SNF Month-End Close: A Reconciliation Pack With Worked Outputs

Put a reconciliation at each system boundary

A folder containing census, claims and bank reports is an index, not a reconciliation. Each report may describe a different period and unit. Build the pack around what moves between them.

This original fictional close exercise uses October 2026 and one accounting entity. All monetary amounts are invented. It illustrates controls and arithmetic, not accounting entries, recognition policy or a completed Medicare filing.

Record extraction time, filters, preparer and reviewer for each input. If a file changes after approval, it becomes a new version; the old signed workpaper remains reproducible.

W1: A balanced total that must fail

Assume qualified review has already established the correct days for two fictional resident-period records. This worksheet tests reconciliation, not Medicare day eligibility.

The pack has two exceptions despite zero net variance. Correcting only the total would do nothing. Resolve the records, preserve the original 18-day summary and identify any already transmitted claim versions needing separate action.

Use explicit day definitions. Occupied-bed days, covered days and claim units are not interchangeable. Similarly, 80 occupied beds out of 100 certified beds is 80%, while 80 out of 90 operationally available beds is 88.9%. A room restriction may change the operational denominator without establishing a certification change.

W2 and W4: Complete the receivable bridges

The fictional receivable roll-forward is:

$120,000 opening + $90,000 additions − $70,000 applied cash − $5,000 approved reductions = $135,000 closing.

These categories must be defined consistently with the organization's policy and source ledgers. They are not a recommendation to recognize every billing estimate as revenue.

Now assume the ledger control balance is $136,200 while the frozen subledger is $135,000. The difference is $1,200. A documented $1,000 approved entry not yet reflected in the subledger explains part of it; $200 remains unexplained. Retain that remainder. The controller determines its treatment; the preparer should not distribute it across accounts to obtain zero.

A balanced roll-forward does not prove the input population is complete. Match the facility/entity scope and investigate missing extracts before calling the regional pack complete.

W3: Explain cash without moving a provider item to a resident

Assume remittance claim payments total $50,000 and the same payment contains a $2,000 provider deduction. Expected transfer is $48,000. A matching $48,000 bank receipt reconciles the reference; a $47,500 receipt leaves a $500 difference.

CMS payment and remittance guidance distinguishes provider-level from claim-level adjustments. Keep the $2,000 at its actual level while finance reviews its treatment. Arbitrarily reducing one resident claim would disguise the bank reconciliation inside an inaccurate account.

Tie receipts to payment references. A same-dollar bank entry for another entity or date is not sufficient evidence. Keep “remittance received, bank pending” distinct from “bank matched.”

W5: Handle a November discovery about October

On November 6, reviewed evidence corrects an October discharge date. The original close used the old event. Record both dates, the discovery date, source, affected claim versions, reports and financial review.

The census correction can be complete while the claim and accounting reviews remain open. The controller may approve a revised management view or another treatment under policy; the worksheet does not prescribe it. Label any rerun “current corrected view” and retain the actual report approved at close.

Carry an unresolved item into the next pack under its original identifier. Creating a new row every month conceals age. An explained timing item needs evidence of expected resolution; an unexplained item needs an investigation, not merely another date.

Preserve the cost-report handoff without pretending it is finished

CMS-2540-24 instructions use defined worksheet inputs. For the preparer, retain source extracts, filters, period, mapping or transformation, reviewed adjustments and final value. A report field called “beds” or “days” cannot establish the worksheet definition by its name alone.

For a related-party cost question, the handoff may also need relationship evidence, supplying-organization cost records and the allocation basis. A paid invoice alone does not decide the allowable reporting amount. Preserve the allocation denominator so another preparer can reproduce the calculation; leave the actual treatment to qualified review.

The close index should end with specific dispositions: W1's two errors resolved or still assigned; W2 reproduced at $135,000; W4's $200 remainder under review; W3 matched or carrying its stated difference; W5 awaiting or carrying the controller's decision. That record is more informative than a signed cover sheet saying all reports were downloaded.