Search
Generic filters

Cash Book Excel Template

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
Share on facebook
Share on linkedin
Share on email
Share on whatsapp

Download Guide

Compatible with : Microsoft Office Excel, Libra Office, WPS Office, Google WorkSheet
  • Download The Template XLSX File Format
  • Use the Template

Download Instruction :

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.

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

Recently Uploaded Excel Templates: