Reconcile payroll exports and review only the exceptions.
Compare payroll, HR, finance, or general-ledger exports using the business key and rules that fit your process. MatchDock keeps amount differences, missing employees, duplicates, and invalid keys visible without uploading spreadsheet contents to MatchDock servers.
The demo is synthetic and runs through the real local reconciliation flow.
Payroll reconciliation
Employee ID · Wage Type · Effective Date
Results summary
- Matched
- 23
- Within date tolerance
- 2
- Differences
- 2
- Only Source A
- 2
- Only Source B
- 2
- Duplicate or ambiguous
- 1 group
- Invalid Source A keys
- 1
Selected exception
Employee 1026 · Wage type 1000 · 2026-08-26
| Field | Payroll export | Finance export | Outcome |
|---|---|---|---|
| Amount | 500.00 | 550.00 | Difference |
Employee ID alone may not identify a payroll line.
The same employee can have several wage types and effective dates. A useful payroll key may combine employee ID, wage type, and effective date, while amount, cost center, or other values remain compare fields.
MatchDock lets you model that distinction explicitly instead of comparing rows by position or quietly using amount to decide which records belong together.
Employee ID
1026
Key field
Wage type
1000
Key field
Effective date
2026-08-26
Key field
Amount
500.00 ↔ 550.00
Compare field
Normalize identifiers and dates with visible rules.
000123 ↔ 123
after explicit leading-zero normalization.
01 Aug ↔ 02 Aug
when a unique date-key match falls inside the allowed tolerance.
500.00 ↔ 550.00
as an amount difference outside the configured rule.
Missing or duplicated employee lines
remain separate exceptions.
MatchDock does not certify payroll correctness. It produces an explainable comparison of the exports and rules you provide.
Move from scanning whole files to reviewing a bounded exception list.
- 01
Add the two payroll-related exports.
- 02
Map employee, wage type, date, amount, and any other relevant fields.
- 03
Define the composite key and explicit normalization or tolerance rules.
- 04
Run locally, inspect the exceptions, and export the result workbook.
Explore the actual product flow with synthetic payroll data.
The payroll demo uses the production CSV parser, Web Worker, deterministic reconciliation engine, results workspace, and local XLSX export. Its data is bundled synthetic data; its results are not a static screenshot or precomputed marketing example.
Your spreadsheet contents stay in your browser.
MatchDock parses and reconciles your files locally. Spreadsheet contents are not uploaded to MatchDock servers, and Excel exports are generated in your browser.
Ready to review the exceptions?
Start with two Excel or CSV exports. Choose the records that should match, apply explicit rules, and keep uncertain outcomes visible.