Download Cash Book Excel Template


Popular Categories in Excel Template
Trednding in Excel Template

Project TimeLine chart

A project timeline chart is created in Excel using charts linked to data tables, so …

Read More

Easy Excel Ribbon Template

Design your own Excel ribbon buttons in minutes. So, Create actions for these buttons and …

Read More

Menstrual Cycle Calendar

Our Menstrual Cycle Calendar and Period Tracker can help you anticipate your next period will …

Read More

GCC VAT With Discount

GCC VAT With Discount is an excel template for tax invoice for business who give …

Read More
Generic filters

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.

Cash Book

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.

Simple Template

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

Instruction :

All Excel templates and tools are sole property of 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.

 You can also download and use our 1000 Best PowerPoint Presentation Templates and 500 Resume Samples from  Completely Free. All our templates are designed by Professionals

Popular Excel Templates: