Supplier outstanding balance: check before paying

Your supplier outstanding balance is the amount you still owe a supplier after purchase bills, payments and agreed adjustments are counted. Match it to the supplier’s statement for the same date before sending the next payment. This guide shows a simple supplier reconciliation, a worked shop example and the Yojika screens that help you trace a difference.

How to calculate your supplier outstanding balance

For a supplier you only buy from, use:

Opening amount owed + new purchase bills − payments − agreed credits or returns = closing amount owed.

Use each bill’s final amount, including any tax charged on it. If a payment was already deducted when calculating the opening amount, do not subtract it again. A return awaiting the supplier’s acceptance belongs on your query list; it is not yet an agreed reduction.

Keep these figures separate:

A new bill can be outstanding without being overdue. Likewise, a payment made this month may settle last month’s purchases. Comparing this month’s purchase total with this month’s bank transfers will not, by itself, tell you what remains due.

If the same business also buys from your shop, review both sides separately before agreeing to offset one against the other.

Match documents before matching the final number

Ask for a statement through a specific date, then collect your purchase bills, payment confirmations and return documents through that date.

1. Agree on the opening amount

Start with the previous agreed closing balance. If that amount differs, trace the earlier period first. A perfect match on this month’s entries cannot explain an old difference.

When moving from a paper book to software, avoid entering the same debt twice: once as an opening balance and again as an unpaid historical bill.

2. Match each supplier bill

Compare the supplier name, supplier bill number, date and final total. Your software’s internal purchase number may differ from the number on the supplier’s document.

Mark missing and repeated bills. Check the actual document before adding anything. Our guide to recording purchases and expenses covers entering the underlying transaction; this check is about reconciling what remains unpaid.

3. Match each payment and adjustment

For a payment, compare the amount, date and bank or UPI reference. If the supplier cannot find it, share the reference and ask them to confirm its allocation. A pending transfer needs investigation before you treat it as settled.

For returned goods, compare the return record with the supplier’s acknowledgement and agreed credit. Keep disputed quantities or deductions listed separately. Never invent a balancing payment just to make the two totals agree.

Worked example: a Pune shop checks one supplier

Imagine a Pune shop checking an ordinary local purchase account with a Pune wholesaler. Both the supplier location and place of supply are in Maharashtra, so taxable supplies in this example use CGST and SGST, consistent with CBIC’s supply FAQ, question 85.

The figures below are hypothetical final document amounts, with any applicable tax already included. They are not a product-rate example; do not add GST again.

The check is ₹8,000 + ₹20,000 − ₹15,000 − ₹1,000 = ₹12,000.

Suppose the supplier’s statement through 25/09/2026 shows ₹17,000. The ₹5,000 difference is a clue to check the UPI payment, not proof that it was missed. If its reference is absent and the supplier confirms receipt, ask for the corrected statement. Sending another ₹5,000 would create a second payment rather than fix the missing entry.

Check the balance in Yojika

Open Parties, find the supplier and select Statement. Choose the same date range as the supplier’s statement. It shows opening, running and closing balances; Export CSV gives you a copy to compare or share.

The Outstanding total above the transactions shows today’s position even when the statement shows an earlier period. A Cr balance means you owe the party; Dr means the party owes you. Read that direction instead of comparing an unsigned number alone.

Use Transactions to open a purchase bill. When an actual payment needs recording, choose Record payment, enter the amount paid, method, date, source account and reference. Payment Out lets you check recorded payments and their linked bills.

An advance can reduce the party balance while individual bills remain open until it is allocated. Check unapplied advances before paying an apparently unpaid bill again. All-party balances includes opening balances and advances; Payables aging focuses on unpaid bills and their age, so the two reports need not match.

Keep the GST check separate

An agreed supplier balance is not, by itself, confirmation of input tax credit eligibility. The GST portal’s GSTR-2B FAQ advises taxpayers to reconcile that statement with their own records and assess credit eligibility.

Give your CA the unresolved bills, returns and payment details. Confirm the current GST treatment of unpaid invoices and adjustments with your CA; this balance check does not determine tax credit or filing deadlines.

Frequently asked questions

How do I calculate a supplier outstanding balance?

Start with the amount already owed, add new purchase bill totals, then subtract payments and agreed credits or returns. Use the same closing date for your records and the supplier statement.

Why does my supplier show more money due than my books?

Check for a payment the supplier has not recorded, a missing purchase bill in your books, a duplicate bill or an unresolved return. Compare document numbers and payment references before changing either balance.

Does outstanding mean the payment is overdue?

No. Outstanding means an amount remains unpaid; overdue means its agreed payment date has passed. Check the payment terms before deciding which bills need attention first.

Why can Yojika’s statement and outstanding total differ?

The statement follows your selected date range, while the outstanding total shows today’s position. Later transactions can therefore change the total without appearing in an older statement.

Make the next payment easier to check

Keep one agreed statement and the references supporting it. Yojika’s purchase records, party statements and Payment Out list help you follow that trail. Explore the billing and bookkeeping features and current plans to see how they fit your shop’s routine.