As featured in The Wall Street Journal, Money Magazine, and more!
     

Reader Question: Ignoring Reconciliation in Quicken

This article was written by in Software. 17 comments.


Here’s a question about reconciliation and running reports in Quicken from a reader:

I have quicken and would like to use it to run reports (net worth, where I’m spending, etc.). But it seems to be forcing me to do “reconciliation” which from what little I understand is to make sure there aren’t mistakes that the banks are making etc. I’ve connected to my accounts online, but the totals for those accounts in Quicken don’t match what they should be.

I usually just review my bank statements to check for mistakes, and reconciliation seems like way to much work. Can Quicken be used in the way I’m thinking, or am I way off base?

Quicken: Remove Automatic ReconciliationBefore you run any reports, you should do what you can to make sure all the data are accurate, and that’s what reconciliation is for. The software doesn’t force you to reconcile, but you my have set up Quicken at some point to automatically reconcile each time you download your activity from your bank. If that’s the case, you can turn that off by performing a manual reconciliation of each account and turn off the option for automatic reconciliation.

Click the image thumbnail to the left to see where this option is in Quicken 2007 Home & Business.

Quicken reportsPerhaps this is because part of my day-job responsibilities involve working with bank-to-ledger reconciliations for a company with thousands of bank accounts, but ensuring the validity of your data is important before running any net worth or spending reports. Reconciliation catches mistakes on the bank’s side (improper fees, incorrect amounts, extra or missing transactions) and well as mistakes on your own side.

Whether or not you choose to reconcile, Quicken can be used to run all kinds of reports, but the reports will only be as accurate as the information in the software. In the menu bar, under Reports, select “Reports & Graphs Center” to see all the different types of reports you can run. The standard reports are displayed on the left of the resulting window, and any custom reports you have saved are on the right. Click on the image thumbnail for an example from my personal Quicken file.

Published or updated July 9, 2007. If you enjoyed this article, subscribe to the RSS feed or receive daily emails. Follow @ConsumerismComm on Twitter and visit our Facebook page for more updates.

Email Email Print Print
avatar
Points: ♦127,490
Rank: Platinum
About the author

Luke Landes, also known as Flexo, is the founder of Consumerism Commentary. He has been blogging and writing for the internet since 1995 and has been building online communities since 1991. Find out more about him and follow Luke Landes on Twitter. View all articles by .

{ 7 comments… read them below or add one }

avatar mapgirl

Reconciliation shouldn’t be too hard, but auto matching transactions doesn’t work that well, neither does manual matching. Sometimes I just have delete the downloaded transaction and go straight to the recon screen. Typical example is that I get three checks, I like to make one entry for each check vs a split transaction, but the bank gives me one total deposit item. The account will still balance.

If your accounts AREN’T balancing, it’s a problem and you should track that down. Perhaps it’s fraud. Perhaps you bought something you don’t remember, or your joint account holder is trying to hide something from you.

Reply to this comment

avatar tinyhands

Question back to the reader: Why don’t the balances match?

If you know, then you can put in an adjusting entry to reconcile them. If you don’t know, find out.

Reply to this comment

avatar Valerie

There are two ways to reconcile in Quicken…either reconciling to your hard copy statement, or to the balance reported when you down load.

THE DOWNLOAD BALANCE WILL NEVER THE SAME AS THE BALANCE SHOWN ON YOUR STATEMENT. This is due to the fact that the download balance is as of the day of the download, and is not the same as the closing date of your statement.

Also, bear in mind that you can’t go back and forth between statement reconciliations and download reconciliations. Once you’ve reconciled to the download balance, you can’t go back to statement reconciliations. So choose one method and stick to it.

Reply to this comment

avatar Anonymous

I’m actually scared of quicken now, and I’ve switched to KMyMoney. It’s a lot simpler, and it doesn’t force me to upgrade when I don’t want to. I don’t think that business users will find it very useful, but for my home use it’s great.

Reply to this comment

avatar Vishal

I’m a student trying to use this to figure out my expenses. Now you mentioned that when you download your account information, the balances will never be the same. My question is, would it eventually “catch-up” and be the same after you download multiple times? Is there a way to have the same balances?

Reply to this comment

avatar mapgirl

Vishal,

Reconciling ‘never being the same’ refers to switching back and forth between online and paper statements. It is actually possible to have it be the same, if you practice some earnestness and delete your duplicated transactions. There are days when even online reconciliation is off for me because I forgot this-and-that-transaction-of-87-cents. Have no fear, it will work if you pay attention to what you are doing.

Reply to this comment

avatar LD

I prefer paper statement reconciliation but decided to try online. It looked wrong and I cancelled it, didn’t complete the reconciliation. But now, quicken won’t let me go back to statement reconciliation, the beginning and ending balance are not correct and can’t be changed. What can I do? the online reconciliation is jacked up and doesn’t show the correct info!

Help!

Reply to this comment

Leave a Comment

Connect with Facebook

Note: Use your name or a unique handle, not the name of a website or business. No deep links or business URLs are allowed. Spam, including promotional linking to a company website, will be deleted. By submitting your comment you are agreeing to these terms and conditions.

Notify me of followup comments via e-mail. You can also subscribe without commenting.

Previous post:

Next post: