# How to check a year of supplier payments for money you can get back

Use an afternoon to check a year of payments. Keep the evidence beside each possible error, then ask the supplier to confirm what is owed.

Updated 12 October 2026 . 5 min read . Alexey Shurov

## The short answer

A finance or operations manager can use a spreadsheet to make a first pass through a year of supplier payments in an afternoon. Look for repeated payments, unused credits, wrong prices, excess quantities and missed discounts. The result is a list to investigate, not a total you can claim back yet.

Keep each possible error linked to its invoice, payment and supporting record. A matching amount alone proves little. The supplier may have sent two separate orders for the same price. Check the documents before asking for money back.

### 1. Gather the records

Export a year of supplier payments and paid invoices. Include supplier codes, invoice references, invoice dates, payment dates, amounts and currency. Keep an untouched copy and work in a second sheet. Gather credit notes, agreed price lists, goods received records and payment terms. Keep different currencies apart.

### 2. Find the same invoice paid twice

Sort payments by supplier, then amount and date. Look for the same amount paid on close dates. Compare invoice references after removing spaces and punctuation in a helper column. Keep the original reference beside it. Check both matches against the invoices and bank records.

The free tool at /tools/duplicate-payment-finder/ does this first check in your browser without uploading the file anywhere. Its matches still need a person to check them.

### 3. Match payments to credit notes

Export credit notes with their dates, amounts and linked invoice references. A credit note records a reduction in what you owe. Look for invoices paid in full after a credit note was issued. Check whether the credit was already refunded or used against another invoice before adding a finding.

### 4. Compare prices with the agreement

Export invoice lines with item codes, quantities and unit prices. Match them to the price list that applied on the order date. Look for a charged price above the agreed price. Compare the same pack size and tax treatment. Record only the possible excess, not the whole invoice value.

### 5. Compare quantities with what arrived

Export invoice quantities and records of goods received, linked by order and item code. Look for more units billed than received. Check later deliveries, returns and pack sizes before treating a difference as an error. Multiply any unexplained extra quantity by its agreed unit price.

### 6. Check earned settlement discounts

Export payment dates, invoice dates, discount terms and the amounts paid. A settlement discount is a reduction for paying within an agreed time. Look for payments that met those terms but used the full invoice amount. Check which date starts the payment window and whether every condition was met.

## The blank findings sheet

Use one row per possible error. Amounts are in pounds. Keep evidence with each finding and update the outcome after the supplier replies.

| Supplier | Invoice refs | What looks wrong | Amount in question | Evidence | Who asks the supplier | Outcome |
|---|---|---|---|---|---|---|
|  |  |  |  |  |  |  |
|  |  |  |  |  |  |  |
|  |  |  |  |  |  |  |
|  |  |  |  |  |  |  |

[Download this sheet as a file for Excel](data:text/csv;charset=utf-8,%EF%BB%BFSupplier%2CInvoice%20refs%2CWhat%20looks%20wrong%2CAmount%20in%20question%2CEvidence%2CWho%20asks%20the%20supplier%2COutcome%0D%0A%2C%2C%2C%2C%2C%2C%0D%0A%2C%2C%2C%2C%2C%2C%0D%0A%2C%2C%2C%2C%2C%2C%0D%0A%2C%2C%2C%2C%2C%2C%0D%0A)

## A made up worked example

**Made up example.** All seven rows, suppliers, references and amounts are made up to show the method. Amounts are in pounds. They are possible errors, not money recovered.

| Supplier | Invoice refs | What looks wrong | Amount in question | Evidence | Who asks the supplier | Outcome |
|---|---|---|---|---|---|---|
| Supplier A | A104 and A104 | Same invoice appears in two payments | 1240.00 | One invoice and two payment records | Finance manager | Awaiting supplier reply |
| Supplier B | B-208 and B208 | Invoice number written differently | 360.00 | Matching invoice copies and payment records | Bookkeeper | Check whether both payments cleared |
| Supplier C | C310 and CN310 | Invoice paid after linked credit note | 180.00 | Credit note predates full payment | Finance manager | Check whether credit was used elsewhere |
| Supplier D | D411 | Unit price above agreed price list | 75.00 | Invoice lines and dated price list | Buyer | Ask supplier to check price |
| Supplier E | E512 | Billed quantity above received quantity | 240.00 | Invoice and goods received record | Operations manager | Check later delivery records |
| Supplier F | F613 | Earned settlement discount not taken | 42.00 | Written terms and payment date | Bookkeeper | Ask supplier to confirm discount |
| Supplier G | G714 and G715 | Same amount paid on close dates | 560.00 | Separate invoices and separate delivery records | Finance manager | Closed after checking separate orders |

