cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
NEW Connect to DBS IDEAL direct bank feeds Click here
IUS
Level 1

How can I found out the date when my bank balance per QB and per the bank account were not aligned?

Hi all. I've come back to work for my current organisation and after allocating all transactions "for review", there is a difference per our bank balance in QuickBooks and the bank balance per the bank. This is likely due to a transaction being deleted in QB by my predecessor. Is there a quick way when we can find out since what date the bank balance in QuickBooks and the bank balance per the bank was not align and has been different?

1 Comment 1
BettyJaneB
QuickBooks Team

How can I found out the date when my bank balance per QB and per the bank account were not aligned?

Hi there, @IUS.

 

I've got some insights to share in regards to reviewing your transactions to determine when your QuickBooks and bank balance started to differ.

 

At this time, we don't have the option to locate directly when the difference between your bank and QuickBooks balance arises. You'll need to review each transaction on your register to identify the exact date.

 

To do that:

  1. Go to the Gear ⚙️ icon at the top.
  2. Select on Chart of Accounts under Your Company.
  3. Look for the bank account that you're working with.
  4. Under the Action column, click on View register.

On the other hand, here are some possible causes why these balances don’t match:

  • Outstanding transactions.
  • New transactions for a connected account.
  • Duplicate transactions.
  • Edited or deleted transactions.
  • Card (liability) account.

To get this issue sorted out, please visit this link that contains complete details on what are the actions to be taken for this situation: Learn what to do if your account in QuickBooks Online doesn't match your bank statement.

 

In addition, you can always check out these resources attached to give you more information about fixing reconciliation discrepancies together with its workflow:

I'd also like you to know that our developers are constantly looking and considering new features to be added to the system. This way, we can make the product work the way your business needs.
 

I'll be right here to help if you have any other questions. Just leave a reply below. Take care!