Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
L
leebrendalee
October 4, 2019
Question

Custom GST

  • October 4, 2019
  • 1 reply
  • 1 view

Hi there, 

 

Thanks for helping me!  I had to create a "custom" GST amount for royalty things etc, has to do with franchisee (s) etc.  Anyway, so I see the 7% on my balance sheet, I went ahead and triple checked everything, sales, expenses, sales etc...and then filed the GST in QB Online only.  ( I have not filed with CRA until I fix this).  So then I zipped over to the balance sheet and the figures were still showing:  7% GST payable (negative amount because its really ITC), and GST payable.  By the way, first time ever using your software, so its very nice so far. LOVE IT.  Anyway, so I thought ok lets go and pay it.  So I paid the GST again only in the books!  Then I forwarded the balance sheet to one day past the payment date and sure enough there is my 7% GST payable still there.  I love the fact that it will actually reduce the amount owing, however, how do I get it into the proper place? This will be ongoing that I will always need to do this, just want to know the best method.  Obviously I can do a JE but wondered what other way.

1 reply

A
Anonymous
October 4, 2019

It's great to see you again in the Community, @leebrendalee.

 

I can help share some insights about filing and paying your GST in QuickBooks. 

 

As long as you've set up GST and created the GST transactions in QBO, you can easily file and pay your tax return. Then you can print a copy and submit it to your tax office.

 

You can refer to this article for more details: File and pay Tax/GST.

 

The tax calculations will automatically flow in your balance sheet as well. You can also open the GST Detail report to view the transactions that are included in your GST return.

 

Let me know if you need anything else or if you have additional questions about your tax return. I'm here to help.

P
PEMARTIN
October 19, 2021

Hi, as Iam using QuickBook Premier Standalone version.

 

Need help on GST filing for SIN.

 

At Tax Agency Report, it will show the following details :-

Sales

Purchases**

Tax on sales

Tax on purchase

 

All figures are correct , except Purchase** the amount included tax code NA / NR.

 

How should i go about it not to include the non taxable amount?

 

P
PEMARTIN
October 19, 2021

Thanks for the prompt reply, @PEMARTIN.

 

I appreciate the steps you've performed to get this worked. I want to help you with your sales tax reporting.

 

When you customised the Tax Agency Report, make sure that you choose Taxable in the drop-down and not the All option. This way, it will show the taxable purchase on the said report. 

 

You can customise the report again and check the filters. Then proceed to file sales tax and verify if the non-taxable purchase is still showing.

 

Also, you can customize the report is by exporting it to Excel and manually editing the file to show the details you need. To export reports to excel, here's how: 

 

  1. Select Reports from the sidebar menu.
  2. Enter the report name in the search bar.
  3. At the top of the report, click the Export icon.
  4. Choose Export to Excel.
  5. Save the file somewhere you can easily find it.

 

You can also check this article for a short video of the steps: Export reports to Excel.

 

Once done customising, you may want to consider memorising the report. Doing so helps you save the current customized settings in QuickBooks Desktop. 

 

Additionally, here's a guide that you can read to help get a detailed look at the taxes you owe to ensure that everything is accurate before you file and pay your sales tax return: 

 

 

Please don't hesitate to reach out to me again if there's anything else I can help you with. I'd be happy to help you out. Take good care, @PEMARTIN.


Hi Joesem, as Iam using QuickBook Premier Standalone version.

 

When you customised the Tax Agency Report, make sure that you choose Taxable in the drop-down and not the All option. This way, it will show the taxable purchase on the said report.  

= Yes, after customised it works but when proceed to file sales tax - it still include the non taxable purchases amount....

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.
Terms & ConditionsAccessibility statement