Share on facebook
Share on Facebook
Share on twitter
Share on Twitter
Share on linkedin
Share on LinkedIn
Share on pinterest
Share on Pinterest

Income & Expense Tracker

It’s that time of year again, time to fill in your tax return

And now you realise that all those receipts and documents, that you’ve been promising yourself you’d sort out all year, are still in a carrier bag, still in your “in” tray, or screwed up at the bottom of your bag.

You’re going to need to put them in to some kind of organisation so you can pull out the right numbers.



Well I have a system for that, and of course it’s a spreadsheet! ⭐


It’s the same one I use when I help my clients but of course I can’t prepare everyone’s tax return for them. So I’m making it available to you, because I know it will save you loads of time compared to setting everything up from scratch.

You can be sure that the formulas are correct and that once you’ve given each expense a category your numbers are ready to use.

If your accounting needs are quite simple – and you want to make the job of organising your invoices and receipts in to a profit and loss statement, and having the right numbers for the right boxes on the self-employment tax return, super duper easy – then you need to have a copy!


This is a simple, one year, business income and expenditure tracker for freelancers and sole traders, under the VAT threshold, and using the financial year as an accounting year. You can track your numbers, produce a profit and loss statement and have the figures ready for your annual self-assessment tax return.

If your annual business turnover is less than the VAT threshold for the tax year then when completing your self-assessment tax return you can use the supplementary form SA103S(short) to record self-employment income on your SA100 tax return.


The spreadsheet will work on the desktop version of Microsoft Excel on both a Windows PC and a Mac


Match your expenses with HMRC categories

This spreadsheet uses the identical categories that HMRC use on form SA103S, to make it simple for you to complete.

At the same time I know you might want to analyse your own expense categories in a little more details. So, in the setup you’ll create a list of all the categories, or expense accounts, you’d like to track in your own business and then, using a dropdown list, you’ll assign the overall HMRC category that you’d like to roll them up in to.




Add your Income

Your income is added on one screen and categorised using a dropdown.




Add your expenditure

Your expenses are added on the next screen. I find it beneficial to download a transactions file from your bank and copy and paste those in here. You can then go through your receipts and either match them to a bank statement line, or add on a new line as a cash transaction.

You’ll then give each line its HMRC expense category. Sorting by description makes this process really fast as most of us have repeated transactions throughout the year.


spreadsheet to track expenditure



Expenditure Analysis

See the breakdown for your own named expenses accounts across the year. This is produced automatically with formulas pulling together the numbers from the data you’ve entered.




Your Profit & Loss is ready

Your Profit and Loss statement is now ready, all picked up from your categorisation when you entered your data.

And it’s also clear which number should be written in which box on the SA103S form.



Your tax return has never been done so quickly, and your records have been accurately kept.

And next year you can do it as you go along!

For only £36, Buy now and get on top of your self employment accounts by tonight!