For rounding adjustments like these, I typically use the discount columns. In your example, you can do the following to get the final total right -
Discount Type = “$" Discount How = “=“ Discount = 0.01 The Tax Invoice report allows you to change some column headers, so I just change the discount column names to “Adjustment”. It would be nice to be able to hide those columns through option settings, so no one needs to see these adjustments… On some occasions, you may end up with a final total that is less than the amount received (in your case, say it shows 418.09). In that case, you would simply make the discount as -0.01. Not a pretty solution, but I get by with these adjustments. Cheers. On 23-May-2018, at 4:47 PM, <gnucash-user-requ...@gnucash.org<mailto:gnucash-user-requ...@gnucash.org>> <gnucash-user-requ...@gnucash.org<mailto:gnucash-user-requ...@gnucash.org>> wrote: Date: Tue, 22 May 2018 21:11:26 -0400 From: Matthew Pounsett <m...@conundrum.com<mailto:m...@conundrum.com>> To: Gnucash Users <gnucash-user@gnucash.org<mailto:gnucash-user@gnucash.org>> Subject: [GNC] Invoice tax rouding issue in 2.x Message-ID: <caaiteh-dky0gqufsyy5by9_drstef1yt77oiy_r3cwqw3iu...@mail.gmail.com<mailto:caaiteh-dky0gqufsyy5by9_drstef1yt77oiy_r3cwqw3iu...@mail.gmail.com>> Content-Type: text/plain; charset="UTF-8" I've got an off-by-a-cent error on an invoice due to the way taxes are calculated. GnuCash (2.6.21) is calculating the tax on each individual taxable item, then summing that up, and adding that value to the subtotal. This causes an error because each individual tax calculation is rounded prior to subtotalling. Given a tax rate of 13%, GnuCash is doing this: Item Tax 277.50 36.08 92.50 12.03 Subtotal: 370.00 + 48.11 = 418.11 When the real calculation should be: Item Tax 277.50 36.075 92.50 12.025 Subtotal: 370.00 + 48.100 = 418.10 This could be fixed by GnuCash not rounding tax amounts until the final total, but typically I believe the calculation done is to add up all the taxable items and apply the tax calculation to that subtotal, so that it's not necessary to track many decimal places to avoid a rounding error. I did some searching through the mailing lists and I see a lot of reported issues about rounding errors in GnuCash 2.x. I can work around this by putting in an extra line item to correct the taxes, but it would be nice not to have to do that. Is this something that's been fixed in 3.x? I've been avoiding the update because I haven't had time for a careful migration, and testing whether I'm affected by any of the various issues that have been reported since its release. But, this might be a reason to set that time aside. _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.