Complete the Income Statement and Balance Sheet columns in the worksheet. Using your worksheet as a guide, prepare the Income Statement for the month ending 30 June 20XX and the Balance Sheet as at 30 June 20xx. (Note: Enter accounts in ascending order according to their chart of account number. If an account results in a zero balance, leave the debit and credit fields for the account blank. Do not enter 0.00 the debit or credit field.) Acct No. Account Trial Balance Dr Balance Sheet WORKSHEET Worksheet for period ended 30 June 20xx Adjusted Trial Balance Income Statement Dr Cr Dr 7,231.07 Adjustments Dr Cr Cr Dr Cr 100 Bank Account 7,231.071 105 Petty Cash 200.00 200.000 110 Accounts Receivable 7,493.00 7,493.00 120 Prepaid Insurance 381.25 381.25 130 164.75 164.75 140 2,498.601 2,498.60 160 350,000.00 350,000.00 161 43,750.00 729.00 44,479.00 170 110,948.09 110,948.091 171 Prepaid Rates and Taxes GST Paid (Outlays) Buildings and Improvements (Cost) Accumulated Depreciation - Bldgs and Improvements Hire Equipment (Cost) Accumulated Depreciation - Hire Equipment Motor Vehicles (Cost) Accumulated Depreciation - Motor Vehicles Store Equipment (Cost) Accumulated Depreciation - Store Equipment Accounts Payable 67,003.00 1,924.00 68,927.00 180 29,900.00 29,900.00 181 8,970.00 498.00 9,468.00 190 14,700.00 14,700.00 191 6,615.00 184.00 6,799.00 200 5,371.00 5,371.00 210 6,732.81 6,732.81 220 1,660.00 1,660.00 230 414.00 414.00 240 80.00 80.00 280 218,000.00 1,191.67 219,191.67 GST Collected PAYG Withholding Payable Superannuation Payable Wages and Salaries Payable Bank Loan Capital Drawings Hire Service Income Lesson Income Discounts Received 310 151,156.00 151,156.00 315 39,024.00 39,024.00 400 127,180.45 127,180.451 410 30,810.00 30,810.00 420 517.46 517.46 430 85.00 85.00 440 Freight Collected Profit on Sale of PPE Advertising 284.18 284.18 600 2,150.00 2,150.00 127.10 605 Bank Charges 127.10 610 900.00 900.00 615 Cleaning Depreciation Discounts Given 35,323.00 3,335.00 38,658.00 620 309.60 309.60 625 Electricity 3,480.50 3,480.50 630 Freight Expense 1,110.53 1,110.53 635 Insurance 4,193.75 381.25 4,575.00 640 Interest Expense 14,002.80 1,191.67 15,194.47 645 2,610.00 2,610.00 650 118.80 118.80 655 163.65 163.651 660 1,812.25 164.75 1,977.00 665 995.00 995.00 Motor Vehicle Expenses Office Supplies Printing and Postage Rates and Taxes Repairs and Maintenance Diving Instruction Charges Staff Amenities Superannuation Telephone Wages and Salaries 670 14,952.73 14,952.73 675 680 685 260.83 260.83 1,404.00 414.00 1,818.00 1,479.60 1,479.50 20,200.00 80.00 20,280.00 568,134.90 668,134.90 5,566.575,566.57 673,155.57 690 673,155.57 Pro Diver INCOME STATEMENT for the period 1 July 20xx to 30 June 20xx INCOME Service Revenue: Hire Service Income 127,166.27 Total Service Revenue Other Income: Total Other Income TOTAL INCOME EXPENSES TOTAL EXPENSES Pro Diver BALANCE SHEET as at 30 June 20XX CURRENT ASSETS TOTAL CURRENT ASSETS NON-CURRENT ASSETS | TOTAL NON-CURRENT ASSETS TOTAL ASSETS CURRENT LIABILITIES TOTAL CURRENT LIABILITIES NON-CURRENT LIABILITIES TOTAL NON-CURRENT LIABILITIES TOTAL LIABILITIES NET ASSETS EQUITY Opening Balance for the year : Drawings TOTAL EQUITY
