| 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 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?
...
Scenario 3: The reason the Transaction Column has detail in this situation is because the report parameters are 1/1/2020-1/30/2020 with a Group By set to Transactions. The transaction date of this SJ batch falls within the date range on the report so the details are displaying in the Transaction Date column with a dollar amount. Since the GJ batch also falls within this date range the detail in the Amount, Fees, and Net Settlement columns are showing for GJ000177.
...
Downloadable Guide
| View file | ||
|---|---|---|
|
...