Track Your Blog or Freelance Income with These Spreadsheets

Whether you’re developing a small alternative income stream through blogging, or running your own freelance business, or something in the middle, you need a way to keep track of it. It’s not like a tidy job that pays you every 2 weeks or so and gives you a handy slip at the end of the year telling you exactly what you earned. If you want to file your taxes properly and if you want to know just how much you earned last month, the ball is in your court.

Click on the images in each section to see a full-size screenshot. And the numbers used are completely pulled out of my head and in no way represent actual clients, earnings, etc. Important note: All downloads are in .zip files because my download plugin doesn’t allow for .xls (spreadsheet extension) at this point.

Blog Income Spreadsheet

The blog income spreadsheet is set up to look and work best for income sources that repeat monthly. That could mean a text-link buyer who paid in advance for 6 months worth of ads on your site. Entering it in the spreadsheet right away also gives you a handy reference as to who has paid for how much of what.

Or every month you can enter your BlogHer or AdsDaq earnings in the proper column.

There isn’t much room for description, but you shouldn’t need it here. Just where the money is coming from and how much it is per month.

The lower “Unpaid But Earned” section is for ads whose payout level you didn’t reach that month (compared with ones whose payout level you reached but who still may not pay you immediately). I only record earnings as earnings when I hit a payout, but I do like to know what I’ve earned anyway. This is useful for AdSense and other ad networks with high payout thresholds.

How you enter the money into the spreadsheet depends on your goals. For tax purposes, it’s probably best to write down when you earned it vs. when you received it. But for your own planning, you may want to keep a separate copy that will help you budget the actual money you receive.

The spreadsheet is set up to automatically add up the numbers you input, near the bottom of the screen. If you need more lines, simply add more lines above the total and it should automatically adjust. Again, you can download it here.

Consulting and Freelance Spreadsheet

As you can see, it has a place for the client’s name, the date, the fee, whether it was invoiced yet, whether or not it was paid, and a short description. It also adds everything into a monthly earnings figure at the bottom of the month’s section. This isn’t as suited to ads, since you’re often running the same ads all year or for half a year. But it’s great for one-time projects and just fine for repeat clients as well.

I think the “Invoiced” and “Paid” sections are critical, particularly if you’re handling several clients at once. This way you know who has paid and who hasn’t. And whether you’ve even sent the bill yet.

You’re welcome, Kacie. One handy thing is that PayPal saves your information for the last year. So I was able to double-check all my transactions recently when I went in to clean up my spreadsheets (I’d been tracking separately and less efficiently, so I knew I needed a new system). Wanted to make sure I didn’t miss anything.

By far one of the best thing I have come across for a while now. I’m not a very organised person when it comes to keeping records but this simple spreadsheet is my answer. How come I haven’t even thougth of it? Strange

Nice start – can I recomend that you create a generic Google Docs or ZOHO account (Zoho is the better of the two IMHO) – and load your spreadsheets there and publish the account username and password “by subscription” via your site, to share with people.

Why do this? Simple, it would be a neat way for you to share the docs, provide a way for people without Excel to gain access to them, as well as provide you with a place we “readers” might also help you continue developing the spreadsheets – I for one would love to help you and fellow readers / bloggers / serial entreprenours out by investing a little time in cleaning them up – making them a little more “pretty” and helping develop them further

Thank you!! I’ve just spent a whole morning trawling the net for a program or a template or SOMETHING that would help me get this stuff in order, but none of them quite met my needs… these are perfect!!

Currently you have JavaScript disabled. In order to post comments, please make sure JavaScript and Cookies are enabled, and reload the page.Click here for instructions on how to enable JavaScript in your browser.

Disclaimer

In accordance with FTC guidelines, we state that we may have a financial relationship with companies mentioned in this website. This may include receiving access to free products and services for product and service reviews and giveaways.

Any references to third party products, rates, or websites are subject to change without notice. We do our best to maintain current information, but due to the rapidly changing environment, some information may have changed since it was published. Please do the appropriate research before participating in any third party offers.

Privacy & Advertising

More Related Sites

Disclaimer

I'm just a girl getting out of debt. Please consult with a competent professional before acting on any advice found on this or any other website.
In accordance with FTC Guidelines: Readers should assume that any posts or articles linking to companies providing products and/or services are affiliate marketing sites that pay commissions to me. Any products or services I review also pay a commission, a fee, or otherwise grant perks as payment. Readers should also assume that any book reviews I conduct on this site were the result of a free book given to me by the publisher. I donâ€™t automatically write a positive review as a result, but the book was probably provided free of charge.
Please take a moment and read the privacy policy.