Why does a supplier show a debit balance on an accounts payable aging report? A negative supplier balance can come from an unapplied credit note, a genuine overpayment, a duplicated journal, a misallocated settlement or a timing difference. The balance alone does not prove that the supplier owes a refund.
This practical investigation uses fictional USD transactions and a fixed 30 September reporting cutoff. It is intended for AP accountants and reviewers who need a traceable explanation rather than a balancing adjustment.
1. Confirm what a debit balance means in your report
For this example, positive AP means an amount owed to the supplier and negative AP means a net debit on the supplier account. Some systems reverse the displayed signs. Confirm the ledger convention and whether the report includes posted, unposted or post-cutoff items.
2. Worked example: why the supplier shows minus $300
Assume one supplier, one legal entity, USD only, and all entries posted by 30 September.
| Transaction | Supporting evidence | AP movement | Running balance |
|---|---|---|---|
| Invoice INV-240 | Approved invoice and receipt | +$2,000 | +$2,000 |
| Credit note CN-045 | Supplier credit and approval | −$600 | +$1,400 |
| Payment PAY-090 | Remittance and bank evidence | −$1,700 | −$300 |
Reconciliation: $2,000 − $600 − $1,700 = −$300. The invoice net of the credit was $1,400; the recorded payment was $1,700. This explains the reported balance mathematically but does not yet establish whether the supplier actually received an extra $300.
3. Distinguish cash overpayment from a posting problem
If the bank confirms $1,700 was paid once and the $600 credit is valid, investigate recovery or an approved application to a future invoice. If the bank confirms only $1,400 left the account, the extra $300 may be a duplicate posting or settlement error. Do not request a refund or book an adjustment until the bank and allocation evidence agree.
4. Seven checks to resolve the difference
- Freeze the reporting cutoff. Record the as-at date, extraction time and inclusion rules. Keep subsequent transactions separate.
- Verify the supplier and entity. Compare supplier IDs, legal entities, currencies and merged vendor records; do not net across entities without approval.
- Trace the document chain. Match the invoice, credit note, goods return or price adjustment, remittance and settlement reference.
- Confirm the actual payment. Match beneficiary, value date, bank reference and amount to the bank statement.
- Review allocations. A credit or payment may have been allocated to a different invoice or left unapplied; check line-level settlements.
- Reconcile to the general ledger. Agree the AP subledger to its control account and identify direct GL journals that bypassed supplier records.
- Document the disposition. Assign an owner, evidence reference, reviewer, due date and decision; retain approval for any recovery, reallocation or correction.
5. What should the exception record contain?
Keep supplier ID, entity, currency, cutoff date, transaction IDs, debit-balance value, suspected cause, bank confirmation, allocation status, evidence links, owner, reviewer and resolution date. Use a separate status for investigating, awaiting supplier response, posting correction and closed with evidence. Do not treat a cleared balance as proof that the underlying cause was resolved.
6. Reporting controls that prevent hidden debit balances
Show gross supplier credits and gross supplier debits separately rather than only a net AP total. Reconcile the supplier-level population to the AP control account using one reporting cutoff. Flag missing document IDs, duplicate payment references, invalid dates and cross-currency netting. A dashboard is most useful when each exception leads to a documented action and review.
Frequently asked questions
Does a negative AP supplier balance always mean a refund is due?
No. An unapplied credit, a settlement error, a duplicate posting or a genuine cash overpayment can produce a similar balance.
Can a credit note be used against a future invoice?
Potentially, subject to the supplier agreement, system capabilities and approved internal process. Preserve the settlement trail so the same credit is not used twice.
What if the invoice and credit are in different currencies?
Do not simply subtract their face values. Reconcile the source currencies and apply the approved FX and settlement policy.
Related GetTheDocs resources
Continue with the supplier statement reconciliation guide, AP aging investigation guide and month-end AP reconciliation workflow. For a product designed around supplier statement matching and discrepancy review, see Supplier ReconMatch Pro.
Illustrative educational example. All figures, supplier details and document IDs are fictional. Follow your organisation's accounting policies and applicable reporting requirements. For background on vendor credit-note settlement, see Microsoft Learn.