Please use word or excel to make the answer clear . Thank you very much!

Transactions related to revenue and cash receipts completed by Sterling Engineering Services during the period November 230, 2010, are as follows: Nov. 2. Issued Invoice No. 717 to Yee Co., $810. 3. Received cash from AGI Co. for the balance owed on its account. 7. Issued Invoice No. 718 to Phoenix Development Co., $400. 10. Issued Invoice No. 719 to Ridge Communities, $1,940. Post revenue and collections to the accounts receivable subsidiary ledger. 14. Received cash from Phoenix Development Co. for the balance owed on November 1 16. Issued Invoice No. 720 to Phoenix Development Co., $275. Post revenue and collections to the accounts receivable subsidiary ledger. 19. Received cash from Yee Co. for the balance due on invoice of November 2. 20. Received cash from Phoenix Development Co. for invoice of November 7. 23. Issued Invoice No. 721 to AGI Co., $670. 30. Recorded cash fees earned, $3,400. 30. Received office equipment of $1,500 in partial settlement of balance due on the Ridge Communities account. Post revenue and collections to the accounts receivable subsidiary ledger. Instructions 1. Insert the following balances in the general ledger as of November 1: 11 Cash 12 Accounts Receivable 18 Office Equipment 41 Fees Earned $17.240 2020 31,500 2. Insert the following balances in the accounts receivable subsidiary ledger as of November 1: AGI Co. Phoenix Development Co. Ridge Communities Yee Co. $1,340 680 3. Prepare a single-column revenue journal and a cash receipts journal. Use the fol- lowing column headings for the cash receipts journal: Fees Earned Cr., Accounts Receivable Cr., and Cash Dr. The Fees Earned column is used to record cash fees. Insert a check mark () in the Post. Ref. column. 4. Using the two special journals and the two-column general journal, journalize the transactions for November. Post to the accounts receivable subsidiary ledger, and insert the balances at the points indicated in the narrative of transactions. Determine the balance in the customer's account before recording a cash receipt. 5. Total each of the columns of the special journals, and post the individual entries and totals to the general ledger. Insert account balances after the last posting. 6. Determine that the subsidiary ledger agrees with the controlling account in the gen- eral ledger