Bank Activity: Update and Match Transactions

If a Bank Activity file was manually uploaded to the wrong bank account (not applicable to Direct Bank Connections) or otherwise incorrectly uploaded, select Undo File Upload to open the Undo File Upload prompt.

The prompt displays the most recently uploaded Bank Activity file and ask if the file should be removed. Select Yes to remove the upload, otherwise click Choose a different one to review and select a different upload file.

 If there is more than one possible match in the system or if the payment is a possible match in a payment batch, a potential match is indicated with an 'M' at the end of the row. Reasons for possible matches include:

• Same Amount and Multiple Transactions - There are multiple transactions in the system for the same amount.

• Same Amount and One Transaction - There are multiple bank activity records imported with the same amount and only one R365 transaction for that amount in the system.

• A bank transaction has possible matches to both a batch and a single payment.

To see the possible matches, click the arrow on the far left of the row to expand the row and view the list.

Potential matches will be listed in date order.

To match a transaction to the desired bank activity, select Match on the far right of the row to match the record. The record moves to the Matched/Excluded tab. collapse the row by clicking the same arrow.

If the bank transaction has possible matches to both a batch and a single payment, the single payment will include a warning next to the match options that notes ‘This payment is also a possible match in a payment batch’.

If the user selects the single match option, an additional warning will display, ‘This payment is also a possible match in a payment batch. Have you confirmed that this is the correct match? Users will have the option to select ‘Yes’ to proceed with the match, or ‘Cancel’ to return to the possible match options.

Records that are not intended to be included or that have already been reconciled manually can be removed by selecting their respective line and then in the Select Command drop-down and choosing Exclude Selected. The rows move to the Matched/Excluded tab.

To move an excluded record back to the Unmatched tab from the Matched/Excluded tab, select the Include button on the 'Matched/Excluded' tab.

If the record is not expected to be included or matched again, select 'Delete Selected' from the Select Command drop-down to permanently remove the bank activity record.

There are three types of transactions that can be created from Bank Activity:

• Bank transactions that involve one GL account and one location.

• Bank transactions might involve multiple GL accounts and/or multiple locations.

• AP Payments

Create a Bank Transaction with one GL Account and One Location

1. Populate the Vendor on the activity row.
   This field is optional and only applies to Withdrawals (not Deposits).If you select a vendor that has a Default Expense Account, the Account column populates automatically.

2. Set or change the Account on the Activity row.
   This is required and must be populated on both Withdrawals and Deposits before they can be created.

3. Set or change the Location.
   This will default to the Location on the Bank Account and is a required field.

4. (Optional) Select the Add Rule checkbox if you want a bank rule created.
   By default, Add Rule is not selected, which means a new bank rule will not be created.
   If selected, any other activity records with characteristics matching the new bank rule are automatically moved to the Rule Applied tab.

5. Add the transaction.
   Transactions can be added individually or in bulk.

   • Select Add to add the single transaction immediately.

   • Select each activity record row and choose Add Selected from the Select Command drop-down to add transactions in bulk. Each selected transaction is added and any rows with Add Rule checkbox selected create new Bank Rules.
     

Create a Bank Transaction with Multiple Locations or Accounts

For Transactions that require multiple GL accounts or locations, instead of populating values on the activity row, select the Withdrawal or Deposit button. A Withdrawal or Deposit window appears in a pop-up where you can create the transaction with as much detail as needed.

When you have entered all of the details, select Create Withdrawal or Create Deposit in the upper left corner of the window to create the transaction and move the activity row to the Matched/Excluded tab.

Create an AP Payment

If Bank Activity pulls in a withdrawal that does not match any existing payment in R365, an AP Payment can be created using the information gathered from the bank. Select the AP Payment button in the row for the withdrawal to open the AP Payment record. Several fields are automatically populated with information from the bank activity. Complete any additional fields then select Create Payment to save the new transaction.

For more information, see Create AP Payment from Bank Activity.