Earnings Tracking Spreadsheet [Free Download]
Earnings Tracking Spreadsheet (Link)
Hey all! I finally have the earnings tracking spreadsheet ready that I promised. This was made based on what I wanted in a spreadsheet, but you might want to make some edits based on what fits you best! Let me explain some of the functionality.
Entering Your Earnings: The earnings log where is you enter your earnings. You add the date, amount, site, and reward type. You can do this when you receive the payment, or when you earn the points. It’s totally up to your personal preference.
When You Use a Brand New Site / Reward Type: When you use a site or reward type that you haven’t recorded yet that in month, you are going to want to add them to the list under “Totals by Site” and “Totals by Reward Type” respectively. You then can copy this list over to the next month if you are still using that site. You also want to add the new site or reward type to the list on the “Summary” sheet so that you track the total over the whole year. For example, if you put “CrowdTap” in the “Totals by Site” list, it will automatically add to that total every time you put a new CrowdTap entry in the Earnings Log.
Tracking: When a site or reward type is added to the totals list, and then is entered into the earnings log, it will automatically add the amount that you enter to the totals lists, and to the summary page. The summary tracks for the whole year and adds all the months up.
Goal Tracking: You can set a goal each month by entering an amount in the goal box at the top of the sheet. The goal tracking stats track how many days are left in the month, and how much you need to earn a day to hit your goal based on how many days are left in the month. Due to the nature of the function I used, this resets each month so it won’t be accurate after the end of the month that you are in.
End of Month Statistics: These are visible on each month’s sheet. It gives you your average earnings per day, highest earning program, and difference from last month (doesn’t work in Jan.) for each month. You can add your own stats to track here if you want. You can also look at the graphs to see the breakdown of your earnings.
Summary Page: This gives you all of your earnings totaled for each month and by site as well as your overall total earnings. This automatically adds up all the data from all twelve months.
I have left some sample data entered into January on the spreadsheet as an example of how it works. You can remove this data once you start using the sheet. I have attached the Google Sheets link so that you can make a copy but you can also download the sheet in Excel. You can do this by going to "file" in the menu, and then either "download as" or "make a copy". Hope this is helpful! If you have any suggestions that I can add let me know! Give my profile a follow for more beermoney related stuff! :) Have a good one!
[link] [comments]
source https://www.reddit.com/r/beermoney/comments/cgbzfk/earnings_tracking_spreadsheet_free_download/
No comments:
Add Comment