Until recently I have been using a very simple spreadsheet that I plug my daily earnings into and it gave me some metrics to work with.
It was getting a bit unwieldly to work with, and with a years worth of data it would be impossible, so I decided to create a new spreadsheet that had some thought behind it.
My new spreadsheet has a sheet for each month, a monthly graph sheet, and a summary sheet that includes all sorts of useful (at least to me) information. (Earnings by Month, Daily Avg, Monthly Min, Monthly Max, Monthly Earnings by Advertiser, YTD Earnings, YTD Earnings by Advertiser and a YTD Graph.)
It’s not finished yet (I still need to add a few things my other sheet had, like Rolling 7 day income, and US$ or NZ$ view).
So I acutally have two questions?
- Do you have any suggestions for other things that might be useful?
- What do you use, if anything, to track your earnings?
The spreadsheet is for OpenOffice Calc, and if people are interested once it’s finished I’m more than happy to share it.
Blogsphere: TechnoratiFeedsterBloglines
Bookmark: Del.icio.usSpurlFurlSimpyBlinkDigg
RSS feed for comments on this post | TrackBack URI for this post
Best Deal Ads :
I would be interested in taking a look at it. Right now I am just using a couple of different money files, but I haven’t decided if that is the way I am going to go long term or not.
I worked on it again last nite and I almost have it they way I want it, with any luck I should have the last couple of bits finished in the next day or two and then I’ll make it available for people to look at.
That sounds very interesting and I’d love to take a look at it once you’re done. I’ve been wondering myself what a good way to track my earnings would be. About your site - keep up the good work! Your content is well thought out and valuable. Thanks!