How to Delete Trial Balance in QuickBooks Online using SaasAnt Transactions Online

February 26, 2026

This article details how to eliminate trial balance discrepancies in QuickBooks Online through SaasAnt Transactions Online. It highlights the importance of identifying the affected accounts, safely correcting the underlying entries, and ensuring that balances are aligned for accurate financial statements.

Note: Since the "Trial Balance" is a report generated from transactions, "deleting a trial balance" technically means deleting the specific transactions (like Journal Entries, Invoices, or Expenses) that are causing incorrect balances.

Why use SaasAnt for deleting the trial balance?

SaasAnt Transactions Online lets you search with filters, review the transactions affecting your trial balance, take a backup, and delete multiple entries in just a few clicks.

What should you have before you start?

You need:

  • SaasAnt Transactions Online installed from the QuickBooks App Store (30-day trial available).

  • A QuickBooks Online company connected to SaasAnt Transactions Online.

Connect Saasant Transactions with QuickBooks Online Account.png

How do you bulk delete the trial balance using SaasAnt?

Step 1: How do you open SaasAnt Transactions Online?

  1. Open the QuickBooks App Store.

  2. Install SaasAnt Transactions Online and connect your QuickBooks Online company.

  3. Launch SaasAnt Transactions Online.

Launch SaasAnt Transactions Online.png

Step 2: Where do you start the delete flow?

  1. From the SaasAnt dashboard, select Delete.

  2. On the setup screen, select Ready to clean up.

Select Delete - SaasAnt Transactions Online.png

Step 3: Which delete method should you choose?

Choose one:

  • Delete by Reference: Use this when you already know the exact Reference Numbers (Ref No) of the transactions you want to delete.

  • Then select Next.

Step 4: How do you narrow results using filters?

  1. Enter the Reference Numbers (transaction numbers) you want to delete.

  2. Select Search to load the matching transactions.

Step 5: How do you review, backup, and delete?

  1. Review the search results carefully to ensure these are the correct entries affecting your balance.

  2. Select the transactions you want to delete.

  3. Download a backup (CSV or Excel) before deleting.

  4. Select Delete.

  5. Confirm the deletion in the pop-up.

Important: Deleting is not reversible. Always take the backup first, and delete in smaller batches if you are removing a large volume.

Step 6: Where do you see the deletion summary?

After deletion, SaasAnt shows a Deletion Summary. This summary is available to download for up to 2 days and can be used for records and audit tracking.

Troubleshooting

What if no trial balance entries show up after the search?

Check these:

  • Confirm that the Reference Numbers are correct.

  • If searching by date, confirm the Date Type and Date Range match when the transactions were created or edited.

  • Remove filters one by one (such as account name or number) to broaden the search.

What if the delete fails for some trial balance entries?

Common reasons:

  • The transaction is restricted by QuickBooks due to how it is linked (e.g., a payment linked to an invoice) or if the books are closed.

  • Try deleting a smaller selection to identify which specific records are failing, then review those transactions inside QuickBooks Online.

What if you deleted the wrong trial balance entry?

You cannot undo a delete in QuickBooks Online. Use your SaasAnt backup file to re-create the transaction if needed, or restore using your own backup process if available.

Bulk delete old or wrong transactions fast
Safely remove duplicates and bad test data
Try SaasAnt free and simplify your cleanup