Recording Bank Interest & transactions in Sage Intacct

Keywords: Transactions, Interests, Management,  Sage

Credit:–  Sage Photo By: FP

Struggling to Keep Your Books in Order? 📊📅

Let us handle the numbers while you focus on growing your business! Get expert bookkeeping support tailored to your needs.

👉 Click Here for a Free Consultation!

Bank interest and charges: Record bank interest or charges

Enter bank interest or service charges from Cash Management. In a multi-currency company, enter bank interest and charges at the entity level.

  • Go to Cash Management > All > Transactions and select
  • Add
  • next to Interest and charges.
  • Select the Bank account and enter the Date of the transaction.
  • For the Transaction type, select one of the following:
  • Select Service charge to record the monthly charge for the account.
  • Select Interest earned to record the interest if it’s an interest-bearing bank account.
  • Enter the transaction number from your statement in the Reference number field.
    This value appears as the Document number in lists and the register report.
  • Optionally, add a Description.
  • Optionally, to permanently and safely store a digital version of a supporting document, in the dropdown next to Attachment, select an attachment, or select Add, then upload your attachment.

Details

  • In a multi-currency company, enter Currency and Exchange rate information about the adjustment in the Currency section.
  • Select the Transaction currency.
    If the currency is not your company’s base currency, continue with the next two steps.
  • Select an Exchange rate type such as Intacct Daily Rate (which is the system-supplied default exchange rate type).
    If you know what the exchange rate for this transaction is, or have contracted with the vendor on a set exchange rate, enter it in Exchange rate.
  • Enter or select a date in Exchange rate date.
    The default is the current date, but you can override this. For example, you can change it to the date the transaction was issued, or the date you intend to pay the transaction.
    If you override the Date field, the Exchange rate date updates automatically.
  • In the Entries section, you can add values directly to each line item, or select Show defaults to define default values to autofill each line item. To set up a value as a default for each existing and new line item, select the dropdown beside the appropriate field and choose a value. You can override any default value on any line item.
  • For each line item, enter information such as the account, transaction amount, and dimension values, if any.
    Sage Intacct automatically converts the transaction amount and displays the converted amount in Amount. You can edit this amount to adjust it. In Description, Intacct automatically copies the transaction type for the line item based on the type that you selected earlier.
  • Select Save.

Bank interest and charges list

View a bank interest or bank charge

  • Go to Cash Management > All > Transactions > Interest and charges.
  • Select View beside the appropriate transaction.
    Transaction information appears on the Transaction tab.
    If the transaction is posted to any accrual journals, GL posting information appears on the posting details tab.

Edit bank interest or charges

Edit a service charge or interest earned transaction if the subledger is open and the transaction has not been reconciled.

  • Go to Cash Management > All > Charges and fees > Bank interest and charges.
  • Find the appropriate transaction.
  • Select Edit.
  • Make the required changes and Save.

Reverse bank interest or charges

Reverse bank interest and charges in an open period, even if the period in which it’s created is closed. Reverse bank interest and charges at the entity level.

  • Go to Cash Management > All > Transactions > Interest and charges.
  • Find the bank interest or charge that you want to reverse.
  • Select Reverse.
  • Enter the reversal date and a description, if desired.
  • Select Submit.

Bank transaction assistant

Use Bank transaction assistant to import bank transactions, assign customers to bank transactions, receive payments in bulk from unmatched bank transaction data.

Process customer payments using Bank transaction assistant

Use Bank transaction assistant to assign customers and receive payments in bulk from unmatched bank transaction data. First assign customers to unmatched bank transactions. Then, begin the receiving payment process. After you receive a payment, a posted payment is created and matches with the bank transaction for reconciliation. If you’re not ready to post payments to the General Ledger, or you want to verify transactions before you post, you can create draft payments and view them in Accounts Receivable. Currently, creating draft payments is not supported for companies enabled for French taxes.

On the Bank transactions page, use the Cash in view to display unmatched credit type transactions. This view includes the Customer ID and Customer columns so you can quickly check which transactions need to be assigned to a customer.

Before you start

To receive a payment, the customer on the invoice needs to match the customer on the bank transaction. You can assign a customer manually or you can create an assignment rule to automatically assign customers to bank transactions.

Special considerations

This feature is not available for the following use cases:

  • Invoices created at the entity level are not available to apply as payments to bank transactions at the top level.
  • 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’s not applied; unless Accounts Receivable is configured to apply negative lines automatically.
  • If Accounts Receivable payment and advance summary frequencies are set to user-specified.
  • If you are a company enabled for French taxes and want to create a draft payment.

In multi-entity, multi-currency companies:

  • You can only receive a payment at the top level if all 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.
  • The invoice currency.
  • Within an entity, the bank transaction currency must match the currency of the invoice.

Assign customers to bank transactions

To receive a payment, first assign customers to bank transactions. You can automate this process by using Assignment rules.

Set up assignment rules

Create an assignment rule on the Assignment rule page.

  • Go to Cash Management > Setup > Reconciliation rules and select
  • Add
  • next to Assignment rules.
  • In the Assign to section, select the Customer you want to create the assignment rule for.
  • Select the Bank account or All bank accounts that make the payment to the customer.
    If you selected a single bank account, the assignment rule will only run for that selected account.
  • Enter an ID and Name.
  • Enter an optional Description.

This description is to describe and identify the assignment rule itself.

  • The status defaults to Active.
  • In the Filter transactions by section, there are two defaulted filters:
  • One filter is to target only credits to the account. You’re only targeting credits because they represent customer payments.
  • Data source: Bank transactions
  • Field: Transaction type
  • Operator: Equals
  • Value: Credit
  • The second filter is where you enter the description from the bank transaction.
  • Data source: Bank transactions
  • Field: Description
  • Operator: Contains
  • Value: Enter the description to identify the customer as it appears on bank transactions. Case sensitive.
  • Set any other filters.
  • Select Preview to view which transactions will be affected by the assignment rule.
    Based on the results, change what you need and then select Preview again.
  • Select Save.

Manually assign customers

Alternatively, you can manually assign customers to bank transactions from the Bank transactions list. During the manual process, you can also create an assignment rule on-the-fly.

  • Go to Cash Management > All > Transactions > Bank transactions.
  • From the View menu, select Cash in.
    The Bank transactions list refreshes with credit type transactions.
  • Select transactions that do not have a customer and choose Assign customers.
    The Assign transactions to customers page appears.
  • For each transaction, select a Customer.
    To create an assignment rule on-the-fly, enter the value Intacct should look for within a bank transaction description to automatically assign a customer. For example, if you have a customer, ACME Customer, you might enter ACME in the Assignment mapping value field and then select Save.
  • Select Save.

To view assignment rules, go to Cash Management > Setup > Reconciliation rules > Assignment rules.

Receive payments from bank transactions

After you assign customers to bank transactions, you can receive a payment. You can also receive payments in bulk. After you receive a payment, a posted payment is created which matches automatically to the bank transaction for reconciliation. You can also create draft payments if you’re not ready to post.

  • Go to Cash Management > All > Transactions > Bank transactions.
  • From the View menu, select Cash in.
    The Bank transactions list refreshes with credit type transactions and additional columns for Customer name and Customer ID.
    If you’re using assignment rules, Intacct automatically assigns customers to bank transactions so you can quickly receive a payment. Otherwise, follow the steps above to manually assign a customer to a bank transaction.
  • Select transactions and select Receive payment.
  • Select the Payment application method.
    Payment is applied to invoices using the waterfall payment method.
  • Oldest invoice first: Apply the payment to invoices with the oldest date.
  • Earliest invoice first: Apply the payment to customer invoices that were created first.
  • Smallest amount first: Apply the payment to customer invoices with the smallest amount out of all invoices.
  • Largest amount first: This is the customer invoice with the largest amount out of all invoices.
  • Create advance: Instead of applying a payment to an invoice, create an advance. Make sure to select an AR advance template to detail how you want the advance to be created.
  • Match to amount: Apply the payment to an invoice of the same open amount.
  • Add an optional Payment memo.
  • Filter invoices by Payment method.
  • You can Create advances for transactions with no invoice if there are no invoices in Intacct that match to the bank transactions.
    To create an advance, select an Advance template.
  • Select Preview payment application.
    In the Bank transactions section, you see the appropriate invoice in the Apply to column. If the payment covers more than one invoice, those invoices are also listed. The type of transaction that you’re creating, either a payment or an advance, appears in the Pending txn column.
  • Select Create draft payments if you’re not ready to post to the General Ledger.
  • Select Post.

You received a payment, created an advance, or created a draft payment for the selected invoice. Posted payments and draft payments appear on the Posted payments list. Posted payments are matched for reconciliation with the bank transaction. If you created an advance, it appears on the Advances list and is matched to the bank transaction for reconciliation. The bank transaction remains on the Bank transaction list, but not in the Cash in view as a payment was received.

Unassign a customer

If a transaction was incorrectly assigned to a customer, you can unassign the customer from the transaction.

  • Go to Cash Management > All > Transactions > Bank transactions.
  • From the View menu, select Cash in.
  • Select the transaction and then select Assign to the customer.
  • Select the checkbox to the left of the transaction and select Unassign and remove.
  • Select Save

Import transactions for reconciliation using Bank transaction assistant file import

