Data workflow
Compare two files and review the exceptions first.
Upload two CSV or XLSX files, confirm the match key and fields to compare, then generate a reconciliation workbook with exact matches, mismatches, duplicates, and only-in-each-file rows.
WorkbookWise preview
Exception workbook
Item
Sales RegisterDetail
Ledger ExportStatus
Match KeyItem
INV-001Detail
INV-001Status
ExactItem
INV-002Detail
INV-002Status
Amount mismatchProblem
Why this feature exists
Teams often need to compare two lists such as sales vs ledger, bank export vs payment register, or stock count vs system export. Manual VLOOKUPs miss changed amounts, duplicate references and rows that exist only on one side.
Approach
How WorkbookWise handles it
Reconcile compares two uploaded files using confirmed match keys and comparison fields. It separates exact matches, likely matches, value mismatches, only-in-A, only-in-B and duplicate candidates into a reviewable workbook.
Outcomes
What users should get from it
Who it is for
Built around real workbook owners
Accountants and finance teams
Compare sales registers, ledgers, bank exports and supplier statements.
Operations teams
Check system exports against physical or partner-provided files.
Business owners
Find missing invoices, mismatched payments or duplicate records quickly.
Admin teams
Compare fee, attendance or collection lists without writing formulas.
Common workflows
The jobs this page should answer
Happy path
From public page to useful output
Upload two files
Provide the two CSV or XLSX files that need to be compared.
Confirm match key
Choose the safest key such as invoice number, bill number, reference number or SKU.
Pick comparison fields
Select amount, date, status or other fields that should match between files.
Review exceptions
Check mismatches, duplicates and only-in-one-file rows before saving.
Save output or process
Download the validated workbook or save the setup for the next reconciliation cycle.
Product example
Sales Ledger Reconciliation
A reconciliation workbook should make exceptions obvious before the user checks matched rows.
Included
What the flow covers
Trust notes
What it does
Core capabilities
Compare two CSV or XLSX files with deterministic one-to-one matching.
Confirm match keys such as invoice number, reference number or customer identifier.
Review mismatches, duplicates and only-in-A/B rows before using the output.
Save repeatable reconciliation processes for recurring monthly checks.
FAQ
Frequently asked questions
Can it reconcile more than two files?
V1 supports two-file reconciliation. Combine files first when many sources need to become one side.
Does it support one-to-many matching?
V1 focuses on deterministic one-to-one matching. Partial payments and many-to-one matching are outside launch scope.
Can I adjust amount tolerance?
Yes. The app exposes amount and date tolerance controls before previewing the workbook.
Can I run the same reconciliation again?
Yes. Save the process after a successful run and reuse the match setup with new files.
Is this the same as Combine & Clean?
No. Combine & Clean creates one master file from many inputs. Reconcile compares two files and highlights differences.
Related features
Continue exploring WorkbookWise
Combine & Clean
Upload multiple CSV or XLSX files, let WorkbookWise detect real tables and matching columns, review uncertain mappings, then save one validated workbook with source traceability.
My Workbooks
My Workbooks keeps custom and upgraded files separate from the public template gallery, with download, delete, share and export paths.
Fix My Excel
Upload an Excel or CSV file, keep the original rows, and create a cleaner workbook with mapped columns, formulas, dropdowns, summaries and help notes. Use My Data is the template-specific version when you already picked a target workbook.
Ready to use Reconcile?
This page explains the workflow in detail. The app is where the user creates, downloads, saves or exports the workbook.