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.