Home » Settings » Creating & Applying Tax Rates – Berlin

Creating & Applying Tax Rates – Berlin

ERPLY supports multiple tax rates and tax scenarios.  Please note that this guide is on how to set up and apply taxes within the ERPLY system.  To find out what taxes apply to you, please consult your city or state tax code, or an accountant who knows the tax laws in your area of business.

  1. Create a tax rate
  2. Applying your Taxes


Step 1: Click on the Settings icon & select “Set up Tax Rates.”



Step 2: Click the “+” sign at the bottom right side of the page; enter the appropriate information & save.



Step 1: Type the name of tax rate and % to be applied.  ERPLY support recommends including your tax rate in the name of your tax.  It can also be useful to include the area for which this applies (e.g.: “NYC – 8.725”).

The tax rate should be your total applicable tax rate.  If your state charges 5% and your city charges 2%, you need to combine them to get your effective rate (7%)

Note: Existing tax rates cannot be edited or deleted from the system.

Step 2: Save.



In some locations (Massachusetts, for example), some items are taxed differently for the portion of the item’s price that is over a set threshold.  This type of tax rate is added as a regular rate, then applied like a normal rate as outlined below in “Applying Your Taxes.”

If the item’s sales price is over a certain threshold, the value below threshold is taxed with one rate (which can also be 0%) and the value above threshold is taxed at a different rate.



You can associate this new tax rate with a register or product group, so that it will apply automatically when needed.


This is a configuration that can be applied to paid accounts, and is not on by default.

When adding taxes, you can break them down by City, State, or County. Be sure to enter the numeric values in each of these fields.

Tiered Taxes


While setting up your tax rates, you can also set up your account codes for your accounting software using the “tax code” field. This works in conjunction with both ERPLY accounting and our Quickbooks export.


Once saved, the tax percentage cannot be changed, but new rates may be added, and old rates may be renamed or assigned new numbers in the accounting software.


The tax rates to be used should now be in ERPLY. Your next step is to apply this rate.  You can apply this rate in several ways, depending on your usage scenario.


Default tax rate applied at the register. This overrides tax rates set on items, or product groups, and the tax rate applied to the first register in a given location will automatically populate tax on Invoice-Waybills. This is the most common set up, and usually the best. To apply tax rate by register:

Step 1: Navigate to your register

Step 2: Choose the tax rate to be applied from the drop down







Step 3: Click SAVE to apply changes


Note: If you are logged into this Register currently, you may have to log out then back in again to apply the new setting.


You can assign tax rates by location and product group in the product group settings.  The register must not have a tax rate on it for this to work.  This is generally used for setting tax rates on Non-Stock Items (services) in groups, or groups that may have different tax rates.

To apply tax rates by Product and Service Group:

Step 1:  Navigate to Product and Service Groups




Step 2: Under the newly-added PIM icon, right click (ctrl-click on Mac) the specific Product and Service Group to be updated and select Edit from the drop down.



In the middle of the Product group card, you have the option of choosing a specific tax rate for any specific location.



Keep in mind, the tax rate chosen only affects the products within the product group at the location specified.

Note: If choosing to set all taxes by product group, please note you will need to assign a tax rate to each one. If left as “default tax” it will take the tax rate from the register or product card.

Note: Tax rates are not “inherited” by lower product groups.  If you want to change the tax rate on a child group or tree-d product group, you must set it in each group.

Step 3: Save your settings.

Note: If you are currently logged into affected registers, you may have to log out, then back in, to apply the new setting.

Setting up dual tax rates by product group example scenario:

Step 1: Create the tax groups as components (ex: city/state).

Step 2: Apply tax rates to product group by going to the Inventory module>product and service groups on the left-hand side.

Step 3: Right-click product group and click Edit.

You will see that you can apply the specific tax via drop down by location within the product group. For this specific setup, taxes will only be applied by product group. For items outside this group, your standard sales tax should be applied via the register.


Tiered tax rates are set up at shop level (Location), and are a lower priority than product group rates.

Example: If a shop sells both clothing and other kinds of items (non-clothing), you need to set up tiered tax as the default, and configure exceptions for all other product groups.

1. The sub-Threshold ($100) rate as the baseline, and goes to register card:


2. On location card, we will establish the over-threshold ($100) tier:


Tiered Tax Invoice

3. For all other product groups that do not need this type of rate, tiered tax rates need to be overridden using product group taxes.



A tax rate is attached to each product. No tax rate should be set on a product group or register for this tax rate to be applied.  This is generally only used if you have a lot of different applicable taxes.


When items need to be taxed individually, the most time-effective way to assign rates to all of the items is to import this information.  To do this, taxes should be set up first, then the percentage should be noted on the import sheet in the “tax rate” column. There should be no % sign in the document.

Please consult our import guide for more information on the import process.

Under the newly-added “PIM” icon:

Step 1: Select “Product Catalog” & click on the name of the item to open the “product card.”

Step 2: Choose your tax rate from the drop down in the tax rate box.

Step 3: Click SAVE to finalize.

Note: If this product is sold through a register with a tax rate applied, the register will override the tax rate.



This check box is set on the product card and will override all other tax rates set on the item (by group, item, or register).  This is for items that are never taxed, such as stamps, or some non-stock items.