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. The client would like a working copy to support the HST return filed so please complete all work in the excel document. Provide the excel document to the client (i.e .....to me so I can mark it) so they have a copy of the supporting documentation. HIGHSKY COMMERCIAL RENTALS INC. General Ledger ACCT 999 - Suspense For the period Jan 1, 2019 - Dec 31, 2019 DR CR R. Smith 2019-01-01 RBC loan payment 2019-01-01 R. Smith 2019-01-01 R. Smith 2019-01-01 1,973.38 1,344.32 1,998.50 998.50 1,100.00 600.00 1,344.32 T. Paster 2019-01-01 T. Paster 2019-02-01 RBC Loan payment 2019-02-01 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 Loan Proceeds 2019-02-01 20000 C. Fount 2019-02-01 RBC Loan payment 2019-03-01 ABC inc. 2019-03-01 ZEI Inc 2019-03-01 T. Paster 2019-03-01 2019-03-01 Cob Contracting Ready Plumbing 2019-03-01 2019-03-01 ZEI Inc Ready Plumbing 2019-03-01 ZEI Inc 2019-03-01 2019-04-01 Ready Plumbing Ready Plumbing 2019-04-01 R. Smith 2019-04-01 RBC Loan payment 2019-04-01 Insurance 2019-04-01 3,450.81 1,344.32 10,989.25 2,847.60 630.00 12,430.00 6,580.97 2,034.00 1,200.00 2,043.00 1,998.50 1,190.00 2,500.00 1,344.32 221.98 3,152.70 600.00 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 ZEI Inc 2019-04-01 T. Paster 2019-04-01 T. Paster 2019-04-01 ZEI Inc 2019-04-01 2019-04-01 Ready Plumbing Ready Plumbing Cob Contracting 2019-04-01 Insurance 2019-05-01 2019-05-01 2019-05-01 2019-05-01 R. Smith Ready Plumbing RBC Loan payment 2019-05-01 Insurance 2019-05-01 T. Paster 2019-05-01 T. Paster 2019-05-01 2019-05-01 Ready Plumbing Loan Proceeds 2019-05-01 7000 Bank Charges 2019-05-01 457.65 T. Paster 2019-06-01 Personal expense 2019-06-01 ZEI Inc 2019-06-01 RBC Loan payment CRA 2018 taxes 2019-06-01 2019-06-01 2019-06-01 2019-06-01 T. Paster T. Paster ZEI Inc 2019-06-01 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 R. Smith 2019-06-01 R. Smith 2019-06-01 2019-06-01 Cob Contracting Cob Contracting RBC Loan payment 2019-06-01 2019-07-01 T. Paster 2019-07-01 2019-07-01 Personal expense Personal expense 2019-07-01 Loan Proceeds 2019-08-01 500 R. Smith 2019-08-01 1,921.00 Loan Proceeds 2019-08-01 10000 RBC Loan payment 2019-08-01 T. Paster 2019-08-01 1,344.32 600.00 2,825.00 T. Paster 2019-08-01 2019-08-01 Loan Proceeds 4000 2019-09-01 Bank Charges Ready Plumbing Loan Proceeds 1,921.00 3,908.24 2019-09-01 2019-09-01 1000 2019-09-01 RBC Loan payment Cob Contracting Cob Contracting 2019-09-01 2019-09-01 R. Smith 2019-09-01 Cob Contracting 2019-09-01 1,344.32 600.00 17,065.00 8,983.50 15,115.07 17,209.11 2,237.18 1,977.50 4,500.00 2019-09-01 2019-09-01 Ready Plumbing Ready Plumbing Ready Plumbing Ready Plumbing 2019-09-01 2019-09-01 Loan Proceeds 2019-10-01 50000 RBC Loan payment 2019-10-01 ZEI Inc 2019-10-01 2019-10-01 Personal expense R. Smith 2019-10-01 ZEI Inc 2019-10-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 ZEI Inc 2019-10-01 ZEI Inc 2019-10-01 Ready Plumbing 2019-10-01 Cob Contracting 2019-10-01 Loan Proceeds 2019-11-01 20000 RBC Loan payment 2019-11-01 1,344.32 Loan Proceeds 2019-11-01 5000 Personal expense Ready Plumbing Personal expense 2019-11-01 2019-11-01 9,000.00 10,283.00 40,000.00 600.00 2019-11-01 T. Paster 2019-11-01 Loan Proceeds 2019-12-01 10000 Loan Proceeds 2019-12-01 4200 Loan Proceeds 2019-12-01 33000 2019-12-01 2019-12-01 Ready Plumbing RBC Loan payment Ready Plumbing T. Paster 2019-12-01 2,000.00 1,344.32 1,000.00 600.00 19,000.00 1,130.00 2019-12-01 T. Paster 2019-12-01 Bank Charges 2019-12-01 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. The client would like a working copy to support the HST return filed so please complete all work in the excel document. Provide the excel document to the client (i.e .....to me so I can mark it) so they have a copy of the supporting documentation. HIGHSKY COMMERCIAL RENTALS INC. General Ledger ACCT 999 - Suspense For the period Jan 1, 2019 - Dec 31, 2019 DR CR R. Smith 2019-01-01 RBC loan payment 2019-01-01 R. Smith 2019-01-01 R. Smith 2019-01-01 1,973.38 1,344.32 1,998.50 998.50 1,100.00 600.00 1,344.32 T. Paster 2019-01-01 T. Paster 2019-02-01 RBC Loan payment 2019-02-01 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 Loan Proceeds 2019-02-01 20000 C. Fount 2019-02-01 RBC Loan payment 2019-03-01 ABC inc. 2019-03-01 ZEI Inc 2019-03-01 T. Paster 2019-03-01 2019-03-01 Cob Contracting Ready Plumbing 2019-03-01 2019-03-01 ZEI Inc Ready Plumbing 2019-03-01 ZEI Inc 2019-03-01 2019-04-01 Ready Plumbing Ready Plumbing 2019-04-01 R. Smith 2019-04-01 RBC Loan payment 2019-04-01 Insurance 2019-04-01 3,450.81 1,344.32 10,989.25 2,847.60 630.00 12,430.00 6,580.97 2,034.00 1,200.00 2,043.00 1,998.50 1,190.00 2,500.00 1,344.32 221.98 3,152.70 600.00 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 ZEI Inc 2019-04-01 T. Paster 2019-04-01 T. Paster 2019-04-01 ZEI Inc 2019-04-01 2019-04-01 Ready Plumbing Ready Plumbing Cob Contracting 2019-04-01 Insurance 2019-05-01 2019-05-01 2019-05-01 2019-05-01 R. Smith Ready Plumbing RBC Loan payment 2019-05-01 Insurance 2019-05-01 T. Paster 2019-05-01 T. Paster 2019-05-01 2019-05-01 Ready Plumbing Loan Proceeds 2019-05-01 7000 Bank Charges 2019-05-01 457.65 T. Paster 2019-06-01 Personal expense 2019-06-01 ZEI Inc 2019-06-01 RBC Loan payment CRA 2018 taxes 2019-06-01 2019-06-01 2019-06-01 2019-06-01 T. Paster T. Paster ZEI Inc 2019-06-01 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 R. Smith 2019-06-01 R. Smith 2019-06-01 2019-06-01 Cob Contracting Cob Contracting RBC Loan payment 2019-06-01 2019-07-01 T. Paster 2019-07-01 2019-07-01 Personal expense Personal expense 2019-07-01 Loan Proceeds 2019-08-01 500 R. Smith 2019-08-01 1,921.00 Loan Proceeds 2019-08-01 10000 RBC Loan payment 2019-08-01 T. Paster 2019-08-01 1,344.32 600.00 2,825.00 T. Paster 2019-08-01 2019-08-01 Loan Proceeds 4000 2019-09-01 Bank Charges Ready Plumbing Loan Proceeds 1,921.00 3,908.24 2019-09-01 2019-09-01 1000 2019-09-01 RBC Loan payment Cob Contracting Cob Contracting 2019-09-01 2019-09-01 R. Smith 2019-09-01 Cob Contracting 2019-09-01 1,344.32 600.00 17,065.00 8,983.50 15,115.07 17,209.11 2,237.18 1,977.50 4,500.00 2019-09-01 2019-09-01 Ready Plumbing Ready Plumbing Ready Plumbing Ready Plumbing 2019-09-01 2019-09-01 Loan Proceeds 2019-10-01 50000 RBC Loan payment 2019-10-01 ZEI Inc 2019-10-01 2019-10-01 Personal expense R. Smith 2019-10-01 ZEI Inc 2019-10-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 ZEI Inc 2019-10-01 ZEI Inc 2019-10-01 Ready Plumbing 2019-10-01 Cob Contracting 2019-10-01 Loan Proceeds 2019-11-01 20000 RBC Loan payment 2019-11-01 1,344.32 Loan Proceeds 2019-11-01 5000 Personal expense Ready Plumbing Personal expense 2019-11-01 2019-11-01 9,000.00 10,283.00 40,000.00 600.00 2019-11-01 T. Paster 2019-11-01 Loan Proceeds 2019-12-01 10000 Loan Proceeds 2019-12-01 4200 Loan Proceeds 2019-12-01 33000 2019-12-01 2019-12-01 Ready Plumbing RBC Loan payment Ready Plumbing T. Paster 2019-12-01 2,000.00 1,344.32 1,000.00 600.00 19,000.00 1,130.00 2019-12-01 T. Paster 2019-12-01 Bank Charges 2019-12-01