How to Track Daily Sales, Cash, and Expenses for Your Retail Shop in Nepal

Most small shop owners in Nepal trust their memory or a rough notebook to track daily sales. That works when you have five customers a day. It stops working the moment you hire a helper, accept eSewa and Khalti alongside cash, and stock twenty-plus product lines. By the time Dashain arrives and your counter is busy from morning to night, you have no idea where the money went.

This guide gives you a simple end-of-day cash reconciliation routine you can run in under twenty minutes — no accountant needed, no fancy software required to start.

Why Daily Reconciliation Matters

A reconciliation is just a count: does the money in your drawer match what your records say should be there? If it does, you're clean. If it doesn't, you caught a problem today — not three months later when your CA asks why your books don't balance.

For Nepali retail shops the stakes are higher than they look. You're likely mixing:

• Cash payments — still the dominant mode for most customers
• eSewa and Khalti — digital wallets that settle to your bank account with a delay
• Credit sales (udhaaro) — items given on trust to regular customers
• COD returns — refunds from couriers like Pathao or NMB Courier for failed deliveries

Each of these flows differently. If you only count cash in the drawer, you're already missing the full picture.

The Five Numbers You Need Every Day

Before you do anything else, commit to recording five numbers every evening:

1. Opening cash — the float you put in the drawer when you opened the shop
2. Total sales — every transaction, regardless of payment method
3. Cash collected — actual notes and coins received from customers
4. Digital payments received — eSewa, Khalti, and bank transfer totals for the day
5. Cash expenses paid out — any cash that left the drawer (electricity bill, supplier payment, tea money)

Your formula is straightforward:

Expected closing cash = Opening cash + Cash collected − Cash expenses paid out

Count what's actually in the drawer. If it matches, you're done. If it's short or over by more than Rs. 50, investigate before you go home.

Setting Up Your Daily Log Sheet

You don't need a spreadsheet on day one. A ruled notebook with columns works fine. Draw seven columns across two pages:

• Date
• Bill or transaction number
• Customer name (or "walk-in")
• Amount (NPR)
• Payment method: Cash / eSewa / Khalti / Udhaaro
• Expense description (leave blank for sales)
• Notes

Every transaction gets one line. Every expense gets one line. At the end of the day, total the Amount column by payment method and run the formula above.

Handling eSewa and Khalti Correctly

This is where many shop owners make an error. When a customer pays Rs. 1,500 via eSewa, that money is not in your drawer — it is in your eSewa merchant wallet. It will arrive in your bank account after one to three business days depending on your settlement schedule.

Record digital payments separately from cash. At the end of each week, open your eSewa or Khalti merchant dashboard and verify that every payment you recorded actually settled. If you see a payment that didn't arrive within five business days, contact the wallet provider immediately — delays beyond that are unusual and worth chasing.

When the settlement does land in your bank account, record it as a bank receipt — do not record it again as a sale, or you will double-count your revenue.

Tracking Udhaaro (Credit Sales)

Udhaaro is deeply embedded in Nepali retail culture. A customer takes goods today and pays later. This is a sale that happened — you just haven't collected the cash yet.

Keep a separate udhaaro register. Every credit sale gets a line with: date, customer name, phone number, items, and amount. When they pay, mark it settled with the date and payment method. Review this register weekly and follow up on anything older than fifteen days.

A common mistake is excluding udhaaro from daily sales totals. That hides your true revenue and makes your reconciliation look cleaner than it is. Record the sale on the day it happens; record the payment when you actually receive it.

VAT, PAN, and Your Daily Records

If your annual turnover crosses Rs. 50 lakh, you are required to register for VAT in Nepal. Even below that threshold, having a PAN and issuing proper receipts protects you during Inland Revenue Department visits.

For daily reconciliation purposes, note which sales had VAT collected (13%) and which were VAT-exempt. Keep all carbon copies of manual bills or printouts of digital receipts. IRD audits often focus on whether your declared sales match the bills you issued — a daily log makes this easy to defend.

If you use a POS system like Saauzi, VAT is calculated automatically on each transaction and your daily sales report includes a full VAT breakdown — saving you the manual tally at month end and giving your CA clean numbers to work from.

The End-of-Day Routine, Step by Step

Block twenty minutes every evening before staff leave. Follow this sequence:

1. Close the counter. Stop taking new transactions for the day.
2. Count the cash drawer. Separate your denominations (Rs. 1000, 500, 100, 50, 20, 10) and write the total.
3. Pull your digital payment totals. Check eSewa and Khalti merchant dashboards for today's confirmed transactions.
4. Total your sales log. Sum cash sales, digital sales, and udhaaro separately.
5. Total your cash expenses. Every note that left the drawer for any reason.
6. Run the formula. Opening cash + Cash collected − Cash expenses = Expected closing cash.
7. Compare with actual count. Note any difference. If it's more than Rs. 50, review your log line by line before locking up.
8. Record your closing balance. This becomes tomorrow's opening cash.
9. Note anything unusual. A supplier advance, a return, a discount — one sentence in the Notes column.

Preparing for Dashain and High-Volume Seasons

Dashain, Tihar, and Chhath can triple your normal daily transaction count. A twenty-minute close can stretch to forty if you haven't built the habit yet. Two adjustments for peak season:

• Do a midday mini-count. At lunch, count the cash in the drawer and note the rough total of digital payments so far. If something is already off, you find it while the morning's transactions are still fresh in memory.
• Batch-reconcile udhaaro weekly, not daily. During Dashain, many customers run tabs. Keep the register updated in real time but do the totals on Sunday evening — it keeps your nightly routine fast.

What to Do When Your Numbers Don't Match

A shortfall means either a sale wasn't recorded, an expense wasn't noted, or cash left the drawer without a record. An overage usually means a customer received wrong change.

Do not adjust the number to make it balance. Write down the difference, investigate for ten minutes, and if you can't find it, record it as an unexplained variance. A pattern of small unexplained variances over several days is a signal worth taking seriously — it may indicate staff error or something more concerning.

Start Tonight

Before you close your shop this evening: count your cash drawer, write down what came in by payment method, subtract what went out, and check if it matches. Do this for seven consecutive days. By the end of that week you will have a clearer picture of your actual daily revenue than you've had in years — and you'll have caught the gaps that have been quietly costing you money. A notebook is enough to begin. When you're ready to move faster, a POS system will run these totals automatically so reconciliation becomes a two-minute review instead of a twenty-minute calculation.