Bank Reconciliation for Vet Practices: The Complete Guide

It's the last Friday of the month. You're sitting at your desk with a bank statement printout, a cup of rooibos that's gone cold, and a growing sense of dread. Somewhere in 347 transactions, there are payments that don't match invoices, invoices with no matching payments, and at least one mystery deposit you can't explain.

Bank reconciliation is the least glamorous part of running a veterinary practice. It's also one of the most important. If your bank balance doesn't match your sales records, you don't actually know how your practice is performing financially.

Let's break down what reconciliation involves, why it's painful for vet practices specifically, and how to make it less awful.

What Bank Reconciliation Actually Is

Bank reconciliation is the process of matching the transactions in your bank account to the transactions in your practice management system. Every payment a client makes should correspond to an invoice. Every invoice that's been paid should have a matching bank deposit.

When these match up, your books are clean. When they don't, you have discrepancies that need investigating.

The goal is simple: make sure the money you think you received is the money you actually received. In practice, this is surprisingly hard.

Why It's Particularly Painful for Vet Practices

Veterinary practices have reconciliation challenges that many other businesses don't.

Multiple Payment Methods

A single client visit might involve a card payment for the consultation, a cash payment for pet food, and an EFT for the medication that gets sent home. That's three bank entries for one visit. Your statement shows three separate deposits, but your system shows one invoice.

Split and Partial Payments

Clients don't always pay the full amount on the day. Payment plans, deposits, and partial payments mean an invoice might be settled across multiple transactions over weeks or months.

Co-Owner Payments

When a pet has multiple owners — divorced couples sharing a dog, siblings sharing a family cat, farming partnerships — you might receive two separate payments for what was originally one treatment. More on co-owner billing in our separate guide, but the reconciliation challenge is that one clinical event generates multiple invoices and multiple payments.

Cash Transactions

Cash is reconciliation's worst enemy. If your front desk takes R500 cash for a walk-in nail trim and nobody records it, that R500 exists in your cash drawer but not in your system. When you deposit it, the bank shows the money but your records don't explain it.

Card Processing Fees

Your client pays R1,000 by card. Your bank receives R975 after the card machine fee. Your invoice says R1,000. That R25 difference isn't a discrepancy — it's a processing fee — but it shows up as a mismatch if you're comparing invoice totals to bank deposits.

The Manual Reconciliation Process

Most practices still reconcile manually, and it goes something like this:

Download your bank statement — log into FNB, Standard Bank, ABSA, or Nedbank and download a CSV or PDF for the month
Print or open your sales report — pull up all invoices for the same period
Match line by line — go through each bank transaction and find the corresponding invoice
Flag mismatches — highlight payments you can't match, invoices with no payment, and amounts that don't agree
Investigate discrepancies — call clients about unpaid invoices, check with front desk about unrecorded cash, reconcile card fees
Adjust records — update your system with corrections, write-offs, and missing entries

For a busy practice doing 30-50 transactions per day, this process takes 4-8 hours per month. That's a full working day spent on bookkeeping instead of seeing patients or managing your team.

South African Banking Context

Each major SA bank exports statements differently, which adds friction if you've ever tried to automate this with spreadsheets.

FNB exports CSV files with a specific column layout — date, description, amount, balance. The description field includes card machine references that sometimes include useful details and sometimes don't.

Standard Bank and ABSA have their own formats with different column names and date formats.

Nedbank statements often include additional reference fields that can help with matching but appear in different positions than other banks.

If your practice uses multiple bank accounts — a main operating account and a separate savings or trust account — you're reconciling across different formats simultaneously.

How Often Should You Reconcile?

Monthly is the minimum. Most practices reconcile monthly because that's when statements close. But monthly reconciliation means you might not catch a problem until 30 days after it happened, by which point memories are fuzzy and trails are cold.

Weekly is better. A quick weekly check — even 30 minutes — catches discrepancies while they're fresh. Did Mrs Naidoo say she'd EFT her R3,200 bill on Tuesday? Check on Friday. If it hasn't landed, you can follow up while both of you remember the conversation.

Daily is ideal but impractical manually. Nobody has time to reconcile every day by hand. But automated systems can match transactions daily, flagging exceptions for your review. You spend five minutes glancing at exceptions instead of hours doing the full matching.

Common Discrepancies and What They Mean

When you find transactions that don't match, here's what's usually going on:

Payment timing differences. A client pays by EFT on the 31st. It reflects in your bank on the 2nd of the next month. The invoice shows paid in month one, the bank shows the deposit in month two. This isn't an error — it's a timing difference. Look at transactions near month-end boundaries.

Unrecorded cash payments. Cash came in, the invoice was marked as paid, but nobody recorded the payment method or amount. The invoice shows paid but there's no corresponding bank deposit because cash was deposited in a lump sum at the end of the week.

Card processing fees. Your invoices show gross amounts. Your bank shows net amounts after card fees. The difference is legitimate but needs to be accounted for, typically as a monthly expense entry.

Reversed or refunded transactions. A card payment was reversed, or you issued a refund. The bank shows a debit, but your system might still show the original payment. Refunds need to be recorded in both systems.

Double payments. A client pays by card at the front desk and then also transfers the amount via EFT because they forgot they already paid. The bank shows two deposits for one invoice. This needs a refund or a credit note.

Deposits with no reference. An EFT lands in your account with "PAYMENT" as the only reference. No client name, no invoice number. You know someone paid you, but you don't know who or for what.

The Automation Approach

The alternative to manual matching is automated bank reconciliation. The process works like this:

Import your bank statement — upload the file from your bank, or connect directly for automatic imports
Automatic matching — the system compares bank transactions against outstanding invoices using amounts, dates, references, and client names
Review exceptions — you only look at the transactions that couldn't be matched automatically
Approve and finalise — confirm the matches, resolve exceptions, and your books are done

The key difference is what you spend your time on. Instead of matching 347 transactions manually, the system matches 330 of them automatically. You review the 17 exceptions — the ones that actually need human judgement.

This takes the process from 4-8 hours down to about 30 minutes.

What Good Reconciliation Gets You

Clean books aren't just about satisfying your accountant. Regular reconciliation gives you:

Accurate financial reporting. Your revenue numbers actually reflect reality. When you look at your monthly income, it's based on money received, not just invoices issued.

Faster debt collection. You spot unpaid invoices quickly instead of discovering them months later when the client has forgotten what the treatment was for.

Cash flow confidence. You know what's in the bank, what's owed, and what's expected. You can make payroll, stock, and equipment decisions based on real numbers.

Audit readiness. If SARS comes knocking, or your accountant needs year-end figures, your records already match your bank. No scrambling.

Fraud detection. Regular reconciliation is the fastest way to spot unauthorized transactions, missing deposits, or internal discrepancies.

Getting Started

If your practice is still reconciling manually with spreadsheets and paper statements, the first step is establishing a consistent routine. Pick a day each week — many practices choose Monday morning — and dedicate 30 minutes to matching the previous week's transactions.

If you're ready to automate, DigiVet's bank reconciliation feature imports bank statements from all major South African banks and automatically matches transactions to your invoices. You review the exceptions, approve the matches, and you're done. What used to take a full day now takes a tea break.