The quick read
Key points
- Use one source account per file.
- Replace formulas with reviewed values in a copy.
- Check signs, dates and imported totals.
Keep the original workbook
Create a working copy and identify one source account and statement period. Keep opening balances, subtotals and summary rows outside the transaction list. The importer reads transaction rows, not a complete workbook model.
Map the four columns
Use Date for the statement transaction date, Description for source text, Amount for signed dollars and Memo for an optional note. Combine separate debit and credit source columns carefully into a single signed amount. Compare refunds and reversals with the statement.
Use values and a supported format
Export plain CSV or prepare XLSX values. Formula cells are rejected rather than calculated. Keep the file within the documented upload bounds and use the template headers exactly. An active paid portfolio can download the CSV layout from the template page.
Review before expanding
Try a small date range, inspect imported values and compare totals with the source. Check automatically booked rows if rules or loan templates match. Once the sample agrees, continue with the remaining records and reconcile the complete statement.
Transaction breakdown
Confirm the treatment of your own transactions with your accountant.
| Source field | IQ column | Review |
|---|---|---|
| Posting date | Date | Confirm date format and year |
| Payee or statement text | Description | Keep meaningful source wording |
| Debit and credit columns | Amount | Combine into one correctly signed value |
| Optional reference | Memo | Exclude secrets and unrelated personal data |
Before you finish
- Use one source account per file.
- Replace formulas with reviewed values in a copy.
- Check signs, dates and imported totals.
Keep your next step simple.
Use the product guide for the app workflow, or contact support with your question. Bookkeeping reports are not tax advice; review filing decisions with a qualified professional.