Tag Archives: loan

EIDL & Advance Program Reopened To All Small Businesses June 15

The U.S. Small Business Administration reopened the Economic Injury Disaster Loan (EIDL) and EIDL Advance program portal to all eligible applicants experiencing economic impacts due to COVID-19 today.

As a reminder — EIDL is considered a “working capital” loan, which means it’s meant to be used to make payments that would have been required to sustain operations if the disaster hadn’t occurred in the first place. The only items that EIDL can’t be used on are a) expansion costs (which includes new assets only if they are part of the expansion; therefore regular replacement or investment in equipment for increased efficiency is allowable), b) consolidating long-term debt (so regular LOC and debt service payments are fine, but not anything that essentially refinances existing long-term debt), and c) shareholder payroll or distributions that are not in the usual course of business (in other words, you can’t use the EIDL to essentially give yourself a bonus).

From their press release today, June 15: “The SBA is strongly committed to working around the clock, providing dedicated emergency assistance to the small businesses and non-profits that are facing economic disruption due to the COVID-19 impact.  With the reopening of the EIDL assistance and EIDL Advance application portal to all new applicants, additional small businesses and non-profits will be able to receive these long-term, low interest loans and emergency grants – reducing the economic impacts for their businesses, employees and communities they support,” said SBA Administrator Jovita Carranza. 

EIDL assistance can be used to cover payroll and inventory, pay debt or fund other expenses.  Additionally, the EIDL Advance will provide up to $10,000 ($1,000 per employee) of emergency economic relief to businesses that are currently experiencing temporary difficulties, and these emergency grants do not have to be repaid.

  • The SBA is offering low interest federal disaster loans for working capital to small businesses and non-profit organizations that are suffering substantial economic injury as a result of COVID-19 in all U.S. states, Washington D.C., and territories.
  • These loans may be used to pay debts, payroll, accounts payable and other bills that can’t be paid because of the disaster’s impact, and that are not already covered by a Paycheck Protection Program loan.  The interest rate is 3.75% for small businesses.  The interest rate for non-profits is 2.75%.
  • To keep payments affordable for small businesses, SBA offers loans with long repayment terms, up to a maximum of 30 years. Plus, the first payment is deferred for one year.
  • In addition, small businesses and non-profits may request, as part of their loan application, an EIDL Advance of up to $10,000. The EIDL Advance is designed to provide emergency economic relief to businesses that are currently experiencing a temporary loss of revenue. This advance will not have to be repaid, and small businesses may receive an advance even if they are not approved for a loan.

For more on the EIDL, see my earlier blog posts here.


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.

PPP Applicant Non-Financial Felony Threshold Reduced

From the June 14th SBA E-Newsletter :

The eligibility threshold for those with felony criminal histories has been changed. The look-back period has been reduced from 5 years to 1 year to determine eligibility for applicants, or owners of applicants, who, for non-financial felonies, have (1) been convicted, (2) pleaded guilty, (3) pleaded nolo contendere, or (4) been placed on any form of parole or probation (including probation before judgment).

The period remains 5 years for felonies involving fraud, bribery, embezzlement, or a false statement in a loan application or an application for federal financial assistance. The application also eliminates pre-trial diversion status as a criterion affecting eligibility.

SBA issued revised PPP application forms to conform to these changes. The guidance and revised application forms are available on SBA’s and Treasury’s websites. SBA will issue additional guidance regarding loan forgiveness and a revised forgiveness application to implement the PPPFA in the near future.


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.

SBA & Treasury Release Initial PPP Flexibility Act Guidance – FREE Zoom Recording

Late night on June 10th, the SBA and Treasury released the 17th interim final rule to reflect changes made by the Paycheck Protection Program Flexibility Act. SBA also published updated application forms to use for loans made on or after June 5, 2020.

The new IFR is mostly a restating and clarification of what we already knew from the statute, its accompanying statement, and the recent Treasury statement.

We are still waiting for guidance for most of our questions, which is especially frustrating given that many PPP loan borrowers have reached or are nearing the end of the original eight-week covered period. As has been a consistent theme, the SBA and the Treasury have promised additional regulations and guidance soon. The concern over the constantly-changing, difficult-to-understand rules — which have been impossible to plan around thus far — has caused a big slow-down in applications. As of now, PPP loans must be approved by June 30th (not applied-for, but approved-by).

(For those who haven’t yet applied: these days I’m finding Funding Circle to have the quickest turnaround and easiest application process for new borrowers. No, I do not receive any benefits from them.)

The biggest problem with the PPP is that you will likely need an accountant (or you could possibly get away with an advanced degree in mathematics) to figure out how to calculate the forgivable portion of the loan — which is hard enough on its own, but even harder when trying to plan, as the rules keep changing. The government did not — in any of the three Acts that involve these loans — realize the administrative burden these rules place on business owners… especially at a time when they’re trying to figure out how to survive the coronavirus shutdown and cautious reopening of our economy.

That said, it may no longer be “free” money, but in most cases, it is definitely still worth it. I’ve been attending the weekly AICPA Town Hall meetings and reporting on them to my clients and colleagues, and making some of those recordings available for the public, in hopes that it will help guide you (or your clients) to making better decisions about how to use the funds.


Here are my notes from the above zoom session, in case it’s easier to read than to listen/watch, or in case you’d like to follow along.

I have taken three webinars on the new PPP forgiveness rules in the past week — and gotten three different interpretations, and a lot of misinformation. So please keep in mind that I am only AN expert, not THE expert.

AICPA Town Hall 6/11 – WHAT WE KNOW

  • Treasury statement came out 6/8 and more guidance released 6/10.
  • 60% cliff fixed!
  • Extension to 24 weeks is automatic; can elect 8-wk period on forgiveness application.
  • The Interim Final Rule released today does not address FTEs. As-written, we’ll have to keep FTEs up for 24 weeks.
    Alternatives: expansion of FTE reduction exemptions AND/OR Safe Harbor of 12/31/20.
  • May not use the old application… wait for new one.
  • Simplified application expected for those with no employees — at the very least, AICPA will release simplified spreadsheet.
  • You do not have to wait until the end of the 24 weeks to apply for forgiveness if you meet the requirements.
  • If you use the 8-week period, the new 60% rule applies – you do not still need to meet the 75% rule.
  • They are trying to get every loan forgiven as much as possible – guidance will be lenient; more relief may come.
  • Treasury referred to ACIPA forgiveness spreadsheet as the gold standard (yay!)
  • You can reapply for PPP if you returned the money or didn’t get full funding.
  • RECOMMENDATION — OPT IN TO PAYROLL TAX DEFERRALS!
  • June 10: Sec. Carranza indicated new EIDL applications will be accepted starting next week!

WHAT WE DON’T KNOW

1) Owner compensation limits – extended to 24/52 of 2019… or remain at 8/52? Waiting for guidance.

2) Will the FTE reduction rule remain in place as-is? It was hard enough for clients to keep average FTE at 100% of their comparison period for 8 weeks, but 24 weeks will render this new “flexibility” useless. Currently, for clients in this situation who cannot use expansion of FTE reduction exemptions or Safe Harbor of 12/31/20, we are encouraging sticking with original 8-week covered period.
(Compass Tax agrees this is the largest remaining concern.)

3) FTE reduction flexibility — the examples I’m seeing are when companies don’t have the same level of activity due to agency standards. But what if you’re “allowed” to open at 100% capacity, but you just don’t have enough business anymore? Currently “too bad” as-written… will this change with SBA interpretation?

4) FTEs – the 1.0 vs 0.5 shortcut calculation… do we still have to calculate this on a weekly basis? I have two colleagues who say you can just count any PT staff who worked at any point during the forgiveness period as 0.5, and similarly for FT, but none of the FTE calculators or case-studies I’ve seen have used this approach. This would make passing the FTE test SO MUCH EASIER.

5) Our clients who (for various reasons) did not apply for PPP beforehand, we had them take the ERTC instead. So now that the forgiveness rules have changed, they want to apply for PPP; but they are disqualified because you can’t do both. Best solutions here? Backing out the credits before filing the 941? Amending the 941?
AICPA response: “If they receive the ERC, they are ineligible for PPP per the CARES act.”

6) EIDL advance grant — subtract from PPP forgiveness or not?
Some folks are saying you have to deduct EIDL advance grant from PPP forgiveness — some say you only do this if you spent it on same costs as PPP.
It looks like on the PPP application you have to deduct it… BUT it says “if applicable”. Since the CARES Act is clear about the fact that it does NOT have to be deducted if taken after April 6 and not used for the same costs, many are saying the “if applicable” means only if pre-April 6th or if used on the same costs as PPP. It sounds like you’re saying that’s not your interpretation, even though it’s in the CARES Act?
AICPA had previously said on their FAQ that we’re waiting for SBA guidance on this. Now they’re saying it has to be subtracted. “If an advance is received, it will reduce PPP forgiveness. If they are used for different purposes, a borrower is able to take loans from both programs but it does not impact the reduction of the advance from the PPP forgiveness.”

The most up-to-date AICPA Summary of the PPP Flexibility Act can be downloaded here.


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.

SBA & Treasury Statement Regarding PPP Flexibility Act – 60% Is Not A Cliff

On June 8th, SBA Administrator Jovita Carranza and U.S. Treasury Secretary Steven T. Mnuchin issued a Joint Statement “Regarding Enactment of the Paycheck Protection Program Flexibility Act”.

They summarized the main points of the Act and clarified a few things that were previously unclear to folks who didn’t read it in full and who missed the accompanying Congressional Statement of Intent. Luckily if you are a regular reader of this blog, you got the news correct first-time around.

(And yes, I am annoyed by old-white-cis-male attorneys telling me that the points I pulled directly from the AICPA Town Hall and their summary were “matters of my opinion”. Anyone who knows me knows I do not take being condescended to well — especially not by lawyers, and especially not by white male lawyers. But I digress.)

But they also made a very important additional point: they eliminated the 60% “cliff” Rubio was worried about, and stated unequivocally, “If a borrower uses less than 60 percent of the loan amount for payroll costs during the forgiveness covered period, the borrower will continue to be eligible for partial loan forgiveness, subject to at least 60 percent of the loan forgiveness amount having been used for payroll costs.”

They also noted that they “will promptly issue rules and guidance, a modified borrower application form, and a modified loan forgiveness application implementing these legislative amendments to the PPP”.

The full text of the statement is located on the Treasury’s website.


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.

Update On PPP Forgiveness Reform – FREE Zoom Recording

I’ve been doing regular 40-minute free zoom sessions for my clients and colleagues for a few months now, mostly centering on questions concerning PPP & EIDL applications and forgiveness.

Today we did one on the recent big changes to the PPP forgiveness program, and many have asked me for the recording, so I decided to make it public — to assist them and others out there in getting the facts (well, at least the ones we know so far).

(You can download the mp4 here if you prefer to watch offline.)

The AICPA has come out with the best summary I’ve seen so far, which is what I chose to use in the zoom session as a reference — so if you don’t have 40 minutes handy, take a quick look at it instead (or in addition):

And of course, the inimitable Tony Nitty has gotten to the core of the issue by pointing out all the stuff we don’t know yet. His excellent analysis can be found at Forbes, as always.

More to come — hopefully soon, as I have many clients whose initial forgiveness period is about to come to a close, and we can only remain in a holding pattern for so long.


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.

PPP Loan Reform Passes Senate – Relief For the Relief Program

Honestly, I’m shocked. (And a little worried — but mostly pleased and shocked.)

When the House passed their extremely generous Paycheck Protection Program reform bill last week (which I affectionately termed “Relief for the Relief Program”), the Senate made it clear there was no way it would clear their chambers: “Multiple members are opposed for different reasons,” GOP Sen. John Thune of South Dakota told CNN on Tuesday, as he suggested that fast-tracking the legislation this week didn’t look likely. Every single pundit, journalist, and even my colleagues at the AICPA said there was no way such a windfall would make it past the Senate. Surprise!

Tonight it passed with an overwhelming majority, and it — mostly — will likely make forgiveness so much easier for small businesses (and the big ones who managed to get the funding despite everything, but that’s old news). We now await its signing between golf outings.

(See this, more recent blog post for a recording of my zoom for clients and colleagues, explaining the changes and answering their questions.)

So what is changing?

  • It will allow borrowers to extend the forgiveness period from eight to 24 weeks (or December 31st, whichever is shorter).
  • It will lower — to 60% from 75% — the minimum portion of the PPP loan that must be spent on payroll. As before, the rest must be spent on rent, utilities and other business-related expenses.
  • It will allow participants in the PPP to also take advantage of the CARES Act option to defer the employer portion of Social Security payroll taxes (previously they were prevented from doing both), with the repayments of 50% due on 12/31/21 & 12/31/22.
  • It will expand the exceptions for employers who are not able to re-hire staff due to COVID-19, and extend the safe harbor rehire date to December 31st.
  • It will extend the repayment period start-date for the non-forgiven portion from six months (the prior rule), to the date when SBA has processed the forgiveness application from the lender — or if the borrower doesn’t apply for forgiveness, then ten months after the last day of the covered period. This also means that you have ten months after the forgiveness period in which to apply for forgiveness.
  • It will extend from two to five years the time new PPP loans must be paid back (with an option for as much as ten) if the amount provided doesn’t convert into a grant. (So far this is only for PPP loans that haven’t been awarded yet, not retroactive to existing loans; but borrowers may work with lenders to amend terms if needed.)

Mostly, this is just amazing. My clients are struggling to jump through all the hoops to spend this money according to the unbelievably complex rules — ones that don’t seem to have much connection to the reality we’re facing right now, especially in the hospitality industry.

So why am I concerned? Because yesterday Marco Rubio said this: “People need to know that the way the Treasury has told us they are going to interpret that bill — if you don’t spend 60% of your money on payroll, if you only spend 59.9%, you will get zero forgiveness.”

MarketWatch reported: “There’s some issues with it that are going to cause people problems, and I just want everybody to know that ahead of time,” Florida’s senior senator also said. “I think still we’re better off passing it than not passing it.”

So of course I am concerned that it sounds like the phase-out of forgiveness that we previously had in the rules is going away. Rubio pointed out that, “procedurally, the problem is if we change the House bill, we’ve got to send it back then,” which is clearly not an option, as this is already “too little, too late”. As it is, I have clients who will not get to use this new relief, as their forgiveness periods end in a few days and they spent all the money based on the old rules — paying staff to do nothing, at a business that is still closed by law.

But for those who can benefit from it, I am thrilled. Now we await signing, and then an inevitably much longer wait for Treasury to issue necessary guidance to answer the many questions this creates.

Please note that several large companies and chains have returned their multi-million-dollar PPP loans, so there is now more than $130 billion available — for eligible nonprofits, companies, and gig workers. So please apply now if you haven’t already!

The full text of the bill is here and the accompanying letter of intent is here — enjoy yourselves.


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.

To Clarify: Yes, You Can Spend More Than 75% of PPP Funds On Payroll

UPDATE: THIS POST IS ALMOST A YEAR OLD AND NO LONGER IS USEFUL INFORMATION.

(Way too many folks are landing on this page and I want to dissuade them from using this as a reference — there have been so many changes to the PPP since this was published. Make sure you restrict any internet searches to posts made in the past month!)


I’m getting this question a lot:

I have someone telling me that they can use all 100% of their PPP for payroll instead of the 75/25 rule of payroll/rent+utilities. Is that correct?

Yes, it is — and yes, you absolutely want to include all of your payroll costs in the forgiveness application calculations!

Some folks are in the situation whereby they have more payroll costs than 75% of the loan will cover. In fact, in some cases, the entire PPP loan — 100% — will be used on payroll costs. And that’s a good thing when it comes to requesting forgiveness, for reasons I’ll explain.

In my firm, for example, I’m paying staff tax-season rates right now, and I have a new employee as of January 2020… but my loan total was calculated based on the average of all of 2019 — so it’s much lower than my actual current payroll costs. I’ll be using 100% of my PPP funds for payroll (and then some). By including all my payroll costs in the forgiveness application and projection calculations, I don’t have to worry about going to the effort of submitting rent/mortgage interest and utilities costs (which are very low for me anyway, as my staff is entirely work-from-home).

But it’s not just a matter of having low overhead and not wanting to spend administrative effort to gather mortgage interest and utilities cost substantiation… it’s more importantly because for forgiveness, we’re all aiming to hit three important tests: the FTE reduction, wage/salary reduction, and 75% of forgiveness hurdles. These are all based on payroll measurements, so it’s best when plugging in your forecasting calculations to first include all the payroll you can… and then just make up the difference with non-payroll costs. The total forgiveness cannot exceed the loan total, so there is no harm in taking this approach.

