Articles in this section

Bank Direct Connect - All Bank Transactions

  • Updated
Follow

Overview 

The All Bank Transactions tab is a listing of all downloaded Bank Transactions from Bank Direct Connect (BDC) or Financial File Import. This tab includes transactions that have been processed (added or matched to source records) and unprocessed.

Note: Up to 2,000 Bank Transactions can display on the All Bank Transactions tab. By default, the most recent 2000 transactions will display.

Do you want to:

Filter Bank Transactions on the All Bank Transactions tab provides the ability to narrow the list of transactions that displays. After adding/updating the filters, click Filter to update the list of available transactions based upon your selection(s).

BDC_05.png
Note: Click here to view the above image in full screen. 

The All Bank Transactions tab includes the following column headings:

  • Actions -indicates the actions that can be performed. Available actions include Unmatch, Remove and/or Restore.

    BDC_Settings_24a.png
    Note: Click here to view the above image in full screen. 

  • Date -  indicates the date that the transaction was processed by the bank. 
  • Account - the Customer/Vendor Account that is associated with this transaction. This field might display as blank if the transaction has not been processed in the Unmatched Bank Transactions tab.
  • Description - displays the current description from the Bank Transaction. The Description field can only be updated for “Add” actions from the Unmatched Bank Transactions tab by expanding the drawer on a transaction row.
  • GL Account - the General Ledger account that is associated with the transaction.
  • Amount - displays the amount of the transaction based upon the selected Ledger currency. Cash-In amounts display as a positive number and Cash-Out amounts display as a negative number in red.
    Note: If you download foreign Bank Transactions from Yodlee and have a Financial Institution Account (FIA) mapped in Bank Settings to a different Ledger, the Amount that displays for each row is based upon the currency of the FIA. However, the GL transactions created from the source records will be converted into the currency of the Ledger. Additionally, for potential matches to source records, the FIA currency and the Ledger currency must be the same.
  • Status - identifies the current status for the transaction, which can include Added, Matched, Removed, or Unmatched.
  • Source Link - if an existing source record has been added or matched to a Bank Transaction, a hyperlink to the record displays, which can be clicked to access and review the record.

    BDC_Settings_23a.png
    Note: Click here to view the above image in full screen. 

The All Bank Transactions tab includes the expanded drawer functionality, which allows you to view additional details about a transaction. However, the additional details on the expanded drawer from this tab are read only. Click the arrow to expand (or collapse) the drawer and view additional details. The sample screen below shows additional details that will display once the drawer has been expanded on a transaction row from the All Bank Transactions tab.

BDC2_03.png
Note: Click here to view the above image in full screen. 

Once the drawer is expanded on a transaction row, the field names display as:

  • Customer/Vendor - indicates the associated customer/vendor, which displays as a hyperlink, if available. This field can be blank on the All Bank Transactions tab, as it can only be added from the Unmatched Bank Transactions tab.
  • Bank TrX Name - this is a hyperlink to the Bank Transaction screen. The Bank Transaction screen is read only.
  • Source Record Type -  indicates whether the transaction is a Cash Receipt, Cash Disbursement, or a Journal Entry.
  • Bank ID - automatically display the bank identification number from downloaded Bank Transactions.
  • Source - identifies if the transaction was downloaded from a service provider or imported from a Financial File Import.
  • High Level Category ID, Master Category, and Detail Category ID - represent category names assigned by our service provider. These fields will display blank if the transactions were included as part of a Financial File Import.
  • Transaction Type – if the Type field on the Bank Transaction record was included, it will display as read only.
  • Debit/Credit – if the Base Type field was included on the Bank Transaction record, it will display as read only.

Return to top

Warning Messages

If a Financial Institution Account cannot be updated or if one fails to connect, a message will display on the Bank Transactions tab. To correct the problem, navigate to the Bank Settings tab. Then, refer to the Bank Direct Connect - Connection Messages article for information about how to correct the problem.

The sample screen below shows one example of a possible warning message that might display.

BDC_04.png
Note: Click here to view the above image in full screen. 

Sortable Column Headings

Sortable column headings are identified with an arrow to the right of the column heading name. For example, the Date column heading has an arrow to the right of the name. Click a sortable column heading to sort it in ascending or descending order.

BDC_AllBT.30.png
Note: Click here to view the above image in full screen. 

Source Record Change

After matching Bank Transactions to source records, if the Amount on a source record is changed or if the source record is deleted the following will happen:

  • The Bank Transaction will return to an Unmatched status on the All Bank Transactions tab and it will be available to add as a new source record on the Unmatched Bank Transaction tab.
    Note: If this transaction should not be added as a new source record, it can be removed from the All Bank Transactions tab. 
  • The Bank Transaction field on the source record will display blank since the transaction will no longer be linked to the source record.
  • The Cleared Date on the source record will display as blank. 

If the Ledger or Bank Account on a source record that was matched to a Bank Transaction is changed, the source record will NOT be unmatched from the Bank Transaction. This will not change the related Ledger on the Bank Transaction or the Bank Account. 

In addition, if a Financial Institution Account (FIA) is remapped in the Bank Settings to a different Ledger and/or Bank Account, any Bank Transactions that are already associated with the FIA will retain the original match to the old Ledger and/or Bank Account. 

Return to top

View and Filter All Bank Transactions 

The All Bank Transactions tab includes all transactions for the selected Financial Institution Account. 

  1. Navigate to Accounting Home and click the Create Entries tab. Then, under the Banking menu, click Bank Direct Connect.
  2. Click the Bank Transactions tab. 
  3. From the top portion of the Bank Transactions tab in the Bank and Credit Card Transactions section, click the Financial Institution Account drop-down list to select the appropriate bank for which you want to view All Bank Transactions.
    Note: If the Financial Institution Account drop-down list displays with blanks, access the BDC – Bank Settings tab, and wait until the screen completely loads. Then, return to the BDC – Bank Transactions tab and refresh the page. Your Financial Institution Accounts (FIAs) should display in the drop-down list.

    Note: At any time, the Refresh button can be clicked to reload the page. This works similar to a browser refresh to reload the page with updated information. The Refresh button is available on both the Unmatched Bank Transactions tab and the All Bank Transactions tab. Clicking Refresh on either tab will refresh the page for both tabs.

    Note: To ensure that you have All Bank Transactions, you can click Update All to immediately download the latest transactions. When you click Update All, the system will review Bank Transactions as far back as 14 days from the Initial Start Date for downloading. Duplicate transactions will not be included. This is a way to capture any pending transactions since the Initial Start Date and 14 days prior.

    Important: Update All uses the oldest Initial Start Date that displays for connected Financial Institution Accounts (FIAs). For example, Bank 1 might have an Initial Start Date of 09/01/2020 and Bank 2 might have an Initial Start Date of 10/1/2020. Using this example, when Update All is clicked, the date of 09/01/2020 will be used for all FIAs since it is the oldest Initial Start Date.

  4. Click the All Bank Transactions tab. 
  5. To narrow the list of transactions that display, filter the list based upon any of the following:

    BDC_Settings_14.png
      1. Customer/Vendor - enter a specific customer or vendor account.
      2. Description - enter a description. This information displays on downloaded transactions or transactions from a Financial File Import.
      3. Type - click the drop-down list to select the Type as All, Debit, or Credit.
      4. Status - click the drop-down list to select the Status as All, Added, Matched, Removed, or Unmatched.
      5. GL Account - enter a General Ledger Account.
      6. Date Range - enter a From and To date range or click the Calendar icon to select a specific From and To date.
      7. Amount - enter an amount range that should be included.
        Note: Enter the amount range as positive numbers. When you click Filter to refresh the transactions, the filtered results will include positive and negative amounts that matched the amount range that was entered.
  6. Click Filter. The screen refreshes based upon your filtered selections.

View and Modify All Bank Transactions 

From the available list of Bank Transactions, you can perform actions that include the following:

  1. Click Unmatch to unmatch a transaction that has already been matched or added as a source record. It will be unlinked from the source record.
    Note: If you click Unmatch to unmatch a transaction from a source record, the Bank Transaction will be available again on the Unmatched Bank Transactions tab.  
  2. Click Remove to remove a Bank Transaction from the Unmatched Bank Transactions tab that is not valid. A removed Bank Transaction cannot be matched or added. The Bank Transaction will remain on the All Bank Transactions tab with a Restore action available. 
  3. Click Restore to restore a Bank Transaction that was previously removed. The restored Bank Transaction can then be processed on the Unmatched Bank Transactions tab.

    BDC_Settings_24a.png
    Note: Click here to view the above image in full screen. 

    Note: To review a transaction before performing an action on it, click the arrow to expand (or collapse) the drawer to review the details. If the Customer/Vendor is available, you can click the hyperlink to view the Account information. You can also click the Bank Trx Name hyperlink to view additional information.

Return to top

____________________

Summer_23.png

Summer '23 Release

Release Notes and Schedule

The label name on the following three read only fields on the expanded drawer have been updated:

  • Source Record Type
  • Transaction Type
  • Debit/Credit

Related articles

Comments

2 comments

Date Votes
  • Lynn Grande

    What is the easiest way to remove transactions that were imported on a specific date?

     

    0
    Comment actions Permalink
  • Barb McLeod
    • Edited

    Hi Lynn,

    For assistance with your question, please open a case with our Customer Support team.

    Thank you.

     

    Barb

    0
    Comment actions Permalink

Please sign in to leave a comment.