And more efficiently. Use Web Connect to automatically launch Quicken. Getting Started. Just add your Wells Fargo Online accounts to your Quicken software to connect. Set-Up; Add Accounts; Transactions; Reconcile; Transfers; Using Bill Pay. Enter date to pay and amount, then click Update/Send. The One Step. QuickBooks for Mac 2016. User’s Guide. By E Lisette Gerald-Yamasaki and the QuickBooks for Mac team. Changing an account’s color 55 Moving a transaction to a different. Reconciling your accounts 168 Before you begin 168. Iv QuickBooks for Mac 2016 User’s Guide.
At the beginning of May I received my April statement and reconciled w/o any problem. When I received my May statement (early June) I attempted to reconcile the account but the beginning balance was about $4,000 too high! What could possibly cause this? I KNOW the opening balance and closing balance in April were correct, how could the opening balance for May be anything other than the closing balance for April? HELP, please? - XS11E, Killing all posts from Google Groups The Usenet Improvement Project: Jim H 10/6/2010, 9:31 น. XS11E wrote: At the beginning of May I received my April statement and reconciled w/o any problem.
When I received my May statement (early June) I attempted to reconcile the account but the beginning balance was about $4,000 too high! What could possibly cause this? I KNOW the opening balance and closing balance in April were correcthow could the opening balance for May be anything other than the closing balance for April? HELP, please? When I've had this, it has been because a reconciled transaction was modified or deleted. White 10/6/2010, 11:15 น. If the ending balance reconciles, then the opening balance is of only academic interest.
If the ending balance does NOT reconcile, then you need to identify the non-reconciling item, even if it occurred in some earlier period. Quite often, a check or deposit that is outstanding on April 30 will clear in May.
Note that a reconciliation is not really for 'a month' or other PERIOD of time, but AS OF a particular POINT in time, usually the close business on the last day of a month. Quicken's reconciliation screens sometimes confuse me. The lists of Payments and Checks and of Deposits are usually all or mostly shown as BOLD. To make it easier on myself, I click Mark All - and then Mark All a second time - to UNbold them all.
And then I click each one as I compare the cleared items from my checkbook (yes, I still also keep a manual checkbook) or Quicken check register to the statement. If the 'Difference' is not zero when I finish this exercise, then I have more tracking and comparing to do. If I forgot to reconcile last month, then the screen that opens when I click Reconcile might show an 'Opening Balance' that was actually from the last time that I did reconcile - maybe a few months ago. That doesn't matter, so long as all the reconciling items match the statements I've received since then. Only the ENDING balance matters. If all else fails, go back and reconcile LAST month-end again.
I know all this is too elementary for you, XS11E - but we all have to go through these steps - again - sometimes.;^ RC - R. White, CPA San Marcos, TX (Retired. No longer licensed to practice public accounting.) Microsoft Windows MVP (Using Quicken Deluxe 2010 and Windows Live Mail in Win7 x64) 'XS11E' wrote in message news:[email protected]. At the beginning of May I received my April statement and reconciled w/o any problem. When I received my May statement (early June) I attempted to reconcile the account but the beginning balance was about $4,000 too high!
What could possibly cause this? I KNOW the opening balance and closing balance in April were correcthow could the opening balance for May be anything other than the closing balance for April? HELP, please? - XS11E, Killing all posts from Google Groups Andrew 11/6/2010, 4:52 น.
Absolutely - start looking! This has happened to me multiple times over the past decade of using Q. Obviously, I don't TRY to do this on purpose, so I am not sure how it happens, but I think it is do to sometimes copying and pasting (or cut and pasting!) transactions that have already been marked as reconciled. (This is not meant to start a 'me too' thread; it's just that this is very very likely the cause of your problem.) - - Regards -Andrew Ralph Kramden 11/6/2010, 6:05 น. XS11E wrote: At the beginning of May I received my April statement and reconciled w/o any problem. When I received my May statement (early June) I attempted to reconcile the account but the beginning balance was about $4,000 too high! What could possibly cause this?
I KNOW the opening balance and closing balance in April were correcthow could the opening balance for May be anything other than the closing balance for April? The opening balance is the net amount of all transactions in the account with a cleared status ('Clr') of 'R' - at the time you initiate the reconcile. Anything that changes that net amount will change your opening balance.
John Pollard news:///alt.comp.software.financial.quicken Your source of user-to-user Quicken help Jerry 11/6/2010, 10:38 น. 'XS11E' wrote in message news:[email protected]. At the beginning of May I received my April statement and reconciled w/o any problem. When I received my May statement (early June) I attempted to reconcile the account but the beginning balance was about $4,000 too high! What could possibly cause this?
I KNOW the opening balance and closing balance in April were correcthow could the opening balance for May be anything other than the closing balance for April? HELP, please? I often copy-and-paste existing reconciled transactions then clear the R status and set the date to today. Could you possibly have done the same but forgotten to change the date and clear the R? If so, sorting the register by order entered should flush out the culprit(s). Jerry XS11E 11/6/2010, 11:03 น.
White' wrote: If the ending balance reconciles, then the opening balance is of only academic interest. If the ending balance does NOT reconcile, then you need to identify the non-reconciling item, even if it occurred in some earlier period.
It didn't reconcile, it's off by the same amount as the opening balance. Quite often, a check or deposit that is outstanding on April 30 will clear in May. I really didn't write any $4,000 checks last month. If all else fails, go back and reconcile LAST month-end again.
Last month reconciled correctly as stated in my post and I did go back and reconcile again to no avail. XS11E, Killing all posts from Google Groups The Usenet Improvement Project: XS11E 11/6/2010, 11:04 น. 'XS11E' wrote in message news:[email protected]. At the beginning of May I received my April statement and reconciled w/o any problem. When I received my May statement (early June) I attempted to reconcile the account but the beginning balance was about $4,000 too high!
What could possibly cause this? I KNOW the opening balance and closing balance in April were correcthow could the opening balance for May be anything other than the closing balance for April? HELP, please? Here's a cumbersome method that should work if all else fails. If a very old transaction has been deleted it might be your only hope. Restore a known-to-be-correct backup copy of your DB on a laptop and compare the current and backup registers to find the line(s) at which the balance differs. Printing the backup register or flipping between the two DBs will also work if you can't find a 2nd computer.
Jerry XS11E 11/6/2010, 11:57 น. XS11E wrote: At the beginning of May I received my April statement and reconciled w/o any problem.
When I received my May statement (early June) I attempted to reconcile the account but the beginning balance was about $4,000 too high! EDIT: error, the beginning balance was $17,414.86 too high! What could possibly cause this? Somehow, during May, Quicken downloaded hundreds of duplicate transactions. I had earlier started a thread that I was unable to match transactions and never received a usable answer but the problem seems to date from my change from UBS to RBC for my checking/credit card accounts? This time I wasn't even given the chance to match, they were just entered into the register somehow??????? I have duplicates of many deposits, checks and credit card transactions going back many months into last year, the number is into the hundreds.
I see no fix other than to load a backup from April and start again??? - XS11E, Killing all posts from Google Groups The Usenet Improvement Project: XS11E 11/6/2010, 14:22 น. XS11E wrote: Found it! Somehow, during May, Quicken downloaded hundreds of duplicate transactions. I had earlier started a thread that I was unable to match transactions and never received a usable answer but the problem seems to date from my change from UBS to RBC for my checking/credit card accounts?
This time I wasn't even given the chance to match, they were just entered into the register somehow??????? I have duplicates of many deposits, checks and credit card transactions going back many months into last year, the number is into the hundreds. I see no fix other than to load a backup from April and start again??? And that didn't work. I reloaded the current and manually deleted several hundred duplicated items, still need to check to be sure there are no more. How can I change the start date on the reconcile screen to go back to a previous month?
- XS11E, Killing all posts from Google Groups The Usenet Improvement Project: XS11E 15/6/2010, 15:03 น. XS11E wrote: XS11E wrote: How can I change the start date on the reconcile screen to go back to a previous month?
Can anyone answer this? I recall doing it once but I can't remember how. You already got the answer you need (presuming you're using a version of Quicken later than.about. Q2002. And following the answer you got, will allow you to re-reconcile to your heart's content (the 'start date' doesn't matter - though the 'ending date' does).
John Pollard news:///alt.comp.software.financial.quicken Your source of user-to-user Quicken help XS11E 16/6/2010, 10:24 น. 'John Pollard' wrote: XS11E wrote: XS11E wrote: How can I change the start date on the reconcile screen to go back to a previous month? Can anyone answer this? I recall doing it once but I can't remember how. You already got the answer you need (presuming you're using a version of Quicken later than.about. Q2002. I give up, where?
And it's Quicken 2010. XS11E, Killing all posts from Google Groups The Usenet Improvement Project: XS11E 18/6/2010, 12:22 น. 'John Pollard' wrote: XS11E wrote: XS11E wrote: How can I change the start date on the reconcile screen to go back to a previous month? Can anyone answer this? I recall doing it once but I can't remember how.
You already got the answer you need (presuming you're using a version of Quicken later than.about. Q2002. And following the answer you got, will allow you to re-reconcile to your heart's content (the 'start date' doesn't matter - though the 'ending date' does). I haven't seen an answer, I've reloaded this entire discussion and can't find any answer and I very much NEED to get this fixed, my alternative is going to have to be to discontinue using Quicken if I can't reconcile the account. XS11E, Killing all posts from Google Groups The Usenet Improvement Project: Bob Wang 18/6/2010, 13:16 น. For some reason, I'm reminded of this scene from 'Blazing Saddles': the Johnsons load their guns and point them at Bart. Bart then points his own pistol at his head Bart: low voice Hold it!
Next man makes a move, the nigger gets it! Olson Johnson: Hold it, men. He's not bluffing. Sam Johnson: Listen to him, men.
He's just crazy enough to do it! Bart: low voice Drop it! Or I swear I'll blow this nigger's head all over this town! Bart: high-pitched voice Oh, lo'dy, lo'd, he's desp'it!
Do what he sayyyy, do what he sayyyy! Townspeople drop their guns. Bart jams the gun into his neck and drags himself through the crowd towards the station Harriet Johnson: Isn't anybody going to help that poor man? Sam Johnson: Hush, Harriet! That's a sure way to get him killed! Bart: high-pitched voice Oooh!
He'p me, he'p me! Somebody he'p me! Bart: low voice Shut up! Bart places his hand over his own mouth, then drags himself through the door into his office Bart: Ooh, baby, you are so talented! looks into the camera Bart: And they are so.dumb.!
XS11E 18/6/2010, 13:42 น. You have had several answers suggested to you.
When I moved over from MS Money I had several similar unbalanced situations while getting into production. I thought you had resolved the problem when you said you had found it.
If you are having difficulties at this point I would 1) drop back to a backup where the problem does not show an error. You said it balanced a month ago (probably now 2 months). Restore that backup and note the account balance at the time it was balanced. Then go to the current file and verify that the account balance on the same day (and transaction) is the same. If it is not then you need to look at what happened previous to that day, otherwise you are limited to items since that day. I had one case where I simply allowed it to put a transaction so I could balance.
I did not want to continue searching for the less than a dollar difference I feel your frustration and hope you are able to find it. 'XS11E' wrote in message news:[email protected]. Ralph Kramden 18/6/2010, 14:32 น.
XS11E wrote: 'John Pollard' wrote: XS11E wrote: XS11E wrote: How can I change the start date on the reconcile screen to go back to a previous month? Can anyone answer this?
I recall doing it once but I can't remember how. You already got the answer you need (presuming you're using a version of Quicken later than.about. Q2002. And following the answer you got, will allow you to re-reconcile to your heart's content (the 'start date' doesn't matter - though the 'ending date' does). WHAT ANSWER?
I haven't seen an answer, I've reloaded this entire discussion and can't find any answer and I very much NEED to get this fixed, my alternative is going to have to be to discontinue using Quicken if I can't reconcile the account. In effect, you're asking the wrong question.
You don't change the start date to go back to a previous reconcile. You change the net amount of reconciled transactions. Which I pointed out on June 11 in this thread. And reminded again June 15. Which you quoted when you submitted this post I'm replying to. John Pollard news:///alt.comp.software.financial.quicken Your source of user-to-user Quicken help Laura 18/6/2010, 14:33 น.
XS11E wrote: 'John Pollard' wrote: XS11E wrote: XS11E wrote: How can I change the start date on the reconcile screen to go back to a previous month? Can anyone answer this? I recall doing it once but I can't remember how. You already got the answer you need (presuming you're using a version of Quicken later than.about.
Q2002. And following the answer you got, will allow you to re-reconcile to your heart's content (the 'start date' doesn't matter - though the 'ending date' does). WHAT ANSWER? I haven't seen an answer, I've reloaded this entire discussion and can't find any answer and I very much NEED to get this fixed, my alternative is going to have to be to discontinue using Quicken if I can't reconcile the account. I've had this happen a few times in the past.
Usually it was caused by a duplicate transaction or a mismatching of a downloaded transaction. I just pull up the bank account online and work my way backwards month by month until I find where the balance in Q no longer matches the balance on the website. Then I narrow it down within that month until I find the transaction(s) causing the problem. In my case, I narrowed it down to my being lazy where I hit the 'accept all transaction' blindly. I no longer do that and only occasionally get duplicate transactions. XS11E 18/6/2010, 17:12 น.
Laura wrote: I've had this happen a few times in the past. Usually it was caused by a duplicate transaction or a mismatching of a downloaded transaction. Thanks, that's the usual problem but I'm $17,414.86 too high which eliminates a single transaction.
I narrowed it down to my being lazy where I hit the 'accept all transaction' blindly. I no longer do that and only occasionally get duplicate transactions. I don't do that but that HAS to be what happened, I've found literally hundreds of duplicate transactions, my only fix has been to delete Quicken, delete all related files, registry entries, etc.
And then re- install. I found I could balance if I restored my February backup but not if I restored a later one. I'm now manually entering all the transactions from February 28 forward and it's pretty slow. XS11E, Killing all posts from Google Groups The Usenet Improvement Project: XS11E 18/6/2010, 17:20 น. 'John Pollard' wrote: In effect, you're asking the wrong question.
You don't change the start date to go back to a previous reconcile. You change the net amount of reconciled transactions. Which I pointed out on June 11 in this thread. And reminded again June 15. Which you quoted when you submitted this post I'm replying to.
Those were non-working answers, I had to remove all reconciled transactions from Quicken, the easiest way was to delete it and all related files, registry entries, etc. And then re-install and restore backups. Strangely enough, only the February backup allowed me to reconcile, any later gave me similar errors despite the fact that April balanced????? So now I'm manually entering the entries from February forward, very tedious. I'll probably never know WHY it downloaded and accepted hundreds of duplicate transactions going back to November of last year (the dupes do NOT show up in the February or earlier backups) and reconciled all of them even though it balanced at the end of April. I have to believe that April would be OK to restore but I'm unable to find that backup and that's another mystery I may never solve. XS11E, Killing all posts from Google Groups The Usenet Improvement Project: Ralph Kramden 18/6/2010, 19:25 น.
XS11E wrote: 'John Pollard' wrote: In effect, you're asking the wrong question. You don't change the start date to go back to a previous reconcile. You change the net amount of reconciled transactions. Which I pointed out on June 11 in this thread. And reminded again June 15. Which you quoted when you submitted this post I'm replying to.
Those were non-working answers, Non-working answers, my eye. You clearly still don't understand anything about how Quicken reconcile works. When you receive an answer and can't accept it (or refuse to ask for clarification).
The problem has become your personal problem. You have exacerbated (if not created) your own problem. I have, on occasion, had to re-reconcile, using the same logic I provided you. And done so with no difficulty. I will no longer attempt to help you.
Please don't waste any one else's time here with your false claim. John Pollard news:///alt.comp.software.financial.quicken Your source of user-to-user Quicken help Laura 19/6/2010, 7:24 น. XS11E wrote: Laura wrote: I've had this happen a few times in the past. Usually it was caused by a duplicate transaction or a mismatching of a downloaded transaction. Thanks, that's the usual problem but I'm $17,414.86 too high which eliminates a single transaction. I narrowed it down to my being lazy where I hit the 'accept all transaction' blindly.
I no longer do that and only occasionally get duplicate transactions. I don't do that but that HAS to be what happened, I've found literally hundreds of duplicate transactions, my only fix has been to delete Quicken, delete all related files, registry entries, etc. And then re- install. I found I could balance if I restored my February backup but not if I restored a later one.
I'm now manually entering all the transactions from February 28 forward and it's pretty slow. Hundreds of duplicates sounds like whatever file keeps track of what has been downloaded from the bank either became corrupt or deleted. Your bank then downloaded all transactions back to the beginning of their download window. With you manually entering the transactions might cause those transactions to be downloaded again the next time you do a OSU.
I suggest you make a backup prior to your next update just to be safe. Hopefully I am wrong.good luck. Mike Blake-Knox 19/6/2010, 7:29 น.
In article, Xs11E wrote: XS11E wrote: How can I change the start date on the reconcile screen to go back to a previous month? Can anyone answer this? I recall doing it once but I can't remember how. The problem is that the start date of a reconciliation doesn't have the slightest effect on the opening balance as Quicken calculates the opening balance by summing the values of all the reconciled transactions. Yes, it's not logical to have a reconciliation start date that's ignored during reconciliation. Unfortunately this isn't the only place where irrelevant informnation is collected while starting a reconciliation.
(For instance, when you start a credit card reconciliation, you are asked for the total amount of charges and the total amount of credits during the period. These two values don't seem to affect reconciliation at all - For years, I've been using 0 for both when reconciling credit card accounts!) Anyway, I have a process that I use when I run across a reconciliation opening balance problem. I run Quicken using one of my backup files that doesn't show the problem. I export a register report and open it in Excel.
I close the old file in Quicken and open the current one. I export a register report for the new one and open it in Excel. In both spreadsheets, I add a running total 'Balance' column where each line is the sum of the previous balance plus the value of the current transaction.
At this point, I can readily see which transaction are in one file but not in the other by scrolling up and down and looking to see where the balances differ. Excel has a side by side comparison function that may be helpful. There are also comparison tools that are sometimes helpful. Hope this helps Mike XS11E 19/6/2010, 9:30 น. Laura wrote: Hundreds of duplicates sounds like whatever file keeps track of what has been downloaded from the bank either became corrupt or deleted. Your bank then downloaded all transactions back to the beginning of their download window. Thanks for the ideas, you're absolutely right, the problem is that Quicken can't match existing transactions to newly downloaded transactions, I had a thread about that some time back (manual matching isn't available either, don't know why?) and a fix was never found.
A lot of good information was provided but none of it seemed to apply to my particular problem. This all started when I changed financial institutions so it's something on their end.
There is other fluky behavior as well, all dating to changing my checking/credit card accounts from UBS to RBC. With you manually entering the transactions might cause those transactions to be downloaded again the next time you do a OSU. I suggest you make a backup prior to your next update just to be safe.
Good idea but a backup doesn't help if I fail to catch it when it happens and somehow that's exactly what did happen, I failed to catch it somehow??? I have a fix, I'm reluctant to do it because it's a hassle but I may have to.
I'm sure if I switch the credit card/checking services from the RBC account to Merrill Lynch account, everything will work properly again, it's somehow related to how RBC handles Quicken downloads. If I get another similar problem that's what I'll have to do.
XS11E, Killing all posts from Google Groups The Usenet Improvement Project: XS11E 19/6/2010, 9:40 น. 'John Pollard' wrote: XS11E wrote: Those were non-working answersNon-working answers, my eye. You clearly still don't understand anything about how Quicken reconcile works. I do but you clearly don't understand the problem.
I admit that's my fault since I don't understand it either it's difficult to explain properly but, try this: The problem I'm having is that the bank (RBC in this case) downloaded hundreds of duplicate transactions dating back into last year. Since these have all been reconciled (no, I don't know how they got accepted into the register or how they became reconciled w/o balancing) the only fix is to delete all of the duplicates that are marked reconciled and the easy way to do that is to start over as I've done. I will no longer attempt to help you. You've been no help at all so far and this last childish outburst from you doesn't help any either. XS11E, Killing all posts from Google Groups The Usenet Improvement Project: XS11E 19/6/2010, 9:45 น. Mike Blake-Knox wrote: In article, Xs11E wrote: XS11E wrote: How can I change the start date on the reconcile screen to go back to a previous month? Can anyone answer this?
I recall doing it once but I can't remember how. The problem is that the start date of a reconciliation doesn't have the slightest effect on the opening balance as Quicken calculates the opening balance by summing the values of all the reconciled transactions. Thanks but I think the problem is I'm asking an incomplete question, I needed to change the start date AND remove all the 'reconciled' tags from the hundreds of duplicate transactions that go back into last year. See my reply to Laura. I've just started over, that seems to be the easiest in light of the number of duplicates. XS11E, Killing all posts from Google Groups The Usenet Improvement Project: Zaidy036 19/6/2010, 14:21 น. In article, [email protected] says.
Mike Blake-Knox wrote: In article, Xs11E wrote: XS11E wrote: How can I change the start date on the reconcile screen to go back to a previous month? Can anyone answer this? I recall doing it once but I can't remember how. The problem is that the start date of a reconciliation doesn't have the slightest effect on the opening balance as Quicken calculates the opening balance by summing the values of all the reconciled transactions. Thanks but I think the problem is I'm asking an incomplete question, I needed to change the start date AND remove all the 'reconciled' tags from the hundreds of duplicate transactions that go back into last year. See my reply to Laura. I've just started over, that seems to be the easiest in light of the number of duplicates.
If you try to reenter transactions you will make errors. Display register by date. Go back to last correct reconciliation.
Duplicate entries should be easy to spot by scanning $$. Delete the duplicates. Repeat the ending reconciliation. Mike Blake-Knox 20/6/2010, 7:26 น. In article, Xs11E wrote: This all started when I changed financial institutions so it's something on their end. There is other fluky behavior as well, all dating to changing my checking/credit card accounts from UBS to RBC. Can you elaborate on the timing and mechanics please?
![]()
When did you switch from UBS to RBC and what did you do in Quicken to reflect the switch? Was the April statement from UBS and the May one from RBC? The way Quicken prevents duplicate entries is that the bank assigns a unique ID to each transaction. When a new transaction is downloaded, Quicken ignores if if the transaction ID has already been processed.
If UBS had a way to transfer old transactions to RBC, I would tend to assume that RBC would use different transaction IDs. It sounds like you are downloading old UBS transactions from RBC! How would RBC have any record of them? Understanding this may shed a lot of light on what's going on. Generally when one gets a new credit card account, you create a new account for the new bank and have a transfer transaction move the balance from the old account to the new account. If you had and even if RBC was able to download your UBS transactions, you could easily delete the old transactions. In fact, that would be the easiest way to delete all the old transactions: Create a new Quicken account, activate it to RBC and download your transactions.
You can then shift-click to select all the transactions and delete them. Afterwards, you could move all your transactions from the old account to the new one but you will likely run across reconciliation problems as Quicken has problems moving transfer transactions. Incidentally, I download from RBC Bank (US) myself using web connect. The web site has a pop-up that controls which transactions are downloaded. Mine is set to download only new transactions. How is yours set?
Hope this helps. Mike XS11E 20/6/2010, 11:23 น. Mike Blake-Knox wrote: In article, Xs11E wrote: This all started when I changed financial institutions so it's something on their end. There is other fluky behavior as wellall dating to changing my checking/credit card accounts from UBS to RBC.
Can you elaborate on the timing and mechanics please? When did you switch from UBS to RBC and what did you do in Quicken to reflect the switch?
About a year ago, all I did in Q was to add the RBC accounts and, as everything wa transferred, eventually deleted the UBS accounts. Was the April statement from UBS and the May one from RBC? No, both were RBC as were the previous 5 - 6 months. It sounds like you are downloading old UBS transactions from RBC! No, all the duplicates are from after the change. How would RBC have any record of them?
Because they're all previous RBC transactions. In fact, that would be the easiest way to delete all the old transactions: Create a new Quicken account, activate it to RBC and download your transactions. Can't go back more than 3 months, I thought of that, of course. Incidentally, I download from RBC Bank (US) myself using web connect.
The web site has a pop-up that controls which transactions are downloaded. Mine is set to download only new transactions. How is yours set? - XS11E, Killing all posts from Google Groups The Usenet Improvement Project.
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |