Tax and GST

Single-column or three-column cash book: which to use

Compare single, double and three-column cash books using one day of takings, and pick the simplest format that still ties to your bank passbook.

Editorial illustration for Single-column or three-column cash book: which to use

Use a single-column cash book if almost everything you do is in cash, a double-column book if you also pay and bank money through a current account, and a three-column book only if you regularly give or take cash discounts. Choose the simplest one that lets you tie your closing figures to both the drawer and the bank statement.

What do the columns actually mean?

  • Single column: one money column on each side, for cash only.
  • Double column: cash and bank side by side, so the book also tracks the bank balance.
  • Three column: cash, bank and discount. The discount column on the receipts side is discount you allowed to customers, and on the payments side is discount you received from suppliers.

The discount column is only a memo. It is not money in the drawer or the bank, so it never changes either balance. It records the gap between what the bill said and what was actually settled.

One day of takings, written in each format

Say a stationery shop opens with ₹4,000 cash and ₹30,000 in the bank. During the day:

  1. Cash sales of ₹6,500.
  2. UPI sales of ₹3,200, credited to the bank.
  3. A customer owing ₹2,100 pays ₹2,000 in cash, and you let ₹100 go.
  4. You pay a supplier ₹5,000 by bank transfer against a bill of ₹5,100, so you received ₹100 discount.
  5. Tea and courier paid in cash, ₹400.
  6. Cash of ₹3,000 taken from the till and deposited in the bank.

Cash closing is ₹4,000 + ₹6,500 + ₹2,000 - ₹400 - ₹3,000 = ₹9,100. Bank closing is ₹30,000 + ₹3,200 + ₹3,000 - ₹5,000 = ₹31,200.

FormatWhat it shows for this dayWhat it misses
Single columnCash closing ₹9,100 onlyBank balance, UPI takings, the supplier payment
Double columnCash ₹9,100 and bank ₹31,200The ₹100 given and ₹100 received as discounts
Three columnCash ₹9,100, bank ₹31,200, discount allowed ₹100, discount received ₹100Nothing for this day

Which one should a shopkeeper pick?

Ask two questions. Does most of your money pass through the bank? If yes, a single-column cash book will feel empty and you need at least two columns. Do customers or suppliers often settle for slightly less than the bill? If yes, add the discount column, otherwise the bill totals will never match what you actually collected.

A tea stall or a small vegetable shop dealing in cash can stay with one column for years. A wholesaler paying suppliers by transfer needs the bank column from day one.

How does the bank column tie to your statement?

At month end, take the bank balance in your book and compare it with the closing balance on your bank statement. They rarely match exactly, and the gaps usually have familiar causes: a cheque you issued that has not cleared yet, a bank charge you have not entered, or a deposit you wrote down on a different date than the bank did. List the gaps, add or subtract them, and the two figures should meet. Check your own statement for what each line means rather than guessing.

What if the bank column feels like too much work?

Many owners keep a plain cash book and treat the bank statement itself as the bank record, then compare the two weekly. That is a fair choice. A tool such as SpendixAI can take the statement as an upload in PDF, CSV or Excel and let you review rows before saving, which saves retyping the bank side. You still keep cash by hand for the drawer.

Before you decide

  • Write down how many payments went through the bank in the last week.
  • Count how many times you gave or took a discount.
  • Pick the fewest columns that cover both answers.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports