Community

We have products with 2 different tax rates. Products in section 1 (food) are with 12% tax and products in section 2 (beverages) are with 21% tax. How can the summary calculate the total sales tax in this case? We would ideally need to see separately: Total price for Section 1 (without tax), Total price for Section 2 ( without tax), Tax (12%) for Section 1 and Tax (21%) for Section 2

Info Dark Kitchen

Apr 10, 2024

Comments (1)

Vipin

Apr 10, 2024

There are two options to calculate taxes. (1) setup taxes for each product and the use the standard TAX() formula to calculate the taxes (2) calculate the tax as a fixed percentage of order amount. Since you have different taxes for food products and beverages, you can use the option (1) Setup tax for product Login to Neartail > click on the form to open it > Edit page will be displayed > In the Edit page, click on the gear icon next to the product > update the tax percentage and click Save. Repeat the steps to set up the tax percentage for each product where applicable. Calculate tax In the Edit page, click on the Add price field button > select Tax, click Next > select Standard calculation using TAX() formula, click Next > click Create. Since you have already added a field for tax, click on the DPH field to select it > click on the gear icon for this field > Field settings page will be displayed > click Answer > delete the existing formula and enter TAX() in the Calculate option > click Save. Note: we do not have the option to show the the taxes separately for Food and Beverages. But this will allow you to apply different tax percentages for each product. Calculate total amount including tax, shipping fee In the Edit page, click on the Add price field button > select Net amount, click Next > select Standard calculation using NETTOTAL() formula, click Next > click Create. Please try this and confirm.

Add your comment