Why are my "In Quickbooks" balance and my "Bank Balance" showing different numbers for my new company?

That worked perfectly. Thanks.

I do not see the Account History under Action.... 

Thanks for pointing this out, susan76.

The Account History option is an old feature in QuickBooks Online (QBO). Under Action, you can use the View register instead.

To be updated with the latest improvements made in the product, feel free to visit this link: https://quickbooks.intuit.com/blog/whats-new/.

Get back to me if you have any other questions. I'm a post away to help. Have a great day!

Hi I did the Opening Balance part and still my "in quickbooks amount is way higher than my bank balance is there any possible reason for this. If so how can I fix it

Allow me to share some details about the mismatch amount between QuickBooks and your bank's balance, @mandarin.

This happens when there are outstanding checks, duplicate transactions, transactions that may have been modified or deleted. I'd recommend carrying out full reconciliation of the account would be the best way to find the discrepancy and allow you to amend the account accordingly.

Checking the Account register to verify the opening balance is one way to spot if there's an opening balance not being added correctly. This figure should be the balance of your bank account on the first day of your financial year to be accurate. Also, let's make sure that every transaction there are reconciled in the Account register. This is how it looks like:

To know more about the causes and resolution of the mismatched balances, you can check out this article: Fix issues for accounts you've reconciled in the past in QuickBooks Online.

You can also reach out to an accountant to make sure that your books are accurate. If you don't have one, you can find an accountant here: https://quickbooks.intuit.com/find-an-accountant/.

Please don't hesitate to let me know if you have other questions or concerns. I'd be happy to help you further. Take care.

Hi,

I'm still having issues w/ my account balances. Bank balances are correct but QB balance is negative. I adjusted the opening balance and reconciled our checking account 

Thanks for joining on this conversation, @PPON.

I'm here to ensure your balance in QuickBooks Online (QBO) is correct. So, let me share with you the possible reason why your QuickBooks Balance is negative.

Several factors may cause why your opening balance is negative in QBO. These are the following: 

• Outstanding transactions
• New transactions for a connected account
• Duplicate transactions
• Edited or deleted transactions
• Credit card (liability) account

To figure this out and resolve it, I'd suggest running the Reconciliation report. 

Here's how: 

1. Go to the Report tab on the left side. 
2. Type the mentioned report in the search box. 
3. Choose Report period and Account in the drop-down. 
4. Review each transaction on the report one at a time by clicking the View button. 
5. Revision the Change Type to see the status of the transactions. 

• Amount changed- open it and modify the amount. 
• Unreconciled in the register - Please go to your Chart of Accounts (COA), then mark the transaction R. 
• Reconciled in error- In the COA Select the box in the tick column until it's blank or you see a C. 
• Deleted - recreate the transaction to fix the problem. 

      6. Follow the on-screen instructions. 

For the complete steps, check out this article: Fix issues for accounts you've reconciled in the past in QuickBooks Online.

Additionally, I'd encourage you to visit these articles below about reconciling errors troubleshooting, and other topics. 

• Learn the reconcile workflow in QuickBooks
• Fix mistakes on your bank or credit card statement

Let me know if you have further questions about this situation. I'm eager to help. Keep safe. 

Hi Michelle, thank you so much for the help and for the quick reply. Ok, i've followed the instructions and when i get to the reconciliation report and click on the transactions, i get a pop up window that says Missing Transaction-The transaction you are trying to edit has been deleted.  A few weeks ago i realized a whole bunch of my credit card deposits were going into either both checking and savings or just savings, i can't remember but i went in and deleted them and now they are stuck in there i think? Not sure how to fix. 

Thanks for keeping us updated, PPON.

I can share how we can fix QuickBooks and bank balances.  

When reconciling an account, we take into consideration the transactions posted on your bank statement and match it with the one QuickBooks. If some edited, moved, or deleted, or unreconciled a reconciled transaction, it changes the ending balance of your last reconciliation which also impacts the beginning balance of the next period to reconcile. 

You can review your statement first if the deleted transactions are supposed to be on that period's reconciliation. If so, you can recreate them exactly how they were created. For your reference, you can use the reconciliation report. 

Here's how to pull that up: 

1. Go to the Reports menu.
2. Enter and select Reconciliation Reports.
3. Select the Account and Report date.
4. Click View report.
5. You'll see the Reconciliation Change Report section which identifies the change. 

Once you've recorded the transactions, you'll want to manually reconcile them. For more details, you can check out the steps on this link: Fix issues for accounts you've reconciled in the past in QuickBooks Online.

Let me know if you have other questions. Take care and have a great day!

Hi, I have been sent your link to follow from live chat on quickbooks as my quickbooks balance and my bank account balance isn't matching by a significant amount, I have no idea how to fix it and I have been reading and following your advice, However where it should say opening balance I have no transactions that say this, is there a reason for this? I have 95 transactions and not one of them say opening balance so I have no idea how to fix this, is this something you have come across before and something you can guide and advise me on? 

Many Thanks

Mandy

Hi Mandy, thanks for joining this thread - the opening balance is the balance of your bank at the point starting to record transactions in QB. If this is a new bank account, the balance may be zero, however, if you have transactions prior to joining you'll want to record the OB and then transactions from this date onwards. We've got a guide here that covers how to enter this using a journal entry - please get back to us below if you have any further Q's.