cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Level 1

GST Report Line 101 showing incorrect total, how do I fix?

Our revenue was entered into Quick Books as a journal entry, then the GST was calculated also being entered as a journal entry.  None of these entries are showing on line 101 - Sales and other revenue.  We had a couple NSF's that were also entered as journal entries which do show up on Line 101. Line 103 and Line 106 are correct.  How do I correct Line 101 so that I can upload the report to Rev Canada?
Solved
Best answer 03-11-2019

Best Answers
Highlighted
Level 3

GST Report Line 101 showing incorrect total, how do I fix?

There are specific "forms" provided in accounting software for each type of transaction.  If transactions are recorded by General Journal Entries instead of using the correct forms it is highly likely that many of your reports will be incorrect.  Sales transactions, for example, should be recorded by Invoices or Sales Receipts as impossible said. 

The only way to obtain a correct value on Line 101 of sales tax reports is to delete all your incorrectly-recorded transactions and re-enter them correctly.  Alternatively, for THIS GST return, obtain the correct amounts for each line of the return from other reports (P&L, QuickReports, etc.) and file your return by NETFILE or paper.

Going forward, try to enter transactions correctly so that you may have the option of filing electronically.  Consider consulting a QB ProAdvisor in your area for training.

View solution in original post

11 Comments
Highlighted
Level 3

GST Report Line 101 showing incorrect total, how do I fix?

There are specific "forms" provided in accounting software for each type of transaction.  If transactions are recorded by General Journal Entries instead of using the correct forms it is highly likely that many of your reports will be incorrect.  Sales transactions, for example, should be recorded by Invoices or Sales Receipts as impossible said. 

The only way to obtain a correct value on Line 101 of sales tax reports is to delete all your incorrectly-recorded transactions and re-enter them correctly.  Alternatively, for THIS GST return, obtain the correct amounts for each line of the return from other reports (P&L, QuickReports, etc.) and file your return by NETFILE or paper.

Going forward, try to enter transactions correctly so that you may have the option of filing electronically.  Consider consulting a QB ProAdvisor in your area for training.

View solution in original post

Highlighted
Level 1

GST Report Line 101 showing incorrect total, how do I fix?

Thank you, I reversed using a journal entry and re-entered using the invoice and everything seems to be working correctly.  It was weird that the NSF journal entries did show on Line 101 but the actual income did not.
Highlighted
Level 3

GST Report Line 101 showing incorrect total, how do I fix?

You're welcome, glad it's sorted out.
Highlighted
Level 6

GST Report Line 101 showing incorrect total, how do I fix?

Your Journal entries are not linked to the Sales Tax reports. Line 101 on the sales tax remittance forms comes from the amount invoiced to your Customers using the Sales Receipt or Customer Invoice functions.
Highlighted
Level 1

GST Report Line 101 showing incorrect total, how do I fix?

Thank you, I figured, so did a Journal Entry correction and re-entered as one invoice per GL account.  It seems to work now.
Highlighted
Level 1

GST Report Line 101 showing incorrect total, how do I fix?

This does not seem to apply - in our situation there are no sales just some dividend income and interest income and bank charges this year - but the company is registered.for GST.  The report is picking up the dividends and interest in line 101.  I tried changing the type of account to Other Income - that still does not work, still shows up in line 101.  I had to telefile, could not efile as it was not correct.  Any solutions out there?
Highlighted
Level 6

GST Report Line 101 showing incorrect total, how do I fix?

While Dividends are Income to you, they are an Expense to your business, as are bank charges. Interest earned by your business bank account are the only Income for your business - although I fail to see how Interest could be earned since there are no Sales, hence no Income to deposit.

Highlighted
Level 3

GST Report Line 101 showing incorrect total, how do I fix?

Not quite.
Dividend income is income, income is income.

Anyway, a really simple solution if there really is no HST/GST collected and no Input tax credits:
use NetFile to file a NIL return.
Highlighted
Level 1

GST Report Line 101 showing incorrect total, how do I fix?

GST is Goods and Services.  Interest and dividend income is neither, and GST does not apply.  Perhaps Intuit has a programming glich here - no reason at all for these investment income items to be included on line 101.
Highlighted
Level 6

GST Report Line 101 showing incorrect total, how do I fix?

It is more likely a case of misapplication of tax codes and misuse of items and/or accounts.
Highlighted
Level 1

GST Report Line 101 showing incorrect total, how do I fix?

You can capture sales and taxes collected via journal entry by entering the taxes on the sales line of the journal entry rather than a line on it's own