cash management

Improve your workflow with bank transaction assistant

Last release, bank transaction assistant became generally available and all you had to do was enable it on the Configure Cash Management page. Now, it's available by default.

Streamline your Accounts Receivable receive payments workflow while accelerating your reconciliation process with bank transaction assistant.

Details

Easily and quickly assign customers to bank transactions and then receive multiple payments for multiple customers, all from the Bank transaction page. After you receive payments, the posted payments in Sage Intacct and the bank transactions automatically match for reconciliation.

For multi-entity, multi-currency companies, receive advances and payments at the entity level.

Use this feature with our new Bank transaction assistant for file imports Imported transactions appear on the Bank transaction list.

How it works

Assign customers to bank transactions

To receive a payment, first assign a customer to bank transactions. You can automate this process by creating an assignment rule.

Use information from the bank transaction description to create a rule and automatically assign customers to bank transactions. For example, you might want all bank transactions with a description of "ABC" to be assigned to the customer "ABC inc."

Assignment rules are similar to matching and creation rules in that you need to filter for the transactions you want to act on, but assignment rules are not included in rule sets. Just associate the assignment rule with the bank account of your choice.

Assignment rules run when the following events happen:

A screenshot of an assignment rule with three numbers calling out different features of the rule.

  1. Select the Customer and Bank account.

  2. The first two filters default for you.

    The first filter targets only credit-type bank transactions. These are bank transactions for which you can receive payments. The second filter targets the bank transaction description. Just enter the description from the bank transaction in the Value column.

  3. When you have your filters in place, select Preview to validate the accuracy of your assignment rule.

You can also assign customers to bank transactions manually from the Bank transaction page.

  1. Go to Cash Management > All > Transactions > Bank transactions.
  2. From the View menu, select Cash in.

    The Bank transactions list refreshes with unmatched bank credits.

  3. Select transactions that do not have a customer and choose Assign to customer.

    The Assign transactions to customers page appears.

  4. For each transaction, select a Customer.

    You can create an assignment rule while you are manually assigning customers by entering an Assignment mapping value. This is where you enter identifying data from the bank transaction description. An assignment rule is automatically created when you select Save.

  5. Select Save.

Receive payments in bulk

When a bank transaction has a customer assigned, you can receive a payment or create an advance. You can also receive payments in bulk. If there's no invoice for the customer, you can create an advance using the new AR advances template.

To receive payments from bank transactions, you'll need the new Cash Management permission to Receive payments from bank transactions.

  1. Select the Cash in view to view only unmatched bank credits.

  2. Select transactions that are assigned to a customer and select Receive payments.

  3. The Payment application method will vary depending on your business needs.

    For example, you might want to target oldest invoices first and then search for more recent invoices. Or, you might want to match by amount.

  4. You can Create advances for transactions with no invoice.

    You might want to do this after you already previewed results and found no available invoices for which to receive a payment.

    To create an advance, select or create an Advance template.

    AR advance templates enable you to quickly create advances based off bank data during the receive payment workflow. However, unlike the other reconciliation transaction templates, AR advance transaction templates are only used in this workflow and cannot be used in creation rules.

  5. Select Preview payment application to preview whether there are invoices available to match to the bank payment.

  6. If there are invoices available, they appear in the Bank transactions table.

  7. Select Post to create a posted payment and match transactions for reconciliation.

Requirements

Subscription

Cash Management

Accounts Receivable
Regional availability

  • Australia

  • Canada

  • South Africa

  • United Kingdom

  • United States
User type Business user with admin permissions
Permissions

To assign a customer to a bank transaction

Bank Transactions: List, View

To create an assignment rule

Bank transaction assignment rules: List, View, Add

To receive a payment for a bank transaction

Receive payment from bank transaction: Add
Restrictions

Not available for the following use cases:

  • If the bank transaction currency does not match the currency of the invoice.

  • If invoices have a terms discount assigned.

  • If the invoice has a negative line item that is not applied, unless configured in Accounts Receivable to apply negative lines automatically.

  • If Accounts Receivable payment and advance summary frequencies are set to user-specified.

  • In a multi-entity, multi-currency company:

    • You can only receive a payment at the top level if all of the following currencies match: the currency of the bank account, the currency of the owning entity of the bank account, the currency of the owning entity of the customer record, and the invoice currency.

    • Within an entity, you can only receive a payment if the bank transaction currency matches the currency of the invoice to receive a payment.

Credits and negative invoices are not applied during the payment application process.