How can I find a cleared transaction that was changed or deleted since I last reconciled?

Legacy KB ID: 855

Question

The transaction list by date report can help you locate entries that have been changed or deleted after being reconciled:

  1. From the QuickBooks Reports menu, choose Accountant & Taxes, and then choose Transaction List by Date.
  2. Click Modify Report, and then click the Display tab.
  3. In the Columns list, select only Date, Num, Clr, and Amount, and then click the Filters tab.
  4. In the Filter list:


    1. Select Account, and then choose the account you are reconciling from the drop-down list to the right.
    2. Select Date, and then enter the date of your earliest QuickBooks transaction in the From field and the ending date of the last reconciled bank statement in the To field.
    3. Select Cleared, and then select Yes to the right.
    4. Select Entered/Modified, and then enter the date of the last reconciliation in the From field and today’s date in the To field.

  5. Click OK to return to the report, and then click Print. Compare each transaction on the printed report to the transaction on the bank statement.


    1. If a transaction on the printed report does not appear on the bank statement, make sure the register’s "cleared" column does not contain a checkmark.
    2. If the transaction does appear on the statement, make sure the "cleared" column in the register contains a checkmark.
    3. After making any needed changes in the register, click Record to save the corrections, and then verify the opening balance in the Reconcile [Account] window.

Note: An amount or reconcile status change will cause a transaction to appear on the report. It will also appear if you have changed a payee, an account, or other field on the transaction.

Finding deleted transactions: If the Audit Trail function is enabled, you can use the transaction list by date report to find transactions that were deleted:

  1. From the QuickBooks Edit menu, choose Preferences.
  2. Click the Accounting icon in the list on the left, and then click the Company Preferences tab.
  3. Select Use audit trail, and then click OK.

Answer

How did we do?

Recovering lost downloaded BankData transactions on Accounts Business

ABA file being rejected by bank

Related Articles

Reckon Accounts Desktop: Finding cleared transactions that have been changed or deleted
How can I delete names from a list?
Incorrect beginning balance in Begin Reconciliation window
Powered by HelpDocs (opens in a new tab)

Powered by HelpDocs (opens in a new tab)