How to Modify Existing Expense Transactions (Bill, Expense, Check, Vendor Credit, Bill Payment) in QuickBooks Online?

January 1, 2025

There may be situations where you need to update your existing expense transactions (Bill, Expense, Check, Vendor Credit, Bill Payment) in QuickBooks Online.


You can modify the existing expense transactions in QuickBooks Online in two ways using the SaasAnt Transactions (Online) application.

Method 1: Using your own File

Method 2: Export and Modify


1) Using your Own File

The files should have Reference No like Bill No, Check No, or Expense No. SaasAnt Transactions (Online) finds the relevant transactions by this reference no. If you believe that, there would be some duplicates for the same reference no, then proceed to the alternate method of update.

Step 1: Click on the MODIFY menu and upload the file.

Step 2: Map the Ref No and other fields in the Field mapping screen.

Step 3: Review and Upload.

2) Export and Modify

It is possible that you may not have to reference any in your transactions in QuickBooks Online. E.g. Bill Payments. Please follow the below steps if you don't have a reference number. It is the best approach to avoid any manual errors.


Step 1: Click on Export Menu.

st245.png

Step 2: Search for a particular date and download the file.

st246.png

Step 3: Make changes to your transactions (Date changes, amount changes,etc..)

st247.png

Step 4: Click on MODIFY Menu.

st248.png

Step 5: Upload the File.

st249.png

Step 6: Review & Upload.

st250.png

st251.png

st252.png

FAQs

  • Will it add more Line Item Details in QuickBooks or replace it? 

           It will replace it. So please provide all ACCOUNT and PRODUCT LINE ITEM DETAILS.


  • I just want to update the incorrect date, shipping address in QuickBooks. Do I need to provide and map all the details like Line Items and etc.?

          You need to. It will be replaced. So please provide all details about the Transactions.

Automated data Import / Export to QuickBooks Online
Say goodbye to the hassle of managing transactions manually
Grow exponential with Clear Financial Visibility