How to Reconcile DSP Payments with Stripe
Most day-to-day reconciliation can now be done entirely from the Payments Report - no need to log into the DSP (Stripe) Dashboard.
Export the DSP Transactions Report to get a single CSV with your card charges, refunds, DSP fees, and Stripe payout details already matched to your Digitail data.
💡 Front desk and reception staff no longer need Stripe (DSP) Dashboard access to complete day-end reconciliation. We recommend keeping Stripe Dashboard access limited to your Practice Manager or Owner - this protects your Stripe account while your team still reconciles day to day using the export.
Recommended:
Reconcile using the DSP Transactions Report export
Go to Reports - Billing & Payments - Payments Report.
Set your Date range (and any other filters you need).
Click the Export menu and choose Export DSP Report.
Open the CSV - it already includes charges and refunds, and, for users with the Export DSP Bank Reconciliation permission, DSP fees, Stripe payout amounts, and payout dates.
Compare the totals to your bank deposit or cash-up for the period.
Note: Reception staff without the Export DSP Bank Reconciliation permission see a payment reconciliation view without processor fees. Give your Practice Manager or bookkeeper this permission if they need to match totals against Stripe payouts.
For filters, permission requirements, and troubleshooting, see Export the DSP Transactions Report.
Advanced:
Reconciling directly with the DSP (Stripe) Dashboard
Use this method only if you need to verify a specific payout or investigate a dispute directly in Stripe. It requires access to the DSP (Stripe) Dashboard - we recommend limiting this access to your Practice Manager or Owner, since it isn't needed for routine day-end reconciliation.
‼️DSP (Stripe) charges and subtracts the fee on a transaction level.
Net Revenue in DSP (Stripe) report is Revenue after the fee.
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.
❗The date and time of transactions in the DSP (Stripe) report are shown in Eastern Time (ET) timezone
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.
‼️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.