Think Build Implement Repeat
London, UK +44 7367 067226
WhatsApp FOLLOW f in X
  1. Home
  2. Blog
  3. Why Does Our End-of-Day Cash-Up Take So Long and Still Not Match the Card Terminal?
Problems We Solve

Why Does Our End-of-Day Cash-Up Take So Long and Still Not Match the Card Terminal?

Dental end-of-day cash-up rarely balances between the card terminal and the practice system. We build automatic reconciliation that shows each mismatch.

Updated 2 min readBy SpiderHunts Technologies

Free estimateNo obligation

Get a free estimate

Tell us what you need. A senior engineer reads every enquiry.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →

Quick answer — TL;DR

The cash-up does not balance because payments are taken on a card terminal, online, by bank transfer and by finance provider, and each is recorded separately from the practice management system. We build a reconciliation that pulls the day's payments from each source, matches them to receipts in your system and shows only the mismatches with likely causes, so reception closes the day in minutes and the practice manager sees a clean record.

Twenty minutes after the last patient

The last patient leaves at 5.30. Reception prints the day's takings report from the practice management system and the Z report from the card terminal. They do not match. Someone goes through the receipts one at a time and finds a payment taken on the terminal but recorded against the wrong patient, a deposit paid online that is not in the terminal total, and a refund done twice.

It is now after 6. The mismatch is written on a note for the practice manager.

Card terminals that batch transactions at different times, or split one day's takings across two reports, make the comparison harder still, especially at practices open into the evening or on Saturdays.

Why the numbers do not match

  • Card terminals and practice systems are often not integrated.
  • Online deposits, bank transfers and finance payments arrive by different routes.
  • Payments are sometimes allocated to the wrong patient or appointment.
  • Refunds and voids are recorded in one place but not the other.
  • Cash is counted separately and recorded on paper.

What the daily mismatch costs

Reception time at the end of every day. Errors that are never fully resolved and carry into the month. Payments allocated to the wrong patient, which creates incorrect balances and confused patients. A practice manager who spends month end untangling the notes.

It also causes friction with patients. A payment allocated to the wrong family member, or a deposit that never reached the plan, shows up months later as a balance the patient insists they have paid. Sorting that out means digging back through terminal reports, which takes far longer than catching it on the day.

How we reconcile the day's payments

  1. Payments recorded in your practice management system are read for the day.
  2. Card terminal transactions are read from your payment provider, such as Stripe or your terminal provider's reports, where available.
  3. Online payments, bank transfers from your bank feed or accounting software, and finance provider payments are read from their sources.
  4. Each payment is matched to a receipt by amount, time and reference. Most match automatically.
  5. Mismatches are shown with likely causes, such as the same amount recorded against a different patient or a refund present in only one place.
  6. Cash is entered by reception on a simple screen and compared with recorded cash receipts.
  7. The day is closed with a record of who resolved what, and a summary goes to the practice manager.
MismatchLikely cause shown
Terminal payment, no receiptReceipt not recorded, or recorded on another day
Receipt, no terminal paymentPayment taken by another method
Same amount, different patientAllocated to wrong patient
Refund in one place onlyRefund not recorded in both

Closing the day in minutes

Reception deals with a short list of real mismatches, often none. Payments allocated to the wrong patient are caught the same day, not when the patient queries a statement. The practice manager gets a clean daily record, which makes month end straightforward.

Deposits taken online for private treatment are matched to the plan they relate to, so the balance on the day of treatment is right. Finance provider payments, which often arrive as one sum covering several patients, are split and matched to each.

Is this your end of day?

  • The cash-up takes a long time after the last patient.
  • Takings and terminal reports often do not match.
  • Mismatches are left on notes for the practice manager.
  • Patients query balances caused by misallocated payments.

FAQ

Frequently asked questions

The questions readers ask us after this guide.

Still have a question?

Ask us directly — a senior engineer will get back to you.

Ask about your project

Does our card terminal need changing?

Usually not. We read transaction data from your provider's reports or API. If none is available, we discuss options with you.

Does this post to our accounting software?

It can send a daily summary to Xero, QuickBooks or Sage if you want. Your accountant decides how it is coded.

What about several sites?

Each site is reconciled separately, with a combined view for the owner.

What affects the cost?

The number of payment sources, integration with your practice management system and the number of sites.

Can it handle deposits and finance payments?

Yes. Deposits are matched to the patient's plan, and combined payments from finance providers are split across the patients they cover.

Keep reading

More on Problems We Solve

Start here

Tell us where your practice's admin gets stuck

Describe the problem, the practice management system you run and who deals with it today. We will tell you what we would build and what we would leave alone, and if a smaller change inside your existing software would fix it, we will say so.

  1. You tell us what you needTwo minutes on the form, or a message on WhatsApp.
  2. A senior engineer reviews itAnd comes back with questions, a realistic range and an honest view on fit.
  3. Free 30-minute scoping callWe talk through scope, options and a realistic estimate — with no obligation.
Free estimateNo obligation

Talk to someone who builds this

Send a short brief and we will come back with an honest view and a realistic range.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →