Use Case: Reconcile Daily Funding

You can reconcile your daily funds with the Funding Summary report. This tutorial shows you how to use specific fields in a Funding Summary report to reconcile your funding activity.

Audience: Partner, Merchant

Reconcile Partner Funding Activity

Complete all steps in the following sections.

Prerequisites

Before attempting this tutorial, you must:

• Meet the general prerequisites described in Get Started with Use Case Tutorials.

• Generate a Funding Summary report that includes funding data across consecutive funding dates. We recommend generating a weekly or monthly report, depending on how you plan to reconcile your accounts.

Identify Key Fields for Reconciliation

In your Funding Summary report:

1. Filter the Entity Type column to display only rows where the value is Partner. This ensures that the report displays only the funding activity relevant to your account.

2. Locate the following columns, which contain the values you need for reconciliation:

   • Prior Undisbursed Amount: The amount available for disbursement from previous days but not yet sent to your bank account. Think of this as your start-of-day balance.

   • Total Funded Amount: The total amount scheduled on the funding date to be credited to your bank account

   • Total Fee: The total amount of fees paid to Worldpay for Platforms

   • Total Other Txn Charges: The total amount of other charges impacting your account balance, including refunds, chargebacks, adjustments, and fee refunds

   • Current Undisbursed Amount: The amount not disbursed on the funding date. Think of this as your end-of-day balance. This amount will be carried over to the next day and reflected in the Prior Undisbursed Amount column for the next funding date.

Reconcile Undisbursed Amounts

Using the fields that you identified in the previous step:

1. Use the following formula to calculate the amount that’s not disbursed on the funding date:
   Prior Undisbursed Amount − Total Funded Amount + Total Fee + Total Other Txn Charges = Undisbursed amount

2. Verify that the calculated amount matches the Current Undisbursed Amount value in the same row of your report.

Result: Your daily funding activity is reconciled. The Current Undisbursed Amount value should equal the next funding date’s Prior Undisbursed Amount. If you identify any discrepancies, contact Partner Services for help.

Partner Reconciliation Example

The following table shows the key fields in a Funding Summary report for Partner A across two consecutive funding dates:

To reconcile Partner A’s funding activity for August 1, calculate the undisbursed amount:

$20,000 − $6,000 + (-$3,000) + $0 = $11,000

The calculated amount matches the values in the Current Undisbursed Amount column for August 1 and the Prior Undisbursed Amount column for August 2.

Reconcile Merchant Funding Activity

Complete all steps in the following sections.

Prerequisites

Before you begin, you must:

• Meet the general prerequisites described in Get Started with Use Case Tutorials.

• Generate a Funding Summary report that includes funding data across consecutive funding dates. We recommend generating a weekly or monthly report, depending on how you plan to reconcile your accounts.

Identify Key Fields for Reconciliation

In your Funding Summary report, locate the following columns, which contain the values you need for reconciliation:

• Captured Transaction Amount: The total transaction amount that is captured by Worldpay for Platforms and is ready for settlement

• Prior Undisbursed Amount: The amount available for disbursement from previous days but not yet sent to your bank account. Think of this as your start-of-day balance.

• Total Funded Amount: The total amount scheduled on the funding date to be credited to your bank account

• Total Other Txn Charges: The total amount of other charges impacting your account balance, including fees, refunds, chargebacks, adjustments, and fee refunds

• Current Undisbursed Amount: The amount not disbursed on the funding date. Think of this as your end-of-day balance. This amount will be carried over to the next day and reflected in the Prior Undisbursed Amount column for the next funding date.

Reconcile Undisbursed Amounts

Using the fields that you identified in the previous step:

1. Use the following formula to calculate the amount that’s not disbursed on the funding date:
   Captured Transaction Amount + Prior Undisbursed Amount + Total Funded Amount + Total Other Txn Charges = Undisbursed amount

2. Verify that the calculated amount matches the Current Undisbursed Amount value in the same row of your report.

Result: Your daily funding activity is reconciled. The Current Undisbursed Amount value should equal the next funding date’s Prior Undisbursed Amount. If you identify any discrepancies, contact Partner Services for help.

Merchant Reconciliation Example

The following table shows the key fields in a Funding Summary report for Sam’s Pizza across two consecutive funding dates:

To reconcile Sam’s Pizza’s funding activity for August 1, calculate the undisbursed amount:

$1,000 + $500 + (-$500) + (-$100) = $900

The calculated amount matches the values in the Current Undisbursed Amount column for August 1 and the Prior Undisbursed Amount column for August 2.