# Tax table for Item, checkbox: "Is this Tax included in Basic Rate?", what's the difference if checked or not, can you give a simple case? say net total is 1000, rate is 10, if checked

Thanks very much.

1. Please be kind and don't send large attachments
2. For issues, features requests use https://github.com/frappe/erpnext/issues

You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

If rate is 10% on net total of 1000/- and the tax is included in basic rate then the actual pricing would be like this:

Selling price = 1000/1.1 = 909.09090909.... (depending upon the currency precision)
Tax would be = 1000/1.1 * 0.1 = 90.090909...  (depending upon the currency precision)

Total would be 1000/-

But without inclusion the

SP = 1000/-
Tax = 100/-
Total would be 1100/-

I hope I am right.

On Wednesday, September 24, 2014 3:20:53 PM UTC+5:30, Y Y wrote:
Thanks very much.

1. Please be kind and don't send large attachments
2. For issues, features requests use https://github.com/frappe/erpnext/issues

You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

understand now, that's mean net total already contains tax value.

in real scenario, why would add this kind of tax into tax table(as it will be 0)? is this just to show the complete tax included?

Thanks,
yang

If rate is 10% on net total of 1000/- and the tax is included in basic rate then the actual pricing would be like this:

Selling price = 1000/1.1 = 909.09090909.... (depending upon the currency precision)
Tax would be = 1000/1.1 * 0.1 = 90.090909...  (depending upon the currency precision)

Total would be 1000/-

But without inclusion the

SP = 1000/-
Tax = 100/-
Total would be 1100/-

I hope I am right.

On Wednesday, September 24, 2014 3:20:53 PM UTC+5:30, Y Y wrote:
Thanks very much.

1. Please be kind and don't send large attachments
2. For issues, features requests use https://github.com/frappe/erpnext/issues

You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

Tax table is used to back-calculate the tax exclusive price which is used for accounting.

Sent from my phone

On 25-Sep-2014, at 11:42, Y Y <ya...@gmail.com> wrote:

understand now, that's mean net total already contains tax value.

in real scenario, why would add this kind of tax into tax table(as it will be 0)? is this just to show the complete tax included?

Thanks,
yang

If rate is 10% on net total of 1000/- and the tax is included in basic rate then the actual pricing would be like this:

Selling price = 1000/1.1 = 909.09090909.... (depending upon the currency precision)
Tax would be = 1000/1.1 * 0.1 = 90.090909...  (depending upon the currency precision)

Total would be 1000/-

But without inclusion the

SP = 1000/-
Tax = 100/-
Total would be 1100/-

I hope I am right.

On Wednesday, September 24, 2014 3:20:53 PM UTC+5:30, Y Y wrote:
Thanks very much.

1. Please be kind and don’t send large attachments
2. For issues, features requests use https://github.com/frappe/erpnext/issues

You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

1. Please be kind and don't send large attachments
2. For issues, features requests use https://github.com/frappe/erpnext/issues

You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/66EC18EB-F6E1-42CB-A1D1-004F55FFE2B6%40iwebnotes.com.

If rate is 10% on net total of 1000/- and the tax is included in basic rate then the actual pricing would be like this:

Selling price = 1000/1.1 = 909.09090909.... (depending upon the currency precision)
Tax would be = 1000/1.1 * 0.1 = 90.090909...  (depending upon the currency precision)

in tax table, if check that checkbox, is that need to calculate to 90.090909(depending upon the currency precision),?

Tax table is used to back-calculate the tax exclusive price which is used for accounting.

Sent from my phone

On 25-Sep-2014, at 11:42, Y Y <ya...@gmail.com> wrote:

understand now, that's mean net total already contains tax value.

in real scenario, why would add this kind of tax into tax table(as it will be 0)? is this just to show the complete tax included?

Thanks,
yang

If rate is 10% on net total of 1000/- and the tax is included in basic rate then the actual pricing would be like this:

Selling price = 1000/1.1 = 909.09090909.... (depending upon the currency precision)
Tax would be = 1000/1.1 * 0.1 = 90.090909...  (depending upon the currency precision)

Total would be 1000/-

But without inclusion the

SP = 1000/-
Tax = 100/-
Total would be 1100/-

I hope I am right.

On Wednesday, September 24, 2014 3:20:53 PM UTC+5:30, Y Y wrote:
Thanks very much.

1. Please be kind and don’t send large attachments
2. For issues, features requests use https://github.com/frappe/erpnext/issues

You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

1. Please be kind and don't send large attachments
2. For issues, features requests use https://github.com/frappe/erpnext/issues

You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.