Revenue report by payment method in the dental practice
How to read and check the revenue report by payment method: cash, card/POS, bank transfers, financing, deposits, and refunds, with an example of a month-end closing.

Collections Report by Payment Method for Dental Practices
The collections report by payment method breaks down the money actually received by the practice during a selected period based on the method used: cash, debit/credit card via POS, bank transfer, patient financing, and so on. It serves three purposes: it allows you to reconcile the cash drawer with your bank statement, understand how your patients pay, and provide clean data to your accountant. Here you will find how to read it, which items it contains, how to distinguish it from revenue, and which checks to perform before exporting it, complete with a monthly closing example.
TreatbaseKeep track of collections and invoicesTreatbase combines invoice management and treatment monitoring into software designed specifically for dental practices.Discover Treatbase
In Brief
The report shows collections, not revenue: an invoice issued but unpaid will not appear, while a deposit received without a final balance invoice will.
Each payment method has an external check: POS transactions match the acquirer's statement, bank transfers match the bank statement, and cash matches the physical cash drawer.
Deposits, partial payments, refunds, and chargebacks must be reviewed separately; otherwise, the total can be misleading.
The payment method also matters outside the practice: it impacts patient tax deductions and, starting in 2026, the connection between POS terminals and electronic cash registers.
Export only after reconciliation: handing an incorrect report to the accountant ends up wasting more time than it saves.
Table of Contents
Why the report is essential for a dental practice
Collections, revenue, and cash flow: the differences
Report line items and how to read them
Payment methods and patient tax deductions
How to set periods and filters
Example: a monthly closing
Checks to perform before exporting
Our perspective
Collections and invoicing in a single management software
Frequently asked questions
Sources
Why the Report Is Essential for a Dental Practice
In a dental practice, money comes in through very different channels. A hygiene patient pays €90 by debit card on their way out. A patient starting an implant plan pays a deposit by bank transfer, then pays in installments via a financing company that disburses the total amount a few days later. An elderly patient brings cash. Consequently, looking at the month-end total alone tells you very little.
The payment method report answers concrete questions that the front desk and practice owner face every week:
Does the cash balance match? If the report states €1,340 in cash and there is €1,290 in the drawer, that discrepancy needs an explanation today, not at the end of the year.
Did the POS settle everything? Card transactions hit the bank account net of processing fees and with a few days' delay: the report tells you what to expect.
How much goes through patient financing? If an increasing share of treatment plans relies on consumer credit, this directly impacts your liquidity and merchant fees.
How much remains in cash? A high proportion of cash means more time spent counting, a higher risk of error, and extra trips to deposit money at the bank.
For the office manager, it is the essential tool for daily closing. For the practice owner, it provides the baseline to make informed decisions: renegotiate POS transaction fees, offer payment links prior to appointments, or revise deposit policies. For multi-location dental groups, it is also the fastest way to compare branches using an identical standard.
Collections, Revenue, and Cash Flow: The Differences
The most common mistake is reading the collections report as if it were a revenue report. They measure different figures and serve entirely different purposes.
From a tax perspective, an individual professional looks at compensation received: the Italian Revenue Agency reminds practitioners that they must record the compensation received in their accounts, even when a healthcare facility handles the collection on their behalf. The same circular clarifies that centralized collection does not alter the tax treatment or obligations for income tax and VAT purposes. Therefore, if independent contractors work in the practice, the report should ideally break down collections by practitioner.
Conversely, if the practice operates as a corporate entity preparing financial statements, revenue follows accrual principles: according to the Italian accounting standard OIC 34 on revenue, applicable to financial years beginning on or after January 1, 2024, revenue from service contracts is recognized according to the percentage of completion when specific conditions are met, or otherwise upon service completion. A two-year orthodontic plan paid in advance is a cash collection today, but revenue recognized over time.
Metric | What It Measures | When It Is Recorded | Where to Check It |
|---|---|---|---|
Revenue / Billing | Invoices/receipts issued | On the invoice or receipt date | Billing / Invoicing report |
Collections | Money actually received | On the payment date | Collections report by method |
Accounts Receivable | Invoiced amounts not yet paid | From invoice issuance until balance settlement | Aging schedule or outstanding balances report |
Deposits / Prepayments | Payments received prior to treatment | On the payment deposit date | Collections report, under a dedicated label |
Cash Flow | Cash inflows minus cash outflows | When money moves in the bank or cash drawer | Cash flow statement |
When the figures do not match, the reason is almost always one of these: invoices issued but not yet paid, deposits collected before invoicing, financing settlements disbursed after the appointment date, or refunds logged in a different month than the original collection.
Report Line Items and How to Read Them
Every software uses its own labels, but the categories are nearly universal. For each, you should know what external source to reconcile it against.
Method | What It Includes | External Reconciliation Source | Things to Watch Out For |
|---|---|---|---|
Cash | Payments at the front desk in bills and coins | Physical cash drawer count and bank deposit slips | Change provided, petty cash withdrawals |
Debit or Credit Card (POS) | Debit cards, credit cards, prepaid cards, smartphone/contactless payments | POS terminal transaction statement | Processing fees, bundled payouts, value dates |
Bank Transfer | Standard and instant bank transfers from the patient | Bank account statement | Incomplete payment descriptions, third-party transfers on behalf of the patient |
Payment Link | Links sent prior to or after the appointment | Payment gateway / service provider report | Initiated but uncompleted transactions |
Patient Financing | Financed treatment plans disbursed to the practice | Financing company settlement statement | Net payout differing from the gross plan amount |
Check | Bank checks or cashier's checks | Bank deposit records | Clearing times and bounced checks |
Refunds and Reversals | Patient refunds, cancellations, chargebacks | Same channel as the original payment | Negative amounts, accrual month |
Three practical rules will help prevent mistakes.
Gross vs. net. Practice management software typically logs the full amount paid by the patient. POS providers and financing companies pay out a net amount after deducting fees. That difference is not missing cash: it must be reconciled as an operating expense.
Partial payments. A €4,800 treatment plan might generate ten payment entries over six months. The payment method report should display each as a distinct collection, each with its own date and method. If a patient pays half by card and half in cash, two separate lines must be recorded, not one.
Deposits. A solid report separates deposits from regular collections, as they represent funds received for clinical services not yet performed. If the patient discontinues treatment, part of that sum may need to be refunded.
Payment Methods and Patient Tax Deductions
Payment methods affect more than just the cash drawer. For healthcare expenses where tax deductibility requires traceability, the Italian Revenue Agency has clarified that funds must transfer from the person bearing the expense to the beneficiary via an uninterrupted chain of traceable payments. For front-desk staff, this means the "cash" category must be recorded just as meticulously as the rest: if a patient later requests confirmation of the payment method used, the record must be accurate.
Furthermore, healthcare services must be documented and submitted to the Health Card System (Sistema Tessera Sanitaria): the 2019 Revenue Agency Circular outlines the procedure. Before altering how your practice logs payments, consult your accountant regarding how payment methods should appear on tax documents and transmitted data: regulations evolve, and your accountant is the right professional to verify your specific requirements.
Finally, there is an upcoming regulation for those using certified electronic recording tools: the operational guide on integrating POS terminals and electronic cash registers introduces a logical integration between these devices and electronic payment systems starting in 2026. If your practice also sells retail products, verify with your accountant if and how this applies to you. Regardless, maintaining a payment method report consistent with POS records will streamline any future reconciliation.

How to Set Periods and Filters
An effective report begins with well-defined filters. Here is the workflow we recommend to front-desk teams:
Filter by payment date. Do not use the appointment date or the invoice date: the collections report relies strictly on the day the money was received.
Set the granularity. Daily for the cash register close, weekly for POS reconciliation, and monthly for the accountant and practice owner.
Filter by practice location and practitioner. In practices with associates or multi-clinic groups, this filter prevents combining revenue belonging to different clinicians.
Group by payment method. The subtotal for each method provides the figure to verify against external sources.
Display deposits and refunds separately. If your software allows it, keep them in dedicated columns rather than blending them into the overall total.
Compare against previous periods. A significant shift in a payment method—such as cash collections doubling—is a trend worth investigating.
To obtain the monthly total, simply sum all payment methods. However, the key figure to review in management meetings is net collections: total collections minus refunds and reversals.
Example: A Monthly Closing
Let us consider an example practice with two chairs, one owner dentist, and one hygienist. These figures are illustrative and intended to demonstrate the reconciliation logic.
Method | Monthly Collections | Reconciliation Source | Result |
|---|---|---|---|
POS Card Payments | €18,420 | Terminal transactions: €18,420 | Balanced |
Bank Transfer | €9,650 | Bank statement: €9,150 | €500 difference |
Cash | €2,310 | Cash drawer and deposits: €2,310 | Balanced |
Patient Financing | €6,000 | Settlement statement: €5,790 net | Fee to be booked |
Refunds | -€350 | POS reversal: €350 | Balanced |
Net Collections | €36,030 |
Upon investigation, the bank transfer discrepancy was due to a payment recorded in the software on the 30th of the month that only settled in the bank account on the 2nd of the following month: the front desk had entered it using the date the patient initiated the transfer. Adjusting the date reconciled the month. The €210 variance in financing represents processing fees: the funds are not missing; they simply represent a finance cost.
The report also provides valuable insights for the practice owner: over half of all collections came via card, cash made up a small fraction, and a single €6,000 financed plan accounted for one-sixth of the month's receipts. These are insights that a single aggregate total would never reveal.

Checks to Perform Before Exporting
Before sending your export to your accountant or practice owner, a ten-minute verification avoids weeks of follow-up questions.
Sum of payment methods matches the total. This sounds obvious, but transactions without an assigned method often end up under an "other" category that goes unnoticed.
No duplicate payments. A classic issue occurs when a patient's card payment appears to fail at the terminal, is run again, and both transactions end up going through successfully.
Consistent dates. Bank transfers and financing payouts should be logged on the actual settlement date, not the date they were agreed upon.
Refunds routed via the correct channel. A refund for a card payment must be logged as a card reversal, not as cash.
Deposits linked to the patient and treatment plan. Every deposit should be tied to a specific treatment quote.
Collections allocated by practitioner. If associates work in the clinic, ensure every payment is correctly attributed to the clinician who performed the treatment.
For exporting, the most practical format is a spreadsheet with one line per entry: date, patient name or ID, linked document, payment method, amount, clinic location, and practitioner. A summary PDF works well for the owner, but the detailed file is essential for the accountant. Agree with them in advance on the exact columns needed and the delivery schedule.
Our Perspective
We frequently encounter practices where collections reports exist, yet no one utilizes them. The reason is almost always the same: data is entered late and inaccurately. The appointment ends, the patient pays, the front desk postpones entering the transaction until the end of the day, and by then, the payment method becomes a guess. The report only becomes dependable when payments are recorded the moment they happen, linked to the invoice and treatment plan.
That is why we believe managing payment methods is not merely an accounting issue, but a workflow design matter. When clinical charts are completed by voice and invoices generate directly from recorded treatments, the front desk has the time to focus on what matters: logging the correct payment, at the right time, using the correct method. The software filters handle the rest.
One final tip, especially if you are transitioning to new management software: before migrating, audit how deposits and refunds were recorded in your legacy system. These items produce the most discrepancies, and it is far better to resolve them during migration than after the fact.
— Matteo
Collections and Invoicing in a Single Management Software
Treatbase is the cloud-based dental practice management platform that brings together voice-driven clinical charting, automated invoicing, payment and collections tracking, and clinic performance analytics. Collections flow seamlessly from the treatments logged in the chart, ensuring the front desk never needs to re-enter details while allowing owners to review clinic metrics across all locations using uniform standards.

If you are transitioning from another system, data migration is included at no extra cost. Discover how our dental practice management software works.
Frequently Asked Questions
Why does the collections report not match monthly revenue?
Because it tracks money received, not documents issued. Invoices that remain unpaid, prepayments collected before invoicing, and payouts received in the following month naturally create differences. To reconcile them, compare the collections report against your patient accounts receivable schedule.
How do I record a payment split between card and cash?
As two distinct collection entries applied to the same document, each with its respective method and amount. Entering it as a single payment skews both the cash drawer and POS reconciliations. The same principle applies when a family member covers part of the fee by bank transfer.
Should patient financing be recorded gross or net?
In the collections report, it is typically logged as the full amount owed by the patient, while the financing institution pays out an amount net of its fees. The difference represents a practice expense and should be accounted for accordingly. Confirm with your accountant how they prefer these two figures presented.
How often should the payment method report be reviewed?
The cash drawer daily, the POS weekly, and bank transfers and financing payouts at month-end alongside the bank statement. This routine takes only a few minutes each time and keeps variances from accumulating. For multi-clinic practices, establishing the same schedule across all locations is best practice.