177x Filetype XLSX File size 0.07 MB Source: www.aafcpa.com
Sheet 1: 8 - Weeks
* Eligible to choose 8-weeks ONLY if loan application processed PRIOR to June 5, 2020 | ||||||||||
ELIGIBLE COST TRACKING - COSTS INCURRED FOR DEFINED 8 WEEK PERIOD*** | ||||||||||
Defined Period*** | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 | Total Costs Allocated | |
DATE | DATE | DATE | DATE | DATE | DATE | DATE | DATE | |||
Eligible Payroll Costs | ||||||||||
Wages, including PTO/Sick Pay and Leave Pay | - | |||||||||
Less: Non-US Based Employees (enter negative) | - | |||||||||
Less: FFCRA Credits Taken against employee wages included above (enter negative) | - | |||||||||
Subtotal Wages before Limit | - | - | - | - | - | - | - | - | - | - |
Less: Wages, PTO/Sick Pay and Leave Pay included in Subtotal line in excess of $15,385 per employee (enter negative)^^ | - | |||||||||
Subtotal Eligible Wages | - | - | - | - | - | - | - | - | - | - |
Group Health Insurance (Employer) | - | |||||||||
403(b) or Other Retirement (Employer) | - | |||||||||
State and Local Taxes (Employer) | - | |||||||||
Eligible Payroll Costs - Subtotal | - | - | - | - | - | - | - | - | - | - |
Eligible NonPayroll Costs | ||||||||||
Mortgage Interest** | - | |||||||||
Rent** | - | |||||||||
Utilities* - Electric | - | |||||||||
Utilities* - Gas | - | |||||||||
Utilities* - Water | - | |||||||||
Utilities* - Transportation | - | |||||||||
Utilities* - Phone & Internet | - | |||||||||
Other | - | |||||||||
Eligible NonPayroll Costs - Subtotal | - | - | - | - | - | - | - | - | - | - |
GRAND TOTAL | - | - | - | - | - | - | - | - | - | |
*Utilities include: electricity, gas, water, and phone and Internet access for service incurred in the ordinary course of business for contracts beginning prior to February 15, 2020. | ||||||||||
**Mortgage and rent agreements must have been in place as of 2/15/2020 to qualify and include real and personal property. No prepayments on rent or mortgages are considered eligible costs. | ||||||||||
*** Defined period as follows: | ||||||||||
Covered Period: | 8 weeks or 56 days beginning on the date of receipt of loan proceeds. Can be used for Payroll and NonPayroll Costs. | |||||||||
Alternative Payroll Covered Period: | 8 weeks or 56 days beginning on the first day of the pay period after the receipt of the loan proceeds. Can be used only for Payroll Costs. | |||||||||
^^Limit of $15,385 should be calculated on an individual employee basis and should not be aggregated. Limit applies to Wages, PTO/Sick Pay, Leave, Tips, Commissions and other | ||||||||||
compensation reported in Box 1 of Form W-2. | ||||||||||
Backup documentation of costs listed above may be requested and may include cancelled checks, payment receipts, transcripts of accounts, or other documents verifying payments on covered | ||||||||||
mortgage obligations, payments on covered lease obligations, and covered utility payments. | ||||||||||
Disclaimer: The contents of this resource are for general informational purposes only. While every effort has been made to ensure its accuracy, the information is provided “as is” and no representations are made that the content is error-free. The contents are based on current guidance and interpretation. We have no obligation to update any content, comments or other information for retroactive or prospective interpretations or guidance provided by regulators, financial institutions or others. The information is not intended to constitute legal or accounting advice or replace the advice of a qualified professional. There are areas of the CARES Act where additional clarification from the Treasury Department and the SBA is needed. Your judgment and interpretation of the act may be needed. Users should consult with their legal counsel and representatives of the lending institution regarding the proper completion of their application and supporting documentation. | ||||||||||
To learn more visit www.aafcpa.com/loan-costs-tracking | ||||||||||
Copyright AAFCPAs 2020 |
no reviews yet
Please Login to review.