Reconciling Bank Feed Transactions

After importing bank transactions, you can use them for automated reconciliation and transaction creation.

Bank transaction matching

The Process Bank Transactions screen (CA306000) identifies the imported payments and tries to assign a match relevancy score. If you click Auto-Match, MYOB Acumatica will automatically match all relevant transactions for you. Otherwise you can match transactions from the list manually.

The matches are based on the settings on the Bank Statements tab of the Cash Management Preferences screen (CA101000).

For example, let's say an imported bank feed on the Import Bank Transactions form (CA306500) includes one transaction dated 11/07 for the receipt of $200.00 and one dated 12/07 for the receipt of $250.00. On the Process Bank Transactions screen, the $200.00 transaction has a matching record in the system with the same date and document ref. The $250.00 transaction also has a matching record in the system with the same date and document ref.

Automated bank transaction creation

You can also create new transactions to match the imported transaction to on the Process Bank Transactions form (CA306000), either manually or in an automated way using the auto-match process.

The rules used to creation transactions automatically are defined on the Bank Transaction Rules form (CA204500). For example, you can create a rule where the auto-match process will apply a bank transaction rule to create a disbursement cash transaction where the transaction description contains EFTPOS.

After processing the bank transactions, all transactions that were matched or created will be available in the bank reconciliation area with the status “Cleared” for further processing.