Business

Single, double and triple column cash book: which one to keep

Single, double or triple column cash book? See one sample day laid out three ways and pick the layout that fits a small trader taking mostly UPI.

Editorial illustration for Single, double and triple column cash book: which one to keep

Choose the single column cash book if you deal only in notes and coins, the double column if you also use a bank account (which is nearly every trader taking UPI), and the triple column only if you regularly give or receive discounts at the time of payment. The three layouts differ in how many columns sit beside the amount, not in how double-entry works underneath.

The sample day we will use

To compare fairly, use one made-up day. Opening cash is ₹5,000 and opening bank balance is ₹30,000. During the day:

  1. Cash sale of ₹2,000.
  2. UPI sale of ₹3,500, credited to the bank.
  3. A customer owed ₹2,000, pays ₹1,900 in cash, and you allow a discount of ₹100.
  4. You settle a supplier bill of ₹6,000 by UPI, paying ₹5,850 because the supplier gives ₹150 discount.
  5. You pay ₹300 cash for transport.

Layout one: single column

Only cash is shown. Receipts are 2,000 plus 1,900, which is 3,900. Payments are 300. Closing cash is 5,000 plus 3,900 minus 300, which is 8,600. The UPI sale and the supplier settlement do not appear at all, so this book cannot tell you what is in the bank.

Layout two: double column (cash and bank)

Each side of the page has a cash column and a bank column. The cash column is the same as above and closes at 8,600. The bank column opens at 30,000, adds the UPI sale of 3,500 and deducts the supplier payment of 5,850, which closes at 27,650. Now one page shows both pools of money.

Layout three: triple column (discount, cash, bank)

A third column records discount. Discount allowed (₹100) sits on the receipts side. Discount received (₹150) sits on the payments side. The discount columns have no balance of their own; you only total them. The cash and bank columns close at the same 8,600 and 27,650. Laid out as the classic two-sided page, the sample day looks like this:

SideParticularsDiscount (₹)Cash (₹)Bank (₹)
ReceiptsOpening balance-5,00030,000
ReceiptsCash sale-2,000-
ReceiptsUPI sale--3,500
ReceiptsCustomer settles a ₹2,000 due1001,900-
PaymentsSupplier bill settled by UPI150-5,850
PaymentsTransport paid-300-
PaymentsClosing balance-8,60027,650

Both sides of the cash column total 8,900 (5,000 plus 2,000 plus 1,900 on one side; 300 plus 8,600 on the other), and both sides of the bank column total 33,500. Only the two discount figures stay unbalanced, and that is expected, since they are memo totals.

LayoutWhat it tracksClosing figures for the sample day
Single columnCash onlyCash 8,600
Double columnCash and bankCash 8,600; bank 27,650
Triple columnDiscount, cash and bankCash 8,600; bank 27,650; discount allowed 100; discount received 150

Which one should you keep?

If most of your receipts are UPI, a single column book hides the bulk of your trade, so start with the double column. The triple column earns its place only when discounts are routine, for example cash discounts to regular buyers or prompt-payment discounts from suppliers. If discounts are rare, note them in the description and keep two columns.

Does the bank column match your passbook?

It should, apart from items still in transit such as a cheque you wrote that has not cleared. Compare your bank column with the statement at least monthly and note each difference with a reason. A bank statement uploaded to SpendixAI can serve as your check, since each imported row keeps the account it came from; your own ledger of cash stays a separate habit.

  • Cash only, no bank account: single column.
  • Cash plus bank, UPI heavy: double column.
  • Regular discounts both ways: triple column.
SPENDIXAI JOURNAL

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

Explore your reports