Re: [GNC] Importing GIF: Unable to complete

[David Carlson]

Amar,
Just sayin'  If you imported your data into GnuCash 4.12 a month ago, then
you only need to open that data file and import a months' data into GnuCash
4.13, not the whole thing.


On Thu, Dec 22, 2022 at 9:50 PM Amar Khalifeh 
wrote:

> I think the QIF file is fine.
> I was able to import it into Moneyspire and Acemoney just now
> I was able to import a similar file (exported from Moneydance) into GnuCash
> less than a month ago.
>
> On Thu, Dec 22, 2022 at 4:01 PM David H  wrote:
>
> > Amar,
> >
> > Please use "Reply All" to keep the conversation on the mailing list
> > so other users can chip in and help.  I rarely use any importers and are
> > just offering suggestions that may or may not help :-)  See John Ralls's
> > reply which is probably more germane than mine.  To me it looks like your
> > file is rubbish - are you sure it's a QIF file ?  Or as John suggested
> have
> > you actually selected a file ?
> >
> > Cheers David H.
> >
> >
> > On Fri, 23 Dec 2022 at 07:46, Amar Khalifeh 
> > wrote:
> >
> >> The file is 1536 KB.
> >> I'm running Windows 11.
> >> 
> >>
> >> As a follow up, I tried again, and this time I examined the import
> status
> >> window.
> >> This is what I got. Does this provide any clues?
> >> [image: image.png]
> >>
> >> On Thu, Dec 22, 2022 at 2:56 PM David H  wrote:
> >>
> >>> What OS ? How large is your QIF history file - perhaps it's still
> >>> working on it and you need to give it more time ?  Have you clicked on
> >>> another Window and taken the focus away from you dialog ?
> >>>
> >>> Cheers David H.
> >>>
> >>> On Fri, 23 Dec 2022 at 06:50, Amar Khalifeh 
> >>> wrote:
> >>>
>  I just downloaded version 4.13 and am trying to import my QIF history.
>  I go
>  through the import process and it seems to be working fine, but when I
>  get
>  to the step where it asks if I want to load another file or continue
>  (with
>  "Next"), I find "Next" grayed out and none of the clickable buttons
>  work.
>  Any ideas why this is happening?
>  I was able to load QIF files in the past from the same source in
> earlier
>  attempts to use Gnu Cash.
>  Thank you for your help.
> 
>  [image: image.png]
>  ___
>  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.
> 
> >>>
> ___
> 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.
>


-- 
David Carlson
___
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] Improvement suggestion

[Robert Heller]

At Fri, 23 Dec 2022 10:34:44 +1000 Daryl Hillgrove  
wrote:

> 
> Can a simple backup function be added to gnucash?
> 
> I am very concerned that if my computer fails I will lose all my data. I
> want to store the backup data to external storage such as a memory stick.
> 

This can be achieved by just copying the *.gnucash file to your external 
storage device.  GnuCash *already* makes backup copies of its datafile, in the 
directory (folder) where the datafile lives.

> Thanks
> 
> Daryl Hillgrove
> ___
> 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.
> 
>   
>  
> 

-- 
Robert Heller -- Cell: 413-658-7953 GV: 978-633-5364
Deepwoods Software-- Custom Software Services
http://www.deepsoft.com/  -- Linux Administration Services
hel...@deepsoft.com   -- Webhosting Services

   
___
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] Importing GIF: Unable to complete

[Amar Khalifeh]

I think the QIF file is fine.
I was able to import it into Moneyspire and Acemoney just now
I was able to import a similar file (exported from Moneydance) into GnuCash
less than a month ago.

On Thu, Dec 22, 2022 at 4:01 PM David H  wrote:

