QB 2008 - reconciling 3 years worth of registry..

[kimer in NH]

Hi all -

I have 3 years worth of checkbook registry entries, which of course
include deposits and checks.

None of them have been reconciled in QB (all entires have a clear
"check" column).

My issue is... I do not have those older bank statements to reconcile
against, my oldest is 08/2007. So I'd like to use a recent 4/30/2008
statement for my "ending balance" info.... But what do I put in there
for my "beginning balance"? The very first transaction (in 2005) in
the checkbook registry is an "opening balance" of $5.95 - how do I
modify that $0.00 Quickbooks has in the Reconcile window?...

Completely confused... this is sooo different than Quickbooks... ahhh!!

 

[Haskel LaPort]

Hi all -

I have 3 years worth of checkbook registry entries, which of course
include deposits and checks.

None of them have been reconciled in QB (all entires have a clear
"check" column).

My issue is... I do not have those older bank statements to reconcile
against, my oldest is 08/2007. So I'd like to use a recent 4/30/2008
statement for my "ending balance" info.... But what do I put in there
for my "beginning balance"? The very first transaction (in 2005) in
the checkbook registry is an "opening balance" of $5.95 - how do I
modify that $0.00 Quickbooks has in the Reconcile window?...

Completely confused... this is sooo different than Quickbooks... ahhh!!

I'm assuming you mean Quicken. Lets own up to the truth here. Even if you
had to perform this in Quicken you would have no idea what to do.

Learning how to reconcile cash from newsgroup posts is really not an
option.

 

[Haskel LaPort]

I will give you a hint. I would not be concerned with the open balance of
zero on the bank reconcilation window. It should be zero, after all you
never did a bank reconcilation so all QB knows is zero. I would also start
with the oldest statement not the current version. You will need to plug
assuming that you made some sort of error(s) in entering your data over the
years.

 

[Laura]

Hi all -

I have 3 years worth of checkbook registry entries, which of course
include deposits and checks.

None of them have been reconciled in QB (all entires have a clear
"check" column).

My issue is... I do not have those older bank statements to reconcile
against, my oldest is 08/2007. So I'd like to use a recent 4/30/2008
statement for my "ending balance" info.... But what do I put in there
for my "beginning balance"? The very first transaction (in 2005) in
the checkbook registry is an "opening balance" of $5.95 - how do I
modify that $0.00 Quickbooks has in the Reconcile window?...

Completely confused... this is sooo different than Quickbooks... ahhh!!

Ignore the opening balance. Just plug in the ending balance from the bank
statement.

I would start with the 1/08 bank statement. Treat 2005-2007 as one giant
bank rec. Check the box to hide entries after the ending statement date. Hit
the mark all button to clear everything through 1/31/08. Then manually check
the 2008 bank statements for any 2007 or Jan08 checks/deposits that cleared
in after 1/31/2008 and unclear them in the bank rec. You probably will end
up with an adjustment to get the process to complete since you are missing
bank charges.

 

[Haskel LaPort]

Ignore the opening balance. Just plug in the ending balance from the bank
statement.

I would start with the 1/08 bank statement. Treat 2005-2007 as one giant
bank rec. Check the box to hide entries after the ending statement date.
Hit the mark all button to clear everything through 1/31/08. Then manually
check the 2008 bank statements for any 2007 or Jan08 checks/deposits that
cleared in after 1/31/2008 and unclear them in the bank rec. You probably
will end up with an adjustment to get the process to complete since you
are missing bank charges.

Yea right, just bank charges.

 

[kimer in NH]

I'm assuming you mean Quicken. Lets own up to the truth here. Even if you
had to perform this in Quicken you would  have no idea what to do.

 Learning how to reconcile cash from newsgroup posts is really not an
option.- Hide quoted text -

- Show quoted text -

Nope - quickbooks! (I *wish* it were quicken!)

 

[Haskel LaPort]

message









I'm assuming you mean Quicken. Lets own up to the truth here. Even if you
had to perform this in Quicken you would have no idea what to do.

Learning how to reconcile cash from newsgroup posts is really not an
option.- Hide quoted text -

- Show quoted text -

Nope - quickbooks! (I *wish* it were quicken!)


Then why is QuickBooks so different than QuickBooks? Now I'm confused.

 

[Laura]

Yea right, just bank charges.

I'm sure there are lots of other missing stuff. But for a closed year, who
cares? Just post the adjustment and move forward.

 

[kimer in NH]

I'm sure there are lots of other missing stuff. But for a closed year, who
cares? Just post the adjustment and move forward.- Hide quoted text -

- Show quoted text -

Yea, but the adjustment is about $2500... and I'm pretty sure it
happened in the last 6 months or so... just cannot find the missing
transaction.... ugh.....

 

[Laura]

I'm sure there are lots of other missing stuff. But for a closed year, who
cares? Just post the adjustment and move forward.- Hide quoted text -

- Show quoted text -

Yea, but the adjustment is about $2500... and I'm pretty sure it
happened in the last 6 months or so... just cannot find the missing
transaction.... ugh.....

*******
If you are sure that the adjustment is within the past year then an
alternative approach would be to treat 2005 & 2006 as one bank rec. Then
start with 1/1/07 and do the 2007 bank recs month by month.

 

[Gil Faver]

Yea right, just bank charges.

yea, right. You are not Allan Martin.

 

[Haskel LaPort]

yea, right. You are not Allan Martin.

I could never fill the man's shoes.