How to batch update transactions in QuickBooks

You can use Zed Axis to batch update,  edit and append to transactions in QuickBooks.  It is possible to export transactions to Excel, modify those transactions using the powerful editing features in Excel like search and replace or copy down, and then re-import those updated transactions back into QuickBooks selecting the option to modify the existing transactions.  This feature goes beyond what is possible in the client data review feature in QuickBooks by including many more types of transactions and fields that can by updated.
 
modify options
 
The options available are when importing, (the identifier used for all transactions is the transactions reference number (DocNumber for QuickBooks Online)
  • Duplicate - if a match is found Axis will create another transaction with the same reference number.
  • Skip -  if a match is found Axis will skip that transaction and will continue with the import.
  • Modify - If a match is found Axis will modify the transaction and replace the line data wih the data being imported (important read the notes below for more about modifying)
  • Append - if a match is found Axis will append the imported data to the existing transaction (ie retain existing rows) (QuickBooks Desktop only)
 
Watch the demonstration of this process below
 
Please note the following when using Zed Axis to modify transactions:
 
  • We recommend that you backup your company data file prior to doing a large batch modify as it cannot be undone.
  • Modifying an existing transaction will undo any linking that transaction has with other transactions, so for example payments will be un-applied and links to sales order, estimates will change.
  • It is very important that you map the transaction reference number as that is how Zed Axis identifies the transaction to modify, in some instances there may be duplicate reference numbers in which case Axis will modify the first transaction that it finds with the matching reference number.
  • When modifying you need to map all the line fields that you wish to appear, as when modifying the transaction Axis first deletes the line content and replaces it with what is being imported.

Feedback

Add Feedback
So if I already know what exact invoices I need to update, can I just imported it again with the same invoice number without exporting it out first? Many thanks, yu
Yu Wu (October 17, 2013 at 10:03 AM)
Yes that is possible, but please make sure that you map the line detail in as we replace that when we do a modify.
Steve (February 11, 2014 at 6:23 PM)
Can I do same thing to modify the employee list?
Shawn He (February 8, 2016 at 5:23 PM)
I have a year's worth of invoices that I need to update the ship-to addresses for. What is the best way to do this? Can I just update or append from an excel spreadsheet that contains the invoice number and the 5 ship-to address lines?
Joe Masciangelo (August 29, 2016 at 4:58 PM)

Add Feedback