I need help creating a accounting worksheet for Nick"s lawn service using the information provided.
insert Format Tools Data Window Help *24) 56% TUD Excel File Edit View Autores Acctg1 Practice Set Template_SP19 Addy Burnett new Home Insert Draw Page Layout Formulas Data Review View Protes MS Port Sparks Comment for 26 Roberts Law Service Worksheet For the Month ended December 31, 2018 Cred Month End Adjustments Adjustment Number Adjustment Description N Record the expiration of one month's insurance. Depreciation on Equipment for the month is $400.00. After taking an inventory, it is determined there is $200 of gas and oil on hand at the end of the month. Nick cut the lawn for the Insurance Agency once during the month (refer to the December 14 business transaction). The interest owed for the month is $125. Complete the bank reconciliation and record any necessary Journal entries. Any discrepancies on check amounts are a bank error a * Previous ogle Chrome GENIOS OR 8 A, 38 E For the Month ended December 31, 2018 Credit $ Debit, 18,670.00 2,450.00 1,200.00 12,750.00 1,005.00 Cash 2 Accounts Recievable 3 Prepaid Insurance 4 Equipment Gas and Oil 5 Accounts Payable 6 Note Payable Unearned Revenue 8 Revenue 9 Advertising Expense 10 Mileage Expense 11 Gas and Oil Expense 12 Insurance Expense 13 Supplies Expense 14 Phone Expense 15 Roberts, Capital 16 Roberts, Withdrawal 17 4,300.00 20,000.00 900.00 3,350.00 - 800.00 210.00 90.00 375.00 10,000.00 15 1,000.00 SI 5 19 Accounts General Journal Unad TB Worksheet Ad Financial Statements Post Closing Te b ank Reconciliation + X X X X x X Comprehensive Project Part B Date Business Transactions Transaction Amount Nick Roberts invested capital in his new December 1, 2018 Deposit Ticket1 business venture by depositing money into an interest bearing business checking $10,000.00 account Nick borrowed from the local bank. It is a 5 December 1, 2018 Deposit Ticket 1 year note, 10% interest December 2, 2018 100 Check Number Nick paid cash for a trailer listed on Craigs $8.000.00 list to haul his lawn equipment Nick signed a contract with a celular company and purchased a smart phone on December 2, 2018 account to track appointments and make $200.00 business phone calls (anything less than $300 is considered an expense). Nick purchased a lawn tractor at Sears on 00000 account Nick paid cash for a hand lawn mower at Check Number $750.00 December 3, 2018 101 Menards (anything tangible over $300 is capitalized as a fixed asset). Nick paid for a one-year insurance policy $1.200.00 Check Number December 4, 2018 102 that was effective December 1. Nick signed a contract with a local graphic center to detail the name of the business on 5700.00 December 5, 2018 his truck for advertising and received an Socember 3, 2018 X X X X C X X Check Number December 5, 2018 103 X Check Number December 8, 2018 invoice to be paid Nick paid cash for supplies (gas cans, rakes, & garbage cans) which he will be using in November for the business. (hint-he is $90.00 using them right away so they are an expense) Nick filled all of the gas cans and purchased oil for the lawn equipment. (Gas & Oil are $400.00 recorded as an asset and adjusted at the end of the month for usogel Nick advertised his business in the local newspaper. The newspaper invoices their $100.00 customers monthly Nick performed lawn service for The Local Community College campus and its dormitories. The college was invoiced. December 9, 2018 $1,000.00 Invoice 001 December 10, 2018 December 1, 2018 $200.00 December 14, 2018 December 15, 2018 December 17, 2018 December 19, 2018 December 19, 2018 December 22, 2018 Deposit Ticket Nick performed lawn service for The CPA Firm and received cash. A The Insurance Agency gave Nick an advance Deposit Ticket 2 payment to maintain their lawn. Nick quoted them $300 per service visit. Deposit Ticket 2 Nick received partial payment for Invoice $300.00 001 Invoice 002 Nick performed lawn service for MNO $400.00 Manufacturing. The company was invoiced Check Number Nick filled all of the gas cans and purchased $230,00 105 oll for the lawn equipment. Check Number Nick paid the local graphic center for the $700,00 106 work they did on his truck. $400.00 Deposit Ticket 3 Nick received payment for Invoice 002. Nick performed lawn service for The Local $950.00 Invoice 003 Community College campus and its dormitories. The college was invoiced. Check Number Nick filled all of the gas cans and purchased $375 00 107 oil for the lawn equipment. Nick submitted an expense report for Check Number 108 truck. December 24, 2018 December 28, 2018 $210.00 business mileage incurred on his personal December 28, 2018 $800.00 Invoice 004 $175.00 Nick performed lawn service for a new client, FSC Corporation and sent them an invoice. Nick paid the cell phone bill for the month of December Nick withdrew cash for personal use. Check Number December 29, 2018 December 29, 2018 December 30, 2018 $1,000.00 109 Check Number 110