Hello, I finish doing my worksheet and I need help making a income statement, balance sheet and statement of changes in owners equity. Would you be able to help me? This worksheet is all one worksheet. I had to take two different pictures because it couldnt fit in one picture. Also I will have the old trial balance March 30, 2018, and the new trial balance is April 30, 2018 and it on the far left of the worksheet.
This the old trial balance:
This is the worksheet for April 30, 2018
Sound Bytes Electronics Adjusted Trial Balance as of March 31, 2018 Account Balances Debit Credit 14,964 1,017 7,475 482 450 29,500 17,550 1,695 124 161 1,387 243 261 841 6,953 6,938 2,531 Account Code # Account Name 101 Bank Account Chequing 120 Accounts Receivable 122 Merchandise Inventory Store Supplies on Hand 128 Prepaid Insurance Store Equipment 162 Accum Deprec Store Equip 210 Accounts Payable 220 Accrued Payables 241 HST on Sales HST on Purc/Serv Bank Loan Payable (Long Term) 310 Capital John Stammers 315 Drawings John Stammers 401 Sales - Electronic Devices 403 Sales - Music CDs 405 Sales - Movies 407 Sales - Other Sales - Returns Sales - Discounts 510 Cost of Goods Sold Purchase - Discounts 521 Rent Expense 523 Store Salaries Expense 527 Store Supplies Expense 529 Insurance Expense 531 Hydro and Water Expense 533 Depreciation Expense Equip 535 Advertising Expense 572 Miscellaneous/Other Expense Bank Charges/Interest Expense 576 Bookkeeping Expense 33,320 23,681 19,685 925 421 423 640 1,371 38,995 516 680 4,500 3,222 470 450 556 1,350 3,340 145 574 215 300 Totals $112.814 $112.814 old 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... Sound Bytes Electronics Adjusted Trial Balance as of March 31, 2018 Account Balances Debit Credit 14,964 1,017 7,475 482 450 29,500 17,550 1,695 124 161 1,387 243 261 841 6,953 6,938 2,531 Account Code # Account Name 101 Bank Account Chequing 120 Accounts Receivable 122 Merchandise Inventory Store Supplies on Hand 128 Prepaid Insurance Store Equipment 162 Accum Deprec Store Equip 210 Accounts Payable 220 Accrued Payables 241 HST on Sales HST on Purc/Serv Bank Loan Payable (Long Term) 310 Capital John Stammers 315 Drawings John Stammers 401 Sales - Electronic Devices 403 Sales - Music CDs 405 Sales - Movies 407 Sales - Other Sales - Returns Sales - Discounts 510 Cost of Goods Sold Purchase - Discounts 521 Rent Expense 523 Store Salaries Expense 527 Store Supplies Expense 529 Insurance Expense 531 Hydro and Water Expense 533 Depreciation Expense Equip 535 Advertising Expense 572 Miscellaneous/Other Expense Bank Charges/Interest Expense 576 Bookkeeping Expense 33,320 23,681 19,685 925 421 423 640 1,371 38,995 516 680 4,500 3,222 470 450 556 1,350 3,340 145 574 215 300 Totals $112.814 $112.814 old 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
