cash management
Import credit card bank transactions for reconciliation with Bank transaction assistant file import
Import credit card transactions for reconciliation. Control who imports bank transactions with a new permission and view a list of all import activity for added insight. Multiple file formats are supported, which gives you extra flexibility.
Details
Import CSV, QIF, XLS, XLSX, OFX, CAMT.053, BAI2, and ASO files. 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
-
Go to Cash Management > All > Transactions and select Add (circle) next to Bank transaction import files.
-
On the Import bank transactions page, select the Bank account.
If a bank account is in the process of being reconciled, it does not appear in the dropdown.
-
Select Continue.
-
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. -
Select Review transactions.
-
Select the date order.
-
Select Continue.
-
Select Confirm import.
Imported transactions appear on the Bank transactions list and remain there even after they’re included in a reconciliation.
View the imported bank transactions
-
Go to Cash Management > All > Bank transactions.
-
Select View.
Permissions and other requirements
| Subscription |
Cash Management Sage Cloud Services |
|---|---|
| Regional availability |
All regions |
| User type |
Business |
| Permissions |
Cash Management
|
| Configuration |
Enable Bank transaction assistant file import in Sage Cloud Services |
