Sales and Use Tax

Changing Rates and other Settings

Changing Rates and Other Settings

A sales tax rate 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. A state sales tax table may require one or more sales tax rate records for a specific state.

  1. Go Sales > Sales Tax > Rates to view all of the applicable sales tax Rates.

  2. Cick on the root folder USA to view all Tax Tables. Double click on individual Tax Table record to open the following dialog:

  3. Enter a Description of the tax table.

  4. The Category identifies when this sales tax table is applied to the sales invoice.

    1. Set the Applies To setting to the appropriate jurisdiction.

    2. Select Country if the sale applies to any sale within the entire country or nation.

    3. Select State if the tax applies to a specific state or province.

    4. Select City, County, or Zip if the tax is limited to a specific city, county or zip.

    5. Select the appropriate Country, State, province, City, County or Zip.

  5. Select the appropriate 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. The Report gross sales from sales in states with no presence is normally enabled only for the home sales tax table.

  7. Enable the Print separately on invoice option to list sales tax amount separately on the invoice. A tax Label, that will displayed on the lower right hand corner of the invoice, must be entered if this option is enabled.

  8. Enter sales tax Rate Information.

    1. The Current Rate reflects the sales tax percentage for new sales invoices. Enter an Effective Date for any rate changes. The original rate will be copied from Current Rate to the Old Rate when a new rate is entered into Current Rate.

    2. The Old Rate will be used to calculate tax for any invoices with an invoice date that is previous to the Effective Date.  This may happen when an invoice is back dated or is reprocessed.

    3. Enter the sales tax Maximum value. Review the Luxury, VAT, Sales Tax, Minimums and Maximums section for more details.

  9. Select a Sales Tax Liability Account to record collected sales tax.

  10. Select a Use Tax Liability Account to record collected use tax.  Review Financials > Chart of Accounts > Adding Genal Ledger Accounts within the main documentation for more details on creating both the sales tax and use tax liability G/L account.  

  11. Enter the Tax Agency vender ID.  This vender ID is used when paying the collected tax.  The Tax Agency is an important setting that must be entered for each Tax Table that is paid to this vender. Review [Financials] Venders > Adding a New Vender of the main documentation for more details on creating a new Tax Agency vender.

  12. Select the appropriate Payment Frequency option.

  13. Add any Notes for reference purposes and click OK to save.

Complete one of the following steps to make inactive: