Free Excel template · ASC 954 / ASC 606

Audit Program: Hospital and Health System

A hospital’s revenue is an estimate from first to last: gross charges reduced by contractual allowances and price concessions to what it expects to collect. The audit turns on those estimates, on third-party settlements that stay open for years, and on patient receivables by payor. This program sets out the procedures with objectives and assertions.

Standard
ASC 954 / ASC 606
Format
Excel (.xlsx)
Cost
Free
Access
No sign-up

What it is

A hospital’s revenue is an estimate from first to last: gross charges reduced by contractual allowances and price concessions to what it expects to collect. The audit turns on those estimates, on third-party settlements that stay open for years, and on patient receivables by payor. This program sets out the procedures with objectives and assertions.

It is a five-tab workbook with procedures, risks, tie-outs and completion tracking, and general procedures appended. It follows the structure of the standards and is paraphrased. Use the medical practice program for physician groups.

When to use it

What’s inside

Standard cited

This template follows ASC 954 / ASC 606. It is written in our own words, except for phrases the standard requires the document to contain, with [bracketed placeholders] for client details, amounts in USD and dates as MM/DD/YYYY. Check it against the current standard and your firm’s methodology before use.

Download free Excel template (.xlsx)

Questions

How are contractual allowances tested?

By recomputing them from contract rates and collection history by payor, and comparing prior estimates with actual remittances.

Why do third-party settlements get their own section?

Cost reports stay open for years and the estimates change with audits and appeals, so balances are judgmental and often large.

Does it replace a Medicare compliance review?

No. It addresses the financial statement audit. Compliance reviews and regulatory opinions need separate work.

Related templates

Last updated 11/05/2026. All free templates.