Cash book format: free Excel template and worked examples

By Khata365 · Published 11 November 2026 · Examples in Pakistani rupees

A cash book is the daily record of every rupee that comes into your shop and every rupee that goes out. Below are the three formats people use most (single column, three column and petty cash), each filled in for one month of a small kiryana shop, plus a free Excel template and a blank sheet you can print.

Download Excel template

The Excel file has four sheets: single column, three column, petty cash and a blank sheet. Totals and balances are formulas, so they update as you type.

What a cash book is

A cash book is a book of original entry: transactions go into it first, on the day they happen. It also works as the cash account in the ledger, so you do not need a separate cash account. Every cash book has two sides:

  • Debit side (left), receipts: cash sales, money a customer pays against udhar, cash you bring into the business, cash withdrawn from the bank.
  • Credit side (right), payments: purchases paid in cash, rent, bills, salaries, cash deposited in the bank.

Each side has the same columns: date, particulars (who paid or what for), voucher or receipt number, L.F. (ledger folio, the page of the related ledger account) and amount. Credit sales and credit purchases do not go in the cash book, because no cash moved; they go in the customer's or supplier's khata.

Single column cash book format

One amount column on each side, for cash only. This is the format most small shops need. Example: Hassan Kiryana Store starts November 2026 with Rs 15,000 in the drawer.

Cash book of Hassan Kiryana Store, November 2026 (Rs)
DateReceipts (Dr)AmountDatePayments (Cr)Amount
Nov 1Balance b/d15,000Nov 2Purchases (wholesaler, cash)30,000
Nov 3Cash sales42,500Nov 5Shop rent25,000
Nov 8Aslam (udhar received)6,000Nov 10Electricity bill7,800
Nov 15Cash sales38,000Nov 20Salary, helper18,000
Nov 30Balance c/d20,700
Total101,500Total101,500
Dec 1Balance b/d20,700

Receipts add up to Rs 101,500 and payments to Rs 80,800. The difference, Rs 20,700, is the cash that should be in the drawer on 30 November. It is written on the payments side as balance c/d (carried down) so both totals match, then brought down on 1 December as balance b/d. If the drawer holds a different amount, an entry is missing.

Double and three column cash book format

Once the shop has a bank account, a double column cash book adds a bank column next to cash on both sides. A three column cash book adds a third column for discount: discount allowed to customers on the receipts side, discount received from suppliers on the payments side.

Three column cash book, November 2026 (Rs)
DateReceiptsDiscountCashBankDatePaymentsDiscountCashBank
Nov 1Balance b/d15,000120,000Nov 2Rehman Wholesale (cheque)1,50058,500
Nov 4Cash sales40,000Nov 12Bank (cash deposited) C20,000
Nov 6Bilal Traders (cheque)1,00049,000Nov 18Shop rent25,000
Nov 12Cash (deposited) C20,000Nov 20Electricity bill (online)7,800
Nov 30Balance c/d10,000122,700
Total1,00055,000189,000Total1,50055,000189,000

Three things to notice:

  • Contra entries. Depositing Rs 20,000 of cash into the bank appears on both sides (cash out, bank in) and is marked C. It is one transaction inside the same book.
  • Discount is not balanced. Cash and bank are balanced like the single column book. The discount columns are only totalled: Rs 1,000 goes to discount allowed and Rs 1,500 to discount received in the ledger.
  • Bank can go negative. If the account is overdrawn, the bank balance c/d is written on the receipts side instead. Cash can never go below zero.

Petty cash book format (imprest system)

Small daily spending (tea, rickshaw fare, carry bags) clutters the main cash book, so many shops give a fixed float to one person and record it in a petty cash book. Under the imprest system the float is topped up at the end of each period by exactly the amount spent, so it always starts again at the same figure. The analysis columns show where the money went.

Petty cash book, imprest Rs 10,000, November 2026 (Rs)
ReceivedDateParticularsTotal paidRefreshmentPackingTravelCleaningStationery
10,000Nov 1Cash from main cash book
Nov 3Tea and biscuits1,2001,200
Nov 7Shopping bags2,5002,500
Nov 12Rickshaw to wholesale market800800
Nov 18Cleaning supplies1,5001,500
Nov 25Register and pens650650
Total spent6,6501,2002,5008001,500650
Nov 30Balance c/d3,350
3,350Dec 1Balance b/d
6,650Dec 1Cash from main cash book (top-up)

Rs 6,650 was spent, Rs 3,350 is left, and the top-up of Rs 6,650 brings the float back to Rs 10,000 for December. Keep a slip for every payment; the slips should add up to the total spent.

How to balance a cash book

  1. Add the receipts side and the payments side separately.
  2. Subtract the smaller total from the larger. For the cash column the receipts side is always the larger.
  3. Write the difference on the smaller side as balance c/d, dated the last day of the period.
  4. Total both sides again; they should now be equal. Write the totals on the same line on both sides.
  5. Bring the balance down on the opposite side as balance b/d, dated the first day of the next period.
  6. Count the cash in hand. It should equal the balance. For the bank column, compare with the bank statement (a bank reconciliation).

Paper or phone? A paper cash book works, but you balance it by hand and it can get lost or wet. In the Khata365 app each cash in and cash out entry updates the balance as you save it, cash, bank and mobile wallet accounts sit side by side, transfers between them are recorded once, and the month can be exported to PDF or Excel. It works offline and is free on Android.

Questions

What is the format of a cash book?

Two sides: receipts (debit) on the left and payments (credit) on the right. Each side has date, particulars, voucher number, L.F. and amount columns. At the end of the period the difference is written on the smaller side as balance c/d so both totals match.

What is the difference between a single column and a three column cash book?

A single column cash book records cash only. A double column cash book adds a bank column (or a discount column). A three column cash book has cash, bank and discount columns on both sides.

What is the imprest system of petty cash book?

The petty cashier gets a fixed float, for example Rs 10,000. At the end of the period the main cashier pays back exactly what was spent, so the float is back to Rs 10,000.

Can a cash book have a credit balance?

The cash column cannot, because you cannot pay out more cash than you have. The bank column can, when the account is overdrawn.

Do credit sales go in the cash book?

No. A credit (udhar) sale moves no cash, so it goes in the customer's khata. The cash book records it only when the customer pays.

Related

Keep your cash book on your phone

Khata365 records cash in, cash out, udhar and stock in seconds, works without internet and is free on Android.