It is, after all, a Paycheck Protection Program.

Reminder: owners themselves (be they sole proprietors, partners, or shareholder-employees) cannot have more than 8/52 of their 2019 compensation forgiven for PPP purposes, which does mean that for a business owner with no employees, they will not be able to use 100% of the funds for payroll. But for everyone else, yes!


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.

How To Forecast PPP Forgiveness Using The AICPA Spreadsheet Calculator – FREE Zoom Recording

I’ve been doing regular 40-minute free zoom sessions for my clients for a couple months now, mostly centering on questions concerning PPP & EIDL applications and forgiveness.

Today I did a run-through of how to use the AICPA’s great spreadsheet calculator tool to forecast forgiveness for a single S-Corp shareholder with a staff of both hourly and salaried employees. I’ve received a lot of feedback about how helpful it was, so I decided to make the mp4 download available for free on my blog in the hopes that it will assist other CPAs, accountants, bookkeepers, and small business owners. The spreadsheet with sample data that I used in the session is available below. (More on the AICPA tool here.)

A few important points:

1) I have taken six webinars on the new PPP forgiveness rules in the past week — and gotten six different interpretations. They vary widely, on topics such as the EIDL advance subtraction, incurred and-vs-or paid, what an acceptable utility is… as well as some flat-out mistakes (such as including owner compensation in FTE/wage reduction calculations — this is simply not okay). There was even one where the person doing the presenting and the person answering questions in chat were conflicting with each other. So keep in mind that just because someone (including me) sounds confident — this does not mean they are right. They’re just AN expert… there is currently no such thing as THE expert. Just do your best with the information you have — the smartest approach to take is to do whatever you can to make it easy for your banker to just glance at your substantiation and decide it’s sufficient to support your calculations, whatever interpretation you choose.

2) This tool is a DRAFT. For one, there are some small errors in it that I’ve reported to the AICPA; but more importantly — we know this guidance is going to change. In fact, there is pending relief legislation in Congress (to extend the forgiveness period or remove the 75% rule) that may render most of what we’re doing now useless (including the fact that we don’t yet know when we’ll be submitting anything for forgiveness).

However: some folks are more than half-way through their forgiveness period and we have to plan based on the law as it stands now… and hitting the FTE reduction, salary/wage reduction, and 75% of payroll tests is hard. So as a tool for forecasting, as well as establishing your goals and gauging your progress, I encourage you to fill this spreadsheet out to the best of your ability, so you aren’t surprised by a large loan balance at the end of this.

3) Remember, you will only fill out the sections on the application that are highlighted in BLUE. The spreadsheet bases all calculations on that data. Grey fields are calculated, and green are ones that pull from data you entered elsewhere. The instructions aren’t entirely complete, and there are a couple small errors, but it’s still the best tool I’ve found out there (including my own). The spreadsheet formula cells are locked, but you can resize any areas you need to in order to view the full content. Lastly, it seems maybe folks with Macs or using cloud spreadsheet software may have challenges getting their systems to recognize it’s not read-only.

Best of luck, and I’ll try to post other examples for other entity types as time allows.


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.

Long-Awaited SBA Rules For Forgiveness Application

The Small Business Administration gets some kind of perverse joy out of releasing guidance on Friday nights. Last week, it was the new PPP loan application, and this week, it’s the guidance to accompany it.

The Journal of Accountancy did a nice job summarizing each of the new documents on Monday — I definitely recommend reading their brief write-up under the heading “Provisions of note in 2 new interim rules”.

I spent some quality time myself on Sunday going through all 45 pages — it’s actually two sets of guidance, the interim final rule to outline the requirements for loan forgiveness, and the one for loan review procedures and related borrower and lender responsibilities.

Here are my takeaways, with page numbers referenced in each document:

