Template

Cash book format for Nepal (Excel and PDF)

A daily cash and bank book with columns for money in and money out, and a balance that updates on every line. There is also a sheet to print for the counter.

Free download

Get both files free

The Excel sheet works the totals out for you; the PDF is the same form left blank for printing. Leave your name, phone and email and the download opens straight away.

Excel template XLSX
Printable PDF PDF

Updated 12 September 2026.

What it must contain

Fields the document needs in Nepal

Account the book covers One book per cash counter or per bank account, named at the top.
Opening balance for the period What was in hand or in the account when the period started.
Date of every entry In AD and BS, so the day total lands in the right Nepali month.
Voucher number and particulars The document behind the entry and a description anyone can follow.
Receipt and payment columns Money in and money out kept apart, never netted into one figure.
Head for each entry Sales, purchase, expense, drawings or transfer, so the month can be read.
Balance after every entry Recalculated line by line and counted against the drawer at close.

What a cash book is for in Nepal

A cash book is the daily record of money in and money out of one account. For most Nepali shops that account is the drawer at the counter. The business bank account gets a second book, kept the same way. Every receipt and every payment goes on its own line with a voucher reference (the bill or slip behind the entry). The balance column shows what should be there when you count.

At the end of the day, most owners want to know where the cash went, more than what the profit was. The cash book answers that. It records money moving in and out, and your accountant prepares the statutory accounts separately.

How to fill it in

Write the account name at the top of the Excel sheet. Set the period in both calendars, and enter the opening balance on the first line. For each entry, record the date in AD and BS, the voucher number and a short description anyone can follow (the particulars). Add the head it belongs to, such as sales or expense. Then put the amount in either the receipt column or the payment column.

The balance column is a formula. It carries the balance down and updates it on every line, so you can always see the closing figure. At the bottom, the sheet totals receipts and payments for the period and shows the closing balance. Print the PDF for the counter, write entries as they happen, and type them into the sheet at close.

Common mistakes

Netting a receipt against a payment to save a line. Neither entry then shows in the book.
Writing entries from memory at the end of the week.
Taking money out for a personal expense without a voucher. The drawer is then short and nobody knows why.
Putting bank and cash in one book. You then cannot check either one against its real balance.
Leaving the head blank, so you cannot see the month by category.
Changing the balance to match the count. Record the difference and look for the cause instead.

How Kuver Books prints it automatically

In Kuver Books the cash entries come from the documents themselves. A counter sale, a supplier payment, a customer receipt or a transfer between accounts records the money against the account it moved through. You see the daily position on screen without typing it up. Record payments across 10 Nepali methods: cash, Khalti, eSewa, bank transfer, ConnectIPS, Fonepay, IME Pay, PrabhuPay, card and mobile banking. You can keep each bank account separate and close the day with a total that matches the bills behind it. Year end runs on a 5-step guided fiscal-year close. See payments, receivables and cash.

How Kuver Books prints this automatically

Frequently asked questions

Should I keep one cash book or several?

Keep one book for each account. A cash counter and a bank account work differently and are counted differently, so each needs its own book. Money moving between them is a transfer. Write it as a payment out of one book and a receipt into the other, on the same date, with the same voucher reference.

How often should the book be closed?

Close the cash book every day. Count the drawer, compare it with the balance column, and write down any difference that day, not at month end. A shortfall found on the same day is usually a missing voucher you can still remember. Found three weeks later, the same shortfall is just a loss.

Is a cash book the same as accounting?

No. A cash book records money in and out of one account, which is what a shop owner needs to see every day. Your accountant prepares the statutory accounts (the formal accounts required by law) from a wider set of records. If your cash book is accurate, the accountant only has to check it, not rebuild it.

More free templates

Kuver Books fills in the cash book for you, with the numbers already right.

Try it on a free trial with your own items imported, or ask us on WhatsApp.

Book a demo

Talk to a person

WhatsApp +977 974-4401191

Sunday to Friday, 9am to 6pm NPT. A real person replies within one business day.