The spreadsheet has the following sheets:
Profit & Loss - for the entire year
VAT Return – for each VAT quarter
Sales - for each VAT quarter
Purchases - for each VAT quarter
Mileage - for the entire year
You will only need to enter information into the ‘Sales’ and ‘Purchases’ sheets of each transaction, along with VAT element. You will also need to record ‘Mileage’ if you use your private vehicle within the company. The ‘Profit & Loss’ sheet updates automatically, without you needing to enter anything into it.
When you receive your version of the simple spreadsheet, you will need to work out your VAT quarters. You then simply enter the transaction for each quarter (3 monthly period) into the correct tab on the spreadsheet. E.g. If you have a VAT quarter starting from the 1st April, enter the sales and purchases from the 1st April until the 30th June into the Sales Q1 and Purchases Q1 tabs on the spreadsheet. From the 1st July, you will then enter the information into the Sales Q2 and Purchases Q2 tabs, etc.
Please check our ‘How Simple It Is’ page for a demo, and you’ll see straight away how simple it really is!
Our simple book-keeping spreadsheet doesn't need any expensive software to run, it simply runs on Google Docs, which is free, and can be accessed as long as you have an internet connection. We simply send you an email with the link, and you can start recording your sales and purchases from there.
Can't wait to get started on your book keeping?
Purchase your spreadsheet for just £40 per year, by clicking the 'Buy Now' button, and it will take you straight through to PayPal: