How to read your three core metrics, diagnose gaps, and know what to do next.
Every report shows three metrics for each payment type. Read them in order: balance first, drift second, match rate third.
The difference between what your PMS recorded and what actually landed in your bank for the period. This is your highest-level signal.
A variance under ~5% of collections is normal. A perfect zero balance is not realistic given timing differences across payment types. A larger variance, or one that grows over time, warrants investigation.
If the balance is clean, you’re in good shape. If it’s off, the other two metrics help explain why.
The balance plotted over time, week by week, with a cumulative line that shows whether the gap is accumulating or self-correcting. This is where you distinguish timing noise from structural problems.
In a healthy practice, the drift line fluctuates modestly in both directions — some weeks the bank runs slightly ahead, some weeks the PMS does, and those differences balance out. What reveals a problem is a gap that consistently grows in one direction without reversing. That pattern indicates something structural, not timing.
How many individual transactions matched at the line-item level, as a percentage. This measures the cleanliness of your records independent of the dollar balance.
It’s possible to have a healthy balance but a low Match Rate — individual entries are messy even if the totals roughly agree. Above 90% is the target for credit card and EFT. Paper (check/cash) often runs lower due to deposit timing. Below 80% usually points to categorization or batching issues worth addressing.
Go through each payment type in this order. Jumping to individual transactions before understanding the aggregate picture is usually wasted time.
Before assuming something is wrong, understand how each payment type moves from your PMS to your bank. Most first-report gaps are timing, not leakage.
| Payment Type | How it works | Typical bank delay |
|---|---|---|
| Credit Card | Processed via merchant; batched and deposited | 1–3 business days |
| EFT (insurance) | Deposited directly from insurer; PMS entry follows receipt of EOB | Same day to 1 day; PMS entry lags by definition |
| Paper (check/cash) | Deposited manually by staff | 1–5 days; depends on deposit frequency |
| Financed (Care Credit, etc.) | Patient pays third-party lender; lender pays practice | 3–5 days; fees and adjustments common |
EFT deposits from insurers almost always hit your bank before the payment is posted in your PMS. The correct workflow is to post the EFT in your PMS only after you have the EOB — at which point you’ve confirmed both the amount and the remittance detail. If your biller posts insurance payments at procedure time rather than on receipt, EFT balances will appear off for weeks at a stretch. The gap isn’t missing money — it’s a posting workflow issue.
Some processors deposit net of fees, so your bank deposit is already reduced by the processing fee. Others deposit the full charge amount and deduct fees separately as a single monthly lump sum. If you’re seeing a consistent small shortfall on credit card that resolves at month end, a lump-sum fee deduction is the likely explanation. Check your merchant statements to confirm how your processor settles.
Each flag type has a common cause and a specific fix.
Your income bank account received a deposit that doesn’t correspond to any PMS payment type. Common causes: a refund credited to the wrong account, a personal transaction routed through the practice account, or non-patient income landing in your collections account.
Payments collected several days before they appear as bank deposits. This creates timing gaps that technically resolve but make reconciliation noisy and harder to read.
Individual PMS entries with no corresponding bank transaction, or bank transactions with no PMS counterpart. These are the line items most worth examining — they’re where actual leakage or data entry errors tend to hide.
Close gaps systematically. Do this in sequence — each step makes the next one more effective.
One income account per office. Only patient and insurance income flows through it. If anything else is currently going in, move it. This is the prerequisite for clean data — everything else depends on it.
If CenturyDoc is showing many payment categories, consolidate to the four core types: Credit Card, EFT, Paper, Financed. Miscategorized payments lower your Match Rate and make the Payment Explorer harder to read. You can recategorize directly in the Payment Explorer.
Staff should deposit on a consistent schedule. Irregular deposits are the single largest source of timing variance. More frequent deposits mean smaller gaps, faster reconciliation, and a drift line that’s actually readable.
Once your setup is clean, a typical review takes under five minutes. Check the three metrics. Open the Payment Explorer if anything is flagged. The goal is catching and fixing clerical errors in the same period they happen, not at year end.
A well-configured practice running CenturyDoc for 60 to 90 days typically reaches these benchmarks. Use them as a reference, not a grading system.
Payment balance variance under 5% of total collections per period, across all payment types.
Match Rate above 90% for credit card and EFT. Paper (check/cash) often runs lower due to deposit timing.
Flags declining period over period as setup issues are resolved.
No accumulating drift — the balance graph fluctuates modestly in both directions rather than drifting consistently one way.
If significant variances persist after 60 days and your account structure is clean, that’s when to look more closely. The Payment Explorer will point you at the right payment type.