quicken is changing my opening balance when I reconcile

LouiseG
LouiseG Member
For 3 months, quicken has changed the opening balance when I reconcile my account even though I reconciled it the previous month. It then puts in a balance adjustment, a deposit, that I didn't make and don't want in my register.
I have used quicken for many many years and have never had this problem. Why is it forgetting the the ending balance from the previous month?
I enter all transactions manually.

Answers

  • LouiseG
    LouiseG Member
    Today I reconciled for 2 months, and when I did the second month, Quicken HAD remembered the opening balance correctly. (This is the second time I have reconciled 2 months on one day. Last time, it never remembered the opening balance correctly.)
    In any case, maybe the glitch is no longer occurring. I still have to figure out whether I can simply delete the erroneous balance adjustments that Quicken made, which are making my actual balance wrong.
  • splasher
    splasher SuperUser ✭✭✭✭✭
    The Opening Balance of the reconcile or the Opening Balance of the account (1st transaction)?
    -splasher  using Q since 1996 -  Subscription  -  Win10
    -also older versions as needed for testing
    -Questions? Check out the  Quicken Windows FAQ list
  • LouiseG
    LouiseG Member
    The opening balance of the reconcile. It used to be that I reconciled one month and then the next month quicken automatically knew the correct opening balance when I was ready to reconcile again.
  • splasher
    splasher SuperUser ✭✭✭✭✭
    If the beginning balance of the reconcile is changing from what they were, it is because the Reconciled transactions have changed.

    The opening balance of the reconcile is the sum total of all of the reconciled, "R" transactions in the register and is calculated at the time of reconciliation and not stored for future reference.

    What could change that # is one of the following:
    1. a blank or C was changed to a R
    2. an R was changed to a blank or C
    3. the amount of an R was changed
    4. a new transaction was marked R to begin with
    5. a R transaction was deleted
    -splasher  using Q since 1996 -  Subscription  -  Win10
    -also older versions as needed for testing
    -Questions? Check out the  Quicken Windows FAQ list
  • LouiseG
    LouiseG Member
    Thanks. I will check those things.
  • markus1957
    markus1957 SuperUser, Windows Beta Beta
    I had this happen in testing a while back. It appeared Quicken was calculating the Opening Balance for the Web app which only goes back 3 years and applying it to accounts with more than 3 years years of transactions in the desktop account register.  After fixing the Opening Balance manually and turning off Sync, it has not reappeared.
  • LouiseG
    LouiseG Member
    I think I'm all set, though to be honest, I'm not sure why. I could easily have changed an "R" to a "C" or vice versa because I do not understand the difference between them. I will be more careful!
    "Sync" was not turned on, but thanks for that suggestion.

    The initial reconcile balance is correct now which is a huge relief.
  • splasher
    splasher SuperUser ✭✭✭✭✭
    LouiseG said:
    I think I'm all set, though to be honest, I'm not sure why. I could easily have changed an "R" to a "C" or vice versa because I do not understand the difference between them. I will be more careful!
    "Sync" was not turned on, but thanks for that suggestion.

    The initial reconcile balance is correct now which is a huge relief.
    Here is my interpretation of "blank", "C","R".
    When I enter a transaction manually, it is blank.
    When I subsequently download a transaction, whether it matches to a manual transaction or is just inserted new, it is "C".
    When I get my statement from the financial institution and I compare it to what is in Quicken doing a reconcile, Ctrl+R, they become "R".
    If you have "auto-reconcile to the online balance" set for the account, the download changes them to "R".  I don't do auto-reconcile, so no comment further on that.
    -splasher  using Q since 1996 -  Subscription  -  Win10
    -also older versions as needed for testing
    -Questions? Check out the  Quicken Windows FAQ list
  • I thought I was going crazy, but when I download transactions, sometimes my automatic reconciliation fails with some kind of odd amount. After several instances and looking at a lot of transaction history, I have concluded that when I do transaction download with automatic reconciliation, that sometimes Quicken alters the opening balance of the account causing it to fail a reconciliation that just one week prior was fine. I have to go adjust the several years old opening balance to put the bank account back into balance and reconcile.
  • nelaco
    nelaco Member ✭✭✭
    I am having the same issue, and it makes no sense. Why would Quicken change my opening balance, and without even asking me to approve the change? This only started happening in the last 2 weeks, and now in TWO accounts. It's been a total PITA. Quicken, you need to FIX this!
  • splasher
    splasher SuperUser ✭✭✭✭✭
    @[email protected]  @nelaco 
    Are either of you using QMobile and/or Q-Web?  If so, I recommend not doing so, it can cause funny things to happen to some files.
    -splasher  using Q since 1996 -  Subscription  -  Win10
    -also older versions as needed for testing
    -Questions? Check out the  Quicken Windows FAQ list
  • nelaco
    nelaco Member ✭✭✭
    splasher said:
    @[email protected]  @nelaco 
    Are either of you using QMobile and/or Q-Web?  If so, I recommend not doing so, it can cause funny things to happen to some files.
    I am not since they suck.  Tried it for a little bit a year ago and decided it was a waste of time. Thank you for trying to help!
  • splasher
    splasher SuperUser ✭✭✭✭✭
    nelaco said:
    splasher said:
    @[email protected]  @nelaco 
    Are either of you using QMobile and/or Q-Web?  If so, I recommend not doing so, it can cause funny things to happen to some files.
    I am not since they suck.  Tried it for a little bit a year ago and decided it was a waste of time. Thank you for trying to help!
    But did you completely turn it off?  You might try using the latest copy process that creates a copy of the file but makes it completely independent of the existing file.  It will require that you reconnect all of your download connections, but you will be able to definitely eliminate QMobile/Q-Web as the source of the problem.




    -splasher  using Q since 1996 -  Subscription  -  Win10
    -also older versions as needed for testing
    -Questions? Check out the  Quicken Windows FAQ list
  • nelaco
    nelaco Member ✭✭✭
    Good to know @splasher, kind of a pain but I'll do it if it keeps happening.  I have over 30 accounts set to download so it would be a lot of work.  Appreciate the quick help!

  • shackelford
    shackelford Member ✭✭
    What @splasher writes is 100% correct. This happens every time Quicken decides to Sync to Quicken Cloud. I write "Quicken decides" because no matter how many times I deactivate that option, it keeps turning itself back on. To fight this, I've written the correct opening balance in the memo field of each account's Opening Balance. At least that way it doesn't take long to find and fix it.
  • markus1957
    markus1957 SuperUser, Windows Beta Beta
    Even with Sync off in Preferences, go to the Mobile Tab and make sure NO accounts are selected to SYNC, including any hidden accounts.  That way when it turns itself back On, no accounts will sync.
  • Chris_QPW
    Chris_QPW Member ✭✭✭✭
    Even with Sync off in Preferences, go to the Mobile Tab and make sure NO accounts are selected to SYNC, including any hidden accounts.  That way when it turns itself back On, no accounts will sync.
    When it is really turned off you shouldn't get that far, here is what it should look like:

    Signature:
    (I'm always using the latest Quicken Windows Premier subscription version)
    This is my website: http://www.quicknperlwiz.com/
  • markus1957
    markus1957 SuperUser, Windows Beta Beta
    Unbelievably, the greyed-out gear icons are still active. 
  • Chris_QPW
    Chris_QPW Member ✭✭✭✭
    Unbelievably, the greyed-out gear icons are still active. 
    Wow, how stupid is that!

    Thanks for pointing it out.
    Signature:
    (I'm always using the latest Quicken Windows Premier subscription version)
    This is my website: http://www.quicknperlwiz.com/
This discussion has been closed.