> Amar,
>
> Please use "Reply All" to keep the conversation on the mailing list
> so other users can chip in and help.  I rarely use any importers and are
> just offering suggestions that may or may not help :-)  See John Ralls's
> reply which is probably more germane than mine.  To me it looks like your
> file is rubbish - are you sure it's a QIF file ?  Or as John suggested have
> you actually selected a file ?
>
> Cheers David H.
>
>
> On Fri, 23 Dec 2022 at 07:46, Amar Khalifeh 
> wrote:
>
>> The file is 1536 KB.
>> I'm running Windows 11.
>> 
>>
>> As a follow up, I tried again, and this time I examined the import status
>> window.
>> This is what I got. Does this provide any clues?
>> [image: image.png]
>>
>> On Thu, Dec 22, 2022 at 2:56 PM David H  wrote:
>>
>>> What OS ? How large is your QIF history file - perhaps it's still
>>> working on it and you need to give it more time ?  Have you clicked on
>>> another Window and taken the focus away from you dialog ?
>>>
>>> Cheers David H.
>>>
>>> On Fri, 23 Dec 2022 at 06:50, Amar Khalifeh 
>>> wrote:
>>>
 I just downloaded version 4.13 and am trying to import my QIF history.
 I go
 through the import process and it seems to be working fine, but when I
 get
 to the step where it asks if I want to load another file or continue
 (with
 "Next"), I find "Next" grayed out and none of the clickable buttons
 work.
 Any ideas why this is happening?
 I was able to load QIF files in the past from the same source in earlier
 attempts to use Gnu Cash.
 Thank you for your help.

 [image: image.png]
 ___
 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.

>>>
___
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] Importing GIF: Unable to complete

[Amar Khalifeh]

Yes, but it's over a month old. I was able to import a QIF file from the
same source, Moneydance.
Now, I'm trying the same process again with a more recent version.

On Thu, Dec 22, 2022, 4:57 PM David Carlson 
wrote:

> Amar,
>
> do you have a data file from a previous version of GnuCash?
>
> On Thu, Dec 22, 2022 at 4:05 PM John Ralls  wrote:
>
>> Please remember to copy the list on all replies.
>>
>> Looks like you had a ton of errors so it didn't load the file.
>>
>> Regards,
>> John Ralls
>>
>>
>> > On Dec 22, 2022, at 1:48 PM, Amar Khalifeh 
>> wrote:
>> >
>> > The file selection was done in the previous step, and I got the
>> impression that it was actually loaded
>> > 
>> >
>> > On Thu, Dec 22, 2022 at 3:06 PM John Ralls  wrote:
>> >
>> >
>> > > On Dec 22, 2022, at 8:41 AM, Amar Khalifeh 
>> wrote:
>> > >
>> > > I just downloaded version 4.13 and am trying to import my QIF
>> history. I go
>> > > through the import process and it seems to be working fine, but when
>> I get
>> > > to the step where it asks if I want to load another file or continue
>> (with
>> > > "Next"), I find "Next" grayed out and none of the clickable buttons
>> work.
>> > > Any ideas why this is happening?
>> > > I was able to load QIF files in the past from the same source in
>> earlier
>> > > attempts to use Gnu Cash.
>> > > Thank you for your help.
>> > >
>> > > [image: image.png]
>> >
>> > The screenshot shows that you haven't selected any files to import. Use
>> the "load another file" button to select one. You can keep using that
>> button to build up a list of QIF files to import into the same GnuCash
>> account that you selected in the previous step.
>> >
>> > The Next button will enable once you've selected at least one file.
>> >
>> > Regards,
>> > John Ralls
>> >
>> >
>>
>> ___
>> 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.
>>
>
>
> --
> David Carlson
>
___
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] Improvement suggestion

[Daryl Hillgrove]

Thank you everyone for your suggestions.

I will try these out and it would appear that my concerns will be solved.

Much appreciated.

Daryl Hillgrove.

On Fri, 23 Dec 2022, 12:02 pm Stan Brown, 
wrote:

>
> On 2022-12-22 16:34, Daryl Hillgrove wrote:
> > Can a simple backup function be added to gnucash?
> >
> > I am very concerned that if my computer fails I will lose all my data. I
> > want to store the backup data to external storage such as a memory stick.
>
> You say "simple", but it would be complex to create some backup software
> that would do what you want but also do the many things that other
> people want. And it would have to work on both Macs and Windows PCs,
> which would be pretty hard.
>
> This is why backup programs are a class by themselves -- different
> people choose the one that suits their needs.
>
> Your concern about losing your data if your computer crashes is quite
> reasonable. But surely your GnuCash data file is not the only thing you
> would hate to lose? If you're like most people, you have other precious
> records on your computer. The best approach is to look at backup
> programs and choose a good one, then let it back up your GnuCash data
> among all your other data.
>
> On the other hand, if truly the only thing you care about is backing up
> your GnuCash data, surely it's pretty easy to plug in the USB stick,
> open File Manager (or whatever the Mac calls it), and drag your GnuCash
> data file to the USB stick.
>
> Stan Brown
> Tehachapi, CA, USA
> https://BrownMath.com
> ___
> 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.
>
___
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] Improvement suggestion