[Download this sheet as a file for Excel](data:text/csv;charset=utf-8,%EF%BB%BFSupplier%2CInvoice%20refs%2CWhat%20looks%20wrong%2CAmount%20in%20question%2CEvidence%2CWho%20asks%20the%20supplier%2COutcome%0D%0ASupplier%20A%2CA104%20and%20A104%2CSame%20invoice%20appears%20in%20two%20payments%2C1240.00%2COne%20invoice%20and%20two%20payment%20records%2CFinance%20manager%2CAwaiting%20supplier%20reply%0D%0ASupplier%20B%2CB-208%20and%20B208%2CInvoice%20number%20written%20differently%2C360.00%2CMatching%20invoice%20copies%20and%20payment%20records%2CBookkeeper%2CCheck%20whether%20both%20payments%20cleared%0D%0ASupplier%20C%2CC310%20and%20CN310%2CInvoice%20paid%20after%20linked%20credit%20note%2C180.00%2CCredit%20note%20predates%20full%20payment%2CFinance%20manager%2CCheck%20whether%20credit%20was%20used%20elsewhere%0D%0ASupplier%20D%2CD411%2CUnit%20price%20above%20agreed%20price%20list%2C75.00%2CInvoice%20lines%20and%20dated%20price%20list%2CBuyer%2CAsk%20supplier%20to%20check%20price%0D%0ASupplier%20E%2CE512%2CBilled%20quantity%20above%20received%20quantity%2C240.00%2CInvoice%20and%20goods%20received%20record%2COperations%20manager%2CCheck%20later%20delivery%20records%0D%0ASupplier%20F%2CF613%2CEarned%20settlement%20discount%20not%20taken%2C42.00%2CWritten%20terms%20and%20payment%20date%2CBookkeeper%2CAsk%20supplier%20to%20confirm%20discount%0D%0ASupplier%20G%2CG714%20and%20G715%2CSame%20amount%20paid%20on%20close%20dates%2C560.00%2CSeparate%20invoices%20and%20separate%20delivery%20records%2CFinance%20manager%2CClosed%20after%20checking%20separate%20orders%0D%0A)

## Turn a finding into a clear question

Use the findings sheet to record the amount in question, the evidence and one person responsible for asking the supplier. Send the relevant references and explain the difference. Update the outcome when the supplier replies. Keep possible errors separate from agreed repayments and money actually received.

## If you would rather have it done

I can run the whole check for you, paid as a share of what comes back. The share and the work are agreed in writing before I start. The agreement also sets out how to record what comes back. No finding counts as recovered money just because it appears on a sheet.

## When this is the wrong fit

This afternoon check is a poor fit when the records cannot be matched to invoices or payment dates. Put those records in order first. It is also the wrong tool for a dispute about the quality of work. A spreadsheet can show a difference, but it cannot decide that dispute.

## Where to start

Start with the duplicate check while gathering the other records. Work through the remaining checks as the evidence becomes available. If the year is too large for an afternoon, record what you covered and what remains. Do not describe an unfinished review as a full check.

## Common questions

### Does a match mean the supplier owes us money?

No. Check the underlying invoice, delivery and payment records. Repeated amounts can be valid, and a credit may already have been used.

### Do I need a new system?

No. Use exports from your existing records and a spreadsheet. Keep the original files so you can trace each finding.

### What belongs in the amount column?

The possible excess payment for that finding. Avoid counting the same invoice difference again under another check.

### Can the whole process finish in an afternoon?

The first review can fit an afternoon when the records are ready. Missing documents and supplier replies can take longer.

## Useful next[Free toolDuplicate payment finderPaste your supplier payments and see which ones may have been paid twice. The check runs in this page, so your figures never leave your computer.](https://shurco.ai/tools/duplicate-payment-finder/)[PlaybookHow to build a business case for AI automationA finance director does not approve AI. They approve a measured task, an honest cost and a way to tell whether it worked. Here is the one page that gets a yes, and the numbers to put on it.](https://shurco.ai/guides/business-case-for-ai-automation/)[ServiceOne job, run for you every monthYou name one piece of repetitive work. I build the system that does it, run it every month for a fixed fee, and send anything unclear to a person on your team.](https://shurco.ai/guides/automation-run-for-you/)

## More guides[GuideAI agent pricing in 2026, what vendors actually chargeVendors now charge for agents by the conversation, the outcome, the action or the credit. Here are the published prices, what each unit really means, and how to compare them on your own workload.](https://shurco.ai/guides/ai-agent-pricing/)[ServiceA monthly test for your customer facing AI assistantOnce a month, I ask your website or phone assistant ordinary customer questions. You get what it got wrong, its exact words and what to change. The first test is free.](https://shurco.ai/guides/ai-assistant-monthly-test/)[PlaybookHow to automate daily site reports across many sitesThe report takes days because the data lives in many places and someone has to chase it. Here is how to gather it in parallel, catch the numbers that disagree and produce a report a manager can check.](https://shurco.ai/guides/automate-daily-site-reports/)[PlaybookHow to automate quoting for a manufacturer or distributorSlow quotes lose work. There are three quite different kinds of quoting automation, and most buying mistakes come from picking the wrong kind. Here is how to tell which one your quotes need.](https://shurco.ai/guides/automate-quoting-for-manufacturers/)[PlaybookHow to automate sales order entry in Business CentralCustomers email orders as PDFs, spreadsheets and free text, and someone keys each line into Business Central. Here are the three ways to take that work away, with what Microsoft's own agent does and where it stops.](https://shurco.ai/guides/automate-sales-order-entry-business-central/)[PlaybookHow to automate timesheet processing for payrollTimesheets arrive as spreadsheets, PDFs, photos and scans, and payroll has a deadline that does not move. This is the order to automate it in, and the checks that stop a wrong payslip.](https://shurco.ai/guides/automate-timesheet-processing-for-payroll/)

## Want this in your operation

I build and run production AI agents that take repetitive work off operational teams. [Tell me what your team spends too long on.](https://shurco.ai/#contact)

Web version https://shurco.ai/guides/supplier-payment-leak-check/