Home Page link  

Reconcile method

 

Quicken Personal Finance Discussions - Quicken - personal finance software discussions 

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
Reconcile method Capt. Tuttle 11-09-2007
Posted by Laura on November 10, 2007, 5:23 pm
Please log in for more thread options
> Laura wrote:
> > That said, how do you get a difference of several hundred dollars?
>
> I changed from on line balance to paper statement.

That difference is usually due to timing issues but certainly not
necessarily an error.

For example, the paper statement dated 10/31/07 has a balance of 1000. My
online balance on 11/5/07 is 1500 because of a deposit on 11/1/07.

If you are using the paper statement to do the reconciliation then you enter
a 10/31/07 date and a value of 1000. As long as you select the proper
transactions to be marked cleared then your reconciliation is correct.

Just because you don't match the online balance does not mean that there is
an error. The only time the paper and online balance will match will be the
day of the paper statement providing there are no pending transactions
showing on the website. Any other difference is a timing issue but again, as
long as you can complete the reconciliation then everything is correct. Just
ignore the difference.


Posted by John Pollard on November 10, 2007, 11:38 am
Please log in for more thread options
Capt. Tuttle wrote:
> Yes, there is a radio button to do that.

> When you change from one
> method to the other you get a warning that if you change you
> may screw up.

I don't get a warning when I change from "Paper Statement" to
"Online Balance"; only when I change from "Online Balance" to
"Paper Statement". My experience also agrees with Quicken Help
on the subject.

> I screwed up and changed.

> I want to know now if there is any way to change back without
> being several hundred dollars off.

It's not really clear what "several hundred dollars off" refers
to. If you change from reconciling to a paper statement to
reconciling to an online balance, there is likely to be an
inititial difference; the online balance is more current than
your last printed statement balance.

If you're going to have problems, you should have had them when
you converted from Online Balance to Paper Statement.

> That is what happens when I change the
> radio button you mention.

> Maybe I should just include the mistake of hundreds of dollars
> and go
> from there, but that may just add to the problem rather than
> fix it.

Again, it's not clear what the "mistake" really is.

I can tell you that if your financial institutions "pends" some
transactions, does not download "pended" transactions (while
they're pended), but does include "pended" transactions in the
online balance; you will not be able to successfully reconcile
to that online balance while there are pended transactions.

> The thought entered my mind to delete the account and start
> over. That
> is not an easy solution or one I want to consider.

As a last resort, I think you should always be able to
unreconcile all the transactions in the account (using
Find/Replace), then re-reconcile once up through the most
current known reconcile balance.

--
John Pollard
First initial underscore Last name at mchsi dot com
Please reply to newsgroup



Posted by Capt. Tuttle on November 10, 2007, 5:24 pm
Please log in for more thread options
John Pollard wrote:

> Capt. Tuttle wrote:
>
>>Yes, there is a radio button to do that.
>
>
>>When you change from one
>>method to the other you get a warning that if you change you
>>may screw up.
>
>
> I don't get a warning when I change from "Paper Statement" to
> "Online Balance"; only when I change from "Online Balance" to
> "Paper Statement". My experience also agrees with Quicken Help
> on the subject.
That's exactly what I did.

>
>
>>I screwed up and changed.
>
>
>>I want to know now if there is any way to change back without
>>being several hundred dollars off.
>
>
> It's not really clear what "several hundred dollars off" refers
> to. If you change from reconciling to a paper statement to
> reconciling to an online balance, there is likely to be an
> inititial difference; the online balance is more current than
> your last printed statement balance.
>
> If you're going to have problems, you should have had them when
> you converted from Online Balance to Paper Statement.
That is when I had the problem.

>
>
>>That is what happens when I change the
>>radio button you mention.
>
>
>>Maybe I should just include the mistake of hundreds of dollars
>>and go
>>from there, but that may just add to the problem rather than
>>fix it.
>
>
> Again, it's not clear what the "mistake" really is.
The "mistake" was going from online balance to paper statement.

>
> I can tell you that if your financial institutions "pends" some
> transactions, does not download "pended" transactions (while
> they're pended), but does include "pended" transactions in the
> online balance; you will not be able to successfully reconcile
> to that online balance while there are pended transactions.
>
>
>>The thought entered my mind to delete the account and start
>>over. That
>>is not an easy solution or one I want to consider.
>
>
> As a last resort, I think you should always be able to
> unreconcile all the transactions in the account (using
> Find/Replace), then re-reconcile once up through the most
> current known reconcile balance.
>

Thanks. I'll give that a try. If it doesn't work I can always go back
through and be at the same spot I am now.

Posted by XS11E on November 11, 2007, 11:25 am
Please log in for more thread options

> I know I've messed up, but thought maybe someone here could help.
> Is there any easy way to change the method to reconcile from paper
> statement to on line balance? I don't remember now, but I think I
> was using on line balance at first, but for some stupid reason
> changed it. Yes, I did see the warning about doing that.
> If I try now to go from paper statement to on line balance there
> is a huge difference.
> Is there any hope?
> Thanks for any help you can give.

Can you restore an earlier backup that was done before you made the
change? You'll have to enter the more recent transactions but that
shouldn't be a big probem, I hope.



--
XS11E, Killing all posts from Google Groups
The Usenet Improvement Project:
http://improve-usenet.org

Similar ThreadsPosted
"Upgrading" investment account - best method? May 22, 2006, 2:48 pm
Reconcile goof up February 24, 2007, 7:34 pm
Reconcile data January 18, 2008, 10:02 pm
how to reconcile old accounts May 24, 2006, 7:02 am
how to (re)reconcile an account November 14, 2008, 8:21 pm
Reconcile/Download problem January 13, 2007, 9:50 am
How do I reconcile transfers to other accounts? April 6, 2007, 6:03 pm
Reconcile error after cleanup August 12, 2007, 1:16 am
Import transactions without reconcile September 23, 2007, 9:16 pm
Auto Reconcile Woes April 16, 2006, 9:46 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