Reconciliation report template

Overview

The reconciliation report template helps you to reconcile your transactions with your bank statement. The report includes information you may require to calculate the revenue over a period of time, taking into account sales, refunds, and other actions.

A reconciliation report is a custom report template that you can generate from the OnlinePay dashboard. For more information about custom reports, see Custom reports.

Create a reconciliation report

To create a reconciliation report template:

1. Log in to the OnlinePay dashboard and navigate to Commerce > Reporting > Orders/Transactions.
2. Select the Transactions option on the toggle.
3. Select the date range for your report.
4. Select the organisation/s you want to include in the report.
5. Add the Transaction type filter, then select the following transaction types:
   • Capture
   • Sale
   • Refund
6. Add the Transaction state filter, then select the following transaction status:
   • Settled
7. Click Export CSV to download the report.

Create a reconciliation report template

To create a reconciliation report template:

1. Log in to the OnlinePay dashboard and navigate to Commerce > Reporting > Orders/Transactions.
2. Select any filter other than the date range.
3. Click Export CSV when it appears, then click Manage templates.
4. In the Transactions report templates page, click Create template.
5. On the Add template page, provide the following information:
   • Template name: Enter a name for the template.
   • Organisation: Select the organisation for which you want to create the template. Optionally, select the Share to all sub-organisations checkbox to share the template with all sub-organisations of the selected organisation.
6. Select the following fields to include in the report:
   • Organisation Name
   • Merchant ID
   • Creation Date
   • Creation Time
   • Original Amount
   • Currency
   • Current Amount
   • Current Amount Currency
   • Transaction type
   • Transaction ID
7. When you have finished, click Save Template.

The reconciliation report template is now available for use when exporting reports from the Export CSV drop-down Report Template list on the Orders/Transactions page.