cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

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

Accepted Solutions
Community Contributor **

There are specific "forms" provided in accounting softwar...

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.
10 Comments
Community Contributor **

There are specific "forms" provided in accounting softwar...

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.
Not applicable

Thank you, I reversed using a journal entry and re-entere...

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.
Community Contributor **

You're welcome, glad it's sorted out.

You're welcome, glad it's sorted out.
Established Community Backer **

Your Journal entries are not linked to the Sales Tax repo...

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.
Not applicable

Thank you, I figured, so did a Journal Entry correction a...

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

This does not seem to apply - in our situation there are...

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?
Established Community Backer **

While Dividends are Income to you, they are an Expense to...

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.

Community Contributor **

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

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.
Not applicable

GST is Goods and Services.  Interest and dividend income...

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.
Established Community Backer **

It is more likely a case of misapplication of tax codes a...

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