Accounting transactions asking for journal entries, ledger, trial balance, adjusted trial balance, post closing trial balance, income statement, owners equity statement, and balance sheet

AutoSave OSearch File Formulas Review View Help Home Insert Page Layout Data (iPROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing PZ M A B F G H J K 1 John Smith has been working part time as a business consultant for several years. 2 He had acquired several clients and decided to go into the business full time. 3 He created a company called Mile High Consulting on June 1, 2018. 4 The following transactons occurred during June. 1-Jun The following assets were put into the Company; cash, $20,000, 6 |accounts receivable, $14,700, supplies, $3,300, and office equipment, $12,000. 7 1-Jun Prepaid three months rent for a rental office, $6,000. 2-Jun Paid the one year premium on property and casualty insurance policies, $4,200. 10 4-Jun Received $9,400 cash from clients as advanced payments for services to be performed later 11 5-Jun Purchased additional office equipment on account from Office Depot, $8,000. 12 6-Jun Received cash from clients on their accounts, $11,700 13 10-Jun Paid cash for a newspaper advertisement, $350. 14 12-Jun Paid Office Depot a portion of the account owed, $6,400 15 12-Jun Provided services on account for clients, $21,900. 8 9 16 14-Jun Paid the receptionist salary for two weeks, $1,650. 17 17-Jun Received cash from clients for services provided, $6,600. 18 18-Jun Paid cash for additional supplies, $725 19 20-Jun Provided services on account for clients, $16,800. 20 24-Jun Received cash from clients for services provided, $4,450. 21 26-Jun Received cash from clients on their accounts, $26,500 22 27-Jun Paid the receptionist salary for two weeks, $1,650. 23 29-Jun Paid the telephone bill for June, $540. 24 30-Jun Paid the utlilites bill for June, $760. 25 30-Jun Received cash from clients for services provided, $5,160. 26 30-Jun Provided services on account for clients, $2,590 27 30-Jun John Smith withdrew $18,000 for his personal use. 28 29 At the end of the month, the following adjustments were required. Insurance expired during June is $350. 30 . Supplies on hand on June 30th are $1,225. b. 31 Depreciation on the office equipment for June is $400. 32 C. The receptionist is owed $275 salary to be paid next week. 33 Rent expired during June is $2,000. Unearned Fees on June 30th are $2,350. 34 e. f. 35 36 Post Closing Trial B Chart of Accounts Transactions Journal Ledger Trial Balance Adjusted Trial Balance a