5 Types of Cash Book Templates with predefined formulas to help you record routine cash transactions of a company regularly.
Enter the transaction on the debit or credit side and it will automatically calculate the cash on hand for you.
These templates can be helpful for accounting professionals like accountants, accounts assistants, small business owners, etc.
What is a Cash Book?
Cash Book is the record of cash transaction done in a company on a day to day or regular basis. Cash Book is just like a ledger account. There is no need to open a separate cash account in the ledger.
It is a subsidiary ledger which records all kind cash receipts and cash payments including the bank deposits and withdrawals. At the end of the month, these transactions from cash book are posted to the general ledger.
The best-known 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. You can use our Bank Reconciliation Statement Excel Template for this purpose.
In big companies where there are high volumes of cash transactions, the cash book is subdivided into two different journals. One is the receipt Journal and the other is the disbursement journal.
In a smaller business as there are fewer transactions, all the cash transactions are maintained in a single cash book.
The records fed in the cash book are always in chronological order. This helps us to easily reconcile the cash balances when required.
All the received cash is posted on the debit side and all payments and expenses are posted on the credit side of the cash book.
Types of Cash Book
There are 4 types of Cash Book.
Simple Cash Book
Simple cash book is a document which records inward and outward cash transaction of a business without any discounts or tax. It consists of 2 sides; debit and credit.
Cash Book With Discounts
Some businesses have to provide discounts during their cash transactions. Thus, these type of businesses maintains Cash Book with Discounts. It consists of an additional column for discounts received or paid. Some
Cash Book With Tax
Similar to the simple cash book, it also consists of a debit and credit side along with an extra column for tax. This can be either GST (Goods and Service Tax) or VAT (Value Added Tax). If there is any other tax applicable in your area, you can insert it according to your needs.
Cash Book With Discounts and Tax
Cash Book with Discounts and VAT is for those whose daily cash transactions include giving/taking of discounts and also collecting or paying taxes. This type of book consists of additional columns for Discounts and Tax.
Cash Book Excel Templates
We have created ready-to-use excel templates with predefined formulas for each type of Cash Book. Let us understand the content o each template in detail.
Simple Cash Book Excel Template
We have created a ready-to-use Simple Cash Book Excel Template which helps you to easily record and reconcile your cash transactions.
Contents of Simple Cash Book Excel Template
The first row is for the company name and second for the title of the template. The Cash on Hand balance amount is displayed on the right-hand side.
The formula applied here is the total of Debit/Inward – the total of Credit/Outward; =(C21-F21).
There are 2 sides Debit and Credit. Both sides consist of 3 columns each: Date, Particulars and Amount.
To record a transaction, insert date, Particular, Amounts on Debit/Inward or Credit/Outward side.
In the end, the total of the amount column for both; Debit and Credit side is given using the SUM Function.
Cash Book With Discount Excel Template
We have created a ready-to-use Cash Book With Discount Excel Template which helps you chronologically easily record and reconcile cash transactions with discount.
Contents of Cash Book With Discount Excel Template
It consists of 3 sections:
- Header Section
- Summary Section
- Data Entry Section
Header section consists of Company name, template title, and logo.
Enter the opening balance manually. The summary section consists of a summary of the total transactions. It will display the opening balance, current income after deducting discounts, current expenditure amount after the discounts.
It will also display the amounts of discounts received and discounts given on total transactions.
Data entry section has 2 sides, debit, and credit. Both the sides consist of the following 5 columns:
The last line consists of totals of the amount and a discount column for ready reference. These amounts also reflect in the summary section.
Cash Book With Tax (VAT/GST) Excel Template
We have created a ready-to-use Cash Book with VAT calculations. With this Cash Book Template, you can efficiently and easily record the daily transactions with VAT. Furthermore, it generates transaction wise and tax percentage-wise report in few clicks.
A value-added tax (VAT) is a type of general consumption tax that is collected incrementally, based on the value-added, at each stage of production. In some countries, it is known as goods and services tax.
The VAT is ultimately paid by the end consumer. Dealers collect VAT on their sales, retain the tax paid on their purchases. Thus, the difference between the VAT received and VAT paid is calculated. The balance of VAT is paid to the Government.
Content of Cash Book Template With Tax Excel Template
This template consists of two sections:
- Header Section and
- Data Input Section
In the Header section, the first row consists of Heading of Book Cash Book (VAT) and the second-row consists the Current month.
The summary includes Opening Balance, Income, Expenditures, Current Balance, VAT received, VAT Paid and the difference of VAT. Thus, all the above computations are linked to the cell showing totals of the respective head in the table.
This section has 2 parts; incomes and expenditures. Both have same columns with similar headings and formulas.
It contains serial number, date, item, VAT %, VAT Amount, Net Amount and Gross Amount. You need input date, item, VAT % and the Gross amount paid or received. VAT Amount and Net Paid or received is calculated automatically.
Note: The formula applied for Net Amount is =Table2[[#This Row],[Gross]]*100/104. The simple unitary method of Mathematics is applied.
If you change the VAT % then u need to change the last part of the formula. Last part of the formula is (100+Vat %). So if your VAT % is 5 or 7 then the last number changes from 104 to 105 or 107 respectively.
All the subheadings in the data input section are created with a table. Thus, it allows you to generate a VAT % wise, date wise, etc query/report as required.
You need to simply click on the drop-down button in a subheading and select the criteria of the report.
Cash Book With Discount and Tax Excel Template
We have created a ready-to-use Cash Book With Discount and Tax which helps you to record your inward and outward transaction with discount and taxes.
Contents of Cash Book With Discount and Tax Excel Template
Similar to Cash Book with Discount Excel Template, this template also consists of 3 sections:
- Data Entry
The header section consists of the company name, logo, and title of the template.
Similar to Cash Book With Discounts, you need to enter the opening balance manually. This section consists of the totals of the following amounts:
Current Cash Balance
The data entry section consists of the 2 main sections; Income and Expenditure. Both section consist of the following columns for entering transactions:
Lastly, a columnar total of each head is given in the last row.
We thank our readers for liking, sharing and following us on different social media platforms.
If you have any queries please share in the comment section below. We will be more than happy to assist you.