The advantage of a digital cash book format using an Excel spreadsheet: It’s quick, clear, and the entered amounts are automatically offset against each other. Cash Book Format is a set of layouts used for accounting purpose. A business enterprise pays through cheques and collects money from its customers through cheques. A petty cash book records small cash transactions in separate accounts.

To get a clear picture of how it looks, go through the following format: The elements of a cash book can be understood as follows: Date: The date of each transaction is recorded in this column. Enter the transaction on the debit or credit side and it will automatically calculate the cash on hand for you. In this format of Cash Book, cash and bank transactions are recorded and thus it gives ledger of both the cash and bank accounts. 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. In this way, digital cash book templates offer a direct overview of the financial situation of a company and spare the need for time-consuming calculations – where errors can easily creep in.

Petty Cash Book Format. Now-a-days volume of bank transactions of even a small business are so high that Single Column Cash Book is not so useful. On the top of the column, the year is noted down. It is totally free & fully customizable.

It is also referred to as a three-column cash book format and it is a most exhaustive form which has three columns of money on both receipt and payment sides and record transactions pertaining to the cash, bank, and discounts. Blank Cash Book Excel Template For Business: This cash book template is appropriate and suitable for any small or big business that desires an easy and simple bookkeeping way. You can download given templates for manual or computer practice of cash book problems.

This is ideal if you don’t want to use a computer to keep your cash book and are happy to do it the good old-fashioned manual way. Use these cash book format instructions to make your very own cashbook spreadsheet using plain paper or a school exercise book.