Skip to main content

How to set the number of decimal places for prices

Learn how to set the desired number of decimal places for displaying prices in documents, reports, and printed forms

Christina avatar
Written by Christina
Updated this week

Setting the number of decimal places

You can now choose how many decimal places to display in prices, with the option to select between 2 and 5 digits.

This setting applies globally to the company and only affects the format in which prices are displayed in documents, printed forms, reports, and exports. The data is fully preserved.

To apply these settings:

1. In the Settings > Prices and discounts > Prices section, select the number of decimal places (from 2 to 5).

2. Save the changes.

Below the selection window, there is an interactive example showing how prices will look when the setting is applied. The type of decimal separator (comma or period) depends on the country set in Regional Settings.


💡Tip

For classic retail, select 2 decimal places. If you work with large wholesale, materials “per meter/gram/hour” or need higher visual accuracy in calculations, set 3-5.


How price display works

After saving the changes, the price of each item, regardless of the specified value, is stored with an accuracy of 5 digits after the decimal point. The API will also return the value without truncation.

The settings only affect how this price is displayed in documents: the system shows the selected number of digits according to standard mathematical rounding rules (when, for example, 1.235 becomes 1.24). At the same time, internal calculations are performed using the full price. The totals in the document are also displayed with this precision.

☝ Important: rounding of payments (for example, to 0.1) differs from mathematical rounding of prices. It only applies to the total amount at the stage of working with payments and does not change the price of products or services in documents.

For example:

The document contains 2 items, the prices of which are specified with an accuracy of 5 digits: $100.45678 and $200.12345. The total amount of the document, i.e. the sum of the items, is $300.58.

If you change the number of decimal places to 3, the prices in the document will be displayed as $100.457 and $200.123, respectively, while the total amount of the document remains unchanged at $300.58.

If you change the display accuracy back to the “classic” 2 decimal places, you will see $100.46 and $200.12. The total amount of the document remains unchanged at $300.58, as the database always stores the full values.

If you also have payment rounding enabled, for example to 0.1, then $300.6 will go to the cash register.

Where this works:

  • entering and displaying prices for products, services, and sets;

  • in documents (Bookings, Estimates, Orders, Sales, Invoices, warehouse documents);

  • in reports, printing, and exporting.

These settings do not apply to:

  • the cost of sets, as it is the sum of the prices of the added components, not the price;

  • the cost of products, as the cost is not the price;

  • the cost of products.

Did this answer your question?