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

Video Tutorial for Editing Journal Entries 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

• You have access to the journal entry records you want to edit

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

How do you export the journal entry records you want to edit?

1. Open SaasAnt Transactions Desktop.

2. Go to Export.

3. Select Journal Entries 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 Journal Entries 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 journal entry records?

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

Can I edit multiple journal entries at once?

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

Do I need to export the journal entry 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.