[Stan Brown]

On 2022-12-22 16:34, Daryl Hillgrove wrote:
> Can a simple backup function be added to gnucash?
> 
> I am very concerned that if my computer fails I will lose all my data. I
> want to store the backup data to external storage such as a memory stick.

You say "simple", but it would be complex to create some backup software
that would do what you want but also do the many things that other
people want. And it would have to work on both Macs and Windows PCs,
which would be pretty hard.

This is why backup programs are a class by themselves -- different
people choose the one that suits their needs.

Your concern about losing your data if your computer crashes is quite
reasonable. But surely your GnuCash data file is not the only thing you
would hate to lose? If you're like most people, you have other precious
records on your computer. The best approach is to look at backup
programs and choose a good one, then let it back up your GnuCash data
among all your other data.

On the other hand, if truly the only thing you care about is backing up
your GnuCash data, surely it's pretty easy to plug in the USB stick,
open File Manager (or whatever the Mac calls it), and drag your GnuCash
data file to the USB stick.

Stan Brown
Tehachapi, CA, USA
https://BrownMath.com
___
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] Improvement suggestion

[Glenn Fowler]

After you set your backup settings in Preferences -> General , I would go
one step further and copy or sync the folder to a different storage device

On Thu, Dec 22, 2022 at 7:41 PM Steve Butler  wrote:

> Backup is a system function.  You need to plan that for all your data
> beyond just GnuCash.
>
> You can do a simple Save As to put that data in another spot.  But that
> leaves your spreadsheets unprotected.
>
> On Thu, Dec 22, 2022, 16:36 Daryl Hillgrove 
> wrote:
>
> > Can a simple backup function be added to gnucash?
> >
> > I am very concerned that if my computer fails I will lose all my data. I
> > want to store the backup data to external storage such as a memory stick.
> >
> > Thanks
> >
> > Daryl Hillgrove
> > ___
> > 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.
> >
> ___
> 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.
>
___
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] Improvement suggestion

[William Prescott]

I agree.

I have three backup systems for my computer:

• I have an external disk attached to it and set up MacOS Time Machine to 
backup to that disk.
• I pay a cloud company to backup my computer (Currently CrashPlan/Code42 but I 
have thought about switching to BackBlaze).
• And I use SuperDuper! to make a clone of my computer every few days 
alternating between two different disks.

The different systems provide protection against different types of failures 
(disk crash, theft, fire, ransom encryption, cloud company failure, mistaken 
deletion of files). I feel all are necessary. But at least one is an absolute 
necessity for anyone who has any data they care about keeping.

A few years ago, over the space of a few weeks I had failures in almost all of 
these systems for different reasons. Fortunately the failures did not all occur 
at the same time, so I did not lose any data although some of the organization 
of old emails was lost so they would be hard to find.

Will


On Dec 22, 2022, at 18:42, Ken Farley  wrote:

This kind of thing is generally your responsibility. I can't think of a single 
bit of software I use for work - be it CAD, document writing, spreadsheet, or 
whatever - that does backup of my data for me. That task is on me, and rightly 
so. The time my computer suffered a complete crash, the data lost was my fault. 
Set yourself up a nice automated backup for your data (like Time Machine on 
MacOS).
___
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.

___
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] Improvement suggestion

[Dr. David Kirkby]

On Fri, 23 Dec 2022 at 00:34, Daryl Hillgrove 
wrote:

> Can a simple backup function be added to gnucash?
>
> I am very concerned that if my computer fails I will lose all my data. I
> want to store the backup data to external storage such as a memory stick.
>
> Thanks
>
> Daryl Hillgrove


All your data is stored in a single file with the extension.gnucash. You
just need to back that one file, which you might call accounts.gnucash.

It would be more complicated if you used an external database, but I assume
that you are not, because that’s not the default behaviour, and it would
require the installation of other software.

So no backup tool is needed. In fact, the program makes regular backups in
the same directory.
-- 
Dr. David Kirkby,
Kirkby Microwave Ltd,
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] Improvement suggestion

[Ken Farley]

This kind of thing is generally your responsibility. I can't think of a 
single bit of software I use for work - be it CAD, document writing, 
spreadsheet, or whatever - that does backup of my data for me. That task 
is on me, and rightly so. The time my computer suffered a complete 
crash, the data lost was my fault. Set yourself up a nice automated 
backup for your data (like Time Machine on MacOS).

___
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] Improvement suggestion

[Steve Butler]

