Tax Rounding Methods For Imported Orders Round Up, Down, And Bankers

Tax Rounding Methods For Imported Orders Round Up, Down, And Bankers

414 
If you are seeing order import exceptions where the ORDER_STATE_SALES_TAX differs from the OrderLogix calculated amount by a few cents and you have already verified with your vendor that you are utilizing the correct Tax Calculation Method (_see article explaining this setting here https://support.orderlogix.com/portal/en/kb/articles/tax-calculation-methods then you should check which method of rounding your vendor is using when calculating tax so that they can send the setting to match the method used.

OrderLogix defaults to use the method ROUND but also supports UP DOWN and BANKERS for imported orders. 

Round: The number will be rounded down if the following digit is less than 5 (0 1 2 3 4) and will be rounded up if the following digit is 5 or greater (5 6 7 8 9). (ex. 1.234 would round to 1.23 and 1.237 would round to 1.24)

Up: If there are any digits following then the number will be rounded up _(ex. 10.5602 would round to 10.57)

Down: If there are any digits following then the number will be rounded down _(ex. 10.629 would round to 10.62)

Bankers: The number will be rounded down if the following digit is less than 5 (0 1 2 3 4). It will be rounded up if the following digit is greater than 5 (6 7 8 9). If the following digit is 5 then round up or down to the even number (ex. 10.565 would round down to 10.56 because 6 is an even number. 10.575 would round up to 10.58 because 8 is an even number.)  This method is also sometimes referred to as half round even.

The rounding method is set on the import configuration page for Batch File imports by selecting from the drop down labeled “Tax rounding method”.

For the API Order Import this is a setting labeled “TAX_ROUNDING_METHOD”.

If you still have questions regarding the material covered in this article please contact OrderLogix Customer Care for assistance. Thank you!
    • Related Articles

    • How to Calculate Tax on an Imported Order

      There are several settings available with the API Order Import to allow for OrderLogix calculations upon import to match the source system’s calculations. SOME THINGS TO CONSIDER THAT MAY IMPACT THE WAY WE CALCULATE TAX ON AN IMPORTED ORDER: OLX or ...
    • Tax Calculation Methods

      388;"388";" OrderLogix allows for three different tax calculation methods within the standard order imports: Order Level Item Level and Order Total. Setting the tax calculation method incorrectly on the import may result in a penny (0.01)  or two ...
    • WARNING: ORDER_STATE_SALES_TAX has the value "$X.XX". State tax must match this order's calculated amount "$X.XX".

      Message:  WARNING: ORDER_STATE_SALES_TAX  has the value "$X.XX". State tax must match this order's calculated amount "$X.XX". Explanation:  The tax supplied for the order does not match the amount that is being calculated during the validation check ...
    • WARNING: ORDER_FEDERAL_SALES_TAX has the value "X.XX". Federal tax must match this order's calculated amount "X.XX".

      Message: WARNING: ORDER_FEDERAL_SALES_TAX has the value "X.XX". Federal tax must match this order's calculated amount "X.XX". Explanation:  The federal tax supplied for the order does not match the amount that is being calculated during the ...
    • Tax Exemptions

      There may be certain scenarios where you would not wish to apply tax for one order, or for one product offer for orders entered directly into OrderLogix. Below will walk you through different approaches which can be taken to accomplish each of these ...