Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

Every payment processed such as charges, refunds and adjustments will be summarized in Payout in Webhook and once the Payout webhook event triggers, it will create Settlement records in your org.

This is a sample of the Settlement record that hasn’t been reconciled.

image-20231218-001657 (1).pngimage-20231218-001756 (1).png

After the Schedule Batch run, the Settlement Record will be updated.

  • Gateway Transaction Total indicates the total amount of all Gateway Transactions linked to the Settlement Records.

  • Gateway Refund Total indicates the total refund amount of all transactions related to its settlement. The system will calculate all refund amounts from the gateway provider’s webhook request.

  • Gateway Adjustment Total indicates the total adjustment amount of all Gateway Transaction records related to Settlement records.

  • Gateway Fee Total indicates the total fee accumulated from all transactions related to its settlement.

  • Reconciliation Balance indicates the difference of subtracting the Gateway Transaction Total to the Gateway Refund Total and the Gateway Adjustment Total. The calculation should result to zero (0) to reconcile settlement in the system.

  • Reconciliation Status indicates the current status of the reconciliation process of a settlement.

    • If the Reconciliation balance matches the Amount then the Reconciliation Status will be set to Reconciled, otherwise if not match a PosiPay log will be created.

image-20231218-002030.pngimage-20231218-002040.png

Compare Gateway Transactions linked to the Settlement record and the Payout Summary in the Stripe Dashboard.

  • For Charges,

    • Check if the number of Gateway Transaction records matches in the Payout Summary.

    • Check if the total charge amount of all Gateway Transaction records matches in the Payout Summary.

    • Check if the total Gateway Fee of all Gateway Accounts records related to this settlement matches in the Payout Summary.

  • Do the same checking with Refunds and Adjustment.

edbae8a9-7b4e-4894-8d91-cf43ef11239a.png

When there is any error in any part of the process, a PosiPay Log will be created.

  • Source = Stripe Gateway Settlement Reconciliation

  • Details = error message from a failed process

  • Type = Error

image-20231218-003632.png

  • No labels