Two States, Two Tax Rates: Setting Up Square and QuickBooks Online
Serving customers across a state line? See how to structure Square tax rates and QuickBooks Online tracking so year-end reporting splits by state.
Plenty of service businesses sit right on a state line. One side taxes labor, the other does not, and every county seems to set its own rate. When you bill through Square and keep the books in QuickBooks Online, the setup matters more than the software. Here is the arrangement we recommend.
Does a state line mean you need two Square locations?
Usually not. Two locations look like the obvious fix, but Square keeps a separate invoice sequence for each one, so your numbering splits in two. A single location with a well-built tax library does the same job and keeps one clean sequence.
Build every jurisdiction’s rate into your Square tax settings. When you raise an invoice, choose the rate for the county where the work was performed. The list does most of the work for whoever sends the invoices.
How do you tax labor in one state but not the other?
Keep a one-page reference sheet for the counties you serve: the rate, and whether labor is taxable. Square lets you set the tax applied on each invoice, so one service list can serve both states. Turn tax on for the labor line where it applies, and leave it off where it does not.
The manual step is the weak point. Someone will pick the wrong rate eventually, so make the reference sheet part of the invoicing routine rather than tribal knowledge.
Is there still a case for two Square locations?
Yes. If you run crews or counters on both sides, per-location tax defaults cut down mistakes, and Square’s own reporting splits by location automatically. The price is two invoice sequences. Numbering rules generally ask for unique numbers rather than one unbroken run, but confirm that with whoever prepares your state filings before you commit.
How should QuickBooks Online record the split by state?
Turn on location tracking, available on the higher-tier QuickBooks Online plans, and create one location per state. Tag every sale. The profit and loss by location report then shows revenue per state on demand.
Check how the Square connection brings sales across. If it does not carry the location with each sale, review the mapping options in the integration settings. Your bookkeeper can also set the location on imported sales during the monthly close. Classes work just as well if you already use locations for something else.
Where does the collected sales tax end up?
Check the account mapping in the Square integration so collected tax lands in a dedicated liability account. Tax charged in Square does not always flow through QuickBooks Online’s own sales tax center, so treat the Sales Tax Liability report with caution.
With tax in its own account and sales tagged by state, the by-location profit and loss shows revenue and tax collected side by side. Those two numbers are what year-end filings in each state are built from.
Is this a software problem or a tax problem?
Both, in different ways. The software side is what we have described: one tax library, location tags, a dedicated liability account. The tax side, meaning where you must register and file, depends on nexus rules that vary and change. The reports will give you the figures; the filing decisions belong with a tax professional.
A routine that keeps it tidy
Each month, reconcile Square deposits against the bank feed, since the integration is built to match them. Spot check a handful of invoices for the right rate and the right labor treatment. Run the by-location report before you close the month.
Then year end becomes a printout rather than a project. Start with one month: rebuild the tax library, tag that month’s sales by state, and run the report. If it agrees with your Square dashboard, roll the routine forward.