Confused by so many funding mechanisms, who they are for, criteria to attain, etc.?  Confused by what is a loan versus a grant?  So many are and this workbook lays them all out for you as a reference guide and easily used to evaluate terms for each program and the applicability to your situation.  From here, moving to the Projections Workbook below, you can best assess from a strategic point of view, what financial methods are best.

With just a few essential inputs, this workbook will bring together your key financial terms, various reductions in revenues and expenses and sources of financial aid to produce an incremental net income  and cash flow projection.  This will help anticipate the worse month for you financially, how long the aid will last and what you may be left repaying next year. SHP is working towards inputting the revenue fields from your most recent dataset and will be in touch if more current data is needed.  In regards to the expense fields; you should be able to pull from your February 2020 financial statements; QuickBooks; or other accounting software reports.

Please note that the worksheet has several tabs; including a guide to the inputs; key assumptions that are embedded in the formulas and the projection worksheet itself.  We will be in touch shortly to discuss next steps on this.

The HHS portal is accessible for providers to begin the registration process for submission of claims requests for the COVID-19 testing and treatment of uninsured patients. The provider registration is a multi-step process that is estimated to take several days.  Again, DHHS has partnered with Optum/UHC for this process and it begins with locating or registering for your Optum ID.  From there, you will Validate TIN; Register for Optum Pay ACH; Upload and Validate your Provider Roster; Submit Patient Data (where you will be issued temporary Patient IDs) and submit claims via a standard EDI 837 transaction.

The embedded grid on this page provides information as to effective date of expanded telehealth coverage; duration of policy; waiver of cost-shares; billing guidance; any noted exclusions; and codes covered where it is explicitly listed by the plans.

As you’ll see from the grid; the billing guidance is varied without a consistent policy that should be applied. For example, Cigna’s systems do not have the capability to administer telehealth Place of Service or Modifiers without reducing the payment amount; therefore, any Cigna telehealth visits should be billed as regular face-to-face encounters.

The HHS Round 2 portal requires that you provide loss information in addition to your tax return. Your loss is based on the reduction in services that were provided in March and April 2020 compared to a baseline. While the portal does not specifically define how to calculate March/April losses, we strongly recommend some form of average collections vs. actual volume analysis as opposed to year over year collections for March '19 vs. March '20/April '19 vs. April '20, which may undershoot real losses at this point.

One version of that is the attached workbook, which we have prepared as an easy/minimalist method to assist with that calculation.

Download the Medicaid Portal applications, instructions, and worksheet, individually or as a group.

• Medicaid Provider Distribution Application Form (PDF)
• Medicaid Provider Distribution Application Form (XLS)
• Medicaid Provider Distribution Instructions (PDF)
• CARES Act Provider Relief Fund FTE Worksheet (XLS)
• CARES Act PRF Gross Revenue Worksheet (XLS)