I need help preparing a bank reconcilliation for Nick Roberts Lawn Service The First picture is the completed accounting worksheet. The second picture is the bank statement information. The third and fourth pictures are the business transactions that are in the books. The 5th and 6th picture are the completed unadjusted and adjusted trial balances. The 7th and 8th pictures are the T-accounts.
Unadjusted Trial Balance Adjustments Adjusted Trial Balance Income Statement Balance Sheet Account title Debit Credit Debit Credit Debit Credit Debit Credit Debit Cash $ 18,670.00 $ 40.00 $ 18,630.00 S 18,630.00 Accounts Receivable $ 2,450.00 $ 2,450.00 $ 2,450.00 Prepaid Insurance $ 1.200.00 $ 100.00 $ 1,100.00 $ 1.100.00 Equipment $ 12,750.00 $ 12.750.00 $ 12,750,00 Gas and Oil $ 1,005.00 $ 805.00 $ 200.00 S 200.00 Accounts Payable $ 4,300.00 $ 4,300.00 $ 4,300.00 Note Payable $ 20,000.00 $ 20,000.00 $ 20,000.00 Uneamed Revenue $ 900.00 $ 300.00 $ 600.00 $ 600.00 Revenue $ 3,350.00 $ 300.00 $ 3,650.00 $ 3.650.00 Advertising Expense $ 800.00 $ 800.00 $ 800.00 Mileage Expense $ 210.00 $ 210.00 $ 210.00 Gas and Oil Expense $ 805.00 $ 805.00 $ 805.00 Insurance Expense $ 100.00 $ 100.00 $ 100.00 Supples Expense $ 90.00 90.00 $ 90,00 Phone Expense $ 375.00 375.00 $ 375.00 Roberts, Capital $ 10.000.00 $ 10,000.00 S 10.000.00 Roberts, Withdrawal $ 1.000.00 $ 1.000.00 $ 1,000.00 Depreciation expense $ 400.00 $ 400.00 $ 400,00 Accumulated depreciation equipment $ 400.00 $ 400.00 $ 400.00 Bank service charge $ 40,00 $ 40,00 $ 40.00 Interest expense $ 125.00 $ 125.00 $ 125.00 Interest payable $ 125.00 125.00 S 25.00 Total $ 38,550.00 S 38.550.00 $ 1,770.00 $ 1.770.00 S 39.075.0039,075.00 $ 2,945.00 $ 3,650.00 S 36,130.00 S 35,425.00 Net incomerloss) $ 705.00 S 705.00 Totals $ 3.650.00 S 3,650.00 S 36,130.00 $ 36,130.00 022 x 1000 C D Roberts Lawn Service Unadjusted Trial Balance For the Month ended December 31, 2018 $ Debit 18,670.00 2.450.00 1,200.00 12,750.00 1,005.00 Cash Accounts Recievable Prepaid Insurance Equipment Gas and O Accounts Payable 6 Note Payable Uneamed Revenue Revenue Advertising Expense 10 Mileage Expense 11 Gas and Ol Expense 12 Insurance Expense 13 Supplies Expense 14 Phone Expense 21 15 Roberts. Capital 22 e Roberts, Withdrawal 4,300.00 20,000.00 900.00 3,350.00 800.00 210.00 88 90.00 375.00 10,000.00 1.000.00 FEEST TSWASTS F onts Post-Closing TB and Reconcil Vorge Center $ Formatting as able Styles X V fx Bank Service Charges Accounts Payable Month End Adjustments Adjustment Number Adjustment Description 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 * Previous Pogle Chrome