From XU Magazine, 
Online News

Don’t Panic! Taking the Guesswork Out of PPP Loans

April 4, 2020

After a rocky rollout, the Paycheck Protection Program (PPP) went live on Friday, April 3. The loan program was established by the CARES Act to distribute $349 billion in loans to small businesses that have been hard hit by coronavirus shutdowns.
This article originated from the Xero blog. The XU Hub is an independent news and media platform - for Xero users, by Xero users. Any content, imagery and associated links below are directly from Xero and not produced by the XU Hub.
You can find the original post here:

SMBs can now apply for a PPP loan of up to 2.5 times their average monthly payroll, and the loan will be forgiven (read: you don’t need to pay it back) as long as it is used to cover wages, rent and other qualifying expenses and you maintain your workforce for 8 weeks.

National banks and other lending institutions are expected to begin accepting PPP loan applications via their online portals this coming week. The Treasury Department encouraged businesses “to apply as quickly as you can because there is a funding cap.”

To learn more about the details of the program, the U.S. Chamber of Commerce put out this excellent PPP loan guide. Below we cover everything else you need to know to get a PPP application ready to go ASAP.

What materials do I need to apply?

Businesses need to do two things to prepare their PPP loan applications:

  • Calculate your average monthly payroll number
  • Provide documentation for your payroll calculation

Sounds simple enough, but the devil’s in the details. Let’s dive in:

How to calculate average monthly payroll

There are quite a few calculators out there, but we hear confusion from our customers when they try to use them: Do they include FICA? What about employer 401(k) contributions? What precisely is capped at $100,000?

Because the official guidance is still evolving, many businesses, lenders and payroll companies have been struggling with these issues all week.

Businesses need answers to these nitty gritty questions, so we’re providing a detailed view of how we calculate average monthly payroll.

There’s still debate about what the right methodology is. Ours is based on the Treasury Department interim guidance issued on April 2 and Rippling’s participation in the AICPA-led coalition of payroll processors. Please note that you should follow your lender or counsel’s guidance, even if it differs from our own.

Step 1: Select the applicable time period.

  • For most companies, use (i) your last twelve months of payroll or (ii) your full year 2019 payroll. We recommend that you prepare both calculations and consult with your lender for guidance on the appropriate time frame due to conflicting views between the Treasury Department guidance and the sample PPP Loan instructions on this.
  • For seasonal businesses, use a 12 week period between February 15, 2019 and June 30, 2019*.
  • For new companies, use January 1, 2020 to February 29, 2020*.

Step 2: Calculate aggregate payroll costs.

  • Include employee compensation in the United States, cash tips, paid leave, employee portion of health insurance and retirement, and employee and employer portion of all federal, state, and local taxes.
  • Please note that we interpret the Treasury Department guidance to include FICA prior to February 15, 2020.

Step 3: Check for and remove any exclusions, such as:

  • Compensation for employees outside the United States
  • Compensation for independent contractors (1099s)
  • Federal employment taxes, including the employee’s and employer’s share of FICA, Railroad Retirement Act taxes, and income taxes, from February 15, 2020 to June 30, 2020 only
  • Any sick and family leave wages that are eligible for tax credits under the Families First Coronavirus Response Act (FFCRA)*

Step 4: Apply the $100,000 cap per employee.

  • Aggregate payroll cost per employee should be capped at $100,000 on an annualized basis.

Step 5: Add employer costs for benefits

  • Including health insurance premiums and contributions to retirement funds. We do not believe this is subject to the $100,000 cap.

Step 6: Divide by 12, unless you are using a seasonal or new business time period.

Step 7: Reduce by amount of Economic Injury Disaster Loan (EIDL) (if you’ve applied for one)*.

If you are a Rippling customer, please read on for how we can help you calculate your average monthly payroll amount and locate supporting tax documentation. Note that we do not include any of the starred (*) items above in our pre-built PPP average monthly payroll report tool.

If you are not a Rippling customer or you would like to run your own calculations, we recommend the AICPA’s publicly available PPP loan calculators.

How to document your payroll calculation

Ok, so now you have your average monthly payroll. Next, you need to provide your lender with documentation to back it up.

Most banks will request your IRS Form 940 and 941s for 2019

  • We’re aware that some lenders have been requesting the Q120 Form 941. Please note that this filing is not available until mid-April, and is not a required document. Industry groups are actively clarifying this with lenders.
  • Also, some businesses — like those that use a PEO for payroll — will not have access to IRS Forms 940 and 941s. Fret not!

If you do not have the forms above, you can provide other supporting documentation

  • The Treasury Department has clarified that IRS Forms 940 and 941s are not required documents, and companies must be allowed to provide alternative documentation, like bank records, to demonstrate your qualifying payroll amount.

For VC-backed startups, we recommend an extra step.

  • Include some supporting evidence of your good faith certification that these funds are necessary to continue business operations.
  • For example, documentation that you have lowered your business forecasts, experienced a reduction in revenue, have considered or implemented layoffs, and/or experienced difficulty in raising additional capital.

Can I use Rippling to make this easy?

Why, yes you can! We know it has been difficult to get clear information on the PPP program — what documents to gather, how to calculate average monthly payroll — so we’ve been working hard behind the scenes to sort out these details.

If you’re a customer, here’s how we can help.

We calculate average monthly payroll for you

Here’s how to use our new customized report for PPP loans:

  • Navigate to Reports on the left hand side panel
  • Select the Built-in Reports tab
  • Select the COVID-19 Payroll PPP Report
  • Under Dates, toggle to “Last 12 Months” or “Previous Calendar Year”
  • Please note that Rippling built two reports: (1) a full-year 2019 report and (2) a last twelve-months report, which will start calculations for the preceding 12 months. We recommend that you consult with your lender to determine their preferred time period for calculation.
  • Click Run Report
  • The “Monthly PPP-eligible costs” will be your “Average Monthly Payroll Cost.” Multiply this number by 2.5 to determine your max PPP loan eligibility. The total loan amount cannot exceed $10 million.

Check out the bottom of this post for the fine print on this tool, including detailed methodology, notes and disclaimers.

We provide supporting documentation

Simply create a Payroll Journal report:

  • From the Rippling Dashboard, open the Payroll app
  • Click on the Reports tab and select Journal Report
  • For Period select Custom, and select the From and To date range that you are running the report for
  • Click Apply
  • After the report has generated, you can click Download to the top right-hand corner to download the report as a CSV file.

We can also provide any available IRS Form 940 and 941 documents:

  • Navigate to your Payroll app
  • Click on the Docs tab
  • Click on Previous Filings (Docs) on the left hand side

Voilà. You’re ready to apply

With those materials in hand, you’re ready to apply for a PPP loan. Contact your bank or participating Section 7(a) lender directly to learn about their application process. While most national banks will issue their own version of the loan application online, the Treasury Department posted a sample application that will give you a good overview of what to expect.

Good luck!

The Fine Print

Details of Our Methodology

  • Base Columns:
  • Gross Pay: Employee Gross Pay
  • Imputed Pay (if applicable for your company): Taxable non-cash compensation, e.g. fringe benefits
  • Total Employer Taxes: All taxes paid by the employer (e.g. unemployment taxes, employer portion of FICA etc)
  • Federal Employment Taxes After Feb 15th: Employee and employer FICA taxes and employee federal taxes
  • Total Employer Retirement Contribution: Contributions to 401(k) plans
  • Total Employer Health Insurance Contribution: Contributions to medical, vision, and dental
  • Summary Columns:
  • Aggregate payroll costs with 100k max: MIN(100k, ‘Gross Pay’ – ‘ImputedPay’ + ‘Total Employer Taxes’ – ‘Federal Employment Taxes After Feb 15th’)
  • 12-mo PPP-eligible costs: ‘aggregate payroll costs with 100k max’ + ‘Total Employer Retirement Contribution’ + ‘Total Employer Health Insurance Contribution’
  • Monthly PPP-eligible costs: ’12-mo PPP-eligible cost’/12

Notes and Disclaimers:

  • Rippling follows the methodology outlined in “How should I calculate my average monthly payroll costs?”, except that Rippling does not include any of the starred (*) items in its pre-built PPP average monthly calculator. If any of the starred (*) items apply to you, please manually adjust the report or run a custom calculation using your payroll journals.
  • If you have been advised to use a different methodology, have additional payroll costs or exclusions to include (not listed above), or have taken an EDIL, please go in and manually update the report to suit your needs.
  • If you are a seasonal employer or a new company, please run a custom calculation using your payroll journals.
  • Please note that we only consider compensation within Rippling’s payroll system for the applicable 12-month period and apply the $100,000 cap on that time period. We recognize that some companies may want to apply the cap on a monthly, quarterly, per pay period or otherwise pro-rated basis for employees not employed during the full period. We also recognize that some companies may want to include compensation covering but paid outside the applicable time period (e.g. bonuses). If this applies to you, you will need to manually adjust those calculations.
  • Please note that we are unable to help you calculate your monthly average payroll if we do not have your payroll records for the entire applicable 12-month time period
  • We recommend that you include a copy of the “Detailed Methodology” with your application.


Why leave it there?

To learn more about Rippling

Straight to your inbox

Subscribe to our newsletter for updates as they happen
We hate spam too. We NEVER sell our mailing list.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.