FREE EXCEL BOOKKEEPING TEMPLATES
Our Free Excel Bookkeeping Templates are great if you want to handle basic bookkeeping tasks using Microsoft. They are available to download for business or personal use. The most popular template is the Cash Book and is suitable for recording your business transactions for Limited companies, self-employed and self-assessment.
While accounting templates will never be as good as full software accounting packages, they are easy to use. Most spreadsheets can be modified for your own needs.
We have designed over 10 Excel business templates. Including petty cash, cash book, business expenses, sales invoice, statements, and balance sheet. They are simple and easy to use with full instructions available.
If you can’t find what you are looking for, drop us a message. We may be able to design one for you.
If you need help with any of our free Excel bookkeeping templates, please contact us.
Advantages of our FREE Excel Bookkeeping Templates
- Easy to use
- Full instructions on the website
- Free to download
- Support available if needed
The Accounts Payable template is excellent for keeping track of purchase (supplier) invoices. It will show the amount outstanding for payment.
The data can be sorted to help keep track of when invoices are due. There is a comments section, which is useful if you have a query on an invoice.
The Accounts Receivable ledger allows you to list all your sales invoices that you have issued to customers. It will calculate when an invoice is due and how many days overdue.
The comments section makes it easy to see the status of an invoice. The data can be sorted by customer or date.
A simple spreadsheet to assist you in the layout of your balance sheet. If you run a limited company, then a balance sheet is a legal requirement for submitting your accounts. Your accountant will produce it for you. Free Excel bookkeeping Templates balance sheet.
Bank Reconciliation Worksheet
A bank reconciliation worksheet is used when you are comparing the bank position to the accounts.
There can be timing differences between when transactions take place in the accounts, and they show on the bank statement.
Our free spreadsheet allows you to record the differences and balance the accounts to the bank statement.
Template Excel Budget Worksheet
The template Excel budget worksheet enables you to set a budget and keep track of spending during the year.
Suitable for either personal or business use. The budget is set on one page and can be adjusted during the year if your circumstances change. By entering your bank transactions, you will then be able to see the differences between your budget and actual figures.
It is a useful Excel bookkeeping template if finances are tight or you want to make some savings.
Business expenses can be claimed back, even if you are self-employed. There two spreadsheets, one for VAT and one non-VAT. All the calculations are completed for you once the figures are posted.
The rules for claiming expenses can be complicated so we have put together a guide explaining what you can claim.
Free Excel Bookkeeping Templates - Cash Book
Our Cash Book Spreadsheet template is designed to handle bookkeeping needs for small businesses and charities. It has been developed for ease of use but still allowing a company to adapt it to their needs.
It helps with your monthly and year-end figures for the Inland Revenue. It is not suitable for recording invoices and VAT but is ideal for taking your bank statement and producing your annual figures.
Small businesses, charities and individuals use our free Excel bookkeeping template.
Cash Flow Forecast Template
The Free Cash Flow Forecast accounts spreadsheet will enable you to set a cash forecast for a year. Knowing how much cash you may have available in a few months, helps you to plan the business.
The Excel template will show the predicted cash available. The income and expenses descriptions can be changed to suit the business.
Mileage Log Template
Do you need to keep track of your business mileage? Our Free simple mileage log allows you to either keep a PDF version or download an Excel Template.
All business mileage can be reclaimed. Read our guide to find out further information about business expenses.
Our free accounts spreadsheet is a log to assist in the management of your petty cash. You can record all the money received and spent over time. The petty cash balance is automatically calculated.
It is designed to save you time calculating the figures. You can then post the totals to your accounting system.
Profit and Loss - Accounts Spreadsheet
The Profit and Loss report allows you to add a whole year's figures onto one page. It is useful to see differences between figures over the year.
A P&L is required by all businesses at year end to show profits or losses. It is also known as an Income and Expenditure report.
Our sales invoice template is easy to use. It can be downloaded and saved with your logo and details, so every time you want to produce a sales invoice, it is ready with your branding.
Add a full description for the sale, along with quantities and price. All the totals are calculated to ensure no mistakes.
Sales Receipt Template
The sales receipt template is ideal if you attend fairs and need to issue a receipt for a cash sale. It can be used as proof of purchase and guarantee for goods or services.
The template can either download as an Excel Spreadsheet or PDF format to complete by hand.
Statement of Account Spreadsheet
The statement of account or customer account template, is used as a reminder to customers how much they owe.
The template can be branded to your own business, by adding a logo and company information. It also includes a remittance to be completed by the customer so you will know which invoices they have paid.
Free Bookkeeping Software
If you are looking for an alternative to Excel accounting templates, there are some free bookkeeping software packages available. Most of the software we have viewed are either complicated, only offer a free trial, or as your business grows, it will not be suitable.
Pandle is a full accounting package on the cloud. It is free of charge for small businesses, but there is also a paid for version. The paid version includes additional features, including automated bank feeds and other sales invoice templates.
A free trial is available to see if it is suitable for your business. It is fully GDPR compliant as per the policy.
Wave Apps is also worth reviewing, but it is not GDPR compliant when it came into force.
There are many websites which offer free Excel bookkeeping templates, or you could design your own. Excel templates can assist you with your accounting records including; balance sheet, forecasting, cash flow, sales invoices and petty cash.
Cloud accounting software - Online accounts software
Cloud accounting software is popular as it allows people to access the accounts from anywhere. There are a few advantages over purchasing a product
- You can access your accounts from anywhere with internet access by using the cloud
- No upfront costs, just a monthly fee
- No space required on your computer for a software package
- You can give other people access to the data. It may be useful for your accountant or bookkeeper
- Most suppliers provide a free trial, so you can try before you buy
Alternatives to Excel
If you do not have Excel, there are alternatives. We recommend Apache Open Office. It is free to download and use; most of the features are similar to Microsoft. Apache is an Open Source software that has been developed by professionals for their use.
Return from Free Excel Bookkeeping Templates page to Business Accounting Basics page.