Cash management

Introducing a more robust bank transaction import experience—Early Adopter

We have a new bank transaction import experience 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

Now, there's a centralized location for importing transactions for all bank accounts and transactions remain in Sage Intacct even after reconciliation. And, even more file formats are supported, giving you extra flexibility. You can also increase control of who imports bank transactions with a new permission and view a list of all import activity for added insight.

Previously, you could only import bank transactions during reconciliation. These bank transactions would not remain in Sage Intacct after a reconciliation had been finalized.

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, specify whether your file displays amounts in two columns (money in and money out) or one column (positive and negative amounts appear in this column). You select a 3 column or 4 column file type, respectively. There are also additional columns to add for even more insight into transactions.

How it works

Import transactions on the Bank transaction import files list.

Import bank transactions

Go to Cash Management > All, and select the + icon next to Bank transaction import files.
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.
On the Upload your file page, select the file type and the date format.

Select how to set up your file 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.

Go to Cash Management > All > Bank transactions.
Select View.

Join the Early Adopter 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.

About the 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.

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