...

• 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?

...

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