Home Page link  

How can Quicken help me to match the online balance?

 

Quicken Personal Finance Discussions - Quicken - personal finance software discussions

 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
How can Quicken help me to match the online balance? PeaceHere 02-08-2008
Posted by Han on February 8, 2008, 8:49 pm
Please log in for more thread options
$U12.61978@trnddc06:

>
>>>I'm not familiar with the reconciliation feature of quicken. Can it
>>>help me figure out where the mismatch occurred?
>
>
> I've been banking for almost fifty years, and not once has my bank ever
> made a mistake. Whenever my records have deviated from theirs, mine
> were wrong.
>
> Just make an adjusting entry to bring things back into balance and from
> now on use the reconcile function regularly.
>
> One person's opinion,
> Doug
>
Like JimH, I have found banks make errors. Why, way back at the
beginning of ATMs in the late '70s, my bank shorted me $20 when I got
cash (or $10 - don't want to be pinned down on it). I did complain, and
eventually was credited the amount due to me.

It doesn't happen often, but it does. That $10 or $20 is worth a lot
more now.
--
Best regards
Han
email address is invalid

Posted by Laura on February 8, 2008, 9:22 am
Please log in for more thread options
This has happened to me several times over the past few years. Mysteriously,
transactions get dropped from quicken. I have not found any easy way to
resolve this. I end up going back several months at a time checking the bank
balance against my paper statements until I find the last month that they
match. Then I have to check each transaction going forward to find the
missing entries.

If the amount is minimal you could also just use the reconcile tool, clear
all transactions and let Quicken post an adjustment to force the bank
balances to match. That certainly would save you a lot of time and energy if
you have not reconciled the account for a while. I do mine each time I
download transactions to make sure that the files are still in synch with
the bank.

> I've have automatic download of my bank's transaction for many
> years. Unfortunately, for unknown reasons, the online balance and
> the ending balance of the bank account in quicken don't match with
> each other. Before I launch the laborious process of figuring out
> what transactions are missing or wrong, but I'd like to begin by
> finding out whether there is an easier way.
>
> I'm thinking of taking out my paper statement for each month, and
> manually enter them in the memo area of blank transaction with the
> correct date. This way, I can compare the bank's balance with the
> registry balance. Still, it's a lot of work, because the discrepancy
> of the 2 balance has been there fore a long time.
>
> I'm not familiar with the reconciliation feature of quicken. Can it
> help me figure out where the mismatch occurred?
>
> I'm using quicken home and business 2005.


Posted by John Pollard on February 8, 2008, 9:30 am
Please log in for more thread options
PeaceHere@gmail.com wrote:
> I've have automatic download of my bank's transaction for many
> years. Unfortunately, for unknown reasons, the online
> balance and
> the ending balance of the bank account in quicken don't match
> with
> each other. Before I launch the laborious process of
> figuring out
> what transactions are missing or wrong, but I'd like to begin
> by
> finding out whether there is an easier way.
>
> I'm thinking of taking out my paper statement for each month,
> and
> manually enter them in the memo area of blank transaction with
> the
> correct date. This way, I can compare the bank's balance
> with the
> registry balance. Still, it's a lot of work, because the
> discrepancy
> of the 2 balance has been there fore a long time.
>
> I'm not familiar with the reconciliation feature of quicken.
> Can it
> help me figure out where the mismatch occurred?
>
> I'm using quicken home and business 2005.

In addition to what the others have said: do not assume that the
"Online Balance" should agree with any other balance in Quicken.

The Online Balance is a number supplied by your financial
institution during a download, so it is never more accurate than
the last time you downloaded.

But even at the instant you download, the Online Balance may not
equal your Quicken "current balance" or "ending balance". If
your financial institution "pends" some of your transactions (as
some fi's do), and does not download those transactions while
they are pended, but does subtract their amounts from your
Online Balance, your Online Balance will not equal any Quicken
computed balance (unless you choose to manually enter those
pended transactions).

One more reason not to reconcile to an online balance.

[I'd like to see two downloaded balances: "Cleared Balance" and
"Available Balance".]

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



Posted by Han on February 8, 2008, 8:50 pm
Please log in for more thread options

> But even at the instant you download, the Online Balance may not
> equal your Quicken "current balance" or "ending balance". If
> your financial institution "pends" some of your transactions (as
> some fi's do), and does not download those transactions while
> they are pended, but does subtract their amounts from your
> Online Balance, your Online Balance will not equal any Quicken
> computed balance (unless you choose to manually enter those
> pended transactions).
>

EXACTLY!

--
Best regards
Han
email address is invalid

Posted by Oilcan on February 9, 2008, 1:44 am
Please log in for more thread options
John made a good point. One of my banks will download a balance that might
have not cleared (a paycheck deposit). I really has cleared by the banks
standards and I can transact using the funds, but the download (my paycheck)
will not be reflected until the end of the day.

What you need to find is a day that you agree with the banks balance and
reconcile towards it. You might have to make an adjusting entry to get it
in sync (hopefully not too much).

I reconcile to online balances and generally do not have a problem as I can
quickly id the difference and it will usually clear up the next day with
another download that will correct the balance.

Oilcan
> PeaceHere@gmail.com wrote:
>> I've have automatic download of my bank's transaction for many
>> years. Unfortunately, for unknown reasons, the online balance and
>> the ending balance of the bank account in quicken don't match with
>> each other. Before I launch the laborious process of figuring out
>> what transactions are missing or wrong, but I'd like to begin by
>> finding out whether there is an easier way.
>>
>> I'm thinking of taking out my paper statement for each month, and
>> manually enter them in the memo area of blank transaction with the
>> correct date. This way, I can compare the bank's balance with the
>> registry balance. Still, it's a lot of work, because the discrepancy
>> of the 2 balance has been there fore a long time.
>>
>> I'm not familiar with the reconciliation feature of quicken. Can it
>> help me figure out where the mismatch occurred?
>>
>> I'm using quicken home and business 2005.
>
> In addition to what the others have said: do not assume that the "Online
> Balance" should agree with any other balance in Quicken.
>
> The Online Balance is a number supplied by your financial institution
> during a download, so it is never more accurate than the last time you
> downloaded.
>
> But even at the instant you download, the Online Balance may not equal
> your Quicken "current balance" or "ending balance". If your financial
> institution "pends" some of your transactions (as some fi's do), and does
> not download those transactions while they are pended, but does subtract
> their amounts from your Online Balance, your Online Balance will not equal
> any Quicken computed balance (unless you choose to manually enter those
> pended transactions).
>
> One more reason not to reconcile to an online balance.
>
> [I'd like to see two downloaded balances: "Cleared Balance" and "Available
> Balance".]
>
> --
> John Pollard
> First initial underscore Last name at mchsi dot com
> Please reply to newsgroup
>


Similar ThreadsPosted
Repairing Match with Online Security? January 25, 2008, 11:19 am
auto setup of 401k - download doesn't match online June 2, 2006, 12:47 pm
Online Banking - Cash Balance August 17, 2006, 4:53 pm
balance forecast and low balance warning weirdness February 10, 2007, 7:11 pm
Quicken Made a "Balance Adjustment" ??? July 10, 2007, 10:05 am
New User on Quicken: Credit Card shows $0 Balance and no transactions September 8, 2007, 3:41 pm
Quicken 2008 - show net worth or ending balance in account bar question December 5, 2007, 9:27 pm
Quicken 2007, Single Mutual Fund, Cash Balance, Scheduled Trans June 13, 2007, 1:05 am
401(k) employer match September 1, 2007, 12:31 pm
Employer Match -- Uncategorized March 1, 2008, 8:08 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