Rounding decimals for Bundles

See the pros and cons to rounding up/down in Thrive and how it will affect your counts.

Chris avatar
Written by Chris
Updated over a week ago

Thrive allows you to round quantities up to three decimal places. This means that in certain cases, you'll need to round up or down to make a number fit.

Rounding up ensures that you won't accidentally oversell a product. For each deduction made, you account for slightly more of the product than is required. This will create extra units of the product you're pulling from over time. Depending on how much is being pulled, these could be very small amounts, but they could still throw your inventory off.

Rounding down is a great option if what you're selling is readily available. For example, if you get closer to selling out, you can always break down another case of beer for a customer so they can be purchased individually. We are under-deducting those units by rounding down, so we are pulling slightly less than expected.

Either way, you decide to go, we always recommend regular Stocktakes to ensure quantities are as accurate as possible.

And it's good to note here that Thrive will never get between you and making a sale if you accidentally sell below zero. We allow you to sell into the negatives, but it's typically not recommended since all signs point to your quantities being incorrect.


An example of a single unit as a Bundle

Let’s say you receive one case with 24 single sodas. You can sell the case as a whole, or you can break down the case and sell the sodas individually.

To sell single sodas from the case, you would make the Bundle the soda and the component 1/24th of the case. 1/24th of the case rounds to 0.04166666666. Since we only go to three decimal places, you can round to either 0.042 or 0.041, but this can lead to differences in the total single quantity.

For example, if you round the case component up to 0.042, then 0.042 x 24 singles = 1.008 cases or 23 bottles. There will be 23 sodas in stock because you received 1 case, not 1.008.

Alternatively, you can enter 1 soda as 0.041 of the case. 0.041 x 24 singles = 0.984 cases or 24 bottles.

If the number of units in a case does not divide within three decimal places, the total number of singles will not be 100% accurate. A high volume will exacerbate errors.


An Example of the case as the Bundle

Let’s say you do the opposite setup and use the case as the Bundle and singles as the component. 24 singles will always be divided evenly into the 24-count case. However, with this method, there are nuances to be aware of for cost.

You purchase a 24-pack of soda at $8.18. The single soda lot cost is calculated as $8.18 / 24 = 0.340833 = $0.34 for each single.

The case cost is calculated based on the components, so the cost would be 24 x 0.34 = $8.16, which is 2 cents off for just one case. The incorrect cost will be exasperated for additional cases.


Priorities / Conclusions

If accurate cost tracking and easy re-ordering are the priority, make the case your component. Remember that you can always adjust the component count directly if the limitation of only being able to use up to three decimals is causing major discrepancies in quantities.

If accurate quantities are the priority, make the single unit your component. The Bundled case will pull complete quantities from the single quantities.

Keep in mind:

  • Component quantities over three decimal places will have errors in quantity.

  • Component costs (i.e., “single as component”) over three decimal places will have errors in costs/profit.

  • Singles - individual units of a case.

  • Case - a group of singles purchased from a vendor or arriving at your store as a singular unit.

Trouble deciding what should be the Bundle or component?

Which product should you make the Bundle? And which product should the Bundle ultimately pull from? There are many factors to think about. Click below for a full guide to help you make the right choice:

Did this answer your question?