# Asset book value errors when number format is 123.456.789,00 **URL:** \ **Category:** Uncategorized\ **Created:** [January 11, 2021, 10:51pm UTC](https://forum.manager.io/t/asset-book-value-errors-when-number-format-is-123-456-789-00/32529 "2021-01-11T22:51:14Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![Frankie](https://avatars.discourse-cdn.com/v4/letter/f/258eb7/32.png) [@Frankie](https://forum.manager.io/u/Frankie)\ **Post date:** [January 11, 2021, 10:51pm UTC](https://forum.manager.io/t/asset-book-value-errors-when-number-format-is-123-456-789-00/32529/1 "2021-01-11T22:51:14Z")
Hi @lubos, the amount is shown in the wrong format. ![Screenshot](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/e/d/ed06b50cdddc0f2e5f9dc1edc9a27b0c4e422673.png) ---
**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\ **Post date:** [January 11, 2021, 11:23pm UTC](https://forum.manager.io/t/asset-book-value-errors-when-number-format-is-123-456-789-00/32529/2 "2021-01-11T23:23:14Z")
Edit screens show to full accuracy whatever the inputs to them (or the calculations that result in inputs) include. The balance sheet contribution for this asset will be limited to the format for the Euro you have defined (presumably two decimal places). This occurs throughout Manager. Your Fixed Asset Summary will also match your currency definition. You have a lock date set for some date after your start date. But somewhere, there is a transaction with three decimal places feeding into this book value. Perhaps there is a pre-start-date purchase invoice with a calculation. Or maybe you have a tax-inclusive payment that resulted in an unrounded, three-digit unit price. You will have to track that down. ---
**Author:** ![Ealfardan](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ealfardan/32/63166_2.png) [@Ealfardan](https://forum.manager.io/u/Ealfardan)\ **Post date:** [January 12, 2021, 6:43am UTC](https://forum.manager.io/t/asset-book-value-errors-when-number-format-is-123-456-789-00/32529/3 "2021-01-12T06:43:36Z")
@Tut It’s not the rounding. Manager should have calculated book value as 309.83 (that’s 780.88 - 471.05), instead it’s 30.983 which is 10x less than what it should be. That looks like a bug. ---
**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\ **Post date:** [January 12, 2021, 1:37pm UTC](https://forum.manager.io/t/asset-book-value-errors-when-number-format-is-123-456-789-00/32529/4 "2021-01-12T13:37:43Z")
I concentrated on @Frankie’s statement, “…the amount is shown in the **wrong format**.” [Emphasis added.] Then I duplicated the math. But I could not replicate the result with direct entry of the acquisition cost and accumulated depreciation: ![Screen Shot 2021-01-12 at 6.32.29 AM](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/d/4/d427428b361dd7863246b5fe3e5a59d84c04d2ba.png) So I still think there is something in the entries contributing to the starting balance. My hypothetical possibilities remain as potential explanations. There could be others. ---
**Author:** ![Frankie](https://avatars.discourse-cdn.com/v4/letter/f/258eb7/32.png) [@Frankie](https://forum.manager.io/u/Frankie)\ **Post date:** [January 12, 2021, 4:16pm UTC](https://forum.manager.io/t/asset-book-value-errors-when-number-format-is-123-456-789-00/32529/5 "2021-01-12T16:16:49Z")
@tut I’m not sure why this is but I’ll investigate further. ---
**Author:** ![Frankie](https://avatars.discourse-cdn.com/v4/letter/f/258eb7/32.png) [@Frankie](https://forum.manager.io/u/Frankie)\ **Post date:** [January 13, 2021, 10:45pm UTC](https://forum.manager.io/t/asset-book-value-errors-when-number-format-is-123-456-789-00/32529/6 "2021-01-13T22:45:30Z")
@tut, It has something to do with the number format settings. ![Screenshot2](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/7/a/7a224e95fd03fd34daf8b8abe2b20d1de7ccb59a.png) This is wrong. ![Screenshot1](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/8/6/86b53796e46499ab9cb4c53059dbc0650a3ccee9.png) ![Screenshot3](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/e/0/e0f073582719f2db31d1b599634b57c09b8e4f0e.png) This is correct. ![Screenshot4](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/7/4/743db8721a2cc66e0ee3aca3ee2a69d35a1416ac.png) ---
**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\ **Post date:** [January 13, 2021, 11:19pm UTC](https://forum.manager.io/t/asset-book-value-errors-when-number-format-is-123-456-789-00/32529/7 "2021-01-13T23:19:52Z")
@Frankie, it confuses the issue when you try to illustrate the problem you believe you have while showing different assets. Please choose one that you believe illustrates the issue and stay with it. Your software is also out of date. Please update. If your problem persists, post new screenshots illustrating it. ---
**Author:** ![Frankie](https://avatars.discourse-cdn.com/v4/letter/f/258eb7/32.png) [@Frankie](https://forum.manager.io/u/Frankie)\ **Post date:** [January 13, 2021, 11:38pm UTC](https://forum.manager.io/t/asset-book-value-errors-when-number-format-is-123-456-789-00/32529/8 "2021-01-13T23:38:26Z")
Hi @tut, it is not important which asset is used it’s the format that causes this. The version i used for the screenshots is 21.1.17 and installed just last Saturday. I updated a minute ago and the problem stays exactly the same. ![Screenshot5](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/8/c/8c6860fa37bdaec81d2c5d1958c86c0140baece8.png) ---
**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\ **Post date:** [January 14, 2021, 12:30am UTC](https://forum.manager.io/t/asset-book-value-errors-when-number-format-is-123-456-789-00/32529/9 "2021-01-14T00:30:21Z")
> [@Frankie](#): > > The version i used for the screenshots is 21.1.17 and installed just last Saturday. The reason this was important is because the Settings page where number formats are set changed after the version you were on. The problem might have been related, but apparently was not. * * * I was finally able to duplicate your problem. It is a bug, and I am moving this topic to the bugs category and editing the title to reflect the problem. 1. The bug occurs in both the Fixed Assets and Intangible Assets tabs. 2. It occurs **only** when the number format is selected as 123.456.789,00 3. The specific bug is that the decimal separator—a comma—is ignored in the calculation of `Book value`. All numbers are treated as integers. Thus, in @Frankie’s example: 3775 - 1303,91, which should yield 2.471,09 is treated as 3775 - 130391, incorrectly yielding -126616 (the correct result for the integer subtraction), which is displayed according to the number format preference as -126.616 4. To fully understand the problem, you must look at the asset Edit screen **after** it has been updated, truncating any trailing zeroes in the second decimal place. ---
**Author:** ![lubos](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/lubos/32/62798_2.png) [@lubos](https://forum.manager.io/u/lubos)\ **Post date:** [January 14, 2021, 8:56pm UTC](https://forum.manager.io/t/asset-book-value-errors-when-number-format-is-123-456-789-00/32529/10 "2021-01-14T20:56:57Z")
Fixed in the latest version (21.1.22) ---
**Author:** ![Frankie](https://avatars.discourse-cdn.com/v4/letter/f/258eb7/32.png) [@Frankie](https://forum.manager.io/u/Frankie)\ **Post date:** [January 14, 2021, 10:55pm UTC](https://forum.manager.io/t/asset-book-value-errors-when-number-format-is-123-456-789-00/32529/11 "2021-01-14T22:55:18Z")
👍 ---
**Author:** ![Ealfardan](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ealfardan/32/63166_2.png) [@Ealfardan](https://forum.manager.io/u/Ealfardan)\ **Post date:** [July 5, 2026, 8:24pm UTC](https://forum.manager.io/t/asset-book-value-errors-when-number-format-is-123-456-789-00/32529/12 "2026-07-05T20:24:34Z")
Closed on July 5, 2026, 8:24pm UTC Uncategorized topics older than 3 years with no recent activity