Reconcile bank vs QBO
Pull a QBO register, drop in the matching bank Excel (and optional credit-card master sheets — add one per card), and Iris compares month-by-month. Walks every mismatch — duplicates, missing entries, wrong-direction transfers — and checks each bank→credit-card payment across all loaded cards to confirm the transfer landed. Produces copy-paste action charts for Iris's add / delete / void / reclass tools, plus opening / closing JEs to make the balances agree.
No QuickBooks client connected. Pick a client in the sidebar (or connect a new one) before reconciling.
1Setup
Fiscal year — set in the topbar
Pull register from QuickBooks
Source files
Drop QBO register .xls/.xlsx here
Or pull directly from QBO above
Drop bank source .xls/.xlsx here
Can contain multiple account sheets
Credit-card statements — optional, add one or more master sheets for transfer verification
Drop CC master .xls/.xlsx — one or more (optional)
Add every card's master sheet — each bank→CC payment is checked across all of them
2Year overview
3Month detail
4Action charts
Each row is a copy-paste block for the matching Iris tool. Click to expand the one you're working on.