Reconciliation Dashboard - Settlement Overview

Document Overview: 

The Settlements Overview tab is used to identify a complete reconciliation by comparing z-out credit card revenue vs the settlement payouts for the same date. Incomplete reconciliations will be a red transaction line with a revenue total of transactions that have not been paid out and the No SID button.

To access the Settlement Overview tab, use the tabs at the top navigation of the foreUP Payments dashboard, then use the start date and end date fields to set the range.

Settlement Overview:

The header box for the chart displays the z-out total compared to the settlement total.

• Z-Out Total: The sum of all the z-out totals in the searched date range parameter. A green checkmark or red x will indicate whether or not credit card revenue is reconciled for that date range.
• Settlement Total: The sum of all the settlement totals in the searched date range parameter. A green or red checkmark will indicate whether or not credit card revenue is reconciled for that for that date range.

The data chart displays a quick view of settlement details for all settlements in the specified date range. To adjust the date range, use the start date and end date fields in the top right. The column headers are defined as follows:

• Z-Out Date: The Z-out date in the foreUP system.
• Z-Out Total: The Z-out credit card revenue total in the foreUP system.
  • Note: This first iteration of the report has a single terminal, a future iteration will have Z-out totals by terminal.
• Settlement Total: The Settlement Total is the sum of paid-out transactions in the settlement for a specific z-out date. This column is the sum of the Amount column for the specified z-out date.
• Terminal: The terminal in the foreUP software where transactions were run
• Settlement ID: Settlement IDs that include payouts for transactions for the specified z-out date. Multiple Settlement IDs may exist for one z-out date
• Settlement Date: The date the settlement was created within the specified Z-out date.
• Amount: The sum of the paid-out transactions in the settlement for the specific Z-out date. When terminals are released, this will be sorted per terminal.
  • Note: This column may not match the deposit totals and should not be used for this purpose
• Settlement Status: The status of the settlement at the time of the report being pulled. The status will show either Pending or Approved.
  • Pending: The settlement is waiting to be cleared by foreUP to be paid out.
  • Approved: The settlement has been approved for payout and the funds are being transferred to the Merchant.
• Actions:
  • Details: Use the Details button from this column to access the Settlement Details page for that specific date

• • Unsettled: Use the Unsettled button from this column to access the No Settlement ID page for that specific date

To export the report as a CSV file, use the CSV Button located next to the date selector