cancel
Showing results for 
Search instead for 
Did you mean: 
E11
Level 1

I need a Sales Tax Report that sorts & totals by the sales tax groups - then by each item that makes up the group. Example: Gwinnettt Cty 6%: GA 4%, Local 1%, Educ 1%

I've set up Sales Tax Groups for each county in Georgia, and I need a report to show the Group Tax and then the tax that make up the group so I can report the breakdown accurately to the state.

State of GA - 4%, Local 1%, Education 1%, Special Purpose 1%, Transportation 1%

Gwinnett County is 6%:  State 4% + Educ 1% + SP 1%

Wilcox County is 8%: State 4% + Local 1% + Educ 1%, SP 1%, Trans 1%

Solved
Best answer December 11, 2018

Best Answers
qbteachmt
Level 15

I need a Sales Tax Report that sorts & totals by the sales tax groups - then by each item that makes up the group. Example: Gwinnettt Cty 6%: GA 4%, Local 1%, Educ 1%

There is nothing that reports on Groups; Group simply is like an envelope or stapler to join things together to get a combined rate. The Sales tax reports are based on agency. You also can run a report such as Sales by Item Summary and remove the Item filter, and Sales Tax items will be listed at the bottom. Or, Sales by Customer Summary, columns by Item Detail, and filter on only the sales tax items.

View solution in original post

12 Comments
sue-craven
Level 1

I need a Sales Tax Report that sorts & totals by the sales tax groups - then by each item that makes up the group. Example: Gwinnettt Cty 6%: GA 4%, Local 1%, Educ 1%

Ellen, i have the same problem now. How have you resolved this?
E11
Level 1

I need a Sales Tax Report that sorts & totals by the sales tax groups - then by each item that makes up the group. Example: Gwinnettt Cty 6%: GA 4%, Local 1%, Educ 1%

I should NOT have set up Sales Tax GROUPS, and just set up each county as a Sales Tax ITEM - with the correct percentage rate that county charges.

Each Sales Tax ITEM then gets paid to the same agency (GA Dept of Revenue).  When I run my sales tax liability report, each county is reported with "Total Sales", "Non-Taxable Sales", & "Taxable Sales".  That is the information I needed to file my GA Sales & Use Tax Report.

If you were in a state where sales tax was paid to different agencies, then GROUPS would be the way to go (at least from my understanding).

Hope this helps!
sue-craven
Level 1

I need a Sales Tax Report that sorts & totals by the sales tax groups - then by each item that makes up the group. Example: Gwinnettt Cty 6%: GA 4%, Local 1%, Educ 1%

OH! I am also in GA. Your way should work for me too!  Can you give me a specific example?  Would Gwinnett be a Sales Tax item at 2%?
E11
Level 1

I need a Sales Tax Report that sorts & totals by the sales tax groups - then by each item that makes up the group. Example: Gwinnettt Cty 6%: GA 4%, Local 1%, Educ 1%

Get a sales tax schedule from the GA Dept of Revenue's web site - <a rel="nofollow" target="_blank" href="http://dor.georgia.gov/documents/sales-tax-rate-chart">http://dor.georgia.gov/documents/sales-tax-ra...> - and list each county as one item "SALES TAX ITEM".  

I used the 3 digit number before each county so it would be easier to sort with the way Georgia does theirs

067 - Gwinnett County 6%
060 - Fulton County - 7%
060A City of Atlanta - 8%
etc. for all 159 counties in Georgia.
sue-craven
Level 1

I need a Sales Tax Report that sorts &amp; totals by the sales tax groups - then by each item that makes up the group. Example: Gwinnettt Cty 6%: GA 4%, Local 1%, Educ 1%

Wow- what a job!  Thank you so much!! I really appreciate your time explaining this to me! Sue
E11
Level 1

I need a Sales Tax Report that sorts &amp; totals by the sales tax groups - then by each item that makes up the group. Example: Gwinnettt Cty 6%: GA 4%, Local 1%, Educ 1%