Backup is a system function.  You need to plan that for all your data
beyond just GnuCash.

You can do a simple Save As to put that data in another spot.  But that
leaves your spreadsheets unprotected.

On Thu, Dec 22, 2022, 16:36 Daryl Hillgrove 
wrote:

> Can a simple backup function be added to gnucash?
>
> I am very concerned that if my computer fails I will lose all my data. I
> want to store the backup data to external storage such as a memory stick.
>
> Thanks
>
> Daryl Hillgrove
> ___
> 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.
>
___
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] Improvement suggestion

[Daryl Hillgrove]

Can a simple backup function be added to gnucash?

I am very concerned that if my computer fails I will lose all my data. I
want to store the backup data to external storage such as a memory stick.

Thanks

Daryl Hillgrove
___
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] Do I need to set up multiple bank accounts for different currencies?

[Frank H. Ellenberger]

Am 22.12.22 um 22:38 schrieb Dr. David Kirkby:

https://wiki.gnucash.org/wiki/Trading_Accounts

has a link to a tutorial, but the link is broken.


Thanks to Peters prompt answer
https://lists.gnucash.org/pipermail/gnucash-devel/2022-December/046472.html
the links are fixed now.

Regards
Frank
___
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

[Alaa Zeineldine]

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> >
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  
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 one currency and tried a number of 
experiments with it. This did not exhibit the problem. This of course is much 

Re: [GNC] Importing GIF: Unable to complete

[Liz Dodd]

On Fri, 23 Dec 2022 08:01:44 +1000
David H  wrote:

> Amar,
> 
> Please use "Reply All" to keep the conversation on the mailing list
> so other users can chip in and help. 

Amar is not subscribed to the list. Any replies will wait for me to let
them through. None waiting up to one minute ago.

Liz
___
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] Importing GIF: Unable to complete

[David Carlson]

Amar,

do you have a data file from a previous version of GnuCash?

On Thu, Dec 22, 2022 at 4:05 PM John Ralls  wrote:

> Please remember to copy the list on all replies.
>
> Looks like you had a ton of errors so it didn't load the file.
>
> Regards,
> John Ralls
>
>
> > On Dec 22, 2022, at 1:48 PM, Amar Khalifeh 
> wrote:
> >
> > The file selection was done in the previous step, and I got the
> impression that it was actually loaded
> > 
> >
> > On Thu, Dec 22, 2022 at 3:06 PM John Ralls  wrote:
> >
> >
> > > On Dec 22, 2022, at 8:41 AM, Amar Khalifeh 
> wrote:
> > >
> > > I just downloaded version 4.13 and am trying to import my QIF history.
> I go
> > > through the import process and it seems to be working fine, but when I
> get
> > > to the step where it asks if I want to load another file or continue
> (with
> > > "Next"), I find "Next" grayed out and none of the clickable buttons
> work.
> > > Any ideas why this is happening?
> > > I was able to load QIF files in the past from the same source in
> earlier
> > > attempts to use Gnu Cash.
> > > Thank you for your help.
> > >
> > > [image: image.png]
> >
> > The screenshot shows that you haven't selected any files to import. Use
> the "load another file" button to select one. You can keep using that
> button to build up a list of QIF files to import into the same GnuCash
> account that you selected in the previous step.
> >
> > The Next button will enable once you've selected at least one file.
> >
> > Regards,
> > John Ralls
> >
> >
>
> ___
> 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.
>


-- 
David Carlson
___
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] Importing GIF: Unable to complete

[John Ralls]

Please remember to copy the list on all replies.

Looks like you had a ton of errors so it didn't load the file.

Regards,
John Ralls


> On Dec 22, 2022, at 1:48 PM, Amar Khalifeh  wrote:
> 
> The file selection was done in the previous step, and I got the impression 
> that it was actually loaded
> 
> 
> On Thu, Dec 22, 2022 at 3:06 PM John Ralls  wrote:
> 
> 
> > On Dec 22, 2022, at 8:41 AM, Amar Khalifeh  wrote:
> > 
> > I just downloaded version 4.13 and am trying to import my QIF history. I go
> > through the import process and it seems to be working fine, but when I get
> > to the step where it asks if I want to load another file or continue (with
> > "Next"), I find "Next" grayed out and none of the clickable buttons work.
> > Any ideas why this is happening?
> > I was able to load QIF files in the past from the same source in earlier
> > attempts to use Gnu Cash.
> > Thank you for your help.
> > 
> > [image: image.png]
> 
> The screenshot shows that you haven't selected any files to import. Use the 
> "load another file" button to select one. You can keep using that button to 
> build up a list of QIF files to import into the same GnuCash account that you 
> selected in the previous step.
> 
> The Next button will enable once you've selected at least one file.
> 
> Regards,
> John Ralls
> 
> 

