Clinic Revenue Reconciliation Workflow Software (2026 Guide)

Clinic Revenue Reconciliation Workflow Software (2026 Guide)

Revenue reconciliation is the process of confirming that every pound, euro, or krona earned by the clinic has been correctly recorded in three places simultaneously: the billing system (invoices raised), the payment records (payments collected), and the accounting ledger (journal entries). When all three agree, the books are reconciled. When they don't, there's a variance — and the variance has a cause that needs to be found.

The difference between a clinic that reconciles daily and one that reconciles monthly is the difference between finding a EUR 47 discrepancy when it first occurs (easy to trace) and finding a EUR 2,300 accumulated discrepancy on the last day of the period (nearly impossible to trace accurately).

This guide covers why reconciliation matters, how to design the workflow, and what software features support it.

Why Clinic Revenue Specifically Needs Reconciliation

Multiple payment channels create multiple reconciliation gaps

A clinic accepting cash, card, bank transfer, and online portal payments has four payment streams that must all reconcile to the same billing records. Each stream has its own settlement timing:

• Card payments settle T+1 or T+2 (Stripe and similar)
• Bank transfers settle on various timelines depending on payment provider
• Cash is immediate but requires daily till reconciliation
• Online portal payments settle via the integrated payment provider

Without structured reconciliation, each stream's timing differences create apparent discrepancies that accumulate.

Refunds and chargebacks require reverse entries

Every refund creates a reversal of the original invoice and payment entries. Every chargeback (a card dispute) creates a temporary reversal that may or may not be permanent depending on the outcome. Without tracking, refund entries appear in one system but not another, creating a reconciliation gap that persists indefinitely.

Staff-applied discounts reduce collected revenue below billed revenue

A discount applied at billing (percentage or fixed amount) reduces the invoice total but must also appear as a corresponding deduction in the ledger. Ad-hoc discounts applied by front desk staff that aren't formally tracked create a gap between the gross revenue the billing system shows and the net revenue that was actually collected.

Payment gateway fees reduce settlement amounts

The amount received in the clinic's bank account from a card payment provider is the gross amount less fees. If the billing system records the gross invoice amount and the bank reconciliation is done against the net settlement, there will be a systematic gap equal to the total fees across all card transactions. The reconciliation system must account for gateway fee deductions as a separate line item.

Reconciliation Architecture

Daily reconciliation (each payment channel)

Cash:

• Till count at end of day: actual cash in drawer
• System payment records: total cash payments posted in the system for the day
• Discrepancy threshold: any variance above EUR 5 requires investigation before close
• Signed off: manager or senior reception

Card (Stripe / payment gateway):

• Daily settlement report from payment gateway: gross charges, fees, net settlement
• System payment records: card payments posted
• Match: gross system total should equal gateway gross charge total
• Fee reconciliation: fee amount should equal the fee shown on gateway report
• Net settlement should appear in bank account T+1 or T+2

Bank transfer:

• Bank statement (imported or API-fed): incoming transfers
• System payment records: bank transfer payments posted
• Match: each bank transfer should have a corresponding invoice payment in the system

Weekly reconciliation (accounts receivable aging)

• Outstanding invoices report from billing system: total AR balance, broken down by age (current, 30 days, 60 days, 90+ days)
• Verify against last week's report: movements should be explainable by new invoices raised and payments received
• Flag accounts entering the 60+ day bucket for follow-up
• Review write-offs: any amounts written off this week should have corresponding AR adjustment entries

Monthly close reconciliation

The full close reconciliation confirms that all daily and weekly reconciliations aggregate correctly:

1. Total invoiced revenue (sum of all invoices raised in the period)
2. Total discounts and adjustments (sum of all discounts, credits, and adjustments)
3. Net revenue (billed minus adjustments)
4. Payments collected (sum of all payment types received)
5. Change in AR (unpaid invoices at end of period minus start of period)
6. Check: Net revenue = Payments collected + Change in AR

If these don't reconcile, the gap has a cause: an unposted payment, an unmatched refund, a discount not correctly entered. The close should not be signed off until the gap is identified and corrected.

Exception Management

Not all reconciliation discrepancies are errors. Some are timing differences:

• A card payment processed on 31 December but settled on 1 January
• A bank transfer initiated on the last day of the period but appearing on the next bank statement

Exception categories:

