Remove incorrect transactions and re-import

For the classic import experience.

Try Bank transaction assistant file import for a more robust import experience.

You might have imported bank transactions for reconciliation that contain errors and you want to re-import a corrected file. Or, your account has been connected to a bank feed and you no longer want to reconcile with an import file. In this case remove the file, as proceeding with it overwrites any matching done by the bank feed. Then, import a corrected file on the Reconciliation page.

If you’re using creation rules, removing the import file does not remove created Sage Intacct transactions. If you re-import the file, creation rules run again and can create duplicate transactions.

After you remove the import file, you can:

  • Delete any Sage Intacct transactions that were generated by a creation rule and then re-import. The bank transactions will generate the same Sage Intacct transactions again and they match for reconciliation.
  • Remove the associated bank transactions from the file and re-import.
  • Have a matching rule in place so that the existing, created Sage Intacct transaction matches to the incoming bank transaction. Have the matching rule run before the creation rule in your rule set.
Subscription

Cash Management

Regional availability

All regions

User type

Business
Permissions

Reconcile bank: List, View, Add, Edit, Delete

  1. Go to Cash Management > All > Reconciliation > Bank.

  2. Enter account information and select Continue.
  3. Select Import.
  4. Select Delete (Trash can) next to the import file that contains the erroneous transactions.

  5. To import a corrected file, make your changes locally.

    Then, select Choose Files on the Import files page to select the corrected file.

  6. Select Done.

You return to the Reconciliation page to continue the reconciliation process.