Sometimes, the order line item prices shown in Onsight may look slightly different from the order line item prices shown in MYOB. This does not usually mean that the order is incorrect.
The difference happens because Onsight and MYOB store prices, display prices, calculate taxes, and, most importantly, apply rounding in different ways.
This article explains why this happens, what the different scenarios are, and what settings can be changed depending on how you prefer to work in MYOB.
The first thing to note is that Onsight and MYOB store prices differently. In MYOB, you can specify item prices ex tax by unchecking the “Prices are Tax Inclusive” checkbox and you can also specify prices inc tax by having the “Prices are Tax Inclusive” checkbox ticked. In Onsight there is no concept of tax inclusive or tax exclusive pricing. We always store all prices excluding taxes. Then we add the taxes and show it to the user when needed.
In MYOB, when creating or viewing an order, you can tick and untick “Tax Inclusive”. When this checkbox is unticked, MYOB treats the item prices as excluding tax. When this checkbox is ticked, MYOB treats the item prices as including tax. In Onsight you cannot do this. When creating orders or viewing orders, prices are always without taxes. We then add the taxes afterwards and show the after-tax total.
The second thing to note is that Onsight and MYOB do rounding differently. Rounding is usually not noticeable when prices, quantities, discounts, and tax amounts produce clean numbers.
However, rounding differences become more visible when the order includes:
Once a discount is applied and tax is added, the calculated value may contain more than two decimal places. MYOB requires line item totals to be rounded to two decimal places. Our integration needs to ensure that the order can be accepted by MYOB.
Because of this, one of two things can happen:
In other words, when tax, discounts, and rounding are involved, it is not always possible for every number to match perfectly in both systems at the same time.
MYOB has strict rules for order line items.
For each line item, MYOB requires the following calculation to balance:
Line Item Total = (Unit Price × Ship Quantity) × (1 – Discount Percent)
MYOB also requires the line item total to be rounded to two decimal places. If the line item does not balance according to MYOB’s rules, MYOB may reject the order. Onsight’s MYOB integration is designed to make sure the order is sent in a format that MYOB will accept. This means that sometimes Onsight needs to adjust how values are sent to MYOB so that the order passes MYOB’s validation rules.
When an order has both discounts and taxes, the numbers shown in Onsight and MYOB can differ depending on two things:
The Onsight MYOB integration can be configured to have a line item balancing field. This can be set to either of these fields:
MYOB also has a checkbox on the order screen: ‘Tax Inclusive’. This can be:
This creates four possible scenarios.
| Line item field for balancing | Line item field kept the same | MYOB Tax Inclusive checkbox | What may look different |
|---|---|---|---|
| Total | Unit price | Unticked | Line item total may differ slightly |
| Total | Unit price | Ticked | Tax-inclusive unit price and line item total may look different |
| UnitPrice | Total | Unticked | Unit price may differ slightly |
| UnitPrice | Total | Ticked | Tax-inclusive unit price and line item total may look different |
Onsight syncs tax rates from MYOB and uses those tax rates when showing order totals to users in the Onsight app and web console. When sending orders to MYOB, we generally do not send the Onsight tax calculations. We rather allow MYOB to redo the tax calculations the way it normally does. This ensures that taxes are calculated using MYOB’s built-in tax engine. It is possible for us to customise your integration so that we send the Onsight tax calculations to MYOB to replace MYOB’s own calculations.
As a wholesale distributor, we recommend that you always work with pre-tax prices. We recommend that you always have the checkbox ‘Tax Inclusive’ unchecked on the order screen in MYOB. We recommend that you always have the “Prices are Tax Inclusive” checkbox unchecked on the item screen in MYOB. If you do this, it is pretty likely that the order line item numbers in Onsight and the numbers in MYOB will be exactly the same.
By default, we always keep the line item Price field the same and we balance the line item by changing the Total field. If you would like us to change which field we use to balance order line items, please reach out to [email protected] . You can then test this setup to see if it suits you better.
By default, we always let MYOB recalculate taxes itself. If you would like us to change this and rather send the Onsight tax calculations to MYOB, please reach out to [email protected] . You can then test this setup to see if it suits you better.