cancel
Showing results for 
Search instead for 
Did you mean: 
leebrendalee
Level 3

Custom GST

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.

10 Comments 10
Anonymous
Not applicable

Custom GST

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.

PEMARTIN
Returning Member

Custom GST

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?

 

ReymondO
QuickBooks Team

Custom GST

Hi there, @PEMARTIN.

 

The data showing on your Tax Agency report relies on the transactions you've entered in QuickBooks. 

 

If you wish to correct its record, you can open it back and click the amount on the report. This will open the list of transactions that totals its amount. You can review each one of them to locate the discrepancy. 

 

You can also reach out to your accountant for further help in correcting the amount in your Tax Agency report.


For additional resources, here's an article about customizing reports in QuickBooks Desktop

Should you have any follow-up questions or concerns, don't hesitate to post again here in the Community or leave a comment on this thread. Take care and have a good one.

PEMARTIN
Returning Member

Custom GST

Hi Reymondo,

The amount recorded are correct for Sales & Purchases.

I just want the Tax Agency Report to only show all the taxable amount.

 

I did try to customized report function, but selecting only taxable amount and it did worked.

 

But when I proceed to file sales tax - the non taxable purchase amount was included in the purchases again.

Is there any way which i can untick the inclusion of non taxable purchase in Tax Agency Report?

 

Summary - I want to :

Exclude non taxable purchase

Include ZP

Include ZR

Joesem M
QuickBooks Team

Custom GST

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.

PEMARTIN
Returning Member

Custom GST

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....

PEMARTIN
Returning Member

Custom GST

Hi ReymomdO, as Iam using QuickBook Premier 2021 Standalone version.

 

When filing tax return, my Sales Tax Agency (GST in Singapore) is showing Taxable + Non taxable amount?

 

How do in remove the non taxable amount when filing?

 

Rose-A
Moderator

Custom GST

Hi, PEMARTIN. I'm here to help and ensure that your questions are addressed accordingly.

 

For me to be able to provide you with the right issue resolution, could you please tell me where exactly in QuickBooks Desktop you're trying to file your tax return?

 

It would be best if you can send me a screenshot as well. Any additional information would be highly appreciated.

 

Hope you can respond to me on this post so we can work with your concern together. Please know I'm ready to assist further. Have a good one.

PEMARTIN
Returning Member

Custom GST

Hi Rose,

 

Iam using QuickBook Premier 2021 Standalone version.

 

When, Filing Sales Tax (in Singapore), the non taxable amount was capture in the purchase?

 

Refer to attachment.

 

 

LieraMarie_A
QuickBooks Team

Custom GST

Thanks for the additional info, @PEMARTIN

 

Currently, there's no desktop version for Singapore. To clarify, are you using QuickBooks Desktop (QBDT) for Canada?

 

I'd recommend reaching out to our Customer Care Support team. This way, they can take a closer look at your report and check its details. 

 

Here's how:

  1. Head to this link: Contact QuickBooks Desktop support.
  2. Click the Contact Us button.
  3. Select QuickBooks Desktop.
  4. Click Solve issues and error messages.
  5. Choose Common Errors.
  6. In Step 2, select a way to connect with an expert.

 

Additionally, you can check out this article that covers the usual sales tax workflow in QuickBooks Desktop: Manage Sales Tax.

 

Please come by if you need more help with filing sales tax. The Community is always here to help.