GNUCash Import QIF - Help Please!

allanhasmail at gmail.com allanhasmail at gmail.com
Tue Jun 23 16:30:59 EDT 2015


Isn't the xls2qif macro a good tool for this?

I haven't been following to closely, but I got it working by bypassing the macro security preferences.
--
Allan

Derek Atkins <warlord at MIT.EDU> wrote:
>David,
>
>David Carlson <david.carlson.417 at gmail.com> writes:
>
>> On 6/22/2015 10:25 PM, GT-I9070 H wrote:
>>> Hi David,
>>>
>>> Thanks for the tip!
>>>
>>> But I do not want the Internet exchange rates, I want to exchange
>>> rates (currency prices) that I practiced on that date in every
>>> transaction that I have written in an MS Excel spreadsheet.
>>>
>>> Regards
>>> GTI
>>>
>>
>> I am still not fully understanding what you are looking for.  If a
>given
>> transaction involves two (or more) currencies, it will have an
>inherent
>> exchange rate which should be correct therein if it is entered
>> correctly.  I.e., if I buy a bag of candy marked US$5.00 and pay for
>it
>> with a certain number of Euros, there is an exact exchange rate
>within
>> the transaction. 
>
>What he's looking for is a way to *import* these transactions.
>
>Sure, he could enter them into the register, but he's (for some reason)
>already entered them into some other spreadsheet program and wants to
>import them into Gnucash instead of re-keying them into the Gnucash UI.
>
>AFAIK, none of the importers will do that.
>
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>
>-derek
>-- 
>       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
>       Member, MIT Student Information Processing Board  (SIPB)
>       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
>       warlord at MIT.EDU                        PGP key available
>_______________________________________________
>gnucash-user mailing list
>gnucash-user at gnucash.org
>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.


More information about the gnucash-user mailing list