___
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] Importing GIF: Unable to complete

[David H]

Amar,

Please use "Reply All" to keep the conversation on the mailing list
so other users can chip in and help.  I rarely use any importers and are
just offering suggestions that may or may not help :-)  See John Ralls's
reply which is probably more germane than mine.  To me it looks like your
file is rubbish - are you sure it's a QIF file ?  Or as John suggested have
you actually selected a file ?

Cheers David H.


On Fri, 23 Dec 2022 at 07:46, Amar Khalifeh  wrote:

> The file is 1536 KB.
> I'm running Windows 11.
> 
>
> As a follow up, I tried again, and this time I examined the import status
> window.
> This is what I got. Does this provide any clues?
> [image: image.png]
>
> On Thu, Dec 22, 2022 at 2:56 PM David H  wrote:
>
>> What OS ? How large is your QIF history file - perhaps it's still working
>> on it and you need to give it more time ?  Have you clicked on another
>> Window and taken the focus away from you dialog ?
>>
>> Cheers David H.
>>
>> On Fri, 23 Dec 2022 at 06:50, Amar Khalifeh 
>> wrote:
>>
>>> I just downloaded version 4.13 and am trying to import my QIF history. I
>>> go
>>> through the import process and it seems to be working fine, but when I
>>> get
>>> to the step where it asks if I want to load another file or continue
>>> (with
>>> "Next"), I find "Next" grayed out and none of the clickable buttons work.
>>> Any ideas why this is happening?
>>> I was able to load QIF files in the past from the same source in earlier
>>> attempts to use Gnu Cash.
>>> Thank you for your help.
>>>
>>> [image: image.png]
>>> ___
>>> 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.
>>>
>>
___
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] Do I need to set up multiple bank accounts for different currencies?

[Dr. David Kirkby]

On Thu, 22 Dec 2022 at 18:43, Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> I don't think you'd have separate accounts. But you might want to turn
> on the Trading Accounts feature that can handle adjusting splits for
> multi-currency transactions. (such as getting paid in USD, but the bank
> shows receipt in GBP)
>
> I dare hazard a guess that if your account is denominated in GBP, that's
> all it should be. How the bank handles receipt of other currencies and
> conversions will be a separate exercise for you to have fun with. (where
> turning on Trading Accounts might be helpful)
>
> Regards,
> Adrien
>

I looked at the trading accounts, but was a bit put off. When I googled the
term, there seemed to be quite different interpretations, and all confused
me. I felt I was going out of my comfort zone.

https://wiki.gnucash.org/wiki/Trading_Accounts

has a link to a tutorial, but the link is broken.

Then I see this comment

https://www.reddit.com/r/GnuCash/comments/mf2vdt/trading_accounts_functionality/

about enabling trading accounts in GnuCash added splits to already
reconciled transactions.

Dave
___
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] Do I need to set up multiple bank accounts for different currencies?

[David Cousens]

Dave

This is the crucial step

>"It's the one bank account - I don't have different account numbers for
> different currencies, and can't hold balances in anything other than GBP."

In this case there generally is no need to have an account in another currency.
If you can record all you need by adding a note that the orignal
deposit/withdrawal was so much of another currency at the exchange rate valid at
the time.
 
When I was last travelling on holidays I had a debit card whose balance was
recorded in another currency (SGD) and transactions recorded with it were made
in that currency so it made sense to set up accounts in that currency and record
the transfers from my bank account to itand back when I returned.

When I was working my business credit card was in AUD but I could use it in most
countries around the world and did. The bank did the conversions, added fees etc
so I had no need to maintain accounts for transactions in other currencies I
just recorded my expenses in AUD, usually with a note about the cost in the
original currency (mainly because some were refundable by my employer and I had
to provide receipts and match them to the AUD amounts i was claiming).

When setting up an account structure, I always ask myself what information is it
recording and for what purpose and in what form do I need that information. That
usually sorts out whether I need a specific account or not.

David Cousens

