Dual-Source Excel Financial Ledger Reconciliation
Combine two disparate workbooks (Sales Ledger vs Bank Settlement), strip currency symbols, join on invoice IDs, and isolate reconciliation variances in 42ms.
Finance teams frequently receive two disconnected workbooks every month: internal sales invoices (with messy strings like "$1,450.00" and trailing whitespace) and third-party bank clearance records. Manual VLOOKUP in Excel freezes on 50,000+ rows, fails on formatting mismatches, and exposes confidential revenue figures to third-party cloud tools.
RTIO imports both Excel workbooks locally via DuckDB-WASM, strips currency symbols and whitespace, joins on "invoice_id", computes the exact discrepancy variance in a new derived column, and filters for accounting audits without sending a single byte outside the browser.
| invoice_id | client_name | gross_amount_str | invoice_date |
|---|---|---|---|
| INV-2024-001 | Apex Logistics | $14,250.00 | 09/15/2024 |
| INV-2024-002 | BioHealth Labs | $8,120.50 | 09/16/2024 |
| INV-2024-003 | Crestline Media | $22,000.00 | 09/17/2024 |
| INV-2024-004 | DataPoint Inc | $3,400.00 | 09/18/2024 |
| invoice_ref | cleared_amount_str | settlement_date | fee_deducted |
|---|---|---|---|
| INV-2024-001 | $14,250.00 | 2024-09-17 | $0.00 |
| INV-2024-002 | $8,095.50 | 2024-09-18 | $25.00 |
| INV-2024-003 | $22,000.00 | 2024-09-19 | $0.00 |
| INV-2024-004 | $3,400.00 | 2024-09-20 | $0.00 |
| invoice_id | client_name | gross_amount | cleared_amount | reconciliation_variance New | audit_status New | settlement_days New |
|---|---|---|---|---|---|---|
| INV-2024-001 | Apex Logistics | 14250 | 14250 | 0 | RECONCILED | 2 |
| INV-2024-002 | BioHealth Labs | 8120.5 | 8095.5 | 25 | DISCREPANCY_FLAG | 2 |
| INV-2024-003 | Crestline Media | 22000 | 22000 | 0 | RECONCILED | 2 |
| INV-2024-004 | DataPoint Inc | 3400 | 3400 | 0 | RECONCILED | 2 |