| Author |
Message |
Kevin Allen
Guest
|
 Posted:
Sat Oct 15, 2005 7:14 am Post subject:
Problem with Reconcilliation |
|
|
I am using Quicken 2004 (release 5).
My computer crashed(motherboard died) and I had to install Quicken on my
laptop.
I have entered a few manual checks that I had written and have accepted
all of my downloaded transactions.
The problem I am having is that when I go to reconcile my checking
account the opening balance does not match the closing balance from my
last reconcile. When I change the opening balance Quicken says I have
an error in my opening balance.
I looked at the help in Quicken and it says to use resolve to help fix
this problem. I can't find the resolve function anywhere. I also can't
find a way to re-do previous reconciliations.
Any help would be appreciated.
Kevin Allen
|
|
| Back to top |
|
 |
John Pollard
Guest
|
| Posted:
Sat Oct 15, 2005 4:01 pm Post subject:
Re: Problem with Reconcilliation |
|
|
Kevin Allen wrote:
| Quote: | I am using Quicken 2004 (release 5).
My computer crashed(motherboard died) and I had to install
Quicken on
my laptop.
I have entered a few manual checks that I had written and have
accepted all of my downloaded transactions.
The problem I am having is that when I go to reconcile my
checking
account the opening balance does not match the closing balance
from my
last reconcile. When I change the opening balance Quicken
says I have
an error in my opening balance.
I looked at the help in Quicken and it says to use resolve to
help fix
this problem. I can't find the resolve function anywhere. I
also
can't find a way to re-do previous reconciliations.
|
In my experience, if "Resolve" is available at all, you can get
it by unreconciling a transaction, then initiating a Reconcile.
Otherwise, the only remedy I found was to unreconcile all
transactions, then initiate a Reconcile up to the last known
statement balance. (You could re-reconcile for each previous
statement, but that could be very cumbersome and time consuming
and I could not find any justification for spending that time).
--
John Pollard
First initial underscore Last name at mchsi dot com
Please reply to newsgroup |
|
| Back to top |
|
|
Kevin Allen
Guest
|
| Posted:
Sun Oct 16, 2005 8:01 am Post subject:
Re: Problem with Reconcilliation |
|
|
John, thanks for the advice but no luck so far.
I tried unreconiling a transaction but that did not give the resolve
function.
I then made a copy of my fileset. I then validated the copied file. It
found 1 transaction in the QSD where the splits had been removed. I
corrected that transaction. There were also 51 errors in the QEL file
where it said there were payments removed that were not in the register.
Is the QEL file for online payments?
I tried reconciling the account by changing all the reconciled
tranactions to cleared. When I do the reconcilliation it is off by the
same amount as before when I reconcile to the current statement. I then
tried reconciling to last months statement and I am still off by the
same amount. I then reconciled to a statement that is from about 4
years ago. It is still off but by a smaller amount.
Do you think I had 51 transactions deleted somehow?
Any futher advice or suggestions would be helpful.
Kevin Allen
John Pollard wrote:
| Quote: | Kevin Allen wrote:
I am using Quicken 2004 (release 5).
My computer crashed(motherboard died) and I had to install
Quicken on
my laptop.
I have entered a few manual checks that I had written and have
accepted all of my downloaded transactions.
The problem I am having is that when I go to reconcile my
checking
account the opening balance does not match the closing balance
from my
last reconcile. When I change the opening balance Quicken
says I have
an error in my opening balance.
I looked at the help in Quicken and it says to use resolve to
help fix
this problem. I can't find the resolve function anywhere. I
also
can't find a way to re-do previous reconciliations.
In my experience, if "Resolve" is available at all, you can get
it by unreconciling a transaction, then initiating a Reconcile.
Otherwise, the only remedy I found was to unreconcile all
transactions, then initiate a Reconcile up to the last known
statement balance. (You could re-reconcile for each previous
statement, but that could be very cumbersome and time consuming
and I could not find any justification for spending that time).
|
|
|
| Back to top |
|
|
John Pollard
Guest
|
| Posted:
Sun Oct 16, 2005 4:00 pm Post subject:
Re: Problem with Reconcilliation |
|
|
Kevin Allen wrote:
| Quote: | John, thanks for the advice but no luck so far.
I tried unreconiling a transaction but that did not give the
resolve
function.
I then made a copy of my fileset. I then validated the copied
file. It found 1 transaction in the QSD where the splits had
been removed. I
corrected that transaction. There were also 51 errors in the
QEL file
where it said there were payments removed that were not in the
register. Is the QEL file for online payments?
|
I believe the QEL file is related to online activities, but I do
not know enough to clarify what happened here.
| Quote: | I tried reconciling the account by changing all the reconciled
tranactions to cleared. When I do the reconcilliation it is
off by
the same amount as before when I reconcile to the current
statement. I then tried reconciling to last months statement
and I am still off
by the same amount.
|
Unless you are finding that Quicken's math is incorrect, I think
this indicates that you have some missing or incorrect
transactions.
| Quote: | I then reconciled to a statement that is from
about 4 years ago. It is still off but by a smaller amount.
Do you think I had 51 transactions deleted somehow?
|
Could be, but not sure it is helpful to know, especially if
there are no specifics on which transactions were involved.
I have only had one or two problems with old reconciles becoming
unreconciled and, in my recollection, they were solved by simply
re-reconciling all transactions: that is, my data was correct,
the reconciliation totals were wrong. In your case, it sounds
like your data is wrong.
I would start at the beginning (as far back as you can go
anyway) and reconcile until there is a discrepancy; noting what
is wrong, then moving on to subsequent reconciles until you find
another discrepancy. Perhaps a pattern will reveal itself; then
you might go directly to, and fix, the missing/incorrect
transactions, after which one final reconciliation of remaining
transactions might finish the job. If no pattern appears, all I
can think of is to re-reconcile each statement to the present (I
don't like the idea of trying to enter a single adjustment
sometime in the distant past that would make the current balance
correct ... it would mean the balance on most dates would still
be wrong).
--
John Pollard
First initial underscore Last name at mchsi dot com
Please reply to newsgroup |
|
| Back to top |
|
|
Kevin Allen
Guest
|
| Posted:
Sun Oct 16, 2005 4:00 pm Post subject:
Re: Problem with Reconcilliation |
|
|
Thanks! That is what I was going to try next. I had to dig up
statements since 1998.
Kevin Allen
John Pollard wrote:
| Quote: | Kevin Allen wrote:
John, thanks for the advice but no luck so far.
I tried unreconiling a transaction but that did not give the
resolve
function.
I then made a copy of my fileset. I then validated the copied
file. It found 1 transaction in the QSD where the splits had
been removed. I
corrected that transaction. There were also 51 errors in the
QEL file
where it said there were payments removed that were not in the
register. Is the QEL file for online payments?
I believe the QEL file is related to online activities, but I do
not know enough to clarify what happened here.
I tried reconciling the account by changing all the reconciled
tranactions to cleared. When I do the reconcilliation it is
off by
the same amount as before when I reconcile to the current
statement. I then tried reconciling to last months statement
and I am still off
by the same amount.
Unless you are finding that Quicken's math is incorrect, I think
this indicates that you have some missing or incorrect
transactions.
I then reconciled to a statement that is from
about 4 years ago. It is still off but by a smaller amount.
Do you think I had 51 transactions deleted somehow?
Could be, but not sure it is helpful to know, especially if
there are no specifics on which transactions were involved.
I have only had one or two problems with old reconciles becoming
unreconciled and, in my recollection, they were solved by simply
re-reconciling all transactions: that is, my data was correct,
the reconciliation totals were wrong. In your case, it sounds
like your data is wrong.
I would start at the beginning (as far back as you can go
anyway) and reconcile until there is a discrepancy; noting what
is wrong, then moving on to subsequent reconciles until you find
another discrepancy. Perhaps a pattern will reveal itself; then
you might go directly to, and fix, the missing/incorrect
transactions, after which one final reconciliation of remaining
transactions might finish the job. If no pattern appears, all I
can think of is to re-reconcile each statement to the present (I
don't like the idea of trying to enter a single adjustment
sometime in the distant past that would make the current balance
correct ... it would mean the balance on most dates would still
be wrong).
|
|
|
| Back to top |
|
|
Kevin Allen
Guest
|
| Posted:
Mon Oct 17, 2005 12:01 am Post subject:
Re: Problem with Reconcilliation/Database corruption |
|
|
John thanks for the suggestion on re-reconciling.
I found two transactions entered as balance adjustments -- which I know
I never entered. Once I deleted those I was able to reconcile without
any other issues.
I checked the copy of the file set I made before the validating the
files set and the balance adjustments were already in the check book
register. Once I deleted them from there I was able to reconcile that
file set too.
I think I should use the copy of the file that I validated and then
super-validated. The validation found 1 record in the QSD file that
lost the splits for the transaction and 51 records in the QEL file that
were removed because there was not a matching transaction. The
super-validation did not find any additional errors. What is the
likelihood that I still have some corruption in my database? The date
for the balance adjustments entered into my check book were both before
the transaction that was corrected by the validation.
I have been having some minor problems when downloading transactions
from my Bank and one of my credit cards. The problem with my bank is
that periodically (every few months) it will download records that I
have already downloaded. My credit card uses web connect. If I use the
default date range it downloads transactions I have already downloaded.
This did not use to happen but has been doing it for about 9-12 months
now.
I also have some Online payments that have a lightening bolt next to
them even after the records have been cleared or reconciled. Most of
the records that have been cleared/downloaded do not have the lightening
bolt. Could this be the records with the problem in the QEL file? Will
Quicken try to make these payments with the lightening bolt again?
I have prefer to keep my data from previous years so I have not done the
year end function since 1995.
I am using Quicken 2004 with Windows XP Home.
Thanks!
Kevin Allen
Kevin Allen wrote:
| Quote: | Thanks! That is what I was going to try next. I had to dig up
statements since 1998.
Kevin Allen
John Pollard wrote:
Kevin Allen wrote:
John, thanks for the advice but no luck so far.
I tried unreconiling a transaction but that did not give the resolve
function.
I then made a copy of my fileset. I then validated the copied file.
It found 1 transaction in the QSD where the splits had been removed. I
corrected that transaction. There were also 51 errors in the QEL file
where it said there were payments removed that were not in the
register. Is the QEL file for online payments?
I believe the QEL file is related to online activities, but I do not
know enough to clarify what happened here.
I tried reconciling the account by changing all the reconciled
tranactions to cleared. When I do the reconcilliation it is off by
the same amount as before when I reconcile to the current statement.
I then tried reconciling to last months statement and I am still off
by the same amount.
Unless you are finding that Quicken's math is incorrect, I think this
indicates that you have some missing or incorrect transactions.
I then reconciled to a statement that is from
about 4 years ago. It is still off but by a smaller amount.
Do you think I had 51 transactions deleted somehow?
Could be, but not sure it is helpful to know, especially if there are
no specifics on which transactions were involved.
I have only had one or two problems with old reconciles becoming
unreconciled and, in my recollection, they were solved by simply
re-reconciling all transactions: that is, my data was correct, the
reconciliation totals were wrong. In your case, it sounds like your
data is wrong.
I would start at the beginning (as far back as you can go anyway) and
reconcile until there is a discrepancy; noting what is wrong, then
moving on to subsequent reconciles until you find another
discrepancy. Perhaps a pattern will reveal itself; then you might go
directly to, and fix, the missing/incorrect transactions, after which
one final reconciliation of remaining transactions might finish the
job. If no pattern appears, all I can think of is to re-reconcile
each statement to the present (I don't like the idea of trying to
enter a single adjustment sometime in the distant past that would make
the current balance correct ... it would mean the balance on most
dates would still be wrong).
|
|
|
| Back to top |
|
|
John Pollard
Guest
|
| Posted:
Mon Oct 17, 2005 4:01 pm Post subject:
Re: Problem with Reconcilliation/Database corruption |
|
|
Kevin Allen wrote:
| Quote: | John thanks for the suggestion on re-reconciling.
I found two transactions entered as balance adjustments --
which I
know I never entered. Once I deleted those I was able to
reconcile
without any other issues.
|
I have never known Quicken to enter an adjustment without
asking, but I suppose stranger things have happened.
| Quote: | I checked the copy of the file set I made before the
validating the
files set and the balance adjustments were already in the
check book
register. Once I deleted them from there I was able to
reconcile that
file set too.
I think I should use the copy of the file that I validated and
then
super-validated.
|
I would.
| Quote: | The validation found 1 record in the QSD file that
lost the splits for the transaction and 51 records in the QEL
file
that were removed because there was not a matching
transaction. The
super-validation did not find any additional errors.
What is the
likelihood that I still have some corruption in my database?
|
I don't know the answer to that.
| Quote: | The date
for the balance adjustments entered into my check book were
both
before the transaction that was corrected by the validation.
I have been having some minor problems when downloading
transactions
from my Bank and one of my credit cards. The problem with my
bank is
that periodically (every few months) it will download records
that I
have already downloaded. My credit card uses web connect. If
I use
the default date range it downloads transactions I have
already
downloaded. This did not use to happen but has been doing it
for
about 9-12 months now.
I also have some Online payments that have a lightening bolt
next to
them even after the records have been cleared or reconciled.
Most of
the records that have been cleared/downloaded do not have the
lightening bolt.
Could this be the records with the problem in the
QEL file?
|
I don't know.
| Quote: | Will Quicken try to make these payments with the
lightening bolt again?
|
I don't know, but I don't think so. I hardly ever use online
payments, but I have done a few online "transfers"; the only one
reconciled so far continues to show the lightening bolt. I have
no idea whether retaining the lightening bolt is according to
design or not; but that transaction has not caused a duplicate
transfer ... its transaction date is back in July of 2005.
| Quote: | I have prefer to keep my data from previous years so I have
not done
the year end function since 1995.
|
I have never done a Start New Year, and do not plan to do so
unless I am somehow forced.
--
John Pollard
First initial underscore Last name at mchsi dot com
Please reply to newsgroup |
|
| Back to top |
|
|
|
|
|
|
FAQ
Memberlist
Register
Profile
Log in to check your private messages
Log in