Our Limited Company Accounts, VAT spreadsheet is designed to provide the easiest way to record your transactions for VAT purposes. It records the daily sales and purchases, along with the relevant VAT, in the easiest way for your company.
It 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 meed to enter ‘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, and 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. This 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 limited company accounts?
Get your spreadsheet for just £60 per year, by clicking on the 'Make A Payment' button below, which will take you through to our secure payment page: