How to generate a payments report (Stripe users)

The Reporting section will only be available if your practice uses Stripe as your payment provider.

Alongside the Generate Reports tab, the Reporting section allows you to see your Payment Activity and Payouts, which can assist in reconciling the HotDoc payments that make up your Stripe payout.

Please view the following instructions for how to use these features.

• How to Generate Reports
• How to view Payment Activity breakdown 
• How to see an overview of your Payouts 
  
  

How to Generate Reports

The Generate Reports tab allows you to download a comprehensive spreadsheet of your payments to help with calculating payments per practitioner. 

1. Whilst in Payments > Reporting, click on the Generate Report tab.
   
   
   
   
2. Select a date range using the calendar, then click the Download button.
   
   
   
   
3. A CSV. file will then be downloaded to your computer called "HotDoc-payments-revenue-from-[date range]". Open this file to view your payments report! 
   
   

How to view Payment Activity breakdown 

This tab provides a comprehensive list and breakdown of a patient's payment, and the overall payment that contribute to a Stripe payout.

To view this:

1. Whilst in Payments > Reporting, click on the Payment Activity tab.
   
   
   
2. Here you will see a breakdown of:
   • Charge Date: Date the payment request was created (when a booking was made by the patient, or the practice did a payment request via the Dashboard)
   • Patient Details: Patients name in your practice management software (PMS)
   • Practitioner: Name of the practitioner in your PMS
   • Appointment Type / Description: 
   • Charged - The amount the patient paid (or will pay, if the charge is Pending)
   • Fees - The payment fees
   • Net - The total the practice received
   • Payment Status - The patient's payment status
   • Payout Date - The date this payment was paid to the practice's linked bank account. Click the View Details to be taken to the Payouts page.
     
     
     
     

How to see an overview of your Payouts 

The payouts section shows a list of all payouts that have been transferred from Stripe to your bank account. 

1. Navigate to Payments > Reporting, then click on the Payouts tab:
   
   
   
   
   
2. If required, you can filter by Charge Date Range. Clicking the View Details button at the right of a payout will take you to the Payout Details page.
   
   
   
3. At the top of the Payout Details page, you'll be shown the total payout amount, Date Paid, Stripe Payout ID and a View button to see this payout in your Stripe dashboard.
   

   Note: The total payout amount consists of all Stripe payments, including payouts from HotDoc Repeats, if you use this feature.  It also takes into account any refunds and anything else you use Stripe for.

   
   
   
4. Underneath the payout details summary, you'll see a list of the separate patient payments within this payout.