cancel
Showing results for 
Search instead for 
Did you mean: 
CharlotteP
Level 1

What do you do when your bank register balance does not equal your chart of accounts bank balance?

Hi, Could someone help me please. I am reconciling the books to match the bank account, the opening balance from previous month is correct and the ending balance for the month i am reconciling is correct, taken from my statement, plus i have printed my statement off and all of the transactions that are ticked in the reconciliation matches what i have on the statement, therefore there are no missing transactions as they are all on the statement and are ticked in Quickbooks but the QuickBooks says i still have a difference of -4,333 (missing bills/expenses i have not inputted). Does anyone know of any troubleshooting errors this could relate to please? 

thank you !!!! 

Any help would be appreciated!!

Carneil_C
QuickBooks Team

What do you do when your bank register balance does not equal your chart of accounts bank balance?

Thanks for joining this thread, @CharlotteP. I’d be glad to help you resolve the reconciliation differences in QuickBooks Online.

 

Since your ending and opening balance are correct when reconciling, I recommend checking your bank statement. Make edits as needed, and ensure you’ve recorded all transactions.

 

In some cases, the reason for this difference amount is a duplicate transaction. If there is, then you can delete it.

 

In addition, I've got this helpful resource to help you fix issues at the end of a reconciliation.

 

To know more about reconciliation in QuickBooks Online, check these out:
Reconcile an account in QuickBooks Online.
Undo or remove transactions from reconciliations in QuickBooks Online.

 

Stay in touch if you have any other questions or concerns about fixing reconciliation issues. I’ll be right here to answer them for you. Enjoy the rest of the day. 

Gigi92
Level 1

What do you do when your bank register balance does not equal your chart of accounts bank balance?

Hi, I have to download my bank transactions as well and import them in quickbooks online. I did enter my opening balance when I first started with QuickBooks Online. I did balance perfectly until recently. I think I have duplicate transactions in there some how, but when I go to delete them it also marks my customers as unpaid. HELP! I don't know what to do at this point?

Thank you!

Carneil_C
QuickBooks Team

What do you do when your bank register balance does not equal your chart of accounts bank balance?

Thanks for joining the thread, @Gigi92.    

 

I want to ensure your concern about your bank transactions gets taken care of. However, I have to ask for some details about the issue. 

 

May I know how you record these transactions? And what transactions came up as duplicates? This way, I can provide you with the best resolution.

 

I'd appreciate any additional details you can provide. I’m looking forward to your reply. Have a great rest of the day.

samraustin
Level 1

What do you do when your bank register balance does not equal your chart of accounts bank balance?

My bank acct is reconciled and correct. When I pull up the list of acts, the balance comes up inaccurate after opening the account it shows the proper amount.  I have 2 other bank accounts that are accurate and in order?

 

ChristineJoieR
QuickBooks Team

What do you do when your bank register balance does not equal your chart of accounts bank balance?

Hello there, @samraustin.

 

We can work together on reviewing your reconciled transactions in QuickBooks Online.

 

When transactions are manually imported, the bank balance and the balance in QuickBooks will not be the same. If the account is linked to online banking, the bank balance will only be changed or updated. The added or matched transactions will also affect the QuickBooks balance.

 

Here are the things to review in reconciling accounts:

 

  1. Review the original opening balance.
  2. Check your bank statement, and make sure you're reconciling the correct month.
  3. Double check if there are matched transactions.

 

Furthermore, If you need to edit the transaction, you can follow these steps: 

 

  1. Click Accounting.
  2. Go to the Chart of Accounts tab.
  3. Select the bank account, then click View register.
  4. Look for the transactions and check if you can see R in the column. 
  5. Select the transaction and repeatedly click the status until it's blank or unreconciled. 
  6. Click Edit. Make the changes and then save.

 

You can go back to the register and manually reconcile the transaction by clicking the Reconciliation status column to, then click Save

 

