Reconcile Receipts with Your Bank or Card Statement
Find missing expense receipts before close-out without handing bank passwords to third-party aggregators. Load your statement CSV locally and compare every charge against your saved IndexedDB receipts or any uploaded spreadsheet immediately inside your browser tab.
- Zero bank logins or OAuth
- ±3-day posting lag tolerance
- 100% browser memory
How Local Statement Reconciliation Categorizes Charges
Credit-card exports abbreviate vendor names into uppercase payment strings while receipts print storefront names and pre-tip subtotals. Pairing deterministic settlement windows with minor-unit tolerances catches matches that naive Excel VLOOKUP formulas miss.
| Reconciliation Status | Matching Rule Applied Locally | Next Step Action |
|---|---|---|
| Matched | Exact minor-unit total match within the chosen +/- day settlement window | Ready to export in CSV or compile into expense reports |
| Possible | Within Tip/FX % tolerance inside the posting window; prioritizes vendor word overlap | Confirm tip/FX delta against your paper slip or card line |
| Missing | No unused receipt found matching amount and date window | Launch Missing Receipt Form or scan bill |
| Unmatched Cash Receipt | Receipt exists locally but was paid in cash or on another card | Track separately under private expense books |
Zero-Bank-Login Privacy Guarantee
- Download a monthly CSV export from your bank or corporate card portal (both single
Amountand separateDebit / Creditcolumns conforming to RFC 4180 CSV are supported). - Click Match Saved Expense Book to read records stored directly in browser IndexedDB without network transfers, remote syncing, or automated bank connections, or compare any two CSV/XLSX exports offline.
- Download your complete audit status sheet as a formula-safe UTF-8 CSV or open pre-filled affidavits for every missing slip before book close—verify how offline matching stays isolated on How Privacy Works.
Common Statement Mismatch Causes & How to Resolve Them
Real credit-card exports rarely match paper bills penny-for-penny on date and text string. Hotels often authorize an initial room deposit days before checkout and settle final folio taxes later, foreign cafes settle under dynamic currency conversion with 1%–3% card spread, and weekend restaurant charges post on Monday under an abbreviated parent processor name. Our CSV reader handles both single signed Amount columns and separate Debit/Credit columns while automatically skipping bill-payment credits.
Using our +/- 3-day posting lag window alongside +/- 10% tip tolerance highlights likely matches cleanly without false confidence. Once unmatched bank lines stand out as Missing, you can group recovered bills in Combine Receipts to PDF, organize folders with our batch receipt file renamer, or read our CSV reconciliation schema guide.
Frequently asked questions
Why do receipt dates often miss bank statement posting dates by 1 to 3 days?
Card networks authorize a purchase when you pay at the register, but merchants settle batches overnight or after weekends. Setting the posting-lag window to +/- 3 days cleanly reconciles real merchant settlement delays.
Does matching receipts with a bank CSV require connecting my bank login?
No. Unlike Plaid-connected trackers, nothing asks for bank credentials or API tokens. Export a plain CSV statement from your bank portal and run the comparison inside your browser with zero uploads.
How are restaurant tips or foreign currency rounding handled?
Set Tip / FX Tolerance to +/- 2% for slight currency conversion drift or +/- 10% to 25% when food pre-authorizations settled higher after adding gratuity; those rows flag as Possible for quick human review.
What happens if a single statement amount matches two identical receipts?
Matching uses a strict one-to-one greedy pairing sorted by exact amount match, merchant text similarity, and nearest date, so one receipt can never reconcile two separate charges.
What should I do when statement charges show as Missing Receipt?
Either locate and scan the missing slip into /scan, or click Missing Form right on the row to launch the Missing Receipt Declaration generator pre-filled with that exact vendor, date, and amount.