What does this article help you do?

This article details how to delete customer records from QuickBooks Online with SaasAnt Transactions Online. It walks you through exporting customers, checking data, and securely syncing updates to keep your accounting records clean and accurate.

Why use SaasAnt for deleting Customers?

SaasAnt Transactions Online lets you search with filters, review the matching customers, take a backup, and delete multiple customers in 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

How do you bulk delete Customers using SaasAnt?

Step 1: How do you open SaasAnt Transactions Online?

• Open the QuickBooks App Store

• Install SaasAnt Transactions Online and connect your QuickBooks Online company

• Launch SaasAnt Transactions Online

Step 2: Where do you start the delete flow?

• From the SaasAnt dashboard, select Delete

• On the setup screen, select Ready to clean up

Step 3: Which delete method should you choose?

Choose one:

• Delete by Reference: Use this when you already know the exact customer names you want to delete.

• Delete by Searching: Use this when you want to find Customers using filters (example: duplicates by customer, amount, or date).

Select your method, then select Next.

Step 4: How do you set customer type and date filters?

Set Transaction Type to Customers

Choose the Date Type you want to filter by:

• Created Date: When the customer was first created in QuickBooks

• Transaction Date: The customer's date shown on the transaction

• Last Updated Date: When the customer was last edited in QuickBooks

Enter the date range

Step 5: How do you narrow results using filters?

Select Customize

Apply the filters you need, such as:

• Total Amount (From amount - To amount): Use this to target Customers within a specific total range (example: Customers between 200 and 800).

Status: 

• All: All the customers in the list will be included.

• Active: Only active customers in the list will be included.

• Deleted/Inactive: Only deleted/inactive customers in the list will be included.

• Company Name: Type the specific company name from which you want to delete the customers

• Detailed Report [Multi Lines]: Turn this on when you want to review line-level details for each customer, especially when Customers have multiple product or service lines.

Select Search to load matching customers

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

• Review the search results carefully

• Select the Customers you want to delete

• Download a backup (CSV or Excel) before deleting

• Select Delete

• Confirm the delete 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 7: 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 Customers show up after the search?

Check these:

• Confirm Date Type and date range match when the customers were created or edited

• Remove filters one by one (customer, reference no, total amount range) to broaden the search

What if the delete fails for some Customers?

Common reasons:

• Some customers may be restricted by QuickBooks based on how they are linked or recorded

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

What if you deleted the wrong Customers?

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

Video Tutorial for Deleting Customers in QuickBooks Online: