Issued invoices
The complete list you expect
| Invoice | Customer | Amount |
|---|---|---|
| INV-810 | Bramble Ltd | €480 |
| INV-811 | Port Studio | €730 |
| INV-812 | Fennel GmbH | €215 |
Spreadsheet reconciliation
Find records that exist in one spreadsheet but not the other.
Use an order number, invoice number, email, SKU, or other stable identifier to check whether every row in your main file exists in a second file. RowPair separates clean matches from records that need attention.
- Match byInvoice number
- AddPosted date
- GetA review showing which issued invoices were posted
Ready-to-use example
Try this job with a small workbook first.
The workbook contains a Main file sheet, a Lookup file sheet, and the expected result. Upload it in both file slots and select the two source sheets when RowPair asks.
When this helps
A focused tool for a common spreadsheet job.
- Reconciling invoices against an accounting export
- Checking that orders reached a fulfillment system
- Finding contacts missing from a CRM import
- Catching duplicate identifiers before a report is sent
Worked example
Two source files become one reviewable result.
The examples below show the fields that matter; your files can contain additional columns and use different column orders.
Accounting export
The system you are checking
| Document no. | Posted | Ledger |
|---|---|---|
| INV-810 | 2026-08-09 | Sales |
| INV-812 | 2026-08-10 | Sales |
| INV-813 | 2026-08-10 | Sales |
Review preview
INV-811 needs attention
| Invoice | Customer | Posted | Match |
|---|---|---|---|
| INV-810 | Bramble Ltd | 2026-08-09 | Matched |
| INV-811 | Port Studio | — | No match |
| INV-812 | Fennel GmbH | 2026-08-10 | Matched |
Step by step
How to do it in RowPair.
- 01
Start with the expected list
Make the file that should contain every required record your main spreadsheet.
- 02
Add the system export
Use the second spreadsheet as the lookup list you want to check against.
- 03
Match stable identifiers
Connect invoice number to document number rather than comparing descriptions or row positions.
- 04
Open Needs review
Inspect every missing, blank, or ambiguous identifier and resolve exceptions before exporting your report.
Before you export
Checks that prevent a misleading merge.
Missing is directional
The main file defines what you expect to find. Swap the files and run again if you also need records that exist only in the second file.
Blank identifiers
A row with no invoice number cannot be matched reliably and is kept in the review list.
Duplicates are not a clean match
Two lookup rows with the same identifier are shown as ambiguous so an accidental duplicate cannot pass unnoticed.
Free · no account · local processing
Use the spreadsheets you already have.
Nothing is uploaded. Review the result in your browser, then download Excel or CSV.
Open the spreadsheet matcher