Manage Transactions Received via Bank Feed or Import File

Once you receive transactions from your bank feed or upload them from an import file, you can:

• Confirm matches to existing entries
• Add transactions  
• Delete transactions 

Watch a Video

Manage Bank Feed or Import File Transactions 

To manage your bank feed or import file transactions:

1. Take the appropriate action:
   • Link your Bank Feed
   • Import Bank Transactions via QBO/Excel/CSV File
2. From the left navigation panel, click Accounting.
3. Atop the Accounting left navigation, click Bank.
4. On the Bank screen, double-click the bank, or single-click it to highlight it, and then from the toolbar, click Edit.
5. From the bottom of the Banks left navigation, click Bank Feed.
   The Bank Feed screen opens, displaying a toolbar atop the screen and a listing of your feed’s transactions.
   Important

   The system displays:

   • A green Matched icon beside a transaction with only one match of the same date and amount.
   • A gray Matched icon beside a transaction, if there is more than one match of the same amount, or same date and amount found. To find the right match, click on the orange Details icon to the right.
   • A gray Add icon indicating no match exists and you must add the transaction.

6. To create rules that automatically rename imported transactions, from the toolbar, click Automatically Rename Imported Bank Transactions (Mapping Rules). Otherwise, you can link trust transactions to matters or operating transactions to GL accounts on a per transaction basis.
7. For each transaction, take the appropriate action:
   • Trust Bank Only
     • From each transaction row’s Matter field drop-down, click the matter to which the transaction applies.
   • Operating Bank Only
     1. From each transaction row’s Account field drop-down, click the chart of accounts to which you want to post the transaction.
        Important

        The Statement Payee field displays the payee listed on the bank feed.

        The Payee field displays the payee you want the system to use.

     2. Edit the Payee fields, if desired. 
8. Take the preferred actions:
   • Add a Matched Transaction
     1. Toward the far left of the transaction in the Status column, click Matched.
        The system adds the Matched transaction, removes it from the listing.
        Important

        To the far right of a Matched transaction’s row, you can click the orange arrow to open the Match Details screen and view additional information regarding the matched transaction. If multiple transactions display, select the correct match and click Save.

        Within the Notes tab, you can review and include any transaction notes.

   • Add a Single Unmatched Transaction
     1. Toward the far left of the transaction in the Status column, click Add.
        The system adds the transaction and removes it from the listing.
   • Add Multiple Unmatched Transactions
     1. Check the boxes to the far left of the transactions.
     2. From the toolbar, click Add/Confirm Match.
        The system adds the transactions and removes them from the listing.
   • Delete Transactions
     1. Check the boxes to the far left of the transactions you want to delete. From the toolbar, click Delete.
        The system deletes the transactions and removes them from the listing.
9. Once you have processed the appropriate transactions, unprocessed transactions may remain. From the toolbar, click Remove Transactions.
   The system removes the transactions from the listing. 

Match Multiple Transactions to a Single Payment 

When transactions for invoice payments display in the bank feed, you match those transactions to your payment records for reconciliation purposes.

In some cases, a single payment might apply to multiple invoices.

If your bank feed deposit includes one payment for several transactions:

1. Create a deposit slip.
2. Return to the bank feed tab and confirm the Matched transactions.
   The system adds the transactions, removes them from the listing, and clears them from their respective reconciliation statements.