Handling multiple currency in GNUCash

Abrash Pervaiz abrash_p at hotmail.com
Sun Oct 21 18:02:48 EDT 2012 

Hi all,
Apologies for grouping different topics under the same post, I'd be careful about this in the future.
Some users were generous enough to help me with the reporting issue via email, so you can mark this as solved. 




> From: gnucash-user-request at gnucash.org
> Subject: gnucash-user Digest, Vol 115, Issue 30
> To: gnucash-user at gnucash.org
> Date: Sun, 21 Oct 2012 12:00:03 -0400
> 
> Send gnucash-user mailing list submissions to
> 	gnucash-user at gnucash.org
> 
> To subscribe or unsubscribe via the World Wide Web, visit
> 	https://lists.gnucash.org/mailman/listinfo/gnucash-user
> or, via email, send a message with subject or body 'help' to
> 	gnucash-user-request at gnucash.org
> 
> You can reach the person managing the list at
> 	gnucash-user-owner at gnucash.org
> 
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of gnucash-user digest..."
> 
> 
> Today's Topics:
> 
>    1. Re: Handling multiple currency in GNUCash (David Carlson)
>    2. Re: filtering online banking transactions (Marc Sherman)
>    3. Re: ipmt function ignorning the i argument? (Marc Sherman)
> 
> 
> ----------------------------------------------------------------------
> 
> Message: 1
> Date: Sun, 21 Oct 2012 07:52:48 -0500
> From: David Carlson <carlson.dl at sbcglobal.net>
> To: gnucash-user at gnucash.org
> Subject: Re: Handling multiple currency in GNUCash
> Message-ID: <5083F020.3080003 at sbcglobal.net>
> Content-Type: text/plain; charset="iso-8859-1"
> 
> On 10/20/2012 11:57 AM, Abrash Pervaiz wrote:
> > Hello again,
> > Thanks for everyone who replied. I have briefly gone over the tutorial and will go in further detail to see if it helps, including using the trading accounts. However, I have decided to delay this just to give the owner a bit of time to get acclimatised to the new accounting system without the added hassle of dealing with multiple currencies (which is complicated enough for me, at least in GNU, so far).
> > I have run into another problem though. I think it is a bug and I am not sure whether it's happening just on my system or is a general issue with ver 2.4.11. I ran the "balance sheet" and "profit and loss" reports on some dummy data, and the top level accounts they show are not balanced (they are balanced on the main screen). For example, the "Assets" account only holds a "zero" balance whereas it should add up all the asset accounts (text dump is shown below):
> >
> > Assets	   	                                               $ 0.00	          Current Assets	          $ 0.00	   	                Petty Cash	          $ 0.00	   	                Inventory	          $ 58,850.00	   	                Prepaid Rent	  $ 0.00	   	                Checking Account $ 52,500.00	   	                Savings Account	$ 0.00	   	          Accounts Receivable	   	$ 0.00	   
> > The accounts on the main screen hold proper balances, so the issue seems to be with report generation. Is anyone else experiencing this?
> > -Abrash
> >
> 
> You have hit on another topic that is often discussed here.  Learning
> how to adapt the provided reports to your needs requires a great deal of
> reading and ultimately a little or a lot of experimenting to wrap the
> chosen report around your particular Chart of Accounts. 
> 
> It would be very difficult to discuss both of the two types that you are
> asking about in the same discussion thread.  I would suggest that you
> narrow your focus to one report per thread and that you go into more
> detail whether you are having a problem with the default settings or
> whatever. 
> 
> Also, please start a new thread when you change the topic.
> 
> David C
> 
> 
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: 0xDC7C8BF3.asc
> Type: application/pgp-keys
> Size: 1729 bytes
> Desc: not available
> URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20121021/5249e8cb/attachment-0001.bin>
> 
> ------------------------------
> 
> Message: 2
> Date: Sun, 21 Oct 2012 09:45:41 -0400
> From: Marc Sherman <msherman at projectile.ca>
> To: gnucash-user at gnucash.org
> Subject: Re: filtering online banking transactions
> Message-ID: <5083FC85.7000002 at projectile.ca>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
> 
> On 10/21/2012 4:26 AM, josh wrote:
> > 3. I tried just importing the data for one month and then associating
> > the accounts for these transactions and then importing the rest in the
> > hope that gnucash would automagically be able to suggest certain
> > accounts for similar transactions as had been previously sorted (this
> > would be like having an automagic filter.), but it didn't. Can this be done?
> 
> Yes, this works if you associate the accounts in the Import dialog, 
> rather than waiting until after they're imported.
> 
> Double click on a yellow transaction to select an account to import to.
> 
> - Marc
> 
> 
> 
> ------------------------------
> 
> Message: 3
> Date: Sun, 21 Oct 2012 09:47:11 -0400
> From: Marc Sherman <msherman at projectile.ca>
> To: gnucash-user at gnucash.org
> Subject: Re: ipmt function ignorning the i argument?
> Message-ID: <5083FCDF.50404 at projectile.ca>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
> 
> On 10/21/2012 4:39 AM, Mike Evans wrote:
> >
> > Does this bug describe the issue you are having?
> >
> > https://bugzilla.gnome.org/show_bug.cgi?id=665883
> 
> Not exactly -- if I create a scheduled transaction with just i in the 
> formula, it does properly increment. It only seems to fail with the more 
> complicated ipmt function.
> 
> On 10/21/2012 6:27 AM, Yann Le Mouel wrote:
> >
> > Maybe this is related to this bug 670731 as well and that the
> > workaround works either.
> >
> > https://bugzilla.gnome.org/show_bug.cgi?id=670731
> >
> > Be aware that modifying the data file is not supported so do a proper
> > backup before...
> 
> That's a lot closer. In this bug, the filer says that it only fails with 
> a non-zero fv parameter, but I'm giving it 0 for fv.
> 
> I tried the workaround, but my .gnucash file is in a binary format, so I 
> can't edit it. This is despite the fact that in the save dialog, I 
> selected "xml" from the format dropdown. Is that a known bug on windows, 
> and if so, is there any way to work around it to get an XML formatted 
> gnucash file?
> 
> - Marc
> 
> 
> ------------------------------
> 
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> 
> 
> End of gnucash-user Digest, Vol 115, Issue 30
> *********************************************

More information about the gnucash-user mailing list