Free Excel Bookkeeping Templates

Our Free Excel Bookkeeping Templates are great for managing basic bookkeeping and accounting tasks using Microsoft. They are available to download for business or personal use. The most popular template is the Cash Book, suitable for recording your business transactions for Limited companies, self-employed and self-assessment.

We have designed 25 Excel free accounting templates to help small business owners manage their own bookkeeping, including petty cash, cash book, business expenses, cash flow, sales invoice, statements, income statement and balance sheet. They are simple and easy to use, with full instructions available.

Drop us a message if you need help with any of our free accounting spreadsheets or can not find what you are looking for. We may be able to create one for you.

Our templates have 300,000+ downloads and are used by many small businesses, non-profits and charities. 

Advantages and Disadvantages of Excel Accounting Templates

Small Business Accounting Software

Using Excel for basic bookkeeping can be feasible, but it often lacks the capabilities for small business owners regarding reporting. Accounting software provides a comprehensive solution simplifies all processes, saving time and cost.

Most available software is user-friendly, equipped with detailed instructions, and seamlessly integrates with other applications. As a result, the accounting process is significantly improved and offers a solution for double entry bookkeeping.

Some of the best bookkeeping packages worth looking into are FreshBooks, Xero or QuickBooks.

Read our guide on the best accounting software, including the pros and cons of each. 

Here are our Excel accounting templates:

1. Accounts Payable Statement Template

The first Excel Bookkeeping template is Accounts Payable; it 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 helpful if you have a query on an invoice.

2. Accounts Receivable Excel Accounting Template

The Accounts Receivable statement template allows you to list all your sales invoices issued to customers. It will calculate when an invoice is due and how many days are overdue.

The comments section makes it easy to see the status of an invoice. The data can be sorted by customer or date.

3. Balance Sheet Accounting

A simple Microsoft Excel spreadsheet to help you prepare a balance sheet. It shows the assets, liabilities and equity at any given time.

A balance sheet is one of the financial statements and is a legal requirement for submitting your accounts if you run a limited company. Our balance sheet template helps look at financial ratios to see how the business performs.

4. Bank Reconciliation Worksheet

A bank reconciliation worksheet compares the bank’s position to the accounts to find any differences.

There can be timing differences between when a transaction occurs and what is shown on the bank statement.

Our bank reconciliation allows you to record the differences and balance the accounts on the bank statement.

5. Budget Worksheet Excel Template

The Excel budget worksheet lets you set a budget and track annual spending.

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 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.

6. Business Expense Template

Most business expenditures can be claimed back, even if you are self-employed. There are two Excel bookkeeping templates for business expenses, one for VAT and one for non-VAT. All the calculations are completed for you once the figures are posted.

The rules for claiming business expenses can be complicated, so we have a guide explaining what you can claim.

7. Cash Book Template

Our Cash Book template (income and expenses) is a simple Excel bookkeeping template, a single-entry system designed to handle small businesses and charity needs. It has been developed for ease of use but still allows a company to adapt 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, recording business transactions and producing your annual figures in an income statement. You can record the income and expenditure transactions by date for each month on a separate sheet.

The totals page will show if the business has made a profit or loss for the year by displaying all the income and expenses.

You will need a spreadsheet for each if you have multiple bank accounts or a credit card.

Our cash book is excellent for Excel bookkeeping and is suitable as a small charity accounts template.

8. Cash Flow Forecast Template

The Cash Flow Forecast will enable you to set a forecast for a year. Knowing how much money you may have in a few months helps with your accounting and business planning.

The Excel accounting template will show the predicted money available. The income and expenses descriptions can be changed to suit the business. There are three templates available by month, week or day.

9. Cash Flow Statement

The cash flow statement illustrates the inflows and outflows of cash within a business, playing a pivotal role in the financial reports. It gives you some really useful insights into where the money has come from and how it’s being spent.

10. Credit Note Template

There may be times when you need to issue a refund to a customer. There are various reasons for raising them, including the return of goods and query on the invoice.

Our Excel credit note accounting template will help you to produce a professional document.

11. Delivery Note

When delivering goods to a customer, a delivery note is required. It is not a legal document.

Read our guide with a template in both Excel and PDF.

12. Home Office Expenses

If you work from home, there are expenses that you can claim. Read the complete guide on what you can claim. They include mortgage, rent, council tax, broadband, insurance and utilities.

