Problems with reconciling after large QIF import

[AJI-4]

I imported a large amount of data from Quicken 2005.  When I tried to
reconcile one of the accounts, I could not edit some of the transactions.

I needed to remove a split from one transaction and change the amount, and
add a split and change the amount on the other.

Even though neither were marked Cleared or Reconciled, and I had not
finished the reconciliation, KMM would not save the transactions.  The only
active button on the ledger window was "Cancel", and when I tried to select
another transaction, the "Cancel Transaction Edit" dialog came up.  Clicking
"No" would not save the transaction - I had to cancel and lose my changes to
continue using KMM.

This is my first reconciliation after the import.  How can I update the
transactions?

Sincerely,

Andrew Ittner



------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
KMyMoney2-user mailing list
KMyMoney2-user@...
https://lists.sourceforge.net/lists/listinfo/kmymoney2-user

[AJI-4]

> I imported a large amount of data from Quicken 2005.  When I tried to
> reconcile one of the accounts, I could not edit some of the transactions.
>
> I needed to remove a split from one transaction and change the amount, and
> add a split and change the amount on the other.
>
> Even though neither were marked Cleared or Reconciled, and I had not
> finished the reconciliation, KMM would not save the transactions.
>  The only
> active button on the ledger window was "Cancel", and when I tried
> to select
> another transaction, the "Cancel Transaction Edit" dialog came
> up.  Clicking
> "No" would not save the transaction - I had to cancel and lose my
> changes to
> continue using KMM.
>
> This is my first reconciliation after the import.  How can I update the
> transactions?
>

To deepen the mystery, it appears that the opening balance transaction
is gone.  Quicken listed the transaction as occuring about 50 years
too early, but KMM does not have it at all.  I cannot add that
as a completely new transaction, either.



------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
KMyMoney2-user mailing list
KMyMoney2-user@...
https://lists.sourceforge.net/lists/listinfo/kmymoney2-user

[Thomas Baumgart]

On Tuesday 18 August 2009 05:17:19 Andrew Ittner wrote:

> > I imported a large amount of data from Quicken 2005.  When I tried to
> > reconcile one of the accounts, I could not edit some of the transactions.
> >
> > I needed to remove a split from one transaction and change the amount,
> > and add a split and change the amount on the other.
> >
> > Even though neither were marked Cleared or Reconciled, and I had not
> > finished the reconciliation, KMM would not save the transactions.
> >  The only
> > active button on the ledger window was "Cancel", and when I tried
> > to select
> > another transaction, the "Cancel Transaction Edit" dialog came
> > up.  Clicking
> > "No" would not save the transaction - I had to cancel and lose my
> > changes to
> > continue using KMM.
> >
> > This is my first reconciliation after the import.  How can I update the
> > transactions?
>
> To deepen the mystery, it appears that the opening balance transaction
> is gone.  Quicken listed the transaction as occuring about 50 years
> too early, but KMM does not have it at all.  I cannot add that
> as a completely new transaction, either.

First off: which version of KMyMoney are you using?

This really sounds mysterious. If nothing helps, can you follow the
instructions given on
http://kmymoney2.sourceforge.net/online-manual/details.formats.anonymous.html 
so that we can take a deeper look?



--

Regards

Thomas Baumgart

GPG-FP: E55E D592 F45F 116B 8429   4F99 9C59 DB40 B75D D3BA
-------------------------------------------------------------
Linux & Open Source Software - aaah, the sweet smell of 'Free'dom
-------------------------------------------------------------


------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
KMyMoney2-user mailing list
KMyMoney2-user@...
https://lists.sourceforge.net/lists/listinfo/kmymoney2-user

[AJI-4]

