cancel
Showing results for 
Search instead for 
Did you mean: 
Deadwood Al
Level 4

Create one invoice for multiple items at different sales tax rates?

QBDT

I'm having a mental block (I hope) trying to figure this out.  We are in an environment with multiple sales tax rates 

 - state tax

 - municipal tax

 - tourism tax

 - gross receipts tax

 

It is very common for one customer to purchase a combination of items where some are at one tax rate and others are at another sales tax rate. I am trying to find a way to create one invoice for these items where tax is correctly calculated based on the appropriate rate for each item. I am really hoping that I do not need to generate separate invoices to have the tax correctly calculated. To create multiple invoices would be far more time consuming, potentially confusing, and not at all customer-focused-friendly.

 

I do have each tax rate set up in the system, and I have sales tax groups to calculate and report each tax component. At first I thought that by creating a Tax Code (inside each item data) and inserting the "Rate" that would accomplish what I wanted, but it seems that "Rate" inside the Item data represents the billing rate, not the tax rate. And since there appears to be no connection between the Tax Code and the Sales Tax Group, the Tax Codes I created don't mean anything other than taxable or not taxable.

 

I know that many states have multiple sales tax rates similar to what I am faced with, and likely face the same question / issue I am dealing with, so I am assuming that I am just dense and can't see the simple solution that must be present to allow one invoice to bill multiple items at different tax rates. I need someone to digitally slap me upside my head and tells me what I need to do.

 

Will you please be the person who slaps me upside my head????? Thank you in advance.

Solved
Best answer 3 weeks ago

Best Answers
BigRedConsulting
Community Champion

Create one invoice for multiple items at different sales tax rates?

I see what you're objecting to. I had thought sales tax groups could be entered on the invoice table, but it appears not.

 

I think your case may be somewhat unique to your business type, which seem to have to do with tourism.

 

You list these tax components:

- state tax

- municipal tax

- tourism tax

- gross receipts tax

 

It is very typical for business to have to pay more than one tax, but usually it's something like State & County & City (all location based) and so the entire sale is subject to the same taxes.

 

If for you it is similar, in that the entire sale is subject to a core set of taxes, but parts of the sale area also subject to additional taxes, then you can use my initial solution - but modified.

 

In this case, group all of the line items that are subject to an additional tax, say tourism, together and then add a subtotal and tax to that group.

 

Repeat for any additional special cases on the sale.

 

Then list the regular-taxed items.

 

Then include a sales tax group that includes only the core taxes (say state and city) at the bottom of the invoice for those core taxes.

 

Capture.JPG

 

And, if needed, you can modify the invoice's template so that them tax label in the footer is perhaps clearer, like:

Capture1.JPG

 

View solution in original post

5 Comments 5
Deadwood Al
Level 4

Create one invoice for multiple items at different sales tax rates?

In the QB info entitled "Show multiple sales tax items on an invoice" ... which sounds like it should answer my question, right?? ... well, maybe, maybe not.   

 

Near the end of that response, it says 

 d:To generate a subtotal, enter the subtotal item after entering all taxable items. If you are calculating a tax based on a certain threshold sales amount, add the subtotal item below all the taxable items up to that amount. You can add the remaining taxable items along with the non-taxable items in step f.

e: Enter the appropriate sales tax item directly below the subtotal item to calculate tax on the subtotal amount. Note that using a subtotal item on an invoice does not affect sales or commission reports.

 

Unfortunately, what is expected here is a sales tax item that is already identified in a Sales Tax Group (a combination of the sales tax items that make up the total rate and allow for reporting on each component of the group). QB seems to have ignored the fact that the "group" already exists and instead, now also expect us to create a Sales Tax Item that is an item with the same total as a corresponding group but without the ability to report on the components that make up that total. Why on earth would QB/Intuit ignore something they already created and serves a needed purpose and now demand another item?

 

This response also does not address what will happen if we need two separate subtotals and a different sales tax item rate .... I'm going to try this to see what happens. More to follow.

 

MJoy_D
Moderator

Create one invoice for multiple items at different sales tax rates?

Hello, Al. 

 

I can share some information about creating an invoice with multiple items at different sales tax rates. 

 

The option to create a single invoice with multiple sales tax rates is currently unavailable unless you use the subtotal item and multiple tax items. However, adding this feature would be a great addition to the current features and would benefit other users who also need to add multiple sales tax rates.

 

I invite you to provide input to our developers so that this feature can be added to future releases. Rest assured, I'll do the same on my end.

 

Here's how:

 

  1. From the Help menu, select Send Feedback Online.
  2. Click the Product Suggestion from the dropdown menu.
  3. Fill out the on-screen instructions in the QuickBooks Feedback window.
  4. After that, click Send Feedback.

 

Here's more information about setting up your sales tax items/groups and then assigning them: Set up sales tax in QuickBooks Desktop

 

If you encounter any issues or unexpected results along the way, here are solutions available to resolve common sales tax issues. Check out this article for further guidance: How to resolve common sales tax issues.

 

Should you require further assistance or additional information while setting up your sales tax, feel free to reach out. I'm here to provide guidance and support every step of the way. Have a wonderful day ahead!

BigRedConsulting
Community Champion

Create one invoice for multiple items at different sales tax rates?

To record sales on one invoice that are taxed differently, group the item(s) together that are taxed at one rate, then use a subtotal item if there are multiple items to be taxed, and then use the sales tax item or sales tax group item below the subtotal. Then, for the sales tax item at the bottom of the invoice, use a 0.00% tax item:

Capture.JPG

 

Deadwood Al
Level 4

Create one invoice for multiple items at different sales tax rates?

Thanks for the ressponse, Big Red.  I tried that and while it would work for the invoice, it didn't appear to put the total tax amount in the tax field at the bottom, nor was there an option to use a Sales Tax Group to generate the appropriate tax amount. By forcing users to create an additional Sales Tax Item, the reports to break out the sales tax by component of the total rate is destroyed. True, an accountant could calculate what the totals should have been, but that's another example of QB forcing users to manually do something that the software should be able to do far more quickly and with needed back up documentation. Had QB allowed the Sales Tax Group to be allowed in the line below the Subtotal, it would have worked (theoretically) in generating the sales tax reporting to show the components and the sales that generated each component. 

 

If you actually have the ability to use a Sales Tax Group, as your comment suggests,  how do you do that? In the example you pasted, it appears you are using a Sales Tax Item that is for the total of the Sales Tax Group entry but not broken down into component levels. If I am wrong, please let me know. In your example below, if the 7.9% and the 10% were each made up of 3 components that equalled the 7>9% and 10%, would the sales tax reporting break out the components correctly? I have been under the belief that only a Sales Tax Group would result in the component level reporting. In all the states I am familiar with, the periodic sales tax reports asks for data and totals on each of the components.

BigRedConsulting
Community Champion

Create one invoice for multiple items at different sales tax rates?

I see what you're objecting to. I had thought sales tax groups could be entered on the invoice table, but it appears not.

 

I think your case may be somewhat unique to your business type, which seem to have to do with tourism.

 

You list these tax components:

- state tax

- municipal tax

- tourism tax

- gross receipts tax

 

It is very typical for business to have to pay more than one tax, but usually it's something like State & County & City (all location based) and so the entire sale is subject to the same taxes.

 

If for you it is similar, in that the entire sale is subject to a core set of taxes, but parts of the sale area also subject to additional taxes, then you can use my initial solution - but modified.

 

In this case, group all of the line items that are subject to an additional tax, say tourism, together and then add a subtotal and tax to that group.

 

Repeat for any additional special cases on the sale.

 

Then list the regular-taxed items.

 

Then include a sales tax group that includes only the core taxes (say state and city) at the bottom of the invoice for those core taxes.

 

Capture.JPG

 

And, if needed, you can modify the invoice's template so that them tax label in the footer is perhaps clearer, like:

Capture1.JPG

 

Need to get in touch?

Contact us