Bank activity imports allow users to upload transaction data from their financial institutions into the Bank Activity page where users can match of bank transactions with records in R365 before starting bank reconciliation. This method requires downloading a file from the banking institution and importing it into the Bank Activity page. Imported transaction data can be used to create and match deposits, withdrawals, and AP payments.
Bank activity can also be uploaded through a Direct Bank Connection or BAI File Transmission or with a CSV file.
Bank Activity Duplicate Handling
The Bank Activity Enable Duplicates setting controls whether duplicate transactions are allowed when importing bank activity. This includes file uploads, direct bank connections, and BAI connections.
By default, duplicates are blocked. To allow duplicates, enable this setting on the System Preferences: Miscellaneous page.
Security
To import bank activity, users must have the following permission:
Banking → Bank Activity → Process Bank Activity
Import QBO, QFX, or BAI Bank Files
Click steps to expand for additional information and images.
1) Download bank activity from the bank website.
Users can download bank transactions from their desired bank account and date range.
Example Screenshot:
R365 Tip
The QuickBooks or Quicken format option typically produce the QFX or QBO file format.
2) Navigate to the Bank Activity page.
A) Open the Accounting application.
B) Expand the Banking category.
C) Select Bank Activity.
The Bank Activity page will open.
3) Click the Retrieve Activity dropdown, then select Upload Bank Activity File.
4) Select the Bank Account to upload transactions to.
5) Select the desired File Type: QBO/QFX or BAI.
When BAI is selected, the Bank Account field is disabled.
The system matches the account identifier in the BAI file to a bank account record using, in order: BAI Account Number, Account Number, then Bank Account Number. The import fails if none of these fields match.
6) Click Select Files to open the files explorer.
7) Navigate to the Downloads folder.
8) Find and select the downloaded bank file.
Troubleshooting
BAI
Failed Import
Issue:
Bank Activity is not uploaded.
Resolution:
Confirm the bank account number on the bank account record is correct.
If Bank Account Number does not match, confirm whether BAI Account Number or Account Number is populated on the bank account record. These fields are checked before Bank Account Number.
BAI File Type
Issue:
bai2 file type is provided instead of bai.
Resolution:
Rename the file from bai2 to bai.
E.g. ABC.bai2 would be renamed to ABC.bai .