MENU
    Bank Activity: Update and Match Transactions
    • 26 Nov 2024
    • 6 Minutes to read
    • Dark
    • PDF

    Bank Activity: Update and Match Transactions

    • Dark
    • PDF

    Article summary

    Matching transactions in Bank Activity makes the Bank Reconciliation process easier. Once Bank Accounts are set up, then Bank Activity can be pulled and matched. This process consists of the following steps:

    1. Navigate to Bank Activity

    2. Update Bank Activity. Bank Activity can be updated in one of three ways:

      • Manual Upload - Download activity from your Bank (.qfx or .qbo file formats only) and then upload the file on the Bank Activity screen (this will attempt to Auto-match the Bank Transaction with its corresponding R365 Transaction, if it has previously been entered)

      • Direct Bank Connection - Connect your bank accounts to R365 and refresh their transaction details with a simple click of the 'Retrieve Activity' button

      • BAI File Transmission - Create a direct link to your bank(s) where transaction details will automatically pull into Bank Activity without User intervention

    3. Auto-Match

    4. Review and Update Records that were not Auto-Matched

    5. Clearing the 'Unmatched' tab

    These steps are further elaborated on below. Scroll down to view all steps or click the desired step above to jump to its section.


     Step 1 - Navigate to Bank Activity and Select the Bank Account

    1. Open Bank Activity by hovering over the Banking option in the top ribbon menu and selecting Get Bank Activity.

    2. From the Bank Account drop-down, select the bank account for which to retrieve activity.


    Step 2 - Import Bank Activity from your Bank

    Users can import bank activity into R365 using one of two methods:

    File Incorrectly Uploaded

    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.


    Step 3 - Auto-Match

    Once the transactions have been imported, Bank Activity performs auto-matching. The auto-matching logic attempts to match each activity record with a transaction in the system (auto-matching logic is outlined at the end of this article).

    • Successful Matching - Records that are successfully auto-matched move to the Matched/Excluded tab.

    • Unsuccessful Matching - Records that did not auto-match to an existing transaction will have one of two actions occur:

      • The auto-match process attempts to match the activity against the conditions set on previously created bank rules. If the activity meets the conditions, it moves to the Rule Applied tab.

      • If the activity does not auto-match, has multiple potential matches, or does not meet any bank rule conditions, it remains on the Unmatched tab to await processing.

    Auto-matching will only occur when there is a single possible match available.


    Step 4 - Manually Addressing Activity That Did Not Auto-Match

    In this step, unmatched activity from the Unmatched tab is reviewed and manually matched, excluded, deleted, or added.

    Manually Matching Bank Records to R365 Transactions

     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.

    Excluding Bank Records from Bank Activity

    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.

    Deleting Bank Records from Bank Activity

    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.

    Create Transactions

    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.


    Step 5 - Clearing the Unmatched Tab

    If any activity records remain after all desired transactions are created and matched on the Unmatched tab, leftover records can be moved to the Matched / Excluded tab by clicking the Remove All Unmatched button near the top of the Bank Activity page.

    All remaining records are moved to the Matched/Excluded tab and removed from Bank Activity 10 days after being moved to this tab.

    Before selecting Remove All Unmatched, make sure there are no records on the Unmatched tab that should be matched. Selecting this button will remove all records from the tab.


    Was this article helpful?