Automatically match transactions for reconciliation
Save time and automate your reconciliation process by bringing bank transactions into Sage Intacct with an import file or bank feed. Each account needs to have a rule set to automatically match transactions for reconciliation.
Automatically match transactions from an import file
Use Bank transaction assistant file import to import bank and credit card transactions for reconciliation. Transactions automatically match against Intacct transactions for reconciliation using the account's rule set.
If you unmatch a transaction that has been matched by a rule, the rule will continue to match other transactions but will ignore the transaction you have unmatched. If another transaction exists that is a match, then when the rule set runs again, that transaction will match.
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.
| Bank transaction assistant file import | Classic import experience | |
|---|---|---|
|
Where to import bank transactions |
From the Bank transaction import files list. |
From the Reconciliation page. |
|
Bank transactions remain in Intacct after reconciliation |
Yes |
No. Unless you drill down from the matched Sage Intacct transaction. |
|
Limited to importing data for the current reconciliation |
No, Because bank transactions are stored in Sage Intacct, you can import data from outside of the reconciliation period. |
Yes |
|
Can import credit card transactions |
Yes |
No |
|
Support for CSV, XLS, XLSX, QIF, OFX, ASO, CAMT.053, BAI2 files |
Yes |
No. Only CSV and QIF. |
|
Can combine with bank feed data |
Yes |
No |
|
Import data for any date range |
Yes |
No |
|
Supports most special characters |
Yes |
No |
|
Support for multiple date formats |
Yes |
No, only MM/DD/YYYY |
Automatically match transactions from a bank feed
Download transactions directly from the bank with a bank feed. As soon as bank transactions download into Intacct, they’re matched against existing Intacct transactions. Learn more about bank feeds.
Use the Bank transaction assistant file import to import missing bank feed transactions, or if your bank does not offer a bank feed connection.