On Thu, 2022-12-22 at 15:56 +, Dr. David Kirkby wrote:
> My Bank is a UK bank, but I sometimes buy things in $HKD, and fairly
> regularly receive payments in USD and EUR in addition to the obvious GBP.
> Should I set up accounts like this? (American's call them checking
> accounts, but we don't here).
> 
> Assets: Current Assets: Bank Account (GBP)
> Assets: Current Assets: Bank Account (USD)
> Assets: Current Assets: Bank Account (EUR)
> Assets: Current Assets: Bank Account (HKD)
> 
> It's the one bank account - I don't have different account numbers for
> different currencies, and can't hold balances in anything other than GBP.
> 
> I initially assumed I needed 4 accounts for 4 currencies, but now I'm
> wondering if I can avoid that complexity, given I can only have a balance
> in GBP.
> 
> Dave
> ___
> 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.

___
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] Importing GIF: Unable to complete

[John Ralls]

> On Dec 22, 2022, at 8:41 AM, Amar Khalifeh  wrote:
> 
> I just downloaded version 4.13 and am trying to import my QIF history. I go
> through the import process and it seems to be working fine, but when I get
> to the step where it asks if I want to load another file or continue (with
> "Next"), I find "Next" grayed out and none of the clickable buttons work.
> Any ideas why this is happening?
> I was able to load QIF files in the past from the same source in earlier
> attempts to use Gnu Cash.
> Thank you for your help.
> 
> [image: image.png]

The screenshot shows that you haven't selected any files to import. Use the 
"load another file" button to select one. You can keep using that button to 
build up a list of QIF files to import into the same GnuCash account that you 
selected in the previous step.

The Next button will enable once you've selected at least one file.

Regards,
John Ralls


___
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] Importing GIF: Unable to complete

[David H]

What OS ? How large is your QIF history file - perhaps it's still working
on it and you need to give it more time ?  Have you clicked on another
Window and taken the focus away from you dialog ?

Cheers David H.

On Fri, 23 Dec 2022 at 06:50, Amar Khalifeh  wrote:

> I just downloaded version 4.13 and am trying to import my QIF history. I go
> through the import process and it seems to be working fine, but when I get
> to the step where it asks if I want to load another file or continue (with
> "Next"), I find "Next" grayed out and none of the clickable buttons work.
> Any ideas why this is happening?
> I was able to load QIF files in the past from the same source in earlier
> attempts to use Gnu Cash.
> Thank you for your help.
>
> [image: image.png]
> ___
> 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.
>
___
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] Gnucash on macOS Ventura

[David H]

Richard,

Working fine here with the update to 4.13 on Ventura 13.1

Cheers David H.


On Thu, 22 Dec 2022 at 07:16, R Losey  wrote:

> Which version of Ventura do you have? 13.0, 13.01, or 13.1
>
>
>
> On Wed, Dec 21, 2022 at 1:43 AM Christian Lynbech 
> wrote:
>
> > Just FYI: the new 4.13 version fixed the issues on Ventura for me.
> >
> > Thanks for the speedy update.
> >
> >/Christian
> >
> >
> > ---
> > On Mon, Nov 14 2022, Christian Lynbech wrote:
> >
> > Anybody here who has experience running Gnucash (4.12) on the newest
> > macOS Ventura?
> >
> > It basically works, but the UI is a bit wonky. The cursor does not
> > update correctly, sometimes you need to click twice or be very carefull
> > ot hit the text inside buttons.
> >
> >/Christian
> > ___
> > 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.
> > ___
> > 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.
> >
>
>
> --
> _
> Richard Losey
> rlo...@gmail.com
> Micah 6:8
> ___
> 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.
>
___
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] Importing GIF: Unable to complete

[Amar Khalifeh]

I just downloaded version 4.13 and am trying to import my QIF history. I go
through the import process and it seems to be working fine, but when I get
to the step where it asks if I want to load another file or continue (with
"Next"), I find "Next" grayed out and none of the clickable buttons work.
Any ideas why this is happening?
I was able to load QIF files in the past from the same source in earlier
attempts to use Gnu Cash.
Thank you for your help.

[image: image.png]
___
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] Do I need to set up multiple bank accounts for different currencies?

[Adrien Monteleone]

I don't think you'd have separate accounts. But you might want to turn 
on the Trading Accounts feature that can handle adjusting splits for 
multi-currency transactions. (such as getting paid in USD, but the bank 
shows receipt in GBP)


I dare hazard a guess that if your account is denominated in GBP, that's 
all it should be. How the bank handles receipt of other currencies and 
conversions will be a separate exercise for you to have fun with. (where 
turning on Trading Accounts might be helpful)


