Home » ARPA

Lost Revenue

American Rescue Plan Act funding can be used to replace lost revenue resulting from the COVID-19 pandemic. Specifically, the law and Treasury guidance provides for an eligible expenditure to, “Provide government services affected by a revenue reduction resulting from COVID-19.”

For determining what amount of loss revenue occurred the formula compares their actual to a baseline adjusted for what could have been expected to occur in the absence of the pandemic. Municipalities can presume that any decrease in revenue is due to the public health emergency; recipients don’t have to demonstrate impact. Importantly, once a shortfall in revenue is identified, municipalities will have broad latitude to use this funding to support government services, up to this amount of lost revenue.

  • Training Video (Updated August 30, 2021)
  • Presentation (Updated August 30, 2021) (PDF)
  • Lost Revenue FAQs (Treasury) (PDF)
  • General Revenue Flow Chart (PDF)
  • Lost Revenue Portion of the Interim (PDF)
  • NLC's Lost Revenue Calculator (Link)

Use the Revenue Loss Worksheet to Calculate Loss Revenue

The Revenue Loss Worksheet was created to help you calculate your city’s Lost Revenue based on the guidance provided by Treasury. It is designed to be used for all periods from 12/31/2020 – 12/31/2023.

  • Revenue Loss Worksheet (Updated August 30, 2021) (Excel)


The spreadsheet contains 3 tabs:

  • Calculator Summary: This tab summarizes the information from the other tabs and displays a table that generates “Counterfactual Revenue” (Projected Growth Revenue), compares it to “Actual Revenue,” and calculates “Revenue Loss” (Lost Revenue). You will not enter anything directly into this tab.
  • Revenue: This tab is used to collect the city’s revenue and revenue adjustments for 2019 (Base Year) and 2020-2023, as available. Enter your city’s revenue information in the gray areas.
  • Growth Adjustment: This tab is only necessary if you believe your city has experienced an average annual revenue growth greater than 4.1% from 2017-2019. If so, enter your city’s revenue information in the gray areas for 2016-2018. The information for 2019 will automatically generate based on the 2019 data entered on the Revenue tab. This tab will not need to be updated each year. It will remain the same.

Each tab has instructions at the top in a navy blue box with white lettering. Beneath the Instructions will be information related to Highlighted Fields. These will explain what the highlighting on each tab means. Generally, highlighting means the following:

  • Navy Blue: Used for Instructions, column labels, and table labels
  • Dark Blue: Revenue tab data used on/for the Calculator Summary tab
  • Light Blue: Growth Adjustment tab data used on/for the Calculator Summary tab 
  • Gray: Cells for city information/data to be entered into as applicable