Finance: Matching of Bank Transactions to Debit Adjustments

In previous versions of MYOB Acumatica, a receipt bank transaction could not be matched to a debit adjustment, and debit adjustments were not shown on the Match to Invoices tab of the Process Bank Transactions (CA306000) form. As a result, when performing bank reconciliation, a user had to match each debit adjustment individually to a bank transaction on the Create Payment tab of this form. The auto-matching process did not support the matching of bank transactions to debit adjustments either.

Starting in MYOB Acumatica 2025.1, users can match a receipt bank transaction to a debit adjustment on the Match to Invoices tab of the Process Bank Transactions form. Alternatively, users can perform the auto-matching process for this purpose.

Changes to the Cash Management Preferences Form

On the Bank Statements tab of the Cash Management Preferences (CA101000) form, the Allow Matching to Debit Adjustment check box has been added to the Receipt Matching section, as shown in the following screenshot.

Figure 1. The new check box on the Cash Management Preferences form

If this check box is selected, the system will allow the matching of receipt bank transactions to AP debit adjustments. If the check box is cleared (the default value), receipt bank transactions are matched to AR invoices.

Changes to the Process Bank Transactions Form

On the Process Bank Transactions (CA306000) form, the Transaction Matching Settings dialog box opens when a user clicks Match Settings on the form toolbar. The Allow Matching to Debit Adjustment check box has been added to this dialog box, as shown in the following screenshot.

Figure 2. The new check box on the Process Bank Transactions form

To match a receipt bank transaction to a debit adjustment, a user should perform the following general steps:

On the Import Bank Transactions (CA306500) form, the user uploads the bank statement file for the needed cash account and period and clicks Process Transactions on the form toolbar.
On the Process Bank Transactions (CA306000) form, the user selects the receipt bank transaction in the left pane and goes to the Match to Invoices tab.
On this tab, the system loads the documents that match the selected bank transaction.
The user selects the Matched check box for the debit adjustment to match it to the bank transaction, as shown in the following screenshot.
Figure 3. A bank transaction matched to a debit adjustment
The user completes the matching of bank transactions and clicks Process on the form toolbar.

When the processing is completed, for each receipt transaction matched to a debit adjustment, the system will create a refund. For this document, the Ext. Ref. Nbr. setting of the bank transaction shown in the left pane on the Process Bank Transactions form will be copied to the Payment Ref. box on the Checks and Payments (AP302000) form, as shown in the following screenshot.

Figure 4. The created refund with the debit adjustment applied to it

Additional Information

For more details, see Bank Reconciliation: Transaction Matching.

For an example of matching a bank transaction to a debit adjustment, see Bank Reconciliation: To Process a Bank Statement in OFX Format (Part 2).