Parallax Spreadsheet Reconcile

Fictional demonstration from an actual local trial. This is not a real customer result. Local links and machine-specific paths are displayed as text.

Completed the May 1–5, 2026 UTC reconciliation and saved the working outputs.

• Five orders match. O007 is USD 10.00 below its expected net value; O999 has a USD 25.00 capture with no order in the supplied export. Their net +15.00 difference should not hide the two separate exceptions.
• USD captures of 625.00 less refunds of 20.00 and fees of 18.75 produce settlement of 586.25. EUR settlement is 48.50. Both supplied controls match exactly.
• Repeated O003/T003 export rows were removed once, the cancelled order was excluded, and O004's capture/refund pair was retained.

Files: management brief, reconciliation, exceptions, rules and checks, reusable calculation code. The output also includes normalized data, untouched raw copies, a transformation ledger, and currency totals.

Decimal calculations, row coverage, source hashes, settlement controls, and export readback were checked. Local Chromium rendered desktop, 390 px mobile, and print styles with no page overflow, broken assets, or external resource requests. The desktop and print screenshots were visually inspected. No PDF was requested or generated; the HTML includes Letter landscape print styling. No processor connection or accounting change was made.

management-brief.html

<!doctype html><html lang="en"><meta charset="utf-8"><meta name="viewport" content="width=device-width,initial-scale=1"><title>Willow Quay Parts reconciliation</title><style>body{font:16px/1.55 system-ui,sans-serif;color:#18313f;background:#f4f7f8;margin:0}main{max-width:1050px;margin:auto;padding:40px 24px;background:white}h1,h2{color:#15364c}h1{font-size:32px}th{background:#15364c;color:white}td,th{padding:9px;text-align:left;border:1px solid #ccd7dd;vertical-align:top}table{border-collapse:collapse;width:100%;font-size:13px}.table-wrap{overflow:auto}p{max-width:80ch}@media print{@page{size:Letter landscape;margin:12mm}body{background:white}main{padding:0;max-width:none}h2{break-after:avoid}thead{display:table-header-group}tr{break-inside:avoid}table{font-size:12px}.table-wrap{overflow:visible}td,th{overflow-wrap:anywhere;padding:5px}}</style><main><h1>Willow Quay Parts reconciliation</h1><p>1–5 May 2026 inclusive · UTC · Before processor fees</p><p><strong>Five orders match; O007 is USD 10 short, and O999 has a USD 25 capture with no order in this export.</strong> The USD net difference of +15 masks these two record-level exceptions. EUR matches. No cause is established for either exception.</p><h2>Order value and settlement bridge</h2><div class="table-wrap"><table><thead><tr><th>currency</th><th>expected order net</th><th>gross captures</th><th>refunds deducted</th><th>economic net</th><th>difference</th><th>fees deducted</th><th>settlement</th><th>supplied control</th><th>control residual</th></tr></thead><tbody><tr><td>USD</td><td>590.00</td><td>625.00</td><td>20.00</td><td>605.00</td><td>15.00</td><td>18.75</td><td>586.25</td><td>586.25</td><td>0.00</td></tr><tr><td>EUR</td><td>50.00</td><td>50.00</td><td>0.00</td><td>50.00</td><td>0.00</td><td>1.50</td><td>48.50</td><td>48.50</td><td>0.00</td></tr></tbody></table></div><p>USD gross captures 625.00 − refunds 20.00 − processor fees 18.75 = settlement 586.25. EUR 50.00 − 0.00 − 1.50 = 48.50. Both supplied controls match with zero residual. Matching settlement does not resolve O007 or identify O999.</p><h2>Record results</h2><div class="table-wrap"><table><thead><tr><th>order id</th><th>currency</th><th>expected net</th><th>observed economic</th><th>difference observed minus expected</th><th>status</th><th>order sources</th><th>processor sources</th></tr></thead><tbody><tr><td>O001</td><td>USD</td><td>120.00</td><td>120.00</td><td>0.00</td><td>matched</td><td>orders.csv:row 2</td><td>processor.csv:row 2</td></tr><tr><td>O002</td><td>USD</td><td>80.00</td><td>80.00</td><td>0.00</td><td>matched</td><td>orders.csv:row 3</td><td>processor.csv:row 3</td></tr><tr><td>O003</td><td>USD</td><td>150.00</td><td>150.00</td><td>0.00</td><td>matched</td><td>orders.csv:row 4</td><td>processor.csv:row 4</td></tr><tr><td>O004</td><td>USD</td><td>40.00</td><td>40.00</td><td>0.00</td><td>matched</td><td>orders.csv:row 6</td><td>processor.csv:row 6; processor.csv:row 7</td></tr><tr><td>O006</td><td>EUR</td><td>50.00</td><td>50.00</td><td>0.00</td><td>matched</td><td>orders.csv:row 8</td><td>processor.csv:row 8</td></tr><tr><td>O007</td><td>USD</td><td>200.00</td><td>190.00</td><td>-10.00</td><td>amount mismatch</td><td>orders.csv:row 9</td><td>processor.csv:row 9</td></tr><tr><td>O999</td><td>USD</td><td>0.00</td><td>25.00</td><td>25.00</td><td>counterpart-only</td><td></td><td>processor.csv:row 10</td></tr></tbody></table></div><h2>What changed and what to check</h2><p>Removed the repeated O003 order and T003 event once each; excluded the cancelled O005 order. Eight raw order rows become six eligible orders plus two documented exclusions. Nine raw event rows become eight eligible events plus one duplicate exclusion. O004 retains both its capture and signed refund.</p><p>Next: inspect O007 capture details and find the corresponding order or scope explanation for O999. Do not label either event fraud or chargeback without evidence. No refund or ledger action has been taken.</p><h2>Basis and verification</h2><p>Source dictionary defines whole-order snapshots and signed economic events. Exact order ID plus currency, zero tolerance, difference = observed − expected. Decimal arithmetic executed; export rows read back; event settlement equations and both independent supplied controls checked. Operational reconciliation only; omitted order records could change exception classification.</p></main></html>

reconciliation.csv

order_id,currency,expected_net,observed_economic,difference_observed_minus_expected,status,order_sources,processor_sources
O001,USD,120.00,120.00,0.00,matched,orders.csv:row 2,processor.csv:row 2
O002,USD,80.00,80.00,0.00,matched,orders.csv:row 3,processor.csv:row 3
O003,USD,150.00,150.00,0.00,matched,orders.csv:row 4,processor.csv:row 4
O004,USD,40.00,40.00,0.00,matched,orders.csv:row 6,processor.csv:row 6; processor.csv:row 7
O006,EUR,50.00,50.00,0.00,matched,orders.csv:row 8,processor.csv:row 8
O007,USD,200.00,190.00,-10.00,amount mismatch,orders.csv:row 9,processor.csv:row 9
O999,USD,0.00,25.00,25.00,counterpart-only,,processor.csv:row 10

exceptions.csv

exception_id,order_id,currency,expected_net,observed_economic,difference_observed_minus_expected,status,order_sources,processor_sources,explanation,next_check
EX-001,O007,USD,200.00,190.00,-10.00,amount mismatch,orders.csv:row 9,processor.csv:row 9,Cause not documented,Compare O007 order amount with capture details; seek the reason for the USD 10 shortfall
EX-002,O999,USD,0.00,25.00,25.00,counterpart-only,,processor.csv:row 10,Cause not documented,Check missing order record and source scope
EX-003,,USD,,,-150.00,exact repeated export excluded,orders.csv:row 5,,Retained orders.csv:row 4,No action unless export rule changes
EX-004,,USD,,,-150.00,exact repeated export excluded,,processor.csv:row 5,Retained processor.csv:row 4,No action unless export rule changes
EX-005,,USD,,,-90.00,cancelled order excluded: no collectible value,orders.csv:row 7,,Cancelled has no collectible value,No action unless export rule changes

rules-and-checks.md

# Rules and executed checks

- Window: 1–5 May 2026 inclusive, UTC; order dates and event dates from the supplied exports.
- All amounts remain in source currency. Gross includes tax and shipping. Refund signs normalized once.
- Zero tolerance; difference is observed economic amount minus expected net order value.
- Exact repeated export rows excluded; no fuzzy matches. Source line references use physical CSV rows, with header as row 1.
- Cancelled O005 excluded; other paid/partially refunded orders retained.
- Whole-order keys unique after deduplication; multiple O004 events aggregated without multiplying order value.
- Raw source copies and SHA-256 retained. Every original hash rechecked unchanged.
- Per-event settlement equation checked. Reconciliation aggregate independently compared to event sums. Supplied USD and EUR settlement controls matched with zero residual.
- Raw USD order net 830.00 minus repeated order 150.00 minus cancelled collectible 90.00 = 590.00 eligible. Raw USD processor economic 755.00 minus duplicate 150.00 = 605.00. Raw USD fees 23.25 minus duplicate 4.50 = 18.75. Raw USD settlement 731.75 minus duplicate 145.50 = 586.25. EUR unchanged.
- Export readback row counts checked: 7 reconciliation rows, 5 exception/exclusion entries, 6 normalized orders, 8 normalized events.
- No formula-like untrusted label occurs in this normal input.
- Browser and print checks are recorded separately in render-checks.json.