How to Track Vendor Advances Against Supplier Invoices

Keep one payment record for each advance, with linked adjustment records where several invoices settle it. Give the payment a unique reference so you can follow it from the bank entry to the purchase and its eventual settlement.

• Supplier name and the party reference used in your books.
• Purchase order, accepted quotation or other written purchase reference.
• Payment date, amount, bank transaction reference and payment approval.
• Expected delivery or service milestone and the person responsible for following up.
• Each invoice reference and the amount of advance adjusted against it.
• Each refund received, its bank reference and any adjustment reversal.
• Outstanding amount, current status, latest supplier response and next action.

Keep the original payment amount unchanged. Add settlement movements separately so a reviewer can explain the remaining balance without reconstructing overwritten figures.

Use this schedule calculation: opening outstanding advance plus new advances, less invoice adjustments, less refunds received, plus reversals of earlier adjustments. Record other approved closures separately, with their reason and accounting reference.

Count a settlement movement once. An invoice adjustment reduces the advance; it is not another bank payment. A promised refund stays outstanding until receipt is verified. If a calculation produces a negative advance, investigate the allocation instead of carrying it forward without explanation.

Check each delivery against the purchase reference and the receipt record from your shop, godown or service owner. Record delivery progress separately from advance settlement. Goods arriving does not, by itself, establish which amount has been adjusted against an invoice.

For each accepted invoice, confirm the agreed advance adjustment and calculate the balance proposed for payment. Show that calculation to the payment approver. Keep any disputed quantity, rejected goods or missing invoice visible as an exception.

In this illustrative example, the invoice balances proposed for separate payment are Rs 15,000 and Rs 30,000. The outstanding advance remains Rs 15,000 after both adjustments until the refund arrives. These figures illustrate allocation only and do not describe tax treatment.

Change the status to cancelled, but retain the outstanding advance. Record the cancellation evidence, the amount requested back, the supplier's response and the person responsible for recovery. Cancelling a purchase reference is not evidence that the money has returned.

• ✓Separate amounts already adjusted against accepted invoices from the unsettled advance.
• ✓Record a refund request separately from a refund received.
• ✓Match each refund to the bank receipt and the original advance.
• ✓Keep any disputed deduction visible until its basis and treatment are approved.
• ✓If both parties agree to use the balance for another order, record the transfer between purchase references without treating it as a fresh payment.

For a partial refund, reduce the schedule only by the amount received. Keep the remainder open with a clear next action. Ask your accountant to determine the entries and documents needed for any agreed deduction or closure.

1. Carry forward the previous closing schedule and explain any changes to opening balances.
2. Match new advances to bank payments, approvals and purchase references.
3. Check invoice adjustments against the invoice records and purchase allocation.
4. Match refunds to bank receipts and review any reversed adjustments.
5. Reconcile the schedule with the relevant advance balances in the books. List differences individually.
6. Review open items against expected delivery, invoice and refund milestones.
7. Assign an owner and next action to every exception, then retain the reviewed closing schedule.

Use the Bank Reconciliation Monthly Routine guide to check payment and refund movements. Read the Accounts Payable Ageing Review guide alongside this schedule before approving supplier payments, so unresolved advances are considered in the payment review.

Keep this review within your Month-End Close Checklist. Where the supplier disagrees with your balance, use the Customer and Supplier Balance Confirmation guide to organise the comparison and supporting records.

Choose review intervals suited to your purchasing cycle, and track both the original payment age and any missed delivery or refund milestone. A recent advance can need attention if its agreed milestone has already passed.

Escalate when the supplier stops responding, delivery repeatedly slips, a refund commitment is missed or nobody can explain the purchase reference. Give the owner a short record of the amount, evidence, latest response and decision needed.

• Keeping only a supplier total, which leaves individual orders and payments unexplained.
• Paying an invoice in full without checking whether an advance should be adjusted.
• Clearing an advance when goods arrive, before confirming the invoice allocation.
• Treating a promised refund as money already received.
• Moving balances between orders without written agreement and a transfer record.
• Hiding differences by netting unrelated supplier balances or overwriting earlier movements.

Keep refundable deposits, employee advances and owner transactions separately identified. If one bank transfer covers several purchases or a deposit as well as an advance, split the schedule allocation and retain the link to the single bank transaction.

No. It records what was paid, what was applied and what remains unresolved. It does not decide expense recognition, asset classification, GST, input tax credit or TDS treatment. Ask your CA to confirm the treatment and current requirements using the official portals.