Shopify reporting county level taxes on multiple lines on new report?

Topic summary

A Shopify merchant is experiencing issues with the platform’s redesigned sales tax reports, where county-level taxes are inexplicably split across multiple rows without clear jurisdiction labels.

Key Problems Identified:

  • Individual counties (Albany, Broome, Greene in New York) appear on duplicate lines
  • Some entries show incorrect tax rates that don’t match any actual district rates
  • The splitting doesn’t correspond to cities or known sub-districts

Suspected Cause:
The merchant theorizes that transactions processed before and after a Shopify system update may have been tagged differently, causing the platform to treat identical jurisdictions as separate entities in reporting.

User Frustration:

  • The new report requires manual consolidation and reverse-engineering to extract needed data (gross sales by county)
  • A task taking 5 minutes with other POS systems now requires multiple hours
  • The merchant questions whether this is a bug or intentional design

Shopify Response:
A support representative acknowledged the post and suggested filing a support request for detailed account investigation if the user believes it’s a bug, while providing links to general US tax reference resources.

Summarized with AI on November 11. AI used: claude-sonnet-4-5-20250929.

Has anyone else seen the new (terrible) sales tax reports dividing individual counties into multiple rows, usually without a jurisdiction-- for some reason? Is there a reason? Its not cities, as they are already separated. Some of them also have the wrong tax rates (like the jurisdictions match, but the rates do not)-- in fact a couple have rates that no district in New York have. Does anyone understand what’s happening here? Like, I have two lines for Albany county (NY), for Broome, for Greene, etc… and I dont think any of these counties have sub-districts or city-level taxation. Presumably other states are reported just as poorly? My best guess is that there are a bunch of transactions that didnt get the jurisdiction code-- like, maybe Shopify updated something, and transactions before (or after) the update were tagged/categorized differently and so then Shopify reports them like they are different tax jurisdictions with the same name. That seems the most likely? As theres really no other reason for every county to be seperated into multiple lines…?

At this point Im unsure if Im legitimately asking or venting at what clearly seems like a bug on top of a tax report that somehow got even worse from the old bad one.

Shopify: My god. You took what takes me 5 minutes at my other company with a different POS system into a multi-hour process involving me to manually sum things and unwind your report into something useable. Hire someone who has EVER done sales tax before in their life to program/design your tax reports. My. God. Not only is the new report STILL not providing data I actually need (gross sales on a county level) but you appear to have made it so much harder to reverse engineer to get the data I actually need.

APP Makers: Go away. Im not paying you $50-100 a month to make a report that doesnt f****** s*** just because Shopify cant be bothered.

Hi there, @msaltzman .

Thanks for posting your question to the Shopify Community.

The United States does not charge a federal sales tax. Instead, sales tax is calculated according to state, county, and municipality, according to physical or economic nexus. You can find more information in our US Tax Reference resource.

If you believe there is a bug and would like our team to take a more detailed look into your account, you can connect with us via the Shopify Help Center by creating a support request.