Home Page link  

QB 2008 - reconciling 3 years worth of registry..

  
Groups | Search | About
User Password
Register Now! Lost Password?

QuickBooks Discussion board - Discussions about the popular financial software by Intuit

 Post an article  get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content  add this group's latest topics to your Google content  YahooMyWeb Yahoo!  Google Google  Windows Live Favorites Windows Live  del.icio.us del.icio.us  digg digg  Add to Netscape Netscape
Subject Author Date
QB 2008 - reconciling 3 years worth of registry.. kimer in NH 05-13-2008
Posted by Laura on May 13, 2008, 8:56 pm
Please log in for more thread options
> 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.


Posted by Haskel LaPort on May 14, 2008, 8:08 am
Please log in for more thread options
>
>> 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.

Yea right, just bank charges.



>



Posted by Laura on May 15, 2008, 7:53 am
Please log in for more thread options
>>
>>> 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.
>
> 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.


Posted by kimer in NH on May 27, 2008, 3:30 pm
Please log in for more thread options
>
>
>
>
>
>
>
.
> >>> 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. =A0So I'd like to use a recent 4/30/200=
8
> >>> statement for my "ending balance" info.... =A0But what do I put in the=
re
> >>> for my "beginning balance"? =A0The 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 ba=
nk
> >> statement.
>
> >> I would start with the 1/08 bank statement. Treat 2005-2007 as one gian=
t
> >> 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 proces=
s
> >> to complete since you are missing bank charges.
>
> > Yea right, =A0just 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.- 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.....

Posted by Laura on May 27, 2008, 9:15 pm
Please log in for more thread options
>
>
>
>
>
>
>
> >>> 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.
>
> > 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.- 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.


Similar ThreadsPosted
Close out / Archive Past years December 21, 2007, 10:56 am
Reconciling CC Account June 14, 2008, 10:17 pm
Reconciling accounts (or not) July 12, 2008, 11:56 am
Reconciling Euro account June 6, 2007, 6:22 am
Reconciling a specific month when other months transactions are in window July 13, 2006, 12:05 pm
Is Qbooks 2006 Worth It? July 17, 2006, 4:47 pm
Re: QB POS Software, worth the price? February 1, 2007, 7:18 pm
QB POS Software, worth the price? January 28, 2007, 3:34 pm
Missing net worth graph January 7, 2008, 1:51 pm
QuickBooks 2008 Remote Applciation Publishing & Windows Server 2008 STD x64 July 7, 2008, 6:23 pm

Contact Us | Privacy Policy
This site is not affiliated with Intuit - makers of Quickbooks and Quicken software
This site is not affiliated with Sage Software - makers of Peachtree accounting software
XML SitemapXML Sitemap