Re: [GNC] Rounding discrepancy in payment processing [SOLVED]
as my purpose was to be able to upgrade to the current version with my books in good order. That is possible now with these corrected settings. Summary: 1. Rounding was caused by setting “Smallest Fraction” to “1”. Unless whole numbers are required, this should be set to “Use Commodity Value” or 1/10, 1/100, etc., depending on the number of decimal places required. (Accounts>Edit Account>Smallest fraction). 2. For multiple currencies, “Use Trading Accounts” must be activated. (File>Properties>check “Use Trading Accounts”) 3. Applying “Actions>Check & Repair>All Transactions” on the relevant A/R accounts may be needed to fix previous discrepancies. 4. Some currencies, like JPY, have zero decimal places and will always be rounded. The Security Editor lists those with a Fraction value of “1”. (Tools>Security Editor>Check “Show National Currencies”>Expand Currencies>Click the Fraction column to sort on the Fraction value”. They can also be looked up here “ISO 4217 - Wikipedia <https://en.wikipedia.org/wiki/ISO_4217#Active_codes> ”. I hope this helps. Alaa -Original Message- From: gnucash-user On Behalf Of Alaa Zeineldine Sent: Sunday, December 25, 2022 2:50 AM To: 'Murugan Muruganandam' Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Rounding discrepancy in payment processing Hello Murugan,. Removing data from the live setup may not be trivial, it’s several years’ worth of transactions, 30 customers and several checking and PayPal accounts in three currencies. The good news is that I am playing with a number of test cases and may have pinpointed the problem with default dollar accounts. I will post my conclusion when I have more definitive results. But it may be an error on my part. If these findings are confirmed, then my problem will have been resolved for the majority of my transactions which are dollar based. However, discrepancies with the non-dollar accounts will still be an issue. Which brings me to a question. For multiple currencies, should I activate “Trading Accounts”? Regards, Alaa Zeineldine From: Murugan Muruganandam < <mailto:m.muruganan...@hotmail.com> m.muruganan...@hotmail.com> Sent: Friday, December 23, 2022 10:15 PM To: Alaa Zeineldine < <mailto:a...@expertwell.com> a...@expertwell.com> Subject: Re: [GNC] Rounding discrepancy in payment processing hi Alaa I am not able to simulate your case, unless i can access your setup. is it possible to send me without data your actual setup? Saludos Cordiales Murugan _ From: Alaa Zeineldine < <mailto:a...@expertwell.com%20%3cmailto:a...@expertwell.com> a...@expertwell.com <mailto:a...@expertwell.com> > Sent: Thursday, December 22, 2022 8:37 PM To: 'Murugan Muruganandam' < <mailto:m.muruganan...@hotmail.com%20%3cmailto:m.muruganan...@hotmail.com> m.muruganan...@hotmail.com <mailto:m.muruganan...@hotmail.com> > Cc: <mailto:gnucash-user@gnucash.org> gnucash-user@gnucash.org < <mailto:gnucash-user@gnucash.org> mailto:gnucash-user@gnucash.org> < <mailto:gnucash-user@gnucash.org%20%3cmailto:gnucash-user@gnucash.org> gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> > Subject: RE: [GNC] Rounding discrepancy in payment processing Hello Murugan, On my live setup rounding happens for all currencies, including the default currency. That is the problem for which I started this thread in the beginning. In addition, this rounding leads to discrepancies in payment processing. Regards, Alaa From: Murugan Muruganandam < <mailto:m.muruganan...@hotmail.com%20%3cmailto:m.muruganan...@hotmail.com> m.muruganan...@hotmail.com <mailto:m.muruganan...@hotmail.com> > Sent: Thursday, December 22, 2022 3:01 PM To: Alaa Zeineldine < <mailto:a...@expertwell.com%20%3cmailto:a...@expertwell.com> a...@expertwell.com <mailto:a...@expertwell.com> > Cc: <mailto:gnucash-user@gnucash.org> gnucash-user@gnucash.org < <mailto:gnucash-user@gnucash.org> mailto:gnucash-user@gnucash.org> Subject: Re: [GNC] Rounding discrepancy in payment processing hi Alaa this is the behaviour i also observerd, so the rounding is controlled by the currency of the customer. so probably you can try a new customer in your existing install and check Saludos Cordiales Murugan _ From: Alaa Zeineldine < <mailto:a...@expertwell.com%20%3cmailto:a...@expertwell.com> a...@expertwell.com <mailto:a...@expertwell.com> > Sent: Wednesday, December 21, 2022 5:05 PM To: 'Murugan Muruganandam' < <mailto:m.muruganan...@hotmail.com> m.muruganan...@hotmail.com> Cc: <mailto:gnucash-user@gnucash.org> gnucash-user@gnuc
Re: [GNC] Rounding discrepancy in payment processing
Hello Murugan,. Removing data from the live setup may not be trivial, it’s several years’ worth of transactions, 30 customers and several checking and PayPal accounts in three currencies. The good news is that I am playing with a number of test cases and may have pinpointed the problem with default dollar accounts. I will post my conclusion when I have more definitive results. But it may be an error on my part. If these findings are confirmed, then my problem will have been resolved for the majority of my transactions which are dollar based. However, discrepancies with the non-dollar accounts will still be an issue. Which brings me to a question. For multiple currencies, should I activate “Trading Accounts”? Regards, Alaa Zeineldine From: Murugan Muruganandam Sent: Friday, December 23, 2022 10:15 PM To: Alaa Zeineldine Subject: Re: [GNC] Rounding discrepancy in payment processing hi Alaa I am not able to simulate your case, unless i can access your setup. is it possible to send me without data your actual setup? Saludos Cordiales Murugan _ From: Alaa Zeineldine mailto:a...@expertwell.com> > Sent: Thursday, December 22, 2022 8:37 PM To: 'Murugan Muruganandam' mailto:m.muruganan...@hotmail.com> > Cc: gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> mailto:gnucash-user@gnucash.org> > Subject: RE: [GNC] Rounding discrepancy in payment processing Hello Murugan, On my live setup rounding happens for all currencies, including the default currency. That is the problem for which I started this thread in the beginning. In addition, this rounding leads to discrepancies in payment processing. Regards, Alaa From: Murugan Muruganandam mailto:m.muruganan...@hotmail.com> > Sent: Thursday, December 22, 2022 3:01 PM To: Alaa Zeineldine mailto:a...@expertwell.com> > Cc: gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> Subject: Re: [GNC] Rounding discrepancy in payment processing hi Alaa this is the behaviour i also observerd, so the rounding is controlled by the currency of the customer. so probably you can try a new customer in your existing install and check Saludos Cordiales Murugan _ From: Alaa Zeineldine mailto:a...@expertwell.com> > Sent: Wednesday, December 21, 2022 5:05 PM To: 'Murugan Muruganandam' Cc: gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> mailto:gnucash-user@gnucash.org> > Subject: RE: [GNC] Rounding discrepancy in payment processing Hello Murugan, I went ahead and created a Yen A/R account under the default A/R account. I then added an invoice for your Yen based Customer 1, with a value of 236.78. The value of this invoice is rounded up in the totals and the A/R Aging report. On the other hand, values of the dollar-based customers are not affected. I also added an invoice to a dollar client. No rounding or discrepancies exhibited in this case. This is closer to the behavior of my actual live setup, except that in my setup rounding happens for all clients, including dollar clients. The resulting test .gnucash file is attached for your perusal. Regards, Alaa -Original Message- From: gnucash-user mailto:gnucash-user-bounces+alaa=expertwell@gnucash.org> > On Behalf Of Alaa Zeineldine Sent: Wednesday, December 21, 2022 4:28 PM To: 'Murugan Muruganandam' mailto:m.muruganan...@hotmail.com> > Cc: gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> Subject: Re: [GNC] Rounding discrepancy in payment processing Hello Murugan, Thanks. I opened the file you sent and saw the new customer with the new invoice you created, which seems to be empty. I think the problems begin when an invoice with an amount is created. In this case, GC will require an A/R account with the same currency as the customer. That is when discrepancies begin to appear. I have a question before I proceed with adding test invoices. In my original live setup, I have the non-dollar A/R accounts as children of the dollar (default) A/R account, so that the parent account always shows the total A/R amount. • My question is whether this is the correct setup, and if not, where should the A/R accounts for the secondary currencies be placed? Regards, Alaa From: Murugan Muruganandam mailto:m.muruganan...@hotmail.com> > Sent: Wednesday, December 21, 2022 3:41 PM To: Alaa Zeineldine mailto:a...@expertwell.com> > Subject: Re: [GNC] Rounding discrepancy in payment processing hi Alaa i have created a customer called customer 1 with their currency as Yen. i have created a invoice also for your reference. you can try creating new invoices with franctions for them and you can see the rounding Saludos Cordiales Murugan _ From: Alaa Zeineldine mailto:a...@expertwell.com> > Sent: Tuesday, December 20, 2
Re: [GNC] Rounding discrepancy in payment processing
Hello Murugan, On my live setup rounding happens for all currencies, including the default currency. That is the problem for which I started this thread in the beginning. In addition, this rounding leads to discrepancies in payment processing. Regards, Alaa From: Murugan Muruganandam Sent: Thursday, December 22, 2022 3:01 PM To: Alaa Zeineldine Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Rounding discrepancy in payment processing hi Alaa this is the behaviour i also observerd, so the rounding is controlled by the currency of the customer. so probably you can try a new customer in your existing install and check Saludos Cordiales Murugan _ From: Alaa Zeineldine mailto:a...@expertwell.com> > Sent: Wednesday, December 21, 2022 5:05 PM To: 'Murugan Muruganandam' mailto:m.muruganan...@hotmail.com> > Cc: gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> mailto:gnucash-user@gnucash.org> > Subject: RE: [GNC] Rounding discrepancy in payment processing Hello Murugan, I went ahead and created a Yen A/R account under the default A/R account. I then added an invoice for your Yen based Customer 1, with a value of 236.78. The value of this invoice is rounded up in the totals and the A/R Aging report. On the other hand, values of the dollar-based customers are not affected. I also added an invoice to a dollar client. No rounding or discrepancies exhibited in this case. This is closer to the behavior of my actual live setup, except that in my setup rounding happens for all clients, including dollar clients. The resulting test .gnucash file is attached for your perusal. Regards, Alaa -Original Message- From: gnucash-user mailto:gnucash-user-bounces+alaa=expertwell@gnucash.org> > On Behalf Of Alaa Zeineldine Sent: Wednesday, December 21, 2022 4:28 PM To: 'Murugan Muruganandam' mailto:m.muruganan...@hotmail.com> > Cc: gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> Subject: Re: [GNC] Rounding discrepancy in payment processing Hello Murugan, Thanks. I opened the file you sent and saw the new customer with the new invoice you created, which seems to be empty. I think the problems begin when an invoice with an amount is created. In this case, GC will require an A/R account with the same currency as the customer. That is when discrepancies begin to appear. I have a question before I proceed with adding test invoices. In my original live setup, I have the non-dollar A/R accounts as children of the dollar (default) A/R account, so that the parent account always shows the total A/R amount. • My question is whether this is the correct setup, and if not, where should the A/R accounts for the secondary currencies be placed? Regards, Alaa From: Murugan Muruganandam mailto:m.muruganan...@hotmail.com> > Sent: Wednesday, December 21, 2022 3:41 PM To: Alaa Zeineldine mailto:a...@expertwell.com> > Subject: Re: [GNC] Rounding discrepancy in payment processing hi Alaa i have created a customer called customer 1 with their currency as Yen. i have created a invoice also for your reference. you can try creating new invoices with franctions for them and you can see the rounding Saludos Cordiales Murugan _ From: Alaa Zeineldine mailto:a...@expertwell.com> > Sent: Tuesday, December 20, 2022 9:27 PM To: 'Murugan Muruganandam' mailto:m.muruganan...@hotmail.com> > Subject: RE: [GNC] Rounding discrepancy in payment processing Hello Murugan, I did lookup a number of customers, each of which had a USD currency, and their invoices were also USD, but rounding still occurs for them. Can you elaborate on what you mean by “a customer currency with no fractions”? Regards, Alaa From: Murugan Muruganandam mailto:m.muruganan...@hotmail.com> > Sent: Wednesday, December 21, 2022 1:58 AM To: Alaa Zeineldine mailto:a...@expertwell.com> > Subject: Re: [GNC] Rounding discrepancy in payment processing Alaa The rounding occurs based on the customer currency , so if your base currency and customer currency are USD , it will not have any problem , but in case you have a customer currency with no fractions , even when you create USD invoice it will round it , Can you look up one customer and tell me the currency of the customer and invoice currency Regard Murugan On 20-12-2022, at 18:22, Alaa Zeineldine mailto:a...@expertwell.com> > wrote: Hello Murugan, Thanks for looking into this. I checked a number of customers, and each shows the currency that was entered when I created the customer initially. I also checked a number of invoices and found that the currency for the invoice was consistent with that of the customer. Please note the reply to David Kirkby that I sent to the list. I created a minimal test .gnucash file with only
Re: [GNC] Rounding discrepancy in payment processing
Hello Murugan, I went ahead and created a Yen A/R account under the default A/R account. I then added an invoice for your Yen based Customer 1, with a value of 236.78. The value of this invoice is rounded up in the totals and the A/R Aging report. On the other hand, values of the dollar-based customers are not affected. I also added an invoice to a dollar client. No rounding or discrepancies exhibited in this case. This is closer to the behavior of my actual live setup, except that in my setup rounding happens for all clients, including dollar clients. The resulting test .gnucash file is attached for your perusal. Regards, Alaa -Original Message- From: gnucash-user On Behalf Of Alaa Zeineldine Sent: Wednesday, December 21, 2022 4:28 PM To: 'Murugan Muruganandam' Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Rounding discrepancy in payment processing Hello Murugan, Thanks. I opened the file you sent and saw the new customer with the new invoice you created, which seems to be empty. I think the problems begin when an invoice with an amount is created. In this case, GC will require an A/R account with the same currency as the customer. That is when discrepancies begin to appear. I have a question before I proceed with adding test invoices. In my original live setup, I have the non-dollar A/R accounts as children of the dollar (default) A/R account, so that the parent account always shows the total A/R amount. • My question is whether this is the correct setup, and if not, where should the A/R accounts for the secondary currencies be placed? Regards, Alaa From: Murugan Muruganandam Sent: Wednesday, December 21, 2022 3:41 PM To: Alaa Zeineldine Subject: Re: [GNC] Rounding discrepancy in payment processing hi Alaa i have created a customer called customer 1 with their currency as Yen. i have created a invoice also for your reference. you can try creating new invoices with franctions for them and you can see the rounding Saludos Cordiales Murugan _ From: Alaa Zeineldine mailto:a...@expertwell.com> > Sent: Tuesday, December 20, 2022 9:27 PM To: 'Murugan Muruganandam' mailto:m.muruganan...@hotmail.com> > Subject: RE: [GNC] Rounding discrepancy in payment processing Hello Murugan, I did lookup a number of customers, each of which had a USD currency, and their invoices were also USD, but rounding still occurs for them. Can you elaborate on what you mean by “a customer currency with no fractions”? Regards, Alaa From: Murugan Muruganandam mailto:m.muruganan...@hotmail.com> > Sent: Wednesday, December 21, 2022 1:58 AM To: Alaa Zeineldine mailto:a...@expertwell.com> > Subject: Re: [GNC] Rounding discrepancy in payment processing Alaa The rounding occurs based on the customer currency , so if your base currency and customer currency are USD , it will not have any problem , but in case you have a customer currency with no fractions , even when you create USD invoice it will round it , Can you look up one customer and tell me the currency of the customer and invoice currency Regard Murugan On 20-12-2022, at 18:22, Alaa Zeineldine mailto:a...@expertwell.com> > wrote: Hello Murugan, Thanks for looking into this. I checked a number of customers, and each shows the currency that was entered when I created the customer initially. I also checked a number of invoices and found that the currency for the invoice was consistent with that of the customer. Please note the reply to David Kirkby that I sent to the list. I created a minimal test .gnucash file with only one currency and tried a number of experiments with it. This did not exhibit the problem. This of course is much simpler than my real setup where I have clients with different currencies, and also bank accounts with different currencies. Regards, Alaa From: Murugan Muruganandam mailto:m.muruganan...@hotmail.com> > Sent: Tuesday, December 20, 2022 9:25 PM To: Alaa Zeineldine mailto:a...@expertwell.com> > Subject: Re: [GNC] Rounding discrepancy in payment processing hi Alaa Can you please do a quick check 1. find customer 2. view/edit 3. Billing information 4. What currency is being shown in this . i was able to recreate the issue in a test file and i think this could be the issue. Saludos Cordiales Murugan _ From: gnucash-user mailto:gnucash-user-bounces+m.muruganandam=hotmail@gnucash.org> > on behalf of Alaa Zeineldine mailto:a...@expertwell.com> > Sent: Tuesday, December 20, 2022 8:21 AM To: 'Dr. David Kirkby' mailto:drkir...@kirkbymicrowave.co.uk> > Cc: gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> mailto:gnucash-user@gnucash.org> > Subject: Re: [GNC] Rounding discrepancy in payment processing Hello Dave,
Re: [GNC] Rounding discrepancy in payment processing
Hello Murugan, Thanks. I opened the file you sent and saw the new customer with the new invoice you created, which seems to be empty. I think the problems begin when an invoice with an amount is created. In this case, GC will require an A/R account with the same currency as the customer. That is when discrepancies begin to appear. I have a question before I proceed with adding test invoices. In my original live setup, I have the non-dollar A/R accounts as children of the dollar (default) A/R account, so that the parent account always shows the total A/R amount. • My question is whether this is the correct setup, and if not, where should the A/R accounts for the secondary currencies be placed? Regards, Alaa From: Murugan Muruganandam Sent: Wednesday, December 21, 2022 3:41 PM To: Alaa Zeineldine Subject: Re: [GNC] Rounding discrepancy in payment processing hi Alaa i have created a customer called customer 1 with their currency as Yen. i have created a invoice also for your reference. you can try creating new invoices with franctions for them and you can see the rounding Saludos Cordiales Murugan _ From: Alaa Zeineldine mailto:a...@expertwell.com> > Sent: Tuesday, December 20, 2022 9:27 PM To: 'Murugan Muruganandam' mailto:m.muruganan...@hotmail.com> > Subject: RE: [GNC] Rounding discrepancy in payment processing Hello Murugan, I did lookup a number of customers, each of which had a USD currency, and their invoices were also USD, but rounding still occurs for them. Can you elaborate on what you mean by “a customer currency with no fractions”? Regards, Alaa From: Murugan Muruganandam mailto:m.muruganan...@hotmail.com> > Sent: Wednesday, December 21, 2022 1:58 AM To: Alaa Zeineldine mailto:a...@expertwell.com> > Subject: Re: [GNC] Rounding discrepancy in payment processing Alaa The rounding occurs based on the customer currency , so if your base currency and customer currency are USD , it will not have any problem , but in case you have a customer currency with no fractions , even when you create USD invoice it will round it , Can you look up one customer and tell me the currency of the customer and invoice currency Regard Murugan On 20-12-2022, at 18:22, Alaa Zeineldine mailto:a...@expertwell.com> > wrote: Hello Murugan, Thanks for looking into this. I checked a number of customers, and each shows the currency that was entered when I created the customer initially. I also checked a number of invoices and found that the currency for the invoice was consistent with that of the customer. Please note the reply to David Kirkby that I sent to the list. I created a minimal test .gnucash file with only one currency and tried a number of experiments with it. This did not exhibit the problem. This of course is much simpler than my real setup where I have clients with different currencies, and also bank accounts with different currencies. Regards, Alaa From: Murugan Muruganandam mailto:m.muruganan...@hotmail.com> > Sent: Tuesday, December 20, 2022 9:25 PM To: Alaa Zeineldine mailto:a...@expertwell.com> > Subject: Re: [GNC] Rounding discrepancy in payment processing hi Alaa Can you please do a quick check 1. find customer 2. view/edit 3. Billing information 4. What currency is being shown in this . i was able to recreate the issue in a test file and i think this could be the issue. Saludos Cordiales Murugan _ From: gnucash-user mailto:gnucash-user-bounces+m.muruganandam=hotmail@gnucash.org> > on behalf of Alaa Zeineldine mailto:a...@expertwell.com> > Sent: Tuesday, December 20, 2022 8:21 AM To: 'Dr. David Kirkby' mailto:drkir...@kirkbymicrowave.co.uk> > Cc: gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> mailto:gnucash-user@gnucash.org> > Subject: Re: [GNC] Rounding discrepancy in payment processing Hello Dave, Sounds reasonable. I will do this as soon as I get some free time this evening. Regards, Alaa From: Dr. David Kirkby mailto:drkir...@kirkbymicrowave.co.uk> > Sent: Tuesday, December 20, 2022 4:38 AM To: Alaa Zeineldine mailto:a...@expertwell.com> > Cc: gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> Subject: Re: [GNC] Rounding discrepancy in payment processing On Tue, 20 Dec 2022 at 01:04, Alaa Zeineldine mailto:a...@expertwell.com> > wrote: This is the first time I email to the list. So, I don't know if screenshots will show up, but I am including below a succession of screenshots for a fake customer invoice to demonstrate the problem. Yes they do show up. It would probably be worth your while creating a test .gnucash file, emailing that, and let people see if they get the problem with your file. Th
Re: [GNC] Rounding discrepancy in payment processing
Hello Dave, Attached is a test .gnucash file I created. Interestingly enough, it does not exhibit the problem. Bearing in mind that this is a minimal setup with a single currency. Before going further with this and adding accounts with different currencies, I will provide the information that Murugan requested in his last message. Regards, Alaa From: Dr. David Kirkby Sent: Tuesday, December 20, 2022 4:38 AM To: Alaa Zeineldine Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Rounding discrepancy in payment processing On Tue, 20 Dec 2022 at 01:04, Alaa Zeineldine mailto:a...@expertwell.com> > wrote: This is the first time I email to the list. So, I don't know if screenshots will show up, but I am including below a succession of screenshots for a fake customer invoice to demonstrate the problem. Yes they do show up. It would probably be worth your while creating a test .gnucash file, emailing that, and let people see if they get the problem with your file. Thanks for your help. Dave -- Dr. David Kirkby, Kirkby Microwave Ltd, drkir...@kirkbymicrowave.co.uk <mailto:drkir...@kirkbymicrowave.co.uk> https://www.kirkbymicrowave.co.uk/ Telephone 01621-680100./ +44 1621 680100 Registered in England & Wales, company number 08914892. Registered office: Stokes Hall Lodge, Burnham Rd, Althorne, Chelmsford, Essex, CM3 6DT, United Kingdom gcRoundingTest.gnucash Description: application/gnucash ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Rounding discrepancy in payment processing
Hello Dave, Sounds reasonable. I will do this as soon as I get some free time this evening. Regards, Alaa From: Dr. David Kirkby Sent: Tuesday, December 20, 2022 4:38 AM To: Alaa Zeineldine Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Rounding discrepancy in payment processing On Tue, 20 Dec 2022 at 01:04, Alaa Zeineldine mailto:a...@expertwell.com> > wrote: This is the first time I email to the list. So, I don't know if screenshots will show up, but I am including below a succession of screenshots for a fake customer invoice to demonstrate the problem. Yes they do show up. It would probably be worth your while creating a test .gnucash file, emailing that, and let people see if they get the problem with your file. Thanks for your help. Dave -- Dr. David Kirkby, Kirkby Microwave Ltd, drkir...@kirkbymicrowave.co.uk <mailto:drkir...@kirkbymicrowave.co.uk> https://www.kirkbymicrowave.co.uk/ Telephone 01621-680100./ +44 1621 680100 Registered in England & Wales, company number 08914892. Registered office: Stokes Hall Lodge, Burnham Rd, Althorne, Chelmsford, Essex, CM3 6DT, United Kingdom ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Rounding discrepancy in payment processing
Hello Murugan, My default currency is USD for accounts and for reporting. I have a couple of bank accounts in EGP, but those do not receive payments, only transfers from other USD accounts. I don't think there is a setting for the invoice currency. If I remember correctly, invoice currency is based on the customer's currency. In my case, I may have a couple of customers in EUR and one GBP, which are rarely used. All the rest are in USD. Regards, Alaa From: Murugan Muruganandam Sent: Tuesday, December 20, 2022 4:09 AM To: Alaa Zeineldine ; gnucash-user@gnucash.org Subject: Re: [GNC] Rounding discrepancy in payment processing hi Alaa can you please confirm what is your default currency and invoice currency Saludos Cordiales Murugan _ From: gnucash-user mailto:gnucash-user-bounces+m.muruganandam=hotmail@gnucash.org> > on behalf of Alaa Zeineldine mailto:a...@expertwell.com> > Sent: Monday, December 19, 2022 10:04 PM To: gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> mailto:gnucash-user@gnucash.org> > Subject: Re: [GNC] Rounding discrepancy in payment processing Hello David, Thanks for the follow up. >We are going to need a bit more detail to try and identify what may be causing >the behaviour you are experiencing. > >What operating system are you using? Previously Windows 10 and recently Windows 11. The issue has always been there since I started using Gnucash about 3 years ago. >Are you up to date with all OS updates? Yes. Always up to date. >How are you installing 4.12 on your computer( downloaded image , flatpak, built >from source)? I usually download the Windows setup package from Source Forge. Today, I downloaded 4.13 setup.exe from Github. >Is the rounding occurring as you enter the amount in the invoice? No. The amount entered in the invoice is the exact amount, and it stays that way whenever I view the invoice. >Is the rounding occurring in the payment window on entry The rounding appears when the invoices for a customer as displayed in the Process Payment dialog. Also, when the invoice is selected, the Payment field is filled with the rounded amount by default. >Is the amount shown in the A/R account register correct or rounded after posting >the invoice or making a payment? Rounded. > >As much detail as possible will help in identifying what is causing the problem. This is the first time I email to the list. So, I don't know if screenshots will show up, but I am including below a succession of screenshots for a fake customer invoice to demonstrate the problem. 1. This is an invoice for $140.16 after posting. 2. This is the entry for that invoice in the A/R Aging report before payment. The amount is rounded down. 3. Here is the Process Payment dialog with the default payment amount 4. Here is the dialog after I changed the payment to the exact invoice amount without rounding 5. This is the entry in the A/R Aging report after payment as above 6. This how the corresponding entries look in the A/R register Thanks for your help. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Rounding discrepancy in payment processing
Correction: The last prepayment in the example should have been (0.22), not (0.12) ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Rounding discrepancy in payment processing
Hello, This problem has been keeping me from upgrading from V 4.6 for some time, but I would like to move on to newer versions. When I receive payment for an invoice amount that is not a whole number, (say $140.16), the Process Payment window rounds the fraction part of the amount. In this case the invoice value will show as $140.00. But the payment I receive is the exact amount. Until GC V4.6, I used to enter the correct amount in the payment field (140.16 here). GC seemed to handle this internally somehow and my books would appear balanced. Also, the A/R Aging report would show no outstanding balance for that customer. When I decided to upgrade to V4.8, the A/R Aging report showed many prepayments that did not actually exist in reality. These seemed to correspond to the fractional difference between the actual entered payment and the invoice amount after rounding for all previously settled invoices whose amounts were not whole numbers. For example: Invoice amount (rounded) | Entered payment amount | Prepayment 140.16 (140.00) | 140.16 | 0.16 450.78 (451.00) | 450.78 | (0.12) Consequently, there was a cumulative prepayment for each customer equal to the net sum of these individual prepayments. Unless all of that customer's invoice amounts were whole numbers. I reverted to V4.6, which did not exhibit this discrepancy in reporting, thinking that there will eventually be a release where this issue is resolved, but the releases I tried until now still had this issue. Now, I upgraded to V4.12 and thought maybe I should do things differently. In the Process Payment window, instead of forcing the exact payment amount, I accepted the amount GC displays in the payment field by default, which matches the displayed (rounded) value of the invoice. I was hoping that since it keeps the correct value of the invoice internally, it may also do that for the default payment amount it computes. The result of this approach was OK for A/R reporting, but it led to an imbalance in the bank accounts where the payments are deposited, resulting from the difference between the real payment and the rounded value I accepted in the Process Payment window. I prefer not to revert back to V4.6. So, is there something I am missing or perhaps doing wrong here. Any ideas? Thanks. Alaa Zeineldine ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.