How to Reconcile DSP Payments with Stripe
Reconciling your DSP payment with Stripe is a simple process that requires two reports: one from DSP (Stripe) Dashboard and one from Digitail. In this article, we will walk you through the steps to reconcile your payments.
Accessing and Exporting the DSP (Stripe) Report
Go to the Administration page in Digitail
Select the Integrations tab on the left
Navigate to Digitail secure payment
Click on the Dashboard icon. This will launch the DSP (Stripe) dashboard.
On the dashboard:
Navigate to the Balance tab on the left
Use the Filter option to select
Date,
is equal to
enter the relevant date
click Done.
You will see a filtered list of transactions.
Click on the Export button and either leave the date as custom or select Today.
This depends on the reconciliation to are trying to complete.
Click on Export to create a csv file in your downloads folder.
Exporting the Digitail Payment Report
To export the Digitail report, follow these steps:
Navigate to the Reports menu > Financial reports and select Payments
Use the Filters to select
the same date range used in DSP (Stripe) export, and
select Payment method as Card
Click Search
Click on CSV to export this report into your downloads folder.
Reconciling the Totals
Once you have both reports exported, you can move on to reconciling the totals. Follow these steps:
On the DSP (Stripe) balance history spreadsheet
SUM the amount column.
On the Digitail transactions spreadsheet
add a filter to the description field, and
filter for text that contains 'digitail'
SUBTOTAL the Total column.
+subtotal(9, [select cell range])
Ensure that the columns being summed have two decimals visible, by selecting the column type as Number or Currency
The Digitail Payment Subtotal should tally to the DSP (Stripe) Total, indicating that your payments have been successfully reconciled.
Important Note❗
In order for the reconciliation to work, the automated description text added when a DSP payment is processed should not be removed. This text is necessary for accurately matching payments between DSP (Stripe) and Digitail.