Tax code for selling items

Hi 360HC,

Welcome to Community!  Having the associated sales tax applied to your transactions is vital, in keeping with government guidelines.  QuickBooks Desktop enables you to set up your sales tax rates, to ensure accurate recording.  I'd be glad to assist!

First and foremost, I recommend updating your QuickBooks product to the latest release.   In addition, I suggest reviewing how your sales tax is set up.  You can assign tax codes to Customers and Suppliers, to save valuable time when creating invoices, estimates, or sales orders.  To learn more about the Sales tax feature and how to set up sales tax codes, click here.

Should you require additional assistance, please don't hesitate to contact us outside of Community.  It would be our pleasure to work with you directly, and ensure you're able to accomplish your QuickBooks goals as soon as possible!

Feel free to reach back out with other questions.  We're always happy to help!

Hi, We have suppliers in Montreal with the TVQ tax. We are not set up for TVQ, so how do we create a custom report to also show the TVQ amount?

We enter the TVQ line item as Tax Exempt. Now we need to create a custom report to show the TVQ as an ATTRIBUTE or another option, but it doesn't populate that amount, it gives us the NET Amount only (price plus 5% GST).

Any help will be appreciated. Thanks.

Hi there, @Vero2022. We'll help you generate a report that shows the TVQ amount inside QuickBooks Desktop (QBDT).

You can run the Transaction Detail report and have it customized to show data from specific account where you've tracked the tax line item you created. We'll be happy to provide the steps below:

1. Access your QuickBooks Desktop company.
2. Go to the Reports tab, and then select Custom Transaction Detail report.
3. Select Custom Dates in the Dates pop-up menu, and then choose a specific period.
4. Click the filters and then see the Account, Entered/Last Modified and its date.
5. Once done, select Apply.

See this page to learn more about customizing a report: Customize reports in QuickBooks Desktop for Mac.

In addition, we've got this article to help you secure a copy of your company file in case you encounter an error: Back up your QuickBooks Desktop for Mac company file.

Thanks for visiting us today, @Vero2022. We've got your back if you need further assistance generating a report or performing tasks inside QuickBooks. Feel free to comment below. Have a good one. 

Hi Kurt,

I have followed the processes, but I can't seem to find the Accountant and Taxes option, nor is there a Customize button anywhere that I can see.  Could you please forward me a print screen shot and or a link so I can then try again.  Thank you!

Hi Kurt,

Attached is the snippet of the transaction - line 2 is the one I need on the custom report as well (Screenshot 2023-12-15 133636).

Currently the report exports the GST tax into the net and it duplicates the rows in my report with the exact same net amount, no TVQ (Screenshot 2023-12-15 1340040).

Thanks!

Hi there Vero2022,

For further assistance with report customization so only the information wanted can appear, I recommend reaching out to the QuickBooks Dekstop support team outside of the Community. They'll be able to analyze both the report itself, as well as how the transactions were created to assist in making sure all appears well on the report. You can reach them using the options provided in the QuickBooks Desktop software support policies

If you have any other questions, feel free to reach out here.