A project timeline chart is created in Excel using charts linked to data tables, so …
Download Cash Book Excel Template
Design your own Excel ribbon buttons in minutes. So, Create actions for these buttons and …
Our Menstrual Cycle Calendar and Period Tracker can help you anticipate your next period will …
Enter the transaction on the debit or credit side and it will automatically calculate the cash in hand for you. These cash book can be helpful for accounting professionals like accountants, accounts assistants, small business owners and others.
It 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 month, the accountant posts these transactions to the general ledger.
The practice of business is to weekly compare the bank related transaction with the bank statement or perform a bank reconciliation to avoid mismatch of balances.
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.
Record all the receipts cash on the debit side and all payments and expenses on the credit side.
Simple Cash Book
- 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
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.
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.
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.
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.
Cash Book Templates
We have created this ready-to-use excel templates with predefined formulas for each type of Book.
We have created a ready-to-use Simple Template which helps you to easily record and reconcile your cash transactions.
Download Cash Book Excel Template
To use this free Excel Template, you should have Microsoft Office/ Microsoft Excel. You can only use this template if you have these applications in your system. or Use, Google Sheets.
After installing Excel or Spreadsheet, download the xlsx file of this template to use it
Once extracted, you can open the file using Excel and start entering data or customizing the template.
Click The Button Below To Download Cash Book Excel Template
All Excel templates and tools are sole property of xlsxtemplates.com. User can only download and use the excel templates for their Personal use only. All templates provided by XLSX templates are free and no payment is asked. However, you are not allowed to distribute or share in any other website for sole purpose of generating revenue from it.
Popular Excel Templates: