Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please pay and record the 13 Contract Staff invoices (including mileages) that have been summarized for (details on an attached page) and record the 4

Please pay and record the 13 Contract Staff invoices (including mileages) that have been summarized for (details on an attached page) and record the 4 payroll cheques including holiday pay (details on an attached page). We are doing the payroll early as we are closing down early for the holidays. Manual Bookkeeping Record the employers EI and CPP liabilities Record the remittance of Payroll Liabilities to the receiver General for November & December (separately) Simply Accounting/ Quick Books Classes only Please remit all payroll deductions to date (November and December) but remit them separately. Cheque numbers 2138 &2139 respectively.

image text in transcribed

image text in transcribed

SUMMARY OF INSTRUCTIONAL HOURS FROM NOVEMBER 20- DECEMBER 15 Instructors Name CHQ TOTAL Hours TOTAL MANUAL USED Sage 50 QuickBooks Travel Expense $ $ (NO DRIVEN GST) 36.00 134 67.00 250 125.00 2121 6 Subcontract TEACHING (INCL GST) 2,520 2,940 2,100 1,680 150 2122 7 $ CHQ AMT 2,556.00 3,007.00 2,225.00 1,743.00 175 2123 5 0 520 2124 4 126 63.00 100 0 2125 8 2126 2127 2128 5 Al Moual ANNE Car BEN Lopez CHRIS Thon Corey Sanders EARL Grey JOE Ofodile MIKE Baker NICK Sanchez MANNY Rai P. BRANSTON POLLY Das NOAH Trevor M. Lasker Arif C. Sessions Run 2129 3,360 2,940 1,680 2,100 1,680 1,680 2,100 3,360 1,680 200 175 100 125 100 100 125 75 4 2130 480 240.00 3,600.00 118 59.00 2,999.00 328 164.00 1,844.00 110 55.00 2,155.00 104 52.00 1,732.00 208 104.00 1,784.00 60 30.00 2,130.00 660 330.00 3,600.00 64 32.00 1,712.00 550 PAYROLL PAY ROLL 660 PAYROLL PAY ROLL 3924 Used 4 2131 5 2132 8 520 2133 4 100 XXX 15 PAYROLL 375 XXX 15 PAYROLL 375 101 -2275 -1,040 0 500 200 November 20, 20XX Dec Purchased Untaught 31/12 Nov 20, 20XX Dec Purchase Balance 31/12 126 2,000 1,000 25 225 160 RECEIVER GENERAL - PAYROLL REMITTANCES CHO NOV DEC CPP TAX CPP TAX BARB Star 60 80 260 60 80 260 CRYSTAL Williams 30 40 125 0 0 0 Bill Bugnay 0 0 0 35 45 135 Arif C. 60 0 2,060 60 0 2,060 M. Lasker 60 0 60 00 2,060 4,515 210 120 2,060 4,505 0 215 Employee Total EMPLOYER SHARE TOTAL 125 210 168 215 175 0 420 288 4,505 430 300 4,515 TOTAL AMOUNT $5,213 $5,245 (#2138) (#2139) Payroll Information (May need to override calculations of Sage 50/QuickBooks) Arif C. BARB Star GROSS 2000 24000 TEACH 6000 41200 CPP 60 720 TAX 2060 24720 TRAV 330 330 DEC TOTAL HOL PAY 80 960 NET 6210 40090 CHO 2134 GROSS 2000 24000 DEC CPP 60 720 80 960 HOL PAY 80 960 TAX 260 3120 NET 1600 19200 CHQ 2135 M. LASKER DEC TOTAL GROSS 2000 24000 TEACH 6000 41200 CPP 60 720 TAX 2060 TRAV 275 275 NET 6155 39155 HOL PAY 80 960 CHO 2136 Bill Bugnay DEC TOTAL 2137 1100 1100 35 35 45 45 135 135 885 885 44 44 24720 SUMMARY OF INSTRUCTIONAL HOURS FROM NOVEMBER 20- DECEMBER 15 Instructors Name CHQ TOTAL Hours TOTAL MANUAL USED Sage 50 QuickBooks Travel Expense $ $ (NO DRIVEN GST) 36.00 134 67.00 250 125.00 2121 6 Subcontract TEACHING (INCL GST) 2,520 2,940 2,100 1,680 150 2122 7 $ CHQ AMT 2,556.00 3,007.00 2,225.00 1,743.00 175 2123 5 0 520 2124 4 126 63.00 100 0 2125 8 2126 2127 2128 5 Al Moual ANNE Car BEN Lopez CHRIS Thon Corey Sanders EARL Grey JOE Ofodile MIKE Baker NICK Sanchez MANNY Rai P. BRANSTON POLLY Das NOAH Trevor M. Lasker Arif C. Sessions Run 2129 3,360 2,940 1,680 2,100 1,680 1,680 2,100 3,360 1,680 200 175 100 125 100 100 125 75 4 2130 480 240.00 3,600.00 118 59.00 2,999.00 328 164.00 1,844.00 110 55.00 2,155.00 104 52.00 1,732.00 208 104.00 1,784.00 60 30.00 2,130.00 660 330.00 3,600.00 64 32.00 1,712.00 550 PAYROLL PAY ROLL 660 PAYROLL PAY ROLL 3924 Used 4 2131 5 2132 8 520 2133 4 100 XXX 15 PAYROLL 375 XXX 15 PAYROLL 375 101 -2275 -1,040 0 500 200 November 20, 20XX Dec Purchased Untaught 31/12 Nov 20, 20XX Dec Purchase Balance 31/12 126 2,000 1,000 25 225 160 RECEIVER GENERAL - PAYROLL REMITTANCES CHO NOV DEC CPP TAX CPP TAX BARB Star 60 80 260 60 80 260 CRYSTAL Williams 30 40 125 0 0 0 Bill Bugnay 0 0 0 35 45 135 Arif C. 60 0 2,060 60 0 2,060 M. Lasker 60 0 60 00 2,060 4,515 210 120 2,060 4,505 0 215 Employee Total EMPLOYER SHARE TOTAL 125 210 168 215 175 0 420 288 4,505 430 300 4,515 TOTAL AMOUNT $5,213 $5,245 (#2138) (#2139) Payroll Information (May need to override calculations of Sage 50/QuickBooks) Arif C. BARB Star GROSS 2000 24000 TEACH 6000 41200 CPP 60 720 TAX 2060 24720 TRAV 330 330 DEC TOTAL HOL PAY 80 960 NET 6210 40090 CHO 2134 GROSS 2000 24000 DEC CPP 60 720 80 960 HOL PAY 80 960 TAX 260 3120 NET 1600 19200 CHQ 2135 M. LASKER DEC TOTAL GROSS 2000 24000 TEACH 6000 41200 CPP 60 720 TAX 2060 TRAV 275 275 NET 6155 39155 HOL PAY 80 960 CHO 2136 Bill Bugnay DEC TOTAL 2137 1100 1100 35 35 45 45 135 135 885 885 44 44 24720

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Multinational Business Finance

Authors: David K. Eiteman, Arthur I. Stonehill, Michael H. Moffett

6th Edition

0201538997, 978-0201538991

More Books

Students also viewed these Finance questions

Question

How does visua lization w ork? (p. 2 80)

Answered: 1 week ago