Exception Type	Description	Resolution
Timing difference	Correct amount, wrong period	Auto-resolve in next reconciliation cycle
Unmatched payment	Payment received, no invoice found	Match to invoice or investigate
Unmatched invoice	Invoice raised, no payment found	Confirm with client; follow-up if needed
Duplicate payment	Two payments recorded for same invoice	Investigate; issue refund if confirmed duplicate
Refund mismatch	Refund recorded in one system, not the other	Trace to source; correct missing entry
Gateway fee variance	Expected fees differ from actual fees	Verify gateway rate; adjust if rate changed

Each exception should have:

• An owner (who is investigating)
• A deadline (when it should be resolved by)
• An audit trail (what was found, what correction was made)

Setting Up in Tregovia

Tregovia's Accounting module (EUR 15/month) supports revenue reconciliation integrated with billing:

• Automatic journal entries: Invoice creation, payment receipt, refund, and discount all create corresponding ledger entries automatically
• Bank reconciliation: CSV bank statement import; transaction matching by amount, date, and reference; unmatched items queue
• Daily cash reconciliation: Till count entry; system-vs-actual variance display
• AR aging report: Outstanding invoices by age bucket, updated in real time
• Exception queue: Unmatched transactions surface in a named exception queue with owner assignment
• Close checklist: Month-end close prevents period lock until all exceptions are resolved
• Period lock: Locked periods prevent retroactive edits without manager override + audit trail

Integration: Tregovia billing → accounting is automatic. Staff posting a payment don't need to separately enter it in an accounting system — the ledger entry is created by the billing action.

Privacy controls: Configure access roles, consent records, exports, deletion requests, and retention rules before publishing this workflow.

Pricing: EUR 10/month flat rate.

Key Performance Indicators

Metric	Definition	Target
Daily reconciliation completion rate	Days reconciled on the correct day / total business days	100%
Exception resolution cycle time	Average days from exception identified to resolved	<3 business days
Close variance at lock	Unresolved variance at period close	Zero
Exception aging	Exceptions open > 7 days	Should be zero at monthly review
Post-close corrections	Corrections made to locked periods	Declining trend
Unreconciled AR aging	AR balance unreconciled for > 30 days	Should approach zero

FAQ

What causes most reconciliation delays in clinics?

Unstructured exception queues with unclear ownership. When a discrepancy is identified and the appropriate action is "investigate later," it typically means "investigate never" — the discrepancy sits until the next reconciliation cycle, where it may or may not be re-identified depending on how the exception was recorded. Structured exception management — every unmatched item has an owner and a deadline — prevents this.

How should clinics handle the gap between cash collected and system records?

Cash variance requires daily reconciliation at till close. Any variance above the minimum investigation threshold (typically EUR 5–10) requires: a recount, a review of all cash transactions posted in the system for the day, and a signed discrepancy report if the variance can't be explained. Cash variance that is ignored accumulates and is nearly impossible to trace after the fact. Daily cash reconciliation with signed-off reports is the control that makes the cash position auditable.

Should clinics reconcile even if they use a single card reader with auto-settlement?

Yes. Even with a single payment channel and auto-settlement, reconciliation confirms that: every payment received in the bank account has a corresponding invoice in the billing system; every invoice marked as paid has a corresponding bank receipt; all gateway fees are correctly accounted for. A clinic where patients occasionally pay without an invoice being raised (informal payments, cash without receipt) will show systematic gaps in reconciliation that wouldn't be visible without it.

How long should reconciliation records be retained?

Financial records — including reconciliation reports, exception records, correction approvals, and period close sign-offs — must be retained per applicable tax and accounting law in the relevant EU member state. Most EU jurisdictions require retention of accounting records for 7–10 years. Digital records are acceptable in most jurisdictions provided they are tamper-evident and accessible for inspection. Verify the specific retention requirement in your member state and industry (regulated healthcare may have additional requirements).

Can Tregovia's reconciliation workflow replace a separate accounting tool for small clinics?

For most small clinics (under EUR 500K annual revenue, standard expense structure, no complex payroll requirements), Tregovia's Accounting module provides sufficient reconciliation workflow without a separate tool. Clinics with more complex requirements — multiple entities, complex asset accounting, payroll tax complexity, external audit requirements — should supplement with or migrate to a dedicated accounting tool and use Tregovia's export capabilities to feed the accountant.