How do I calculate the holding amount in my settlement report?

Download your settlement report and identify transaction types. Use the provided formulas to calculate the holding amount. Ensure the sum of the settlement amount matches the expected bank deposit.

To calculate the holding amount in your settlement report, follow these steps:

Step-by-Step Guide:

1. Download Your Settlement Report:

   • Follow the steps outlined in our support article to download your settlement report: How to Download a Settlement Report from the Tazapay Dashboard.

2. Sample Report:

   • Alternatively, you can download a sample report for reference: Download Sample Settlement Report.

3. Understand Transaction Types:

   • Note that your settlement report contains many different types of transactions. Refer to the ID and the code it starts with:
     • COL: Collection
     • RFD: Refund
     • PAT: Checkout
     • POT: Payout
     • ST: Settlement Fee

4. Calculate Holding Amount:
   

   1. • For collections, refunds, and checkouts, use the following formula:

   Holding Amount = Holding Exchange Rate x Net Amount (with fees) in Invoice Currency

   • • For payouts, use the following formula:

   Holding Amount = Net Amount (with fees) in Payout Currency / Holding Exchange Rate

5. Verify Settlement Amount:

   • Note that the sum of the settlement amount should be the amount you expect to hit your bank account.