> On Tuesday 18 August 2009 05:17:19 Andrew Ittner wrote:
> > > I imported a large amount of data from Quicken 2005.
> When I tried to
> > > reconcile one of the accounts, I could not edit some of
> the transactions.
> > >
> > > I needed to remove a split from one transaction and
> change the amount,
> > > and add a split and change the amount on the other.
> > >
> > > Even though neither were marked Cleared or Reconciled,
> and I had not
> > > finished the reconciliation, KMM would not save the transactions.
> > >  The only
> > > active button on the ledger window was "Cancel", and when I tried
> > > to select
> > > another transaction, the "Cancel Transaction Edit" dialog came
> > > up.  Clicking
> > > "No" would not save the transaction - I had to cancel and lose my
> > > changes to
> > > continue using KMM.
> > >
> > > This is my first reconciliation after the import.  How
> can I update the
> > > transactions?
> >
> > To deepen the mystery, it appears that the opening balance
> transaction
> > is gone.  Quicken listed the transaction as occuring about 50 years
> > too early, but KMM does not have it at all.  I cannot add that
> > as a completely new transaction, either.
>
> First off: which version of KMyMoney are you using?
>
> This really sounds mysterious. If nothing helps, can you follow the
> instructions given on
> http://kmymoney2.sourceforge.net/online-manual/details.formats

.anonymous.html
so that we can take a deeper look?

I compiled from CVS using the code available on August 10 (0.9.3).  Is
there an easy way to determine the CVS revision in my working copy?

The problem exists with the anonymized copy; I will forward that to the
dev list.

The opening balance for the account in question is in the QIF, but was
not imported; in addition, there are numerous erroneous imports - at a
glance, some transactions with no source (I may have deleted the account
a long time ago in Quicken) were assigned to my primary checking
account.

Thinking "out loud" here, I can probably work around that by making a
"phantom checking" account, and transferring those transactions from
"real" checking to phantom, and then close the phantom account.  I do
not see an option to delete the transaction source and keep the
destination.

Thanks,

Andrew Ittner



------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
KMyMoney2-user mailing list
KMyMoney2-user@...
https://lists.sourceforge.net/lists/listinfo/kmymoney2-user

[Thomas Baumgart]

On Wednesday 19 August 2009 07:37:24 Andrew Ittner wrote:

> > On Tuesday 18 August 2009 05:17:19 Andrew Ittner wrote:
> > > > I imported a large amount of data from Quicken 2005.
> >
> > When I tried to
> >
> > > > reconcile one of the accounts, I could not edit some of
> >
> > the transactions.
> >
> > > > I needed to remove a split from one transaction and
> >
> > change the amount,
> >
> > > > and add a split and change the amount on the other.
> > > >
> > > > Even though neither were marked Cleared or Reconciled,
> >
> > and I had not
> >
> > > > finished the reconciliation, KMM would not save the transactions.
> > > >  The only
> > > > active button on the ledger window was "Cancel", and when I tried
> > > > to select
> > > > another transaction, the "Cancel Transaction Edit" dialog came
> > > > up.  Clicking
> > > > "No" would not save the transaction - I had to cancel and lose my
> > > > changes to
> > > > continue using KMM.
> > > >
> > > > This is my first reconciliation after the import.  How
> >
> > can I update the
> >
> > > > transactions?
> > >
> > > To deepen the mystery, it appears that the opening balance
> >
> > transaction
> >
> > > is gone.  Quicken listed the transaction as occuring about 50 years
> > > too early, but KMM does not have it at all.  I cannot add that
> > > as a completely new transaction, either.
> >
> > First off: which version of KMyMoney are you using?
> >
> > This really sounds mysterious. If nothing helps, can you follow the
> > instructions given on
> > http://kmymoney2.sourceforge.net/online-manual/details.formats
>
> .anonymous.html
> so that we can take a deeper look?
>
> I compiled from CVS using the code available on August 10 (0.9.3).  Is
> there an easy way to determine the CVS revision in my working copy?
>
> The problem exists with the anonymized copy; I will forward that to the
> dev list.

Where I picked it up and took a look at it.

> The opening balance for the account in question is in the QIF, but was
> not imported;

Some opening balances have been picked up. From the internal IDs used I see,
that some have been skipped. Are the ones missing related to a certain
account type?

> in addition, there are numerous erroneous imports - at a
> glance, some transactions with no source (I may have deleted the account
> a long time ago in Quicken) were assigned to my primary checking
> account.

Can you check the information in the QIF source? How does it look there?

> Thinking "out loud" here, I can probably work around that by making a
> "phantom checking" account, and transferring those transactions from
> "real" checking to phantom, and then close the phantom account.  I do
> not see an option to delete the transaction source and keep the
> destination.

Keep in mind, that you can only close an account with a balance of 0. So that
might not be an option.

The problem why you cannot save the transaction is that the posting date for
the transaction is before the opening date of the account (which might have
been picked up wrong from the import). Once you correct that in the account
dialog you should be able to modify transactions.

It would be nice, if you can send me some fragments of your QIF file. An
interesting part would be the opening balance transaction and maybe the first
real transaction of the A000139 account. Please feel free to send it to me
via private e-mail and if necessary encrypt it using GPG.

--

Regards

Thomas Baumgart

GPG-FP: E55E D592 F45F 116B 8429   4F99 9C59 DB40 B75D D3BA
-------------------------------------------------------------
What is mind? No matter. What is matter? Never mind.
 (Punch, 1855)
-------------------------------------------------------------


------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
KMyMoney2-user mailing list
KMyMoney2-user@...
https://lists.sourceforge.net/lists/listinfo/kmymoney2-user

[Jack-160]

On 2009.08.17 23:17, Andrew Ittner wrote:
>> I imported a large amount of data from Quicken 2005.  When I tried  
>> to reconcile one of the accounts, I could not edit some of the  
>> transactions.

>> I needed to remove a split from one transaction and change the  
>> amount, and add a split and change the amount on the other.

>> Even though neither were marked Cleared or Reconciled, and I had not  
>> finished the reconciliation, KMM would not save the transactions.  
>> The only active button on the ledger window was "Cancel", and when I  
>> tried to select another transaction, the "Cancel Transaction Edit"  
>> dialog came up.  Clicking "No" would not save the transaction - I  
>> had to cancel and lose my changes to continue using KMM.

>> This is my first reconciliation after the import.  How can I update  
>> the transactions?

> To deepen the mystery, it appears that the opening balance  
> transaction is gone.  Quicken listed the transaction as occuring  
> about 50 years too early, but KMM does not have it at all.  I cannot  
> add that as a completely new transaction, either.

Minor point - but is the opening balance transaction really not  
present, or is it just not shown due to the filter of not showing  
transactions before a specified date?

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
KMyMoney2-user mailing list
KMyMoney2-user@...
https://lists.sourceforge.net/lists/listinfo/kmymoney2-user

[AJI-4]

> On 2009.08.17 23:17, Andrew Ittner wrote:
> >> I imported a large amount of data from Quicken 2005.  When
> I tried
> >> to reconcile one of the accounts, I could not edit some of the
> >> transactions.
>
> >> I needed to remove a split from one transaction and change the
> >> amount, and add a split and change the amount on the other.
>
> >> Even though neither were marked Cleared or Reconciled, and
> I had not
> >> finished the reconciliation, KMM would not save the
> transactions.
> >> The only active button on the ledger window was "Cancel",
> and when I
> >> tried to select another transaction, the "Cancel
> Transaction Edit"
> >> dialog came up.  Clicking "No" would not save the transaction - I
> >> had to cancel and lose my changes to continue using KMM.
>
> >> This is my first reconciliation after the import.  How can
> I update
> >> the transactions?
>
> > To deepen the mystery, it appears that the opening balance
> > transaction is gone.  Quicken listed the transaction as occuring
> > about 50 years too early, but KMM does not have it at all.
> I cannot
> > add that as a completely new transaction, either.
>
> Minor point - but is the opening balance transaction really not
> present, or is it just not shown due to the filter of not showing
> transactions before a specified date?
>

No, that's not it - my settings are to filter out anything before
1900-01-01, and the opening balance in questions was in 1944 (go
figure).

Andrew



------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
KMyMoney2-user mailing list
KMyMoney2-user@...
https://lists.sourceforge.net/lists/listinfo/kmymoney2-user

[AJI-4]

