Efficient bank reconciliation is critical to maintaining accurate financials, but outdated processes can slow your team down. If you’re still relying on Sage Intacct’s classic bank import during reconciliation, you may be spending unnecessary time preparing files, troubleshooting errors, and reworking transactions.

This month’s tip highlights the Bank Transaction Assistant, a smarter, more flexible way to import bank and credit card activity. By shifting imports out of the reconciliation process and into a centralized workflow, finance teams can streamline operations, improve visibility, and significantly reduce manual effort.

Tip summary: Sage Intacct Bank Transaction Assistant

The Bank Transaction Assistant modernizes how transactions are imported into Sage Intacct, giving users greater control, flexibility, and efficiency.

Key benefits include:

• Centralized import management outside of reconciliation
• Expanded file format support (CSV, XLS, XLSX, QIF, OFX, ASO, CAMT.053, BAI2)
• Retention of imported transactions for audit and troubleshooting
• Flexible date handling and reduced formatting constraints
• Automatic transaction matching using rule sets

In short, the Bank Transaction Assistant simplifies the import process while enabling faster, more accurate reconciliations.

Steps: How to use the Bank Transaction Assistant

Transitioning to the Bank Transaction Assistant is straightforward and requires minimal setup. Follow the steps below to get started:

1. Enable the feature in Sage Cloud Services

The Bank Transaction Assistant must be enabled at the platform level. Work with your administrator or partner to activate the feature in Sage Cloud Services. Once enabled, it becomes available within your Sage Intacct environment.

2. Confirm user permissions

Ensure users have the appropriate access to use the feature. Required permissions include:

• Business User Type – Admin privileges
• Email Delivery Log permissions

These permissions allow users to manage imports and monitor processing without restrictions.

3. Navigate to the bank transaction import files page

Access the centralized import hub within Sage Intacct. This page allows you to upload, review, and manage all bank and credit card import files in one place, separate from the reconciliation workflow.

4. Upload your bank or credit card file

Import your file directly into the system. The Bank Transaction Assistant supports multiple formats, eliminating the need for manual file conversions or reformatting.

5. Review and process imported transactions

Once uploaded, transactions are stored in Sage Intacct and remain accessible even after reconciliation. This provides greater transparency and simplifies troubleshooting when needed.

6. Leverage automatic matching

Sage Intacct uses predefined rule sets tied to the bank account to automatically match imported transactions to existing records. This reduces manual matching and accelerates the reconciliation process.

7. Complete reconciliation separately

With transactions already imported and partially matched, reconciliation becomes a cleaner, more focused step, centered on validation rather than data entry.

Why this tip matters

The Bank Transaction Assistant is one of the most effective ways to modernize your reconciliation workflow in Sage Intacct. By separating imports from reconciliation, expanding file flexibility, and retaining transaction history, finance teams gain greater control, improved auditability, and meaningful time savings.

If your team is still relying on legacy import methods, now is the time to upgrade your workflow. Contact our Sage Intacct experts to evaluate your current setup and identify opportunities to streamline reconciliation and improve efficiency. And be sure to check back next month for another Sage Intacct Tip of the Month.