To help calculate the figures, there is a simplified calculator and a home expenses Excel bookkeeping template.

13. Job Estimate

As a business, you might provide job estimates for your services to potential customers. Creating a professional-looking work estimate and giving it to the client promptly is essential.

Learn about producing a job estimate using our free spreadsheet.

14. Journal Spreadsheet

If you need to adjust the figures in the accounts, a journal is required. 

A journal is a simple form to move a transaction from one code to another.

15. Mileage Log Template

Do you need to keep track of your business mileage? Our simple mileage log allows you to either keep a PDF version or download an Excel Template.

All mileage can be reclaimed. Please read our guide to find out further information about business expenses.

16. Petty Cash Account Spreadsheet

Our accounts spreadsheet is a log to assist in managing your petty cash transactions. You can record all income and expenditure over time. The balance is automatically calculated.

It is designed to save you time calculating the figures. You can then post the totals to your accounting system.

17. Profit and Loss Statement or Income Statement Template

The Profit and Loss statement or Income Statement Excel accounting template allows you to add a year’s figures onto one page. It is helpful to see differences between income and expense figures over the year.

A P&L report is one of the financial statements all businesses require at year-end to show profits or losses. It is also known as an Income and Expenditure report.

18. Purchase Order

businesses that operate stock systems often find themselves in need of generating supplier purchase orders. These purchase orders serve as official confirmations for the goods, quantity, delivery date, and price, ensuring efficient and transparent transactions.

Our easy-to-use Purchase Order template will automatically calculate total figures for you. We have also created a purchase order log to record all the orders.

19. Rent Receipt Template

Keeping a rent receipt is crucial for accurately documenting payment transactions if you are a landlord or tenant. It serves as a vital record to ensure financial clarity and accountability.

We have produced an Excel rent receipt, letter and log to help keep track of payments over time.

20. Sales Forecast

The sales forecast Excel bookkeeping template is helpful for small businesses to track their sales figures and make necessary adjustments.

The free template offered on this website is easy to use and can be customised to include your own products or services.

By entering actual monthly sales income, you can compare your projected sales with reality and adjust your forecasting methods as needed. 

21. Sales Invoice and Proforma Invoice

Our sales invoice template is easy to use and looks professional. It can be downloaded and saved with your logo and details, so whenever you want to produce a sales invoice, it is ready with your branding.

Add a full description of the sale, along with quantities and prices. All the totals are calculated automatically to ensure no mistakes.

The proforma invoice is for issuing before the supply of the goods or services.

22. Sales Receipt Template

The sales receipt template is ideal if you attend fairs and need to issue a receipt to clients for a cash sale. It can be used as proof of purchase and a guarantee for goods or services.

The template can be downloaded in Excel or PDF format to complete by hand.

23. Statement of Account Spreadsheet

The statement of account or customer account template statement is used to remind customers how much they owe.

The statement template can be branded to your 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.

24. T Accounts Template

The T Account template is one of the most popular templates for students to learn about the general ledger entries and visualisation of accounts.

It is easy to use and allows users to input specific values to see how the account would be affected.

25. Timesheet Template

Our timesheet can assist with the process if you need to track employee or contractor hours.  

Record the hours worked and customer details, including order references. It makes it easier to calculate how much to invoice clients.

26. Trial Balance Template

A trial Balance is a useful tool to check the balances of all the accounts on the general ledger.

Our Excel bookkeeping template will assist with the process, along with a guide on completing a trial balance.

Alternatives to Microsoft Excel

If you are not using Microsoft Office, there are alternatives. We recommend Apache Open Office. It is free to download and use; most features are similar to Microsoft. The other option is to use Google Sheets.

Many tutorials are available online and on YouTube if you want to create your own Excel templates.

Conclusion

Free Excel bookkeeping templates are great for starting small businesses on their basic bookkeeping journey.

We offer a wide range of templates, with support if required. Excel spreadsheets are a great way to start recording your business bookkeeping. Our top bookkeeping spreadsheet UK is the cash book, with over 18,000 downloads.

Once your business grows, it is worth looking into alternative options for a double entry bookkeeping system.

If you are unsure of bookkeeping tasks, we suggest using a bookkeeper or accountant. They have experience in setting up a bookkeeping system and will advise on tax.