Importing transactions directly from the client's financial institution

Alerts and notices
Leave feedback

Contact information (optional):

Leave this blank:

Please tell us how we can make this information more helpful.


Characters left:

The Accounting CS Bank Feeds feature makes it easy for you to import bank transactions directly from a client’s bank account into Accounting CS. This can save time during data entry and bank account reconciliation. Use the Bank Feeds portlet to review transactions that you have retrieved from the client’s bank and to approve the specific transactions to import into Accounting CS.

Before you can import any transactions, your client must register and link their bank account to Accounting CS.

  1. Open the Bank Feeds portlet in the Bank Feeds Dashboard.
  2. Select the appropriate client, and then select the appropriate bank account.
  3. To set up Accounting CS to automatically assign a specific value to the reference, description, type, vendor, 1099 item, and/or GL account when it retrieves transactions, click the Rules link in the lower-left corner of the screen to open the Rules dialog. In this dialog, you can define the criteria to compare and the values to assign.
  4. Choose one of the following options.
    • To retrieve transactions that have not previously been retrieved, click the Retrieve Data button. For a newly linked account, Accounting CS retrieves transactions as far back as the financial institution allows (up to three months). For accounts that have already been linked, Accounting CS retrieves transactions since the last retrieval.
    • To retrieve transactions for a specific date range, click the Custom Date Range link in the upper-right corner to open the Custom Date Range dialog, where you can specify the date range for which to import the transactions.

    Note: If a retrieved transaction matches an existing Accounting CS transaction, the application displays Match in the Status column, grays out the row, and lists the transaction in the Matching Transaction grid below.

  5. Review the transactions in the Retrieved Transactions grid. If necessary, you can modify data in the Reference, Description, Type, Vendor, and GL Account columns for any unmatched transactions. You can also modify distributions for those transactions by clicking the Ellipsis button to open the Enter Transaction Distributions dialog.

    By default, all transactions in the Retrieved Transactions grid are approved for retrieval. To exclude a transaction from the import, clear the checkbox in the Approve column.

  6. To view details about an existing Accounting CS transaction that matches a retrieved transaction, select the transaction in the Retrieved Transactions grid. The application displays the details in the Matching Transaction grid below.

    You can view the original transaction record by clicking the Go To Source button.

    If the transaction is not a true match, click the Unmatch button.

  7. Choose one of the following options.
    • To import the selected transactions, click the Approve button. Accounting CS imports the transaction information from the client's financial institution and makes those transactions available in the Actions > Enter Transactions screen and the Actions > Reconcile Bank Accounts screen.
    • To save any changes you've made in this portlet for later, click the Finish Later button. You or another staff member who has access to this client's account can return to this portlet at any time to complete the import.

Excluding transactions from the import

After you retrieve transactions from your client's financial institution, you may find that you do not want to actually import all of the transactions into Accounting CS. If you have retrieved (but not yet imported) a transaction that you don't want to include, choose one of these options.

Related topics

Bank Feeds overview

Bank Feeds Dashboard

Share This