cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
PSBoffice
Level 2

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 February 02, 2021

Best Answers
Safari818
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

PSBoffice
Level 2

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

As they are neither an expense or income, I have set mine up to "Equity", there is no Sales Tax consequences.

 

Dividends are:  a sum of money paid rby a company to its shareholders out of its profits (or reserves).

 

View solution in original post

29 Comments 29
Safari818
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.
PSBoffice
Level 2

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.
Safari818
Level 3

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

You're welcome, glad it's sorted out.
impossible
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.
PSBoffice
Level 2

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.
hbruchet
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?
impossible
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.

Safari818
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.
hbruchet
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.
impossible
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.
BMalison
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

susan_new
Level 2

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

I'm in the same situation.  Other income (dividends, interest income) recorded by JE is being captured in Line 101 on my return. I see your comment is over a year old - any solution other than file manually? S

susan_new
Level 2

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

I'm in the same situation.  Other income (dividends, interest income) recorded by JE is being captured in Line 101 on my return. I see your comment is over a year old - any solution other than file manually? S

LeithG
Level 7

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

Hi Susan:

 

Look at the tax indicator; if it includes the word Sales it will show up here e.g. Exempt (Sales), Zero-Rates (Sales), Taxable (Sales).

If you change these indicators to Exempt (Purchase) it will not appear in your sales total.

Kmon20
Level 1

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

HI Susan, 

 

I saw your message and am in the same situation. I was wondering if you ever found a way to fix this issue or if you just had to manually file the return? 

Rebecca R
QuickBooks Team

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

Hi there KMon20,

I'm glad you've turned to the Community for support with using QuickBooks, but in this case, consulting with your accountant or a QuickBooks ProAdvisor is the best course of action. Since you've recorded income using a Journal Entry, it's important that the correct accounts and tax codes are applied to each line to ensure that your tax filing is impacted correctly. This is something an accounting professional can give you guidance on, so let me show you how you can connect with them directly within QBO.

 

If you're working with an accountant already. you can navigate to the My Accountant tab and invite your accountant using their email address. Once they accept the invitation they'll be able to work with you in QuickBooks in order to ensure your income is recorded accurately. If you don't have an accountant just yet, the Find a pro to help button on the same page will take you to our database of QuickBooks-certified accountants, known as ProAdvisors who are more than happy to support you on issues like this using QuickBooks.

 

Don't hesitate to reach out if you have more technical questions related to using QuickBooks Online. I'm happy to assist in whatever way I can.

JoeAveryCPA
Level 1

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

For clarity, dividends paid out are NOT an expense like bank charges.

They are a negative cash flow yes, but not an expense.

Dividends are the distribution of after tax retained earnings.

LeithG
Level 7

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

100% agreed Joe, however, in terms of tax treatment QBO treats items as tax-sales or tax-purchases.  In order to prevent something from showing up in your tax (GST/HST) returns you have to make sure it's not selected as sales, which only leaves purchases.

JoeAveryCPA
Level 1

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

If that's so, how would one keep cash and receivables and long term debt from the HST return? I am by no means an expert in QBO but there must be a better way than calling dividends expenses.

PSBoffice
Level 2

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

As they are neither an expense or income, I have set mine up to "Equity", there is no Sales Tax consequences.

 

Dividends are:  a sum of money paid rby a company to its shareholders out of its profits (or reserves).

 

Smilynic
Level 1

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

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 

Rochelley
Level 8

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

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:

 

Capture Sales Tax on JE's.PNG

 

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

JaneAS
Level 1

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

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.

cmackenz
Level 1

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

I have an app that puts tips from Clover into invoices in QBO (see pix 1).  The tips seem to be getting posted to a liability account called "Clover Tips" and where Sales Tax is indicated as "Exempt".  I find these amounts are ending up on Line 101 of the Sales Tax return that QBO generates (see pix 2).  I thought  "Exempt" meant the sales amounts would not be part of Line 101, yet if I compare what QBO says to put on Line 101 to what shows in the Profit and Loss report for the quarter, I can see that tips are being included for Line 101.  There is an exact match in the difference between what is recommended for Line 101 and what shows on the Profit and Loss report.  Tips are in the liability account and don't show on the Profit and Loss report, as it should be.  Some way to re-configure so that the tips are not included in Line 101 on the Sales Tax return, without manually working out the amount to file and filing manually all the time?

1 -- Tips sent from Clover App to QBO Invoice - Sales Tax Exempt 228.36.png

2 -- Tips on QBO Invoice Sales Tax Exempt - show on Line 101 of Sales Tax - View Summary when preparing Sales Tax return.png

  

Need to get in touch?

Contact us