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

Hopefully someone can help me with this issue. 

 

Im having a problem with my quickbooks balance matching my bank balance. 

 

What I have noticed in my register is I have some bills coming up as twice, and its going towards the balance. I will have one of them reconciled from bank feed and the other will come up as either an expense or bill payment. My bills are paid by check.

 

What am i doing wrong?

2 Comments
RaymondJayO
Moderator

Yes, I'm here to help you fix the difference between your QuickBooks Online (QBO) and bank balances, @Scottyb718.

 

QBO depends on the financial data shared by your bank. With this, I'd suggest contacting their support team. They can help you confirm why some bills are coming up as twice, which causes the difference in your bank balance. Thus, you aren't doing wrong. 

 

Once verified, let's undo those transactions in the Reviewed tab since these are already added to the register. These will be moved to the For Review tab so you can exclude them. That way, they won't appear in any associated account registers or reports. I'll guide you how. 

  1. Go to Banking from the left menu. 
  2. Select Reviewed.
  3. Click Undo for all the duplicate transactions which come up as expenses or bill payments.
  4. Go to the For Review tab. 
  5. Check the box next to each transaction.
  6. Click the Batch actions drop-down.
  7. Choose Exclude Selected.

 

The screenshot below shows you the first three steps. For the detailed instructions in excluding transactions, check out this article: Exclude Expenses From Downloaded Bank Transactions

UndoDuplicateBills.PNG

 

Once done, you can categorize the transactions or match them with the existing entries, such as checks, in the program. It helps ensure your financial records are accurate. 

 

When you reconcile your account, your QuickBooks and bank balances will now match. 

 

Lastly, I recommend visiting this website: Reconcile Workflow. It contains in-depth details about starting, fixing any difference, and completing the reconciliation process. 

 

I'm here anytime you have other concerns. Take care always, @Scottyb718.

Scottyb718
Level 1

The "to print" doesn't show up in my bank feed where I can exclude it. This is only in register. This doesn't happen to every single bill I enter and pay, only a few over the past 6+ months. Any idea why it does this?

 

Heres an example

dup2.png duplicate.png

Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us