# Rounding problem **URL:** \ **Category:** Uncategorized\ **Created:** [July 12, 2017, 12:10am UTC](https://forum.manager.io/t/rounding-problem/10533 "2017-07-12T00:10:36Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Eu\_Mesmo](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/eu_mesmo/32/18423_2.png) [@Eu\_Mesmo](https://forum.manager.io/u/Eu_Mesmo)\ **Post date:** [July 12, 2017, 12:10am UTC](https://forum.manager.io/t/rounding-problem/10533/1 "2017-07-12T00:10:36Z")
I have one supplier invoice that i can’t make total look like what they sent… all products have 2% discount (i changed the penultimate to 1% to make total look right) ![](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/2X/b/bf32fe6eb8807a94b52e25603a144377ca7753a6.jpg) so, that will make 20.12€, if i put 2% in the penultimate one, will make 20.11€… (after update green is pressed) the last one is freigt-in. ---
**Author:** ![Brucanna](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/brucanna/32/1960_2.png) [@Brucanna](https://forum.manager.io/u/Brucanna)\ **Post date:** [July 12, 2017, 12:45am UTC](https://forum.manager.io/t/rounding-problem/10533/2 "2017-07-12T00:45:07Z")
You didn’t say what the total should be ? But, that is where you need to use a Rounding Account, so the invoice is correct (or adjust the Freight-in amount to reflect the rounding required) ---
**Author:** ![Eu\_Mesmo](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/eu_mesmo/32/18423_2.png) [@Eu\_Mesmo](https://forum.manager.io/u/Eu_Mesmo)\ **Post date:** [July 12, 2017, 9:04am UTC](https://forum.manager.io/t/rounding-problem/10533/3 "2017-07-12T09:04:57Z")
the problem is: 20.1289 should be 20.13 in the invoice list, isn’t? ---
**Author:** ![Brucanna](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/brucanna/32/1960_2.png) [@Brucanna](https://forum.manager.io/u/Brucanna)\ **Post date:** [July 12, 2017, 10:52am UTC](https://forum.manager.io/t/rounding-problem/10533/4 "2017-07-12T10:52:00Z")
Then make the Freight-in 3.9011. The problem is that 3rd & 4th decimal point aren’t adding up to a round 2 decimal point number. ---
**Author:** ![sharpdrivetek](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/sharpdrivetek/32/34244_2.png) [@sharpdrivetek](https://forum.manager.io/u/sharpdrivetek)\ **Post date:** [July 12, 2017, 12:02pm UTC](https://forum.manager.io/t/rounding-problem/10533/5 "2017-07-12T12:02:08Z")
Forgive me but is it necessary to have four decimal positions? I think setting it to two decimal places will solve most rounding issues since your supplier also would be using such number format. Also, I thought the number format in Manager can be set only upto two decimal places. ---
**Author:** ![Eu\_Mesmo](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/eu_mesmo/32/18423_2.png) [@Eu\_Mesmo](https://forum.manager.io/u/Eu_Mesmo)\ **Post date:** [July 12, 2017, 12:32pm UTC](https://forum.manager.io/t/rounding-problem/10533/6 "2017-07-12T12:32:05Z")
where do you force the use of only two decimal places? ---
**Author:** ![sharpdrivetek](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/sharpdrivetek/32/34244_2.png) [@sharpdrivetek](https://forum.manager.io/u/sharpdrivetek)\ **Post date:** [July 12, 2017, 12:33pm UTC](https://forum.manager.io/t/rounding-problem/10533/7 "2017-07-12T12:33:37Z")
On the top tab in Manager, select Preferences and set your preferred number format. ---
**Author:** ![Eu\_Mesmo](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/eu_mesmo/32/18423_2.png) [@Eu\_Mesmo](https://forum.manager.io/u/Eu_Mesmo)\ **Post date:** [July 12, 2017, 12:35pm UTC](https://forum.manager.io/t/rounding-problem/10533/8 "2017-07-12T12:35:31Z")
I don’t see any option there with anything above two decimal places. I have 123,456,789.00 ---
**Author:** ![sharpdrivetek](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/sharpdrivetek/32/34244_2.png) [@sharpdrivetek](https://forum.manager.io/u/sharpdrivetek)\ **Post date:** [July 12, 2017, 12:37pm UTC](https://forum.manager.io/t/rounding-problem/10533/9 "2017-07-12T12:37:00Z")
That is exactly the reason i asked you if its necessary to have more than two decimal places ---
**Author:** ![Eu\_Mesmo](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/eu_mesmo/32/18423_2.png) [@Eu\_Mesmo](https://forum.manager.io/u/Eu_Mesmo)\ **Post date:** [July 12, 2017, 12:41pm UTC](https://forum.manager.io/t/rounding-problem/10533/10 "2017-07-12T12:41:42Z")
i don’t see the point of your question, i don’t use 4 decimal places, it’s not my fault that 1.98€ minus 2% is 1.9404, manager have to deal with it ---
**Author:** ![sharpdrivetek](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/sharpdrivetek/32/34244_2.png) [@sharpdrivetek](https://forum.manager.io/u/sharpdrivetek)\ **Post date:** [July 12, 2017, 12:47pm UTC](https://forum.manager.io/t/rounding-problem/10533/11 "2017-07-12T12:47:18Z")
My point is, if in your country the usual practice is to have two decimal places, why not set a number format as per the same. Manager works the way we set it to work. > [@Eu\_Mesmo](#): > > the problem is: 20.1289 should be 20.13 in the invoice list, isn’t? your post shows your supplier is using a two decimal format, then why do you use four decimals? Manager will round the value only according to your preferences. The rounding is different for two decimal and four decimal respectively. ---
**Author:** ![Eu\_Mesmo](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/eu_mesmo/32/18423_2.png) [@Eu\_Mesmo](https://forum.manager.io/u/Eu_Mesmo)\ **Post date:** [July 12, 2017, 12:49pm UTC](https://forum.manager.io/t/rounding-problem/10533/12 "2017-07-12T12:49:26Z")
lol where i use 4 decimal places? i don’t use them! maths is done by manager, no? “it’s not my fault that 1.98€ minus 2% is 1.9404” ---
**Author:** ![Eu\_Mesmo](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/eu_mesmo/32/18423_2.png) [@Eu\_Mesmo](https://forum.manager.io/u/Eu_Mesmo)\ **Post date:** [July 12, 2017, 12:55pm UTC](https://forum.manager.io/t/rounding-problem/10533/13 "2017-07-12T12:55:40Z")
putting 3.9011 will give 20.1201 total, BUT when you press UPDATE, will give 20.11€ ---
**Author:** ![sharpdrivetek](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/sharpdrivetek/32/34244_2.png) [@sharpdrivetek](https://forum.manager.io/u/sharpdrivetek)\ **Post date:** [July 12, 2017, 1:05pm UTC](https://forum.manager.io/t/rounding-problem/10533/14 "2017-07-12T13:05:32Z")
sorry my mistake. the line items total is calculated irrespective of the decimal places set under preferences. you will have to adjust the values accordingly so that it matches your supplier invoice. try putting freight as 3.92 ---
**Author:** ![Brucanna](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/brucanna/32/1960_2.png) [@Brucanna](https://forum.manager.io/u/Brucanna)\ **Post date:** [July 12, 2017, 1:08pm UTC](https://forum.manager.io/t/rounding-problem/10533/15 "2017-07-12T13:08:17Z")
> [@sharpdrivetek](#): > > if its necessary to have more than two decimal places Manager when doing calculations uses as many decimal points as required so that the impact on rounding is minimal - but is only displayed up to four. To limit to do two decimals as you suggest will cause even more problems. Consider this: 1.2346 x 10 = 12.346 or 12.35 rounded, but 1.2346 rounded to two decimals - 1.23 x 10 = 12.30, a variance of 0.05 > [@Eu\_Mesmo](#): > > putting 3.9011 This was based on your screenshot above showing 20.1289, so adding 0.0011 will equal 20.13. However, if you have changed the 1% to 2% for the second last entry, then you need to adjust the 3.9011 to suit the new circumstances… ---
**Author:** ![sharpdrivetek](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/sharpdrivetek/32/34244_2.png) [@sharpdrivetek](https://forum.manager.io/u/sharpdrivetek)\ **Post date:** [July 12, 2017, 1:10pm UTC](https://forum.manager.io/t/rounding-problem/10533/16 "2017-07-12T13:10:29Z")
> [@Brucanna](#): > > Manager when doing calculations uses as many decimal points as required so that the impact on rounding is minimal - but is only displayed up to four. To limit to do two decimals as you suggest will cause even more problems. Consider this: 1.2346 x 10 = 12.346 or 12.35 rounded, but 1.2346 rounded to two decimals - 1.23 x 10 = 12.30, a variance of 0.05 I understood. Thanks for clearing that. Some more knowledge gained. 🙂 ---
**Author:** ![Eu\_Mesmo](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/eu_mesmo/32/18423_2.png) [@Eu\_Mesmo](https://forum.manager.io/u/Eu_Mesmo)\ **Post date:** [July 12, 2017, 1:17pm UTC](https://forum.manager.io/t/rounding-problem/10533/17 "2017-07-12T13:17:42Z")
> [@Brucanna](#): > > This was based on your screenshot above showing 20.1289, so adding 0.0011 will equal 20.13. > However, if you have changed the 1% to 2% for the second last entry, then you need to adjust the 3.9011 to suit the new circumstances… like i said “putting 3.9011 will give 20.1201 total, BUT when you press UPDATE, will give 20.11€” the problem i see, is manager having multiple rounding approaches across the view panels ---
**Author:** ![dcVest](https://avatars.discourse-cdn.com/v4/letter/d/aca169/32.png) [@dcVest](https://forum.manager.io/u/dcVest)\ **Post date:** [July 12, 2017, 1:37pm UTC](https://forum.manager.io/t/rounding-problem/10533/18 "2017-07-12T13:37:22Z")
Manager does not round until the transaction is posted, that is you push the Create or Update button. Your supplier may be rounding in any of a number of ways on his invoice. Manager does not provided a way to control rounding on purchase invoices because there is no certainty that it would be the same method as used by your supplier. There is a guide that explains how to handle your situation: [Adjust rounding differences on purchase invoices](https://www.manager.io/guides/adjust-rounding-differences-on-purchase-invoices/9499) ---
**Author:** ![dcVest](https://avatars.discourse-cdn.com/v4/letter/d/aca169/32.png) [@dcVest](https://forum.manager.io/u/dcVest)\ **Post date:** [July 12, 2017, 2:18pm UTC](https://forum.manager.io/t/rounding-problem/10533/19 "2017-07-12T14:18:13Z")
> [@Eu\_Mesmo](#): > > like i said “putting 3.9011 will give 20.1201 total, BUT when you press UPDATE, will give 20.11€” I prepared your example in Excel so you can see that Manager is correct; ![](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/2X/9/9545880d139e8202b643468262524367ff62328a.jpg) Summing the `Amount` column gives a total of 20.1201 Rounding each line item and then summing the `After Rounding` column gives a total of 20.11. This is what Manager does after you click the Create or Update button. ---
**Author:** ![Eu\_Mesmo](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/eu_mesmo/32/18423_2.png) [@Eu\_Mesmo](https://forum.manager.io/u/Eu_Mesmo)\ **Post date:** [July 12, 2017, 2:52pm UTC](https://forum.manager.io/t/rounding-problem/10533/20 "2017-07-12T14:52:38Z")
> [@dcVest](#): > > This is what Manager does after you click the Create or Update button. this makes no sense, when we click update/create only total should be taken into account, makes no sense to have two ways with two total [Next page](https://forum.manager.io/t/rounding-problem/10533.md?page=2)