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:
- Cash sale of ₹2,000.
- UPI sale of ₹3,500, credited to the bank.
- A customer owed ₹2,000, pays ₹1,900 in cash, and you allow a discount of ₹100.
- You settle a supplier bill of ₹6,000 by UPI, paying ₹5,850 because the supplier gives ₹150 discount.
- 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:
| Side | Particulars | Discount (₹) | Cash (₹) | Bank (₹) |
|---|---|---|---|---|
| Receipts | Opening balance | - | 5,000 | 30,000 |
| Receipts | Cash sale | - | 2,000 | - |
| Receipts | UPI sale | - | - | 3,500 |
| Receipts | Customer settles a ₹2,000 due | 100 | 1,900 | - |
| Payments | Supplier bill settled by UPI | 150 | - | 5,850 |
| Payments | Transport paid | - | 300 | - |
| Payments | Closing balance | - | 8,600 | 27,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.
| Layout | What it tracks | Closing figures for the sample day |
|---|---|---|
| Single column | Cash only | Cash 8,600 |
| Double column | Cash and bank | Cash 8,600; bank 27,650 |
| Triple column | Discount, cash and bank | Cash 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.
Useful ideas start with a clearer picture of your own spending.
Explore your reports
