You can generate a Disbursement Summary report to reconcile a withdrawal disbursement (payout). Perform reconciliation regularly to catch any discrepancies early and maintain accurate financial records.
This article shows you how to generate a Disbursement Summary report and use specific values to perform a manual reconciliation of the disbursement total. Users can have different reconciliation processes, so this process might vary if you’re performing a reconciliation through other accounting software.
Note
Reconciliation is the process of comparing your financial records, usually over a longer period, to ensure that the withdrawn amount matches the intended disbursement amount, used by merchants under Statement (Gross) Billing.
Balancing is the process of maintaining financial equilibrium by verifying that your total daily disbursements align with your available balance and financial goals, used by merchants under Net Billing.
Reconcile with a Disbursement Summary Report
Complete all steps in the following sections.
Configure Your Disbursement Summary Report
Under Admin in the main side bar, select Reports then Standard Reports.
From the Select Report dropdown menu, select Disbursement Summary.
Select Include all up-to-date data.
In the Report Date dropdown menu, select Today for daily reconciliation.
(Optional) In the Templates dropdown menu, select a previously saved report template or create a new one from the parameters being set by clicking Add Template.
(Optional) In the Filter By dropdown menu, add a filter for Divisions, merchants, or include both.
Click Advanced Filters in the upper-right corner to add the following data columns to the Disbursement Summary report that are recommended for manual reconciliation:
Sales: Disbursement totals from transaction sales
Refunds: Disbursement totals from a payment or fee refund
Disputes: Disbursement totals from won chargeback disputes
Fees: Disbursement totals from fees received from other entities
Tip
If you create filters for a report that you regularly generate, be sure to save it as a template under the Templates dropdown menu to automatically recall your report filtering settings from the previously generated report.
Click Generate Report to generate your Disbursement Summary report.
Click the CSV or XLS download icon in the upper-right corner of the page to download the report to an Excel-readable format for manual reconciliation outside of the Portal or to import it into your preferred accounting software.
Tip
The report is also available on the Report History page for a limited time. You can use the data in various ways to help improve your business or just for metrics tracking.
Reconcile Your Payout Disbursement
Add the totals of the Sales, Refunds, Disputes, Fees, and Other column values to calculate your expected total for the given disbursement.
Note
Certain interchange fees that amount to less than a full cent ($0.01) are displayed under Not Disbursed on a Disbursement Summary as an undisbursed amount rollover.
Compare your expected total against the Total column to check for any discrepancies.
No discrepancies: If the disbursement totals have no discrepancies, you can finalize and complete your reconciliation process.
Disbursement discrepancy: If you identify any discrepancies in the disbursement total comparison process, proceed to the next step.
Using the corresponding Date, Entity ID, and Entity Name column information, investigate and resolve any issues causing discrepancies, such as missed transactions or calculation errors.
Important!
Verify time periods shown under the Date column to ensure you are reconciling the correct transactions.
Result: After resolving any discrepancies, you can finalize your disbursement totals and complete the reconciliation process to save for your records. If you identify any calculation errors from the platform, submit a Partner Services ticket for assistance in resolving the error.
Next Steps
When you’re familiar with this process, review the following articles for additional actions using different reports:
Reconcile Negative Disbursements with a Disbursement Report: Use a Disbursement Summary report to reconcile totals debited from a bank account.