<snip>
> > The opening balance for the account in question is in the
> QIF, but was
> > not imported;
>
> Some opening balances have been picked up. From the internal
> IDs used I see,
> that some have been skipped. Are the ones missing related to
> a certain
> account type?

The missing opening balances are on 2 credit card accounts; on one, the
first transaction is correct - there is just no "Opening Balance"
transaction for that account (which was 0).  For the other, the OB is
missing, and it was non-zero.

I was able to modify the opening date for the 2nd, and I added the
opening balance.  The current balance appears much closer to reality.

>
> > in addition, there are numerous erroneous imports - at a
> > glance, some transactions with no source (I may have
> deleted the account
> > a long time ago in Quicken) were assigned to my primary checking
> > account.
>
> Can you check the information in the QIF source? How does it
> look there?

I will need some help with that - I don't know what the data should look
like.

>
> > Thinking "out loud" here, I can probably work around that
> by making a
> > "phantom checking" account, and transferring those transactions from
> > "real" checking to phantom, and then close the phantom
> account.  I do
> > not see an option to delete the transaction source and keep the
> > destination.
>
> Keep in mind, that you can only close an account with a
> balance of 0. So that
> might not be an option.
>
> The problem why you cannot save the transaction is that the
> posting date for
> the transaction is before the opening date of the account
> (which might have
> been picked up wrong from the import). Once you correct that
> in the account
> dialog you should be able to modify transactions.

