How to Delete Imported Transactions in QuickBooks Online?

Deleting an imported transaction in QuickBooks Online ensures your financial records remain accurate and organized. Follow these comprehensive steps and tips to delete or exclude a transaction effectively.

Step 1: Log In to QuickBooks Online

Step 2: Go to the Banking Section

  1. From the left-hand menu, select “Banking” or “Transactions.”
  2. Choose the bank or credit card account where the imported transaction is located.

Step 3: Locate the Transaction

  1. Navigate to the appropriate tab based on the transaction’s status:
    • For Review: Transactions not yet added to the register.
    • Categorized: Transactions already recorded in the register.
    • Excluded: Transactions previously removed.
  2. Use the search bar or filters to find the specific transaction you want to delete.

Step 4: Delete or Exclude the Transaction

For Transactions in the “For Review” Tab

  1. Locate the transaction and click to expand its details.
  2. Select “Exclude” to move the transaction to the Excluded tab. This removes it from your financial records.

For Transactions in the “Categorized” Tab

  1. Find the transaction and click on it.
  2. Select “Undo” to move it back to the For Review tab.
  3. In the For Review tab, exclude the transaction as explained above.

Step 5: Verify the Deletion

  1. Go to the Excluded tab in the Banking section to confirm the transaction has been excluded.
  2. Optionally, review the account register in the Chart of Accounts to ensure the transaction no longer affects your balances.

Important Notes

  • Excluded Transactions: Excluding a transaction does not permanently delete it; it simply removes it from your records and reports.
  • Reconciled Transactions: Be cautious when deleting reconciled transactions as it may create discrepancies in your accounts. Consult an accountant if necessary.
  • Unmatched Transactions: If a transaction is matched with another record, unmatch it before deleting or excluding it.

Tips for Managing Imported Transactions

  1. Use Bank Rules: Set up bank rules to automatically categorize or exclude certain transactions during imports.
  2. Bulk Exclusions: Select multiple transactions in the For Review tab to exclude them all at once.
  3. Avoid Duplicate Imports: Check your bank feed or import file settings to prevent unnecessary transactions from appearing.

By following these steps, you can successfully delete imported transactions in QuickBooks Online, keeping your financial records accurate and organized.

Read Similar Articles: