70.2K

Verified Solution

Link Copied!

I need help creating a bank reconcilliation using the information provided below. The last picture listed shows how the answer should be laid out

the only thing that needs to be completed is the bank reconcilliation. The other pictures just have extra information. Please complete the bank reconcilliation based on the information provided.

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 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

Answer & Explanation Solved by verified expert

See Answer