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.


Il metodo di pagamento e la detrazione del paziente — overview diagram

How to Set Periods and Filters

An effective report begins with well-defined filters. Here is the workflow we recommend to front-desk teams:

  1. 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.

  2. Set the granularity. Daily for the cash register close, weekly for POS reconciliation, and monthly for the accountant and practice owner.

  3. Filter by practice location and practitioner. In practices with associates or multi-clinic groups, this filter prevents combining revenue belonging to different clinicians.

  4. Group by payment method. The subtotal for each method provides the figure to verify against external sources.

  5. Display deposits and refunds separately. If your software allows it, keep them in dedicated columns rather than blending them into the overall total.

  6. 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.


Esempio: la chiusura di un mese — overview diagram

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.


Treatbase

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.

Sources

Contacts

Request DEMO

info@treatbase.it

Treatbase S.r.l. - Via Gaetano Donizetti 4 – 00198 Rome (RM) - VAT / Fiscal Code: 18041701006 - PEC: treatbase@legalmail.it

Contacts

Request DEMO

info@treatbase.it

Treatbase S.r.l. - Via Gaetano Donizetti 4 – 00198 Rome (RM) - VAT / Fiscal Code: 18041701006 - PEC: treatbase@legalmail.it

Treatbase S.r.l
Via Gaetano Donizetti 4 - 00198 Rome (RM)
VAT number / Tax code: 18041701006
PEC: treatbase@legalmail.it

Contacts

Request DEMO

info@treatbase.it

Privacy Policy Cookie Policy