This cash book in Excel template is useful for small businesses to start their bookkeeping when on a tight budget and unable to pay the monthly subscription costs for online bookkeeping software or the upfront outlay of hundreds for desktop software.
In this Cashbook you can:
This Cashbook also has a Balance Sheet so you can track assets and liabilities including:
There are two versions of the cash book.
The first one is for one bank account only.
The second one is for up to five bank accounts and three credit cards.
US$7.99
One-time payment
Please check my Refund Policy.
What you get with your purchase:
1 x Excel Template for 1 Bank Account
1 x e-Book - Help Guide
Both items can be downloaded to your device.
US$11.99
One -time payment
Please check my Refund Policy.
What you get with your purchase:
1 x Excel Template for up to 5 Banks and 3 Credit Cards
1 x e-Book - Help Guide
Both items can be downloaded to your device.
Requirements on your device:
Try the sample version for free*.
You can enter data for two months and if you love it, buy* the unlock key so you can keep using the same workbook.
*Note: Don't use the sample version with Excel Online unless you have the desktop version of Excel or Microsoft365 because the sample version cannot be unlocked from Excel Online.
Note: More accounts cannot be added to the reports in this sample.
The Quick Start Tips gives you a summary of what to do first.
The main first things are to enter your financial year and months and your account names.
There are 12 monthly sheets where you will enter your transactions for each month.
The totals from these sheets are linked to the reports so they update automatically.
The Examples page has data in it that will help you see how to enter your income and expenses and other type of transactions.
Here are snips of the Profit and Loss Report and Balance Sheet Report.
The Inventory in this cash book in Excel is based on the Periodic method of tracking stock, so it will calculate your Cost of Goods Sold automatically, so long as you can enter your closing stock balances at the end of each month, or just do it once a year.
Note: to actually track the purchase, sale and levels of each stock item you will need to use a separate template such as my Excel Inventory template.
There is a Help page in this cash book template with more in depth instructions on everything including how to add more accounts or hide excess accounts, and how to process the Petty cash transactions and the Inventory procedures. However, when you purchase this template you will also get the free printable e-book of these help instructions.
If you are looking for a simpler/smaller version of the cashbook you can try my free Excel Cashbook Easy. It's simple because it has no balance sheet or balance sheet type accounts.
Home > Excel Bookkeeping Templates > Cash Book Excel
Facebook Comments
Leave me a comment in the box below.