I need help preparing a bank reconcilliation for Roberts Lawn Service. The bank statement information is in the first picture. The book information is in the 2nd and 3rd picture. Extra information is also included

Date Number Description Withdrawals Deposits Balance 12/1/2018 Deposit 30,000.00 30,000.00 12/5/2018 101 Check 750.00 29,250.00 12/5/2018 100 Check 8,000.00 21,250.00 12/6/2018 102 Check 1,200.00 20,050.00 12/11/2018 103 Check 90.00 19,960.00 12/12/2018 104 Check 400.00 19,560.00 12/15/2018 Deposit 1,400.00 20,960.00 12/21/2018 105 Check 230.00 20,730.00 12/29/2018 Deposit 400.00 21,130.00 12/30/2018 Bank Service Charge 40.00 21,090.00 12/30/2018 108 Check 210.00 20,880.00 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 Adjusted Trial Balance Debit 18,670 Continue to post 2.450 1.005 1.100 My Textbook Solutions cess to whep by step so 12.750 4.300 900 167 Particulars Cash Accounts receivables 1,00SGAs & Oil Prepaid Insurance Equipment Accounts Payable Uneamed revenue Interest payable notes payable Capital Withdrawls Service Revenue Advertising expense Cellphone expense Mileage expense Supplies expense Insurance Expense Interest expense Total 20,000 10,000 11.000 1150 Accounting Chegg tutors who can help right now 500 375 1210 AG 90 D amaha 100 167 5 18,717 38,717 4000108O4@4409 Roberts Lawn Service 3350 800 Statement of Income For the period ending 31.12.2018 Service Revenue Less: Advertising Expense Cellphone Expense 375 Mileage Expense 210 Supplies Expense Insurance Expense 100 Interest Expense 167 Net Income Balance sheet As at 31.12.2018 Assets Current Assets Cash Accounts Receivable Gas & Oil Prepaid Insurance 167 Amounts in $ Amounts in $ Liabilities Amounts in $ Amounts in $ Current Liabilities 18670 Accounts Payable 4300 2450 Unearned Revenue 900 1005 Interest Payable 5367 1100 23225 Non Current Liabilities Note Payable 20000 12750 Owner's Equity Capital 10608 35975 Total Liabilities & Equity 35975 1742 Non Current Assets Equipment Total Assets Capital Statement of Owner's Equity For the period ending 31.12.2018 10000 Net Income 11608 Withdrawals -1000 10608 1608 Credit in $ Post Closing Trial Balance For the period ending 31.12.2018 Particulars Debit in $ Cash 18670 Accounts Receivable 2450 Gas & Oil 1005 Prepaid Insurance 1100 Equipment 12750 Accounts Payable Unearned Revenue Interest Payable Note Payable Capital Totals 4300 900 167 20000 10608 35975 File Edit View insert Format Tools Data Window Help BU Accg 1 Practice Set Template SP19 Addy Burnett now-Seved to my Mac View 1 Draw Page Layout Formulas Data Review 30 AA E = Wrap Text Merge Center % 9 Canon E F G C D 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 Prepaid Insurance 4 Equipment Gas and 01 Accounts Payable Note Payable Uneamed Revenue Revenue Advertising Expense 10 Mileage Expense 11 Gas and Oil Expense 12 Insurance Expense 12 Supplies Expense 14 Phone Expense 15 Roberts, Capital Roberts, withdrawal 4,300.00 20,000.00 900.00 3,350.00 800.00 210.00 90.00 375.00 10,000.00 1,000.00 W E IR | D