• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Download Cash Book Excel Template

Download Cash Book Excel 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.

These templates can be helpful for accounting professionals like accountants, accounts assistants, small business owners, etc.

Table of Contents

  • What is a Cash Book?
  • Main Features of a Cash Book
  • Types of Cash Book
    • Single Column Cash Book
    • Double Column Cash Book (Discounts)
    • Double Column Cash Book (Tax)
    • Triple Column Cash Book (Discounts and Tax)
  • Download Cash Book Templates
    • Simple Cash Book Template
    • Cash Book Template With Discount
    • Cash Book Template With Tax (VAT/GST/Sales Tax)
    • Cash Book Template With Discount and Tax
  • Advantages of A Cash Book
  • Frequently Asked Questions

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 Column Cash 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.

Cash Book Templates

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).

Simple Cash Book

There are 2 sides Debit and Credit. Both sides consist of 3 columns each: Date, Particulars, and Amount.

Simple Cash Book

To record a transaction, insert date, Particular, Amounts on Debit/Inward, or Credit/Outward side.

Simple Cash Book

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.

Cash Book With Discount

Excel Google Sheets Open Office Calc

Contents of Cash Book Template With Discount

It consists of 3 sections:

  1. Header Section
  2. Summary Section
  3. Data Entry Section

The header section consists of Company name, template title, and logo.

Cash Book With Discount

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.

Cash Book With Discount

It will also display the amounts of discounts received and discounts given on total transactions.

Cash Book With Discount

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.

Cash Book VAT

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:

  1. Header Section and
  2. 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.

Cash Book Template

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.

Cash Book Template

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.

Cash Book With Discount and Tax

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:

  1. Header
  2. Summary
  3. Data Entry

The header section consists of the company name, logo, and title of the template.

Cash Book With Discount and Tax

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

Cash Book With Discount and Tax

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

Cash Book With Discount and Tax

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 the cash receipts and cash payments 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 books into several parts.

What is a 3 column cash book?

The triple column 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

« Download Accounts Receivable Excel Template
Download Invoice Excel Templates »

Filed Under: Accounting Templates

You are Here: Home / Excel Templates / Accounting Templates / Download Cash Book Excel Template

About Shabbir Bhimani

I have worked in Excel and like to share functional excel templates at ExcelDataPro.