Use Bank transaction assistant file import to import bank and credit card transactions into Sage Intacct for reconciliation. Transactions automatically match against Intacct transactions using the rules in the account’s rule set. It can take a few minutes for transactions to import into Intacct. Learn how and where to view transactions. While you can use the classic import experience, this method is going away no earlier than May 2026.This change does not impact any custom integrations that use the Intacct API.

If you accidentally import duplicate transactions, you can ignore duplicates during reconciliation or from the Bank transactions list.

Before you begin

  • Subscribe to Sage Cloud Services and select the option Enable Bank transaction assistant file import.
  • Enable Cash Management permissions for Bank transactions for API and import: List, Add, Delete, View.

Import a file

  • Go to Cash Management > All and select
  • Add
  • next to Bank transaction import files.
  • Select the Bank account or credit card account for which to import transactions.

If the bank account is not appearing for selection in the dropdown, the account is in the middle of a reconciliation. Either finalize the reconciliation or clear the pending reconciliation.

  • Select Continue.
  • Select a file from your device.
  • Select the file.
  • Select Open.
  • Select Review transactions.
  • Select the correct date order.
  • Select Continue.
  • Review transactions.
    Verify that transactions import correctly by identifying transactions as either Money in or Money out of the account. To switch the transaction types, select Switch transaction types.
  • Select Confirm import.
  • Select OK in the popup window.

You return to the Bank transaction import files list. After a few minutes your transactions import into Intacct. On the Bank transaction file import list, you see a status of Completed for the file import.

Create an assignment rule

Create an assignment rule on the Assignment rule page. Filter for credit type transactions and information from the description of the bank transaction that indicates the customer. After you set up your assignment rule, select Preview to preview the results.

Create an assignment rule for an account on-the-fly

Create an assignment rule on-the-fly when you’re assigning customers to unmatched bank transactions on the Bank transaction page. To create an assignment rule on-the-fly, enter the value for Sage Intacct to look for within a bank transaction description. For example, if you have a customer, ACME Customer, you might enter ACME in the Assignment mapping value field and then select Save.

  • Go to Cash Management > All > Bank transactions.
  • Go to All and select the Cash in view.
  • Select the transaction.
  • Select Assign to customer.
  • Enter a value for the Assignment mapping value.
    This value is something in the Description field of your bank transaction that identifies the transaction.
  • Select Save.

The assignment rule runs on all bank deposits for the selected bank account that are not yet matched for reconciliation. You can view the assignment rule on the Assignment rules list.

  • Go to Cash Management > Setup and select
  • Add
  • next to Assignment rules.
  • In the Assign to section, select the Customer you want to create the assignment rule for.
  • Select the Bank that receives the payment from the customer.
    If you selected a single bank account, the assignment rule will only run for that selected account. You can also select All bank accounts to apply this assignment rule to all bank accounts.
  • Enter an ID and Name.
    Enter an optional Description.
    This description is to describe and identify the assignment rule itself.
  • The status defaults to Active.
  • In the Filter transactions by section, there are two defaulted filters:
  • One filter is to target only credits to the account. You’re only targeting credits because they represent customer payments.
  • Data source: Bank transactions
  • Field: Transaction type
  • Operator: Equals
  • Value: Credit
  • The second filter is where you enter the description from the bank transaction.
  • Data source: Bank transactions
  • Field: Description
  • Operator: Contains
  • Value: Enter the description to identify the customer as it appears on bank transactions. Case sensitive.
  • Set any other filters that you might need.
  • Select Preview to view which transactions are affected by the assignment rule.
    Based on the results, make any necessary changes and then select Preview again.
  • Select Save.

The assignment rule runs on all bank deposits for the selected bank account that are not yet matched for reconciliation.

Edit an assignment rule

You might need to adjust your assignment rule so that it runs correctly. You can also preview any edits that you make.

  • Go to Cash Management > Setup > Assignment rules > Edit.
  • Make your changes.
  • Select Preview to view the transactions affected by the assignment rule.
  • Select Save.

The assignment rule runs on all bank credits for the selected bank account that are not yet matched for reconciliation.

View an assignment rule

View an assignment rule from the Assignment rules list.

Go to Cash Management > Setup > Assignment rules > View.

Deactivate an assignment rule

While you cannot delete an assignment rule that’s already assigned customers to bank transactions, you can deactivate it.

  • Go to Cash Management > Setup > Assignment rules > Edit.
  • Select Inactive from the Status dropdown.
  • Select Save.

Delete an assignment rule

You can delete an assignment rule if it has not been used to assign any customers to unmatched bank transactions. For assignment rules that have already assigned customers to transactions, deactivate the rule.

  • Go to Cash Management > Setup > Assignment rules.
  • Select the assignment rule.
  • Select Delete.

Check out our Free Additional Articles