cash Book Excel Main Details
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.
Cash Book Excel Quick Start Tips
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.
Cashbook Excel Examples
Here are snips of the Profit and Loss Report and Balance Sheet Report.
Cashbook Excel Profit and Loss Overview
Cashbook Excel Balance Sheet Overview
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.
Cash Book Excel Periodic Inventory Screen Shot
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.
Overview of Help Menu