Skip to main content
November 27, 2024
Question

Is there a batch tool in quickbooks to reclassify transactions? I'd like to add locations to data in batch.

  • November 27, 2024
  • 2 replies
  • 0 views
Original commenter did not share additional details

    2 replies

    November 27, 2024

    Hi there, @LORI11_2.

     

    Thanks for bringing your concern to the Community.

     

    Yes, QuickBooks Online (QBO) offers a batch tool for reclassifying transactions and adding location information. However, this feature is exclusive to certain subscriptions like the Accountant and Advance versions of QBO. This enables users to reclassify transactions in bulk, including accounts and classes. However, it might not support batch addition of locations unless location fields are already present in the transactions you intend to update. Here's how:

     

    In QuickBooks Online Accountant, you can access your client's QBO company, navigate to Accountant Tools, and choose Reclassify Transactions.

     

    To reclassify transactions for QuickBooks Online Advanced, follow the steps below:

     

    1. Open your QuickBooks Online account.
    2. Go to Settings and select Reclassify Transactions.
    3. Use the Account types dropdown menu to choose Profit and Loss for income and expense accounts, or Balance Sheet for asset, liability, and equity accounts.
    4. From the Account list, select the account containing the transactions you wish to modify.
    5. Apply filters such as type, class, customer/vendor, and modify filters for refining the list.  
      Tip: Select Accrual for all paid and unpaid transactions, or Cash for only paid transactions.
    6. Click Find Transactions.
    7. Check the box for each transaction you intend to change. 
      Important: Ensure there's a customer or vendor before moving transactions to Accounts Receivable or Accounts Payable. Avoid leaving these fields empty.
    8. Click Reclassify.
    9. Choose a new account for the transactions from the Change Account to dropdown, a new class from the Change Class to dropdown, or a new location from the Change Location to dropdown.

    Note: If Change Location to is not visible, you may need to set up locations for your account.

    When ready, click Apply.

     

     

     

    Please know that the reclassify tool is also available for your firm's transactions in QuickBooks Online Accountant. On your firm's page, select Accountant Tools and Reclassify Transactions.

     

    Furthermore, you can browse this page to learn how to use the reclassify transactions tool to batch edit transactions in QBO: Learn how to use the reclassify transactions tool to batch edit transactions.

     

    If you want to keep track of each segment in your business, you run reports by class and customize them. I'm adding these articles as your guide:

     

     

    Feel free to reach out if you have any more questions about the batch tool for reclassifying transactions and adding location information in QuickBooks Online. Wishing you all the best, and have a fantastic weekend, Lori!

    November 29, 2024

    I am using QB Plus are there any options for that version to do bulk update of location?

    Thanks,

    Lori

    PS this was my first question to the community I'll make sure next time to include what version I am using.

    FishingForAnswers
    November 27, 2024

    @lori.williams  You did not specify whether you were using Desktop or Online in this thread.

     

    To add to what @Shania_C  said, this functionality is also available in QuickBooks Accountant Desktop.

    November 29, 2024

    Apologies I didn't include!  I'm using QB Plus.  My first post to the community I'll be sure to include next time.  Thanks!!

    November 29, 2024

    I appreciate you getting back and providing more details about your query, Lori. I'm here to supply information about modifying bulk locations or reclassifying transactions inside QuickBooks Online (QBO).

     

    As my colleague mentioned in the thread, the option you're trying to access is only available in the Advanced version of QBO. Thus, it's not on the list of features that you can use within QBO Plus. If you wish to upgrade to the higher version to utilize the Reclassify transaction Tool, I can outline the steps to get you going:

     

    1. Access your QuickBooks Online company as a primary or company admin.
    2. On the top right corner, click the Gear icon and select Subscriptions and billing.
    3. Make sure your payment info is up to date.
    4. In the QuickBooks Online section, select Upgrade your plan.
    5. Review the available plans and then select Choose plan.
    6. Follow the on-screen steps to upgrade your plan.

     

    For further guidelines, refer to this page: Upgrade or downgrade your QuickBooks Online edition.

     

    You can refer to the screenshot below for visual reference: 

     

    Once done, you can visit this page to learn more about the reclassify transactions feature: Reclassify or move multiple transactions in QuickBooks Online Accountant and Advanced.

     

    I'm providing this article for when you generate reports to track classes. These resources will allow you to add more details while keeping your current settings for future reference:

     

     

    Need assistance ensuring the transaction you've recorded in your QBO company is accurate? Our QuickBooks Live Expert Assisted can offer tips and guide you in streamlining the process of reclassifying them inside the program.

     

    You can comment below if you have other questions regarding reclassifying transactions or performing specific tasks inside the program. Rest assured, I'll be here with the details needed to sort queries. Keep safe.