Sales Tax Nexus Tracker
For the accountant who currently has a spreadsheet with 45 state thresholds in it and no reliable way of knowing when a client crossed one.
Feed it a sales-by-state export and it scores every state against its economic nexus threshold.
It puts each one in a bucket: triggered, approaching (within 80% of the line, by default), or fine for now.
$49 a month for the firm, all clients, all states. Cancel any day.
Nobody notices the quarter they crossed the line
Economic nexus is not a thing that announces itself. A client sells into Georgia all year, does $40,000, does $70,000, and then has a good November and crosses $100,000, and now they had a registration obligation that started at a date somebody will eventually have to determine.
They didn’t know. You didn’t know, because you look at their sales by state once a year at most, and by then the exposure has been accruing for six months.
The retrospective conversation is the worst one in this job. It’s not “you owe tax.” It’s “you owed tax, from March, and nobody was watching.”
It aggregates per state, then scores each one
- It parses
SALES_CSV. Columns:state,revenue,transactions, matched case and whitespace insensitively, so a messy export still parses. - It aggregates per state. Rows are summed, so an export with one row per month, or even one per transaction, works without you pre-aggregating anything. That is the difference between a five-minute job and an afternoon.
- It scores each state. The threshold comes from
THRESHOLDS_CSVif there’s a row for that state, otherwise from the default ($100,000 revenue, 200 transactions). Triggered means revenue or transaction count has met or exceeded the threshold. Approaching means it’s withinAPPROACH_PCT(default 80%) of either one. Everything else is fine.
The template, the outputs, and the caveat that comes with them
REGISTER_TODO.md: the triggered states, with an action checklist. This is the file you act on and the one you send the client.NEXUS_STATUS.md: the full state-by-state picture, including the approaching ones, which is the list that actually earns the subscription. Knowing a client is at 84% of the Georgia threshold in September is worth ten times more than finding out in March that they crossed it.nexus.csvandnexus.jsonfor the workpapers and for anything downstream.- A 2026 threshold template ships with it, covering the 46 states plus DC that levy a state sales tax, with the common $100,000 / 200-transaction pattern and the well-known variants (California and Texas at $500,000, no transaction test). Alaska, Delaware, Montana, New Hampshire and Oregon are omitted because they have no state-level sales tax, though Alaska’s local-level rules are real and are out of scope.
- The template is a starting point, not an authority. Several states have dropped the 200-transaction test in recent years and more will. Confirm with the state before you register anyone anywhere.
The firm that needs this, and the one that shouldn’t buy it
An accounting or bookkeeping firm with ecommerce, wholesale or multi-state service clients, where somebody has to answer “are we registered where we should be” and currently can’t.
Not for you if you need the model to be exact in every state. It runs a straightforward OR test: revenue or transaction count clears the threshold, so the state is triggered. A few states, New York and Connecticut among them, require both conditions together, and the bundled template approximates those with the OR test. So a client with 250 small transactions into New York and modest revenue can show as triggered when the state’s real rule says otherwise. It overstates, rather than understates, which is the safer direction to be wrong in, and proper AND-test modelling is on the build list. Review any borderline result in those two states against the state’s own rule.
Not for you if you want the vendor to maintain the threshold data for you. That’s a data subscription and it’s a different product at a different price.
What it replaces, and who does it better
Avalara and TaxJar both do nexus monitoring, and both are better at it than this. They maintain the threshold data as a service, so they know when Louisiana changed its rule and you don’t have to. They watch continuously rather than when you remember to run something. And they’ll register the client for you.
That’s real value and if you have a client selling into thirty states with serious volume, they should be on one of those platforms, and we’d say so.
The gap is the client who isn’t there yet. The one doing $600,000 across eleven states, who isn’t going to pay for a compliance platform, and whose accountant is tracking nexus in a spreadsheet that hasn’t been updated since 2023. That client is the one who gets caught, and $49 a month is a price they’ll actually pay.
Your client’s whole sales picture, on your machine
Sales by state is a complete map of where a business does business. It’s read from disk and it stays there. There is no cloud in this product, no ecommerce integration to authorise, and no vendor holding a client’s revenue data.
The report is written under OUTPUT_FOLDER at 0600, with every write path checked against the root, and validate mode checks the config without any file I/O at all.
$49 a month, and the honest maintenance cost
The software is a five-minute setup. The thing you owe it is the thresholds file, and you owe it once a year, because state rules move.
Start with the bundled template, verify the states your clients actually sell into, and keep your own THRESHOLDS_CSV. That’s an hour in January and it’s the difference between a tool you trust and a tool that gives you a confident answer from 2024.
Security and privacy
Handles client sales data (revenue and transaction counts by state). Security is designed in.
Principles
– Local-first. SALES_CSV/THRESHOLDS_CSV are read from disk and never transmitted anywhere; nothing in this tool touches the network. Nothing is uploaded, no telemetry, no cloud dependency.
– Non-destructive. Source CSVs are only read, never modified or deleted.
– Least privilege. Reads SALES_CSV/THRESHOLDS_CSV, writes only under OUTPUT_FOLDER.
Protections implemented (v0.1.0)
– Path-traversal defense — every output filename is sanitized (safeSegment) and every write is checked with assertWithinRoot(), so the report can’t be written outside OUTPUT_FOLDER.
– Fail-fast config validation — clear errors for a missing SALES_CSV/OUTPUT_FOLDER, an out-of-range APPROACH_PCT, or a negative default threshold, before any file is touched. THRESHOLDS_CSV is optional by design; if it’s absent or unreadable the tool falls back to DEFAULT_THRESHOLD and warns rather than failing.
– Restrictive permissions — the generated report (NEXUS_STATUS.md, REGISTER_TODO.md, nexus.csv, nexus.json) is written 0600.
– Defensive parsing — the CSV parser and currency parser never throw on malformed input (missing fields default to empty string, unparseable amounts default to 0); a bad row degrades the analysis rather than crashing it. A blank or non-positive threshold cell is treated as “no override,” not as a $0 threshold that would falsely trigger every state.
– Secrets discipline — .env and generated output//Nexus-Reports/ output are git-ignored; no secrets or client data in the repo.
Distribution / AV trust
Known limitations / roadmap
– Not tax advice. This tool applies a simple, transparent rule to data supplied by the user. It does not verify state threshold figures, does not model AND-tests (e.g. New York, Connecticut require both revenue and transaction count together; this tool’s OR model can overstate exposure for those states), and does not track effective/marketplace-facilitator exceptions. All output must be reviewed by a qualified tax professional before acting on it.
– Thresholds change. State thresholds are amended periodically (several states dropped the 200-transaction test in recent years). The bundled templates/thresholds-2026-template.csv is a starting point, not an authoritative or continuously updated source — verify current figures with each state’s Department of Revenue before relying on them.
– No marketplace-facilitator netting. Revenue/transaction inputs are taken as given; if a state excludes marketplace-facilitated sales from its own nexus count, that adjustment must be made in SALES_CSV before running the tool.
Reporting
Report suspected vulnerabilities privately to the maintainer before public disclosure.
Frequently asked questions about Sales Tax Nexus Tracker
What does the sales tax nexus tracker do, and how does it read a sales-by-state export?
The sales tax nexus tracker reads a client’s sales grouped by state and compares each state’s revenue and transaction count against that state’s economic-nexus threshold. Where a client has crossed a threshold, the tool flags it, because crossing is what creates an obligation to register and collect sales tax in that state. The reader who buys it runs books for clients selling across state lines, the kind of business most at risk of triggering a registration nobody noticed.
Economic nexus is the rule that a state can require a seller to collect its sales tax once the seller’s activity in the state passes a set level of revenue or a number of transactions, even with no physical presence there. Every state sets its own numbers. Tracking dozens of thresholds against a client’s actual sales by state is the work the tool takes over, so a firm is not maintaining that grid by hand.
The workflow has three steps. You import sales grouped by state. You load the state thresholds, and a template comes with the tool so you are not building the grid from scratch. Then the sales tax nexus tracker produces a status report showing where the client has triggered nexus, where they are approaching it, and where they are well clear. Nothing is filed, the tool measures and flags.
Revenue and transaction counts are both checked because states use both. Some set a dollar threshold, some a transaction count, and some either one. The tool compares a client’s figures against each state’s specific test, so a business that is under the dollar limit but over the transaction count still gets flagged in the states where the count alone triggers an obligation.
The output is a nexus status report plus a registration to-do list by state. Instead of a vague worry that a client might owe somewhere, the firm gets a named list of states where the threshold is crossed and registration is due, and a second list of states creeping toward the line. That is the difference between reacting to a state notice and getting ahead of one.
The report the tool builds is also a record worth keeping. IRS Publication 583, Starting a Business and Keeping Records, describes keeping a business’s records of sales in an orderly fashion, and a state-by-state status report is exactly that kind of organized sales record. The sales tax nexus tracker produces it from the same export the firm already holds, so the documentation of where a client stood against each threshold exists the moment the check is run rather than being rebuilt later.
What you get is a clear read on a question that otherwise hides in a sales report, which states has this client actually triggered. The tool does not register the client or file the returns, that stays with the firm and the client. It measures activity against thresholds and flags the crossings, the same way on every client. You can see how the sales tax nexus tracker fits a practice on the product page, where it is described as the tracking Avalara charges enterprise money for, scoped to the one question a growing client needs answered.
How does the sales tax nexus tracker help a firm keep the sales records behind a nexus determination?
A nexus determination is only as good as the sales data behind it. To say a client did or did not cross a state’s threshold, a firm needs the sales-by-state figures that support the call, and it needs to keep them. The sales tax nexus tracker works from that sales export and produces a status report that documents, state by state, where the client stood against each threshold at the time the firm looked.
Keeping the records behind that kind of determination is what the recordkeeping rules are about. IRS Publication 583, Starting a Business and Keeping Records, states that a business’s supporting documents include its records of sales, and that they should be kept in an orderly fashion. The sales-by-state data that drives a nexus call is exactly that kind of sales record. The tracker turns it into an organized report rather than a raw export nobody can read a year later.
Because the nexus status report is produced as the firm runs the check, the record of the determination exists at that moment, dated and specific. If a state later questions when a client should have registered, the firm can show the sales figures it measured and the thresholds it compared them against, rather than trying to reconstruct the picture from a sales export that has since changed.
The registration to-do list is part of that record too. It captures not just where a client crossed a threshold but what the firm concluded should happen next. That turns the sales tax nexus tracker from a one-time calculation into a documented trail, a firm can see when a state first tripped and what the plan was, which is the sort of orderly support a client file is supposed to hold.
There is a boundary to name. The tool organizes and documents the sales data against thresholds, but it does not keep the client’s books for them or verify that the sales export is complete. If the export understates a state’s sales, the determination will be understated in the same way. A firm still owns the accuracy of the data going in and the conclusion coming out.
Timing is the other reason the record matters. Nexus questions rarely surface in the year they arise. They surface when a state audits or a buyer runs diligence years later. A firm that saved a dated status report can show exactly what a client’s sales looked like when the call was made, which is a far stronger position than trying to rebuild an export that has since moved on to newer numbers.
For a firm with clients selling into many states, the value is a determination you can stand behind because the record behind it is kept. Nexus questions surface years after the fact, and a firm that saved an orderly status report is in a far better position than one working from memory. You can see how the tracker sits beside the other SortTax tools on the accounting and tax page, where each one is built to leave the organized, retrievable record the rules ask a business and its preparer to keep.
Where does the sales tax nexus tracker keep client sales data, and is that information safe?
A sales-by-state export is a detailed map of a client’s business, how much it sells and where. Firms are right to ask where that data goes before importing it. The sales tax nexus tracker is built to read the sales export the firm already holds and produce its status report inside the firm’s own process, rather than requiring a client’s full sales history to be handed to an outside platform to get a nexus answer back.
Handling that data carefully is an obligation, not a preference. The Federal Trade Commission treats tax and accounting firms as financial institutions under its rule, and its guidance, FTC Safeguards Rule: What Your Business Needs to Know, tells firms to develop, implement, and maintain an information security program with administrative, technical, and physical safeguards designed to protect customer information. A tool that reads a client’s detailed sales data falls inside the scope of what that program has to cover.
The tracker meets that expectation by keeping its footprint narrow. It works with the sales export as part of the nexus check and keeps the status report and to-do list with the firm’s own files. There is no need to publish a client’s entire sales history to a third-party service to learn which states a threshold was crossed in. The shorter the path the data travels, the fewer systems a firm has to secure and name in its program.
The claims stay honest. The tool is not antivirus and it does not replace the firm’s security program. It measures sales against thresholds and flags the crossings. What it avoids is creating a new outside home for a client’s full sales data, which would be one more copy to track when the firm documents where sensitive information lives and who can reach it.
A security program also covers the ordinary handling around the tool, who opens the imported sales export, where the status report is filed, and how superseded copies are disposed of. Because the sales tax nexus tracker keeps its inputs and outputs where the firm already applies its controls, those questions have direct answers instead of pointing at a service the firm does not operate.
The plain version is this. The sales tax nexus tracker is built to reduce the number of places a client’s full sales history has to live, not to add another one. It reads the export the firm already holds and leaves its status report in the firm’s own files, so a practice that keeps a written security program can fold the tool into that program without opening a new outside store of sensitive sales data.
For the buyer, a CPA or bookkeeping firm, the result is a tool you can adopt without widening your exposure. You get the nexus status report you needed without adding a system that holds a client’s entire sales history somewhere outside your control. You can read how the tracker fits a practice on the product page, and place it inside the written safeguards you already keep, so the nexus work gets done without the security program getting longer.
How is the sales tax nexus tracker different from Avalara or a spreadsheet for tracking economic nexus?
Economic nexus tracking has two usual homes, an enterprise platform like Avalara or a homemade spreadsheet. The sales tax nexus tracker sits deliberately between them. It gives a firm the state-by-state threshold tracking that a spreadsheet does poorly, without the cost and weight of an enterprise tax engine. The catalog names what it replaces, Avalara at the enterprise end and spreadsheets at the manual end.
Against a spreadsheet, the difference is the thresholds and the upkeep. A spreadsheet can hold a client’s sales by state, but someone has to maintain every state’s threshold, remember which states test on revenue and which on transaction count, and rerun the comparison by hand. The tracker ships with a threshold template and compares a client’s revenue and transaction counts against each state’s specific test, so the grid is not a manual project.
Against Avalara, the difference is scope and price. An enterprise engine assumes a large seller, a real implementation, and a budget to match, and it does far more than answer the nexus question. A firm that just needs to know which states a client has triggered does not need to buy filing automation for a whole enterprise. The sales tax nexus tracker is scoped to the tracking, which is the part a growing client most needs first.
Keeping the determination in a consistent, organized form also helps with records. IRS Publication 583, Starting a Business and Keeping Records, describes keeping a business’s records of sales in an orderly fashion, and a repeatable status report is easier to retain and revisit than a spreadsheet whose formulas only its author understands. When a nexus question resurfaces, a consistent report is what a firm wants to open.
There is an honest limit. The tool tracks nexus and flags crossings, it does not register the client, file sales-tax returns, or replace a full tax engine for a large multistate seller. It also depends on the sales export being right. A firm still owns the decision to register and the accuracy of the data. What the tool removes is the manual grid-keeping that made spreadsheet tracking fragile.
Across a growing client base, that middle ground is exactly where a firm lives. A single client selling into two states does not justify an enterprise engine, and a dozen clients each selling into twenty states will break a hand-kept grid. The sales tax nexus tracker scales through both without changing how it works, comparing revenue and transaction counts against each state’s own test whether a firm checks one client or the whole book.
For a firm with clients growing across state lines, that middle ground is the case. A spreadsheet is fragile and an enterprise engine is more than the question requires. The tracker turns a task that scaled badly into a repeatable check. You can see how it lines up with the other SortTax tools on the accounting and tax page, and judge whether trading a hand-kept grid for a scoped nexus tracker is right for how many multistate clients your firm actually carries.
Can the sales tax nexus tracker flag states a client is approaching and build a registration to-do list?
Yes, and that forward-looking view is a large part of why the tool is worth running. Catching a threshold after a client has already crossed it means back-tax exposure. Catching it as the client approaches means the firm can plan the registration before the obligation bites. The sales tax nexus tracker flags both, states where nexus is already triggered and states where the client is approaching the line, and it turns the triggered ones into a registration to-do list by state.
The approaching flags come from the same comparison that finds the crossings. As the tool measures a client’s revenue and transaction counts against each state’s threshold, it can see not only which states are over but which are close. A client sitting at eighty percent of a state’s revenue threshold is a state to watch, and surfacing that early is what lets a firm act before a notice rather than after.
The registration to-do list turns the triggered states into an action plan. Instead of a report a firm has to translate into next steps, the tool names the states where registration is due, so the firm can work the list one state at a time. The sales tax nexus tracker does the sorting between where action is required now and where a client only needs monitoring.
Both lists update as new sales data comes in. Nexus is not a one-time event, a client that was clear last quarter can cross a line this quarter as sales grow. Rerunning the check against fresh sales keeps the triggered and approaching lists current, so a firm reviewing a client periodically always sees where they stand rather than where they stood at the last look.
Keeping that running status is also part of a good record. IRS Publication 583, Starting a Business and Keeping Records, describes keeping a business’s records of sales in an orderly fashion, and a dated status report showing when a state was first approached and then crossed is exactly that kind of orderly record. It documents not just the conclusion but the path the client took to it.
For a firm reviewing clients on a quarterly rhythm, the approaching flags turn nexus from a fire drill into a calendar item. Instead of reacting to a state notice, the firm sees a client nearing a threshold, plans the registration, and moves before the obligation starts. That head start is the practical payoff of watching the line rather than only the crossing after a client has already stepped over it.
The limit stays clear. The tool flags and lists, it does not register the client or decide the registration date for them. A firm and its client still make the call and file the paperwork. What the approaching flags and to-do list remove is the surprise, the moment a firm learns about a threshold only after a state has sent a bill. You can read how the tracker fits a practice on the product page, where the sales tax nexus tracker is described as the tool that tells a firm exactly which states a client has crossed, and which ones are coming next.
| Attributes | Value |
|---|---|
| Deployment |
Cloud |
| Platform |
Web |
| License Type |
Subscription |
| Billing Period |
Monthly |
| Target Customer |
Accounting & CPA Firms |
| Free Trial |
Yes |
Frequently bought together
-
Sales & Use Tax Prep
$39.00
