Skip to main content
May 8, 2020
Question

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

  • May 8, 2020
  • 1 reply
  • 0 views
There were two "sales receipts" entered 2 years ago. They were deleted and no longer show on register, but still on balance

1 reply

May 8, 2020

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!

richheatAuthor
May 9, 2020

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!

 

richheatAuthor
May 9, 2020

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.