Credits befroe debits

[Xavier Lagraula]

Hello all,

This is quite a naïve answer from a newbie who does not know what
transactions imported from Quicken look like, but... When I import
transactions from the CSV file provided by my bank, the "number" field is
left blank. And it is exposed to the user by the UI of GC. I also think
that GC does not impose a unicity constraint on it and that one can sort
the display on this field.

So, on the condition that Quicken does not use it already, you could
aggregate your transactions using custom values (e.g. in your case "1"
could mean credit, and "2" debit). Even if Quicken does use it, it depends
on whether this number has a significance to you: you could replace it
altogether or prefix it to achieve the sort order your desire.

This is also a bit tedious, I'll grant you that. But much less than editing
the XML file by hand. And much less risky.

Best regards,
  Xavier


2014-07-18 16:34 GMT+02:00 John Morris <johnjeff at editide.us>:

> I also just imported from Quicken to GnuCash and had the same problem.
> Looking online, I found a page that indicated that GnuCash sorts the
> transaction by when they were input, down to the second, even though it
> only shows the date of input. If two transactions have the same input date
> and time, which they would in an import situation, they are sorted by the
> Number field. That's what the web page said, but it does not quite match my
> experience. My transactions seem to uniformly put the debits before the
> credits and changing a transaction (which I expect to change the date and
> time of input) does not affect the order.
>
>   Of course, reentering all your transactions is not a good solution if
> you have many of them. You can switch the file from compressed to
> uncompressed (Preferences->General->Compress Files) and then edit the input
> times show using a text editor, but that may be pretty tedious. For myself,
> I corrected the few problems I could see in the last screenful of
> transactions and ignored the rest. I know that they balance out in the end,
> and I don't go back there very often.
>
>   I agree that it would be nice to have better control over the order of
> presentation. At the very least, there should be a way to expose those
> input times in the GUI.
>
> Best,
> John
>
> On Jul 18, 2014, at 12:16 AM, Patrick Laprocina wrote:
>
> > I imported all of ny Quicken transactions into GnuCash. In my Quicken
> check register, all of credits for any given day were automatically moved
> to the beginning of the transaction list for that day, because that is the
> way that the banks all process transactions - credits then debits per day.
> When I looked in my GnuCash check register, the credits and debits were
> scattered about. The only time that I balanced with Quicken was at the end
> of the day. There were also many indications of overdrafts in GnuCash that
> did not occur.
> >
> > I looked in the register settings and could find no option to process
> credits first. Where/how do I get GnuCash to process credits before debits
> per day to match my bank records?
>
>
> _______________________________________________
> 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.
>