Excel Invoice Reconciliation
Budget: $10 – $30 USD
Two small Excel files—each under 20 rows—need a clean, side-by-side reconciliation. The only columns that matter are the invoice number (Document No) and the corresponding amount; any other columns can be ignored if they appear.
Process
• Cross-check every invoice number between the two files.
• When the number exists in both sheets, compare the amounts.
– If the amounts match, no action needed.
– If they differ, list the invoice number with both amounts on a new worksheet named “Differences”.
• When a number is present in only one file, add it to the same “Differences” sheet and label it “Missing in File 1” or “Missing in File 2”.
Deliverable
An Excel workbook containing the consolidated “Differences” worksheet that clearly shows:
1. Invoice numbers with mismatched amounts plus both values.
2. Invoice numbers missing from either file, properly tagged.
No macros are required as long as the results are accurate and easy to audit, though a formula-based or Power Query approach is welcome if it keeps the workbook lightweight and transparent.
Process
• Cross-check every invoice number between the two files.
• When the number exists in both sheets, compare the amounts.
– If the amounts match, no action needed.
– If they differ, list the invoice number with both amounts on a new worksheet named “Differences”.
• When a number is present in only one file, add it to the same “Differences” sheet and label it “Missing in File 1” or “Missing in File 2”.
Deliverable
An Excel workbook containing the consolidated “Differences” worksheet that clearly shows:
1. Invoice numbers with mismatched amounts plus both values.
2. Invoice numbers missing from either file, properly tagged.
No macros are required as long as the results are accurate and easy to audit, though a formula-based or Power Query approach is welcome if it keeps the workbook lightweight and transparent.