Changing multiple bill payments individually in QuickBooks Desktop can take a lot of time, particularly when you need to fix payment dates, accounts, references, or other details.

SaasAnt Transactions Desktop allows you to export Bill Payments, modify the necessary fields in Excel, and then import them again. This blog outlines the process for editing Bill Payments.

Video Tutorial for How to Edit Data in QuickBooks Desktop using SaasAnt Transactions Desktop:

What do you need before you start?

• QuickBooks Desktop company file is open

• SaasAnt Transactions Desktop is connected to QuickBooks Desktop

• You have access to the Bill Payments records you want to edit

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

How do you export the Bill Payments records you want to edit?

1. Open SaasAnt Transactions Desktop.

   

2. Go to Export.

   

3. Select Bill Payments 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 Bill Payments 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

FAQ

1) Can I edit Bill Payments in QuickBooks Desktop?

Yes. QuickBooks Desktop lets you open a single Bill Payment and modify the details that can be changed. If you want to update several Bill Payments at once, SaasAnt Transactions Desktop offers a bulk update feature.

2) How does SaasAnt help edit Bill Payments in bulk?

SaasAnt Transactions Desktop allows you to export current Bill Payments to Excel, modify the necessary details, and then import the updated file using the Update feature.

3) Do I need to export Bill Payments before updating them?

Yes. Exporting the current records gives you the transaction details required to correct and update the related Bill Payments in QuickBooks Desktop.

4) When should I enable the Update option?

Turn on the Update option when you import an edited file with existing Bill Payments that you wish to change in QuickBooks Desktop.

5) What happens if I do not select the Update option?

Without selecting the Update option, SaasAnt may process the file like a normal import instead of updating the existing transactions. Always confirm this option before moving forward.