When you compare a posted reconciliation Financial Summary (or printed reconciliation report) to the QuickBooks Desktop IIF export for the same reconciliation, some payment lines can look different even when the journal is balanced.
What matches
Use these totals to confirm the export lines up with the report:
- Undeposited Funds change on the report Assets section
- Sum of the Undeposited Funds lines in the IIF (often Check + ACH)
- Other balance-sheet changes such as Accounts Receivable, Customer Deposits, and Income
When those rollups match, the IIF is reflecting the same reconciliation closeout as the report.
Why the Check line can look different
On the Financial Summary Payments section, Check is the gross check payment total for the reconciliation, and Refunds are listed separately.
In the IIF journal, the Undeposited Funds Check amount is often the check payments net of refunds for that closeout (gross Check + Refunds). That is why the Check figure on the report can be higher than the Check amount on the IIF line, while Undeposited Funds overall still matches.
How to compare
- Open the posted reconciliation Financial Summary (or the printed reconciliation report).
- Note Payments: Check, ACH, Refunds, and the Undeposited Funds asset change.
- Open the IIF and add the Undeposited Funds lines.
- Confirm Undeposited Funds and the other balance-sheet changes match before treating a single Check line difference as an imbalance.
If Undeposited Funds or another balance-sheet change still does not match after that comparison, contact Support with the reconciliation number, the report PDF, and the IIF file.