Reconcile patient deposits by connecting each payment to its purpose, appointment or benefit record, later application, refund, and remaining obligation. Use a fixed cutoff and preserve changes when appointments move. The payment processor, scheduling system, and ledger can each be correct on their own while still describing different dates and events.
What counts as a deposit in the reconciliation?
Define the category before exporting a balance. A reservation deposit, a payment toward a specified treatment, a prepaid package, and a membership credit can create different contractual and operational questions. A software label called deposit may combine several of them, so inspect the actual program and patient-facing terms.
State whether the balance is measured by payment date, appointment date, service completion, or a financial reporting cutoff. Identify the entities and locations included, especially when one company receives payments and another provides the relevant services. Document the reporting basis rather than assuming every system follows the same policy.
The IRS discussion of accounting methods and advance payments provides tax context. It does not, by itself, determine a patient’s refund rights, the practice’s transaction reporting policy, or the buyer’s contractual assumption. Ask the appropriate accountant and counsel to resolve those questions separately.
Which identifiers connect the systems without exposing unnecessary information?
Use the minimum appropriate administrative identifiers needed to match the payment and obligation. Depending on the approved process, these may include a controlled customer reference, payment identifier, appointment reference, program version, date, amount, and event status. The financial reviewer generally does not need an unrestricted clinical chart to test a deposit movement.
Limit access and use a permitted information-sharing method. The HHS de-identification guidance explains specific standards for de-identifying protected health information. Removing a name from an export does not automatically establish that those standards are satisfied. Obtain appropriate privacy review before describing an extract as de-identified.
Keep a protected cross-reference only where authorized and necessary. Record who created the matching file and the exact source versions used. If data must remain inside the practice’s controlled environment, design the review around that constraint instead of copying sensitive information into an ordinary buyer spreadsheet.
What events should the deposit ledger capture?
Track the deposit from receipt through every supported change. A useful event ledger distinguishes receipt, application to a completed service, refund, transfer to another approved benefit, unresolved dispute, and remaining balance. Preserve original dates and references so the sequence can be reconstructed.
| Field | Purpose | Common exception |
|---|---|---|
| Original payment reference | Connects the receipt to processor evidence | Duplicate or missing payment entry |
| Appointment or benefit reference | Explains what the payment supports | Rescheduled or deleted appointment |
| Application event | Records use against the service balance | Applied twice or before completion |
| Refund reference | Connects an approved refund to actual payment | Approved but not processed |
| Remaining amount | Identifies the unresolved or future obligation | Negative or unexplained balance |
Use defined statuses rather than relying on inconsistent free-text notes. A refund approval, a refund instruction, and a settled refund are different events, each relevant to the final balance and cash position.
How does an illustrative deposit roll-forward work?
Assume no opening balance and twelve hypothetical deposits of $240 each, all received during the period. Receipts are 12 × $240 = $2,880. Eight are applied to completed services, totaling $1,920. Two are fully refunded, totaling $480. The remaining recorded obligation is $2,880 − $1,920 − $480 = $480.
Of that $480, suppose one $240 deposit belongs to a future appointment and the other $240 is an unresolved cancellation case. Keep both visible while the responsible people determine the appropriate treatment. Do not call the unresolved amount earned revenue merely because a cancellation occurred or the cash remains in the bank.
This example ignores processor fees and settlement timing to isolate the obligation ledger. The bank reconciliation must address those separately. Check the deferred revenue explanation for the wider distinction between money collected and services or other benefits still owed.
Why does rescheduling create reconciliation problems?
A reschedule changes the expected service date but should not erase the original payment history. Systems may move a deposit automatically, leave it attached to a canceled appointment, or require a manual transfer. The reviewer needs to understand the actual behavior and controls.
Trace a sample from the original booking to the current appointment, preserving both references. Identify deposits carried forward through several changes, payments applied to a different service, partial refunds, and records recreated during a software migration. A final appointment list may omit the events needed to explain the money.
Set a reporting cutoff and list later events separately. A refund processed after month-end may relate to an obligation existing at month-end, but the accountant must determine the correct treatment for the stated purpose. Avoid changing old reports silently when a future appointment moves. The membership underwriting guide provides related context for reconstructing benefit balances across time.
What sequence should staff use to investigate differences?
Start with the event trail and classify the exception before proposing an entry. An unexplained difference might be a timing issue, duplicated application, missing refund, data migration error, contract question, or unsupported balance. Each requires different evidence and sometimes a different decision-maker.
- Save the source extracts and the exact cutoff used.
- Match received payments to the original appointment or benefit records.
- Trace applications, transfers, refunds, and outstanding disputes.
- Recalculate remaining balances and compare the total with the ledger.
- Investigate exceptions and obtain the required accounting or legal decision.
- Preserve approved corrections and verify the next reporting period.
The SBA financial-management resource emphasizes bookkeeping and cash visibility. The deposit-specific sequence above is an original educational method for implementing that discipline. Adapt responsibilities and review depth to the practice rather than treating the sequence as a regulatory checklist.
How does the closing cutoff change the transaction discussion?
At closing, identify who keeps the money and who assumes the associated obligation. A ledger balance is an input to that negotiation, not an automatic purchase-price adjustment. The parties need defined terms, a cutoff, supporting records, and an agreed procedure for later-discovered exceptions.
Check whether the same balance already appears in working capital, a debt-like adjustment, a refund reserve, or another negotiated mechanism. Deducting it more than once can distort seller proceeds. Ignoring it can leave the buyer funding services or refunds with no corresponding cash plan.
The working capital peg definition explains how account definitions affect the closing calculation. Have the transaction accountant and attorney align the financial schedules with the purchase agreement. Where a patient dispute remains unresolved, distinguish the legal outcome still pending from any provisional economic allocation the parties agree between themselves.
What operating changes make future reconciliations easier?
Standardize deposit categories, required references, status definitions, and approval rights at the source. Train staff on rescheduling and refunds in the actual software. Restrict manual adjustments appropriately and review recurring exceptions so the process improves instead of depending on repeated spreadsheet repairs.
Include a roll-forward and exception summary in the monthly financial pack. State which balances are supported, which require further work, and whether the systems or policies changed. A consistent month-to-month history gives the next owner a better basis for understanding collections and remaining obligations.
The operations hub connects this detailed control with the broader effort to make records reproducible. The aim is a clear explanation of each material amount and a practical path to resolution. Better matching may reveal refunds or lower reported earnings; that information is useful even when it complicates the initial sale story.
What else do owners and buyers ask?
Is every patient deposit automatically revenue?
Receipt of money alone does not resolve the relevant reporting or contractual question. Identify what was purchased, whether the service or benefit has been delivered, what obligations remain, and which accounting basis applies. Have the accountant distinguish tax reporting, management reporting, and transaction normalization instead of relying on a software category.
What if the scheduling system and accounting ledger disagree?
Preserve both source versions and reconcile the underlying events rather than choosing the more attractive total. Trace receipts, applications, reschedules, refunds, and timing differences. Assign unresolved items to the appropriate person and retain the correction history so a buyer can understand how the final balance was derived.
Should a buyer deduct the full deposit balance from the price?
That is a negotiated issue requiring defined obligations, cash treatment, and coordination with working capital and other adjustments. The balance alone does not establish the correct mechanism or amount. Avoid counting the same item twice, and distinguish the parties' financial allocation from any rights the patient retains.
Can I remove patient names and send the spreadsheet to bidders?
Removing names does not automatically make information de-identified or permitted for unrestricted sharing. Have the appropriate privacy and legal professionals approve the scope and method. A financial deposit review often can use limited administrative references without distributing an unnecessary clinical record or other sensitive details to prospective buyers.
Which sources support this guide?
Sources were checked during research. Regulations, lender policies, and market conditions can change. Use the linked primary material and your advisors to confirm applicability.
- Publication 538: Accounting Periods and Methods — Internal Revenue Service
- Guidance Regarding Methods for De-identification of Protected Health Information — U.S. Department of Health and Human Services
- Manage your business: finances and bookkeeping — U.S. Small Business Administration
Educational analysis prepared with AI-assisted research for The Med Spa Broker. “Last reviewed” records the source and editorial check date; it does not imply review by an attorney, clinician, or independent appraiser. Read our editorial standards.