Skip to Content
Team PortalPayments & AccountingImport and Reconcile Bank Transactions

Import and Reconcile Bank Transactions

Use a financial account’s register to bring in statement activity, decide what each transaction means, and reconcile the books to a completed statement.

Importing a file does not post or reconcile its transactions. Imported rows are staged for review until you accept them, and reconciliation remains a separate proof that the selected book activity agrees with the statement.

Before You Start

  • Add the financial account and confirm its purpose.
  • Download an OFX, QFX, QIF, or CSV file from the bank or card provider.
  • For the first reconciliation, know the statement’s beginning and ending balances.

Open the Account Register

  1. Open Financial > Banking > Financial accounts.
  2. Select the bank or credit-card account.
  3. Review the account name, masked identifier, and current book balance.
Owner Trust Checking account register with its book balance, Reconcile link, Import transactions button, and For review tab.
Open the account register to import activity, review transactions, or begin reconciliation.

Import Transactions

  1. Select Import transactions.
  2. Choose the OFX, QFX, QIF, or CSV file.
  3. For a CSV, confirm which columns contain the date, description, amount, and other required values.
  4. Select Import with this mapping.

AveryIQ remembers a confirmed CSV layout for later exports from the same account. Review the mapping again whenever the bank changes its export format.

CSV mapping dialog with date, description, memo, amount, and date-order fields and a three-row transaction preview.
Confirm the CSV mapping against the sample rows before importing the statement.

Review What Each Transaction Means

Imported transactions appear under For review. For each row, choose the appropriate treatment:

  • Add to create new book activity with a category and, when applicable, a property
  • Match to connect the bank movement to one or more entries already on the books
  • Transfer when money moved between two of your financial accounts
  • Exclude for a duplicate or a row that should not become book activity
  • Split when one bank transaction belongs to several categories

Review suggestions rather than accepting them blindly. Confirm the amount, date, counterparty, category, property, matched entries, and transfer account.

For review register with imported transactions and Add, Match, Transfer, Exclude, category, property, Split, and Accept controls.
Assign the correct accounting treatment to every imported transaction.
Imported owner contribution with Transfer selected and a destination-account control visible.
Transfer opens an account selector so money moving between your own accounts is not recorded as income or expense.

Accept Reviewed Transactions

After assigning a decision, select the reviewed rows and choose Accept. Acceptance posts new entries or records the selected match, transfer, split, or exclusion. Accepted rows leave the review queue and appear under Cleared.

Three imported transactions marked Reviewed with the Accept 3 reviewed button available.
Accept the reviewed rows only after every decision is complete.

Discarding a statement import is available only while its staged rows are still being reviewed. It removes the import, not already posted journal activity.

Start a Statement Reconciliation

Select Reconcile from the account register, or open Financial > Banking > Reconcile.

  1. Choose the financial account.
  2. Enter the statement start and end dates, or select an eligible import to use its dates.
  3. Enter the statement beginning and ending balances. AveryIQ may prefill an ending balance contained in an OFX or QFX statement.
  4. Select Start draft.
Statement reconciliation setup with account, imported statement period, beginning balance, ending balance, and Start draft button.
Choose the statement period and enter its beginning and ending balances before starting the draft.

A reconciliation covers a statement period, not merely one uploaded file. A monthly statement can include transactions from several imports.

Mark Statement Activity as Cleared

Check each statement row that cleared during the selected period. AveryIQ shows:

  • Opening difference
  • Cleared activity
  • Reconciled ending balance
  • Ending difference
  • Book activity that remains uncleared

Save the draft whenever you need to stop and return later. Draft balances and selections remain editable until completion.

Reconciliation draft showing zero opening and ending differences and the Complete reconciliation button.
Complete the reconciliation only after the statement evidence produces a zero-dollar difference.

Complete the Reconciliation

Resolve every blocker and save any unsaved draft changes. The statement can be completed only when its opening and ending evidence agrees with the books.

Select Complete reconciliation to freeze the statement period, balances, cleared selections, actor, and completion time. Later reconciliations use the previous completed statement as their beginning evidence.

Uncleared book activity is not deleted. It remains available to clear on a later statement.

Correct a Draft

Before completion, edit and save the balances or cleared selections. You can also abandon the draft; this removes only the working reconciliation and does not change the journal or imported statement.

Completed reconciliation evidence is not an editable working draft. If the underlying accounting is wrong, correct the relevant business record or journal through its supported reversal or correction workflow rather than changing the completed statement history.

Activate Trust AccountingRecord Expenses and Manage Bills