Import Local Sales Tax Rates by ZIP

The state rate is right and the invoice is still wrong

Most US states let cities, counties and special districts add their own tax. A sale shipped to one ZIP can carry a different total rate from a sale to the next ZIP over.

Adding the local rate to the state rate as one number hides it. The return needs the local tax separately, and the state needs it reported per place.

Local rates change on their own dates. A rate edited in place loses the history of what was charged before.

Why this happens

Local tax is folded into the state rate.
Rates are entered without an effective date, so a change applies to the wrong invoices.
Local rules ignore the state’s treatment of a category, so groceries exempt from state tax still pay city tax.
Rates are imported for a state whose pack part is not installed.

Biznsbook addresses this through Local tax rates by ZIP, effective-dated rules, state taxability when Accounting and Taxation are on. Sales, purchases, POS, Field Service, and Real Estate all ask the same tax engine, so the invoice, the return line, and the ledger read the same posted tax.

A second state, a reseller with a certificate, and a supplier that charged nothing are where a rate table drifts. Making Biznsbook the place that taxes the invoice, keeps the certificate, and builds the return keeps those on the same posted tax.

Step-by-step: Import Local Sales Tax Rates by ZIP

Written for owners, bookkeepers, and finance staff who charge and file sales tax, GST, HST, QST, or PST with Biznsbook Taxation. Biznsbook calculates and reports from your own setup. It does not give tax advice and does not file returns with a tax authority for you.

Install the state first. Install the US pack for the state. Importing local rates is refused when the state’s part of the pack is not installed.
Prepare the CSV. The file has six columns: state, zip, name, level, rate and effective_from. For example: WA, 98101, Seattle, City, 3.85, 2025-04-01. A second row for the same ZIP can add a district tax with its own rate and date.
Choose the level. Level is City, County or District. Each local tax gets its own jurisdiction under the state, so a city and a district on the same ZIP are separate taxes on the invoice and separate amounts on the return.
Paste or upload. Open Local rates and paste the rows or upload the file. Biznsbook creates, per local tax, a jurisdiction, a component filed with the state, a rule, and the ZIP mapping for your company.
Update a rate with a new date. To change a rate, import a row for the same place with the new rate and a later effective date. It closes the earlier rule, so invoices before that date keep the old rate.
Check taxability. Local rules follow the state’s taxability: the local tax copies the state’s treatment of the category. In Washington, groceries are exempt from state tax and so are exempt from the city tax too.
Try a ZIP in the simulator. Open Simulator and try a sale shipped to the ZIP. The result lists the state tax and each local tax, with the rule that applied.

Review results after the first full filing period cycle. Adjust roles, mappings, or approvals where the same exception repeats.

Screen names in this guide match the Taxation tab bar in the product: Overview, Returns, Search, Settings, Packs, Rules, Local rates, Simulator, Registrations, Authorities, Components, Groups, Certificates, Nexus, 1099 / T4A, Provider, Checklist, Audit log, Approvals, and Guide. The tab bar only shows the tabs your permissions allow.

Common mistakes to avoid

Mistake 1: Local tax is folded into the state rate. Repeating this each month usually shows up first in a return line that does not match the ledger, or tax charged in the wrong place.
Mistake 2: Rates are entered without an effective date, so a change applies to the wrong invoices. Repeating this each month usually shows up first in a return line that does not match the ledger, or tax charged in the wrong place.
Mistake 3: Local rules ignore the state’s treatment of a category, so groceries exempt from state tax still pay city tax. Repeating this each month usually shows up first in a return line that does not match the ledger, or tax charged in the wrong place.
Mistake 4: Rates are imported for a state whose pack part is not installed. Repeating this each month usually shows up first in a return line that does not match the ledger, or tax charged in the wrong place.

Note each recurring gap when you review the filing period. Each one should map to a step in this guide or an item on the compliance checklist.

Best practices that hold up as you scale

Install the state first — Install the US pack for the state.
Prepare the CSV — The file has six columns: state, zip, name, level, rate and effective_from.
Choose the level — Level is City, County or District.
Paste or upload — Open Local rates and paste the rows or upload the file.
Update a rate with a new date — To change a rate, import a row for the same place with the new rate and a later effective date.

Teams that keep addresses complete, try a change in the Tax Simulator before switching it on, and file from the return lines rather than a side spreadsheet keep the invoice, the return, and the ledger in step.

How Biznsbook supports this workflow

Local tax rates by ZIP — part of Biznsbook Taxation, which sits on Accounting. Tax can come from tax groups, from jurisdiction rules installed by the Canada or US pack, or from your own Avalara AvaTax or TaxJar account. Whichever method you pick, posted tax lands on invoice tax lines that the dashboard, the return lines, and the settlement journal all read. Posted documents keep their tax when you change the setup later.

