Balance in Quicken 2017 Mac is incorrect.

phil roberts

Apple Macbook Pro died last week. Bought a new one. Downloaded Q17 Mac and installed. Downloaded 2 yrs of transactions from the bank and imported into Q17. Manually added new transactions. Certain transaction dates do not change the Balance column. It's somewhat random: 1/3/2020, 12/31/2019 and others. Trans date 1/11/2020 does update the Balance. What's up with this? Tried to reconcile last statement period. All transactions match but balances don't.

John_in_NC

It's designed to help you

What's going on is the "Live Balance Adjustment"-and it does indeed work well when you understand what is going on.

When you setup these accounts, it took the balance as reported by the bank, and created an opening balance adjustment to make the final balance correct. Great.

Any transactions entered after the last transaction imported on initial import will change the running balance. Any transactions entered/adjusted prior (in your case 1/10/2020) will cause the Live Opening Balance amount to change (and thusly causing your final running balance to remain the same.) This is so you can manually enter in older transactions, if desired, and your final balance will remain correct.

If you don't want this auto-magic opening balance to exist, you can recreate (i.e. manually enter) the Opening Balance transaction exactly as is with the desired amount, and then get rid of the Live Balance (in gray) that Quicken created. Your transaction will be static and won't change.

But, once you understand what is going on, you might not wish to do that as it will be helpful if you are entering in old data.

John_in_NC

It's designed to help you

What's going on is the "Live Balance Adjustment"-and it does indeed work well when you understand what is going on.

When you setup these accounts, it took the balance as reported by the bank, and created an opening balance adjustment to make the final balance correct. Great.

Any transactions entered after the last transaction imported on initial import will change the running balance. Any transactions entered/adjusted prior (in your case 1/10/2020) will cause the Live Opening Balance amount to change (and thusly causing your final running balance to remain the same.) This is so you can manually enter in older transactions, if desired, and your final balance will remain correct.

If you don't want this auto-magic opening balance to exist, you can recreate (i.e. manually enter) the Opening Balance transaction exactly as is with the desired amount, and then get rid of the Live Balance (in gray) that Quicken created. Your transaction will be static and won't change.

But, once you understand what is going on, you might not wish to do that as it will be helpful if you are entering in old data.

phil roberts

Thanks for the quick and helpful response. It solved my problem. It's in balance now.

AEHaworth

Can you get rid of the live balance and projected balance feature and do it manually?

John_in_NC

AEHaworth said:

Can you get rid of the live balance and projected balance feature and do it manually?

Hi, AEHaworth:

(Do note this is an old question you are posting on.)

But, yes, you can eliminate the live balance automation by deleting the Live Balance and manually entering an equivalent transaction. This transaction will be static and will not adjust.