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

Problem filing Receiver General Sales Tax report

Desktop Premier 2019.

 

Line 106 is not connecting to GST codes when entered through Bills/Cheques/Credit Card. Quickbooks is not separating GST from the expense amount and is recording the total expense in the expense account.

 

For example, when a cheque is entered for a vendor, it shows the GST being separate and the amounts are correct, but when you look at the transaction journal it shows $0.00 for GST and applies the full amount to the total expense. 

 

Also, under Chart of Accounts, it doesn't show that it is connected to the GST Payable Account for purchases.

 

As a test, we created new Sales Codes and Sales Items, but had the same issue. 

 

Any insight would be appreciated.

 

Solved
Best answer July 10, 2019

Best Answers
Todd66
Level 2

Problem filing Receiver General Sales Tax report

Don't how, why or when, but I discovered that "Track tax on purchases separately" was turned off on the Receiver General Vendor account.

 

Thanks all for the input and getting me looking in the right places.

View solution in original post

10 Comments 10
JamesM
QuickBooks Team

Problem filing Receiver General Sales Tax report

Hi Todd66,

 

Thanks for providing all the details of what you're experiencing with QuickBooks. It's important you get the support you need so you can get back to business ASAP. Don't worry, I'll be happy to assist you with this. 

 

Have you tried to completely exit out of the program and accessing it again? Feel free to share the troubleshooting steps you've covered on your end. If you're still having issues after uninstalling and reinstalling the program make sure you have a backup copy), I recommend calling our phone support team at 877-772-9158. The hours of operation are 24/7 so you can call at your earliest convenience. One of our knowledgeable agents will be able to share your screen to see what's happening. 

 

In the meantime, let me know if you have questions. I'll be happy to steer you in the right direction. 

impossible
Level 6

Problem filing Receiver General Sales Tax report

I see that you are not using the GST Codes automatically created by QB. You are using a Tax Code G1 - a code I do not see in the Item List and you did not provide a screenshot of your Sales Tax Code list.

The first thing I would do is check to make sure that the Sales Tax is set up correctly: Open your Sales Tax Code list>doubleclick the Tax Code G1>click the Edit tab beside GST on Purchases. Complete the Rate, the Tax Agency and the appropriate Tax Return Line (106 for Purchases) Then, click the Edit tab beside GST on Sales. Tax Return Line 103 for Sales)

 

This must be done for Every Tax Code you create and/or use.

 

The setup should look like the screenshot below.

 

 

Todd66
Level 2

Problem filing Receiver General Sales Tax report

We either exit out of QB or change company files many times a day and this does not resolve the issue.

 

The troubleshooting steps we took are detailed in my post along with images which illustrate the issue. Did you review the images I provided? 

 

We already tried calling support and to be blunt; they were useless. All they did was send a generic article to verify the data. They, too, offered to do a screen share but wanted to charge a fee.

 

impossible
Level 6

Problem filing Receiver General Sales Tax report

No, exiting the program and opening different company files will not solve your issue. Setup is specific to each data file.

Yes, I did see the images. Did you see my image and try the solution provided?

Angelyn_T
QuickBooks Team

Problem filing Receiver General Sales Tax report

Hi there, @Todd66.

 

One possible reason why this happens is because of the sale tax settings. For now, please ensure to check your Sales Tax Center and set up the sales tax correctly. You can check on the steps provided by our Community Backer (impossible) above.

 

Also, make sure to set up the sales tax item and the rate correctly.

 

  1. Go to the List menu and select Item List.
  2. Click on the drop-down arrow beside Item, choose New, then open the New Item window.
  3. From the Type drop-down list, choose Sales Tax Item.
  4. Enter a sales tax name. This name appears as one of the choices in the Tax field on your sales forms.
  5. Enter the sales tax rate or dollar amount. 
  6. If you receive a warning, select OK to confirm that this tax is a fixed amount.
  7. From the Tax Agency drop-down list, choose the sales tax agency that collects this sales tax.
  8. Choose the line of the Sales Tax Return on which to report this sales tax item or choose Tax On Purchases or Tax On Sales. You see these options if: 
    1.  the sales tax return doesn't have a line for this item, (e.g. purchases on a PST return), or
    2. there is no sales tax return selected for this sales tax agency.
          Important: The Tax Return Line options are based on the information in the sales tax agency record.
  9. Select OK.

You may check this article for further details about setting up sales tax in QuickBooks Desktop (QBDT): How to set up sales tax in QuickBooks Desktop.

 

You can also check our help articles for you future reference: Help articles for QuickBooks Desktop.

 

Please feel free to drop a comment if you have further questions about sales taxes, I'll always be here to help you. Wishing you the best!

Todd66
Level 2

Problem filing Receiver General Sales Tax report

@impossible my reply was to @JamesM, not yourself.

 

I reviewed the image you posted and both the QB generated 'G' and our manually created test code 'G1' match your image; 106 and 103, respectively.

 

impossible
Level 6

Problem filing Receiver General Sales Tax report

OK. Please check a couple of other areas: Is there more than one Receiver General account in your COA (including Inactive)? If so, the Sales Tax is possibly directed to the incorrect account. Also please check the Vendor List - include All Vendors. Is there more than one Receiver General Account?
Todd66
Level 2

Problem filing Receiver General Sales Tax report

Don't how, why or when, but I discovered that "Track tax on purchases separately" was turned off on the Receiver General Vendor account.

 

Thanks all for the input and getting me looking in the right places.

VJ AY
Level 1

Problem filing Receiver General Sales Tax report

QB is not letting me save the GST on purchase Please advise
Alessandra_B
QuickBooks Team

Problem filing Receiver General Sales Tax report

Hi there, @VJ AY.

 

Thank you for providing me a screenshot of your concern. Let me provide some details about this and help you further. 

 

When you choose to track your sales and purchases separately, you'll need to select different accounts. 

 

In addition, when you choose to track your sales and purchases in the same account, all you have to click in the Include this tax when billing for expenses checkbox. 

 

This way, all your sales and purchases are tracked under the same account. 

 

You can refer to this article for more information: How to Set Up Sales Tax in QuickBooks Desktop?

 

As always, you can get back to me if you have any other questions or concerns. I’d be happy to help you.

Need to get in touch?

Contact us