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 EXPLANATIONS: R. Smith - repairs and mantenance T. Paster - repairs and maintenance C. Fount - repairs and maintenance ABC Inc - professional fees ZEl Inc- repairs and maintenance Cob Contracting - repairs and mantenance Ready Plumbing - repairs and maintenance Sheet1 Sheet1 HIGHSKY COMMERCIAL RENTALS INC. General Ledger ACCT 999 - Suspense For the period Jan 1, 2019 - Dec 31, 2019 EXPLANATIONS: R. Smith - repairs and mantenance T. Paster - repairs and maintenance C. Fount - repairs and maintenance ABC Inc - professional fees ZEl Inc- repairs and maintenance Cob Contracting - repairs and mantenance Ready Plumbing - repairs and maintenance Sheet1 Sheet1