Reconciling payouts
Payouts can be reconciled either in the console or by downloading a csv report. When reconciling a payout, the primary items to verify are the:
- Payout amount
- Net amount of transactions associated with the payout
- Amount deposited in the merchant’s bank account
Reconciling in the console
To reconcile a payout in the console, follow these steps:
- Go to "Reports" > "Payouts"
- Click into the payout that is to be reconciled
- Verify that the amount in the “Payout Overview” widget is equal to the net payout amount in the “Summary” widget
Reconciling using a csv report
To reconcile a payout using a csv report, follow these steps:
- Go to "Reports" > "Downloads"
- Locate the Payout report and click the “Generate Report” button
- Enter a report name and select a merchant and date range
- Click the “Generate” button
- Open the csv file (the following steps assume the file has been opened in Excel)
- Click the “Custom Sort” option
- Sort by the “payout id”, followed by the “source id”
- Sum all transactions associated with a payout
- Verify that the sum of all transactions associated with the payout is equal to the payout amount