Re: [GNC] rounding of Invoice vs Accounts Receivable

2022-10-18 Thread Maf. King
On Tuesday, 18 October 2022 14:34:34 BST Etienne wrote: > > I think for the time being that manual entry in the ledger correcting the > 1ct will have to do. Hopefully GNC will have some option down the line for > this. Unless things have changed in recent versions of GC, that is not the

Re: [GNC] rounding of Invoice vs Accounts Receivable

2022-10-18 Thread Michael or Penny Novack
@Michael, you pay VAT on the total invoice, but both items already have the VAT included on the item line. So the rounding happens at the total level. Else you get too big rounding errors (especially supermarkets when you have 9% categories and 21% items (e.g. rounding a 9% tax on a 49ct can

Re: [GNC] rounding of Invoice vs Accounts Receivable

2022-10-18 Thread Etienne
In the Bill I enter the amount 109.95, and then select the columns Taxed, Taxes Included and the Tax Table entry. It then calculates both values 18.33 and 91.63, which add up to 109.96 but the total I entered in the first amount column remains at 109.95. Only when I Post the Bill, I see a

[GNC] rounding of Invoice vs Accounts Receivable

2022-10-18 Thread flywire
Since I use cash accounting I don't have any experience with GnuCash invoicing. I process heaps of invoices, including recipient-created invoices. Tax-inclusive or tax-exclusive costs are optional in Quickbooks (which I use for business accounts) and calculated values can be user overwritten. I

Re: [GNC] rounding of Invoice vs Accounts Receivable

2022-10-17 Thread Adrien Monteleone
The problem with advertising 'inclusive' sales tax is, except in limited circumstances, usually impossible. This is because in many jurisdictions, there are taxes that scale with the amount of the total purchase, or on the day of the purchase (tax holidays anyone?) or even who the buyer is,

Re: [GNC] rounding of Invoice vs Accounts Receivable

2022-10-17 Thread R Losey
Yes and no for me... with each city in our (US) state allowed to add some percentage points to the sales tax, it would be difficult for a store to include the sales tax... but I have shopped in Europe and very much like that the price in the store is what I pay at the register. In addition, some

Re: [GNC] rounding of Invoice vs Accounts Receivable

2022-10-17 Thread R. Victor Klassen
We encounter the same problem in jurisdictions with tax computed after. Which is to say this problem is not unique to having tax-in pricing advertised. Where I see it is in bills where the GnuCash rounding differs from that used by the vendor. And it only happens when there are multiple line

Re: [GNC] rounding of Invoice vs Accounts Receivable

2022-10-17 Thread Michael or Penny Novack
On 10/17/2022 11:03 AM, gnuc...@boeziek.nl wrote: Hi, I created a Sales Tax Table entry of 20%. When I create an Invoice of EUR 109,95 with tax included and select my Tax table, GNUCash calculates EUR 18,33 tax and EUR 91,63 in net revenue. My Accounts Receivable however will not increase by

Re: [GNC] rounding of Invoice vs Accounts Receivable

2022-10-17 Thread Stan Brown
On 2022-10-17 09:53, gnuc...@boeziek.nl wrote: > Thank you Stan, > > Indeed inside EU it is compulsory to advertise pricing including VAT. So I > have to work backwards. Ah -- I'm guessing that's because VAT is imposed at several stages between raw material and final sale? Here in the US, as

Re: [GNC] rounding of Invoice vs Accounts Receivable

2022-10-17 Thread gnucash
Thank you Stan, Indeed inside EU it is compulsory to advertise pricing including VAT. So I have to work backwards. Inside the Invoice function in GNC you can’t manually edit the amounts after the Tax Table calculated them. It would be great if GNUCash will either (1) allow you to edit the tax

Re: [GNC] rounding of Invoice vs Accounts Receivable

2022-10-17 Thread Stan Brown
On 2022-10-17 08:03, gnuc...@boeziek.nl wrote: > I created a Sales Tax Table entry of 20%. > When I create an Invoice of EUR 109,95 with tax included and select my Tax > table, GNUCash calculates EUR 18,33 tax and EUR 91,63 in net revenue. > My Accounts Receivable however will not increase by EUR

[GNC] rounding of Invoice vs Accounts Receivable

2022-10-17 Thread gnucash
Hi, I created a Sales Tax Table entry of 20%. When I create an Invoice of EUR 109,95 with tax included and select my Tax table, GNUCash calculates EUR 18,33 tax and EUR 91,63 in net revenue. My Accounts Receivable however will not increase by EUR 109,95 but by 109,96. So 1 cent difference. (the