CARES ACT PPP Loan Preparation
*Disclaimer*
AdvanStaff HR is NOT a legal or tax advisor on any loan program and all situations are different. We are doing our best to outline various key points recently published.
Many banks and legal advisors are still digesting the new guidelines and application acceptance dates will vary from bank to bank based on how those banks interpret the changes.
If you have questions please open a ticket. We will get back to you ASAP by phone (if requested) or by email.
If you need help or assistance with anything at all, please open a support request.
We will respond promptly.
Include ALL the following inserts with your loan application.
PPP(& PPP2) Loan Payroll Data / Reports Instructions
The Loan Application calls for “Average Monthly Payroll”
Managers can download a report from the Manager Portal to help gather this information.
Based on clarification from the Paycheck Protection Program – Interim Final Rule available as of 4/2 late evening, we understand the following:
- Allowable expenses:
- Gross Wages
- SUTA
- Other State Taxes
- ER Paid Benefits
- ER 401k Match
- Disallowed expenses. The following columns have been removed from the report.
- FICA
- FUTA
- Works’s Comp
- 1099 Subcontractors
The client allocation report has been updated accordingly.
If you want payroll data now, you can run a report on your own. We suggest
- printing a hard copy (unedited) version of the report to provide to your bank. Your bank will want an official, unedit reports from your 3rd party payroll services (AdvanAStaff HR).
- exporting the report to be edited for the purpose of calculating the loan amount.
Now run a payroll report on your own.
- Log into the Manager Portal
- Step 1- Click on the “Report” Icon at the top of the action bar.
- Step 2 -Under “Payroll Reports,” click on the “Client Allocation Report” option.
Next, you will select the variables to run the report.
- Client Allocation Report
- Select: ” -OR- Enter a Pay Date Range check box
- Enter a custom date range in the fields to the right (i.e. 01/01/2019 to 12/31/2019)
- Report Parameters
- Allocation Format: SBA
- Report Type: Detail Report
- Field Type Column Display: Code Only
- Field Type Column Display Order: Before EE Info
- Other Parameters: “Suppress Page Break on Primary Sort (Detail Report)” check box
- Allocation and Sort Parameters:
- Select the broadest (or appropriate) range value. “Location” or “Project” may be appropriate.
- Run the Report
Now that you can see the report, you can print a hard copy and open the report in MS Excel and edit the file.
Print a hard copy of the report under the “Actions” pull-down at the top of the window. Your bank may prefer an official, hard copy report from AdvanStaff HR.
Next, export the report to a spreadsheet for editing.
- Click on the “XLS” link at the top left of the screen.
- Download and open the file.
You can now edit the employee payroll report
- Remove all unnecessary columns.
- Where applicable, cap employees payroll at $100,000
- Divide the column totals by 12 to get the monthly average
- Sum the monthly average totals by category
- Add a line with the 2.5x or 3.5x monthly multiplier depending on your industry
We will continue to develop this report. If you follow the steps above, you will get the “gross payroll” or the “Payroll Costs” that you might need to apply for the loan.
It is *probable* this number will be used to compare the employee retention rate later in order to determine the amount of loan forgiveness.
To compute the number of jobs, you need to take the average number of employees from 1/1/2020 – 2/29/2020.
Instructions
- Run the same Client Allocation Report as previously listed by month (custom range) for:
- January 2020
- February 2020
- Count the number of paid employees for each month
- Divide the total by 2
Because the loan forgiveness will be partially based on employee retention rate (and maintaining pay rates) you need to make sure these numbers are accurate.
Do not over state the number of active employees on the application form.
It is possible the bank requests copies of 941 or 941 equivalent reports. The tax reports are not required as mentioned in the 4/2/2020 Paycheck Protection Program – Interim Final Rule (IFR)
This language makes clear that lenders can confirm the eligible loan amount using the “required documents” as set forth in the IFR, such as payroll records, bank statements, etc., and that tax documents (such as Forms 941) are not required to be provided to lenders to qualify for the loans. And while the application does continue to reference “tax information,” it says specifically “any,” tax information, indicating that, in fact, no such “tax information” may be provided, but if “any tax information” is provided, the client employer is merely authorizing the SBA to share that information with SBA representatives and the Office of the Inspector General.
Download the explanation letters to be provided to your banker
Again, under these rules, 941s are not required to be provided to lenders in order to qualify for the loans.
However, if you decide that you this report, please make a request through the ticket system.