Five Ways to Handle Sales Tax Rates in an Online Store, Compared
From a hand-maintained spreadsheet to a fully outsourced compliance service, each approach trades accuracy, effort, and cost differently. Here is an honest look at where each one fits.
Every online store that ships to US customers has to answer the same question on every order: what rate applies here, and on which items? How you answer it is a real decision with real consequences, not a checkbox. A very small seller with nexus in one state and a simple catalog can get by with almost nothing. A seller with nexus in fifteen states, taxable and exempt products, and both direct and marketplace channels cannot. The five approaches below are the ones we see most often, described by what they actually are rather than by any vendor's marketing. We build a rate lookup product ourselves, so we have tried to be candid about where a lookup tool is the wrong answer as well as where it is the right one. The criteria are the ones that tend to matter in practice: how accurate the rate is at the address level, how much work it takes to set up, how much ongoing attention it needs, what the cost looks like as you grow, and whether it covers filing and remittance or only the calculation.
| Option | Rate accuracy at the address level | Setup effort | Ongoing maintenance | Cost profile | Filing and remittance coverage |
|---|---|---|---|---|---|
| Manual rate table in a spreadsheetBest for: A seller with nexus in one or two states, a few hundred orders a month, and a catalog where everything is taxed the same way. | Low. Tables are almost always keyed by state or ZIP code, so addresses in special districts or split ZIPs are charged the wrong combined rate and nobody notices until a customer or an auditor does. | Very low to start. You look up a handful of rates from state websites and enter them into your store's tax settings or a lookup sheet. | High relative to its size. Someone has to check for rate changes each quarter in every state you collect in, and in practice that step is the first thing to be skipped when the business gets busy. | No direct cost. The real cost is the owner's time and the exposure created by stale or imprecise rates, which is invisible until it is not. | None. You prepare returns yourself from your order export, or hand that export to a bookkeeper. |
| Built-in tax settings of an ecommerce platformBest for: A seller on a hosted store platform with nexus in a small number of states who wants something automatic without integrating anything. | Moderate and uneven. Some platforms resolve rates at the address level and update them automatically; others still rely on ZIP-level tables or require you to enter rates yourself. Taxability by product category is often coarse or missing. | Low. You enable collection in the states where you are registered and, where supported, tag products with a tax category. | Low to moderate. Rate updates are usually handled for you, but you still own nexus tracking, product categorization, shipping taxability settings, and exemption handling. | Typically included in the platform subscription for basic calculation, with some platforms charging extra above a transaction volume or for advanced features. | Usually reporting only. The platform can show you what was collected by state, but filing the returns remains your job unless you add a separate service. |
| Address-level rate lookup APIBest for: A store with its own checkout, a custom or headless build, or a marketplace of its own, where the team wants precise rates and full control over how they are applied. | High when the address is validated and the lookup is rooftop-level with effective dates. Accuracy on taxability depends on whether the service exposes product categories or only base rates. | Moderate. A developer integrates the lookup into checkout, maps products to tax categories, and decides how to store the rate and jurisdiction on each order line. | Low for rates, since the provider maintains the jurisdiction data. Nexus decisions, exemption certificates, and reconciliation stay with you. | Typically a monthly subscription or a per-lookup charge that scales with order volume, usually modest compared with the cost of a single rate error multiplied across a year. | Generally none. A lookup service answers the rate question; it does not file returns, although its per-jurisdiction data makes preparing them much easier. |
| Full-service automated complianceBest for: A seller registered in many states, with meaningful volume, who wants calculation, registration, filing, and remittance handled end to end by one system. | High. These services calculate at the address level and maintain both rates and taxability rules, and they are motivated to get it right because they file on the result. | Moderate to high. You connect every sales channel, map your catalog to tax codes, provide registration details for every state, and review the first few filing cycles closely. | Low once running, but not zero. New products need codes, new channels need connecting, nexus alerts need acting on, and notices from states still land in your inbox. | The most expensive option in dollars, usually a platform fee plus a charge per return filed and sometimes per registration, which becomes proportionally reasonable as state count and volume grow. | Complete. Returns are prepared and filed, payments are remitted from your funded account, and many services will handle registrations and respond to routine notices. |
| Outsourced to an accountant or sales tax specialistBest for: A seller with unusual products, exemption-heavy B2B sales, a compliance problem to clean up, or an owner who simply wants a person accountable for the outcome. | Depends entirely on what the professional uses to calculate. A specialist will typically insist you use address-level software at checkout; the professional handles judgment, not the per-order arithmetic. | Moderate. The engagement starts with a nexus study, a review of your catalog and channels, and registration in any states you have missed. | Low for you, since the professional owns the calendar and the returns, but you still have to supply clean sales data on time and answer questions promptly. | Hourly or fixed monthly fees that are usually higher than software alone, with the value concentrated in judgment calls, cleanup projects, and audit defense rather than routine filing. | Complete when included in the engagement, and the only option here that also brings human judgment on taxability questions, voluntary disclosures, and audits. |
- Manual rate table in a spreadsheet: Reasonable as a starting point in a single origin-based home state, and increasingly risky the moment you add a destination-based state with local rates.
- Built-in tax settings of an ecommerce platform: The right default for many small stores; the thing to verify is whether the platform truly resolves rates by street address and how it treats shipping and product categories in each state.
- Address-level rate lookup API: This is the category our own product lives in, so weigh our view accordingly: it is the best fit when calculation accuracy is the bottleneck and the team is comfortable owning the rest of the process.
- Full-service automated compliance: Worth the cost once you are filing in more than a handful of states every month; overkill and often frustrating for a seller with two states and a quarterly schedule.
- Outsourced to an accountant or sales tax specialist: Best paired with good software rather than used instead of it; a professional filing from inaccurate checkout data is still filing inaccurate returns.
Our verdict
For most small and mid-sized online stores the honest answer is a combination rather than a single choice. The rate applied at checkout should come from something that resolves the validated street address to its actual jurisdictions with current effective dates, whether that is a capable platform setting or a lookup API, because that is the decision repeated on every order and the one an audit will sample. Filing can then be handled in whatever way matches your state count: yourself from good per-jurisdiction data when you are in one to three states, through a full-service provider when you are filing monthly in many, or through a professional when the situation involves judgment rather than arithmetic.
The approach to move away from as soon as you can is the spreadsheet keyed by ZIP code. It feels free and it feels under control, and it is neither. The cost shows up as undercollected tax you pay from margin, overcollected tax that annoys customers, and a quarterly chore that quietly stops happening. If you are early and truly in one origin-based state, use your platform's setting and revisit the decision the first time you register somewhere new. If you are already in several destination-based states, the question is not whether to use address-level calculation but which layer above it, filing software or a specialist, fits how you want to spend your time.
Frequently asked questions
Can I just charge one flat rate for the whole state to keep things simple?
Only where the state explicitly allows it. A couple of states offer remote sellers an optional single statewide rate, and origin-based states let in-state sellers use their own location's rate for in-state orders. Everywhere else, a destination-based state expects the combined local rate at the delivery address, and charging a flat average will overcollect in some areas and undercollect in others. Both directions create problems.
If I use a full-service compliance provider, do I still need to understand sales tax?
Yes, at least at the level covered in our guide. The provider automates calculation and filing, but you still decide where to register, how to categorize products, whether a channel is a marketplace, and how to respond when a state notice arrives. Sellers who understand the basics catch configuration errors early; those who do not tend to find them during an audit.
Read the complete guide for the full reasoning behind this comparison.