37 To store the trial balance data and provide mapping to the financial statement Balance Sheet ASSETS Cash Prepaids Accounts Receivable Trial Balance Account rs Label Balance Checking Cash 14,221 Savings Cash 57503 Money Market Cash 39.550 Prepaid Rent Propa 4,500 Fixed Assets AR Accounts Receivabl 79,018 At Allowance Accounts Receivabl -5,000 Machinery Faed Assets 120,558 Equipment Fixed Assets 78,222 Automobiles Fixed Assets 65,981 Total As UANUITIES & EQUITY Accounts Payable AP Accounts Payable 57,003 Debt Loans Payable Debt 20,000 Equity Equity 377,549 Total Liabilities Creating Race Sheet from a Tra Data Validation total Punchin Setup Data Vadation byggingus CC21 and ch Validation as the Data Times on Your guts for this di ES Label Categories Cash Prepaids Accounts Receivable Fixed Assets Accounts Payable Debt Equity Equity Total Liabilities & Equity Step 2 tace Pie Chart Here in of the FS Labels in column Cby thoosing the correct ca Account Step in Cell H10 enter a SUMIFS formula that will Sum the values in th If the FS Label is equal to the Balance Sheet account type in colum format of the SUMS function SUMIF(sum range, criteria rangel, criterial, criteria_range Where Sum range would be the numbers in column D, the criter would be the labels in column C and criterial would be G10 when Cash appears Repeat this SUMIFS formula for all accounts in the Step 4 Use the Subtotal function to get the Total Assets, Total Liabilite Liabilities and Equity. The format of the Subtotal function is SUBTOTAL(function_num,reft,ref2 Where function num in this case is 9 for Sum and refi would