FW: Reconciliation problem - State of transaction as reconciled is not preserved.

[Avner]

Hi,

I agree that it doesn't make sense to have a statement dated January 1 with
a transaction that happened on January 5.
However, the "Reconciliation" page for a statement date of January 1 DOES
show transactions from a later date (e.g. January 5) but without the tick
marks (even if transactions from a later date were ticked earlier, using
reconciliation with a later statement date).
So it also doesn't make sense to show transactions that happen after the
statement date. But if later transactions are shown (current behavior) then
I expect that the attributes of these transactions will also be shown.

Regards, 
Avner

xxxxx-----Original Message-----
xxxxxFrom: Derek Atkins [mailto:warlord at MIT.EDU]
xxxxxSent: Sunday, December 28, 2008 12:56 PM
xxxxxTo: Avner
xxxxxCc: gnucash-user at gnucash.org
xxxxxSubject: Re: FW: Reconciliation problem - State of transaction as
xxxxxreconciled is not preserved.
xxxxx
xxxxxHi,
xxxxx
xxxxxQuoting Avner <avner-moshkovitz at shaw.ca>:
xxxxx
xxxxx>
xxxxx> I have noticed that the ticking state of the transactions shows up
xxxxxaccording
xxxxx> to the "Statement Date" in the "Reconcile Information" dialog box.
xxxxx> If I choose a date which is earlier than the transaction, even though
xxxxxthe
xxxxx> transaction was earlier ticked in the "Reconcile" page, it will show
xxxxxup as
xxxxx> NON ticked.
xxxxx> For example, if the "Statement Date" is set to 10/31/2008 and the
xxxxx> transaction is from 12/15/2008, then the transaction doesn't show up
xxxxxas
xxxxx> ticked in the "Reconcile" page. If I change the "Statement Date" to
xxxxx> 12/31/2008, then the transaction does show up as ticked in the
xxxxx"Reconcile"
xxxxx> page.
xxxxx> This is confusing. Is this a designed feature, or a bug?
xxxxx
xxxxxThis is a feature.   How could you have a statement dated January 1
xxxxxwith a transaction that didn't happen until January 5?  You can't.
xxxxxSo that's why the system works the way it does.
xxxxx
xxxxx> Regrads,
xxxxx> Avner
xxxxx
xxxxx-derek
xxxxx
xxxxx>
xxxxx>
xxxxx> xxxxx-----Original Message-----
xxxxx> xxxxxFrom: Avner [mailto:avner-moshkovitz at shaw.ca]
xxxxx> xxxxxSent: Sunday, December 28, 2008 10:51 AM
xxxxx> xxxxxTo: 'Derek Atkins'
xxxxx> xxxxxCc: 'gnucash-user at gnucash.org'
xxxxx> xxxxxSubject: RE: Reconciliation problem - State of transaction as
xxxxx> xxxxxreconciled is not preserved.
xxxxx> xxxxx
xxxxx> xxxxxHello,
xxxxx> xxxxx
xxxxx> xxxxxThe state indeed changes from "n" to "c" in the "R" column in
xxxxxthe
xxxxx> xxxxxregister account page. However, the problem is that after
xxxxxticking
xxxxx> xxxxxtransactions in the Reconcile dialog box, postponing, and then
xxxxx> xxxxxreopening the Reconcile dialog box, the transactions appear as
xxxxxNON
xxxxx> xxxxxticked.
xxxxx> xxxxxSo you have no indication of what is already reconciled once you
xxxxxare
xxxxx> xxxxxresuming the reconciliation.
xxxxx> xxxxxThis happens only for some of the newer transactions (for
xxxxxearlier
xxxxx> xxxxxtransactions the ticked state is preserved when resuming the
xxxxx> xxxxxreconciliation). Therefore I suspect that this has something to
xxxxxdo with
xxxxx> xxxxxthe new import or with the growing list of transactions.
xxxxx> xxxxx
xxxxx> xxxxx
xxxxx> xxxxxOn another note, you mentioned that: "The OFX importer will mark
xxxxx> xxxxxduplicate/matched transactions as cleared".
xxxxx> xxxxxWhat does "duplicate/matched" mean?
xxxxx> xxxxxI noticed that if you import two files with overlapping
xxxxxtransactions
xxxxx> xxxxx(e.g. a file with transactions for the months of
xxxxxOctober/November and a
xxxxx> xxxxxfile with transactions for the months of November/December) then
xxxxx> xxxxxduplicate transactions are handled correctly (i.e. do not show
xxxxxup
xxxxx> xxxxxtwice)
xxxxx> xxxxx
xxxxx> xxxxxI have experienced this problem with Gnucash 2.2.7 and 2.2.8 on
xxxxxWindows
xxxxx> xxxxxXP and Windows Vista
xxxxx> xxxxx
xxxxx> xxxxxRegards,
xxxxx> xxxxxAvi
xxxxx> xxxxx
xxxxx> xxxxx
xxxxx> xxxxx
xxxxx> xxxxxxxxxx-----Original Message-----
xxxxx> xxxxxxxxxxFrom: Derek Atkins [mailto:warlord at MIT.EDU]
xxxxx> xxxxxxxxxxSent: Sunday, December 28, 2008 7:55 AM
xxxxx> xxxxxxxxxxTo: Avner
xxxxx> xxxxxxxxxxCc: gnucash-user at gnucash.org
xxxxx> xxxxxxxxxxSubject: Re: Reconciliation problem - State of transaction
xxxxxas
xxxxx> xxxxxxxxxxreconciled is not preserved.
xxxxx> xxxxxxxxxx
xxxxx> xxxxxxxxxxHi,
xxxxx> xxxxxxxxxx
xxxxx> xxxxxxxxxxQuoting Avner <avner-moshkovitz at shaw.ca>:
xxxxx> xxxxxxxxxx
xxxxx> xxxxxxxxxx> Hello,
xxxxx> xxxxxxxxxx>
xxxxx> xxxxxxxxxx> I have a problem with reconciling transactions on my
xxxxxcredit card
xxxxx> xxxxxxxxxxaccount.
xxxxx> xxxxxxxxxx> After importing new transactions into gnucash, the
xxxxxreconciled
xxxxx> xxxxxstate
xxxxx> xxxxxxxxxxof the
xxxxx> xxxxxxxxxx> new transactions is not preserved.
xxxxx> xxxxxxxxxx>
xxxxx> xxxxxxxxxx> I downloaded a new period of credit card transactions
xxxxxfrom the
xxxxx> xxxxxcredit
xxxxx> xxxxxxxxxxcard
xxxxx> xxxxxxxxxx> online banking site and imported it into my gnucash data
xxxxxfile.
xxxxx> xxxxxxxxxx>
xxxxx> xxxxxxxxxx> I reconcile some of the new transactions, choose
xxxxxPostpone, save
xxxxx> xxxxxthe
xxxxx> xxxxxxxxxxdata to
xxxxx> xxxxxxxxxx> file and exit gnucash.
xxxxx> xxxxxxxxxx>
xxxxx> xxxxxxxxxx> After reopening the gnucash application, the transactions
xxxxxshow
xxxxx> xxxxxup as
xxxxx> xxxxxxxxxxnot
xxxxx> xxxxxxxxxx> reconciled.
xxxxx> xxxxxxxxxx>
xxxxx> xxxxxxxxxx> I have tried doing the same for transactions from a
xxxxxprevious
xxxxx> xxxxximport
xxxxx> xxxxxxxxxx> successfully, i.e. the reconciled state is preserved
xxxxx> xxxxxxxxxx>
xxxxx> xxxxxxxxxx> I suspect that this have to do with gnucash handling
xxxxxgrowing
xxxxx> xxxxxamount
xxxxx> xxxxxxxxxxof
xxxxx> xxxxxxxxxx> transactions.
xxxxx> xxxxxxxxxx>
xxxxx> xxxxxxxxxx> Alternatively this may be related to multiple importing.
xxxxxI'm
xxxxx> xxxxxusing
xxxxx> xxxxxxxxxxGnucash
xxxxx> xxxxxxxxxx> 2.2.7 I have also tried version 2.2.8 with no success
xxxxx> xxxxxxxxxx>
xxxxx> xxxxxxxxxx> Thanks,
xxxxx> xxxxxxxxxx>
xxxxx> xxxxxxxxxx> Avi
xxxxx> xxxxxxxxxx
xxxxx> xxxxxxxxxxWhen you Postpone the reconciliation it will NOT mark the
xxxxx> xxxxxtransactions
xxxxx> xxxxxxxxxxas RECONCILED (y).  However, it SHOULD mark the items as
xxxxxCleared
xxxxx> xxxxx(c).
xxxxx> xxxxxxxxxx
xxxxx> xxxxxxxxxxThe QIF importer doesn't touch the reconciliation bits at
xxxxxall.
xxxxx> xxxxxxxxxxThe OFX importer will mark duplicate/matched transactions
xxxxxas
xxxxx> xxxxxcleared.
xxxxx> xxxxxxxxxx
xxxxx> xxxxxxxxxx> Please remember to CC this list on all your replies.
xxxxx> xxxxxxxxxx> You can do this by using Reply-To-List or Reply-All.
xxxxx> xxxxxxxxxx
xxxxx> xxxxxxxxxx-derek
xxxxx> xxxxxxxxxx
xxxxx> xxxxxxxxxx--
xxxxx> xxxxxxxxxx       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media
xxxxxLaboratory
xxxxx> xxxxxxxxxx       Member, MIT Student Information Processing Board
xxxxx(SIPB)
xxxxx> xxxxxxxxxx       URL: http://web.mit.edu/warlord/    PP-ASEL-IA
xxxxxN1NWH
xxxxx> xxxxxxxxxx       warlord at MIT.EDU                        PGP key
xxxxxavailable
xxxxx>
xxxxx>
xxxxx
xxxxx
xxxxx
xxxxx--
xxxxx       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
xxxxx       Member, MIT Student Information Processing Board  (SIPB)
xxxxx       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
xxxxx       warlord at MIT.EDU                        PGP key available