ashley s said:

When I remit HST I normally print off an Income Statement and use our Total Sales Revenue as line 101

I use the line on the Income Statement that says Total Revenue because the GST34 form indicates on line 101, "Enter your total sales and other revenue".  When you look at one sales account in the General Ledger, that is all you are getting is the entries and total for one account.  Even if you are using the correct date range, your income statement is usually made up of more than one revenue account, especially if you have a balance in that time period for your CEWS.

If the CRA audits your HST returns, you may have a problem if you report something different than what they are expecting or finding.  I've been through HST audits with several clients and did not have any major concerns and normally no questions about revenue reported.  But I always use Total Revenue.

The only time I was questioned was in the first period of a new company that was requesting a large refund.  It took a few weeks to go through that audit and they asked for followup information several times.  They questioned Sales in Canada vs. Sales in the US but never questioned the application of GST on sales and shipments from Ontario to BC or HST @ 15% for sales and shipments to PEI.  In fact she seemed surprised we did that correctly.  They only wanted proof that the US sales were actually shipped out of the country.  This isn't specific to your issue, just an example of some of the types of things the CRA will ask for during an audit.

I know several people who have told me they only use the Sales dollars like you did, and when using the Intuit products, that is what the Sales Tax Reporting system gives you.  In my opinion, the report in QBD and QBO is wrong and I always change it to the amount on the Income Statement when I file (and that will include any subsidies during the period, interest income, freight income, reductions for customer discounts and short payments, etc. if applicable).

At our accounting practice, we have seen more questions over the past few years where the 'sales and total revenue' according to the GST/HST return does not equal the revenue totals according to the corporate income tax return.  There are, of course, times when 'sales and other revenue' for GST/HST will be different from total revenue for income tax, but we've made a habit of identifying the differences just to be comfortable that we're on the right track.

As Richard pointed out, the GST/HST return doesn't ask for 'sales', it asks for 'sales and total revenue' - so yes, you would include CEWS subsidy revenue on that line.  If you're taking the option to divide your revenue between GST/HST'able and non-GST/HSTable on your return, the CEWS would, of course, go on the non-GST/HST'able line so as to not trigger more frequent reporting.

You should also remember that there are times when your 'sales and other revenue' for GST/HST purposes will be higher than the total you get when adding all of the revenue lines on your income statement together.  The most obvious one is when you sell a piece of equipment.  The entire selling price is 'sales and other revenue' for GST/HST purposes, but if you sold the equipment at a loss, it will show on the income statement as 'loss on sale of capital asset', not a revenue item at all.

I'm new to Sage 50 and found a Revenue Synopsis that seems to have the revenue info I need for HST reporting. 

From the Reports Menu on the top bar, Forecast & Analysis - Analysis - Revenue Synopsis.

This report shows all revenue as well as the hst collected during the period you enter.   I believe it has everything I need and the hst amount reported here is the same as the TB and G/L for the same period.