Solved

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

Forum|Forum|7 years ago
March 12, 2019
3 replies
23 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?

QuickBooks Desktop

Best answer by lindak1119

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.

L

lindak1119Answer

Level 7

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.

S

Smilynic

Not everything can be recorded in “Sales”! I often have to do General Journal entries due to Asset Sales &/or Purchases! They need the GL entries to be linked to the HST file. It was always linked in DeskTop version so I don’t know why it can’t be the same for online version. So frustrating

R

Rochelley

Level 2

Hello @Smilynic ,

If you are wanting tax entries that are entered on a JE to show up on tax reports, then you cannot just apply a code to a sales or purchase line in a JE. You have to enter the tax account on a separate line and then tab over to the Sales Tax column and enter the correct tax code. This applies to either sales or purchases. See below for example of a purchase:

This behaves exactly as it did in Desktop. If you tried to put a tax code on Line 1, it would not populate in sales tax reports or on the return. Designating the tax account to a separate line on the JE will, as long as the Sales Tax field is mapped to the proper line on the return.

Hope it helps.

All the best,

Rochelley

N

NEVER

Level 1

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

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

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

Level 1

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.

L

lindak1119

Level 7

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.

Sign up

Login with SSO

Let's get you signed in

Login with SSO