Skip to main content
June 25, 2019
Question

Can you change the accounts that the sales tax posts to? all my GST is posting to GST Payable, I would like it to post to GST Collected and GST paid.

  • June 25, 2019
  • 2 replies
  • 0 views
Original commenter did not share additional details

2 replies

June 25, 2019

Hello,

 

Recording your sales tax accurately is important for your business. The great news is that QuickBooks Online offers a sales tax feature where you can prepare and file your returns in a few easy steps. That being said, changing the accounts the sales tax posts to is not an integrated feature of the system. I'll make sure to forward your suggestion to my development team for consideration.

 

To know more about how to file sales tax with QuickBooks Online, check this community article.

 

Feel free to reach out if you need any help.

March 27, 2021

As a user of sage50, I prefer separate  accounts showing GST paid and collected and GST adjustments if required at year end. Also an account for GST instalments. On quickbooks, as it is all integrated, hard to track it. 
I am a new user and have not yet come to the stage of filing GST return as yet. I understand that quickbooks generate the form for filing GST and so does sage50 with an option to use the form. 
I will know more when I come to this function. 
In the meantime, please educate me on this feature and functions and how to use it. 

Rebecca R
March 29, 2021

Hi there @nmotani2,

 

Welcome to the QuickBooks Community! QuickBooks Online makes collecting and filing your sales tax easy and accurate. Once set up, the sales tax module does all the calculations for you and lets you know when your payments are due, ensuring that you file on time. Let me give you a hand with this so you know how the feature works and how the money movement takes place within your accounts.

 

When you set up a provincial sales tax code in the Taxes module, QuickBooks automatically creates some accounts for you in the Chart of Accounts. Depending on your province, these may be slightly different, but generally, you'll see a GST/HST Payable account and GST/HST Suspense account. If you're tracking in BC, for example, you'll also notice a PST Expense (BC) account created. You'll also see a new column on Sales and Expense transactions for Sales Tax. You can select the code that you've added from the dropdown.

 

Once you enter a transaction with a tax code selected, QuickBooks will record the amount of tax collected or paid to your GST/HST Payable account as an Increase or Decrease. When you're ready to file your taxes for the period, you'll navigate to the Taxes tab, then to Sales Tax. You'll choose the period to file, and select Prepare return. The amount that's owed will move from the GST/HST Payable account, to the GST/HST Suspense account until you record the payment or refund. Once recorded, the Suspense account will be cleared. 

 

You can collect and pay taxes in multiple provinces, and even set up your own custom codes if necessary. I'm including some helpful articles below that I hope you'll review to learn more about this process:

 

 

If you'd like further support on this, don't hesitate to reply to this thread. I'm happy to assist you. It's what I'm here for!

Lourdes-Fernandez
March 27, 2021

Good morning tophattfinancial,

I'm sorry to hear your having troubles with your sales tax codes and accounts. Depending on where we are creating the transaction (Banking Tab or manual transaction entry) we want to be mindful of the different GST's available. If you are already in a A/R transaction such as sales receipt or invoice, then it should automatically assign itself to GST Collected.

If we are working in the banking tab section, this is where we want to be super mindful of the tax codes as we want to ensure we pick GST (Sales) rather than GST (Payables).

I would be super curious to see your set up for the Sales Tax Center, and your tax codes to see where exactly this may have happened along the way. The Sales Tax Center is defiantly a good place to start reviewing your set up though. Typically when we initially set up our Sales Tax center and provide the correct information, QuickBooks Online does an amazing job at setting up the Tax codes automatically as it should be.

I'll forward some information in regards to the Sales Tax Center, Tax Codes, in hopes it may help you with what it happening.

Set up and use sales tax in QuickBooks Online
https://quickbooks.intuit.com/learn-support/en-ca/sales-taxes/set-up-and-use-automated-sales-tax-in-quickbooks-online/00/711691

Taxes
https://quickbooks.intuit.com/learn-support/en-ca/taxes/07?product=QuickBooks%20Online

If for whatever you can share some image to help us help you that would be awesome! Feel free to ping me with a @ then my user name :D

Kindest Regards,
Lourdes Fernandez

February 7, 2023

Question, were the creaters of Quickbooks accountants?   This is not the accurate way to record HST.   You need 3 separate accounts.  One being HST Collected on Sales.  Two being HST Paid on Purchases and Three HST Paid/Refund.   When you have one account that this is dumped into, its never a good idea for an auditing.   I have been pulling out my hair wondering why this is all dumped into one GL.  Never in my career of accounting has any company ever recorded information this way.