Accounting Cycle Project (version 1) - AutoRecovered. Formulas Data Review View Help General A Inse Merge & Center - $ - %8 w Conditional Format as Cell Formatting Table Styles Styles Alignment Number e a client for $24,000 of work performed in July. The invoice will be paid on the 20th of next month. A B Connie's Consulting July 2019 Transactions Description of the Transaction Date July 1 Borrow $35,000 from 1st Bank by signing a 24 month note. Invest $65,900 cash into the business. July 1 July 1 Purchase $34,500 of new computer equipment, paying cash. July 1 Pay $500 cash for the July office rental. July 3 Invoice a new customer $3,450 for a completed job-customer will pay in 10 days. July 5 Take a withdrawal of $26,000 cash. July 10 Complete a job for a new customer-customer pays $1,315 cash for the job. July 12 Collect $3,500 cash for a special rush job completed on May 31. Transactions Chart of Accounts General Journal General Journal p2 General Accounting Cycle Project (version 1) - AutoRecovered e sourch ut Formulas Data Review View Help General Insert D Number - ' ' 25 Wrap Text A Conditional Format as $ -%88- Cell Merge & Center Formatting Table Styles Alignment Styles nvoice a client for $24,000 of work performed in July. The invoice will be paid on the 20th of next month. B July 14 Pay the employees $11,500 for work performed during the first 2 weeks of 22 July 23 July 15 Purchase $880 of supplies. The supplies are consumed immediately. Connie's will pay for the supplies in about 2 weeks. D 24 25 July 15 Collect $3,450 on account. The cash that is received is from the new customer for the job that was completed on July 3. 26 27 July 17 28 One of the original computers purchased in January of 2018 needed repair. The cost of the repair is $915. Connie's will pay for the service in 30 days. Purchase for cash $31,000 of supplies. These supplies will be consumed over the next 12 months July 19 0 2 July 20 Collect $30,000 for work performed and invoiced in June. July 23 Receive an advance payment of $21,750 for consulting work to be performed from August 1, 2019 to January 31, 2020. Complete a consulting job; the total price for the work is $7,250. The customer pays $1,000 cash on this date and will pay the remainder on August 25. Transactions Chart of Accounts General Journal General Journal p2 General Ledger July 25 Accounting Cycle Project (version 1) - AutoRecovered Formulas Data Review View Help General ' ' -A- 23 Wrap Text Merge & Center $ -% 8398 Ins Conditional Format as Cell Formatting Table Styles Styles Alignment Number voice a client for $24,000 of work performed in July. The invoice will be paid on the 20th of next month. A D B July 25 Complete a consulting job; the total price for the work is $7,250. The customer pays $1,000 cash on this date and will pay the remainder on August 25. 36 37 38 39 40 July 27 Pay $880 cash for the supplies purchased on July 15. Pay the employees $10,150 for work performed for the last 2 weeks of July. July 28 July 31 Invoice a client for $24,000 of work performed in July. The invoice will be paid on the 20th of next month. 42 43 45 46 47 18 9 Additional Information Equipment: The $48,000 beginning balance in the Equipment account relates to equipment which was purchased on January 2, 2018. At that time, Connie's estimated: the equipment would last for four years (48 months) - at the end of the four years, the equipment would have no future value and would be scrapped 50 51 2 The following information relates to the new equipment which was purchased on July 1, 2019 Transactions Chart of Accounts General Journal General Journal p2 General Ledg e . Accounting Cycle Project (version 1) - AutoRecovered Formulas Data Review View Help A General 3 Wap Text Merge & Center $ % 9 8-98 In Conditional Format as Cell Formatting Table Styles Styles Alignment Number ce a client for $24,000 of work performed in July. The invoice will be paid on the 20th of next month. A D Additional Information Equipment: The $48,000 beginning balance in the Equipment account relates to equipment which was purchased on January 2, 2018. At that time, Connie's estimated: - the equipment would last for four years (48 months) - at the end of the four years, the equipment would have no future value and would be scrapped The following information relates to the new equipment which was purchased on July 1, 2019. - The new equipment was placed into service on July 1, 2019 and should be depreciated for the month of July. - The estimated useful life of the new equipment is 5 years. - At the end of 5 years, the new equipment will have no future value and will be scrapped - The new equipment will be depreciated using the straight-line method. Supplies: At the end of July there are $28,250 supplies on-hand. Caneuline nn neilt Connie' ciandcontent to norformance for ou utomor Transactions Chart of Accounts General Journal General Journal p2 General Ledg RE e Accounting Cycle Project (version 1) - AutoRecovered. Formulas Data Review View Help A 5 Wrap Text General Merge & Center A $ -% -28 Insert Delete Conditional Format as Cell Formatting Table Styles Styles Alignment Number Cells Dice a client for $24,000 of work performed in July. The invoice will be paid on the 20th of next month. D E Supplies: At the end of July there are $28,250 supplies on-hand. Consulting On April 1, Connie's signed a contract to perform services for a new customer. Service: The contract stipulates that connie's will be paid an $8,000 monthly fee for the consulting services. As part of the contract agreement, the customer agrees to pay the first four months of services in advance; thus Connie's received $32,000 cash on April 1. Connie's put the credit to Unearned Revenue. At the end of April, May and June, Connie's recognized the $8,000 of consulting revenue earned. The monthly consulting service was provided per the contract for July 2019. Wages Due The last wage payment was made to the employees on July 28, 2019. The employees worked on July 29, 30, and 31. For these three days of work the Employees: employees earned $3,075 of wages. These three days of wages will be paid to the workers during the first week of August. Bank Loan The interest on the loan from 1st Bank will be paid every three months. The first interest payment to the bank will be made on September 30, 2019. On July 31 the bank indicates that the interest on the loan for July is $830. the Transactions Chart of Accounts General Journal General Journal p2 General Ledger RI L Accounting Cycle Project (version 1) - AutoRecovered - Page Layout Formulas Data Review View Help 111 General - A A - AA- Wrap Text + Merge & Center $ %&-28 Conditional Formatting ont Alignment Number A D F G 3 4 files. Save 5 6 7 B Chart of Accounts Account # Account Name Assets: 100 Cash 105 Accounts Receivable 110 Supplies 150 Equipment 155 Accumulated Depreciation 8 L. 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 200 205 210 215 250 Liabilities: Accounts Payable Wages Payable Interest Payable Unearned Revenue Note Payable 300 305 Equity: Owner's Capital Owner's Drawings 400 Close Revenues: Service Revenue Transactions Chart of Accounts General Journal General Journa Accounting Cycle Project (version 1) - AutoRecovered - - Layout Formulas Data Review View Help ' ' General Wrap Text Merge & Center A $ -% 8 - Conditional Format Formatting Table Styles Alignment Number B D G 250 Note Payable ve 17 18 19 20 21 22 23 24 300 305 Equity: Owner's Capital Owner's Drawings Revenues: Service Revenue 400 25 26 27 28 29 500 505 510 515 520 550 Expenses: Supplies Expense Repair Expense Wages Expense Rent Expense Depreciation Expette Interest Expense 30 31 32 33 34 35 36 37 Alignment Number Styles Cells General Ledger = Equipment Atce Pay Oral Servis Bontonome 11 60.000 Balasse OD Balance Ad 11 Acumulated 15 Depreciated - 19.00 7 Wewable Ouna's Drouin 1 Balanse SER TE BetBalance Be Balance . 11 InterartPayable 11 In consummary Balland 2 Resipi An Receivable Baland 11 11 11 Balans 32,500 Und Raven 11 Band WENN B Balance . Mete Payable feler B.Balance 975 Accounting Cycle Project (version 1) - AutoRecovered - Search Page Layout Formulas Data Review View Help 11 -A A 2 Wrap Text Text a-A- + Merge & Center $ - % 848 Conditional Format Formatting Table - Styles Font Alignment Number Pre-Closing Trial Balance 0 E F G H 1 Connie's Consulting 2 3 4 Pre-Closing Imal Balance files. Save Debit Credit S. 5 Account Name 8 Cash 7 Accounts Receivable & Supplies 9 Equipment 10 Accumulated Depreciation 11 Accounts Payable 12 Wages Payable 13 Interest Payable 14 Unearned Revenue 15 Note Payable 16 Owner's Capital 17 Owner's Drawing 18 Service Revenue 19 Supplies Expense 20 Repair Expense 21 Wages Expense 22 Rent Expense 23 Depreciation Expense 24 Interest Expense 25 Total Close Transactions Chart of Accounts General Journal General Journal p2 = Accounting Cycle Project (version 1) - AutoRecovered Search out Formulas Data Review View Help Number - A A SA- Wrap Text Merge & Center $ % 8-98 Conditional Format as Cell Formatting Table Styles Styles Alignment Number D G H 1 2 3 Connie's Consulting Income Statement For the Month Ended July 31, 2019 4 5 6 7 Service Revenue 8 Total Revenue 9 10 11 12 13 14 15 16 17 18 19 20 21 22 Expenses Supplies Repair Wages Rent Depreciation Interest Total Operating Expenses Net Income Transactions Chart of Accounts General Journal General Journal p2 Genere Accounting Cycle Project (version 1) - AutoRecovered - Formulas Data Review View Help A 2 Wrap Text Number V lili e Merge & Center $ - %, 8-98 Conditional Formatting Alignment Number 2 B 0 FT F G C Connie's Consulting Balance Sheet As of July 31, 2019 Assets: Current Assets Cash Accounts Receivable Supplies Total Current Assets Property & Equipment: Equipment Accumulated Depreciation Property & Equipment, net Total Assets Liabilities & Oxner's Equity: Current Liabilities: Accounts Payable Wages Payable Interest Payable Unearned Revenue Total Current Liabilities: Long-Term Liabilities: Note Payable Total Liabilities: Owner's Equity Owner's Capital Total Owner's Equity Total Liabilities & Ovner's Equity Transactions Chart of Accounts General Journal General Jour o search Accounting Cycle Project (version 1) - AutoRecovered. Formulas Data Review View Help General 25 Wrap Text Merge & Center ' ' A- Insert $ -% 8-98 Conditional Format as Cell Formatting Table Styles Styles Alignment Number E F D Connie's Consulting 1 2 3 Closing Journal Date Account Number Account Name Posted Debit Credit 4 5 6 7 8 9 10 12 3 5 6 7 8 9 General Journal General Journal p2 General Ledger Trial Balance IS & OE BS Layout Formulas Data Review View Help 11 A A Wrap Text Number AE Merge & Center $ - % Alignment Number A B E F G Connie's Consulting 2 3 4 Post-Closing Trial Balance Save Debit Credit 5 Account Name 6 Cash 7 Accounts Receivable 8 Supplies 9 Equipment 10 Accumulated Depreciation 11 Accounts Payable 12 Wages Payable 13 Interest Payable 14 Unearned Revenue 15 Note Payable 16 Owner's Capital 17 Owner's Drawing 18 Service Revenue 19 Supplies Expense 20 Repair Expense 21 Vages Expense 22 Rent Expense 23 Depreciation Expense 24 Interest Expense 25 Total 26 27 28 + Document1 - Word o Search Layout References Mailings Review View Help For this question I need the: general journal, general journal adjusting entries, general ledger, trial balance, income statement, owner's equity, balance sheet, closing journals, post-closing trial balance