Sheet 1: CARES LOAN

	
	
	
	
	
	
	
	
	
	
	
	
	

		
CARES LOAN TRACKER
		


		


		


		
Total Loan Amount
		


		


		


		
% of Loan mandated to Payroll (60% of total loan)
		


		


		


		
 $-   
	
	

		


		


		


		


		


		


		


		


		
% of Loan allowed for non-payroll (40% of total loan)
		


		


		


		
 $-   
	
	

		


		
Click into cell, then use dropdown arrow on right side of your cell (not the one on the black header)
		


		


		


		


		
( Utilize the "Tab" key from this column to add a new line)
		


		


		


		


		


		


	
	

		
Date
		
Expense Type:
		
Payable to:
		
If Payroll, run date?
		
If non payroll, define.
		
Amount
		
Loan Balance
		


		


		


		


		


		


	
	

		
4/1/2020
		
Payroll
		
staff
		


		


		


		
 $-   
		


		


		


		


		


		


	
	

		


		


		


		


		


		


		
 $-   
		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		
Remaining Payroll
		


		
 $-   
		


	
	

		


		


		


		


		


		


		


		


		


		
Remaining NonPayroll
		


		
 $-   
		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		
Current Payroll %
		


		
#DIV/0!
		


	
	

		


		


		


		


		


		


		


		


		


		
Current NonPayroll %
		


		
#DIV/0!