How do I set up included sales tax (pre-tax price in body of receipt)?

Please note: we will sunset inFlow On-Premise on July 31, 2024. After sunset we will stop selling or activating new licenses for inFlow On-Premise and stop providing support (including online KB articles).

In the meantime we will still provide technical support to customers with an active Support Plan.

If you need to show your price before tax in the body of the receipt (as in the UK) but don’t want to have to calculate all your pre-tax prices by hand, inFlow On-Premise can do that for you.

First, set up a pricing scheme for the pre-tax price:

  1. Add your prices as posted to the program under a Taxes Included scheme, let’s call this scheme Normal Price.
  2. Go to the Main Menu > Inventory > Product Pricing.
    4901_1
  3. Click Add Products and select everything.
  4. From the Pricing/Currency dropdown choose <Add New..> and create a new pricing scheme; called “Sales Excl”.  Click Save & Close.
    4901_2
  5. Next we have to calculate the percentage by which your prices should be reduced (since it’s not the same as your tax percentage).  This is done using the following formula: OriginalPrice = PostedPrice * [1 / 1+SalesTax] For 17.5% sales tax the calculation (for example) would be as follows: £8.99 * [1 / 1 + 17.5%].  This would work out to the original price being £7.65.  This also tells us that the original price (pre-tax) was 85.1% of the posted price, meaning that we will need to reduce our prices by 14.9% in order to get the correct pre-tax prices.
  6. To set your PreTax Price scheme correctly, tell inFlow at the bottom of the window to: SET “SALES EXCL” TO “NORMAL PRICE” “MINUS” “14.5%”.
  7. Click Adjust to apply the changes.
4901_3

When you’re done, set up taxes to calculate:

  1. Go to Main Menu > Options > Settings.
  2. Scroll down to the Taxes section and click Manage Taxing Schemes.
  3. Set up a 17.5% sales tax in this window and give it a name.
  4. Click “Save & Close“.
4901_4

Your sales order would finally look like this:

4901_5

 

Were you looking for a way to show the product’s tax included price on your order? If so please see here.

Yun Ling
Archon Systems
w,
+1.866.923.4974
260 Carlaw Ave #397
Toronto, ON, M4M 3L1
Canada
May 10, 2018

Rate this article

Not enough ratings yet
1 star2 stars3 stars4 stars5 stars
Loading...
  • Did this article help? If not, please let us know so we can improve it.

  • This field is for validation purposes and should be left unchanged.