+1 480 485 7373
Microsoft Teams
How Business Central models sales tax setup in the US version
The US version of Business Central works out sales tax from two things: where the sale takes place for tax purposes and what you sell. A tax area stands for where. It lists the jurisdictions that apply to an address, such as a state, a county and a city. A tax group stands for what, using a category such as taxable goods, nontaxable services or freight. The tax details table then holds a rate for each pairing of jurisdiction and tax group, with an effective date.
Customers, vendors and your own locations each carry a tax area code, and on customers and vendors the Tax Liable flag says whether tax applies at all. Items, resources and G/L accounts carry a tax group code. When someone enters a sales line, Business Central combines the tax area on the document with the line's tax group. It then looks up the detail for each jurisdiction in that area and adds up the tax.
Each jurisdiction posts to its own G/L accounts and appears separately in reports. So you can see exactly what you collected for the state and for each local authority. That separation is what makes preparing returns from Business Central data practical, whether your team files them or your adviser does.
The four building blocks of Business Central sales tax
Tax jurisdictions
One record per taxing authority, such as a state, county or city. Each holds the G/L accounts for tax on sales and on purchases, plus a report-to jurisdiction for grouping.
Tax areas
A named list of jurisdictions that together apply to a place. You assign tax areas to customers, ship-to addresses, vendors and your own locations.
Tax groups
Categories of taxability for what you sell or buy. Items, resources and G/L accounts each carry one, so the same address can tax goods but not a service.
Tax details
The rate for each jurisdiction and tax group pair, with a tax type and an effective date. A rate change is a new line, so older invoices keep their history.
Business Central sales tax setup in an order that avoids rework
- 1
List the jurisdictions you collect for
With your tax adviser, confirm the states where the company must collect and, within them, which local jurisdictions apply. Create a tax jurisdiction for each and assign its G/L accounts.
- 2
Define tax groups from the product catalog
Sort items and services into groups that share the same tax treatment wherever you sell, such as taxable goods, nontaxable labor and freight. Keep the list short and write down what belongs in each group.
- 3
Enter the tax details
For each jurisdiction and tax group pair, enter the rate your adviser or the taxing authority publishes, with its effective date. A zero rate is valid and makes a nontaxable pairing explicit rather than accidental.
- 4
Build the tax areas
Create a tax area for each distinct combination of jurisdictions your customers ship to, and one for each of your own locations. Name them so users can pick the right one from an address.
- 5
Code the master data
Set Tax Liable and a tax area on customers, vendors and ship-to addresses, record exemption numbers where they apply, and give every item, resource and G/L account used on sales lines a tax group.
- 6
Test with real transactions
Post sample invoices to several addresses with mixed lines. Then check the tax per jurisdiction on the posted documents and in the sales tax reports before go-live, so you know your sales tax setup in Business Central works.
Where the key Business Central sales tax fields live
When a tax engine such as Avalara is the better choice
Standard sales tax setup in Business Central works well for companies that collect in a limited number of jurisdictions with stable product taxability. You maintain the rates yourselves, which is manageable when the list is short and one person clearly owns the updates.
The balance shifts when you sell into many states or ship to a large number of local jurisdictions. It also shifts when taxability varies from state to state for what you sell, such as clothing, food, software or services. Maintaining rates and rules by hand then becomes a genuine risk. Tax engines calculate tax per transaction from the exact address and a product tax code, and many also handle exemption certificates and return filing. Avalara's AvaTax is the best-known example with a Business Central connector, and other providers offer similar integrations.
An engine is not always the answer. It adds a subscription, another system to reconcile and a dependency on the connector keeping pace with Business Central releases. If you sell mainly in one state from one location, the built-in setup is usually enough. Ecommerce growth into new states is the most common trigger for moving to an engine, and your tax adviser's view on where you have nexus should set the timing.
Sales tax setup questions about Business Central
Does Business Central include sales tax rates?
No, you enter and maintain the rates yourself in the tax details table, or connect a tax engine that supplies them. State and local authorities set the rates, and they change over time. Each detail line has an effective date, so you add new rates without losing the history behind earlier invoices. If you stay on the built-in setup, name one person who owns rate updates.
How do we know which states we must collect sales tax in?
Ask a qualified tax adviser, because this is a legal question about nexus rather than a system setting. After the 2018 Wayfair decision, states can require collection based on sales into the state, not only a physical presence, and their thresholds differ. Once your adviser confirms the states, you set up the jurisdictions to match. Sales reports by ship-to state from Business Central give your adviser the figures to work from.
How are tax-exempt customers handled?
Usually by clearing Tax Liable on the customer and recording the exemption certificate number on the customer card. Where a customer is exempt only for certain products or places, a zero-rate tax group or tax area can model that more precisely. Keep the certificates themselves on file, because auditors ask for them. Tax engines often add certificate collection and expiry tracking if you have many exempt customers.
More questions on sales tax setup in Business Central
Can Business Central handle use tax on purchases?
Yes, the US version supports use tax on purchase lines where the vendor did not charge tax. You mark the line as use tax. Business Central then records both the tax expense and the liability in the jurisdiction accounts, instead of adding the amount to what you owe the vendor. Whether use tax is due on a particular purchase is a question for your tax adviser. Once you decide, the sales tax setup in Business Central simply records it correctly.
Is freight taxable in Business Central?
That depends on the state, and you can configure Business Central either way. Companies usually bill freight through a G/L account or item charge that carries its own tax group. The tax details for each jurisdiction then decide whether that group carries tax. Your adviser confirms the rule for each state where you collect. The setup then applies it the same way on every invoice.
Talk to us about your project.
Tell us what you run today and what has to change. A senior consultant replies with a written next step.