In some recent training I did I showed the participants a template I had created to allow a small business to track their expenditure. If I am really honest I’d actually recommend that if you are self-employed or running a business – a better investment would be to learn how to use an actual accounting package. I use QuickBooks because it allows me to easily generate reports etc. However if you don’t have that many transactions and don’t want to invest in an accounting package, this might help. I also want to give a shout out to my pal Colin Foster AKA The Office TimeLord (and he’s an accountant) about the bank statement tip
There are a few moving parts to this so I’m breaking it down over a number of weeks..
In this first video I’m showing you how to set up the basic structure – that includes formulas that calculate your VAT payments. You do need to know how to create dropdown lists but once you have those set up – feel free to use this template for your own purposes. Here is the one with the data I was using and here is one with all the data removed (except the lists – change those yourself in the Lists sheet)