Cash management

A more robust bank transaction import experience—Early Adopter

There's a new way to import your bank transactions for reconciliation that focuses on flexibility, control, and visibility. And, it's headed your way in a future release. You can get a sneak peek at what's coming by joining our Early Adopter program.

This import experience takes the place of the classic import process. You can use one functionality or the other, but not both at the same time.

Details

The new import experience for bank transactions introduces a fresh approach to importing.

  • Imported transactions appear in a centralized location for all bank accounts.

  • Transactions you import remain in Sage Intacct, even after reconciliation.

  • More file formats are supported, giving you extra flexibility.

  • You can increase control of who imports bank transactions.

  • A new import activity list provides added insight.

This import experience also works with our new workflow, Bank transaction assistant.

More file types supported

In addition to the CSV and QIF file formats that are supported in the classic import process, we now support XLS, XLSX, and OFX.

To ensure a smooth import process, make sure that your file is formatted correctly.

For CSV, XLS, and XLSX files, you select a 3 column or 4 column file type.

  • If your file displays amounts in 1 column (both positive and negative amounts appear in this column), select a 3 column file type.

  • If your file displays amounts in 2 columns (money in and money out), select a 4 column type.

You can include additional columns for even more insight into transactions.

How it works

Subscribe to Sage Cloud Services and you are automatically enabled for Bank txn file imports. Then, assign the Bank transactions for API and import permission to appropriate users. Then, import transactions on the Bank transaction import files list.

Import bank transactions

  1. Go to Cash Management > All, and select the + icon next to Bank transaction import files.

  2. On the Import bank transactions page, select the Bank account and then select Continue.

    If a bank account is in the process of being reconciled, it won't appear in the dropdown.

  3. On the Upload your file page, select the file type and the date format.

    Select how to set up your file on the Upload your file page to learn more about how to format your file for import. In this guide, there are example files that you can use as templates.

View bank transactions

Imported bank transactions appear on the Bank transactions list and remain there even after they are included in a reconciliation.

Because bank feed transactions are also listed on the Bank transactions list, create a custom view to include the Source column and determine whether transactions are from an import file or bank feed.

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

  2. Select View.

Early Adopter program

The Early Adopter program provides qualified functionality to a specific set of customers. During this release, these early adopters will help us refine our offering to deliver the functionality that's critical for business controls.

The Early Adopter program is closely monitored. We work with the early adopters to ensure that we focus our time and attention on what matters most to you.

Join the program

If you would like to consider being an early adopter, contact Customer Support.

Do not request to enable this feature until you complete your current reconciliation. This feature disables the classic import experience.

Requirements

Subscription

Cash Management

Sage Cloud Services
Regional availability

All regions
Configuration

You are automatically enabled for Bank txn file imports when you subscribe to Sage Cloud Services.
User type Business user with admin privileges
Permissions

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