Transaction workbench

On this page, you can search bank transactions that were imported into Sage Intacct. Based on your search criteria, records are retrieved and displayed in the grid.

If you set up matching rules, records are matched to those criteria. You can also create AR payments and advances.

Search for bank transaction feeds

1. Select Create.

2. Enter or select a bank feed.

   When selecting, the list of available bank accounts only includes those that are mapped to Sage Intacct. If you do not see a bank account listed, you cannot work with a transaction feed from that account.

   See your administrator if you need a bank account added.

3. Enter criteria to limit search results to a date range, transaction type, and status.

4. Though not required, entering a date range that corresponds to the bank statement is recommended. When you enter a date range, you can save the current bank transaction feed inquiry and return later to finish matching.

5. Status is Unmatched by default. This is the status in Sage Intacct.

6. Only new lines is Off by default.

Process bank feed results

The grid displays bank transaction records based on the search criteria you entered for date, transaction type, and so on. For each record, you can add dimensions, split an amount, or modify the account, tax detail, and so on.

When the matching details for a line are correct, you can save the line to generate a journal entry to be synchronized with Sage Intacct.

You can see totals at-a-glance above the results grid for the retrieved bank feed such as deposits and withdrawals.

The matching status displays according to your matching rules. Expand each record to view the line status and matching results, such as account and tax detail, and a link to the Sage Intacct record if there is one.

Match transactions

If the transaction record has a match and you don't need to make any changes, you can select Save from the More actions menu. The transaction is ready to post and you can post from the line or as part of a bulk action after saving multiple lines.

Expand a transaction to view the line details. Whether a match is found or not, you can modify line values such as the account, tax detail, and amount. The tax amount is automatically calculated based on the Tax column value.

You can view and update the current matching rules by selecting the link above the Results grid. Remember to search again to update the results.

Select the More actions menu to perform any of the following:

• Delete line: You can remove the transaction from the matching process in Sage Distribution and Manufacturing Operations

• Split line: You can allocate the amount to one or more accounts.

• Dimensions: You can add dimensions to the account.

• Search: You can search records to find any existing journal entries. This avoids duplicate journal entries.

  If a journal entry is found, you can select the link to view it in Sage Intacct. You do not need to post this entry again from Sage Distribution and Manufacturing Operations
  

• Create rule: You can create a new matching rule based on the values matched for this transaction.

Save your work

If you do not review the complete list of results for the current transaction feed inquiry, you can save your work.

Saved searches display in the selection list by bank name and date.

Post journal entries

When you validate and save transactions, they are ready to post.

You can post each line individually, or select All to post in a single action.