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 tax laws in your area of business.

  1. Create a tax rate
  2. Applying your Taxes


CREATE TAX RATES:

Step 1: Click on the Settings icon & select ‘Set up Tax Rates’

TaxRateMenu

 

Step 2: click the ‘+’ sign at the bottom right side of the page; enter the appropriate information & save.

PlusSign

DEFINE YOUR TAX:

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 be useful to also include the area for which this applies eg. ‘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.

SaveButton

PRICE-BASED TAXING:

In some locations (Massachusetts), 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 item sales price is over a certain threshold, then 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.

PriceBasedTaxing

 

As a next step, you’d associate this new tax rate with a register, or with a product group, so that it would apply automatically when needed.

CITY/STATE/COUNTY

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

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

Tiered Taxes

TAX CODE:

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

SAVE:

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

APPLYING YOUR TAXES

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.

REGISTER:

Default tax rate applied at the register, this overrides tax rates set on items, or product groups.  This is the most common and usually best set up. To apply tax rate by register:

Step 1: Navigate to your register

Step 2: Choose TAX RATE to be applied from the drop down

RetailChain

 

 

 

Register

 

Step 3: Click SAVE to apply changes

SaveButton

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

PRODUCT GROUP:

You can assign tax rates by location and product group on 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

PIM

 

 

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.

ProductService

 

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

ProductGroup

 

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 to “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 a tax rate on a child, 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:

Step1: 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.

Result: 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:

Tiered tax rates are set up at shop level (Location), and is 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:

RegisterCard

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

OverThreshold

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.

 

PRODUCT LEVEL:

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

IMPORT:

When items need to be taxed individually the most time-effective way to assign this to all of the items is to import this information.  To do this, taxes should be set-up first, then the percent 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.

RegisterOverride

TAX FREE AT ALL LOCATIONS:

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

TaxFree