Coming soon · Alteryx workflows for hospital finance

Leases, bonds and net assets, tied out.

Workflows for the schedules a hospital close depends on, each tested in the Alteryx engine against an independent answer key. Built on a fictional health system, so you can run every one before it touches your own data. The first collection is in the works now.

See the planned books See the covenant check

Photo: David Trinks on Unsplash

Preview · debt covenant check

Fiscal year-end test, from the ledger

Covenant Result Required Check
Days cash on hand130.0≥ 75Pass
Debt service coverage2.60x≥ 1.25xPass
Cash and investments tie to GL0.000.00Ties
Sample results for a fictional health system. The workflow, coming in the first collection, shows every input: unrestricted cash and investments, operating expenses less depreciation, and maximum annual debt service.

Five areas

The schedules behind a hospital close.

Start with the first collection. The other areas follow as each book passes its engine test. Open a card to see its books.

First collection

Leases: the books

  • Equipment and building leases under ASC 842
  • Lease roll-forward: liability and right-of-use asset
  • Lease changes: extensions, terminations, remeasurement
  • Short-term and low-value screening

Debt: the books

  • Bond and loan amortization, premium and discount
  • Covenants: days cash on hand, debt service coverage
  • Trustee and lender statements to the GL

Investments and net assets: the books

  • With and without donor restrictions, and the releases
  • Custodian statements to the GL, by fund
  • Board-designated versus donor-restricted funds

Coming next

Patient revenue: the books

  • Gross to net: contractuals, bad debt, charity care
  • Payments to remittances: bank deposits matched to 835 files and posted cash
  • Denials by payer and reason; the receivables allowance

The close: the books

  • Cash: bank statements to the GL, every account
  • Non-patient receivables (NonAR): grants, rebates, other amounts due
  • Prepaid amortization and accruals, with the PO three-way match
  • Self-insurance reserves: malpractice and employee health claims
  • Intercompany: hospital, clinics and foundation
  • Fixed asset roll-forward

Photos on Unsplash: Marcel Scholte, LEDC, Jakub Żerdzicki, Max Tcvetkov, Vitaly Gariev.

What every book includes

The same build as the revenue library: one workflow, explained tool by tool, with the data to prove it.

Leases, debt and net assets collection

The first ten books are coming soon.

Leases, debt, and investments and net assets, each tested in the Alteryx engine. Email us and we will tell you the day it is ready. Email me when it is ready

Questions

Is any real hospital or patient data used?

No. Every file describes a fictional health system, built for the book.

Which ERP do I need?

None in particular. The workflows read CSV extracts; each book says which fields to pull from your system.

I'm at a not-for-profit outside healthcare. Will these fit?

The lease, debt and net asset books will. The patient revenue books are hospital-specific.