Upload the two transaction files
Accepted here: XLSX, CSV, TSV, text-based PDFs, and DOCX. Scanned PDFs and image files need OCR first; use the local app for image OCR. Check every extracted transaction against its source.
How the colors work
GREEN exact date and amount match AMBER same amount with date difference / review RED unmatched items.
Matching is one-to-one by amount and date. It does not post journal entries, infer accounting treatment, or replace review. Make bank and ledger signs consistent before upload.
For privacy, use sample or redacted statements. Uploaded contents are sent to Vercel for processing and are not saved by this app.
Prime Broker vs Custodian — cash and positions
Upload four CSV or Excel files. Cash files need Currency and Cash Balance. Position files need a security ID (ISIN, CUSIP, SEDOL, ticker or security ID), Quantity, and Market Value. Currency and security description are recommended. Duplicate currency/security rows are aggregated.
GREEN = within tolerance; AMBER = same key but value break; RED = missing currency/security. Use synthetic or redacted data in a hosted demo and verify outputs against source statements.