| Table of Contents |
|---|
Overview
The CE Payments Settlement Report is an interactive report built to assist with reconciling CE payments in the system and can be found in the Interactive reports module in CMA.
Use Case(s)
This interactive report assists in the reconciliation process of CE payments from Paycloud and POS.
Accessing the Tool
Click on Interactive Reports → (+) next to Accounting → CE Payments Settlements
Double click on this report to open it.
Once inside the report, pay attention to the parameters.
The Dates can be changed to incorporate the dates of the CR batches when the Group By filter is set to Transactions.
When the Group By filter is set to Settlements you can search by GJ batches.
The Filter By option is the one to use for reconciling.
...
| Info |
|---|
Please Note: The Settled Payments and Settled Ticket filters show the fee movement in your GL. This will help with the reconciliation of the Fees account. |
...
Best Practices
The Start Date and End date work in conjunction with the Group By filter.
Example: 1/1/2020-1/30/2020 with Group By Transactions will display any CR/SJ batch associated within those date ranges, including their GJ batches. This means a CR or SJ batch with transaction dates 12/30/2019, 12/31/2019, etc. with a settlement batch that falls within that date range will appear on this report as well. The Transaction Date column of the report will tell you what the transaction date of that CR/SJ batch is for, so if you see it falls outside of your date range, it is because its associated GJ batch falls within the date ranges you provided.
Example: 1/1/2020-1/30/2020 with Group By Transactions will display all GJ batches associated within those date ranges, including their CR/SJ batches. This means you will see GJ batches up there with transaction dates of 12/30/2019, 12/31/2019, etc. will be seen if their CR/SJ batches have transaction dates that fall within that date range will appear on this report as well. The Transaction Date column of the report will tell you what the transaction date of the GJ batch is for, so if you see it falls outside of your date range, it is because its associated CR/SJ batches fall within the date ranges you provided.
...
FAQs
Q: Why doesn’t my CE Payment Settlement report match my funds in transit account?
...