How can I adjust my "in quickbooks" to match my "bank balance" in quickbooks?

Forgot to add I can reconcile just fine with no balance issues.  Just can't figure out why it won't match up on its own.  :(

Hi Lynners,

Unfortunately the only easy way to find out why the two balances dont match is to reconcile on a regular basis (I normally recommend once a month to my clients).

The other quick fix is sometimes to enter the 'Account History' and take a look at all of the transactions that have gone into that paticular bank account. Transactions with a green symbol have been pulled through on your bank feed directly from your bank account. Be wary of ones that do not have the green icon as they have been entered manually (normally where most error occurs). Also you might want to check above the green icons that there is the letter 'R' which means reconciled. Theoretically all transactions should have an 'R' against them as they should all be reconciled.

I hope this helps.

Kind Regards,

Emily

I am reconciled with no problems all the way up to this month and it doesn't help. :(  Ill check the other things you mentioned.  Thank you!

Any luck, lynners76?

Yes please?? Did you find an answer? I have the same exact problem. We have had a change-over in our church admin. New person still trying to figure things out. What I would like to do is go in a make an adjustment to my "in quickbooks" register so that it I can balance out like starting over. I have reconciled every month up to this last month. I just need to get my "in quickbooks" balance to match my actual Bank Account balance. 

Hello there, joybaptist.

Thanks for visiting the Community. I want to ensure your QuickBooks balance matches with the bank balance so it won't throw off your bank records.

When the amount doesn't match, it could be there are outstanding checks, duplicate transactions, transactions that may have been modified or deleted. For the recommended steps on how to resolve the issue, you can refer to the article provided by @ GillH.

If none of the steps work, I suggest you get in touch with our QuickBooks Online Customer Care Team for help with matching your transactions. You can reach them through the following link: Contact support.

Since you're reconciling, you might want to check out this helpful articles:

• Reconcile hub
• Reconcile accounts

Also, you can reach out to me anytime if you have questions about using QuickBooks. Please know I'm just a comment away.

Hi everyone,

Please see the video below on how to reconcile your bank accounts to solve this issue: 

Bank Reconciliations

Also it is worth going into account history to check the opening balance equity account. This automatically pulls through when you connect your bank account. This figure should be the balance of your bank account on the first day of your financial year to be accurate.

Kind Regards,

Emily Mockett