Shop Operations

Shop Opening Balance Checklist: Dues and Stock

Use this shop opening balance checklist to verify customer dues, supplier balances and stock before switching systems, without counting the same entry twice.

By Yojika
Shop Opening Balance Checklist: Dues and Stock

A shop opening balance checklist helps you carry customer dues, supplier dues and stock into a new billing system without counting them twice. Choose when the old records end, verify what remains unpaid or on hand, and keep the evidence beside each figure. This guide covers that starting snapshot, with a worked shop example and the relevant Yojika fields.

Shop opening balance checklist: prepare one starting snapshot

An opening balance is the amount carried into your records when you begin using the system. It is not automatically the original bill amount: part of that bill may already have been paid.

Use a sheet with these columns before entering anything:

CheckWhat to write downEvidence to keep
Cut-offLast day covered by the old records and first day of new entryDated handover note
Customer duesCustomer name and amount still to receiveOld bills, khata pages and receipts
Supplier duesSupplier name and amount still to paySupplier statement, bills and payment references
Opening stockItem, unit and quantity physically on handDated count sheet
Advances or disputesAmount, reason and person following upPayment proof or correspondence
VerificationAgreed figure, person who checked it and dateChecked copy of the sheet

Keep customer and supplier totals separate. Do not subtract all supplier dues from all customer dues and enter one shop-wide balance. You need to know whose money each amount represents.

This is a checklist for starting billing records. Ask your accountant to handle the wider opening books, including bank balances, loans, capital and tax accounts.

Fix the cut-off before collecting figures

Write a simple boundary: “Old records through closing on 18/10/2026; new transactions from 19/10/2026.” Complete the old day’s receipts and payments before agreeing the totals.

If someone pays while you are preparing the sheet, record the date and reference. Decide which side of the boundary it belongs to and count it once. A payment received after the cut-off belongs in the later activity, rather than silently reducing the agreed starting figure.

Keep the original khata or export available. Switching software should not remove the evidence behind a customer’s old debt.

Check unpaid amounts, names and stock units

For each customer, start with the relevant old bills and subtract payments already received. Check returns, agreed adjustments and advances with the person who maintains your books. A disputed amount needs a note and follow-up, rather than a guessed correction.

For each supplier, compare your records with their statement using the same date. A recent bank transfer might appear in your records before the supplier updates theirs. Match its reference before accepting the supplier’s total.

Check identities before copying figures. Two similar customer names may represent one account, or two different businesses. Our duplicate customer records check explains that comparison.

Count stock in a consistent unit. If the item uses pieces, five cartons of twelve pieces means 60 pieces, not five. Separate damaged, returned or third-party goods for review; do not quietly include them as ordinary saleable stock. Opening stock quantity and stock valuation are separate checks, so have your accountant confirm the value and tax treatment where needed.

Worked example: a Pune shop changes its records

In this fictional example, Neha runs a household-goods shop in Pune. She agrees the close of 18/10/2026 as her cut-off and prepares these figures:

RecordOld document totalsPayments before cut-offOpening position
Customer Asha₹8,400₹3,400 received₹5,000 to receive
Customer Mohan₹2,700₹700 received₹2,000 to receive
Supplier Deccan Traders₹15,600₹9,600 paid₹6,000 to pay

Customer dues are ₹5,000 + ₹2,000 = ₹7,000. Supplier dues are ₹15,600 − ₹9,600 = ₹6,000. Neha checks each account separately rather than entering only the ₹1,000 difference.

The sample bills concern ordinary local taxable supplies where the supplier and place of supply are both in Maharashtra. CGST and SGST apply to that basic same-state case, as explained in CBIC’s supply FAQ, question 85. The table uses final document totals, including applicable tax; it does not prescribe a product rate or calculate a new tax liability.

Neha also counts five cartons of twelve storage containers: 5 × 12 = 60 pieces. She records 60 as the opening quantity for that item. This count does not establish what she owes Deccan Traders; that comes from the unpaid bills.

If Neha carries Asha’s ₹5,000 into the opening balance, she must not also recreate the same ₹5,000 as an unpaid sale. That would show ₹10,000 due, although Asha owes only ₹5,000. If historical transactions will be loaded, Neha and her accountant first decide which amounts those transactions already represent.

Enter and check the figures in Yojika

Yojika provides separate fields for the two kinds of starting information:

  • In Parties, the party form has Opening balance, with To receive for money owed to you and To pay for money you owe.
  • When adding a goods item under Items, Opening stock records the starting quantity. Check the item’s unit before entering the count.
  • In a party’s details, Statement shows the opening and closing balances and the intervening entries. Export CSV saves that statement for comparison with your sheet.

Review the starting figures before adding new activity. Keep the agreed cut-off in your handover note; these fields do not replace that note or the supporting documents. The party’s Outstanding figure shows today’s position even when a historical period is selected, so use the dated statement when checking a past period.

FAQ

What should a shop opening balance checklist include?

Record the cut-off date, each customer’s unpaid amount, each supplier’s unpaid amount, stock quantities and supporting references. Keep advances and unresolved differences visible for your accountant to check.

Should I enter the original bill total as the opening balance?

Use the amount still unpaid at your agreed cut-off, after checking payments and adjustments. Do not enter the same debt both as an opening balance and as an unpaid historical bill.

Can opening stock show how much I owe a supplier?

No. Opening stock records goods on hand; supplier dues record money still payable. Goods may already be paid for, and an unpaid supplier bill may relate to goods already sold.

Should I change the opening balance when a customer pays later?

Keep the agreed starting figure and record the later payment separately using the appropriate payment workflow. Changing the opening figure to today’s balance loses the distinction between the starting debt and later activity.

Start with figures you can explain

Yojika’s opening balance, opening stock and statement tools help you carry checked figures into everyday billing. See the features, or download Yojika to explore the fields with sample records before entering your shop’s starting amounts.

Try Yojika at your counter

Offline-first GST billing for Indian small shops — automatic CGST/SGST/IGST, invoices in 22 languages, A4 / A5 / thermal printing, and your data on your own PC.

Keep reading

Newsletter

Practical GST & shop-keeping tips, now and then

Occasional, plain-English guides for Indian small shops. No spam, unsubscribe anytime.