Sometimes a line's quantity multiplied by its displayed unit price does not equal the displayed sub-total, or a supplier's quoted total differs from TenderBoard's by a cent. This page explains why and what to do.
How TenderBoard calculates and displays amounts
- Amounts are stored exactly as entered, with as many decimal places as you or the supplier typed (for example a unit price of $0.142857). Buyer admins can limit the number of decimal places suppliers may enter for unit prices in Organisation Settings (line item validation).
- Amounts are displayed rounded: 2 decimal places for most screens and currencies, up to 4 on the supplier's bid form line totals.
- Sub-totals, tax and totals are calculated from the stored values, not from the rounded display values. Only the displayed figure is rounded.
So the sub-totals and grand total are correct, and the only thing that is "off" is a unit price that has been rounded for display.
Example: the display does not multiply up
| Quantity | Unit price | Sub-total | |
|---|---|---|---|
| Stored | 7 | $0.142857 | $1.00 |
| Displayed | 7 | $0.14 | $1.00 |
7 × $0.14 looks like $0.98, but the real unit price is $0.142857 and the sub-total of $1.00 is right. Nothing needs fixing. If you need the exact unit price, open the line item to see the stored value.
Example: the supplier's GST total is one cent different
TenderBoard calculates GST on each line from the stored amounts and rounds only the displayed total. A supplier's own system may round each line's GST to the cent first and then add them up. The two methods can differ by a cent:
| 3 lines of $10.05 at 9% GST | GST per line | GST total |
|---|---|---|
| Rounded per line, then added (supplier's system) | $0.90 | $2.70 |
| Exact per line, added, then rounded (TenderBoard) | $0.9045 | $2.71 |
At award, use TenderBoard's figure: a one-cent difference in the quotation does not need a resubmission. When the supplier's invoice arrives with their figure, edit the tax amount on the affected invoice line so the invoice matches what they billed. The same adjustment is available on credit notes and goods receipts. See How do I adjust the value for taxes.
Partial quantities on goods receipts
Goods receipts accept decimal quantities (for example 0.25 of an item) and value them correctly.
Still see a mismatch?
If a total is wrong by more than a rounding cent, or a sub-total does not match the stored values, email support@tenderboard.biz with the deal reference number and a screenshot of the line.