That worked.  The account opening date was set to 100 years after the
opening balance in Quicken (2044 instead of 1944, so it appears that the
non-Y2K-compliant data in the QIF caused a problem.

>
> It would be nice, if you can send me some fragments of your
> QIF file. An
> interesting part would be the opening balance transaction and
> maybe the first
> real transaction of the A000139 account. Please feel free to
> send it to me
> via private e-mail and if necessary encrypt it using GPG.
>

Will do, thank you for your help.

Andrew Ittner



------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
KMyMoney2-user mailing list
KMyMoney2-user@...
https://lists.sourceforge.net/lists/listinfo/kmymoney2-user

[Thomas Baumgart]

Hi,

on Saturday 22 August 2009 Andrew Ittner wrote:

> <snip>
>
> > > The opening balance for the account in question is in the
> >
> > QIF, but was
> >
> > > not imported;
> >
> > Some opening balances have been picked up. From the internal
> > IDs used I see,
> > that some have been skipped. Are the ones missing related to
> > a certain
> > account type?
>
> The missing opening balances are on 2 credit card accounts; on one, the
> first transaction is correct - there is just no "Opening Balance"
> transaction for that account (which was 0).  For the other, the OB is
> missing, and it was non-zero.

In KMyMoney there won't be an opening balance transaction if it is 0.  

> I was able to modify the opening date for the 2nd, and I added the
> opening balance.  The current balance appears much closer to reality.

Does the opening balance show up when you edit the account data? If not,
delete the manually created transaction and simply add the value into the
field in the account edit dialog. Make sure to use the right sign.

This is just to avoid further problems with that opening balance. It could
influence the reporting side of things.

> > > in addition, there are numerous erroneous imports - at a
> > > glance, some transactions with no source (I may have
> >
> > deleted the account
> >
> > > a long time ago in Quicken) were assigned to my primary checking
> > > account.
> >
> > Can you check the information in the QIF source? How does it
> > look there?
>
> I will need some help with that - I don't know what the data should look
> like.
>
> > > Thinking "out loud" here, I can probably work around that
> >
> > by making a
> >
> > > "phantom checking" account, and transferring those transactions from
> > > "real" checking to phantom, and then close the phantom
> >
> > account.  I do
> >
> > > not see an option to delete the transaction source and keep the
> > > destination.
> >
> > Keep in mind, that you can only close an account with a
> > balance of 0. So that
> > might not be an option.
> >
> > The problem why you cannot save the transaction is that the
> > posting date for
> > the transaction is before the opening date of the account
> > (which might have
> > been picked up wrong from the import). Once you correct that
> > in the account
> > dialog you should be able to modify transactions.
>
> That worked.  The account opening date was set to 100 years after the
> opening balance in Quicken (2044 instead of 1944, so it appears that the
> non-Y2K-compliant data in the QIF caused a problem.

The (current) rule is, that all years < 70 are treated in this century. So
that's OK from my point of view.

> > It would be nice, if you can send me some fragments of your
> > QIF file. An
> > interesting part would be the opening balance transaction and
> > maybe the first
> > real transaction of the A000139 account. Please feel free to
> > send it to me
> > via private e-mail and if necessary encrypt it using GPG.
>
> Will do, thank you for your help.

--


Regards

Thomas Baumgart

GPG-FP: E55E D592 F45F 116B 8429   4F99 9C59 DB40 B75D D3BA
-------------------------------------------------------------
A clearly defined problem is half the solution!
(found in a chinese fortune cookie)
-------------------------------------------------------------


------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
KMyMoney2-user mailing list
KMyMoney2-user@...
https://lists.sourceforge.net/lists/listinfo/kmymoney2-user

[AJI-4]

> > <snip>
> >
> > > > The opening balance for the account in question is in the
> > >
> > > QIF, but was
> > >
> > > > not imported;
> > >
> > > Some opening balances have been picked up. From the internal
> > > IDs used I see,
> > > that some have been skipped. Are the ones missing related to
> > > a certain
> > > account type?
> >
> > The missing opening balances are on 2 credit card accounts;
> on one, the
> > first transaction is correct - there is just no "Opening Balance"
> > transaction for that account (which was 0).  For the other,
> the OB is
> > missing, and it was non-zero.
>
> In KMyMoney there won't be an opening balance transaction if
> it is 0.
>
> > I was able to modify the opening date for the 2nd, and I added the
> > opening balance.  The current balance appears much closer
> to reality.
>
> Does the opening balance show up when you edit the account
> data? If not,
> delete the manually created transaction and simply add the
> value into the
> field in the account edit dialog. Make sure to use the right sign.
>
> This is just to avoid further problems with that opening
> balance. It could
> influence the reporting side of things.
>
> > > > in addition, there are numerous erroneous imports - at a
> > > > glance, some transactions with no source (I may have
> > >
> > > deleted the account
> > >
> > > > a long time ago in Quicken) were assigned to my primary checking
> > > > account.
> > >
> > > Can you check the information in the QIF source? How does it
> > > look there?
> >
> > I will need some help with that - I don't know what the
> data should look
> > like.
> >
> > > > Thinking "out loud" here, I can probably work around that
> > >
> > > by making a
> > >
> > > > "phantom checking" account, and transferring those
> transactions from
> > > > "real" checking to phantom, and then close the phantom
> > >
> > > account.  I do
> > >
> > > > not see an option to delete the transaction source and keep the
> > > > destination.
> > >
> > > Keep in mind, that you can only close an account with a
> > > balance of 0. So that
> > > might not be an option.
> > >
> > > The problem why you cannot save the transaction is that the
> > > posting date for
> > > the transaction is before the opening date of the account
> > > (which might have
> > > been picked up wrong from the import). Once you correct that
> > > in the account
> > > dialog you should be able to modify transactions.
> >
> > That worked.  The account opening date was set to 100 years
> after the
> > opening balance in Quicken (2044 instead of 1944, so it
> appears that the
> > non-Y2K-compliant data in the QIF caused a problem.
>
> The (current) rule is, that all years < 70 are treated in
> this century. So
> that's OK from my point of view.
>
> > > It would be nice, if you can send me some fragments of your
> > > QIF file. An
> > > interesting part would be the opening balance transaction and
> > > maybe the first
> > > real transaction of the A000139 account. Please feel free to
> > > send it to me
> > > via private e-mail and if necessary encrypt it using GPG.
> >
> > Will do, thank you for your help.

I finally got the import completed; I will send a separate email with
the problems and workarounds so others can benefit.

Thank you for your help!

Andrew Ittner



------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
KMyMoney2-user mailing list
KMyMoney2-user@...
https://lists.sourceforge.net/lists/listinfo/kmymoney2-user