How to Find Missing Credit Notes and Duplicate Payments With Supplier Statements

Why do a missing credit note and a duplicate payment look the same?

A duplicate payment means the money left your bank twice. A missing credit note means the supplier cut what you owe and your ledger was never told, so you pay the full bill anyway. Both are items on one side only, which is the pattern Academy module 4 covers.

Your bank feed never sees a credit note, and the usual duplicate-bill check compares bills rather than payments, so a bill paid twice gets past it. The supplier’s statement is the one document that lists both what they credited you and what they think you paid.

Here the ledger sits above the supplier’s number for both reasons, so the two errors stack into one gap. Stop at “the totals differ” and you write one email about one thing, or you chase the first amount that happens to fit. A wrong opening balance or a timing difference can leave you with other problems that look like this too.

Where does the $2,365.60 come from?

Kellyvale’s statement is dated 31 October 2026 and covers account BB-5528. It has eight lines and a closing balance of $2,982.50. Lines 1, 2 and 3 are marked on the statement below.

Next to it, Brannock’s ledger, one document per row. Payments and credits are negative on both sides.

Finding the missing credit note

Run down the credit column and tick each credit against the ledger. KVC-3617 is there. KVC-3688, for $438.15 and dated 21 October, is not.

It is tempting to email Kellyvale and ask for the money, but there is nothing to claim. The credit has already reduced their balance. What you are missing is the document. If you pay from your own ledger you overpay by $438.15.

Finding the duplicate payment

On the payment side, invoice KV-82314 for $1,927.45 was paid on 5 October, and the ledger shows that. The statement also shows a second receipt of $1,927.45 on 14 October. Brannock’s ledger has nothing against this supplier for that date, because the 14 October bank payment was coded to suspense.

Nobody noticed because the bank rec balanced, the money had gone out. And the supplier account looked fine too, since the second payment never got onto it. Open the bank statement and look for a $1,927.45 debit on 14 October. Found it? Then you paid twice.

The credit that is posted but not applied

KVC-3617 sits on both sides at $164.20, so it is not a difference between them. It is still a loose end. A credit that is posted and never applied to a bill does nothing, and the next payment run pays that bill in full.

A plain balance comparison will not show it, because both sides agree. List the credits in your own ledger that are still open to find it.

Proving the gap is these two and nothing else

The sums are easy enough to do by hand. Take 1,927.45 and 438.15 off 5,348.10 and you land on 2,982.50. But that only shows the total works. Plenty of other pairs of mistakes could add up to $2,365.60 as well, so you still need to match every line.

How does a credit note go missing?

The supplier issued the credit note every time. What differs is where it stalled on the way to your ledger, and that decides the repair.

How does a payment get made twice?

Most duplicate checks look for the same supplier, the same reference and the same amount. That catches a double entry. It misses a payment made twice by a different route.

Say a bank transfer goes out on the 5th. On the 14th a second person pays the same bill by card, because the supplier’s credit controller phoned and nobody checked the first payment. Neither person sees the other’s payment. Direct debits and a second payer using their own login cause the same trouble. A payment parked in suspense, as here, also hides it: the bank reconciliation balances and the supplier account looks clean. A supplier that resends the bill under a new reference after a reminder can get it keyed as new, too.

The statement lists every receipt however the money arrived, so it picks up what the duplicate check misses. Pairing a payment with its invoice can be done by rule, and how references and amounts are matched has its own guide. Deciding whether two same-size payments are a mistake takes a person. If you pay a supplier the same amount every month, two payments close together may be quite legitimate, so ask before you assume.

Before you write to anyone, look in your own books for these. For how far back, start with the last three statements from your five biggest suppliers and go further only if you find a hit (our rule of thumb, not a standard).

1. Two payments to the same supplier for the same amount within 30 days. The 30 days is our rule of thumb, not a standard, so adjust it to how often you pay that supplier.
2. A supplier statement that shows you in credit when your ledger says you owe them.
3. Old items in suspense that match a supplier payment amount to the cent.

Xero’s duplicate-bill check compares the contact, the reference and the amount of bills and credit notes (Xero Central, read 30 October 2026). It targets a bill keyed twice. A bill paid twice is a different problem.

If money went out a year ago and nobody noticed, a recovery audit is one way to find it. This page is the do-it-yourself version for the statements you hold now.

Working down a statement for both problems

1. 1

   Check the closing date and the opening balance

   Pull your ledger as at the statement date, not today. If the opening balance does not match last month’s closing balance, fix that first, or every line under it will look wrong.

