Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

i need help preparing a bank reconcilliation for Roberts Lawn Service. Here's what I currently have. Most of these photos contain information that is needed

i need help preparing a bank reconcilliation for Roberts Lawn Service. Here's what I currently have. Most of these photos contain information that is needed to create a bank reconcilliation. Please include an explaination on how you got to the answer you got when you complete the problem
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
the first photo has the bank statement information
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 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 Set Homework Help With ChegX C Use The Template And Informatix Hippie and the Free Love Mover x E-help/questions-and-answers/use-template-information provided-create-accounting-worksheet-please-expla M Gmail-burnettadri. Moraine Park Tech... Dashboard Outlook Mail # Freeform Disney Chan = Search Chegg Study Textbook Solutions Expert Q&A Practice ** il lui sit C Q Search or type URL. 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 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 Set Homework Help With ChegX C Use The Template And Informatix Hippie and the Free Love Mover x E-help/questions-and-answers/use-template-information provided-create-accounting-worksheet-please-expla M Gmail-burnettadri. Moraine Park Tech... Dashboard Outlook Mail # Freeform Disney Chan = Search Chegg Study Textbook Solutions Expert Q&A Practice ** il lui sit C Q Search or type URL

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting For Decision Makers

Authors: Peter Atrill, Eddie McLaney

10th Edition

1292409185, 9781292409184

More Books

Students also viewed these Accounting questions

Question

Is having a positive self-concept really all that important?

Answered: 1 week ago