A supplier who owes you money is easy to forget about, which is why debit balances often turn out to be cash that never comes back.
A supplier debit balance means the supplier owes you money, usually because of a duplicate payment, an overpayment, a credit note received after payment, a deposit or a posting error. List debit balances every month, investigate each one, then request a refund, offset it against the next invoice or correct the posting. Don't leave them to age.
In accounts payable a supplier account normally carries a credit balance: you owe them. A debit balance means the position has flipped and the supplier owes you. That is money you have already paid out.
Export supplier balances at month end. Check your system's sign convention first: some show creditor balances as positive, others as negative. With supplier in column A and balance in column B, where credits are positive:
=IF(B2<0,"Debit balance","")
Add the date of the last transaction in column C and age each debit balance against the report date:
=IF(B2<0,ReportDate-C2,"")
Sort by amount, then by age. Anything old or large goes to the top of the list.
Large debit balances are not liabilities, so many teams reclassify them from trade payables to other receivables or prepayments in the reporting pack. Agree the approach with your auditors and apply it consistently.
Most debit balances start with a duplicate or an overpayment. Run duplicate checks before entry, review the payment run before release, and reconcile key supplier statements monthly. A debit balance found quickly is usually recovered; one found a year later often isn't. Make sure the person who clears debit balances isn't also the person who can change supplier bank details or release payments: see segregation of duties in accounts payable.
UK teams say "creditor debit balances" or "debit balances on the purchase ledger"; US teams say "vendor debit balances". US companies should check state unclaimed property (escheat) rules before writing off; UK teams should check with their advisers. Apply your reporting framework (for example UK GAAP, IFRS or US GAAP) to presentation.
AI software that reconciles a supplier statement to your AP ledger on your own computer: missing invoices, credit notes, price differences, duplicates and payments in transit. $2,997 once-off; see it on the built-in example first.
The Supplier Statement Reconciliation Template keeps payments in transit, credit notes not yet on the statement and statement items not yet in your ledger as three separate reconciling items, and logs genuine queries instead of netting them into one difference. Excel, no macros, one-time price.
The supplier owes you money, usually because of a duplicate payment, an overpayment, a credit note received after payment, a deposit or a posting error.
Investigate the cause, then request a refund, agree in writing to offset it against the next invoice, or correct the posting. Write off only with approval and documented recovery attempts.
Material ones are usually reclassified to other receivables or prepayments for reporting. Agree the treatment with your auditors and apply it consistently.
Last updated 21 October 2026. General guidance for finance teams; check it against your own policies, systems and local rules.