Free Template To Track Earnings From Apps!


I want to share a template a made that I used to track my earnings from apps. I am far from a pro as I've read people actually make hundreds of dollars a month on these things while I bust my ass to break $100. I originally made this template as I was wondering if my time was being wasted on these apps. It honestly felt nice to see the solid numbers and a breakdown of everything. Without further ado here is the template:


*Select Make A Copy so you can be able to input any data.

As a quickie refresher here are what the columns mean:

A= Date of your payout redemption 
B= App you redeemed from
C= Gift card amount in US dollars
D= PayPal or Amazon gift card you chose
E= Date you received the payout

The template is blank but all very self explanatory. The first page with the graph YOU LEAVE BLANK! That is because I input formulas that will eventually carry over to show in the graph as well as the totals.

For January, February, March and so on is where you input everything. The first column is the date and you should easily just click/tap and a date should pop up to select. So there is no need to type an actual date.

In the B column there should be a drop down menu to select the app of your choosing. If you would like to customize the list to your own like then on Desktop or Tablet select the entire B column and select Data Validation but make sure it says to apply to range: 

(Month)!B3:B20
 

Customize the drop down menu tabs from there. Same applies to the rest of the columns.

Lastly, the E column is where you select the date you received your payout. May be confusing so feel free to change and move things around that makes it easier for you. 

Final note is that the entire 2 Row already has a formula to calculate the totals for PayPal only and Amazon only. Very nifty, huh? You'll see when you enter your amounts and pick one from the dropdown menu. Not only will it calculate from the sheet but the data will also translate to the Profit tab (the first sheet) in not only the monthly totals but the graph and the yearly totals below it. Super neat, huh? 

Click File-》》Make A Copy to save it and input yours as needed.

ENJOY!

Popular posts from this blog

Testing: Cashwalk App - How Long Does It Take to Redeem? (Concluded)

October Hair Growth Update!

November Hair Growth *New Ugly Snip* *Nail Growth Pics!!!