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.