Reconciling A/R to the General Ledger
Two numbers claim to be the receivable: the total of the open balances in the billing system, and the A/R control account in the general ledger. They rarely match, and the instinct to treat every difference as an error is what makes this reconciliation feel impossible. Most of the gap is structural — the two books are built from different events for different purposes. The work is to name each difference, not to eliminate it, and a reconciliation that ends in a list is finished while one that ends in agreement may only be lucky.
Updated 10 min read
On this page
Key takeaways
- A receivable exists because revenue is recognized when it is earned rather than when it is collected. The A/R balance is that gap, carried on the balance sheet.
- The aging is a claim-level operational record answering who owes what. The general ledger is a dollar-level financial record answering what the practice's assets are. Neither is a worse version of the other.
- The reconciliation's output is a list of named, explained differences — not a single matched figure. An unexplained variance is the finding, whatever its size.
- The recurring reconciling items are few and knowable: charges captured but not billed, adjustments taken at different moments in each book, credit balances netted against debits, unapplied cash, and write-offs recorded in one book before the other.
- Credit balances hidden inside a net receivable are the item most likely to matter beyond accounting, because a credit balance can be a refund obligation rather than a discount on what is owed.
- Consistency between periods is the property that makes the number useful. A definition changed quietly is more damaging than a definition that was never ideal.
- The standard worth holding to is that a qualified outsider could follow the reconciliation from the source records without being talked through it.
Why there is a receivable at all
The reconciliation is much easier to run once the underlying idea is explicit, and it often is not. Federal regulation states it about as cleanly as it can be stated. Under 42 CFR 413.24(b)(2) (opens in a new tab), the accrual basis of accounting means that revenue is reported in the period in which it is earned, regardless of when it is collected, and an expense in the period in which it is incurred, regardless of when it is paid.
That single sentence is the whole reason the number exists. Work performed in March is March's revenue whether the money arrives in April, in September, or never. Accounts receivable is the balance-sheet name for the interval between those two events. It follows that the receivable is not a queue of problems — it is the expected consequence of recognizing revenue when it is earned, and only the part that ages beyond explanation is a problem.
Who Part 413 actually binds, said plainly
Two books answering two questions
The billing system and the general ledger are not two copies of one record. They were built for different readers and they record different events, which is why forcing them to agree destroys information rather than producing it.
| Dimension | The billing system's A/R | The general ledger's A/R |
|---|---|---|
| The question it answers | Who owes what, on which claim, and how old is it? | What is the practice's receivable asset worth at this date, and what changed it in this period? |
| The unit | A claim or an account, attached to a patient and a payer. | A dollar amount in a control account, attached to a period. |
| The event that moves it | A claim is created, submitted, adjudicated, adjusted, paid, or written off. | A journal entry posts — often summarized from the billing system in a batch, on a schedule that is its own decision. |
| Who relies on it | Follow-up staff deciding what to work next; the discipline in designing an A/R follow-up process. | Owners, lenders, and auditors reading a balance sheet, plus anyone comparing this period with the last. |
Because the second is usually built from a summarized feed of the first, the interface between them — what gets summarized, when, and on which definitions — is where nearly every recurring difference originates. It is worth documenting once, in writing, because nobody can reconstruct it from either book alone.
The differences that recur, named
A reconciliation gets tractable the moment the differences stop being a single mysterious variance and become a short list of known categories. Nearly everything falls into one of these.
- Captured but not billed
- Charges entered and not yet submitted. Whether these sit in the receivable at all depends on when the practice recognizes the charge, and the two books frequently answer differently. This is also the population with no aging row at all, which unbilled and held claims covers as a risk rather than as an accounting question.
- Adjustments taken at different moments
- A contractual adjustment may be recognized when the claim is billed or when the remittance arrives. Bill at full charge and adjust on payment, and the receivable carries an amount nobody expects to collect; estimate the allowable up front, and it does not. Both are defensible; carrying one convention in each book is not.
- Credit balances netted into a total
- Accounts in credit reduce a net receivable, which quietly conceals them. A credit balance is often a refund obligation — a liability, not a smaller asset — and credit balance refunds covers why it cannot simply be left to offset.
- Cash received and not applied
- Money in the bank that no claim has been credited for sits in suspense. It has reduced nothing in the aging while having very much arrived, which is exactly the shape of a reconciling item. Unapplied cash owns clearing it.
- Write-offs recorded in one book first
- A write-off approved operationally and not yet journalized — or journalized in bulk while the accounts clear individually — produces a difference that resolves itself next period and looks alarming this one.
- Timing at the cutoff
- Anything that straddles a period end. This is the cash-side close's territory rather than this reconciliation's, and the month-end cash close sets out how a straddling item is assigned to one side and carried by name.
The output is the list, not the match
The standard the work has to meet
There is a usable articulation of what adequate financial records look like, and it is worth borrowing whether or not it binds a given practice. 42 CFR 413.24(a) (opens in a new tab) requires cost data based on financial and statistical records capable of verification by qualified auditors, and 413.24(c) adds that the data must be accurate and in sufficient detail for its purpose, and that records should be maintained consistently from one period to another so that comparability is not impaired — while allowing that a desirable change in procedure is not precluded where there is reason for it.
Verifiable by someone who was not there
The test is not whether the person who ran it believes it. It is whether a qualified outsider can start from the source records and arrive at the same place without narration. That standard is what makes the reconciliation evidence rather than reassurance.Detailed enough for its purpose
A single variance figure meets no purpose. A variance resolved into named categories, each traceable to accounts, is what lets someone act — and what makes next month's version take an hour rather than a week.Consistent between periods
The property that makes a trend mean anything. If the definition of open A/R changes quietly between periods, every comparison built on it becomes wrong, and nothing in either book records that it happened. A definition changed deliberately, dated and documented, is fine; the regulation itself allows for change with reason.Run on a rhythm, at the same point each period
Reconciliation performed only when something looks wrong is not a control, because it never runs in the periods where a problem is still small. The value comes from the cadence, and from the fact that an unexplained difference has somewhere to be raised.
Records that cannot support the number are their own risk
Common questions
Should the aging total and the general ledger ever match exactly?
Sometimes they do, and it is not the goal. The two books record different events on different schedules, so a set of legitimate differences normally sits between them — unbilled charges, adjustments recognized at different moments, credit balances, unapplied cash, write-offs posted in one book before the other. Exact agreement is a pleasant coincidence when it happens and a warning when it is engineered, because forcing a match usually means a plug entry was posted rather than a difference explained. The reconciliation's product is a list of named differences that someone can defend.
Why does the receivable exist if we have not been paid?
Because revenue is recognized when it is earned rather than when it is collected. That is the accrual basis, and it is why performing a service creates an asset immediately: the practice has done the work and is owed for it. The receivable is the balance-sheet record of that interval. Understanding this changes how the number is read — a receivable is not by itself evidence of a collections problem, and only the portion that is aging beyond what the payer mix and the process would predict is telling you something.
Where do credit balances belong in this?
They deserve separate treatment rather than netting. An account in credit usually represents money the practice holds that belongs to someone else — an overpayment awaiting refund — which is a liability rather than a reduction of an asset. Netting it against debit balances produces a receivable total that understates both sides at once and hides an obligation that carries its own rules and its own deadlines. Report the two populations separately even where the accounting eventually nets them, so that nobody has to discover the credit balances by accident.
Our billing system and general ledger use different definitions of open A/R. Is that a problem?
Only if it is undocumented, which it usually is. Two defensible definitions can coexist as long as the difference between them is written down and the same definition is used in each book from period to period. The failure mode is not divergence; it is silent divergence, and its cost lands on trends rather than on any single month — a comparison across periods becomes meaningless without anything visibly breaking. Write the definitions down once, note where they differ and why, and treat a change to either as an event to be dated and explained.
How is this different from the month-end cash close?
The cash close asks whether every dollar the practice received was recorded and placed in the correct period, and then freezes that period. This reconciliation asks whether the receivable still owed is stated correctly on the balance sheet. One ties to the bank, the other ties to the ledger, and they have different reconciling items — a deposit in transit belongs to the first, an unbilled charge to the second. They are usually run in the same week by the same person, which is why they get conflated, and running them as one exercise tends to mean the balance-sheet half is quietly skipped.
Key terms in this article
Defined once, on their own pages.
Continue learning
The book being reconciled, and the cash-side close beside it.
A/R Aging Buckets
The sub-ledger side of this reconciliation, and what the aging does and does not show.
The Month-End Cash Close
The cash-side tie-out that runs in the same week and answers a different question.
Unapplied Cash
Money received and not yet credited to a claim — a reconciling item with its own clearing process.
Credit Balance Refunds
Why a credit balance is an obligation rather than a smaller receivable.
Unbilled and Held Claims
The population that appears in neither book the same way, and why it is the riskiest.
Days in A/R Calculator
Build the measure from your own figures, once the receivable is stated correctly.
Authoritative sources
- 42 CFR § 413.24 — Adequate cost data and cost finding (opens in a new tab)
Requires providers paid on a reasonable-cost basis to provide adequate cost data based on financial and statistical records capable of verification by qualified auditors, on an approved method of cost finding and on the accrual basis of accounting. Paragraph (b)(2) defines the accrual basis: revenue is reported in the period in which it is earned regardless of when it is collected, and an expense in the period in which it is incurred regardless of when it is paid. Paragraph (c) requires that data be accurate and in sufficient detail for the purpose intended, and that financial and statistical records be maintained consistently from one period to another so that comparability is not impaired — while providing that a proper regard for consistency need not preclude a desirable change in accounting procedures where there is reason for it.
- 42 CFR § 413.20 — Financial data and reports (opens in a new tab)
States that the principles of cost reimbursement require providers to maintain sufficient financial records and statistical data for proper determination of costs, and that the methods used make use of data available from the institution's basic accounts as usually maintained rather than a separate special-purpose set. Paragraph (e) provides that where a contractor determines a provider does not maintain, or no longer maintains, adequate records for determining reasonable cost, payments may be suspended until the contractor is assured adequate records are maintained, following written notice identifying the recordkeeping deficiencies and an opportunity for the provider to respond.