i cannot get the worksheet to balance.

- The unit of measure for this business is the US $. - Source documents for Nothan' Eut Netore as follows: - You hejped Trish set up the chart of accounts fo copy of which is provided in the accompanying working papers). Why would Trish have two different revenue accounts? Why does the journal have a special column for each of the revenue accounts? Let's get started! In addition to this booklet, be sure that you have the following materials to complete this simulation: Journal General Ledger Additional Working Papers Instructions \& Transactions 1. The following transactions are for the month of March, 20xX. Begin with page 1 of the Journal. March 1 F1 Trish opened a checking account in the name of the business, depositing $12,000.00,R1. \#2 Owner made the $3,200.00 computer an asset of the business, R2. March 2 13 Paid Office Warehouse cash for supplies, $800.00,Cl. \$4. Paid cash for 12 -month insurance policy, 51,200,00,C2. mmily=titil What types of insurance coverage might a business like this require? \$12 Trish withdrew $1,000.00 out of the business for personal use, C6. \#13 Trish paid $110,00 to a local print shop for business cards (Miscellaneous Expense), C7. 614 Pald Office Warehouse $600.00 on account, C8. A15 Recelved $1,900.00 for design work completed, 83. March 12 \#6 Recelved payment from VMS Records, $8,500,00, R4. 117 Established a $300.00 petty cash fund, C9. 118 Trish withdrew $800.00 out of the business for personal use, C10. \#19 Bilied Dooley Real Estate for Web site design work completed, \$1,200.00, 52 . 120 Paid Ofince Warehouse the balance owed, C11. Whamithis How much is owed to Office Warehouse? 2. Total page 1 of the Journal. 3. Using the appropriate form provided in your working papers, prove and rule page 1 of the Journal, Carry the totals forward to page 2. 4. Post the appropriate individual items from page 1 of the Journal. March 18 \#31 Trish charged a $98.00 repair at Gas-n-Go Miscellaneous Expense), M4. \$32 Submitted design work to VMS Records and bilied them 5400.00,53. \$33 Paid cash for a case of printer toner at Office Warehouse, $334.00,C18. March 19 934 Paid the cell phone bill for the business (Utilities Expense), S132.00, C19. 135 Paid for special phone messaging services (Utilities Expense), 577.00,C20. March 22 \#36 Recelved payment from VMS Records, $400.00,R7. $37 Paid \$192.00 to insurance Associates, inc, for monthly equipment coverage. (Note: This is monthly, not prepaid), C21. -38 Paid $220.00 for an ad in a local entertainment periodical, C22. 339 Paid Gas-n-Go $146.00 on account, C23. $40 Paid $825,00 to rent special equipment, C24. 6. Total page 2 of the Journal. 2. Using the appropriate form provided in your working papers, prove and rule page 2 of the Journal. Carry the totals forward to page 3. 8. Post the appropriate indlvidual items from page 2 of the Journal. 9. Continue to journalize the transactions for the period using page 3 of the Joumal. March 23 \$41 Bought computer suppilies at Office Warehouse on account \$435.00, M5. $42 James Riley, Esq. bliled Trish for iegal expenses, $250.00,M6, $43 Received \$5,500.00 from Runway Magazine for Web site design work, R8. 144 Paid $1,225.00 for travel expenses, C25. March 24 \$45 Submitted design work to VMS Records and billed them S1, 100.00, S4. $46 Paid $120.00 for printing services (Miscellaneous Expense), C26. \#47 Recelved $500.00 from various clients for maintenance work, T24. March 29 148 Recelved $1,100,00 from various cllents for maintenance work, 729 $49 Traveled to San Francisco for a conference and paid $3,200.00 for expenses, C27. 350 Paid Office Warehouse $300.00 on account, C28, F51 Pald $250.00 owed to James Riley, Esq. C29. 552. Pald monthly heaith in March 30 153 Recelved payment from Dooley Real Estate, 51,200.00, R9. 10. Trish recelved the bank statement dated March 26. Using the appropriate bank reconclliation form provid in your packet, reconcile the account referring to the following information: - Checks still outstanding $24,27,828,29,$30. - Deposit of \$1,100.00 on Mareh 29 did not appear on the bank statement. - Checkbookregister shows a balance of $18,403.00. - Bank stotement balance of $22,513.00. - Service charge of 510.00 . - ATM fees of $5.00. 11. Continue to Journalize the rest of the transactions on page 3 of the Journal. \#54 After completing the reconciliation of the bank account, recognize the \$15.00 service charges and fees (Miscellaneous Expense), M7. \#55 Provided an estimate for Big Apple Enterprises for Web site design. fisizctitip Describe how you handled this transaction and why. \#56 Replenished the petty cash fund, $276.00 (Postage (Misc), \$96.00, Supplies, \$180.00), C31. March 31 \$57. Paid S145.00 for the office electric bill for the month, C32. $58 Paid $1,250.00 for internet fees expense, C33. 459 Trish withdrew $3,500.00 out of the business for personal use, C34. \#60 Trish billed the Peach Pit for design work completed, s1,500.00, S5. 12. Total page 3 of the Journal. 13. Using the appropriate form provided in your working papers, prove and rule page 3 of the Journal. 14. Post the appropriate individual items from page 3 of the Journal. 15. Post the appropriate column totals of the Journal. 16. Using the appropriate form provided in your working papers, prove cash. Checkbook balance equals $13,217.00. 12. Prepare a trial balance on the worksheet. End-of-period date is March 31, 20xx. The following end-ofperiod information applies to adjustments: - The unexpired insurance value is $1,100.00. - The supplles inventory end-of-period value is $618,00. 18. Complete the worksheet. 19. Once you have completed the worksheet and have calculated the net income, prepare the following using the forms provided in your packet: 19. Once you have completed the worksheet and have calculated the net income, prepare the follo using the forms provided in your packet - Income stotement (calculate component percentages for reventie, expenses, and net income rot calculations to the nearest. 1% ). Bolance Sheet. 20. Journalize and post adjusting entries (use page 4 of the Journal). 21. Complete the closing process for the period: - Journalize and post closing entries. 22. Prepare a post-closing trial balance. tralye this What percent of sales were the operating expenses for the business? What was the profit margin for the business? How are these percent measurements useful for evaluating the performance of the business? Finishing the Job Once you finish, make sure to hand in the following completed materials: General Ledger - packet PDF or Google Sheet: Journal Joumal Proofs -debits = credits Cash Proof Additional Working Papers