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?

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.

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

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: 

• Set up sales tax in QuickBooks Desktop
• Pay and manage sales tax in QuickBooks Desktop
• File your GST return and record tax payment

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

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?

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.

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.

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.