Import transactions for reconciliation using Bank transaction assistant file import

Use Bank transaction assistant file import to import bank and credit card transactions into Sage Intacct for reconciliation. Transactions automatically match against Intacct transactions using the rules in the account's rule set and are shown on the Banking cloud tab for the account. It can take a few minutes for transactions to import into Intacct. Learn how and where to view transactions.

Although you can currently use the classic import experience, this method is going away no earlier than May 2026. This change does not impact any custom integrations that use the Intacct API.

If you accidentally import duplicate transactions, you can ignore duplicates during reconciliation or from the Bank transactions list.

During the upload process, select Open file import guide for details and example templates. Or download an example import template.

Before you begin

  • Subscribe to Sage Cloud Services and select the option Enable Bank transaction assistant file import.

  • Enable Cash Management permissions for Bank transactions for API and import: List, Add, Delete, View.

Import a file

Learn how to upload and import a bank transaction file. It can take a few minutes for bank transactions to arrive into Sage Intacct.

Subscription

Cash Management

Sage Cloud Services
User type

Business
Permissions

Bank transactions for API and import: List, Add, Delete, View

  1. Go to Cash Management > All > Transactions and select Add (circle) next to Bank transaction import files.

  2. Select the Bank account or credit card account for which to import transactions.

    If the bank account is not available in the dropdown list, the account is in the middle of a reconciliation. Either finalize the reconciliation or clear the pending reconciliation.

  3. Select Continue.

  4. Do one of the following: 

    • Drag and drop the file as indicated.
    • Select Select a file from your device, then navigate to the file and select Open.
  5. Select Review transactions.
  6. Select the correct date order and select Continue.

  7. Review transactions.

    Verify that transactions import correctly by identifying transactions as either Money in or Money out of the account. To switch the transaction types, select Switch transaction types.

  8. Select Confirm import.
  9. Select OK in the popup window.

You return to the Bank transaction import files list. After a few minutes your transactions import into Intacct. On the Bank transaction file import list, you see a status of Completed for the file import.