\

Develop a trial balance worksheet for July 31 and August 31

The general ledger of Jay Consulting shows the following balances at July 31 Cash Accounts receivable Prepaid rent Accounts payable Salaries payable Jay Blue, capital Jay Blue, drawing Consulting fees Rent expense Salary expense Supplies expense Utilities expense Miscellaneous expense $4,440 5,780 1,200 2,850 475 7,486 2,000 6,920 600 2,600 755 196 160 Jay has asked you to develop a worksheet that will serve as a trial balance (file name PTB). Use the data provided as input for your model. Review the Model-Building Problem Checklist on page 154 to ensure that your worksheet is complete. Print the worksheet when done. Check figure: Total debits, $17,731 To test your model, use the following balances at August 31 Cash Accounts receivable Prepaid rent Accounts payable Salaries payable Jay Blue, capital Jay Blue, drawing Consulting fees Rent expense Salary expense Supplies expense Utilities expense Miscellaneous expense $7,527 4,287 600 1,495 400 8,095 1,800 8,820 600 2,800 950 221 25 Print the worksheet when done. Check figure: Total debits, $18,810