Skip to main content
P
PSBoffice
March 12, 2019
Solved

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

  • March 12, 2019
  • 3 replies
  • 0 views
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?
Best answer by arkvalleyinfo
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.

3 replies

A
arkvalleyinfoAnswer
March 12, 2019
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.
P
PSBofficeAuthor
March 12, 2019
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.
N
NEVER
March 12, 2019
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.
P
PSBofficeAuthor
March 12, 2019
Thank you, I figured, so did a Journal Entry correction and re-entered as one invoice per GL account.  It seems to work now.
J
JaneAS
February 27, 2022

I'm having this same problem.  In my case I am entering the sales figures from Shopify as a monthly journal entry.  I have a retail store.  I have many transactions in a month.  I don't understand how you overcome the recording problem with invoicing.

N
NEVER
March 12, 2019

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.

A
arkvalleyinfo
March 12, 2019
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.
Terms & ConditionsAccessibility statement