Glad I could help - Good Luck!
E11
Level 1

I need a Sales Tax Report that sorts &amp; totals by the sales tax groups - then by each item that makes up the group. Example: Gwinnettt Cty 6%: GA 4%, Local 1%, Educ 1%

I added a screen shop of part of my item list of counties with the sales tax charged
qbteachmt
Level 15

I need a Sales Tax Report that sorts &amp; totals by the sales tax groups - then by each item that makes up the group. Example: Gwinnettt Cty 6%: GA 4%, Local 1%, Educ 1%

There is nothing that reports on Groups; Group simply is like an envelope or stapler to join things together to get a combined rate. The Sales tax reports are based on agency. You also can run a report such as Sales by Item Summary and remove the Item filter, and Sales Tax items will be listed at the bottom. Or, Sales by Customer Summary, columns by Item Detail, and filter on only the sales tax items.

View solution in original post

E11
Level 1

I need a Sales Tax Report that sorts &amp; totals by the sales tax groups - then by each item that makes up the group. Example: Gwinnettt Cty 6%: GA 4%, Local 1%, Educ 1%

So would it be easier to just use Sales Tax Items - NOT groups for sales tax?
qbteachmt
Level 15

I need a Sales Tax Report that sorts &amp; totals by the sales tax groups - then by each item that makes up the group. Example: Gwinnettt Cty 6%: GA 4%, Local 1%, Educ 1%

You cannot use Three tax items without putting them in a Group, to get that combined rate.

It isn't an issue of Easier or not. It is an issue of Function. The reporting and the functions all work fine. Think of Group as the "wrapper" that ties a bundle together. Let's take your Educ tax as one example:

That same item might in the Group for each of three counties; you simply Pay that to the tax authority. You owe it because of sales for those three counties. But you Owe that, by itself, to that agency. That is the Function. Your State tax is the same; you owe it because of sales in various counties, but you Owe it to the State agency. You put it in the groups for Functionality.

What is the problem you are having?

AAAADesigns
Level 1

I need a Sales Tax Report that sorts &amp; totals by the sales tax groups - then by each item that makes up the group. Example: Gwinnettt Cty 6%: GA 4%, Local 1%, Educ 1%

Similar problem in Colorado...  We have to collect different taxes for numerous jurisdictions.  For example:

Site 1.  City tax 4.81%, RTD 1%, CFD .1%  State 2.9%  Total 8.81

Site 2.  City tax 1%  RTD 1%  CFD .1% County A Tax .25%  State Tax 2.9%

Site 3.  City tax 2%  RTD 1%  CFD .1%  County A Tax .25%  State Tax 2.9%

Each site is reported separately to the state online, however the common agencies all add up.  I need to report the sales for each Site to the State but don't want to duplicate them.  So I need a report that can show me each sales tax group's totals....

Catherine_B
QuickBooks Team

I need a Sales Tax Report that sorts &amp; totals by the sales tax groups - then by each item that makes up the group. Example: Gwinnettt Cty 6%: GA 4%, Local 1%, Educ 1%

Hello there, AAAADesigns.

 

You can enter the tax rates per site as combined and ensure that you select the correct site on the invoice. Let me show you how: 

 

  1. Go to the Taxes menu and select Sales Tax
  2. At the upper-right, click Sales tax settings.
  3. Click Add rate under Custom rates.
  4. Select the Combined option. 
  5. Enter the site name and each rate under it. 
  6. Click Save.

Do the same steps in creating sites 2 and 3. Just ensure that you give a specific name to each rate let's say RTD- 2, CFD- 1. Then, when you pull up the tax liability report it'll be combined in one agency and separated per rate. You can export the report and separate it per site to Excel.

 

Feel free to use the sales tax article for more details in managing the rates and returns. 

 

Let me know if you have any other questions. I'm just here to help. Take care!

Need to get in touch?

Contact us
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up