"""Reconciliation checks for Task 9. Run from the workspace root: python output/verify-calculations.py Reads inputs/purchase-orders.csv; invoice figures below were transcribed from inputs/invoice-01.png and inputs/invoice-02.png (both fully legible). Uses exact Decimal arithmetic; stdlib only.""" import csv from decimal import Decimal as D po = {} with open('inputs/purchase-orders.csv', newline='') as f: for r in csv.DictReader(f): po[(r['po'], r['item'])] = r inv1_lines = [('Workshop handbooks', 80, D('7.50'), D('600.00'))] inv2_lines = [('Microphone rental', 3, D('85.00'), D('255.00')), ('Stand rental', 2, D('15.00'), D('30.00'))] def check(name, poid, lines, sub, tax, ship, total, bank): print(f'--- {name} ({poid}) ---') calc_sub = D('0') for desc, q, u, amt in lines: ext = D(q) * u print(f'{desc}: qty {q} x {u} = {ext}; printed {amt}; match={ext==amt}') calc_sub += ext p = po[(poid, desc)] print(f' PO qty {p["qty"]} unit {p["unit_cad"]} -> qty_match={q==int(p["qty"])}, price_match={u==D(p["unit_cad"])}') calc_tax = (calc_sub * D('0.12')).quantize(D('0.01')) calc_total = calc_sub + tax + ship print(f'subtotal printed {sub} calc {calc_sub} match={sub==calc_sub}') print(f'tax printed {tax} calc(12% merchandise) {calc_tax} match={tax==calc_tax}') print(f'total printed {total} calc {calc_total} diff={total-calc_total}') banks = {p['bank_suffix'] for k, p in po.items() if k[0]==poid} print(f'bank printed {bank} PO {banks} match={bank in banks}') po_sub = sum(int(p['qty'])*D(p['unit_cad']) for k,p in po.items() if k[0]==poid) po_total = po_sub + (po_sub*D('0.12')).quantize(D('0.01')) print(f'PO-based merchandise {po_sub}, PO-based total (no shipping) {po_total}') check('Cedar Print 000742', 'PO-1042', inv1_lines, D('600.00'), D('72.00'), D('20.00'), D('692.00'), '0412') check('Harbour AV 001083', 'PO-1043', inv2_lines, D('285.00'), D('34.20'), D('0.00'), D('329.20'), '8891')