Free Excel Bookkeeping Templates for Small Business

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 business transactions for limited companies, self-employed individuals, self-assessment, and personal use.

If you require assistance with any of our free accounting spreadsheets or cannot locate what you need, please don’t hesitate to contact us. We may be able to design a bespoke spreadsheet just for you.

Our Free Excel Bookkeeping templates have 320,000+ downloads and are used by many small businesses, non-profits and charities. 

Advantages and Disadvantages of Excel Accounting Templates

Our free Excel bookkeeping templates are an excellent place to start with your business finances, but when your business grows, they can hold you back. This is where accounting software comes in, offering a double-entry bookkeeping solution that streamlines operations, saving time and money.

Some of the best bookkeeping packages worth looking into are Xero, QuickBooks and Sage.

Xero – 90% Discount for 6 Months

Xero simplifies your business finances with easy invoicing, expense tracking, payroll, bank reconciliation, and financial reporting in one secure cloud-based platform.
Visit XERO

QuickBooks – 90% Discount for 7 Months

Simple, smart accounting software for invoicing, payroll, inventory, expense tracking and producing financial reports, accessible anytime, anywhere.
Visit QuickBooks

Here are our Excel accounting templates:

Our Top Free Excel Bookkeeping Template – The Cash Book

Our top bookkeeping template is the cash book, as it makes tracking income and expenses for small businesses and charities easy. It will produce the figures needed for an Income statement (Profit and Loss). Many people have praised us for its ease of use.

Why you’ll love it:

• Focus on what matters: Track your actual cash flow – income received directly and expenses paid out – without complex accounting.
• Quick and easy setup: Start recording your cash transactions immediately; no bookkeeping experience is needed.
• Tax-time ready: Get the figures you need for Inland Revenue returns without the hassle.
• Adaptable to your needs: Customise the template with your income and expense codes.
• Multiple accounts? No problem: Create separate spreadsheets for each bank account or credit card.

There are 3 different Excel bookkeeping templates depending on the business setup and needs, including standard, extended (more categories and rows) and self-employed, which runs from April.

1. Accounts Payable Statement Template

The first Excel Bookkeeping template helps you manage your supplier payments easily using our Accounts Payable Excel template. Track outstanding invoices, see overdue amounts at a glance, and avoid late fees.

Sort the data by due date or supplier to prioritise payments. A handy comments section lets you note important details. Ideal for small business owners.

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

This 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 is essential for identifying discrepancies between accounting software records and bank statements.

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.

It is 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. You will see the differences between your budget and actual figures by entering your bank transactions.

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

Although we have already listed the cash book template as our top download, we wanted to ensure you hadn’t missed it.

Manage your finances effortlessly with our Excel-based Cash Book template. Track income and expenses easily for personal, small business, and non-profit use.

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 expense descriptions can be changed to suit the business. Three templates are 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 valuable 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.

Please read our guide with a template in both Excel and PDF.

12. Home Office Expenses

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

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

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 track your business mileage? Our simple mileage log allows you to use a PDF version or download an Excel Template.

All mileage can be reclaimed as an employee or business owner. Please read our guide to learn more 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 expenditures over time, and the balance is automatically calculated.

It is designed to save you time calculating the figures. Then, you can 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, also known as an income and expenditure report, is one of the financial statements all businesses require at year-end to show profits or losses.

18. Purchase Order

businesses that operate stock systems often need to generate supplier purchase orders. These purchase orders are official confirmations of 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 helps small businesses 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 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. The totals are calculated automatically to prevent mistakes.

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

We also have an invoice list, which allows you to have a complete list of all invoices, record when paid and show any outstanding invoices.

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 form for the customer to complete 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. This will make it easier to calculate the amount to invoice clients.

26. Trial Balance Template

A trial balance is a valuable tool for checking 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 using Excel Bookkeeping templates and require an alternative to Microsoft Office, we recommend Apache Open Office. It is free to download and use, and most features are similar to Microsoft’s. Another option is to use Google Sheets.

Look at our basic Excel formulas to create your own Excel bookkeeping spreadsheets. Many tutorials are also available online and on YouTube.

Conclusion for Free Excel Bookkeeping Templates

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

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

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

If you are unsure about bookkeeping tasks, we suggest hiring a bookkeeper or accountant. They have experience setting up a bookkeeping system and can advise on tax.