Reconcile credit card vs QBO
Pull a QBO credit-card register, drop in the matching credit-card statement master Excel, and (optionally) the bank master Excel to confirm payments came from the chequing account. Iris compares month-by-month and produces inline action charts 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 credit-card register .xls/.xlsx here
Or pull directly from QBO above
Drop credit-card master Excel here
The MASTER-CC statement file from Iris
Bank master — optional · confirms CC payments came from the bank
Drop bank master Excel (optional)
Confirms CC payments came from the bank / chequing account
Saves the QBO register, the Excel sheets you loaded, and the reconciliation into one file to send for inspection.
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.