imported transactions

[Charles Day]

On Fri, Oct 31, 2008 at 6:58 AM, Beverly Compere <ufichina at gmail.com> wrote:

>  Thanks so much for your email!
>
>
>
> Your questions caused me to look closely at my transactions.  Since Quicken
> isn't a double-entry program, I had "rigged" it to make it do some things I
> wanted (I'm sure you've heard that before!).  My problems were related to
> that.  I think if I fiddle with the QIF file, it will all work fine.  Also,
> I had understood the concept of all imported transactions coming in with a
> 1:1 ratio, but still couldn't make it work.  After your email, I went back
> to my accounts and tried again.  I had been trying to edit the wrong line of
> the split, so of course it wasn't working.  Thanks to you, I've got it
>
What did you "rig" in Quicken exactly? My guess: You couldn't make a deposit
directly into a retirement account so you deposited it in another account
with an equal transfer, leaving a transaction value of zero. (That's the
only one I know.)

The register could be more forgiving about the "edit exchange rate" thing,
like automatically applying your request to the other line if there are only
two. I think there is already a bug report for this, but I'm not sure.

> now.
>
>
>
> Thanks again for a great program.  I've plugged along with Quicken for
> years, but it just doesn't do what I need (which was really double-entry
> accounting).  QuickBooks won't track investments, making it worthless for
> someone trying to keep track of personal and business finance together.
> When I first downloaded GnuCash, I wasn't impressed, but the more I work
> with it, the more I like it.  It's really got powerful and useful features.
> I've recommended it to accountant friends.  Keep up the great work!
>
>
>
> Thanks again for taking time to answer my questions.
>
>
>
> Beverly C
>
>
>
You're welcome,
Charles

>
>
> *From:* Charles Day [mailto:cedayiv at gmail.com]
> *Sent:* Wednesday, October 29, 2008 11:21 PM
> *To:* Beverly Compere; gnucash-user at gnucash.org
> *Subject:* Re: imported transactions
>
>
>
> On Wed, Oct 29, 2008 at 7:27 AM, Beverly Compere <ufichina at gmail.com>
> wrote:
>
>  Thanks for your help several weeks ago.  I've run into another snag.
> After importing a number of years of Quicken info into GnuCash, there were
> some problems (not surprising, as I am working with multiple currencies).
> Some of my transactions came in "backwards" (credits when they should be
> debits and debits where there should be credits).   I also have some
> multi-currency transactions that didn't work right.  I would like to edit
> both of these types of transactions to correct them.  However for some
> reason, the program won't let me edit these transaction that were brought in
> from Quicken.  If I make a new transaction, editing is easy, but not for
> these old ones.  For example, if I go into one of these imported
> transactions and try to move the credit amount to the debit column (deleting
> the amount from the credit column) and correcting the rest of the
> transaction in this way, when hitting the "enter" key, it all reverts to the
> original amounts, not keeping the edits.  These imported transactions will
> also not let me change the exchange rate (that option won't even show up
> when right-clicking on the transaction).  Do you have any suggestions, or
> could you point me someplace for help.  I have searched on the web and
> through all the GnuCash documentation I could find.
>
>
>
>  Can you give an example of a transaction with backwards credits/debits?
> And what do the QIF lines look like for that transaction?
>
> For the exchange rates, have you already corrected the currency settings on
> all the accounts? The QIF importer would have assumed that all imported
> accounts and transactions used the same currency, exchange rates on all
> imported splits were set to 1. Now that you want to correct them, remember
> that all amounts you see in a particular account register are in terms of
> the currency of that account. So.you can't edit the exchange rate of a split
> line for that same account since it is 1:1 by definition. You would have to
> be change the rate on one of the other split lines.
>
>  Thank you!
>
> Beverly C
>
>
> Cheers,
> Charles
>
> P.S. Remember to CC the list on your reply.
>