I need help preparing a bank reconcilliation for Roberts Lawn Service. It also needs to include book information. The last photo is the layout that needs to be followed.

Date Number Description Withdrawals Deposits Balance DOO 12/1/2018 Deposit 30,000.00 30,000.00 Check 12/5/2018 101 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 400.00 12/12/2018 104 Check 19,560.00 Deposit 12/15/2018 1,400.00 20,960.00 12/21/2018 105 Check 230.00 20,730.00 12/29/2018 Deposit 21,130.00 400.00 Bank Service 40.00 12/30/2018 21,090.00 Charge 12/30/2018 108 Check 210.00 20,880.00 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 Do Rato answer her Anonymous 143 Based on the adjusted Trial Balance, please Stockholder's equity schedule attached Income statement Balance Sheet ar 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 FAST COMPANY Bank Reconciliation Statement January 31, 2016 Balance as per bank statement, January 31, 2015 Add: Deposit in transit $ 10,000 822 $ 10,822 $ 200 Deduct: Outstanding checks Check No. 201 Check No. 212 Check No. 216 20 610 830 Adjusted cash balance $ 9,992 8,525 Balance as per depositor's record, January 31, 2015 Add: Note receivable collected by bank Interest earned during January 1,588 50 1,638 $ 10,163 10 100 Deduct: Collection charges NSF check Service charges Error on check no. 220 171 Adjusted cash balance $ 9.992 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 Do Rato answer her Anonymous 143 Based on the adjusted Trial Balance, please Stockholder's equity schedule attached Income statement Balance Sheet ar Chrome Fle Edit View Hstory Bookmarks People Tab Window Help o Ba Sment Accountng Mon GUsng The mation And Temx Heole ed the F v Mave NepHtory, Lesty&Be chegg.comhomework-help/ouestions-and-anwersuning-information-template-provided-need-help-eeating-fnacia-statements-oberts-lawn se g42915529 llApps be M Gnal-bue Amancom Merine Pak ch ebot Ou Ma Dey Chael Cengagee2 Feetorm Cm E Chegg Study Textbeek Solutions Expert Q&A Practice Search Q Adjusted Trial Balance Particulars Cash Debit Credit 18,670 2450 Continue to post Accounts receivables 1,005GAS &Oi no mnin 1,005 1,100 12,750 Prepaid Insurance My Textbook Solutions Equipment Accounts Payable Unearned revenue nderest payable otes payable Capital Withdrawls Service Revenue Advertising expense Cellphone expense Mileage expense Supplies expense Insurance Expense Interest expense Total intant - sol r eots 4300 00 167 20,000 Adda eook Adda ok ebook 10,000 000'1 3350 Accounting Chegg tutors who can help right now 800 375 Abu 210 90 Samae M Ho ivty 100 167 Duncan M 38,717 38,717 ese a search or ye uRL 2 3 4 7 E R T P Y tab A D F G H eaps lock z X C V M shit contrel option commands command Comprehensive Project PartB Date Business Transactions Transaction Nick Roberts invested capital in his new business venture by depositing money into an interest bearing business checking X Amount December 1 2018 Deposit Ticket 1 $10,000.00 account Nick borrowed from the local bank. It is a 5- December 1, 2018 Deposit Ticket 1 year note, 10% interest Nick paid cash for a trailer listed on Craig's list to haul his lawn equipment. Nick signed a contract with a cellular company and purchased a smart phone on account to track appointments and make business phone calls (anything less than $300 is considered an expense). Nick purchased a lawn tractor at Sears on account Nick paid cash for a hand lawn mower at Menards (anything tangible over $300 is capitalized as a fixed asset). Nick paid for a one-year insurance policy that was effective December 1 Nick signed a contract with a local graphic center to detail the name of the business on his truck for advertising and received an 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 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 recorded as an asset and adjusted ot the end of the month for usage) Nick advertised his business in the local newspaper. The newspaper invoices their customers monthly Nick performed lawn service for The Local Community College campus and its dormitories. The college was invoiced $20,000.00 Check Number December 2, 2018 100 $8,000.00 December 2, 2018 $200.00 bocember 3, 2018 $4,000.00 Check Number December 3, 2018 101 $750.00 (X Check Number $1,200.00 December 4, 2018 102 $700.00 December 5, 2018 $90.00 X Check Number December 5, 2018 103 $400.00 Check Number December 8, 2018 104 $100.00 December 9, 2018 $1,000.00 December 10, 2018 Invoice 001 X December 1, 2018 Deposit Ticket 2 Nick performed lawn service for The CPA Firm and received cash. December $200.00 014, 2018 The Insurance Agency gave Nick an advance Deposit Ticket 2 payment to maintain their lawn. Nick quoted them $300 per service visit. Nick received partial payment for Invoice 001 $900.00 December Deposit Ticket 2 15, 2018 $300.00 December 17, 2018 Nick performed lawn service for MNO Manufacturing. The company was invoiced Nick filled all of the gas cans and purchased oil for the lawn equipment. Nick paid the local graphic center for the work they did on his truck. Invoice 002 $400.00 December 19, 2018 December 19, 2018 December 22, 2018 Check Number 105 $230.00 Check Number $700.00 106 Nick received payment for Invoice 002. $400.00 Deposit Ticket 3 Nick performed lawn service for The Local Community Colllege campus and its dormitories. The college was invoiced. Nick filled all of the gas cans and purchased oil for the lawn equipment. Nick submitted an expense report for business mileage incurred on his personal $210.00 truck 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 December 24, 2018 $950.00 Invoice 003 Check Number 107 $375.00 December 28, 2018 Check Number December 108 28, 2018 $800.00 December Invoice 004 29, 2018 $175.00 Check Number 109 Check Number 110 December $1,000.00 29, 2018 December Nick withdrew cash for personal use. 30, 2018 Date Number Description Withdrawals Deposits Balance DOO 12/1/2018 Deposit 30,000.00 30,000.00 Check 12/5/2018 101 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 400.00 12/12/2018 104 Check 19,560.00 Deposit 12/15/2018 1,400.00 20,960.00 12/21/2018 105 Check 230.00 20,730.00 12/29/2018 Deposit 21,130.00 400.00 Bank Service 40.00 12/30/2018 21,090.00 Charge 12/30/2018 108 Check 210.00 20,880.00 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 Do Rato answer her Anonymous 143 Based on the adjusted Trial Balance, please Stockholder's equity schedule attached Income statement Balance Sheet ar 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 FAST COMPANY Bank Reconciliation Statement January 31, 2016 Balance as per bank statement, January 31, 2015 Add: Deposit in transit $ 10,000 822 $ 10,822 $ 200 Deduct: Outstanding checks Check No. 201 Check No. 212 Check No. 216 20 610 830 Adjusted cash balance $ 9,992 8,525 Balance as per depositor's record, January 31, 2015 Add: Note receivable collected by bank Interest earned during January 1,588 50 1,638 $ 10,163 10 100 Deduct: Collection charges NSF check Service charges Error on check no. 220 171 Adjusted cash balance $ 9.992 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 Do Rato answer her Anonymous 143 Based on the adjusted Trial Balance, please Stockholder's equity schedule attached Income statement Balance Sheet ar Chrome Fle Edit View Hstory Bookmarks People Tab Window Help o Ba Sment Accountng Mon GUsng The mation And Temx Heole ed the F v Mave NepHtory, Lesty&Be chegg.comhomework-help/ouestions-and-anwersuning-information-template-provided-need-help-eeating-fnacia-statements-oberts-lawn se g42915529 llApps be M Gnal-bue Amancom Merine Pak ch ebot Ou Ma Dey Chael Cengagee2 Feetorm Cm E Chegg Study Textbeek Solutions Expert Q&A Practice Search Q Adjusted Trial Balance Particulars Cash Debit Credit 18,670 2450 Continue to post Accounts receivables 1,005GAS &Oi no mnin 1,005 1,100 12,750 Prepaid Insurance My Textbook Solutions Equipment Accounts Payable Unearned revenue nderest payable otes payable Capital Withdrawls Service Revenue Advertising expense Cellphone expense Mileage expense Supplies expense Insurance Expense Interest expense Total intant - sol r eots 4300 00 167 20,000 Adda eook Adda ok ebook 10,000 000'1 3350 Accounting Chegg tutors who can help right now 800 375 Abu 210 90 Samae M Ho ivty 100 167 Duncan M 38,717 38,717 ese a search or ye uRL 2 3 4 7 E R T P Y tab A D F G H eaps lock z X C V M shit contrel option commands command Comprehensive Project PartB Date Business Transactions Transaction Nick Roberts invested capital in his new business venture by depositing money into an interest bearing business checking X Amount December 1 2018 Deposit Ticket 1 $10,000.00 account Nick borrowed from the local bank. It is a 5- December 1, 2018 Deposit Ticket 1 year note, 10% interest Nick paid cash for a trailer listed on Craig's list to haul his lawn equipment. Nick signed a contract with a cellular company and purchased a smart phone on account to track appointments and make business phone calls (anything less than $300 is considered an expense). Nick purchased a lawn tractor at Sears on account Nick paid cash for a hand lawn mower at Menards (anything tangible over $300 is capitalized as a fixed asset). Nick paid for a one-year insurance policy that was effective December 1 Nick signed a contract with a local graphic center to detail the name of the business on his truck for advertising and received an 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 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 recorded as an asset and adjusted ot the end of the month for usage) Nick advertised his business in the local newspaper. The newspaper invoices their customers monthly Nick performed lawn service for The Local Community College campus and its dormitories. The college was invoiced $20,000.00 Check Number December 2, 2018 100 $8,000.00 December 2, 2018 $200.00 bocember 3, 2018 $4,000.00 Check Number December 3, 2018 101 $750.00 (X Check Number $1,200.00 December 4, 2018 102 $700.00 December 5, 2018 $90.00 X Check Number December 5, 2018 103 $400.00 Check Number December 8, 2018 104 $100.00 December 9, 2018 $1,000.00 December 10, 2018 Invoice 001 X December 1, 2018 Deposit Ticket 2 Nick performed lawn service for The CPA Firm and received cash. December $200.00 014, 2018 The Insurance Agency gave Nick an advance Deposit Ticket 2 payment to maintain their lawn. Nick quoted them $300 per service visit. Nick received partial payment for Invoice 001 $900.00 December Deposit Ticket 2 15, 2018 $300.00 December 17, 2018 Nick performed lawn service for MNO Manufacturing. The company was invoiced Nick filled all of the gas cans and purchased oil for the lawn equipment. Nick paid the local graphic center for the work they did on his truck. Invoice 002 $400.00 December 19, 2018 December 19, 2018 December 22, 2018 Check Number 105 $230.00 Check Number $700.00 106 Nick received payment for Invoice 002. $400.00 Deposit Ticket 3 Nick performed lawn service for The Local Community Colllege campus and its dormitories. The college was invoiced. Nick filled all of the gas cans and purchased oil for the lawn equipment. Nick submitted an expense report for business mileage incurred on his personal $210.00 truck 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 December 24, 2018 $950.00 Invoice 003 Check Number 107 $375.00 December 28, 2018 Check Number December 108 28, 2018 $800.00 December Invoice 004 29, 2018 $175.00 Check Number 109 Check Number 110 December $1,000.00 29, 2018 December Nick withdrew cash for personal use. 30, 2018