Monthly Insurance A/R Reconciliation for Medical Practices

Decide what the insurance A/R report is meant to explain

Start with a control question: why did insurance receivables change from last month? The answer should come from a summarized practice-management report, not from trying to reproduce every claim line in the general ledger. Retain a month-end summary by payer and aging bucket when those views are useful for follow-up.

Keep the practice’s accounting basis and reporting policy clear. Under the cash method, income is generally reported when received; under an accrual method, income is generally reported when earned. The IRS also states that an accounting method must be used consistently and clearly reflect income. IRS Publication 538: Accounting Periods and Methods

The bookkeeping records should be sufficient to support and verify the entries used on the return, and computerized records should reconcile to the books and return while identifying underlying source documents. IRS Publication 583: Starting a Business and Keeping Records For a cash-basis practice, insurance A/R may be an operating and cash-planning control outside the general ledger. For an accrual-basis practice, it may also be a control for the insurance receivable account. Confirm the intended treatment with the practice’s accountant before posting year-end or method-related entries.

• Use a report date matching the financial statements, such as the last day of the month.
• Save a summary showing total insurance A/R, payer totals, and aging buckets when available.
• Keep patient names, dates of birth, account numbers, and clinical details out of the bookkeeping worksheet.
• Label each retained report with the system name, report date, and preparer.

Build a monthly insurance receivables rollforward

Use four inputs: the prior month-end insurance A/R report, current-month insurance charge or responsibility activity, current-month payment and adjustment activity, and the current month-end insurance A/R report. The goal is to explain the movement between two control totals.

A practical rollforward is: beginning insurance A/R + new insurance responsibility recorded during the month − insurance payments posted − approved contractual adjustments and other reductions = expected ending insurance A/R. Use the labels produced consistently by the practice-management system and chart of accounts.

If the expected ending balance does not agree to the current control report, record the difference as a reconciliation item. Do not use an unsupported journal entry just to force agreement. Check report dates, filters, reversed payments, late posting, payment batches, and adjustment timing first.

• Beginning insurance A/R: the prior retained month-end control report.
• Add: current-month insurance charges or responsibility, based on the report the practice uses consistently.
• Less: payer payments posted to claims.
• Less: approved contractual adjustments, refunds, transfers, write-offs, or other separately reported reductions.
• Ending insurance A/R: the current month-end control report.

Match payer deposits to remittance and posting support

A bank deposit proves that cash arrived, but it does not independently show which payer activity or claims posting batch it represents. Match each insurer EFT, check, or processor deposit to a remittance advice, payment-posting batch, or comparable internal support. In a deposit log, retain the payer name, deposit date, amount, bank reference, and posting-batch reference.

The IRS identifies supporting documents such as invoices, receipts, deposit slips, paid bills, and canceled checks as business records, and says electronic recordkeeping systems must provide complete and accurate records that are accessible to the IRS. IRS Publication 583: Starting a Business and Keeping Records

When one bank deposit represents several remittances, list the components in the reconciliation. If a remittance is posted but the related cash has not cleared by month-end, keep it as a documented timing item rather than creating a duplicate income entry or an unexplained clearing-account balance.

• Match each payer deposit to remittance or posting support.
• Flag deposits received but not yet posted to claims.
• Flag payments posted to claims but not yet deposited or cleared.
• Separate payer receipts from patient payments, refunds, card-processor activity, and owner transfers.
• Store remittance support in the practice’s restricted-access system or folder.

Convert the reconciliation into an owner report

A short owner report should focus on aggregate results, unresolved items, and cash implications rather than patient-level claim detail. The SBA lists accounts receivable, available cash, bank reconciliation, and payroll among the functions a small business should ensure someone can manage. SBA: Manage Your Business

Show both collections and receivables. Deposits received this month can relate to services from an earlier period, while recently provided services may not yet have produced payer cash. Viewing both measures helps a practice distinguish current cash activity from a rising or falling insurance receivables balance.

For example, assume summarized insurance A/R begins at $84,000. The month’s reports show $52,000 added, $46,000 of payer payments posted, and $8,000 of approved adjustments and other reductions. Expected ending A/R is $82,000. If the current report shows $86,500, the $4,500 difference is a follow-up item—not a plug.

• Month-end insurance A/R and change from prior month.
• Insurance A/R by aging bucket and payer, using aggregate amounts.
• Payer deposits matched to remittances and total unmatched deposits.
• Payments posted but not yet deposited or cleared.
• Open reconciliation items, assigned owner, and follow-up date.
• Cash collections, payroll, major practice expenses, and near-term cash needs.

Use a repeatable close checklist

Set a consistent close cadence and assign preparation and review responsibilities. A simple approach is for one person to assemble the monthly package and another person to review unusual items, aged balances, and unresolved differences. Preserve each month’s control report, reconciliation, deposit support, and follow-up log together.

Do not use the reconciliation to casually switch between cash and accrual reporting. The IRS says that, after an accounting method has been established, IRS approval is generally required to change it; changing from cash to accrual or the reverse is listed as an example of a change requiring approval. IRS Publication 538: Accounting Periods and Methods

• Run and save the month-end insurance A/R control report.
• Complete the beginning-to-ending A/R rollforward.
• Match payer deposits to remittance or posting support.
• Reconcile bank and clearing accounts used for insurance receipts.
• Review unusual adjustments, refunds, transfers, and write-offs.
• Prepare the owner report and assign each open item.
• Archive the close package in a restricted-access location.