Excel Bookkeeping Templates – Cash Book
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.
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.
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.
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.