Sales Tax Tracker
Track monthly sales by state, applicable tax rates, collected amounts, and remitted totals.
Published by Blueprint Dynamics. Planning tools, not professional advice. Read the formula, assumptions, and examples below before relying on a result. Independent professional review is not claimed. Learn more about our methodology →
AllTemplates • Blueprint Dynamics • hello@bpdynamics.io. Educational worksheet; entries and assumptions are not independently verified. This document is not tax, legal, medical, investment or engineering approval. Review current official rules and seek a qualified specialist where appropriate.
Specialist review required for real decisions
US federal educational examples are not filing determinations. Check the stated year, entity, payment type, eligibility, elections and state rules with a qualified tax professional; historical defaults are not automatic current-year guidance.
- IRS: current 1099-MISC/NEC instructions (including 2026 changes)
- IRS: small-business and self-employed guidance
Primary reading context, not an endorsement or evidence that the linked organization reviewed this tool. No independent professional sign-off is claimed.
About the Sales Tax Tracker
Sales tax is not your money — you collect it as an agent for the state and hold it in trust until you remit it. That distinction matters because states treat unremitted sales tax far more harshly than a late income-tax bill, often with personal liability for owners. This tracker keeps a clear month-by-month record of what you collected versus what you have paid over, so the trust fund never quietly disappears into operating cash.
For each period you log the month, the state, gross taxable sales, the applicable rate, and the amount you have remitted. The tool computes tax collected automatically and surfaces three headline numbers: total collected, total remitted, and the outstanding balance you still owe the state.
How the Sales Tax Tracker works
Tax collected for each row is gross sales × (rate ÷ 100). The dashboard sums collected across all rows, sums the remitted column you fill in, and subtracts to show the outstanding balance. When outstanding is positive the panel turns red, a deliberate visual cue that money is sitting in your account that legally belongs to the state.
Because rates and nexus rules vary by state, the state column lets you run separate lines for each jurisdiction you have registered in. Enter the combined state-plus-local rate that actually applies to your sales in that location — many addresses carry city and county add-ons on top of the base state rate.
Worked example
The sample tracks California at a 7.25% rate. January sales of $15,000 generate $1,087.50 collected, February's $18,500 generates $1,341.25, and March's $22,000 generates $1,595.00 — a total of $4,023.75 collected.
Remittances so far are $1,000.00 for January and $1,341.25 for February, with March unpaid, totaling $2,341.25 remitted. The outstanding balance is therefore $4,023.75 − $2,341.25 = $1,682.50, which the dashboard flags in red as tax you still owe the state.
Tips & common mistakes
- Never spend collected sales tax on operations. It is trust-fund money, and most states can hold owners and officers personally liable for shortfalls even if the business is an LLC or corporation.
- Use the combined rate for each address. The California statewide base is 7.25%, but district taxes push many localities above 10%, so verify the destination rate rather than defaulting to the state minimum.
- Match your filing frequency to volume. States assign monthly, quarterly, or annual filing based on your collections, and filing on the wrong cycle triggers penalties even if you eventually pay in full.
- Track economic nexus. Since the Wayfair decision, selling into a state can create a filing obligation once you cross its sales or transaction threshold (commonly $100,000 in sales), even with no physical presence.
Sales Tax Tracker: frequently asked questions
How do I know which sales-tax rate to enter?
For destination-based states, use the rate at the buyer's shipping address, combining state, county, city, and special-district taxes. For origin-based states, use your own location's rate. When in doubt, the state revenue department publishes a rate lookup by ZIP or address — enter that combined figure in the rate column.
What is the difference between tax collected and tax remitted?
Collected is what you charged customers, calculated automatically as sales times rate. Remitted is what you actually sent to the state, which you type in. The gap between them is your outstanding liability — money you are holding in trust and must pay by your filing deadline.
Do I owe sales tax on shipping charges?
It varies by state. Some tax shipping when it is part of a taxable sale, others exempt separately stated freight, and rules change if the shipment mixes taxable and exempt items. Check your state's treatment and fold any taxable shipping into the gross sales figure you enter.
What happens if I file but can't pay the full amount?
Always file on time even if you cannot pay, because the failure-to-file penalty usually exceeds the failure-to-pay penalty. States will often set up a payment plan, but the trust-fund nature of sales tax means interest accrues and personal liability may attach, so pay the outstanding balance as fast as possible.
Do I need to track states where I only have online sales?
Possibly. Economic nexus laws require registration and collection once you exceed a state's threshold — frequently $100,000 in annual sales or 200 transactions. Add a separate row per state where you cross the line, and register with each before you begin collecting.