With one week left before year-end, it’s possible that you are among the folks who received an email (below) back in October but hasn’t yet reported to the SBA on the eligible expenses incurred so far. This blog post (with a 20-min video walking you through the whole process) is our suggestion of how to translate the info you already have in QuickBooks into a format that will easily conform to the Restaurant Revitalization Award Portal requirements.

Spoiler alert: the process takes more than 5 minutes. It can easily take an hour or more. The actual entering of data into the SBA RRF portal is the part that only takes 5 or so minutes.

Our recommendation is to download the free Restaurant Revitalization Fund Tracker from the American Institute of CPAs (AICPA) website (like their PPP Forgiveness Calculator, you do have to register for an account, but there’s no charge). However, instead of entering each individual transaction on the form (as it’s designed for you to do), our suggested shortcut is to take the information you already have in your QuickBooks file and enter each category as one line — then subtract all the non-RRF grants and assistance received, so that you’re not double-dipping.

The RRF period runs from February 15, 2020 — the very beginning of the pandemic — to March 11, 2023. The year-end reporting is just a progress report of what you’ve spent so far that is eligible for RRF program fund allocation. So we suggest you run a Profit & Loss for your company for the period of February 15, 2020 all the way through November 30, 2021 (or whatever your most recently reconciled month-end is), and use those numbers to report what has been spent so far. Then enter the non-RRF grant funds as negative numbers on the same Expense Tracker tab, so that they net against each other. The result will be the data you submit to the SBA at restaurants.sba.gov once you log in to your portal.

I’ve recorded a video illustrating the whole process — but in case you want a follow-along checklist, here it is:

Step 1 – download the AICPA RRF Tracking Tool
Step 2 – enter the name of your company in the Summary tab, cell A9
Step 3 – enter the RRF amount in the Expense Tracker tab, cell C6
Step 4 – run your Profit & Loss from 2/15/2020-11/20/2021
Step 5 – export to Excel and save to your RRF file folder
Step 6 – on the Expense Tracker tab, enter summary amounts from the Profit & Loss for Payroll, Rent, Utilities, Food & Beverage, Maintenance, Supplies, Covered Supplier Costs, and Business Operations Expenses

Tip: for now, skip Mortgage Payments, Debt Service, Outdoor Seating Construction, and Depreciation, or ask your accountant for help with these, as they are usually on the Balance Sheet or in the Non-Operating Expense section of the Profit & Loss, and are therefore harder to DIY.

Tip: Business Operations Expenses are all operating expenses that are not already accounted for in one of the other categories.

Step 7 – IMPORTANT: enter all the non-RRF grants and financial assistance as negative amounts on the Expense Tracker tab — this is to prevent any double-dipping
Step 8 – go to restaurants.sba.gov and log in
Step 9 – enter your name, address, EIN, phone, and email (if this information is not already there)
Step 10 – enter the amounts from the Summary tab — Note: you cannot enter more than the total RRF grant, so you may need to reduce one or more of the categories so that you don’t exceed the total.
Step 11 – if you have allocated all the RRF funds, certify as such — you will not be required to repeat this progress report next year; if you have not allocated all the RRF funds, you will be able to “Save” but not “Submit”.

If you have not allocated all the funds yet, then follow this same process next year by December 31, 2022 — you can run the Profit & Loss from 12/1/2021-11/30/2022 at that point and follow the same approach. Most folks will have sufficient eligible expenses from 2/15/2020-11/30/2021 to “use up” the whole RRF grant, but after subtracting other grant income from expenses, may find that they still have a balance left over that they can allocate costs to when reporting at the end of 2022.

You have until March 11, 2023 to allocate all the funds (aka spend them on operating expenses, and until April 30, 2023 for final reporting. If it turns out you didn’t have enough eligible expenses from 2/15/20-11/30/21 using Profit & Loss Operating Expenses, then take some time to work with your accountant to determine if you have debt service, mortgage payments, capital expenses for outdoor seating, or depreciation that counts. You can report these in next year’s RRF Program Post-Award Report, along with next year’s Profit & Loss Operating Expenses. In all cases: make sure to subtract all other grant income from expenses so you are not double-dipping!

---