Download Simple Cash Book format in Excel and Spreadsheet for business and personal use. You can simply capture the transactions on the debit (dr.) or credit (cr.) side. This is a simple daily cash book excel format.
The template automatically computes cash in hand or cash positions. This cash book can be helpful for accounting professionals like accountants, accounts assistants, small business owners and others.
Understanding Cash Book
Cashbook records the cash transactions done in a company on a day to day or regular basis. Moreover, this is like a ledger account. There is no point to open a separate cash account in the ledger.
It is subsidiary ledger that records all kind cash receipts and cash payments including bank deposits and withdrawals. At the end of each day, week or month, the cashier or cash accountant or accountant posts these transactions to the general ledger.
The best practice of any business is to weekly compare the bank related transaction with the bank statement or perform a bank reconciliation to avoid mismatch of balances. This activity can be done on monthly or quarterly basis as well.
- In big companies where there is high volume of transactions, the book is subdivided into two different journals. One is receipt Journal and other is the disbursement journal.
- In a smaller business where there are fewer transactions, such businesses maintain all the cash transactions a single book.
The records fetch in the book are always in chronological order. This helps us to easily reconcile the cash balances as and when required. However, if you are not maintaining a chronological order while capturing the details, this will increase the chance of having errors and mismatches during reconciliation process. Record all the receipts cash on the debit side and all payments and expenses on the credit side.
Key Points for Simple Cash Book Maintenance
- The transactions in chronological order.
- Cash column cannot have a credit balance.
- It is a subsidiary as well as principal book of accounting.
Types of Cash Book templates
There are certain types of cashbooks templates that one should understand before implementing the process of cash book in their business or in client’s business. We have briefly covered the types of cash book below –
1. Cash Book single column
Single Column book is a document which records the inward and outward cash transaction of a business without any discounts or tax. It consists of 2 sides; debit and credit.
2. Double Column with (Discounts)
Some businesses have to provide discounts for their cash transactions. Thus, these type of businesses maintains this with Discounts. It consists of additional column for discounts received or paid.
3. Double Column with Tax
Similar to the simple book, it also consists of a debit and credit side along with one extra column for tax. This can be either GST or VAT.
4. Triple Column (Discounts and Tax)
This book with Discounts and VAT is for those where daily cash transactions include giving/taking of discounts and also collecting or paying taxes. This type of book consists of an additional columns for Discounts and Tax.
Download and use Simple cash book Format in Excel
To use this free Simple cash book format and excel Template, you should have Microsoft Office/ Microsoft Excel installed in your system.
After installing Excel or Spreadsheet, download the zip file of this template, extract the template using WinRAR or 7Zip decompressing software.
Once extracted, you can open the file using Excel and start entering data or customizing the template. You can customize the currency, color scheme, fields in this excel template as per your requirement.