Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Hello and good morning, I am doing my Bank Reconciliation Form in accounting and I need some help. Would you be able to help me?
Hello and good morning, I am doing my Bank Reconciliation Form in accounting and I need some help. Would you be able to help me?
Appendix B Bank Reconciliation Form Tou may complete the Bank Reconciliation below. The Bank Statement is on the next page. Sound Bytes Electronics Bank Reconciliation As Balance per Bank $ Balance per Books $ Add: Add: Subtotal Subtotal Less: Less: Reconciled Balance $ Reconciled Balance $ The following statement from the Community Bank was received on May record the actual information ($9 bank charges for the statements). Appendix C Bank was received on May 7, 2018, too late to Prepare a Bank Reconciliation as of April 30, 2018, in proper form. The Bank Reconciliation Adjustments have not been included in the solution determined and included at the discretion of the instructor. ave not been included in the solution but may be 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 14,964.00 401 1,695.00 13,269.00 Dep 339.00 13,608.00 DM 50.00 13,558.00 Dep 222.00 13,780.00 402 791.00 12,989.00 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 Dep 610.20 5,360.20 16 407 339.00 5,021.20 30 DM 400.00 4,621.20 31 SIC 9.00 4,612.20 Debit Memo DD Direct Deposit NSF Not Sufficient Funds, Item returned AC Item returned, Account Closed S/C Service Charge Cor Correction Name Julie-ann Patton 2 Worksheet Sound Bytes Electronics Work Sheet For Month Ended April 30, 2018 Income Statement Debit Credit Adjustments Debit Credit 10,882 80 691.001 5,494.43 9 Account Titles 10 101 Bank Account Chequing 11 120 Accounts Receivable 12 122 Merchandise Inventory 13 124 Store Supplies on Hand 14 128 Prepaid Insurance 15 161 Store Equipment 16 162 Accum Deprec. Store Equip 17 210 Accounts Payable 18 220 Accrued Payables 19 241 HST on Sales 20 243 HST on Pure/Serv 21 261 Bank Loan Payable (Long Term) 22 310 Capital John Stammers 23315 Drawings John Stammers 24 401 Sales - Electronic Devices 25 403 Sales - Music CDs 26.1405 Sales - Movies Trial Balance Debit Credit 4,081.20 1,708.00 12.969,43 48200 450.00 29,500.00 17.550.00 1.808.00 0.00 226.20 1.157 001 6,600.00 6,938.00 3.231.00 33.795.00 24,901.00 19.850.00 Adjusted Trial Balance Debit Credit 14 964 00 1,017.00 7.475.00 482.001 450.000 29,500.00 17,550.00 1.695.00 Balance Sheet & Statement of Owner's Equity Debit Credit 14,964.00 1,017.00 7,475.000 482.00 450.00 29,500.00 17,550.00 1.695.00 113.001 1.387.00 1,387.00 1.160.80 316.00 353.00 841.001 841.00 6.953.00 6.938.00 6.953.00 6.938.000 700.00 2.531.00 2,531.00 475.00 1,220.00 165.00 33,320.00 23,681.00 19.585.00 33,320.00 23.681.00 19.6851001 1,005.00 80.00 925.00 925.00 840.00 1,375.00 39,900.57 200.00 4.00 905.57 640.00 1,371.00 38,995.00 640.00 1,371.00 38.995.00 806.00 126.00 680.00 680.00 1,500.00 540.00 4 27 407 Sales - Other 28 421 Sales - Returns 29 423 Sales - Discounts 30 510 Cost of Goods Sold 31 516 Purchase - Discounts 32 521 Rent Expense 33 523 Store Salaries Expense 34 527 Store Supplies Expense 35 529 Insurance Expense 36 531 Hydro and Water Expense 37 533 Depreciation Exp Store Equip 38 535 Advertising Expense 39 572 Miscellaneous/Other Expense 40 574 Bank Charges/Interest Expense 41 576 Bookkeeping Expense 42 Totals 43 .... ..... 300.00 6,000.00 3,762.00 470.00 1 450.00 856.00 1,350.00 4,040.00 195.00 262 001 400.00 113.479.20 4,500.00 3.222.00 70.00 450.00 556.00 1,350.00 3,340.00 1 45.00 215.00 300.00 112,814.00 4,500.00 3,222.00 470.00 450.00 556.00 1,350.00 3,340.00 145.00 215.00 300.00 700.00 50.001 47.00 100.00 13.061.80 1 113,479.20 13,061.80 112,814.00 22 737 00 78,291.00 22.737.00 57 260.00 78,291.00 57.260.00 Accounts Payable Subleger Perpetual Inventory Subledger Worksheet Income Statement S... Appendix B Bank Reconciliation Form Tou may complete the Bank Reconciliation below. The Bank Statement is on the next page. Sound Bytes Electronics Bank Reconciliation As Balance per Bank $ Balance per Books $ Add: Add: Subtotal Subtotal Less: Less: Reconciled Balance $ Reconciled Balance $ The following statement from the Community Bank was received on May record the actual information ($9 bank charges for the statements). Appendix C Bank was received on May 7, 2018, too late to Prepare a Bank Reconciliation as of April 30, 2018, in proper form. The Bank Reconciliation Adjustments have not been included in the solution determined and included at the discretion of the instructor. ave not been included in the solution but may be 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 14,964.00 401 1,695.00 13,269.00 Dep 339.00 13,608.00 DM 50.00 13,558.00 Dep 222.00 13,780.00 402 791.00 12,989.00 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 Dep 610.20 5,360.20 16 407 339.00 5,021.20 30 DM 400.00 4,621.20 31 SIC 9.00 4,612.20 Debit Memo DD Direct Deposit NSF Not Sufficient Funds, Item returned AC Item returned, Account Closed S/C Service Charge Cor Correction Name Julie-ann Patton 2 Worksheet Sound Bytes Electronics Work Sheet For Month Ended April 30, 2018 Income Statement Debit Credit Adjustments Debit Credit 10,882 80 691.001 5,494.43 9 Account Titles 10 101 Bank Account Chequing 11 120 Accounts Receivable 12 122 Merchandise Inventory 13 124 Store Supplies on Hand 14 128 Prepaid Insurance 15 161 Store Equipment 16 162 Accum Deprec. Store Equip 17 210 Accounts Payable 18 220 Accrued Payables 19 241 HST on Sales 20 243 HST on Pure/Serv 21 261 Bank Loan Payable (Long Term) 22 310 Capital John Stammers 23315 Drawings John Stammers 24 401 Sales - Electronic Devices 25 403 Sales - Music CDs 26.1405 Sales - Movies Trial Balance Debit Credit 4,081.20 1,708.00 12.969,43 48200 450.00 29,500.00 17.550.00 1.808.00 0.00 226.20 1.157 001 6,600.00 6,938.00 3.231.00 33.795.00 24,901.00 19.850.00 Adjusted Trial Balance Debit Credit 14 964 00 1,017.00 7.475.00 482.001 450.000 29,500.00 17,550.00 1.695.00 Balance Sheet & Statement of Owner's Equity Debit Credit 14,964.00 1,017.00 7,475.000 482.00 450.00 29,500.00 17,550.00 1.695.00 113.001 1.387.00 1,387.00 1.160.80 316.00 353.00 841.001 841.00 6.953.00 6.938.00 6.953.00 6.938.000 700.00 2.531.00 2,531.00 475.00 1,220.00 165.00 33,320.00 23,681.00 19.585.00 33,320.00 23.681.00 19.6851001 1,005.00 80.00 925.00 925.00 840.00 1,375.00 39,900.57 200.00 4.00 905.57 640.00 1,371.00 38,995.00 640.00 1,371.00 38.995.00 806.00 126.00 680.00 680.00 1,500.00 540.00 4 27 407 Sales - Other 28 421 Sales - Returns 29 423 Sales - Discounts 30 510 Cost of Goods Sold 31 516 Purchase - Discounts 32 521 Rent Expense 33 523 Store Salaries Expense 34 527 Store Supplies Expense 35 529 Insurance Expense 36 531 Hydro and Water Expense 37 533 Depreciation Exp Store Equip 38 535 Advertising Expense 39 572 Miscellaneous/Other Expense 40 574 Bank Charges/Interest Expense 41 576 Bookkeeping Expense 42 Totals 43 .... ..... 300.00 6,000.00 3,762.00 470.00 1 450.00 856.00 1,350.00 4,040.00 195.00 262 001 400.00 113.479.20 4,500.00 3.222.00 70.00 450.00 556.00 1,350.00 3,340.00 1 45.00 215.00 300.00 112,814.00 4,500.00 3,222.00 470.00 450.00 556.00 1,350.00 3,340.00 145.00 215.00 300.00 700.00 50.001 47.00 100.00 13.061.80 1 113,479.20 13,061.80 112,814.00 22 737 00 78,291.00 22.737.00 57 260.00 78,291.00 57.260.00 Accounts Payable Subleger Perpetual Inventory Subledger Worksheet Income Statement SStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started