Regards,
Adrien

On 12/22/22 9:56 AM, Dr. David Kirkby wrote:

My Bank is a UK bank, but I sometimes buy things in $HKD, and fairly
regularly receive payments in USD and EUR in addition to the obvious GBP.
Should I set up accounts like this? (American's call them checking
accounts, but we don't here).

Assets: Current Assets: Bank Account (GBP)
Assets: Current Assets: Bank Account (USD)
Assets: Current Assets: Bank Account (EUR)
Assets: Current Assets: Bank Account (HKD)

It's the one bank account - I don't have different account numbers for
different currencies, and can't hold balances in anything other than GBP.

I initially assumed I needed 4 accounts for 4 currencies, but now I'm
wondering if I can avoid that complexity, given I can only have a balance
in GBP.


___
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] Is it safe to use Greek, Chinese etc characters

[Maf. King]

On Thursday, 22 December 2022 15:09:36 GMT Dr. David Kirkby wrote:

> Okay, I will leave the Greek characters when I see them.  It looks a bit
> nicer if I send a customer an invoice with the Greek omega symbol, rather
> than write ohm. (The electrical resistance of something is expressed in
> ohms, and denoted by a lowercase omega.)
> 

Hmm.  You could always do what the electronics mags of the 70s and 80s did and 
use R rather than Omega for ohms so a 68 ohm resistor would be in the 
parts list as 68R or a 1000 ohm would read as 1k or 1kR... just a thought!

PS, I thought that Ohms was capital Omega, and lower case omega (looking a 
little like a curvy w) was to do with frequencies in resonant circuits or 
angular / rotational mechanics  (there's a 2 -Pi-f ringing a distant bell in 
my brain)?  But that learning is very dusty now, and this is certainly off 
topic for a GC list!

Maf.


___
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] Do I need to set up multiple bank accounts for different currencies?

[William Prescott]

I am neither an accountant nor particularly expert at GnuCash, though I've used 
it for a dozen years or so. But if I understand what you are saying it sounds 
crazy to me.

I have several bank accounts in USD and several in MXN. I have one account in 
Gnucash for each bank account and the currency is set to whatever currency is 
appropriate. Transactions generally occur with both sides in the same currency. 
The only exceptions are when I transfer money from a bank account in USD to a 
bank account in MXN or visa versa. Then the two sides of the transactions are 
in different currencies and GnuCash asks me about the conversion rate. Or when 
I use an ATM in one country to withdraw cash from a bank in another country. 
This happens mostly when traveling.

You certainly do not need to have multiple Gnucash accounts for a single bank 
account to deal with currency exchanges. Just set the Gnucash bank account to 
GBP and have expense accounts in the other currencies as needed. GnuCash will 
deal with transactions that involve two currencies.

Will

On Dec 22, 2022, at 09:56, Dr. David Kirkby  
wrote:

My Bank is a UK bank, but I sometimes buy things in $HKD, and fairly
regularly receive payments in USD and EUR in addition to the obvious GBP.
Should I set up accounts like this? (American's call them checking
accounts, but we don't here).

Assets: Current Assets: Bank Account (GBP)
Assets: Current Assets: Bank Account (USD)
Assets: Current Assets: Bank Account (EUR)
Assets: Current Assets: Bank Account (HKD)

It's the one bank account - I don't have different account numbers for
different currencies, and can't hold balances in anything other than GBP.

I initially assumed I needed 4 accounts for 4 currencies, but now I'm
wondering if I can avoid that complexity, given I can only have a balance
in GBP.

Dave
___
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.

___
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] Do I need to set up multiple bank accounts for different currencies?

[Stan Brown]

The Tutorial and Concepts Guide has a longish chapter on multiple
currencies. Was that not of help to you?

Stan Brown
Tehachapi, CA, USA
https://BrownMath.com

On 2022-12-22 07:56, Dr. David Kirkby wrote:
> My Bank is a UK bank, but I sometimes buy things in $HKD, and fairly
> regularly receive payments in USD and EUR in addition to the obvious GBP.
> Should I set up accounts like this? (American's call them checking
> accounts, but we don't here).
> 
> Assets: Current Assets: Bank Account (GBP)
> Assets: Current Assets: Bank Account (USD)
> Assets: Current Assets: Bank Account (EUR)
> Assets: Current Assets: Bank Account (HKD)
> 
> It's the one bank account - I don't have different account numbers for
> different currencies, and can't hold balances in anything other than GBP.
> 
> I initially assumed I needed 4 accounts for 4 currencies, but now I'm
> wondering if I can avoid that complexity, given I can only have a balance
> in GBP.
___
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] Do I need to set up multiple bank accounts for different currencies?

