Key Assignment DraftScenarioIt is time for the staff account

Key Assignment DraftScenarioIt is time for the staff accountants to begin preparing daily accounting transactions. In preparation for the upcoming audit, the accountants must ensure that these transactions are correct and are free from any misstatement. Because this is a new subsidiary of the company, there are no beginning balances. As a staff accountant, your job is to do the following:Prepare the 10 transactions below by posting to the general journal. You should use an Excel spreadsheet to accomplish this task.Post the general journal entries to the general ledger in the Excel spreadsheet.Prepare a trial balance from the ending balances on the ledger. You should also use an Excel file for the trial balance. Transactions Invested $50,000 in the businessPaid $100 for phone servicePurchased $35,000 equipment on creditPaid $3,000 for 3 months rentPaid $5,500 for 6 months of insurance Paid $1,000 for advertising on credit (Note: This is an expense to the company)Customer purchased $2,000 on accountCustomer in #7 paid $1,000 on accountPaid for #6 advertisingSold to customer and received $5,000 cash Click here for the General Journal Ledger template.Please submit your assignment.