Compare expected credits with documented credit notes
Match expected supplier credits to credit notes by explicit claim reference. Find missing, partial, excess or unmatched credit documents.
How do I check whether an expected supplier credit has been documented?
Match credit notes to the same supplier and explicit claim reference, then compare their combined amount with the expected credit. Credit Follow-up checks documents provided in your files; it does not determine whether money was refunded.
Input requirements and report limits ↓Inputs
Copy a table from Excel or Google Sheets, including its header row, and paste it below. CSV/TSV files also work. Use “Map your columns” for different headers. IDs stay as text.
Free: UTF-8 CSV/TSV · 200 KB / 500 rows per input · 5 successful reviews per browser per day. CSV calculations run locally.
Need larger files or repeat batches? View editions →
Reuse a column profile
A profile stores column names only. It does not store your file contents.
Review report
Before you use this review
| Bring | Expected credits and credit notes with supplier, explicit claim reference, currency and nonnegative amounts. |
|---|---|
| Match | Unique supplier + claim in expected credits; unique supplier + credit ID in notes. Sum matching-currency amounts. |
| Calculate | 100 expected − 60 documented = 40 unresolved. Unmatched notes and currency mismatches need review. |
| Cannot establish | Cash refund, allocation to invoices or accounting entries. One credit note spanning multiple claims needs a separate allocation workflow. |
Required inputs
Expected credits need supplier, claim_id, expected_credit, currency. Credit notes need supplier, credit_id, claim_id, amount, currency. Supplier + claim keys and supplier + credit ID keys must be unique in their respective files. Amounts are nonnegative with at most two decimal places.
Interpret the report
For an expected credit of 100 and matching notes totaling 60, the unresolved amount is 40. Missing, partial and excess credits are distinguished, and notes with no matching claim are listed. Currency mismatches require review; only matching-currency amounts are totaled.
A matching document total does not prove cash repayment or allocation against an invoice. Tax treatment, payment settlement and accounting entries are outside this tool. Use PO Exposure separately for invoices against purchase orders.
Can I match a credit note without a claim reference?
No. Supply a reviewed, explicit claim reference in your input table. The tool does not infer links from equal amounts, product names or dates. If a credit note spans multiple claims, resolve that allocation outside this one-reference-per-note template.
Does a credit-note amount go in as a negative number?
For this review template, enter the credit amount as a nonnegative value, such as 60.00 against an expected credit of 100.00. The unresolved amount is 40.00. This convention is specific to the comparison; it is not an instruction to change signs in your accounting system.
Prepared by Supplier Desk Team · Updated . Examples are synthetic.
Who this is for
Small retail and wholesale operations teams reviewing supplier exports before changing catalog, stock or purchasing records. This is a focused review worksheet; it does not connect to your store or post transactions.
Related background
Read the source discussion or documentation. This describes the broader workflow. Use the input requirements and calculation rules above to decide whether this particular check fits your task.
Free tools with optional offline batch editions. Higher file limits, saved batch configurations and grouped report exports. No automatic store changes.