Multi Tier Commission Spreadsheet

I am seeking assistance in creating a multi-tier/level commission spreadsheet for my client base that will easily track referral commission going down 3 levels. This sheet must be able to easily track monthy rewards based on pre-existing criteria (must have active memberships). My management system creates a variety of reports that can be extracted into a CSV file. Each client has a unique ID number. Example: Client 1 refers a client 2; Client 1 receives a tier 1 reward Client 2 refers client 3; Client 2 receives tier 1 reward, Client 1 receives tier 2 reward Client 3 refers client 4; Client 3 receives tier 1 reward, Client 2 receives tier 2 reward, Client 1 receives tier 3 reward. Tier 3 reward would be the final level down but unlimited width.