A Payments Report is a useful tool for businesses that accept payments from customers. It provides a detailed breakdown of all the payments received during a specific time period, typically at the end of the day.
By regularly generating and reviewing payments reports, businesses can ensure the accuracy of their financial records and make informed decisions for the future.
Tracking Payments
The summary panel at the top of the report gives you a quick overview of your financial activity for the selected period. It shows Total Payments, Total Refunds, Total Sales, Total Discounts, and Total Credit Issued.
The payment method chart includes a toggle to switch between Total Payments and Payments Less Refunds. This lets you see what you actually received after refunds at a glance, without changing any filters.
The card type chart has its own toggle: Total Cards (All), Integrated, or Manual. Use this to isolate card payments processed through your terminal or online from those manually entered as card payments - useful when reconciling against your payment processor.
π The summary panel defaults to today's date. When you change the date in the panel, the data refreshes immediately and the table filter below updates to match automatically.
Identifying Discrepancies
Another important use of a payments report is to identify any discrepancies in the cash received. By comparing the payments report to the cash in the register or card terminal totals, you can ensure that all payments have been accurately recorded. Any discrepancies can then be investigated and resolved, preventing potential losses for the business.
Filters
Various filters are available including:
the date - set a From and To date to define your range (the default is Today)
a particular client - for an overview of payments by client
Refund/Credit - filter to see All, Refunds only or Credit only
Payment source - filter by All, Integrated (terminal and online payments processed through DSP & CareCredit), or Manual
the payment method (card, cash, bank transfer, etc.)
staff member - the person that received the payment i.e. cashier
Wellness Plan - whether the payment is a wellness plan subscription
After selecting the desired filters, click Search.
π The date filter stays in sync between the summary panel and the table. Change the date in the panel and the table filter updates automatically. Change the date in the table filters and click Search - the summary panel refreshes to match.
Table
The report displays the date & time of the transaction, as well as the record or counter sale link (and the patient, too), the client's name, the description of the payment, the payment method, and the amount.
The refunds or reversal are marked in red.
When credit results from a payment, you are able to track this credit available and used.
The positive value (+) is the credit available to be used from the payment.
The negative value (-) is the portion of the credit that has been allocated / used.
Example:
Client A is charged for a service yesterday and pays you $200 more that the Sale Total.
At the end of yesterday your Payment Report Credit will appear as +$200
Client A visits today again and buys a $5 pet treat for which they pay using their existing Client Credit.
At the end of today if you revisit the Payment Report for yesterday, your Credit will appear as +$195 | -$5.00
π The $5.00 will not appear on today's Payment Report, as no tangible funds transacted today.
π This credit is created when a client pays more than is owing or a payment was received but not yet allocated to a sale.
Each transaction has the following actions:
preview payment receipt > to view and reprint a receipt
refund payment > to return funds to the client
edit payment > to change / update the amount, the payment method or card type, the date, and the description
delete payment > to remove a payment (a confirmation popup will appear to confirm this action)
πSome permissions are necessary to perform some of the above actions
This table can be easily exported in PDF or CSV for further analysis if needed.
What is a CSV file?
CSV is a widely compatible data file format which can be opened directly in Excel
π Larger reports will be sent via email and will not download directly






