Complete the following chart on the Journal spreadsheet tab labelled Question VI. You must use formulas...

Transcribed Image Text:

Complete the following chart on the Journal spreadsheet tab labelled "Question VI". You must use formulas to show any calculations within the spreadsheet cells. The first row of the chart has been done for you. If the payable amount is less than the recoverable amount, there will be a refund claim. 5 marks Month HST Payable HST Recoverable Remittance Amount Refund Claim Due Date January $1892.76 $798.45 $1094.31 n/a Feb 15 31 February $1673.58 $967.54 28 March 31 $2167.45 $1688.78 April 30 $715.64 $840.68 May 31 $2183.45 $2568.83 June 30 $8582.45 $7352.58 Complete the following chart on the Journal spreadsheet tab labelled "Question VI". You must use formulas to show any calculations within the spreadsheet cells. The first row of the chart has been done for you. If the payable amount is less than the recoverable amount, there will be a refund claim. 5 marks Month HST Payable HST Recoverable Remittance Amount Refund Claim Due Date January $1892.76 $798.45 $1094.31 n/a Feb 15 31 February $1673.58 $967.54 28 March 31 $2167.45 $1688.78 April 30 $715.64 $840.68 May 31 $2183.45 $2568.83 June 30 $8582.45 $7352.58