Comments

  1. Emery says

    March 14, 2018 at 5:56 am

    Where to record money that is in Cash and Money that is in Bank ?

    Reply
    • Fahim Lashkaria says

      March 14, 2018 at 10:38 am

      Money in the bank is reported in Bank book. Only cash transactions are recorded in cash book.

      Reply
      • Ghazanfar alvi says

        August 21, 2019 at 1:18 am

        Assalam o Alaikum
        Sir mujhy koi aisi accounting sheet chahiye jis main aik bank ki tarah account open kr k hisab rakha jaey . agr koi aisi sheet ho to please mujhy send kijiey ga. mera email address ghazanfaralvi4@gmail.com

        Reply
        • Fahim Lashkaria says

          August 21, 2019 at 8:46 am

          We don’t have any such template. If there will be any, we will let you know.

          Reply
          • Rameez says

            January 8, 2020 at 5:28 pm

            Sir,
            I want to get your help in a sense Proper Book keeping recode in Accounting

          • Fahim Lashkaria says

            January 9, 2020 at 10:58 am

            what kind of help do you need?

  2. Emery says

    March 14, 2018 at 5:57 am

    In that Cashbook format you showed us?

    Reply
  3. KISHORE says

    April 5, 2018 at 10:07 am

    HOW TO CELL 1 TO 21
    21 TO NEXT……

    Reply
    • Fahim Lashkaria says

      April 5, 2018 at 10:31 am

      Hi Kishore,
      Unable to understand what you want. Please write your query in detail.

      Reply
  4. BEA says

    July 27, 2018 at 9:42 am

    Hi could you help me how to creat the manual cash book. I have got the Bank Statement and I have only a couple transaction like BAC HBI om credit side then EBP HMRC the same amount on debit side. How to record in the cash book, also CHG to 05 Jan- A/C I am not sure if all this transaction go on the same side ?

    Reply
  5. BEA says

    July 27, 2018 at 9:46 am

    Hi could you help me how to creat the manual cash book. I have got the Bank Statement and I have only a couple transaction like BAC HBI om credit side then EBP HMRC the same amount on debit side. How to record in the cash book, also CHG to 05 Jan- A/C I am not sure if all this transaction go on the same side like Bank ??

    Reply
    • Fahim Lashkaria says

      July 28, 2018 at 7:01 am

      Hi there,
      Dear cash book always reports the cash transaction. Thus these transactions aren’t recorded in Cashbook. You need to maintain a bank book where banks debit will be your credit and bank’s credit amount will be your debit amount. The general rule of accounting is ” Debit what comes in and credit what goes out.” THus now see how do the charges reflect your accounting. If you have paid anything it will be your credit and if received it will be your credit.

      Reply
  6. Muhammad Sajid says

    June 22, 2019 at 11:57 pm

    used and downloaded for the first time. will comment in detail later.

    Reply
    • Fahim Lashkaria says

      June 23, 2019 at 9:40 pm

      thanks for downloading

      Reply
    • sohail.ahmed417@gmail.com says

      March 20, 2020 at 3:27 pm

      What is Opening balance & Closing balance & where from we get it

      Reply
      • Fahim Lashkaria says

        March 20, 2020 at 3:33 pm

        Cash in hand or starting balance is called opening balance. and closing balance is the cash in hand at the month or day end.

        Reply
  7. Raj says

    July 9, 2019 at 7:54 pm

    Thank you for the template. How do I use this to track daily status. I would like to close the daily balances and carry forward for the next day

    Reply
    • Fahim Lashkaria says

      July 10, 2019 at 11:38 am

      Hi Raj,

      There are two ways to do this.
      1. Make 1 sheet for each day and carry forward the balance to next day on the debit side.
      2. The template displays the current balance so you have the balance.

      Reply
  8. Sohail Ahmed says

    March 12, 2020 at 10:04 pm

    Very Useful

    Reply
    • Fahim Lashkaria says

      March 13, 2020 at 6:09 pm

      Thanks

      Reply
  9. brian says

    June 26, 2020 at 5:47 pm

    i need a two column cash book template which consits of the cash column and bank column please

    Reply
    • Fahim Lashkaria says

      June 29, 2020 at 2:02 pm

      Noted. Will be published when in line.

      Reply
      • brian says

        July 1, 2020 at 6:35 pm

        Thank you

        Reply
    • AISWARYA says

      May 7, 2022 at 4:35 pm

      YES I ALSO

      Reply
  10. Muhammad Munna says

    August 20, 2020 at 4:04 pm

    What if my data exceeds the 20th row that u have provided for data entry?

    Reply
    • Fahim Lashkaria says

      August 20, 2020 at 4:08 pm

      Add rows

      Reply
      • Muhammad Munna says

        August 20, 2020 at 4:11 pm

        How?

        Reply
        • Fahim Lashkaria says

          August 20, 2020 at 4:14 pm

          Right-click at the cell above totals. Click on Insert, select Entire row, and click on “OK”. Do this for as many rows you want to enter.

          Reply
  11. Obed says

    November 19, 2020 at 10:32 pm

    wow!!!
    You just released the stress that I had. Honestly I love these templates.

    May I please ask that you sincerely help me out with a Financial Statement Template. I will highly appreciate that.

    Kind Regards

    Reply
    • Fahim Lashkaria says

      November 23, 2020 at 7:56 pm

      Hi Obed, Thanks for your appreciation. You can find financial statements on the link below:
      https://exceldatapro.com/templates/financial-statement-templates/

      Reply
  12. USK says

    March 3, 2021 at 12:44 am

    Hello

    Thank you for the great work,

    Is it possible with single entry excel based spreadsheet, transactions automatically prepare financial statements

    Reply
    • admin says

      March 4, 2021 at 7:10 am

      Doable but we don’t provide them as a complete financial statements in one sheet.

      Reply

Trackbacks

  1. Download GST Invoice Format For Job Workers In Excel - ExcelDataPro says:
    July 30, 2017 at 7:48 am

    […] you can also download other accounting templates like Petty Cash Book, Simple Cash Book, and Accounts Payable from […]

    Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Accounting Templates

  • Accounts Payable Excel Template
  • Accounts Receivable Excel Template
  • Cash Book Excel Template
  • Invoice Excel Templates
  • Expense Report Excel Template
  • Petty Cash Book Excel Template
  • Inventory Management Excel Template
  • Billing Statement Excel Template
  • Purchase Return Book Excel Template
  • Accounts Payable With Aging Excel Template
  • Accounts Receivable With Aging Excel Template
  • Budget With Charts Excel Template
  • Checkbook Register Excel Template
  • Purchase Order Excel Template
  • Purchase Return Book With Tax Excel Template
  • Marketing Budget Excel Template
  • Asset Inventory Tracker Excel Template
  • Depreciation Calculator Excel Template

ExcelDataPro

Free Excel Pro Templates

  • Glossary
    • Accounting Glossary
    • HR & Payroll Glossary
    • Tax Glossary
  • Templates
    • Accounting
      • Financial Analysis
      • Financial Statement
    • Educational
    • Taxation
      • Federal Income Tax
      • GST
      • UAE VAT
      • UK VAT
    • Human Resources
      • HR & Payroll
      • HR Metrics
    • School Management
    • Social Media
    • Sales-Marketing
    • Personal Finance
    • Other
      • Health & Fitness
  • Functions
  • FAQ’s
  • Blog
  • Home
  • Contact
  • Privacy
  • Terms

© ExcelDataPro 2023. Content Licensed Under Creative Commons with Attribution Required

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Cookie settingsACCEPT
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT