Free Excel Bookkeeping Templates for Small Business

Please note that this page contains affiliate links. While we only recommend products that we believe in, we may benefit financially from any purchases you make.

25 FREE Excel templates to download and use for your small business.

Keeping track of your finances is essential for any small business, but it can be time-consuming and confusing if you don’t have any bookkeeping experience. That’s where free Excel bookkeeping templates come in! These templates are pre-formatted spreadsheets that you can use to record your income and expenses, track your mileage, create invoices and other financial tasks.

Free Excel Bookkeeping Templates

We provide a wide variety of free downloadable Excel bookkeeping templates that are perfect for small business owners and self-employed individuals with little to no bookkeeping knowledge. With these templates, you can easily manage your finances and get a better understanding of your business’s financial health.

If you require assistance with any of our free accounting spreadsheets or if you’re unable to 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

Advantages

  • Easy to use and keep company records
  • Free Downloads
  • Already familiar with Excel
  • Add calculations and charts

Disadvantages

  • Will not grow with the business
  • Limited to the number of transactions
  • Easy to make mistakes
  • Not double entry bookkeeping
QuickBooks Banner with discount

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

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

 

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). We have had many people thanking us for the ease of use.

Cash Book Template

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: Easily 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

Free Excel Bookkeeping Templates for Small Business

The first Excel Bookkeeping template helps you to manage your supplier payments with ease 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. There is a handy comments section that lets you note important details. Ideal for small business owners.

2. Accounts Receivable Excel Accounting Template

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

QuickBooks Banner

3. Balance Sheet Accounting

Balance Sheet Template

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

Bank reconciliation template

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.

Free Excel Bookkeeping Templates for Small BusinessFree Excel Bookkeeping Templates for Small Business

5. Budget Worksheet Excel Template

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

Personal or business budget template

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

Expenses Spreadsheet UK Example

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.

Free Excel Bookkeeping Templates for Small Business

7. Cash Book Template

Free Excel Cash Book Template Our free Excel cash book template has been designed to assist your small business with its bookkeeping. It is based on bank account transactions or if you do not have a separate bank account, you can just post all your transactions. It is not suitable to track sales and purchase invoices or if you are VAT registered.

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

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

8. Cash Flow Forecast Template

Free 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

How to read a cash flow statement example

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

10. Credit Note Template

Credit Note exmaple for return of goods

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

Delivery note template example in Excel

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

Calculating home office expenses Excel Template

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

Free job estimate template download

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

Learn about producing a job estimate using our free spreadsheet.

14. Journal Spreadsheet

Journal Form for Accounting

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

Simple 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

Petty Cash Excel Template

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. You can then post the totals to your accounting system.

17. Profit and Loss Statement or Income Statement Template

self employed profit and loss template example

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

Purchase Order Template Example
Purchase Order Template Example

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

Rent Receipt Template Example

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

Sales forecast template

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

Sales Invoice Template UK VAT example

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.

Free Excel Bookkeeping Templates for Small Business

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.

22. Sales Receipt Template

Word 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

statement of account template

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

T-Account PDF free download

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

Excel Timesheet Template Example

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

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

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

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 of bookkeeping tasks, we suggest hiring a bookkeeper or accountant. They have experience setting up a bookkeeping system and can advise on tax.