4 ready-to-use Types of Cash Book Templates in Excel, Google Sheets, and Open Office Calc format to 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.
Table of Contents
What is a Cash Book?
Cash Book records of cash transactions 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 that records all kind cash receipts and cash payments including bank deposits and withdrawals. At the end of the month, the accountant posts these transactions 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, such businesses maintain all the cash transactions 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.
Record all the receipts cash on the debit side and all payments and expenses on the credit side of the cash book.
Main Features of a Cash Book
- Cash Book records only Cash & Bank transactions.
- It records transactions in chronological order.
- The cash column cannot have a credit balance.
- It is a subsidiary as well as a principal book of accounting.
Types of Cash Book
There are 4 types of Cash Book.
Single ColumnCash Book
Single Column 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. It is also known as a simple cash book.
Double Column Cash Book (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.
Double Column Cash Book (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.
Triple Column Cash Book (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.
Download Cash Book 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.
Furthermore, all these templates are available in 3 file formats – Excel, Google Sheets, and Open Office Calc. Click on the icon button to download the desired format. The functioning and formulation are the same in all three formats.
Lets us discuss each template in brief.
Simple Cash Book Template
We have created a ready-to-use Simple Cash Book Template which helps you to easily record and reconcile your cash transactions.
Excel Google Sheets Open Office Calc
Click here to Download All Accounting Excel Templates for ₹299.
Important Note: To edit and customize the Google Sheet, save the file on your Google Drive by using the “Make a Copy” option from the File menu.
Contents of Simple Cash Book 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 Template With Discount
We have created a ready-to-use Cash Book With Discount Template which helps you chronologically easily record and reconcile cash transactions with discounts.
Excel Google Sheets Open Office Calc
Contents of Cash Book Template With Discount
It consists of 3 sections:
- Header Section
- Summary Section
- Data Entry Section
The 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.
The data entry section has 2 sides, debit, and credit. Both the sides consist of the following 5 columns:
Date
Item
Amount Received/Paid
Discount Received/Given
Total Amount
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 Template With Tax (VAT/GST/Sales Tax)
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 reports in a few clicks.
Excel Google Sheets Open Office Calc
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 VAT/GST/Sales Tax
This template consists of two sections:
- Header Section and
- Data Input Section
In the Header section, the first row consists of the Heading of Book Cash Book (VAT), and the second-row consists of 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 the same columns with similar headings and formulas.
It contains the 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. The 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 Template With Discount and Tax
We have created a ready-to-use Cash Book With Discount and Tax which helps you to record your inward and outward transaction with discounts and taxes.
Excel Google Sheets Open Office Calc
Contents of Cash Book Template With Discount and Tax
Similar to Cash Book with Discount Template, this template also consists of 3 sections:
- Header
- Summary
- 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:
Income
Expenditure
Current Cash Balance
VAT Received
VAT Paid
Difference
Discount Received
Discount Given
The data entry section consists of the 2 main sections; Income and Expenditure. Both section consist of the following columns for entering transactions:
Date
Item
Receipt/Payment
Discount Received/Paid
Gross Amount
VAT/GST %
VAT/GST Amount
Total Amount
Lastly, a columnar total of each head is given in the last row.
Advantages of A Cash Book
- Maintaining a cash book is a reliable and proven method of recording all cash transactions.
- You can set up the triple column cash books that it identifies the amounts of GST/VAT/Sales tax in separate columns so that you can account for them and report to the respective tax department.
- A properly maintained cash book helps you to keep an eye on your daily cash flow.
- It helps to analyze the breakdown of income and expenses.
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.
Frequently Asked Questions
What is the main cash book?
The main cash book is a type of a general ledger that records all cash transactions during a period are recorded.
Are capital drawings a cash book item?
No, it is not recorded in Cash Book.
Is Cash Book a real account?
Yes, Cash Book is a real account that that records thecashreceipts andcashpayments of a business for the particular accounting year.
What is LF in the cash book?
LF stands for the ledger folio number. Generally, folios are reference numbers for dividing booksinto several parts.
What is a 3 column cash book?
The triplecolumn cash book consists of three amount columns on the debit and credit side of the cash book. It includes cash, discount, and bank amounts.
How is the cash book balance calculated?
Formula to calculate Cash Book Balance is Cash Balance = Opening Balance + Receipts – Withdrawals
FAQs
Does Excel have a cash book template? ›
4 ready-to-use Types of Cash Book Templates in Excel, Google Sheets, and Open Office Calc format to 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.
How do I make a cash book in Excel? ›Receipt Method: create a receipt method as either Cash or the Cheque. In the 'Receipt Method' column, go to the 'Data Ribbon' and click on Data Validation. Then select 'Allow List'. In the source box, type Cash,Cheque and click OK.
How do I download Excel templates? ›- Go to Office.com.
- Click Templates at the top of the page.
- On the Templates page, click Excel. ...
- Click the template you want, click Edit in Browser, sign in if prompted, and then click Continue.
The cash book is used to record every transaction involving cash receipt or cash payment. Any transaction that involves immediate cash or cheque is recorded in the cash column or the bank column of the cash book. 5.2 TYPES OF CASH BOOK.
Where do I find templates in Excel? ›Open Microsoft Excel. On the right side of the Home tab, click More templates. Scroll through the displayed list of templates to find the one that suits your needs. If you don't find one you like, you can use the Search for online templates text field to see if there is a template online for what you need.
What are the 3 types of cash book? ›There are three common types of cash books: single column, double column, and triple column.
How do you make a simple cash book? ›simple cash book||with solved problem||by kauserwise - YouTube
How do you create a cash book? ›- Opening Balance: Put the opening balance (if any) on cash in hand and cash at bank on the debit side in the cash book and bank columns. ...
- Cheque/Check or Cash Received: ...
- Payment By Cheque/Check or Cash: ...
- Contra Entries: ...
- Bank Charges and Bank Interest Allowed: ...
- Solution:
- Noorani Stores.
It is also referred to as a three-column cash book format, and it is a complete form with three columns of money on both receipt and payment sides and records transactions about the cash, bank, and discounts.
How do I download a template? ›How to Download a Template for Microsoft® Word or Adobe Creative ...
How can I download Excel files for free? ›
Using Microsoft Excel and other core Office programs is free via the web, and all you'll need is a Microsoft account. Head over to Office.com and click 'Sign in' to enter your details. If you don't yet have an account, choose 'Sign up for the free version of Office' and follow the instructions.
Where can I find my templates? ›The default templates folder is opened. The folder location (in Windows 7 and later operating systems) is c:\users\username\appdata\roaming\microsoft\templates. If your template is saved in a different folder, click Browse, and then select the template. Select the template, and then click Open.
What is three column cash book PDF? ›A three column cash book, also known as a triple column cash book, contains three money columns on both the debit and credit sides: one on each side for recording discount, cash, and bank amounts.
How many columns are in a cash book? ›The bank cash book has three columns at the debit side and three columns at the credit side, with the headings discount, details, bank.
What are the four types of cash book? ›- Single column cash book.
- Double column cash book.
- Triple column cash book.
- Petty cash book.
Apply template to existing workbook in Excel
Step 1: Open the existing workbook you will apply specific Excel template to. Step 2: Apply the specific Excel template: In Excel 2007 and 2010, click the File > New > My Templates, then in the New dialog box select the specific Excel template and click the OK button.
Open your Excel > File > Options > Save > Your see Default Personal templates location > If this is blank, put a folder path here and place all your personal templates in this folder path. When you open your Excel > File > New > You will have Personal /Shared categories also where your templates will reflect.
How do I open a downloaded template in Excel? ›- Open Excel. ...
- Click "New" on the Office menu. ...
- Look to the "Templates" section on the "New Workbook" menu. ...
- Click one of the Excel template categories to view an Excel template.
An increase in liabilities or shareholders' equity is a credit to the account, notated as "CR." A decrease in liabilities is a debit, notated as "DR." Using the double-entry method, bookkeepers enter each debit and credit in two places on a company's balance sheet.
Who maintain cash book? ›Cash book keeps a record of cash transactions. Passbook is issued by the bank to the account holder that records the deposits and withdrawals. Cash book is prepared by the firms whereas Passbook is written by banks and retained by the customer.
What are the 5 books of accounts? ›
Books of Accounts for Service Business
General journal. General ledger. Cash receipt journal.
A cash book is a document highlighting all the cash receipts and payments transacted by a business within a particular period. This document is divided into two main sections: the debit and credit side. Any transaction involving the receipt of money is recorded on the debit side while payments are credited.
How do you make a cash book column? ›- May 1 Cash in hand $50000.
- May 1 Bank balance $160000.
- May 4 Received a cheque from a customer “A” of $18000.
- May 8 Cash withdrawn from bank for business purpose is $15000.
- May 11 Goods sold for cash $28000.
A cash book, or petty cash log, is a ledger for keeping track of small cash purchases. Some small businesses such as restaurants find cash books especially useful because these companies tend to need small quantities of easily available supplies to make up for unpredictable shortfalls.
Is the template app free? ›Many of the features are free to use, but Template always wants to provide you with the best & freshest template designs. With Template Plus, you get unlimited access to all 850+ Template designs, fonts, & more. You can choose to subscribe monthly or annually.
Are Microsoft templates free? ›You can download free, pre-built document templates with useful and creative themes from Office when you click File > New in your Office app. Templates can include calendars, business cards, letters, cards, brochures, newsletters, resumes, and much more.
How much does Excel cost to download? ›Office 365 Personal: $6.99/month or $69.99/year Office 365 Home: $9.99/month or $99.99/year Office Home & Student 2019: $149.99 one-time Office 365 Business: $8.25/user/month (annual commitment required) Office 365 Business Premium: $12.50/user/month (annual commitment required) Office 365 Business Essentials: $5/month ...
Is there a free online Excel version? ›Use Word, Excel, PowerPoint and more for free with Office on the web.
Can I download Excel to my computer? ›While Microsoft Excel for computers can only be downloaded as part of the Microsoft Office bundle, you can download Excel by itself for free on iPhone and Android platforms. Keep in mind that you must have a Microsoft account in order to buy and use Office 365 on a computer.
Where is the Microsoft templates folder? ›By default, user templates files are stored in the following location: In Windows XP: \Documents and Settings\<user name>\Application Data\Microsoft\Templates. In Windows Vista or Windows 7: \Users\<user name>\AppData\Roaming\Microsoft\Templates.
How do I open a downloaded template? ›
Load templates or add-ins
, and then select Word Options > Add-ins. In the Manage list, select Word Add-ins, and then click Go. Click the Templates tab. Under Global templates and add-ins, select the check box next to the template or add-in that you want to load.
On your computer, go to Google Docs, Sheets, Slides, or Forms. At the top right , click Template Gallery. Click the template you want to use.
How many columns are in three column cash book? ›The triple column cash book has 7 columns on both debit and credit sides. The purpose of each column is briefly explained below: Date: The date column is used to enter the transaction date.
How do you prepare three columnar cash book? ›Triple column cash Book - YouTube
How do you join the three column cash book? ›THE THREE COLUMN CASHBOOK - YouTube
Is double column a cash book? ›A double column cash book, also known as a two column cash book, consists of two columns on each side to record cash and bank transactions. Rather than separating cash and bank accounts, a double column cash book enables accountants to maintain the two accounts side by side.
Is cash book a journal or ledger? ›The cash book is a journal because it records the cash transactions from the source document for the first time and then these are posted in the respective ledger accounts. The cash book is a ledger in the sense that it serves the purpose of a cash account also.
What are golden rules of accounting? ›Take a look at the three main rules of accounting: Debit the receiver and credit the giver. Debit what comes in and credit what goes out. Debit expenses and losses, credit income and gains.
What are the two features of cash book? ›Features of cash book
Act as both journal and ledger − Cash books records transactions as it happens and posts the transactions. Substitution − It serves as an alternative for cash accounts. Dual entry − Cash book has two sides namely, debit side and credit side. Identical − Debit side (total) = credit side (total).
Cash books are important because their proper maintenance and reconciliation with bank statements are fundamental for a business. Some businesses maintain cash books instead of cash receipts journals and cash payments journals. This is because all cash receipts and payments are recorded in a cash book.
What are the two types of cash? ›
Types of Cash and Cash Equivalents
Cash in checking accounts. Cash in savings accounts.
The P&C Cashbook is an excel-based finance system that combines the recording, reconciliation process and financial reporting requirements in one simple excel workbook which allows for increased transparency and compliance.
Can you use Microsoft Excel for bookkeeping? ›When bookkeeping with Excel, the program is used to record financial data such as purchases, expenses, and sales in various digital spreadsheets. These spreadsheets are used to create and maintain records of other business data too, like inventory, supplier, and employee information.
How do you make a simple cash book? ›simple cash book||with solved problem||by kauserwise - YouTube
How do I use the money template in Excel? ›- Once you open the Money in Excel template, the Money in Excel pane will open on the right. ...
- In the Money in Excel pane, select Get started. ...
- Once signed in with your Microsoft 365 subscription, Money in Excel will ask you to link your financial accounts.
- Single column cash book.
- Double column cash book.
- Triple column cash book.
- Petty cash book.
There are four main types of cash books: Single column cash book. Double column cash book. Three column cash book.
What is the difference between cash book and cash book? ›...
Comparison Chart.
| Basis for Comparison | Cash Book | Cash Account |
|---|---|---|
| Type | Subsidiary Book | Ledger Account |
| Narration | Yes | No |
| Folio | Ledger Folio | Journal Folio |
Microsoft Excel is an invaluable tool for accountants to make numerous schedules and calculations that traditional bookkeeping software doesn't provide. It comes with functions for performing complex mathematical calculations and also supports many add-ons for activities like financial forecasting and modeling.
Do all accountants use Excel? ›Even if you hate Excel, it's one of those platforms you can't avoid in the accounting world, no matter how senior a position you hold. Accounting analysts, managers, and even directors, are expected to have mastered it and be able to use it with the utmost efficiency.
What Excel functions do accountants use? ›
VLOOKUP and HLOOKUP are two of the most useful Excel functions for accountants. These functions let you search a table of data and give all the appropriate information for an individual set of data based on only one part of it.
What is the format of cash book? ›It is also referred to as a three-column cash book format, and it is a complete form with three columns of money on both receipt and payment sides and records transactions about the cash, bank, and discounts.
What is the standard format of cash book? ›The format of the cash book is similar to that of a ledger account. Like a ledger account, the cash book consists of two sides – the debit side and the credit side if prepared in 'T' format. Like ledger accounts, the balance of the cash book is determined and transferred to the trial balance.
How many columns are in a cash book? ›The bank cash book has three columns at the debit side and three columns at the credit side, with the headings discount, details, bank.
How do I create an Excel template? ›Open the workbook that you want to use as a template. , and then click Save As. In the File name box, type the name that you want to use for the template. In the Save as type box, click Excel Template, or click Excel Macro-Enabled Template if the workbook contains macros that you want to make available in the template.
How do you upload a template to Excel? ›- Select the type of data to import from the Import Type drop-down list.
- Choose an import mapping template. You can: Choose a previously defined template from the drop-down list.
In 2010 Microsoft announced the release of Money Plus Sunset. This is a free tool and we already covered how to download and use Microsoft Money Plus Sunset version on Windows 10.