effective-dated rules — part of Biznsbook Taxation, which sits on Accounting. Tax can come from tax groups, from jurisdiction rules installed by the Canada or US pack, or from your own Avalara AvaTax or TaxJar account. Whichever method you pick, posted tax lands on invoice tax lines that the dashboard, the return lines, and the settlement journal all read. Posted documents keep their tax when you change the setup later.

state taxability — part of Biznsbook Taxation, which sits on Accounting. Tax can come from tax groups, from jurisdiction rules installed by the Canada or US pack, or from your own Avalara AvaTax or TaxJar account. Whichever method you pick, posted tax lands on invoice tax lines that the dashboard, the return lines, and the settlement journal all read. Posted documents keep their tax when you change the setup later.

The Canada and US tax packs are drafts until a tax adviser reviews them, and rates and taxability must be checked for your business. Rates are effective-dated, and reinstalling a pack keeps rules you edited. Biznsbook prepares returns and contractor figures and exports them; it does not e-file, and it is not tax advice.

Suggested implementation timeline

Week 1: Complete the state or province and postal code on the company, warehouses, and customers, and install the country pack for the places you sell into.
Week 2: Record your registrations, set item tax categories, and try real sales and purchases in the Tax Simulator.
Week 3: Switch Tax Settings to jurisdiction rules, post a few real invoices and purchase bills, and check the tax on each.
Week 4: Create the first filing period, put local tax rates by ZIP to work on real postings, review the return lines against posted tax, and export them for your adviser.
Ongoing: Each filing period, review the compliance checklist and the points under “When importing rates stops being practical” below.

Product page: Taxation. Hub: sales tax and GST guides. Decision: built-in sales tax rules vs Avalara or TaxJar.

What one CSV row creates

Each local tax becomes a jurisdiction of county, city or district level with the state as its parent. A component is created under the state’s authority with the state component’s accounts. A rule is added that follows the state’s taxability, and the ZIP is mapped to that jurisdiction for your company.

When an invoice is taxed, the place resolver adds the ZIP’s local jurisdictions after the country and state. The rules for each then apply, and each local tax is posted as its own line.

Keeping rates current

Local rates change on dates the state announces. Import the new rate with its effective date before that date, and invoices from that day use it. Nothing needs to be deleted, and the history of what applied when stays in the rules.

The Tax Simulator takes a date, so you can check which rate applies on a given day. The rates themselves come from you, so confirm them with the state or your adviser.

Metrics to track monthly

Compliance checklist items by severity
Exemption certificates expiring within 30 days or already expired
States at or approaching their economic nexus threshold
Draft filing periods close to their end date
Recent sales to customers with no address, taxed at your own location

Start with three metrics; trend direction matters more than a single point-in-time snapshot.

Spreadsheet rate table vs Biznsbook Taxation

Compare a typical rate spreadsheet and manual return with the same work in Biznsbook Taxation.

Capability	Manual / Spreadsheet	Biznsbook
Local tax	❌ Folded into one combined rate	✅ Its own jurisdiction, component and rule
Rate change	❌ Edited in place	✅ A later effective date closes the earlier rule
Groceries and clothing	❌ Taxed locally by mistake	✅ Follows the state’s taxability
Return	❌ Local amount estimated	✅ Local line worked out from posted tax
Several taxes on a ZIP	❌ One number	✅ City, county and district kept separate
Checking a place	❌ Look it up again	✅ Try the ZIP in the Tax Simulator

When importing rates stops being practical

Local rates are manageable for one or a few states where you know the ZIPs you ship to. Across many states, the number of local taxes and their changes grows quickly. At that point, compare the built-in rules with connecting your own Avalara AvaTax or TaxJar account, which works out local tax from the address.

Write this into your filing routine, and revisit it when you register in a new province or state or change how tax is calculated.

Frequently asked questions

Does Biznsbook ship official local rate tables?

No. The local rates are yours to maintain. Biznsbook imports the rows you give it. If you sell into many states, an external provider such as Avalara or TaxJar is the alternative.

Which authority are local taxes filed with?

With the state. Each local component sits under the state’s authority and uses the state component’s accounts, so local tax appears on that state’s return.

What happens to invoices before a rate change?

They keep the rate in force on their tax date. A later effective date closes the earlier rule rather than overwriting it, and posted invoices keep the amounts they were posted with.

How is origin sourcing handled for local rates?

Where the US pack sets origin sourcing for a state and the sale stays in that state, the seller’s ZIP is used to find the local taxes.

How this differs by industry

Retail

A store in Seattle imports its city rate and the regional district rate for its ZIP, so counter sales carry state, city and district tax as separate lines.

Wholesale & distribution

A distributor shipping to customers in a dozen ZIPs in one state imports a row per ZIP and level, and the return shows local tax as its own line.

Manufacturing

A manufacturer selling food products into Washington relies on local rules following the state’s taxability, so groceries exempt from state tax are also exempt from city tax.