Zero Bank Credentials · ±3-Day Lag Matcher · Updated 2026-11-18

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
Drop a bank or credit-card statement CSV, then match against saved Expense Book records or an uploaded receipt CSV. (Receipt source: Not loaded yet)

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 StatusMatching Rule Applied LocallyNext Step Action
MatchedExact minor-unit total match within the chosen +/- day settlement windowReady to export in CSV or compile into expense reports
PossibleWithin Tip/FX % tolerance inside the posting window; prioritizes vendor word overlapConfirm tip/FX delta against your paper slip or card line
MissingNo unused receipt found matching amount and date windowLaunch Missing Receipt Form or scan bill
Unmatched Cash ReceiptReceipt exists locally but was paid in cash or on another cardTrack separately under private expense books

Zero-Bank-Login Privacy Guarantee

  1. Download a monthly CSV export from your bank or corporate card portal (both single Amount and separate Debit / Credit columns conforming to RFC 4180 CSV are supported).
  2. 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.
  3. 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.

Bookkeeping audit reminder: Heuristic amount-and-date matching helps locate missing paperwork faster but can pair two same-day identical charges incorrectly if both come from different stores. Always verify statement descriptions, dates, tax amounts, and invoices against original bank statements and paper receipts before closing books or claiming deductions, per IRS recordkeeping standards.

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.