Establishing Sales Tax Rates

It is important that the sales tax accounts are properly configured before the point-of-sale portion of EBMS is used to invoice customers. The user should determine which sales tax rates apply to the business before proceeding with this section.  

A sales tax rate record should only be added to EBMS for applicable states or provinces. Do not add rates into EBMS unless the company is required to collect the sales tax for the specific tax jurisdiction (sales tax nexus). A state sales tax table may require one or more sales tax rate records for a specific state.  

Identify if a state is origin-based or destination based.   Review Origin vs Destination Sales Tax for an explanation.  

Perform the following steps to setup the sales tax within EBMS.   Note that these accounts will be created by TaxJar if sales tax is calculated by the TaxJar SmartCalc too.   Review TaxJar > Overview for details.

1. A liability G/L account should be created before the sales tax rate record is entered or downloaded. Go to Financials > Chart of Accounts and create a sales tax liability account for each group of sales taxes. For example, create a single general ledger account if the sales tax collected includes both a state and county tax and both are paid to the same vendor. Create multiple accounts if the tax is paid to different vendors. Review the Financials > Chart of Accounts > Adding General Ledger Accounts section of the main documentation for details on adding a sales tax collected liability G/L account.
   
2. Create a vendor record for the Tax Agency for the new sales tax. Go to Expenses > Vendors to create a new vendor as shown below. Review [Financials] Vendors > Adding a New Vendor of the main documentation for details on how to create a new vendor.

3. Go to Sales > Sales Tax > Rates to view the sales tax rate table as shown below.   Steps #3 and #4 can be ignored sales tax rates are calculated by the TaxJar sales tax subscription.  Review TaxJar > Overview for details.  
   

4. Click on the Edit menu and select New to create a new sales tax rates within EBMS and the following dialog will appear:

1. Enter a Description of the sales tax that is being entered identifying the state and type of tax. The sales tax identification number can also be recorded within the Description field.

2. Enable the Print separately on invoice option to itemize this sales tax rather than combining with another sales tax rate. This option should only be disabled if multiple rates should be combined on the sales order or invoice. Edit the sales tax Label shown on the invoice if necessary.

3. Configure the Category settings. The Applies to: setting should be set to Country for a national sales tax, State if it is a state sales tax, County, City, or Zip. This setting will affect the other category entries. All category entries must be populated. Use the two-character abbreviation for the state entry. The county and city should not be abbreviated.

4. Configure the Rate Information.

1. Select the sales tax Rate Type:

1. Select the Flat Amount type for any tax that is based on quantity such as a fuel or FET tax. Review the Sales Tax > Calculating Fuel Taxes section for an example of a flat tax setup.

2. Select the Percentage type to calculate sales tax based on a tax rate. This is the standard Rate Type for most sales tax settings.

2. Enter the Current Rate.

3. The Effective Date entry can be left blank unless the sales tax rate was changed within the past two years or a new rate takes effect in the future. Review the Changing Rates and other Settings section for more details.

4. The Maximum option only applies for percentage rate taxes. Review the Luxury, VAT and Sales Tax Minimums and Maximums for more details on the Maximum setting.

5. Choose a Sales Tax on Freight setting.

1. Select Tax if there are any taxable items to charge sales tax on freight, if any taxable items exist on the sales invoice.

2. Select Pro-rate based on taxable items to pro-rate the sales tax calculation on the freight amount, based on the percentage of taxable items.

3. Select Never Tax to make all freight charges tax exempt.

6. Configure the Payment settings.

1. Enter the Liability G/L Account. Click on the drop-down button to the right of the field to list all available sales tax general ledger accounts. These accounts are identified within the general ledger as accounts with a classification of Sales Tax. Go to General Ledger > Chart of Accounts > Advanced tab > Classification to set the classification. Review the Financials > Chart of Accounts > Chart of Account Folders section for more details.

2. Enter a vendor ID in the Tax Agency entry. The system will use this vendor ID when the sales tax is paid to the tax agency. The vendor ID should be the same for sales tax rates that are paid to a common tax agency. Review [Financials] Vendors > Changing Vendor Information within the main documentation for vendor ID details.

3. Set the Agency Type to State or Federal.

4. Choose a Payment Frequency.

5. Enable the Include Report gross sales from sales in states with no presence option to add gross sales from states with no sales tax liability. This option should only be enabled for the main sales tax table if recommended by your accountant. Do not enable this option for multiple tax rate records.

7. Click the Next button to continue and enter a unique Sales Tax ID.

5. Click the Next button to continue.
   

6. Each tax group must be identified as taxable or non-taxable. Enable the Taxable option to charge tax for the specific tax Group. Review Inventory Tax Group for more details on creating tax groups.

7. Click on the Finish button to complete the new wizard.

Review TaxJar > Overview for a cloud based service to manage sales tax rates.