Generating a reconciliation Settlement Statement for payment reporting

This article provides instructions on how to view and download a Settlement Statement for a school, which includes details of card payments and refunds. Users need the Finance: View permission to access the statement, and can filter results by date and specific columns before downloading.

Permissions

You'll need the Finance: View permission to view and download the settlement statement. If you don't have the permission, you'll need to ask your admin team to give you permission using these instructions.

Generating the Settlement Statement

The settlement statement allows you to view and download the list of card payments and refunds (with their accounting codes) made on the school account. 

Card payments and refunds settle on your bank accounts in three-four business days after the payout happens. Once these funds are settled, you will be able to see them in the Settlement Statement.

To get to the Settlement Statement go to School > Payments > Reconciliation >Card Payments> Settlement Statement.

Click the green Change button in the filter bar to edit the dates that you want to report on.

Make sure to click Apply once you have set your dates.

This will then generate your Settlement Statement. Click the Download button to export this out of Arbor.

You can also filter the actual columns on the table (such as Customer Account Type or Description).

You can do this by:

1. Click the little arrow next to the column you want to filter.
2. Click the filter icon
3. Select in the tick boxes the results you want to see
4. Click somewhere on the page to remove the little pop up and see the results