Skip to content
Spreadsheet

Sliding Fee Scale & Eligibility Worksheet

Federal poverty guidelines are issued annually, vary by household size and differ for Alaska and Hawaii — so a workbook shipping figures would quietly apply last year’s numbers to this year’s patients and nobody would notice. You enter your own table and your own adopted discount tiers; the workbook applies them consistently to every household, computes the percentage of guideline, and records who determined it and when. A Settings cell holds the guideline year, so an out-of-date table is visible instead of silent.

  • Percentage of guideline and tier computed per household
  • A guideline-year field that makes a stale table visible
  • Gaps between discount bands reported rather than rounded away

Recorded on the Summary so an out-of-date table is visible rather than silent.

Download your workbook

The income table and the discount tiers arrive empty on purpose. Poverty guidelines change annually and a schedule is a policy you adopt — a workbook shipping figures would apply last year’s numbers silently.

Keep going

Related free tools

Stop screening volunteers the hard way

These free tools are built by VolunteerBadge — full national criminal background checks for just $5, with FCRA compliance built in. No monthly fees.

Create Free Account