Skip to main content
S
Shelly_K123
December 19, 2023
Question

Items for Review

  • December 19, 2023
  • 1 reply
  • 0 views

Hi, I hope someone can help me.  I have recently joined a company that uses Quickbooks.  Unfortunately the person who has been dealing with the accounting has not been matching income to customer invoice so I have 360 items for review.  I've been in touch with the Quickbooks team & have been told that I need to  match them one by one to get them out of review (the quickbooks balance doesn't match the bank balance).  My predecessor manually received the credit against the invoice so all of the invoices are already paid, so I would have to undo the payment received, then match the item.  Sadly, some of the clients accounts no longer exist & there are payments where it is not clear who the client was due to the generic description on the payment.  Basically, I need to find a way to remove these items (without losing the information in case I need to refer to it in the future) so that the quickbooks & bank account balances match.  Does anyone have any ideas please?  Thank you 

1 reply

G
GeorgiaC
December 19, 2023

Hi Shelly_K123, thanks for posting on the Community 

 

In the case that the payment details have already been correctly recorded against the invoice, you can go ahead and exclude the corresponding transaction(s) in the For review tab to prevent duplicates.

 

To exclude a transaction on a web browser: 

 

1. Go to Transactions and select Bank transactions.
2. Select the For Review tab.
3. Select the checkbox of the transactions to exclude.
4. Select Exclude.
 

The transaction moves to the Excluded tab of the Bank Transactions page. From here, you can select the transactions to Delete. 

 

In the future, you can use the Match function to link the downloaded bank transaction to an open invoice or invoice payment. Please note, that it's not possible to Match once the transaction has been reconciled. 

 

If a transaction has been recorded and reconciled incorrectly, you can instead learn how to undo or remove transactions from reconciliations. Hope this helps!

S
Shelly_K123Author
December 21, 2023

Thank you, I have tried this.  The item disappears from the review list but it does not change the balance in quickbooks so my bank account balance & quickbooks balance still won't match. 

E
emmam6
December 21, 2023

Hello Shelly, if you exclude a transaction in the for-review page it will not impact the bank account balance. In this case the exclude was being suggested as you mentioned the transaction was already recorded.

In terms of the balance not matching. If you go to the chart of account for the bank account and account history, at what point did it not match, is this recent? Has the reconcile tool been used by the previous user (settings cog in top right>reconcile will tell you date reconciled until)?

Terms & ConditionsAccessibility statement