Paycheck Protection Program – Requirements – Loan Forgiveness

  • Accrued interest will be forgiven with the rest of forgiveness (no guidance on interest calculation for partial forgiveness) (page 7)
  • Still no confirmation one way or the other re: EIDL advance subtraction (page 8) — is this only for EIDL advances that meet the characteristics outlined in the CARES Act, or all EIDL grants?
  • Paid OR incurred (not paid AND incurred) — which means unpaid costs from prior periods are in fact eligible (page 9)
  • Supplements to salary/wages are included:
    e.g., bonuses, hazard pay, and additional wages paid to replace tips (except to owners in excess of 2019 income) (page 11)
  • Payroll to furloughed employees is included (page 11)
  • Owners are limited to 8/52 x 2019 compensation (shareholder-employees can also include health insurance and retirement employer contributions, but not Schedule C sole proprietors or partnership partners)
  • Otherwise not limited to 8/52 of costs (except owner payrolls) (page 12-13 utility example)
  • Prepayments are allowed (only mortgage interest specifically excluded) (page 13)
  • FTE reduction exception clarified somewhat (page 13-15)
  • Salary/wage reduction (page 19) appears to take hours-worked into consideration for salaried employees — but heads-up: that is not reflected in the AICPA workbook
  • Similarly, loan forgiveness will not be reduced for exemptions (page 22), but only an FTE solution is offered; I suspect this means that for the wage reduction spreadsheet, only employees working during the 8-week forgiveness period should be included. (I’ll be asking AICPA to clarify this in the instructions.)

    And although not new, I felt they drove home the point that we should make sure to maintain written records of any employees who voluntarily resigned. This will be part of the documentation when substantiating the forgiveness application.

Paycheck Protection Program – SBA Loan Review Procedures and Related Borrower and Lender Responsibilities

  • There will be an opportunity to respond to SBA questions regarding loan forgiveness substantiation before a decision is made (page 9)
  • There will be an appeal process if eligibility is denied by SBA (page 10)
  • The lender will have to review but not audit (independently verify) all documentation and calculations supplied by the borrower, before submitting to SBA
  • The lender may rely on third-party payroll processor records (not required to review source data unless these records are not available) (page 11)
  • Lenders may rely on borrower representations, but must confirm calculations and substantiation (page 12)
  • No date yet by which forgiveness application is due – but bank then has 60 days to submit to SBA and SBA has 90 days to respond (page 12)
    …so it could easily be well over 5 months before you find out whether you got forgiveness.

In summary, I’d say some of these were already clear from the forgiveness application but they finally put it in writing; and some actually confirmed something I could only guess at before; but a few examples actually drove home some important new — or previously vague — points; others were just confirmation that we still don’t know some things, such as the all-important EIDL question.

For a more in-depth walk through the PPP loan forgiveness application, please see Tony Nitti’s excellent line-by-line deep dive — and the AICPA’s spreadsheet calculator. Or if you’re a sole proprietor/ independent contractor/ gig worker who files a Schedule C, then skip the in-depth stuff and follow along with Brian Thompson’s short article instead.


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.

PPP Forgiveness Application Calculator Spreadsheet

UPDATE: AICPA has partnered with a Fintech lender to create an online version of their forgiveness tool — www.PPPForgivenessTool.com — available free of charge. More on the project here. The spreadsheet below still works, and I personally prefer it, but the online tool is easier to use if you don’t already have background into how the PPP rules work.


My husband and I have collectively spent nearly 18 hours preparing, updating, editing and testing our PPP Forgiveness spreadsheet, as well as comparing it with colleagues’ versions… only to be stymied at every last moment — each time we were ready to “go live” with it, some new guidance, analysis or interpretation was released that had us going back to the drawing board. At this point I’m joking with my clients that it’s a mythical creation.

And it might have to stay that way — the AICPA has done such an incredible job with their version that I’m not sure we can do any better.

It’s not pretty, and it’s a bit clunky, and there’s no budget tool or FTE calculator included — but the logic is sound and it does a lot of the calculations for you. And they’ve made it public! Just scroll down to where it says “PPP loan forgiveness calculator“.

CPA Practice Advisor notes, “As the AICPA has emphasized throughout this process, questions surrounding guidance make critical decisions unnecessarily challenging and complex for PPP loan recipients and those who are considering applying for the program.” They created a loan forgiveness calculator last week that reflected both the latest SBA guidance and additional AICPA recommendations, and presented it to Treasury. Unfortunately that was not the version that became the final application (released this past Friday night).

“The AICPA loan forgiveness calculator provided more support and details than the SBA loan forgiveness application, and we will continue to encourage Treasury and SBA to leverage our recommendations,” said their VP of Firm Services.

So they reconciled their previous version with the forgiveness application, released it to the public — and you should use it.


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.