GNUCash Import QIF - Help Please!

[GT-I9070 H]

2015-07-02 16:11 GMT-04:00 Wm <wm+gnc at tarrcity.demon.co.uk>:

Thanks for your attention Wm!



> I think you posted about this before and everyone lost interest because it
> was so obscure.  It might help if you showed the document, I would
> certainly read it out of interest.


No, this is the first time I publish this my approach to work with
multicurrency.

Documentation is incomplete and is written in the same terms of the text
you read.



> What I think you do is this:
>
> Buy X100 for Y50 and then reprice everything you buy in X in terms of Y.
>

Yeah. Now I have X100 for spending. When I spend all X100 I will have spent
all Y50.


>
> So each X in your pocket is (you think) Y.5
>

No. If X100=Y50 then X=Y*1/2 (Where Y is default currency, X the foreign
currency and 1/2 the exchange rate).
Except if 1/2 = .5 in this case I'm sorry this is a notation issue. In my
country 1/2 = 0,5.


>
> So instead of a snack costing X1 you record it as Y.5 and so on
>

Yeah with the fix above (No Y.5, Yes Y*1/2). Record in their respective
accounts with their respective currencies.
What we have here is a simple and common transaction between two different
currencies AND an exchange rate, so I record X, Y and the rate.


>
> Until you get some more of X at a slightly different rate at which point
> the same snack now costs Y.54132


No, maybe Yes. I spent all the X money in your rate (1/2), buy more
X money in your new rate and follow spending. eg. X=Y*1/3.


If I understand, and I *think* I do, then possibly an import won't work at
> all and becomes rather complicated.  As JohnR suggests in the other thread
> you'd be better off using the API, python should be easy enough if you
> borrow and you definitely need the sanity checks it involves.


When I asked for your help in this thread I meant a way to *import*
transactions WITH off-line exchange rate from an Excel spreadsheet and not
to this text on my approach to work with multicurrency, but if you are
interested in talking about it would be a pleasure but I think more
appropriate we open another thread.

Thanks

Regards
GTI