Question: please help me with that transaction table. I attached the given information. Thank you. (right-click to see the numbers clearly and download images of the
please help me with that transaction table. I attached the given information. Thank you. (right-click to see the numbers clearly and download images of the table)







Date Invoice No. Account Lesson Income Freight Collected SALES JOURNAL Post Terms Ref N30 SNOH 10/10, N30 SNOL N30 ALPS June 7 7 19 26 3358 3360 3361 Snow Ski Holidays Snowlink Alpine Sports Hire Service Income 1,002.73 2,016.00 720.00 3,738.73 1,800.00 1,080.00 1,200.00 4,080.00 Page: 10 GST Collected Accounts Receivable 280.27 3,083.00 309.60 3,405.60 192.00 2,112.00 781.87 8,600.60 400 V 410 210V 110V Page: 11 Date Invoice No. Account PURCHASES JOURNAL Terms Post Ref 5/10, N30 SPIH/170 Other Freight Expense Accounts Payable GST Paid (Outlays) 250.18 June 6 23116 2,400.00 101.82 2,752.00 2234 Spida Headgear/Hire Equipment (Cost) Jordan, Mitchell/Ski Instruction Charges The South Face/Hire Equipment (Cost) NZ JORM/670 1,234.55 123.45 1,358.00 26 9457 N30 SOUF/170 1,500.00 50.00 155.00 1,705.00 5,134.55 151.82 528.63 5,815.00 630 140 V 200 Page: 12 Credits Petty Cash Date Account Other CASH PAYMENTS JOURNAL Debits Accounts GST Paid Payable (Outlays) 34.22 960.00 5.73 2,400.00 Discount Received GST Paid (Outlays) June 342.20 Bank Account 376.42 960.00 57.27 63.00 3,042.00 2,400.00 3,042.00 2,614.40 2,752.00 125.09 12.51 26.85 Post Cheque No. Ref 1194 685 1195 JORM PC 655 1196 SKIW 1197 315 1198 SPIH PC 675 1199 645 1200 1201 665 1202 230 1203 610 1204 690 220 BS 605 BS 280 0.72 8.00 4 Telephone 5 Jordan, Mitchell 12 Printing and Postage 12 Skicentral NZ Wholesalers 12 Drawings 14 Spida Headgear 15 Staff Amenities 20 Motor Vehicle Expenses 24 Petty Cash 24 Repairs and Maintenance 25 Superannuation Payable 28 Cleaning 28 Wages and Salaries PAYG Withholding Payable Bank Charges Bank Loan 26.13 80.00 -89.85 32.00 88.00 89.85 352.00 432.00 110.00 10.00 320.00 432.00 100.00 4,600.00 -540.00 14.70 2,000.00 10,474.30 4,060.00 14.70 2,000.00 16,539.37 6,112.00 90.67 0.00 125.09 12.51 200 140 100 420 140 V Credits Accounts Receivable Date Account Hire Service Income Lesson Income GST Collected Other June 288.00 28.80 1,320.00 Debits Post Bank Account Discount Given GST Collected Ref 316.80 SNOH 1,320.00 170 656.00 1,601.60 MOUR 2,160.00 SNOL 3,065.04 309.60 30.961 9,119.44 309.60 30.96 1 Cash Sale #3357 10 Snow Ski Holidays 17 Hire Equipment (Cost) 18 Cash Sale #3359 24 Mountain Lake Resort 28 Snowlink 596.36 59.64 145.60 256.00 1,200.00 2,160.00 3,405.60 6,885.60 544.00 1,200.00 234.04 596.36 100 620 210 400 V 410 V 110V 210 V Page: 20 Credit Date Post Ref Debit 491.00 June 17 GENERAL JOURNAL Description Accumulated Depreciation - Hire Equipment Hire Equipment (Cost) Profit on Sale of PPE (Transfer profit on sale of ex hire equipment to Jack Small) 171 170 440 217.64 273.36 27 200/SOUF 165.00 Accounts Payable/The South Face Hire Equipment (Cost) GST Paid (Outlays) (Adjustment note #9462 from The South Face for the return of hire equipment) 170 140 150.00 15.00 GENERAL LEDGER Name: BANK ACCOUNT Acct No.: 100 Date Details Post Ref Debit Date Details Post Ref Credit June 1 Balance 14,632.20 June Acct No.: 105 Name: PETTY CASH Date Details June 1 Balance Post Ref Debit Date Details Post Ref Credit 200.00 Name: ACCOUNTS RECEIVABLE Date Details Acct No.: 110 Credit Post Ref Debit Date Details Post Ref June 1 Balance 5,760.00 June Acct No.: 120 Name: PREPAID INSURANCE Date Details June 1 Balance Post Ref Debit Date Details Post Ref Credit 381.25 Name: PREPAID RATES AND TAXES Date Details June 1 Balance Acct No.: 130 Credit Post Ref Debit Date Details Post Ref 164.75 Name: GST PAID (OUTLAYS) Date Details Acct No.: 140 Credit Post Ref Debit Date Details Post Ref June 1 Balance 1,905.75 June V Acct No.: 160 Name: BUILDINGS AND IMPROVEMENTS (COST) Date Details Post Ref June 1 Balance Date Details Post Ref Credit Debit 350,000.00 Acct No.: 161 Name: ACCUMULATED DEPRECIATION - BLDGS AND IMPROVEMENTS Date Details Post Ref Debit Date Post Ref Details Balance Credit 43,750.00 June 1 Acct No.: 170 Name: HIRE EQUIPMENT (COST) Date Details Post Ref Debit Date Details Post Ref Credit June 1 Balance 108,000.00 June V 1 Name: ACCUMULATED DEPRECIATION - HIRE EQUIPMENT Date Details Post Ref Acct No.: 171 Credit Debit Date Details Post Ref June June 1 Balance 67,500.00 Name: MOTOR VEHICLES (COST) Date Details June 1 Balance Acct No.: 180 Credit Post Ref Debit Date Details Post Ref 29,900.00 Name: ACCUMULATED DEPRECIATION - MOTOR VEHICLES Date Details Post Ref Debit Date Details Post Ref Acct No.: 181 Credit 8,970.00 June 1 Balance Name: STORE EQUIPMENT (COST) Date Details June 1 Balance Acct No.: 190 Credit Post Ref Debit Date Details Post Ref 14,700.00 Acct No.: 191 Name: ACCUMULATED DEPRECIATION - STORE EQUIPMENT Details Post Ref Date Debit Post Ref Credit Date June 1 Details Balance 6,615.00 Name: ACCOUNTS PAYABLE Date Details Acct No.: 200 Credit Post Ref Debit Date Details Post Ref June June V 11 Balance 5,824.00 Name: GST COLLECTED Acct No.: 210 Date Details Post Ref Debit Date Details Post Ref Credit June June 1 1 Balance 5,745.90 V Name: PAYG WITHHOLDING PAYABLE Date Details Post Ref Debit Date Details Post Ref Acct No.: 220 Credit 1,120.00 June 1 Balance 28 Name: SUPERANNUATION PAYABLE Acct No.: 230 Credit Date Details Post Ref Debit Date Details Post Ref June June 1 Balance 432.00 Name: BANK LOAN Acct No.: 280 Credit Date Details Post Ref Debit Date Details Post Ref June 30 CP312 June 1 Balance 220,000.00 Name: CAPITAL Date Details Post Ref Debit Details Post Ref Date June 1 Acct No.: 310 Credit 151,156.00 Balance Name: DRAWINGS Acct No.: 315 Credit Date Post Ref Debit Date Details Post Ref Details Balance June 1 36,000.00 Name: HIRE SERVICE INCOME Acct No.: 400 Date Details Post Ref Debit Date Details Post Ref Credit June 1 Balance 122,880.00 Name: LESSON INCOME Acct No.: 410 Date Details Post Ref Debit Date Details Post Ref Credit June 1 Balance 25,530.00 V Name: DISCOUNTS RECEIVED Acct No.: 420 Credit Date Details Post Ref Debit Details Post Ref Date 11 June Balance 392.10 Name: FREIGHT COLLECTED Date Details Post Ref Debit Post Ref Date 1 Details Balance Acct No.: 430 Credit 85.00 June Acct No.: 440 Name: PROFIT ON SALE OF PPE Date Details Post Ref Debit Date Details Post Ref Credit June Acct No.: 600 Name: ADVERTISING Date Details June 1 Balance Post Ref Debit Date Details Post Ref Credit 2,150.00 Name: BANK CHARGES Date Details June 11 Balance Acct No.: 605 Credit Post Ref Debit Date Details Post Ref 112.40 30 Name: CLEANING Acct No.: 610 Details Post Ref Debit Date Details Post Ref Credit Date 1 June Balance 800.00 Name: DEPRECIATION Date Details June 1 Balance Acct No.: 615 Credit Post Ref Debit Date Details Post Ref 35,323.00 Name: DISCOUNTS GIVEN Acct No.: 620 Date Details Post Ref Debit Date Details Post Ref Credit June Name: ELECTRICITY Date Details June 1 Balance Acct No.: 625 Credit Post Ref Debit Date Details Post Ref 3,480.50 Name: FREIGHT EXPENSE Acct No.: 630 Date Post Ref Debit Date Details Post Ref Credit Details Balance June 1 962.35 Name: INSURANCE Date Details June 1 Balance Acct No.: 635 Credit Post Ref Debit Date Details Post Ref 4,193.75 Name: INTEREST EXPENSE Acct No.: 640 Post Ref Debit Date Details Post Ref Credit Date June 1 Details Balance 14,002.80 Acct No.: 645 Name: MOTOR VEHICLE EXPENSES Date Details June 1 Balance Post Ref Debit Date Details Post Ref Credit 2,530.00 Name: OFFICE SUPPLIES Acct No.: 650 Date Details Post Ref Debit Date Details Post Ref Credit June 1 Balance 118.80 Acct No.: 655 Name: PRINTING AND POSTAGE Date Details June 1 Balance Post Ref Debit Date Details Post Ref Credit 109.10 Acct No.: 660 Name: RATES AND TAXES Date Details June 1 Balance Post Ref Debit Date Details Post Ref Credit 1,812.25 Name: REPAIRS AND MAINTENANCE Acct No.: 665 Date Details Post Ref Debit Date Details Post Ref Credit June 1 Balance 675.00 Name: SKI INSTRUCTION CHARGES Date Details June 1 Balance Acct No.: 670 Credit Post Ref Debit Date Details Post Ref 13,710.00 Name: STAFF AMENITIES Acct No.: 675 Credit Details Post Ref Debit Date Details Post Ref Date June 1 Balance 234.70 Name: SUPERANNUATION Date Details June 1 Balance Acct No.: 680 Credit Post Ref Debit Date Details Post Ref 1,404.00 Name: TELEPHONE Acct No.: 685 Date Details Post Ref Debit Date Details Post Ref Credit June 1 Balance 1,137.40 Acct No.: 690 Name: WAGES AND SALARIES Date Details June 1 Balance Post Ref Debit Date Details Post Ref Credit 15,600.00 Date Invoice No. Account Lesson Income Freight Collected SALES JOURNAL Post Terms Ref N30 SNOH 10/10, N30 SNOL N30 ALPS June 7 7 19 26 3358 3360 3361 Snow Ski Holidays Snowlink Alpine Sports Hire Service Income 1,002.73 2,016.00 720.00 3,738.73 1,800.00 1,080.00 1,200.00 4,080.00 Page: 10 GST Collected Accounts Receivable 280.27 3,083.00 309.60 3,405.60 192.00 2,112.00 781.87 8,600.60 400 V 410 210V 110V Page: 11 Date Invoice No. Account PURCHASES JOURNAL Terms Post Ref 5/10, N30 SPIH/170 Other Freight Expense Accounts Payable GST Paid (Outlays) 250.18 June 6 23116 2,400.00 101.82 2,752.00 2234 Spida Headgear/Hire Equipment (Cost) Jordan, Mitchell/Ski Instruction Charges The South Face/Hire Equipment (Cost) NZ JORM/670 1,234.55 123.45 1,358.00 26 9457 N30 SOUF/170 1,500.00 50.00 155.00 1,705.00 5,134.55 151.82 528.63 5,815.00 630 140 V 200 Page: 12 Credits Petty Cash Date Account Other CASH PAYMENTS JOURNAL Debits Accounts GST Paid Payable (Outlays) 34.22 960.00 5.73 2,400.00 Discount Received GST Paid (Outlays) June 342.20 Bank Account 376.42 960.00 57.27 63.00 3,042.00 2,400.00 3,042.00 2,614.40 2,752.00 125.09 12.51 26.85 Post Cheque No. Ref 1194 685 1195 JORM PC 655 1196 SKIW 1197 315 1198 SPIH PC 675 1199 645 1200 1201 665 1202 230 1203 610 1204 690 220 BS 605 BS 280 0.72 8.00 4 Telephone 5 Jordan, Mitchell 12 Printing and Postage 12 Skicentral NZ Wholesalers 12 Drawings 14 Spida Headgear 15 Staff Amenities 20 Motor Vehicle Expenses 24 Petty Cash 24 Repairs and Maintenance 25 Superannuation Payable 28 Cleaning 28 Wages and Salaries PAYG Withholding Payable Bank Charges Bank Loan 26.13 80.00 -89.85 32.00 88.00 89.85 352.00 432.00 110.00 10.00 320.00 432.00 100.00 4,600.00 -540.00 14.70 2,000.00 10,474.30 4,060.00 14.70 2,000.00 16,539.37 6,112.00 90.67 0.00 125.09 12.51 200 140 100 420 140 V Credits Accounts Receivable Date Account Hire Service Income Lesson Income GST Collected Other June 288.00 28.80 1,320.00 Debits Post Bank Account Discount Given GST Collected Ref 316.80 SNOH 1,320.00 170 656.00 1,601.60 MOUR 2,160.00 SNOL 3,065.04 309.60 30.961 9,119.44 309.60 30.96 1 Cash Sale #3357 10 Snow Ski Holidays 17 Hire Equipment (Cost) 18 Cash Sale #3359 24 Mountain Lake Resort 28 Snowlink 596.36 59.64 145.60 256.00 1,200.00 2,160.00 3,405.60 6,885.60 544.00 1,200.00 234.04 596.36 100 620 210 400 V 410 V 110V 210 V Page: 20 Credit Date Post Ref Debit 491.00 June 17 GENERAL JOURNAL Description Accumulated Depreciation - Hire Equipment Hire Equipment (Cost) Profit on Sale of PPE (Transfer profit on sale of ex hire equipment to Jack Small) 171 170 440 217.64 273.36 27 200/SOUF 165.00 Accounts Payable/The South Face Hire Equipment (Cost) GST Paid (Outlays) (Adjustment note #9462 from The South Face for the return of hire equipment) 170 140 150.00 15.00 GENERAL LEDGER Name: BANK ACCOUNT Acct No.: 100 Date Details Post Ref Debit Date Details Post Ref Credit June 1 Balance 14,632.20 June Acct No.: 105 Name: PETTY CASH Date Details June 1 Balance Post Ref Debit Date Details Post Ref Credit 200.00 Name: ACCOUNTS RECEIVABLE Date Details Acct No.: 110 Credit Post Ref Debit Date Details Post Ref June 1 Balance 5,760.00 June Acct No.: 120 Name: PREPAID INSURANCE Date Details June 1 Balance Post Ref Debit Date Details Post Ref Credit 381.25 Name: PREPAID RATES AND TAXES Date Details June 1 Balance Acct No.: 130 Credit Post Ref Debit Date Details Post Ref 164.75 Name: GST PAID (OUTLAYS) Date Details Acct No.: 140 Credit Post Ref Debit Date Details Post Ref June 1 Balance 1,905.75 June V Acct No.: 160 Name: BUILDINGS AND IMPROVEMENTS (COST) Date Details Post Ref June 1 Balance Date Details Post Ref Credit Debit 350,000.00 Acct No.: 161 Name: ACCUMULATED DEPRECIATION - BLDGS AND IMPROVEMENTS Date Details Post Ref Debit Date Post Ref Details Balance Credit 43,750.00 June 1 Acct No.: 170 Name: HIRE EQUIPMENT (COST) Date Details Post Ref Debit Date Details Post Ref Credit June 1 Balance 108,000.00 June V 1 Name: ACCUMULATED DEPRECIATION - HIRE EQUIPMENT Date Details Post Ref Acct No.: 171 Credit Debit Date Details Post Ref June June 1 Balance 67,500.00 Name: MOTOR VEHICLES (COST) Date Details June 1 Balance Acct No.: 180 Credit Post Ref Debit Date Details Post Ref 29,900.00 Name: ACCUMULATED DEPRECIATION - MOTOR VEHICLES Date Details Post Ref Debit Date Details Post Ref Acct No.: 181 Credit 8,970.00 June 1 Balance Name: STORE EQUIPMENT (COST) Date Details June 1 Balance Acct No.: 190 Credit Post Ref Debit Date Details Post Ref 14,700.00 Acct No.: 191 Name: ACCUMULATED DEPRECIATION - STORE EQUIPMENT Details Post Ref Date Debit Post Ref Credit Date June 1 Details Balance 6,615.00 Name: ACCOUNTS PAYABLE Date Details Acct No.: 200 Credit Post Ref Debit Date Details Post Ref June June V 11 Balance 5,824.00 Name: GST COLLECTED Acct No.: 210 Date Details Post Ref Debit Date Details Post Ref Credit June June 1 1 Balance 5,745.90 V Name: PAYG WITHHOLDING PAYABLE Date Details Post Ref Debit Date Details Post Ref Acct No.: 220 Credit 1,120.00 June 1 Balance 28 Name: SUPERANNUATION PAYABLE Acct No.: 230 Credit Date Details Post Ref Debit Date Details Post Ref June June 1 Balance 432.00 Name: BANK LOAN Acct No.: 280 Credit Date Details Post Ref Debit Date Details Post Ref June 30 CP312 June 1 Balance 220,000.00 Name: CAPITAL Date Details Post Ref Debit Details Post Ref Date June 1 Acct No.: 310 Credit 151,156.00 Balance Name: DRAWINGS Acct No.: 315 Credit Date Post Ref Debit Date Details Post Ref Details Balance June 1 36,000.00 Name: HIRE SERVICE INCOME Acct No.: 400 Date Details Post Ref Debit Date Details Post Ref Credit June 1 Balance 122,880.00 Name: LESSON INCOME Acct No.: 410 Date Details Post Ref Debit Date Details Post Ref Credit June 1 Balance 25,530.00 V Name: DISCOUNTS RECEIVED Acct No.: 420 Credit Date Details Post Ref Debit Details Post Ref Date 11 June Balance 392.10 Name: FREIGHT COLLECTED Date Details Post Ref Debit Post Ref Date 1 Details Balance Acct No.: 430 Credit 85.00 June Acct No.: 440 Name: PROFIT ON SALE OF PPE Date Details Post Ref Debit Date Details Post Ref Credit June Acct No.: 600 Name: ADVERTISING Date Details June 1 Balance Post Ref Debit Date Details Post Ref Credit 2,150.00 Name: BANK CHARGES Date Details June 11 Balance Acct No.: 605 Credit Post Ref Debit Date Details Post Ref 112.40 30 Name: CLEANING Acct No.: 610 Details Post Ref Debit Date Details Post Ref Credit Date 1 June Balance 800.00 Name: DEPRECIATION Date Details June 1 Balance Acct No.: 615 Credit Post Ref Debit Date Details Post Ref 35,323.00 Name: DISCOUNTS GIVEN Acct No.: 620 Date Details Post Ref Debit Date Details Post Ref Credit June Name: ELECTRICITY Date Details June 1 Balance Acct No.: 625 Credit Post Ref Debit Date Details Post Ref 3,480.50 Name: FREIGHT EXPENSE Acct No.: 630 Date Post Ref Debit Date Details Post Ref Credit Details Balance June 1 962.35 Name: INSURANCE Date Details June 1 Balance Acct No.: 635 Credit Post Ref Debit Date Details Post Ref 4,193.75 Name: INTEREST EXPENSE Acct No.: 640 Post Ref Debit Date Details Post Ref Credit Date June 1 Details Balance 14,002.80 Acct No.: 645 Name: MOTOR VEHICLE EXPENSES Date Details June 1 Balance Post Ref Debit Date Details Post Ref Credit 2,530.00 Name: OFFICE SUPPLIES Acct No.: 650 Date Details Post Ref Debit Date Details Post Ref Credit June 1 Balance 118.80 Acct No.: 655 Name: PRINTING AND POSTAGE Date Details June 1 Balance Post Ref Debit Date Details Post Ref Credit 109.10 Acct No.: 660 Name: RATES AND TAXES Date Details June 1 Balance Post Ref Debit Date Details Post Ref Credit 1,812.25 Name: REPAIRS AND MAINTENANCE Acct No.: 665 Date Details Post Ref Debit Date Details Post Ref Credit June 1 Balance 675.00 Name: SKI INSTRUCTION CHARGES Date Details June 1 Balance Acct No.: 670 Credit Post Ref Debit Date Details Post Ref 13,710.00 Name: STAFF AMENITIES Acct No.: 675 Credit Details Post Ref Debit Date Details Post Ref Date June 1 Balance 234.70 Name: SUPERANNUATION Date Details June 1 Balance Acct No.: 680 Credit Post Ref Debit Date Details Post Ref 1,404.00 Name: TELEPHONE Acct No.: 685 Date Details Post Ref Debit Date Details Post Ref Credit June 1 Balance 1,137.40 Acct No.: 690 Name: WAGES AND SALARIES Date Details June 1 Balance Post Ref Debit Date Details Post Ref Credit 15,600.00
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
