Cash Builder
BuSo Pro
- Joined
- Jan 14, 2017
- Messages
- 456
- Likes
- 608
- Degree
- 2
What is the correct way to track earnings for affiliate sites? Is there a correct way, or is it just preference? A lot of affiliate networks, including Amazon, pay out the earnings after 2 months. Do you add revenue to your profit/loss statement when you earn it, or when it comes into your bank account?
Here is my current setup:
I have a P/L sheet for all individual sites. I put the revenue that I actually earned that month into it, the earnings that I can pull from the affiliate network reports for that month.
I also have a P/L sheet for my business as a whole. In this, I put the earnings as money that came into my bank account that month. This could be Amazon earnings from 2 months ago, and Ezoic earnings from 1 month ago.
I don't really see any other way I can track this. The first way allows me to calculate my KPIs for the month, while the second way allows me to see what cashflow I have for the month. Is there a better way to do this? It's confusing the hell out of me each month as the numbers obviously don't add up between the statements.
Here is my current setup:
I have a P/L sheet for all individual sites. I put the revenue that I actually earned that month into it, the earnings that I can pull from the affiliate network reports for that month.
I also have a P/L sheet for my business as a whole. In this, I put the earnings as money that came into my bank account that month. This could be Amazon earnings from 2 months ago, and Ezoic earnings from 1 month ago.
I don't really see any other way I can track this. The first way allows me to calculate my KPIs for the month, while the second way allows me to see what cashflow I have for the month. Is there a better way to do this? It's confusing the hell out of me each month as the numbers obviously don't add up between the statements.