Use the SaasAnt Transactions Desktop to efficiently delete customers in QuickBooks Desktop. This approach enables accountants and bookkeepers to bulk remove inactive or duplicate customer records. By securely connecting to your company file, applying filters, backing up data, and confirming deletions, you keep your customer lists clean and your reporting accurate.

Prerequisites

• QuickBooks Desktop is set up, and the company file is accessible.

• Admin permissions for the company file are required.

• SaasAnt Transactions Desktop is installed.

• The company file must be opened in QuickBooks before you can connect.

How to Delete Customers in QuickBooks Desktop: Step-by-Step Guide

Step 1: Open the SaasAnt Transactions Desktop

• Download the latest SaasAnt Transactions Desktop version.

• Launch the SaasAnt Transactions Desktop, and connect to your QuickBooks company file.

Step 2: Connect to QuickBooks Desktop

• Go to the File menu

• Click Connect to QuickBooks, and allow access permission in QuickBooks when prompted.

• This secure link allows SaasAnt to read and adjust customers in the selected company file environment.

Step 3: Open Delete Module

• On the left panel dashboard, select Delete.

• This section is meant for deleting transactions in bulk.

Step 4: Search Customers

• Choose QuickBooks Search

• Set QuickBooks Type → Customers

• Apply filters, including date range or transaction criteria, to refine results.

• Click Search to view all customer records for review and deletion.

Step 5: Select the Customers to Delete

• The matching customers will show up in the results list

• Review and select the required customers with checkboxes

• Click Download (at the bottom-left) to save a backup as an Excel (.xls) or CSV file.

• Click Delete at the bottom right.

Step 6: Confirm Deletion

• A confirmation pop-up appears; carefully review the count and details.

• Click OK to proceed. 

• SaasAnt will permanently delete the selected customers from the QuickBooks Desktop company file.

Step 7: View Deleted Customers

• Deleted Customers appear in the SaasAnt dashboard

• You can download the deleted records using the Download option in Excel or CSV format.

To verify:

Open QuickBooks Desktop → Customers → Customer Center →  Customer & Jobs. Search for customers whose records you deleted.

FAQ

1) As an accountant, why would I delete customers in QuickBooks Desktop?

Deleting duplicate, inactive, or wrongly created customer records helps maintain clean master data and ensures accurate financial reporting.

2) How do I connect SaasAnt to QuickBooks Desktop?

Go to the File menu, choose Connect to QuickBooks, and authorize access permissions in the QuickBooks authorization window.

3) How do I search for customers?

Select QuickBooks Search, set the QuickBooks Type to Customers, apply the filters, and click Search to get the results.

4) Is it recommended to back up before deleting customers?

Yes, download the chosen records in Excel or CSV format to keep a backup before they are permanently deleted.