Matching ledger entries with PSP payments
Important
Available for version 6.2.0.0 or higher.
To enable the matching of ledger entries with payment lines imported from a PSP, it is essential to configure specific settings for the External Payment Reference field in the Payment Management setup. This field is included in sales documents and customer ledger entries, allowing it to be matched with the corresponding reference field specified in the imported file. Successful reconciliation takes place when these two fields have identical values. By accurately specifying the relevant fields or columns for each PSP, we ensure precise reconciliation based on the payment references provided within the file.
Important
Only users with the CPM365 ADMIN, SUPER, or CPM PSP IMPORT permission set can create PSP agreements and import PSP files.
To apply External Payment Reference field settings to prepare to add a PSP agreement:
Use the
icon, search for Payment Management Setup and select the related link.Navigate to the FastTab Payment Receipt Import, and enter information for the following fields:
- Update External Payment Reference - select the field to use on sales documents as the reference number. You can choose from the following options: Using Custom Field, Using Your Reference, Using External Document No.
- Custom External Payment Reference Field Name - Select the appropriate field from the Sales Header table if you selected Using Custom Field in the Update External Payment Reference field.
Payment Management now prompts you to update External Payment Reference in not posted sales documents and open the customer ledger entries.
If the standard payment reference field in the file is not suitable for reconciliation and a custom field is needed, you can refer to the PSP Reconciliation Setup for instructions on how to configure it. This setup enables you to customize the reconciliation process according to your needs.
Go to the PSP Agreement you want to set up the reconciliation for.
On the action menu, select Related > PSP Reconciliation Setup.
In the PSP Reconciliation window, you can now use the following settings:
Extended Search – enable if you want to find ledger entries based on not only reference number but also on posting date and amount.
Posting Date Tolerance – specify a tolerance for the number of days that posting days can deviate when using Extended Search.
Payment Reference Position – this setting determines which field is used as the payment reference value. The default values are pre-filled and explained for each PSP. However, you can choose a custom field position in the file if necessary. Please note that the field position is represented by an integer value starting from 0. For example, in Excel, column A would be 0, column B would be 1, and so on.
Date Format – this setting is utilized during file import to ensure the correct formatting of the posting date. While default values are provided, it is important to adjust the date settings to match the local or date settings of the downloaded file if they differ.
Note
The date format is based on the .NET DateTime format.