What does this article help you do?

This article shows you how to update existing service records in QuickBooks Desktop in bulk. This is useful when you need to correct or update multiple service records without editing them one by one.

What do you need before you start?

• QuickBooks Desktop company file is open

• SaasAnt Transactions Desktop is connected to QuickBooks

• You have access to the service records you want to edit

• It is recommended to keep a backup before making bulk changes

How do you export the service records you want to edit?

1. Open SaasAnt Transactions Desktop.

2. Go to Export.

3. Select Service in the QuickBooks Type field.

4. Choose the date type and date range if required.

5. Use filters if needed to narrow the records.

6. Click Search.

7. Review the records and click Download to export them to Excel.

How do you update the exported file?

1. Open the exported Excel file.

2. Update the fields you want to change.

3. Do not remove key columns from the file.

4. Save the file after making the changes.

How do you import the updated file back into QuickBooks Desktop?

1. Open SaasAnt Transactions Desktop.

2. Go to Import.

3. Select Service as the type.

4. Choose the edited Excel file.

5. Turn on the Update option.

6. Click Next and review the field mapping.

7. Continue to the review screen and verify the data.

8. Click Send to QuickBooks to update the existing records.

What should you keep in mind while editing?

• Update only the fields you need to change

• Keep the file structure unchanged as much as possible

• Review the data before sending it to QuickBooks

• Test with a small set of records first if needed

FAQs

How does SaasAnt edit existing service records?

SaasAnt exports the existing QuickBooks Desktop service records, lets you update them in Excel, and imports the edited file back with Update turned on.

Can I edit multiple service records at once?

Yes. You can update multiple service records in one file instead of editing them one by one in QuickBooks Desktop.

Do I need to export the service records first?

Yes. Exporting first helps you work with the existing records in the correct format.

What does the Update option do?

The Update option tells SaasAnt to update existing records instead of creating new ones.

Can I edit only a few fields and leave the rest as they are?

Yes. You can update only the required fields and keep the remaining values unchanged.