Question: For your convenience to complete reports in Chapter 1 0 and Exercises 1 0 , an Excel Template is provided with your text to organize

For your convenience to complete reports in Chapter 10 and Exercises 10, an Excel Template is provided with your text to organize your Excel reports. If you have not already downloaded the Excel Template, to access it, you have two options: If you are using Connect with your text, the Excel Template can be downloaded from within Connect. If you are not using Connect, go to www.my-quickbooksonline.com > select QBO 4e > QBO 4e Excel Templates > Download the Chapter 10 Excel Template. After downloading the Excel Template, select the Instructions sheet in the Excel Template to view the steps to copy your exported Excel reports to the Excel Template Required: Trial Balance Totals. What is the amount of Total Debits on the Trial Balance?What is the amount of Total Credits on the Trial Balance? What is the balance in the Checking account? Note: Answer this question in the table shown below. Round your answer 2 decimal places. What is the balance of the Money Market account? Note: Answer this question in the table shown below. Round your answer 2 decimal places. What is the balance of the Accounts Receivable account? Note: Answer this question in the table shown below. Round your answer 2 decimal places. What is the balance of the Prepaid Expenses: Supplies account? Note: Answer this question in the table shown below. Round your answer 2 decimal places. What is the balance of the Prepaid Expenses: Insurance account? Note: Answer this question in the table shown below. Round your answer 2 decimal places. What is the balance of the Prepaid Expenses: Rent account? Note: Answer this question in the table shown below. Round your answer 2 decimal places. What is the balance of the Accounts Payable account? Note: Answer this question in the table shown below. Round your answer 2 decimal places. What is the balance of the VISA Credit Card account? Note: Answer this question in the table shown below. Round your answer 2 decimal places. What is the balance of the Interest Payable account? Note: Answer this question in the table shown below. Round your answer 2 decimal places. What is the balance of the Unearned Revenue account? Note: Answer this question in the table shown below. Round your answer 2 decimal places. What is the balance of the Insurance Expense: Renter Insurance Expense account? Note: Answer this question in the table shown below. Round your answer 2 decimal places. What is the balance of the Insurance Expense: Liability Insurance Expense account? Note: Answer this question in the table shown below. Round your answer 2 decimal places. What is the balance of the Interest Expense account? Note: Answer this question in the table shown below. Round your answer 2 decimal places. What is the balance of the Office Supplies & Software account? Note: Answer this question in the table shown below. Round your answer 2 decimal places. What is the balance of the Rent Expense account? Note: Answer this question in the table shown below. Round your answer 2 decimal places. What is the balance of the Utilities Expense account? Note: Answer this question in the table shown below. Round your answer 2 decimal places. \begin{tabular}{|l|l|}\hline 4a. Total Debits on the Trial Balance & \\\hline 4b. Total Credits on the Trial Balance & \\\hline 5. Balance in the Checking account & \$ 51,070.30\\\hline 6. Balance of the Money Market account & \$ 20,000.00\\\hline 7. balance of the Accounts Receivable account & \$ 7,301.32\\\hline 8. Balance of the Prepaid Expenses: Supplies account & \$ 300.00\\\hline 9. Balance of the Prepaid Expenses: Insurance account & \$ 400.00\\\hline 10. Balance of the Prepaid Expenses: Rent account & \$ 1,500.00\\\hline 11. Balance of the Accounts Payable account & \$ 2,176.00\\\hline 12. Balance of the VISA Credit Card account & \$ 2,548.00\\\hline 13. Balance of the Interest Payable account & \$ 10.00\\\hline 14. Balance of the Unearned Revenue account & \$ 4,500.00\\\hline 15. Balance of the Insurance Expense: Renter Insurance Expense account & \$ 36.00\\\hline 16. Balance of the Insurance Expense: Liability Insurance Expense account & \$ 200.00\\\hline 17. Balance of the Interest Expense account & \$ 10.00\\\hline 18. Balance of the Office Supplies \& Software account & \$ 1,139.50\\\hline 19. Balance of the Rent Expense account & \$ 1,140.00\\\hline 20 Ralanc.e of the Ittilities Fxnense acr.nunt & \$ 77000\\\hline \end{tabular}
For your convenience to complete reports in

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!