Your supplier says ₹12,000 is due. Your notebook says ₹9,000. Before making another payment, you need to know which bill or payment explains the difference. Paying first and checking later can turn a small missing entry into a bigger dispute.
A supplier ledger is a running record of what you owe one supplier. It works best when every bill, payment and agreed adjustment has a reference you can find.
Reconcile the entries, not just the final balance. Two matching totals can still contain missing or duplicated records.
A supplier balance you can check by hand
Assume you owe ₹5,000 at the start of the month. A new purchase bill adds ₹8,000. You pay ₹6,000, and the supplier agrees a ₹1,000 reduction for returned goods. The expected outstanding amount is ₹6,000: ₹5,000 + ₹8,000 − ₹6,000 − ₹1,000.
The adjustment is only part of the example because it has been agreed and documented. Sending goods back does not by itself prove that the supplier has accepted a credit.
Use this reconciliation worksheet
For each supplier, write down:
- Opening balance and the date both sides last agreed it.
- New bill numbers, dates and total amounts.
- Payments with dates, amounts and transaction references.
- Agreed returns or credits and their document references.
- Closing balance and any unresolved difference.
Compare the worksheet with the supplier's statement. Work in date order. Check a payment against both your bank record and the supplier's receipt; a bank debit proves money left your account, but you still need to check the recipient and allocation.
Four common reasons for a difference
A bill entered twice: match document numbers, not just amounts. Two bills can legitimately have the same value.
A payment entered against the wrong party: check the supplier name and reference before changing anything.
A return still awaiting acceptance: keep it separate from a confirmed adjustment.
Different opening balances: return to the last agreed statement rather than hiding the difference in a new purchase.
Keep the records together in DAM
Search Add Party to create the supplier record and New Purchase to record a purchase bill. Search Purchase Invoices to review the bill list. Check the supplier's ledger and opening balance against the worksheet before adding the next batch of bills.
When recording a payment, use the relevant payment workflow and review the supplier balance afterwards. Do not create another purchase just to represent money paid. For the stock side of the entry, use the purchase bill guide.
A better weekly routine
Reconcile your busiest suppliers weekly. Keep a short list of disputed entries with the bill reference and the person following up. When both parties agree a correction, keep the reason alongside the record.
Does a supplier payment reduce this month's purchases?
No. Paying an old balance is different from receiving new goods. Keep purchase records and settlement records distinct.
What if I cannot explain an old difference?
Keep it visible and investigate with the supplier and accountant. Do not force the balance to match by inventing a sale or purchase.
Useful next reads
- Retail Billing Software: What a Small Shop Actually Needs
- Inventory Software for Small Shops: A Practical Buying Checklist
- Kirana Billing App: Manage Bills, Stock and Udhar Together
Try DAM with your own shop workflow
Start with a few products and one bill. New accounts are currently offered one month of Gold free. Check the current plan, price and limits before paying.
Try DAM on Android