Alexandre Demers Posted February 2 Share Posted February 2 For an invoice that has the following items: Item A @ 359.88$ Item B @ 203.88$ Item C @ 119.88$ the total is 683.64$. If I apply a 5% tax to every item, here's what Sage is doing: Item A @ 359.88$ x 5% = 17.994$, Sage rounds it at 17.99$ (0.004 is lost) Item B @ 203.88$ x 5% = 5.994$, Sage rounds it at 5.99$ (0.004 is lost) Item C @ 119.88$ x 5% = 10.194$, Sage rounds it at 10.19$ (0.004 is lost) Now, Sage adds up all of the their calculated tax amounts: 17.99$ + 5.99$ + 10.19$ + 8.40$ = 34.17$ But, if we keep the fractions of cents, the real amount should be: 34.182$, rounded to 34.18$. Also, simpler: adding all of the items amount and then calculating the 5% tax on the total gives the same results as 34.182$, rounded to 34.18$. So, we lose 1 cent in this example with Sage's calculations. I bring this up because this was a real-world example of an invoice generated with Stripe (which charged the customer) and which doesn't match what Sage calculates, which brings complexity with our financial department. We need to adjust the certain invoices where the taxes are incorrectly calculated. Is this a bug, or I'm doing something wrong? I have attached a screenshot of an example invoice with this example. Link to comment Share on other sites More sharing options...
Alexandre Demers Posted February 2 Author Share Posted February 2 Quote Now, Sage adds up all of the their calculated tax amounts: 17.99$ + 5.99$ + 10.19$ + 8.40$ = 34.17$ The 8.40$ shouldn't be there, but the total is the same. Link to comment Share on other sites More sharing options...
Steel, Mark Posted February 5 Share Posted February 5 Hi Alexandre, Thank you for your post. This community supports integrators of Sage products with issues, requests and ideas. Product related questions have a greater visibility to our product managers and users in the Sage City community - https://communityhub.sage.com/ Thanks Mark Link to comment Share on other sites More sharing options...
Alexandre Demers Posted February 5 Author Share Posted February 5 I posted this in the "Bugs" forums for the product I'm using, because I see this as a bug. Link to comment Share on other sites More sharing options...
Steel, Mark Posted February 6 Share Posted February 6 Thanks Alexandre, This is the bug section for our API's used by our integrators. Thanks Mark Link to comment Share on other sites More sharing options...
Alexandre Demers Posted March 20 Author Share Posted March 20 Stripe offers a solution to this Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now