Setup

Click on the link Open the Payment Reconciliation Setup Guide

1. Click on the search button.
2. Click on the field Tell me what you want to do - Type Payment Reconciliation Setup.
3. Click on Payment Reconciliation Setup Wizard Administration .
   Or go to the Payment Reconciliation Setup without the Wizard to assist.

Click on the button Next

• Set the field Payment Recon No. Series.
  The No. series which allocates a new number for payment reconciliation worksheets.
• Set the field Bank Journal No. Series.
  The General Journal template name used for creating journal entries after matching the bank statement lines.
• Click on the button Next.

• Set the field Bank Journal Template.
  The journal template used for creating journal entries after matching the bank statement lines. This is normally GENERAL.
• Set the field Bank Journal Batch Name.
  The journal batch name used for creating journal entries after matching the bank statement lines. BPMTREC is a new batch installed by the extension, but you can change it here.
• Set the field Intercompany Template.
  The Intercompany Journal template name used for creating intercompany journal entries after matching the bank statement lines with an IC partner.
• Set the field Intercompany Batch Name.
  The Intercompany Journal batch name used for creating intercompany journal entries after matching the bank statement lines with an IC partner.
• Click on the Auto Post Journal on Transfer toggle.
  Engage this toggle this field if you want the system to automatically post the journal entries resulting from the payment reconciliation matching when you transfer the matched entries to journal.
• Click on the button Next.

• Set the field Bank Journal Source Code.
  This is a new Source Code the extension will install, "BPMTREC".
• Set the field Bank Journal Source Code Name.
• Set the field Transfer Entries Source Code.
• Set the field Transfer Entries Source Code Name.
• Click on the button Next.

• Set the field Reference 1 Caption. This is often 'Particulars'.
• Set the field Reference 2 Caption. This is often 'Code'.
• Set the field Reference 3 Caption. This is often 'Reference'.
• Set the field Payment Tolerance Date. Commonly set to 2D (2 days).
• Click on the button Next.

Click on the navigation menu item popup Cash Management

Click on the navigation menu item Bank Accounts

Select the bank account you want to modify. This guide demonstrates bank statement reconciliation for the CHECKING bank account.

1. Click on the button Show more on the General tab.
2. You can select the standard Match Tolerance Type Percentage or Amount. When matching statement lines in the Payment Reconciliation worksheet, the system will find matching ledger entry amounts including this tolerance, irrespective of the statement amount sign. Depending on your selection in Match Tolerance Type, enter the Match Tolerance Value.
3. This extension adds the Filter Payment Reconciliation. The payment reconciliation page will be automatically filtered for this account if set.
4. Also added is the Auto Post Bank Reconciliation which specifies if the journal will be posted and matched automatically.

You can define the Bank Statement Import Format code to use under the Transfer tab.

Click on the navigation menu item Bank Accounts

Click on the No. for the relevant Bank Account

Click on the lookup button Bank Statement Import Format

Click on the link Select from full list

Note the Data Exch. Def. Code on the selected line. This will be the Data Exchange Definition code we need to modify. In this example it is ASB CSV

1. Click on the search button.
2. Click on the field Tell me what you want to do - Enter Tell me what you want to do.
3. Click on Data Exchange Definitions Lists .

Click on the link in cell Code with the value ASB CSV

Click on the navigation menu item popup Manage

Click on the navigation menu item Field Mapping

Click on the cell Column No.

Select the Column Name for Particulars

Click on the lookup button in the cell Field ID

1. Click on the Search button - Enter the text Reference1.
2. Click on the link in cell No. with the value 70254115.

Click on Optional

Click on the cell Column No.

Select the Column Name for Code

Click on the lookup button in the cell Field ID

1. Click the Search button - Enter the text Reference2.
2. Click on the link in cell No. with the value 70254116.

Click on Optional

Click on the cell Column No.

Select the Column Name for Reference

Click on the lookup button in the cell Field ID

1. Click on the Search button - Enter the text Reference3.
2. Click on the link in cell No. with the value 70254117.

Click on Optional

Transformation Rule

If you select the UPPERCASE rule on the Code column, when the bank statement file is imported in the "Bank Account Reconciliation" page, the text in this column will be converted to uppercase.

1. Click on the field Code - Enter the text COtoC0.
2. Click on the field Description - Enter the text CO to C0.
3. Click on the field Transformation Type.
4. Click on the item Replace in the list.

1. Click on the field Find Value - Enter the text CO.
2. Click on the field Replace Value - Enter the text C0.
3. Click on the textarea Test Text - Enter the text CO1234.
4. Click on the field Update.
5. See the Result to see the letter C followed by numbers zero, one, two, three, four.
6. Click on the button OK.