Free guide · Practice answer key
Answer key - keep out of the workflow input
12 distinct transactions, 3 cities, no missing locations or duplicates.
Baseline
12 distinct transactions, 3 cities, no missing locations or duplicates.
| City | IDs | Net CAD |
|---|---|---|
| Toronto | EXP-001 through EXP-004 | 642.00 |
| Ottawa | EXP-005 through EXP-008 | 474.00 |
| Montreal | EXP-009 through EXP-012 | 558.00 |
| Total | 12 transactions | 1,674.00 |
Categories: lodging 1,090.00; local transport 96.00; meals 168.00; meeting rooms 320.00.
With optional exceptions
15 source records, 14 distinct accounting entries after removing one duplicate. EXP-003 occurs in two source files but counts only once; retain both references. ADJ-001 is a separate -40.00 refund against EXP-009, not a duplicate. EXP-013 is a 22.00 meal with no location.
Toronto 642.00; Ottawa 474.00; Montreal 518.00. Mapped total: 1,634.00. Unlocated: 22.00. Grand total: 1,656.00. Summing all source records without deduplication incorrectly gives 1,720.00.
Pass checks
- Every distinct entry has its source filename and page 1.
- Dates, IDs and amounts match the PDFs.
- Clicking each city shows only its transactions, including the Montreal refund in the second run.
- Only city-centre markers are used; no merchant-address precision is implied.
- Duplicate and unlocated entries are explicitly reported.
- Grand total includes the unlocated expense and reconciles to mapped total plus unlocated total.
Detailed expected records are in answer-key.json.
Source records
| ID | Date | Merchant | Location | Signed CAD | Source, page | Duplicate? |
|---|---|---|---|---|---|---|
| EXP-001 | 2026-09-14 | Harbour Lane Lodge | Toronto, Ontario, Canada | 420.00 | 01-toronto.pdf, page 1 | No |
| EXP-002 | 2026-09-14 | Cedar Cab | Toronto, Ontario, Canada | 38.00 | 01-toronto.pdf, page 1 | No |
| EXP-003 | 2026-09-15 | Copper Table | Toronto, Ontario, Canada | 64.00 | 01-toronto.pdf, page 1 | No |
| EXP-004 | 2026-09-15 | North Desk Rooms | Toronto, Ontario, Canada | 120.00 | 01-toronto.pdf, page 1 | No |
| EXP-005 | 2026-09-16 | Canal House Lodge | Ottawa, Ontario, Canada | 310.00 | 02-ottawa.pdf, page 1 | No |
| EXP-006 | 2026-09-16 | Maple Cab | Ottawa, Ontario, Canada | 26.00 | 02-ottawa.pdf, page 1 | No |
| EXP-007 | 2026-09-17 | Birch Kitchen | Ottawa, Ontario, Canada | 48.00 | 02-ottawa.pdf, page 1 | No |
| EXP-008 | 2026-09-17 | Summit Desk Rooms | Ottawa, Ontario, Canada | 90.00 | 02-ottawa.pdf, page 1 | No |
| EXP-009 | 2026-09-18 | Orchard House Lodge | Montreal, Quebec, Canada | 360.00 | 03-montreal.pdf, page 1 | No |
| EXP-010 | 2026-09-18 | River Cab | Montreal, Quebec, Canada | 32.00 | 03-montreal.pdf, page 1 | No |
| EXP-011 | 2026-09-19 | Elm Kitchen | Montreal, Quebec, Canada | 56.00 | 03-montreal.pdf, page 1 | No |
| EXP-012 | 2026-09-19 | East Desk Rooms | Montreal, Quebec, Canada | 110.00 | 03-montreal.pdf, page 1 | No |
| EXP-003 | 2026-09-15 | Copper Table | Toronto, Ontario, Canada | 64.00 | 04-optional-exceptions.pdf, page 1 | Yes |
| ADJ-001 | 2026-09-20 | Orchard House Lodge | Montreal, Quebec, Canada | -40.00 | 04-optional-exceptions.pdf, page 1 | No |
| EXP-013 | 2026-09-20 | Juniper Cafe | Not recorded | 22.00 | 04-optional-exceptions.pdf, page 1 | No |