Here is a rundown of how my free Adsense Excel spreadsheet works and can help you to keep track of your Adsense earnings with Excel.
If you haven’t already, download the basic Excel spreadsheet that you can use to keep track of your own Adsense earnings.
I have the spreadsheet starting you out with December 09. Each day of the week has a different color. First of all in looking at the spreadsheet, you’ll see that Column B has the days of the week beginning with Monday. Column C has the days of the month. Row 5 has the time of the day. 4am, 5am, 6am, etc. So if you first log into check your Adsense account at 7am and you have 20.08 you would type in 10.08 in Column F8. Each time you log in you write in your earnings underneath the correct time.
Column AB has the total earnings for the day. You would input this figure on the next day. For example you would input the earnings for December 1, 2009 on December 2,2009. I believe the earnings are updated around 2:00 in the morning but it will depend on your time zone. You might as well just wait until the next day.
You would continue to follow this simple process each day of the month, entering your daily earnings. The spreadsheet has the sheets already made for December 2009 through March 2010. To make additional sheets for upcoming months, just copy one of the worksheets from the previous months and add the days that mark April 1 through 30. Delete your earnings from the new spreadsheet and that’s it!
Content © 2009 Hoover Web Design http://www.hooverwebdesign.com
Leave a Reply
Note, all comments are moderated. If you do not see your comment, please be patient as the admin has to approve it before it is posted on this website. Spam comments are not posted. Thank you.
Hoover Web Design.
You must be logged in to post a comment.