Excel Bookkeeping Templates

These free Excel bookkeeping templates can be used by anyone and any small business.

Excel is a fantastic spread sheeting program and if you already have it on your computer, you already have the means to start your bookkeeping.

Most of these excel bookkeeping templates are easy to customize to your requirements.

This means you change the background shading, and the fonts and layouts to get them to look how you like.

Small businesses starting up can take full advantage of Excel until they are in a position to afford bookkeeping software.

 

1. Excel Cash book

Our Most Popular Template

The excel cash book is the simplest and easiest way to start recording and tracking your business income and expenses and bank balance, for your day to day bank accounts.

You can add or delete unwanted columns and delete or insert more rows.

Balances are calculated automatically with built-in formulas so all you have to do is enter how much you earned or spent and the expected bank balance is calculated for you! You can then perform a bank reconciliation within the cashbook to make sure the cashbook reconciles with your bank balance.

This cash book also includes an Income Statement report so you can see if the business is making a profit or a loss each month, and a Balance Sheet report so you can see what your business is worth.

 

Excel Cash Book Template

Excel Bookkeeping Templates – Cash Book

 

2. Expense Form Template

This form is a cash book specifically for tracking income and expenses off a credit card.

 

Expense Form Template

 

3. Accounts Receivable Ledger

Use this spreadsheet to record all the invoices a business issues to a customer who have an account with the business.

You can track customer payments, and keep notes on what a customer says if the business has to call them about overdue payments.

 

Excel Accounts Receivable Ledger

4. Excel Inventory Template

If you buy or make stock items and sell them, you can use this Excel inventory template to keep a track of all items purchased (made) and sold, having a record of the costs and prices, the quantities, the values and so one for each one.

There is an overall Inventory Report which updates automatically so you get to see the totals in one list and immediately see the quantities left in stock, and the overall value of stock on hand.

We also explain how to bring the total value of stock on hand into your bookkeeping software.

 

Excel Inventory Template

 

5. Accounts Payable Ledger

This spreadsheet is a fantastic tool for keeping a record of your purchase invoices due for payment.

You would only need to use this spreadsheet if you have bought goods on account and which you still owe payment to the supplier/vendor.

You would not use this spreadsheet if you paid for your goods at the time of purchase – eg. if you paid with cash or bank card or with some other means.

 

Excel Accounts Payable Ledger

 

Conclusion to Excel Bookkeeping Templates

 

If you are an Excel user, you can try installing the Office Mobile app which allows you to access your documents from your OneDrive or Dropbox or the Microsoft Excel app to your mobile device. It allows you to view and edit and save your Excel documents. Great for when you are out and about.

All of the Excel bookkeeping templates founds on this page can also be opened within OpenOffice.

If you are on this page you probably already own a desktop version of Microsoft Excel or you subscribe to Microsoft 365, but did you know that OpenOffice is completely free?

 

It is an excellent alternative to Excel and also has word processing, presentations, graphics – all the things you can get from Microsoft, but for free! And in many different languages.

Please contact me if you would like to see any other excel bookkeeping templates.