The invoice against the quote you accepted
See changed prices and quantities, unmatched lines, duplicate identifiers and recorded totals that need a closer look before you decide what to pay.
The result, on the sample
This is the finished result, made on this page from the sample file below. It is not a picture of one.
5 comparison exceptions and 1 arithmetic findings to inspect
- 4 quote rows and 4 invoice rows. Identifiers, quantities and units retain their exact text.
- Findings are differences or unresolved evidence, not proof of an overcharge. No supplier is contacted and no payment is made.
- USD, non-negative quantities/prices, and exact units only. Taxes, shipping, discounts, currency conversion and refunds are outside this report.
- Line references count data records, excluding the header. Multiline cells may occupy several physical file lines.
- Quote SHA-256: 29714f91e6251ce37d8a8b409020384a313762a3a68bd6aa4f2afe46b55a97a7. Invoice SHA-256: 6d048ccd08e09ab8746f40ca9e8321be2167eff1919e601cdae1a60ad9eb1288.
- Both recorded line totals are compared and separately checked against quantity × unit price.
Every identifier, with its source values
| Item | Comparison | Quote source | Invoice source | Quote quantity | Invoice quantity | Quote unit | Invoice unit | Quote unit price (USD) | Invoice unit price (USD) | Unit-price difference (not a recovered amount) |
|---|---|---|---|---|---|---|---|---|---|---|
| A | difference_flagged | quote data row 1 | invoice data row 1 | 2 | 2 | each | each | 10.00 | 12.00 | $2.00 |
| B | incompatible_units | quote data row 2 | invoice data row 2 | 1 | 1 | box | each | 30.00 | 30.00 | not comparable |
| C | difference_flagged | quote data row 3 | invoice data row 3 | 4 | 4 | each | each | 2.00 | 2.00 | $0.00 |
| D | quote_only | quote data row 4 | 1 | each | 5.00 | not comparable | ||||
| E | invoice_only | invoice data row 4 | 1 | each | 4.00 | not comparable |
Line extension checks
| Input | Data row | Item | Finding | Explanation |
|---|---|---|---|---|
| invoice | 3 | C | line_extension_mismatch | Recorded 9.00; exact quantity × unit price is $8.00. Discounts, tax and shipping are not inferred. |
The sample it came from — Four quoted items against four invoice rows, with a price change, a unit mismatch, a total discrepancy and missing items
quote.csv — The accepted quote or order
item,quantity,unit,unit_price,line_total A,2,each,10.00,20.00 B,1,box,30.00,30.00 C,4,each,2.00,8.00 D,1,each,5.00,5.00
invoice.csv — The supplier invoice
item,quantity,unit,unit_price,line_total A,2,each,12.00,24.00 B,1,each,30.00,30.00 C,4,each,2.00,9.00 E,1,each,4.00,4.00
Sample data.
Run it on your own file
Pick a file and it runs here, in this page.
Your files remain in this browser. Nothing is uploaded, and closing the tab discards the working data. Downloads you explicitly save remain on your device.
Running your own file needs scripting turned on. The result above, and every word on this page, do not.
What it does
Shows both source values and source data-row references for every identifier.
It will not A flagged difference is not proof of an overcharge or recovered money.
Checks supplied line totals against exact quantity times unit price.
It will not Fractional cents stay unresolved; tax, shipping and discounts are not guessed.
What it will and will not do
- Two CSV files or explicitly tab-separated spreadsheet rows, each with headers
- Up to 5,000 rows and 2 MB per input.
- USD only; non-negative quantities and prices. Choose and confirm the columns shown in the preview.
- Identifiers, units and quantities are compared exactly as text; no fuzzy matching or unit conversion.
- PDF and XLSX are not supported. Export to CSV or paste tab-separated cells.
Your version
Three questions about the work, not about you. All optional, and there is no account.
If you want us to do it
$0.00 version 2026-09-16
This bounded local report is free. No live paid extension is implied by this page.
A price we have guessed at. Nobody has bought this, and the version is on the record.
These reports are usable now within the limits above. Larger paid or recurring scopes are not sold by this page.