[Dr. David Kirkby]

My Bank is a UK bank, but I sometimes buy things in $HKD, and fairly
regularly receive payments in USD and EUR in addition to the obvious GBP.
Should I set up accounts like this? (American's call them checking
accounts, but we don't here).

Assets: Current Assets: Bank Account (GBP)
Assets: Current Assets: Bank Account (USD)
Assets: Current Assets: Bank Account (EUR)
Assets: Current Assets: Bank Account (HKD)

It's the one bank account - I don't have different account numbers for
different currencies, and can't hold balances in anything other than GBP.

I initially assumed I needed 4 accounts for 4 currencies, but now I'm
wondering if I can avoid that complexity, given I can only have a balance
in GBP.

Dave
___
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] Is it safe to use Greek, Chinese etc characters

[Dr. David Kirkby]

On Thu, 22 Dec 2022 at 02:09, john  wrote:

> Yes, it's completely safe on Linux and macOS and mostly safe on MSWindows.
> Just make sure that the characters are encoded in UTF-8. Web pages
> generally are, but other Windows applications use UTF-16 and pasting into
> GnuCash will not produce the desiredresult. Windows CMD and Powershell are
> pretty firmly stuck in the 1990s and unless you perform some special
> contortions encode non-ASCII characters using DOS code-pages. Don't try to
> paste from them into GnuCash.
>

I'm unlikely to know how a particular web server is configured. But I'll
probably be doing most of this on Linux anyway.

GnuCash fully supports Unicode via UTF-8 and we have lots of users around
> the world who use a variety of writing systems.
>

Okay, I will leave the Greek characters when I see them.  It looks a bit
nicer if I send a customer an invoice with the Greek omega symbol, rather
than write ohm. (The electrical resistance of something is expressed in
ohms, and denoted by a lowercase omega.)

Regards,
> John Ralls
>

Dave
___
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] How can I refund this payment through PayPal, using business feature?

[Dr. David Kirkby]

On Wed, 21 Dec 2022 at 23:42, Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> Just un-post, edit and re-post. Still work, but no need to start over.
>

Since the accounts were not set up optimally, I'd rather just delete them,
and start again. There are less than a dozen entered.


> > I believe that Accounts Payable will need sub accounts for GBP, USD and
> > EUR. Not having three Accounts Payable in each currency should make
> posting
> > bills easier, as I will not have to select Bank, PayPal or eBay. If
> there’s
> > only one choice with the matching currency I assume that GnuCash with
> know
> > where to post.
>
> You do need separate AP for each currency, true. (or at least I've heard
> it helps, it may indeed be required)
>

You definitely do.  You can't post a USD transaction to a GBP Accounts
Payable.

>
> As for smart guessing, that I'm not so sure of, but you never know till
> you try. In a worst case, you can still choose the one you want. Posting
> isn't automatic.
>

The default choice is automatic. GnuCash definitely does give one a list of
Account Receivables to choose from, but only in the correct currency. But
I'll drop the PayPal, Bank and eBay specific ones.

> I have not set them up as vendors.
>
> I didn't think so, which is why I didn't understand the need for AP
> accounts for them.
>
> The *usual & generic* transaction flow should go something like this:
>
> New Bill from Vendor
> -
> Dr. Expenses
>Cr. AP
>
> Paying the Bill
> -
> Dr. AP
>Cr. Assets
>
> ('Assets' being your payment method/source of funds - Cash, Bank,
> PayPal, Credit Card, Gift Card, etc.)
>
> Return/Cancellation/Refund from Vendor (full or partial) - as a Credit Note
> -
> Dr. AP
>Cr. Expenses
>
> Receipt of funds from Vendor
> -
> Dr. Assets
>Cr. AP
>
> If you end up with a Credit Note situation before (fully) paying the
> original Bill, you can simply post the Credit Note, then Process Payment
> selecting both the Bill & Credit Note to offset each other. (partially
> or fully, as the case may be)
>
> Regards,
> Adrien
>

Thank you

Dave
___
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

[Murugan Muruganandam]

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 
Sent: Wednesday, December 21, 2022 5:05 PM
To: 'Murugan Muruganandam' 
Cc: 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  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> >