To help you with your bookkeeping, we have disigned some basic templates for you to use in Excel.
There are three main areas:
- Bank statements
- Sales list
- Out of pocket expenses
Please feel free to tailor the the templates to your own needs.
They are only suitable for small businesses with simple affairs. If you need a more sophisicated solution, we can advise accordingly.
To download the Excel file you need, click on the link below.
Bank statements
To record bank statement transactions from a business bank account, use one of the forms below depending on whether you are VAT registered on not. We have included an example of each to help you on your way. If you are not sure give us a call.
Please note that if you use Internet Banking, it may be quicker and easier to analyse bank statements downloaded in .CSV format from your bank's website.
Bank_transactions_-_VAT registered.xls
Bank_transactions_-_Not_VAT registered.xls
Example_-_Bank_transactions_-_VAT registered.xls
Example_-_Bank_transactions_- Not_VAT registered.xls
Sales List
To record your sales, use one of the forms below depending on whether you are VAT registered on not. We have included an example of each to help you on your way. If you are not sure give us a call.
Sales_list_-_VAT_registered.xls
Sales_list_-_Not_VAT_registered.xls
Examples:
Example_-_Sales_list_-_VAT_registered.xls
Example_-_Sales_list_-_not_VAT_registered.xls
Out of pocket expenses
To record out of pocket expenses, use one of the forms below depending on whether you are VAT registered on not. We have included an example of each to help you on your way. If you are not sure give us a call.
Expense_claim_-_VAT_registered.xls
Expense_claim_-_Not_VAT_registered.xls
Expense_claim_-_VAT_registered_-_annual.xls
Expense_claim_-_No_VAT_-_annual.xls
Examples
Example_-_Expense_claim_-_VAT_registered.xls
Example_-_Expense_claim_-_Not_VAT_registered.xls