jagomart
digital resources
picture1_Loan Tracking Spreadsheet Template 46336 | Loan Costs Tracking Spreadsheet Aafcpas Template 2020


 177x       Filetype XLSX       File size 0.07 MB       Source: www.aafcpa.com


File: Loan Tracking Spreadsheet Template 46336 | Loan Costs Tracking Spreadsheet Aafcpas Template 2020
sheet 1 8 weeks eligible to choose 8weeks only if loan application processed prior to june 5 2020 eligible cost tracking costs incurred for defined 8 week period defined period ...

icon picture XLSX Filetype Excel XLSX | Posted on 18 Aug 2022 | 3 years ago
Partial file snippet.
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










The words contained in this file might help you see if this file matches what you are looking for:

...Sheet weeks eligible to choose only if loan application processed prior june cost tracking costs incurred for defined week period total allocated date payroll wages including ptosick pay and leave less nonus based employees enter negative ffcra credits taken against employee included above subtotal before limit in line excess of per group health insurance employer b or other retirement state local taxes nonpayroll mortgage interest rent utilities electric gas water transportation phone amp internet grand include electricity access service the ordinary course business contracts beginning february agreements must have been place as qualify real personal property no prepayments on mortgages are considered follows covered days receipt proceeds can be used alternative first day after should calculated an individual basis not aggregated applies tips commissions compensation reported box form w backup documentation listed may requested cancelled checks payment receipts transcripts accounts do...

no reviews yet
Please Login to review.