AccAnalysisAccAnalysis
Revenue Cycle & Financial Operations

Five hundred invoices a month, without a person assembling them

Generating, formatting and emailing invoices to more than three hundred hospital facilities was consuming days of every month. We automated the full lifecycle on monthly and weekly cadences.

At a glance
Status
Delivered
Region
United States
Engagement model
Shared specialists

Status: Delivered. Described from our own delivery records. Client identity, brand and commercial terms are withheld. Figures, where given, cover the period stated and nothing beyond it.

The organisation

Context

A revenue-cycle operation billing more than three hundred hospital facilities on monthly and weekly cycles.

Each invoice needed generating from current data, formatting correctly, addressing to the right recipients, and sending with the right attachments.

The brief

The problem

  • Around five hundred invoices a month were produced and sent largely by hand.
  • The work was concentrated at period end, so it collided with everything else that happens at period end.
  • Recipient lists, subject lines and attachment sets were maintained manually and drifted.
  • A mistake was expensive in a specific way: an invoice sent to the wrong facility is both a billing problem and a data-handling one.
The work

What we built

Automation of the full invoice lifecycle

Data refresh, generation, export and formatting — for both cadences.

A mapped distribution layer

Holding recipients, subject lines, body content and attachment rules per facility, maintained as configuration rather than as a habit.

Scheduled execution

On the monthly and weekly cycles, with run reporting.

Method

How we delivered it

  1. 1

    Map every facility's billing requirements

    Cadence, recipients, format, attachments — into a single configuration set.

  2. 2

    Automate generation

    With output validated against the manual result.

  3. 3

    Automate distribution

    Initially to an internal mailbox rather than to facilities.

  4. 4

    Parallel-run a full cycle

    Comparing every generated invoice against the manual one.

  5. 5

    Switch over cadence by cadence

    Monthly first, then weekly.

Sequence

How it was phased

PhaseDurationWhat happens
1Requirement mapping
2–3 wks

Per-facility cadence, recipients, format, attachments

2Generation automation
3–4 wks

Refresh, export, formatting

3Distribution automation
2–3 wks

Mapped recipients, subjects, bodies, attachments

4Parallel cycle
4 wks

A full period compared invoice by invoice

5Switch-over
2 wks

Monthly first, then weekly

Indicative phasing for work of this shape. Actual duration varies with data quality, access and decision speed.

Hand-over

What the client keeps

  • The automation definitions and source
  • The per-facility distribution configuration
  • The parallel-run comparison record
  • The run-monitoring setup
Stack
Power AutomatePower BISQLSharePointScheduled email distribution
Keep reading

Related

Related case studies

Tell us what your current system can't do, and we'll tell you what it would take to change that.