import json, csv from decimal import Decimal as D inv = json.load(open('output/invoices.json')) po = list(csv.DictReader(open('inputs/purchase-orders.csv'))) for r in inv: sub = sum(D(str(l['qty'])) * D(l['unit_price']) for l in r['line_items']) tax = (sub * D('0.12')).quantize(D('0.01')) tot = sub + tax + D(r['shipping']) pos = [p for p in po if p['po'] == r['po']] posub = sum(D(p['qty']) * D(p['unit_cad']) for p in pos) potot = posub + (posub * D('0.12')).quantize(D('0.01')) + D(r['shipping']) print(r['invoice_number'], 'sub', sub, r['subtotal'], 'tax', tax, r['tax'], 'total', tot, 'stated', r['total'], 'diff', D(r['total']) - tot, '| PO basis total', potot, 'bank PO', {p['bank_suffix'] for p in pos}, 'inv', r['bank_account_suffix']) for l in r['line_items']: p = [p for p in pos if p['item'] == l['description']][0] print(' ', l['description'], l['qty'], p['qty'], l['unit_price'], p['unit_cad'])