Failure to Balance

[Doug Laidlaw]

I have seen something similar when importing a complete Quicken ledger as 
a .QIF file.  Part of a split could be imported twice, once as part of the 
split and again as a distinct transaction.  I had to hunt down the duplicates 
manually, afterwards.  The best indicator was that they were not flagged as 
reconciled.  Often their matching entry was reconciled, producing a warning.

I reconcile only bank accounts, as I don't have vouchers for revenue accounts.

Doug.

On Tue, 26 Jun 2007 03:37:40 pm David T. wrote:
> This thread is old, but I thought you all would like to know that I finally
> found out what was causing my trouble (hint: it wasn't Gnucash!). It seems
> that on several multi-split transactions in 2006 (paychecks with 12
> different lines on them) which had been imported from a Quicken QIF file,
> two lines got put into the ledger twice--once in the original transaction,
> and once as a free-standing transaction. The original transaction in
> Quicken was reconciled, so both of these got reconciled flags on import.
> Because the transactions were to retirement accounts that I don't reconcile
> very often, I never noticed the extra cash sitting in the parent cash
> account. I was reconciling these accounts yesterday, and found those extra
> entries, which cleared up the discrepancy.
>
> For that person asking recently about whether to reconcile: I'd say you
> should!
>
> Cheers, and thanks for all the suggestions back then!
> David
>
> --- "Michael B. Trausch" <fd0man at gmail.com> wrote:
> > On Tue, 2007-03-06 at 23:07 -0500, Derek Atkins wrote:
> > > First thing I would try is "Check & Repair" which should make sure all
> > > your transactions are balanced.  This will add splits to the
> > > Unreconciled
> > > or Imbalance accounts.  From there, I dont know what to tell you.  It
> > > does sound like there are missing transactions that got deleted.
> >
> > Interesting.  I had a little bit of a problem balancing my GC file and I
> > had to print out the transaction log and go through them to find where
> > the problem was.  I even tried that Check & Repair thing (after I made a
> > backup, of course, because I didn't know exactly what C&R did).  What it
> > was, though, at least in my case, was the first of two transactions made
> > in a foreign currency.  GC somehow figured on making the exchange rate
> > 1:1 for USD:GBP when I created my first GBP account, and when I paid it
> > off with a proper exchange rate was when the imbalance was created.
> >
> >     — Mike
> >
> > --
> > Michael B. Trausch
> >                     fd0man at gmail.com
> > Phone: (404) 592-5746
> >                           Jabber IM:
> >                     fd0man at gmail.com
> >               fd0man at livejournal.com
> > Demand Freedom!  Use open and free protocols, standards, and software!
> >
> > > _______________________________________________
> >
> > 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.
>
> ___________________________________________________________________________
>_________Ready for the edge of your seat? Check out tonight's top picks on
> Yahoo! TV.
> http://tv.yahoo.com/
> _______________________________________________
> 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.