Hello and good afternoon, I am doing Bank Reconciliation and I need help doing this. I was wondering if you could help me figure out how do to do this.
A D G K Name Julie-ann Patton 2 Worksheet Sound Bytes Electronics Work Sheet For Month Ended April 30, 2018 Balance Sheet & Adjusted Statement of Trial Balance Account Titles Adjustments Trial Balance Income Statement Debit Credit Owner's Equity Debit Credit Debit Credit Debit Credit Debit 10 101 Bank Account Chequing Credit 4,081.20 11 120 Accounts Receivable 10,882.80 14,964.00 14,964.00 12 122 Merchandise Inventory 1,708.00 691.00 12,969.43 1,017.00 1,017.00 13 124 Store Supplies on Hand 5,494.43 482,00 7.475.00 7,475.00 14 128 Prepaid Insurance 450.00 482.00 + 482.00 15 161 Store Equipment 29,500.00 450.00 450.00 16 162 Accum Deprec. Store Equip 29,500.00 29,500.00 17 210 Accounts Payable 17,550.00 17,550.00 17,550.00 18 220 Accrued Payables 1,808.00 113.00 1,695.00 1,695.00 19 241 HST on Sales 0.00 226.20 20 243 HST on Purc/Serv 1, 160.80 1,387.00 1,157.00 1,387.00 21 261 Bank Loan Payable (Long Term) 316.00 841.00 841.00 6,600.00 353.00 22 310 Capital John Stammers 6,953.00 6,938.00 6,953.00 6,938.00 23 315 Drawings John Stammers 3,231.00 6,938.00 700 00 2,531.00 24 401 Sales - Electronic Devices 2,531.00 33,795.00 475.00 25 403 Sales - Music CDs 33,320.00 24,901.00 33,320.00 1,220.00 26 405 Sales . 23,681.00 23,681.00 19 850 00 165 00 19 685 001 19 685.0027 407 Sales - Other 1,005.00 80.00 925.00 925.00 28 421 Sales - Returns 840.00 200.00 640.00 640.00 29 423 Sales - Discounts 1,375.00 4.00 30 510 Cost of Goods Sold 1,371.00 1,371.00 39,900.57 905.57 38,995.00 38.995.00 31 516 Purchase - Discounts 806.00 126.00 680.00 680.00 32 521 Rent Expense 6,000.00 1,500.00 33 523 Store Salaries Expense 4,500.00 4,500.00 3,762.00 34 527 Store Supplies Expense 540.00 3,222.00 3,222.00 470.00 470.00 35 529 Insurance Expense 450.00 470.00 450.00 36 531 Hydro and Water Expense 856.00 450.00 37 533 Depreciation Exp Store Equip 300.00 1,350.00 556.00 556.00 38 535 Advertising Expense 1,350.00 1,350.00 4,040.00 700.00 3,340.00 3,340.00 39 572 Miscellaneous/Other Expense 195.00 50.00 40 574 Bank Charges/Interest Expense 145.00 145.00 262.00 47.00 41 576 Bookkeeping Expense 215.00 215.00 400.00 100.00 300.00 300.00 42 Totals 113,479.20 113,479.20 13,061.80 13,061.80 112,814.00 43 112,814.00 22,737.00 44 22,737.00 78,291.00 78,291.00 57,260.00 57,260.00 45 46 47 48 49 50 51 ... Accounts Payable Subleger Perpetual Inventory Subledger Worksheet Income Statement S ... +Appendix C The following statement from the Community Bank was received on May 7, 2018, too late to record the actual information ($9 bank charges for the statements). Prepare a Bank Reconciliation as of April 30, 2018, in proper form. The Bank Reconciliation Adjustments have not been included in the solution but may be determined and included at the discretion of the instructor. Community Bank 938 Carlton Street St. Catharines, Ontario L2R 3C6 Sound Bytes Electronics 1577 Scott Street St. Catharines, Ontario L2N 4F8 Account Number: 261686342-1484 Statement period 1 Apr 2018 to 30 Apr 2018 Enclosed items 8 Page 1 Date Ch. No. Withdrawals Deposits Balance or Code April A W - 14,964.00 401 1,695.00 13,269.00 Dep 339.00 13,608.00 DM 50.00 13,558.00 5 Dep 222.00 13,780.00 6 402 791.00 12,989.00 10 403 555.00 12,434.00 10 Dep 610.20 13,044.20 13 405 700.00 12,344.20 13 404 546.00 11,798.20 13 AC 610.20 11,188.00 16 406 6,438.00 4,750.00 16 Dep 610.20 5,360.20 16 407 339.00 5,021.20 30 DM 400.00 4,621.20 31 S/C 9.00 4,612.20 DM Debit Memo DD Direct Deposit NSF Not Sufficient Funds, Item returned AC Item returned, Account Closed SIC Service Charge Cor Correction