2. 2

   Tick the invoices

   Pair each invoice by reference, then by amount and date. Whatever you cannot pair is what is left to investigate.

3. 3

   Tick the payments, and look for twins

   Mark each payment against your bank feed or remittance. Two payments of the same amount against one invoice is a likely duplicate. Then check suspense for the second one.

4. 4

   Tick the credits

   Every credit on the statement must be in your ledger. Any you cannot find goes on the chase list with its reference, date and amount.

5. 5

   Look the other way: credits you hold

   List the credit notes in your own ledger that are still open. Apply them to a bill or chase the supplier to confirm what they are for.

6. 6

   Write a cause beside every difference

   Credit not posted, payment in suspense, keying error, timing. If you cannot name a cause, you have not found the difference yet.

Ticking the lines goes quickly. Waiting on the supplier’s documents is the slow part. If you match by hand, this workbook is a place to do it.

Getting the paperwork and the money back

The two problems need different asks, so send two emails.

Missing credit note: ask for the document

Write to the supplier’s accounts receivable or credit control team. The sales contact who arranged the return usually cannot pull the document. Give them the credit note reference, its date and amount, and your account number, and ask for a copy and which invoice it should reduce.

Leave money out of this email. Until the credit note is on file there is nothing for them to refund.

Duplicate payment: refund or credit?

Work out which one you want before you write to them. Kellyvale’s closing balance already includes the second payment. If you ask for a credit, you just pay the $2,982.50 on the statement once KVC-3688 is posted. If you ask for a refund, the balance goes back up to $4,909.95 and $1,927.45 comes back into your bank.

A credit is quicker if you buy from them every month. A refund suits an occasional supplier, a large amount, or a supplier you would rather not be owed money by.

After you send it

Do not short-pay the next invoice to recover the money yourself. Their ledger will show an under-paid bill, and their credit control may chase it or hold your orders. Wait for the written answer.

Put a date in the email and diarise it. Ten working days is our suggestion, not a norm. We found no standard time that a supplier must take to issue a credit note or return an overpayment, and some credits expire, so check the supplier’s terms.

If you hear nothing by your date, chase the same person, then their manager, and attach the first email. Keep every reply with the statement. Expect them to ask for:

• The remittance for each payment.
• The account the money left from.
• The bank record showing the date and amount.

How do you record the credit in Xero and QuickBooks Online?

Xero and QuickBooks Online won’t warn you about a missing credit note. You only see it on the statement. When the document turns up, the table below shows where to enter it, taken from each vendor’s own help pages (read 30 October 2026). If you’re after the whole statement and not just one credit, see the guides to reconciling supplier statements in Xero and in QuickBooks Online.

The QuickBooks steps here are the US wording. If you are on the Australian or UK version, the labels may differ, so check them against your own screen.

Making it routine

Run it monthly for your largest suppliers, anyone you return goods to, and anyone where you have already found an error. Do it as part of the payment-run checklist, so the credit chase happens before the money leaves.

The person who keys the bills should not be the only one who reads the statements. At Brannock, whoever keyed the bills never saw KVC-3688, so they could not have noticed it was missing. A second reader fixes that, and it is the idea behind segregation of duties.

Doing this with Statement Zen

We make Statement Zen, so weigh this section accordingly. Statement Zen for Xero and Statement Zen for QuickBooks Online connect to your ledger with a read-only sign-in. Vista works differently: it emails its AP position on a schedule. In each case you forward the supplier’s statement PDF, and the dashboard shows the statement lines it could not match to your ledger. You can try it on a single statement with the free reconciliation. The checks are the same either way: read the credit column for KVC-3688, and look for the second 1,927.45 receipt, whether you use a spreadsheet or a tool.

Questions people ask

Sources

• Australian Taxation Office: Adjustment notes (page last updated 14 September 2026), read 30 Oct 2026
• Xero Central: Apply a supplier’s credit to a bill, read 30 Oct 2026
• Intuit QuickBooks Online help: Enter and refund a vendor credit (US), read 30 Oct 2026
• Xero Central: Credit notes explained, read 30 Oct 2026
• Xero Central: Add and track your bills in Xero (duplicate bill detection), read 30 Oct 2026
• Intuit QuickBooks Online help: Print customer or vendor reports (Vendor Balance Detail, updated 3 August 2026), read 30 Oct 2026

What changed

• 30 Oct 2026: First published.