![]() Use the gross wages paid to your team members (including yourself if you take a paycheck).Ĭommissions are again self explanatory. Salary and wages are pretty self explanatory. Some general thoughts on expense categories, based on my reading of the guidance from Treasury and a couple of accountant websites. Begin entering your eligible expenses! I’ve broken the categories into broad sub-categories based on the PPP guidelines published by Treasury, and included a line for each date in the eight week measurement period, since you most likely pay various expenses on different days of the month. ![]() The spreadsheet will calculate your average number of FTEs during the eight week measurement period. If you employ part time employees, it is possible this number could half a half FTE (i.e., 3.5). Calculate your average FTEs by averaging the number of FTE employees for each pay period in the look-back period. Enter your average number of full-time-equivalent employees (FTEs) for the period Januthrough Februin the “Avg FTEs 1/1 to 2/29” field.This (hopefully) will change, but at the moment, you have 56 days from disbursement to allocate the funds. Current guidelines are that you have eight weeks to accumulate the amounts used to calculate the forgiveness component of your loan. Enter the date the funds hit your account in the “Date funds disbursed” field.This should be your total/net PPP disbursement. Enter the total amount of your PPP loan in the “PPP Loan Amount” field.The amounts you need to enter are shaded in green. I say “may” because the final rules on forgiveness aren’t published yet, so the spreadsheet is based on my current research and published guidance so far. I’ve put together an Excel spreadsheet to help in calculating the amount of a PPP loan that may be forgiven. Hopefully, you’ve managed to have your PPP application approved and the funds have been disbursed.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |