AX2012 R2 - Advanced Bank Reconciliation Setup

Overview

Advanced bank reconciliation is a new feature of AX2012, available from R2 onwards.

This new feature allows for the import of bank statements that can be automatically reconciled from within AX2012. This blog shows how to setup the Cash and bank management module to enable the importing of bank statements.

Cash and Bank Management Setup

Ensure that the number sequences are in Cash and bank management > Setup > Cash and bank management parameters : Number sequences

Set the bank reconciliation parameter, these are optional, but I like to at least have the amounts split between debit and credits

Browse to : Cash and bank management à Setup à Bank reconciliation à Bank statement format

Create a new record and give this an appropriate statement format description and a name. Select the inbound port that you have created above, type in the file type “xml”. But do not select the XML file checkbox (save the record and ensure this is the case).

Browse to : Cash and bank management à Setup à Bank reconciliation à Transaction code mapping

This form allows the mapping of the transaction codes on the imported bank statement to the transaction codes as held against the transaction in AX.

Bank Account Setup

The bank account will require setting up as allowing bank statement imports. From the bank account setup form (Cash and bank management > Common > Bank accounts), on the “Reconciliation” FastTab select the “Advanced bank reconciliation” checkbox.

The following message will be displayed, take note and click “OK” to continue.

The other settings on this FastTab can be set at this point.

• Statement format, this could be set here to default the statement format to be used.
• Bank name in statements – This will validate against the name as it appears in the bank statement and will validate at the point of import
• Reconcile after import – Will perform an automatic reconciliation after the file has been imported.
• Default matching rule set – Set of rules to automatically match the transactions (see later matching rules section).
• Matching rule set for manual matching – Default set of rules to manually match the transactions (see later matching rules section). Reversal rule set for manual matching – Default set of rules to manually reverse matching of the transactions (see later matching rules section). 

Reconciliation Mapping Rules

Browse to : Cash and bank management > Setup > Bank reconciliation > Reconciliation matching rules.
Create a new record giving it a matching rule and name as appropriate. Set to “Match with bank document”.

On the “Step 1” FastTab, a reconciliation can be performed against a specific value in the bank reconciliation.

To do this select the required bank statement field

Select the required Operator

Then enter the value to be found in that field in the Value field

On the “Step 2” FastTab, a reconciliation can be performed against specific documents.

Basic criteria

• Check difference amount – Allows for the amount to have a variance, set to 0.00 for no difference
• Check difference in days – Allows for the days to have a variance in the number of days between the statement transaction and the AX transaction.
• Same document number – Document number must match
• Map to the same transaction type – Transaction type must match Same payment reference – Payment reference must match

Advanced criteria


The advanced criteria section allow the matching of any of the AX field values to the bank statement values. The operator has the same value choices as per step 1 above.

The following example checks that the amount and dates match.

The following example checks that the “Payment reference” held in AX matches to the “Entry reference” on the bank statement.

The following example checks that the “Payment reference” held in AX matches to the “Reference No.” on the bank statement.

Once you are happy with the matching rule, click the “Activate” button.

Note : To edit a rule, click Deactivate first, the click Activate once the edit is complete.

Reconciliation Matching Rule Sets

Matching rule sets allow the grouping together of different matching rules into one set of rules.

Browse to : Cash and bank management > Setup > Bank reconciliation > Reconciliation matching rule sets

Create a new records and add in the matching rules required, move them up/down to suit the order in which the rules should be read.

The setups for the advanced bank reconciliation for AX2012 R2 are now complete, and you are ready to perform your bank reconciliation.