Payroll Protection Program Calculation Template

IMPORTANT: This blog post is now out-of-date due to new guidance released on April 6th — see new post here.

The most recent interim guidance for the Payroll Protection Program makes a few vague and misunderstood items clearer… and creates some new issues in the process.

From my colleagues over at KMK Law:

Material Changes in PPP

  • Independent contractors do not count as employees for PPP loan calculations or loan forgiveness.
  • All federal employment taxes, including employee’s federal income tax withholding and both employer and employee’s share of FICA from February 15, 2020-June 30, 2020 are excluded from “payroll costs”.
    • This means that businesses are eligible for loan forgiveness based on the after-tax pay to employees (after FICA and income tax are withheld), not the gross pay made by the employer.
    • This exclusion applies only during the Feb. 15, 2020-June 30, 2020 period, which seems to imply that borrowers do not have to deduct employee income tax withholding and FICA when calculating the loan amount from 2019 payroll costs, except to the extent total payroll costs exceeds $100,000 per employee (including FICA and income tax withholding).
  • Interest rate is 1.0%.
  • At least 75% of PPP loans proceeds must be used on payroll costs (whether or not used in the 8-week period eligible for forgiveness; and to be eligible for forgiveness such payroll cost must be paid during the 8-week period).
  • Borrowers knowingly using PPP loan funds for unauthorized purposes may result in additional liability, including fraud.  In addition, if one of the borrower’s shareholders, members, or partners uses PPP funds for unauthorized purposes, SBA will have recourse against that shareholder, member or partner.

Note in particular the bit about payroll taxes: as a result, a lot of folks could be caught by surprise due to the fact that the initial loan request amount is based on gross pay, and the loan forgiveness is based on net pay. Most of us are pretty sure this was not the law’s intent, but we have to work with the most recent regulations released by the Treasury.

This excellent template by Joey Brannon at Axiom takes the new regs into account and explains his analysis by referring directly to each passage in the most recent release. Keep in mind that if you use Gusto or ADP, they will have calculated much of this for you — just make sure to gut-check the results.

The Treasury has also released a PPP Fact Sheet (it’s a little vague, but relatively simple to follow).

Of course, the entire small business community, accountants, advisors, lawyers, banks and other lenders are all frustrated beyond compare that this calculation couldn’t have been standardized and applied consistently. My favorite tax writer, Tony Nitti at Forbes, wrote an excellent article in the form of an open letter to the Treasury Secretary that outlines everything we’re thinking and feeling (but more intelligently, backed up with data, and without swear words).

Furthermore, Gusto is getting push-back from some clients and lenders who disagree with the interpretation of the new regs, and they have released an updated report that allows users to choose either method of calculation.

Hopefully this is just a glitch that will be remedied in the next week, after the ten days of comments are up — but just in case, you may wish to have all employees go to 9 exemptions for those eight weeks, making up the under-withholding later in the year. (And it serves the dual purpose of getting cash into the hands of people now, rather than at tax-time.)

Are we having fun yet?


If this or any other posts on the website were useful to you, and your financial situation permits it, please consider contributing to my tip jar. This allows me to continue to provide free accounting resources to small businesses who do not have the funds available to hire a CPA.

2 thoughts on “Payroll Protection Program Calculation Template”

  1. My question is this: how can a sole proprietor with no employees other than her/himself, after obtaining a PPP loan based on 2019 net earnings from self-employment, hope to qualify for ANY forgiveness unless same is based on her net earnings from self-employment during the 8-week period after obtaining the loan? Even if that is the case, does anyone else see the incongruity in forgiving loans based on use of loan proceeds for an amount of income that one must receive from others – i.e., not for an expense? That is especially true when one realizes that control of that amount is not in the hands of the loan recipient, but rather in the hands of the person paying them for their services, which is probably drastically reduced due to the COVID-19 situation. Think in terms of a sole proprietor realtor, for instance, who undoubtedly would qualify for a PPP loan, but would have trouble generating sales and commissions in the current environment.

    1. First, I want to make sure you saw that the guidance changed since this post went live, and the PPP template here is outdated. Please see a more recent post of mine on the PPP for instructions on calculating the amounts.

      Secondly, I am not sure I understand your question… for the PPP loan for a sole proprietor, the forgiveness *is* in fact based on how much you pay yourself in the 8 weeks following the loan. Same as for those with employees, you’re not supposed let pay dip below 75% of your average pay from the prior year. It is *not* based on revenue from others — I’m not sure where that misunderstanding came from.

      The calculation for forgiveness is 8 weeks of payroll (at least 75% of loan proceeds), plus up to 25% of loan proceeds to pay for rent/mortgage interest + utilities (a sole prop can use their home office costs for this).

      They haven’t released specific guidelines for sole props yet, because they will not be able to apply until April 10th, but hopefully that will happen tonight.

Leave a Reply

Your email address will not be published. Required fields are marked *