Supplier reconciliation Excel template and sample files
Use the two fictional CSV files below to inspect the expected inputs or run a complete local reconciliation. SupplierRecon generates the Excel workpaper from the same engine used for your files; no manually prepared result workbook is presented as product output.
What the sample demonstrates
The fictional Northshore-style scenario includes a unique exact invoice, a one-cent amount difference, one statement invoice represented by two AP rows, and a credit absent from the AP file. It is designed to show Exact match, Needs review and Unmatched treatment without using a real person, customer or operating company.
Input field guide
| Field | Required? | Purpose | Handling note |
|---|---|---|---|
| Reference | Yes | Invoice, credit or document identifier | Keep long identifiers as text; scientific notation can be blocking. |
| Amount, or debit and credit | Yes | Comparable signed transaction value | Confirm decimal, grouping, sign and debit/credit direction. |
| Date | Recommended | Period and date-window evidence | Missing or invalid dates create warnings; where both dates exist, the window protects Exact matches. |
| Currency | Recommended | Prevents cross-currency matching | A confirmed default can fill a missing mapped currency column. |
| Supplier | Required for multi-supplier AP exports | Confirms run scope and filters AP rows | Multi-supplier mode blocks missing or out-of-scope AP supplier values. |
| Type and description | Optional | Review context and similar-text ranking | Text similarity can rank a candidate but never creates an Exact match. |
Supported file limits
- CSV: up to 25 MB and 200,000 parsed data rows.
- XLSX: up to 10 MB and 50,000 parsed data rows.
- Unsupported: PDF, images, OCR, XLSM, ODS, macros, encrypted workbooks and legacy Excel containers.
The generated Excel workpaper
The current exporter creates eleven worksheets:
- Summary
- Rules & Parameters
- Exact Matches
- Reviewed Matches
- Unmatched Statement
- Unmatched AP Ledger
- Data Warnings
- Exceptions
- Source A Reconciled
- Source B Reconciled
- Run Manifest
Before download, the export worker reopens the workbook and checks the required sheet set, row classifications, group identifiers, control totals and manifest values. This verifies the generated file's internal structure; it does not make the workbook tamper-proof or approve its accounting content.