Reconciliation is complete. Says everything is good, but balance between QB and bank statement are out. Cant fix!

Hey richheat.

Awesome job getting the reconcile done on your account. Having your books match up with your bank is important for all business owners and I would be happy to help you get this sorted out.

I'd like to make sure the sales receipts were fully removed from your account to make sure it's not the reason they are still showing up in your balance.

These are the steps to make sure it was deleted correctly.

1. Go to the Sales menu.
2. Find and open the transaction.
3. Review the transaction. Make sure you need to delete it.
4. Select More in the footer. Then select Delete.
5. Select Yes to confirm.

Once that is done and you've confirmed the sales receipt was deleted and not just voided, then I would start by clearing the cache and temporary internet files. This can sometimes have an affect on the information that is inputted because QuickBooks online is a cloud-based software. Here is a link for how to do this on all commonly used browsers.

Should the issue continue after following these steps, having more information on how it was deleted and when would greatly assist getting to the bottom of what is happening. I would suggest calling into our support team for more assistance.

Hope you have yourself a great weekend!

Hi Nick,  and thanks for taking the time to help out.   I'm still not out of the woods yet.

The amount that is out after completely reconciling right up to a few days ago is $79.10

This amount is exactly equal to two sales receipts I mistakenly made back in August 2018.

One was for $67.80

One was for $11.30    I was never able to fix these.

Those two receipts were deleted.  They do not show up any more in the register, or the sales register either.

Following your steps, those receipts can no longer be found, there was nothing to delete, and yet the amount is still out by $79.10

There is another problem.  By doing the reconciliations, I discovered that two other  transactions were double entered.  Not by me, but by quickbooks when I reviewed them from the bank statement download.  (a glitch perhaps?)  I deleted those transactions as well and they no longer show in the register,  however, they are still showing under transactions as "not yet reviewed".   If I click "add" to categorize them, it adds them to my quickbooks balance and throws out the balance.   These transactions are also no longer showing up in the register, they are just stuck in "to be reviewed".   No idea how to fix this either!

Nick I need to update this as I've been working with it some more.

I managed to get the sales receipts permanently deleted.  So the accounts now balance.

I still have the problem of the double entries.  If I go into the register and delete them, it just sticks them into the "to be reviewed" on my banking dashboard.   If I click "add" it puts them back into the register and I end up with 2 double transactions again.  It's a loop I cannot get out of.   I cannot find any way to get rid of these double transactions.

I've managed to "exclude" the two duplicate transactions.  They are still there, but it's been shuffled into excluded section and not counting into the balance.  So I can move on, but these transactions will always be there and apparently can never be completely deleted.

I think I've finally fixed it.  I discovered that once a transaction is put into the excluded folder, it can finally be deleted.  Hopefully they are gone!