Reconciling Successful Transactions in the Gateway

Review settled transactions in your payment gateway to confirm that their amounts match the equivalent successful payment transaction records in Salesforce Billing. Regularly reconciling your transactions this way ensures that you don’t miss instances where the payment gateway didn’t record, or inaccurately recorded, a settled transaction in Salesforce Billing. (Salesforce Billing Managed Package)

We recommend running a report in Salesforce to evaluate all your successful payment transactions at least one time a day. This way, you have fewer sets of transactions to review at one time compared to larger time periods such as a month. You can then compare the report to a report with the same parameters in your payment gateway. We recommend setting each report to sum the balance of every transaction in your daily or weekly period, so you can quickly see if any discrepancies exist between Salesforce Billing and the payment gateway.

When you reconcile every day, you can also find and correct any potential cash impacts immediately, which benefits your company and your customers.

Tip Run payment transaction reports multiple times a day following high-impact actions such as implementations, data migrations, and package updates due to the larger potential for data errors.

If you find that Salesforce Billing didn’t create a payment transaction for a settled payment, create the payment transaction in Salesforce Billing. Then, create a payment from the new payment transaction and allocate it to the invoice that should have been paid as a result of the settled transaction.