Also, editing reconciled transactions may result in discrepancies between your previous and next reconciliation balances. I recommend contacting an accountant to help you manage the reconciled transaction so it doesn't mess up your books.

 

After that, try to reconcile the new month and see if there are any other issues. If there are any errors, you can use this article to help you correct them: Fix issues for accounts you've reconciled in the past in QuickBooks Online.

 

Please let me know if there is anything else I can do for you. Please leave a comment, and I will respond as soon as possible.

brickwallmasonry
Level 1

What do you do when your bank register balance does not equal your chart of accounts bank balance?

My account is reconciled, but the bank and quickbooks totals are still off. When I go into chart of accounts and look at the checking account, there are multiple transactions that have not been reconciled. All of them are transfers to pay for credit cards. Could that be why it is off? How do I fix this? My credit cards are also not matching in quickbooks versus bank, even though they are reconciled correctly.

LieraMarie_A
QuickBooks Team

What do you do when your bank register balance does not equal your chart of accounts bank balance?

Hey there, @brickwallmasonry

 

Thanks for joining this thread! I'm pleased to share some insights about why your real-life bank and bank account in QuickBooks don't match.

 

To clarify, are these transfers included in your most recent bank statement? Your QuickBooks bank/credit card balance is the total balance of all transactions you've added or matched to QuickBooks, while the statement balance covers the balance for a specific period it indicates. Differences between your bank and your bank account in QuickBooks are usually the result of uncleared transactions. For example, you write a check or record a sale in QB. There will be a difference until that money has been deducted or added to your real bank account.

 

Additionally, you can refer to the articles below to learn more about the reconciliation process:

 

 

Please come back and add a reply below if you have further questions regarding your balances. I'd be delighted to help you more. Keep safe always!

louis112121121
Level 1

What do you do when your bank register balance does not equal your chart of accounts bank balance?

I need Help. My bank opening balance on the trial balance is correct. but on the bank register it is showing a different opening balance but there are no reconciliations as i have deleted them all.  

 

Can someone help ?

Angelyn_T
QuickBooks Team

What do you do when your bank register balance does not equal your chart of accounts bank balance?

Let's address the discrepancy in your account's opening balance, Louis.

 

If you're referring to the Opening Balance Equity account on the Trial Balance report, this comprises all the opening balances of your accounts. Thus, the amount won't match a single bank's opening balance. 

a27 1.PNG

 

You can click on the amount to drill down the details.

 

However, if your bank's opening balance is off, you can modify it by following these steps:

 

  1. Tap on Chart of Accounts from the Gear icon.
  2. Locate the account and select View Register.
  3. Find the opening balance entry. You can sort the date column to show the oldest entries first. 
  4. Choose the opening balance entry.
  5. Update the amount.a27 3.PNG
  6. Select Save to record the changes.

 

I'm also adding this material for more tips while managing an opening balance for your bank, credit card, and other accounts: Enter and manage opening balances in QuickBooks Online.

 

Once done, you can proceed with your reconciliation to match your QuickBooks record and your statement.

 

You're always welcome to leave a comment if you have further questions while tracking your bank balances and other financial data. I'll be around to help.   

louis112121121
Level 1

What do you do when your bank register balance does not equal your chart of accounts bank balance?

That's not right as the bank accounts are split out on the trial balance so the single account balance is correct and there are no earlier transaction then the one i put in for the opening. and this balance is different to the opening balance in the register which has no reconciliation. 

 

GeorgiaC
QuickBooks Team

What do you do when your bank register balance does not equal your chart of accounts bank balance?

Hi louis112121121, did you migrate to QuickBooks Online from a different software (such as QuickBooks Desktop), and is the opening balance marked as reconciled (with the R status in the check column) in the bank register? To view the bank register, select Account History beside the account in your chart of accounts. The opening balance should be the earliest entry here. 

Need to get in touch?

Contact us