Question

1 Approved Answer

Posted on Jul 18, 2024

Attached is an excel document for your use when completing the case assignment. This assignment must be completed in excel. You are required to use

Attached is an excel document for your use when completing the case assignment. This assignment must be completed in excel. You are required to use excel to manipulate the data provided in order to complete the complete HST return which will indicate any HST owing/refund at December 31, 2019.

Attached is the general ledger detail of the suspense account for High Sky Commercial Rentals for the period Jan 1, 2019 to December 31, 2019. The corporation does not have sophisticated accounting records so the bookkeeper records all items to the suspense account and then sends to the companies accountant (you) to complete required government filings. The bookkeeper simply takes each months bank statement and records each bank transaction at the dollar amount that went in and out of the bank. That is, no adjustment has been made for HST. In other words, all items paid which have HST are recorded at the purchase amount plus HST (113%). Also, gross rent deposits for the period was $2,100,000, inclusive of HST.

You have been asked to complete the HST return for the period Jan 1, 2019 to December 31, 2019. Please use the data provided in the excel document and complete the HST return so the client can file the HST return.

image text in transcribed

47% Sat 3:41 PM a Excel File Edit View View Insert Format Format Tools Data Window Window Help AutoSave Ad 2... Home Insert Draw Page Layout Formulas Data Review View Tell me OFF ACCT 3610 EXCEL HST CASE Share Comments Calibri (Body) 11 V - AP Insert v General V [C = = = ab Wrap Text v V qov O DA 2X Delete v @ IN Analyze Data Paste BIU av A. Av HO $ % ) 2 Merge & Center .00 0 V Conditional Format Cell Formatting as Table Styles Sensitivity Sort & Filter Format Find & Select U209 X fx B C D E F G . I J K L M . N 0 P o R R S T T U V 2 HIGHSKY COMMERCIAL RENTALS INC. 3 General Ledger ACCT 999 - Suspense 4 For the period Jan 1, 2019 - Dec 31, 2019 5 6 DR CR 7 8 R. Smith 2019-01-01 1,973.38 9 RBC loan payment 2019-01-01 1,344.32 10 R. Smith 2019-01-01 1,998.50 11 R. Smith 2019-01-01 998.50) 12 T. Paster 2019-01-01 1,100.00 13 T. Paster 2019-02-01 600.00 14 RBC Loan payment 2019-02-01 1,344.32 15 Loan Proceeds 2019-02-01 20000 16 C. Fount 2019-02-01 3,450.81 17 RBC Loan payment 2019-03-01 1,344.32 18 ABC inc. 2019-03-01 10,989.25 19 ZEI Inc 2019-03-01 2,847.60 20 T. Paster 2019-03-01 630.00 21 Cob Contracting 2019-03-01 12,430.00 22 Ready Plumbing 2019-03-01 6,580.97 23 ZEI Inc 2019-03-01 2,034.00 24 Ready Plumbing 2019-03-01 1.200.00 25 ZEI Inc 2019-03-01 2.043.00 26 Ready Plumbing 2019-04-01 1,998.50 27 Ready Plumbing 2019-04-01 1,190.00 28 R. Smith 2019-04-01 2.500.00 29 RBC Loan payment 2019-04-01 1.344.32 30 Insurance 2019-04-01 221.98 31 ZEI Inc 2019-04-01 3,152.70 32 T. Paster 2019-04-01 600.00 22 T Pacter 2010.01.01 9.97225 Sheet1 + EXPLANATIONS: R. Smith - repairs and mantenance T. Paster-repairs and maintenance C. Fount-repairs and maintenance ABC Inc - professional fees ZEI Inc-repairs and maintenance Cob Contracting - repairs and mantenance Ready Plumbing - repairs and maintenance Ready 5 119% NOV 2 55 13 tv AW P T A 47% Sat 3:41 PM a Excel File Edit View View Insert Format Format Tools Data Window Help AutoSave A.C... Home Insert Draw Page Layout Formulas Data Review View Tell me OFF ACCT 3610 EXCEL HST CASE Share Comments Calibri (Body) 11 V Insert v General = = = ab Wrap Text V V 27 ) 2X Delete v @ IN Analyze Data Paste BIU av A. Av v DA Conditional Format Cell Formatting as Table Styles == = $ % ) 2 Merge & Center 60 .00 .00 0 V Sort & Filter Sensitivity Format Find & Select U209 X fx A B D E F G H J K L M N O P O R S U V 2019-04-01 2019-04-01 2019-04-01 2019-04-01 2019-05-01 2019-05-01 2019-05-01 2019-05-01 2019-05-01 2019-05-01 2019-05-01 www.ve 9.972.25 1,169.55 7,000.00 966.15 1,998.50 1,300.00 553.79 1,998.50 1.344.32 734.50 600.00 700.00 2,825.00 2019-05-01 2019-05-01 2019-05-01 2019-05-01 7000 33 T. Paster 34 ZEI Inc 35 Ready Plumbing 36 Ready Plumbing 37 Cob Contracting 38 Insurance 39 R. Smith 40 Ready Plumbing 41 RBC Loan payment 42 Insurance 43 T. Paster 44 T. Paster 45 Ready Plumbing 46 Loan Proceeds 47 Bank Charges 48 T. Paster 49 Personal expense 50 ZEI Inc 51 RBC Loan payment 52 CRA 2018 taxes 53 T. Paster 54 T. Paster 55 ZEI Inc 56 R. Smith 57 R. Smith 58 Cob Contracting 59 Cob Contracting 60 RBC Loan payment 61 T. Paster 62 Personal expense 63 Personal expense 64 Loan Proceeds Sheet1 2019-06-01 2019-06-01 2019-06-01 2019-06-01 2019-06-01 2019-06-01 2019-06-01 2019-06-01 2019-06-01 457.65 1,500.00 500.00 3,955.00 1,344.32 7,937.30 1,080.00 6,215.00 1.981.00 2,800.00 600.00 6,324.70 5,650.00 1,344.32 1,000.00 600.00 15,000.00 2019-06-01 2019-06-01 2019-06-01 2019-07-01 2019-07-01 2019-07-01 2019-07-01 500 2019-08-01 + Ready 3 119% NOV 2 55 13 tv AW P T A 47% Sat 3:41 PM a Excel File Edit View View Insert Format Format Tools Data Window Help AutoSave Ad 2... Home Insert Draw Page Layout Formulas Data Review View Tell me OFF ACCT 3610 EXCEL HST CASE Share Comments Calibri (Body) 11 V Insert v General = = = ab Wrap Text V V qov - 0. 2X Delete v @ IN Analyze Data Paste BI av A. Av v DA Conditional Format Cell Formatting as Table Styles == == $ % ) 2 Merge & Center 60 .00 .00 0 V Sort & Filter Sensitivity Format Find & Select U209 X fx A B D E F G H J K L M N O P Q R R S S U V 63 Personal expense 64 Loan Proceeds 65 R. Smith 66 Loan Proceeds 67 RBC Loan payment 68 T. Paster 69 T. Paster 70 Loan Proceeds 71 Bank Charges 72 Ready Plumbing 73 Loan Proceeds 74 RBC Loan payment 75 Cob Contracting 76 Cob Contracting 77 R. Smith 78 Cob Contracting 79 Ready Plumbing 80 Ready Plumbing 81 Ready Plumbing 82 Ready Plumbing 83 Loan Proceeds 84 RBC Loan payment 85 ZEI Inc 86 Personal expense 87 R. Smith 88 ZEI Inc 89 ZEI Inc 90 ZEI Inc 91 Ready Plumbing 92 Cob Contracting 93 Loan Proceeds 94 RBC Loan payment Sheet1 2019-07-01 15.000.00 2019-08-01 500 2019-08-01 1.921.00 2019-08-01 10000 2019-08-01 1,344.32 2019-08-01 600.00 2019-08-01 2,825.00 2019-08-01 4000 2019-09-01 1,921.00 2019-09-01 3,908.24 2019-09-01 1000 2019-09-01 1,344.32 2019-09-01 600.00 2019-09-01 17.065.00 2019-09-01 8.983.50 2019-09-01 15.115.07 2019-09-01 17,209.11 2019-09-01 2.237.18 2019-09-01 1,977.50 2019-09-01 4,500.00 2019-10-01 50000 2019-10-01 1.344.32 2019-10-01 23.403.43 2019-10-01 20,000.00 2019-10-01 600.00 2019-10-01 737.32 2019-10-01 5,000.00 2019-10-01 700.00 2019-10-01 5,000.00 2019-10-01 4,996.02 2019-11-01 20000 2019-11-01 1.344.32 MOTO + Ready BERBESLAGSORDERE T 1970 NOV 2 55 13 A tv Aw P T A 47% Sat 3:41 PM Q Excel File Edit View View Insert Format Format Tools Data Window Help AutoSave Ad 2... Home Insert Draw Page Layout Formulas Data Review View Tell me OFF ACCT 3610 EXCEL HST CASE Share Comments Calibri (Body) 11 V - A Insert v General = = = ab Wrap Text V V qov O 2X Delete v @ IN Analyze Data Paste v DA Conditional Format Cell Formatting as Table Styles BI 60 av Av == == $ % ) 2 Merge & Center .00 0 V Sort & Filter Sensitivity Format Find & Select U209 X fx B B C D E F G H J K L M N O P 0 R R S T U V - UVUL A - Can IVOOLS 84 RBC Loan payment 85 ZEI Inc 86 Personal expense 87 R. Smith 88 ZEI Inc 89 ZEI Inc 90 ZEI Inc 91 Ready Plumbing 92 Cob Contracting 93 Loan Proceeds 94 RBC Loan payment 95 Loan Proceeds 96 Personal expense 97 Ready Plumbing 98 Personal expense 99 T. Paster 100 Loan Proceeds 101 Loan Proceeds 102 Loan Proceeds 103 Ready Plumbing 104 RBC Loan payment 105 Ready Plumbing 106 T. Paster 107 T. Paster 108 Bank Charges 109 110 111 112 113 114 115 Sheet1 2019-10-01 2019-10-01 2019-10-01 2019-10-01 2019-10-01 2019-10-01 2019-10-01 2019-10-01 2019-10-01 2019-11-01 2019-11-01 2019-11-01 2019-11-01 2019-11-01 2019-11-01 2019-11-01 2019-12-01 1,344.32 23,403.43 20,000.00 600.00 737.32 5,000.00 700.00 5,000.00 4,996.02 20000 1,344.32 5000 9,000.00 10,283.00 40,000.00 600.00 10000 4200 33000 2,000.00 1,344.32 1,000.00 600.00 19,000.00 1,130.00 2019-12-01 2019-12-01 2019-12-01 2019-12-01 2019-12-01 2019-12-01 2019-12-01 2019-12-01 + Ready TI910 NOV 2 55 13 A tv AW P T A 47% Sat 3:41 PM a Excel File Edit View View Insert Format Format Tools Data Window Window Help AutoSave Ad 2... Home Insert Draw Page Layout Formulas Data Review View Tell me OFF ACCT 3610 EXCEL HST CASE Share Comments Calibri (Body) 11 V - AP Insert v General V [C = = = ab Wrap Text v V qov O DA 2X Delete v @ IN Analyze Data Paste BIU av A. Av HO $ % ) 2 Merge & Center .00 0 V Conditional Format Cell Formatting as Table Styles Sensitivity Sort & Filter Format Find & Select U209 X fx B C D E F G . I J K L M . N 0 P o R R S T T U V 2 HIGHSKY COMMERCIAL RENTALS INC. 3 General Ledger ACCT 999 - Suspense 4 For the period Jan 1, 2019 - Dec 31, 2019 5 6 DR CR 7 8 R. Smith 2019-01-01 1,973.38 9 RBC loan payment 2019-01-01 1,344.32 10 R. Smith 2019-01-01 1,998.50 11 R. Smith 2019-01-01 998.50) 12 T. Paster 2019-01-01 1,100.00 13 T. Paster 2019-02-01 600.00 14 RBC Loan payment 2019-02-01 1,344.32 15 Loan Proceeds 2019-02-01 20000 16 C. Fount 2019-02-01 3,450.81 17 RBC Loan payment 2019-03-01 1,344.32 18 ABC inc. 2019-03-01 10,989.25 19 ZEI Inc 2019-03-01 2,847.60 20 T. Paster 2019-03-01 630.00 21 Cob Contracting 2019-03-01 12,430.00 22 Ready Plumbing 2019-03-01 6,580.97 23 ZEI Inc 2019-03-01 2,034.00 24 Ready Plumbing 2019-03-01 1.200.00 25 ZEI Inc 2019-03-01 2.043.00 26 Ready Plumbing 2019-04-01 1,998.50 27 Ready Plumbing 2019-04-01 1,190.00 28 R. Smith 2019-04-01 2.500.00 29 RBC Loan payment 2019-04-01 1.344.32 30 Insurance 2019-04-01 221.98 31 ZEI Inc 2019-04-01 3,152.70 32 T. Paster 2019-04-01 600.00 22 T Pacter 2010.01.01 9.97225 Sheet1 + EXPLANATIONS: R. Smith - repairs and mantenance T. Paster-repairs and maintenance C. Fount-repairs and maintenance ABC Inc - professional fees ZEI Inc-repairs and maintenance Cob Contracting - repairs and mantenance Ready Plumbing - repairs and maintenance Ready 5 119% NOV 2 55 13 tv AW P T A 47% Sat 3:41 PM a Excel File Edit View View Insert Format Format Tools Data Window Help AutoSave A.C... Home Insert Draw Page Layout Formulas Data Review View Tell me OFF ACCT 3610 EXCEL HST CASE Share Comments Calibri (Body) 11 V Insert v General = = = ab Wrap Text V V 27 ) 2X Delete v @ IN Analyze Data Paste BIU av A. Av v DA Conditional Format Cell Formatting as Table Styles == = $ % ) 2 Merge & Center 60 .00 .00 0 V Sort & Filter Sensitivity Format Find & Select U209 X fx A B D E F G H J K L M N O P O R S U V 2019-04-01 2019-04-01 2019-04-01 2019-04-01 2019-05-01 2019-05-01 2019-05-01 2019-05-01 2019-05-01 2019-05-01 2019-05-01 www.ve 9.972.25 1,169.55 7,000.00 966.15 1,998.50 1,300.00 553.79 1,998.50 1.344.32 734.50 600.00 700.00 2,825.00 2019-05-01 2019-05-01 2019-05-01 2019-05-01 7000 33 T. Paster 34 ZEI Inc 35 Ready Plumbing 36 Ready Plumbing 37 Cob Contracting 38 Insurance 39 R. Smith 40 Ready Plumbing 41 RBC Loan payment 42 Insurance 43 T. Paster 44 T. Paster 45 Ready Plumbing 46 Loan Proceeds 47 Bank Charges 48 T. Paster 49 Personal expense 50 ZEI Inc 51 RBC Loan payment 52 CRA 2018 taxes 53 T. Paster 54 T. Paster 55 ZEI Inc 56 R. Smith 57 R. Smith 58 Cob Contracting 59 Cob Contracting 60 RBC Loan payment 61 T. Paster 62 Personal expense 63 Personal expense 64 Loan Proceeds Sheet1 2019-06-01 2019-06-01 2019-06-01 2019-06-01 2019-06-01 2019-06-01 2019-06-01 2019-06-01 2019-06-01 457.65 1,500.00 500.00 3,955.00 1,344.32 7,937.30 1,080.00 6,215.00 1.981.00 2,800.00 600.00 6,324.70 5,650.00 1,344.32 1,000.00 600.00 15,000.00 2019-06-01 2019-06-01 2019-06-01 2019-07-01 2019-07-01 2019-07-01 2019-07-01 500 2019-08-01 + Ready 3 119% NOV 2 55 13 tv AW P T A 47% Sat 3:41 PM a Excel File Edit View View Insert Format Format Tools Data Window Help AutoSave Ad 2... Home Insert Draw Page Layout Formulas Data Review View Tell me OFF ACCT 3610 EXCEL HST CASE Share Comments Calibri (Body) 11 V Insert v General = = = ab Wrap Text V V qov - 0. 2X Delete v @ IN Analyze Data Paste BI av A. Av v DA Conditional Format Cell Formatting as Table Styles == == $ % ) 2 Merge & Center 60 .00 .00 0 V Sort & Filter Sensitivity Format Find & Select U209 X fx A B D E F G H J K L M N O P Q R R S S U V 63 Personal expense 64 Loan Proceeds 65 R. Smith 66 Loan Proceeds 67 RBC Loan payment 68 T. Paster 69 T. Paster 70 Loan Proceeds 71 Bank Charges 72 Ready Plumbing 73 Loan Proceeds 74 RBC Loan payment 75 Cob Contracting 76 Cob Contracting 77 R. Smith 78 Cob Contracting 79 Ready Plumbing 80 Ready Plumbing 81 Ready Plumbing 82 Ready Plumbing 83 Loan Proceeds 84 RBC Loan payment 85 ZEI Inc 86 Personal expense 87 R. Smith 88 ZEI Inc 89 ZEI Inc 90 ZEI Inc 91 Ready Plumbing 92 Cob Contracting 93 Loan Proceeds 94 RBC Loan payment Sheet1 2019-07-01 15.000.00 2019-08-01 500 2019-08-01 1.921.00 2019-08-01 10000 2019-08-01 1,344.32 2019-08-01 600.00 2019-08-01 2,825.00 2019-08-01 4000 2019-09-01 1,921.00 2019-09-01 3,908.24 2019-09-01 1000 2019-09-01 1,344.32 2019-09-01 600.00 2019-09-01 17.065.00 2019-09-01 8.983.50 2019-09-01 15.115.07 2019-09-01 17,209.11 2019-09-01 2.237.18 2019-09-01 1,977.50 2019-09-01 4,500.00 2019-10-01 50000 2019-10-01 1.344.32 2019-10-01 23.403.43 2019-10-01 20,000.00 2019-10-01 600.00 2019-10-01 737.32 2019-10-01 5,000.00 2019-10-01 700.00 2019-10-01 5,000.00 2019-10-01 4,996.02 2019-11-01 20000 2019-11-01 1.344.32 MOTO + Ready BERBESLAGSORDERE T 1970 NOV 2 55 13 A tv Aw P T A 47% Sat 3:41 PM Q Excel File Edit View View Insert Format Format Tools Data Window Help AutoSave Ad 2... Home Insert Draw Page Layout Formulas Data Review View Tell me OFF ACCT 3610 EXCEL HST CASE Share Comments Calibri (Body) 11 V - A Insert v General = = = ab Wrap Text V V qov O 2X Delete v @ IN Analyze Data Paste v DA Conditional Format Cell Formatting as Table Styles BI 60 av Av == == $ % ) 2 Merge & Center .00 0 V Sort & Filter Sensitivity Format Find & Select U209 X fx B B C D E F G H J K L M N O P 0 R R S T U V - UVUL A - Can IVOOLS 84 RBC Loan payment 85 ZEI Inc 86 Personal expense 87 R. Smith 88 ZEI Inc 89 ZEI Inc 90 ZEI Inc 91 Ready Plumbing 92 Cob Contracting 93 Loan Proceeds 94 RBC Loan payment 95 Loan Proceeds 96 Personal expense 97 Ready Plumbing 98 Personal expense 99 T. Paster 100 Loan Proceeds 101 Loan Proceeds 102 Loan Proceeds 103 Ready Plumbing 104 RBC Loan payment 105 Ready Plumbing 106 T. Paster 107 T. Paster 108 Bank Charges 109 110 111 112 113 114 115 Sheet1 2019-10-01 2019-10-01 2019-10-01 2019-10-01 2019-10-01 2019-10-01 2019-10-01 2019-10-01 2019-10-01 2019-11-01 2019-11-01 2019-11-01 2019-11-01 2019-11-01 2019-11-01 2019-11-01 2019-12-01 1,344.32 23,403.43 20,000.00 600.00 737.32 5,000.00 700.00 5,000.00 4,996.02 20000 1,344.32 5000 9,000.00 10,283.00 40,000.00 600.00 10000 4200 33000 2,000.00 1,344.32 1,000.00 600.00 19,000.00 1,130.00 2019-12-01 2019-12-01 2019-12-01 2019-12-01 2019-12-01 2019-12-01 2019-12-01 2019-12-01 + Ready TI910 NOV 2 55 13 A tv AW P T A