You can use Zed Axis to batch update or edit 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 reimport 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.
Watch the demonstration of this process below
Article ID: 164, Created On: 11/15/2011, Modified: 11/15/2011