Skip to main content

SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends 8/27

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
lindak1119
Level 7
Jan 27, 2019 4:52 PM UTC
Question

I found an item product code with a WRONG Income Account. I changed the income account however my past transactions were not updated. How do I change past in bulk

No text available

9 replies

mazar
Level 6
Jan 27, 2019 5:07 PM UTC

Hello,

 

This is very easy, no worries.

 

Go back to the item that had the wrong income account.  Change it back to the incorrect income account and save it.

 

Then go back and edit it again.  Change it to the correct income account BUT..... BEFORE you click save, check mark the box below that says "Update for Historical Transactions" . Then click save.  Now it will be updated in all your past transactions.

    inhoso
    Mar 10, 2020 3:42 PM UTC

    So if I change the item to different account, it would only affect the data going forward if I don't check mark "Update the Historical Transaction"?

     

    I want to make sure our historical stays the same as we made AJEs to correct that in the past.

     

    Thanks

    JasroV
    JasroV
    Level 8
    Mar 10, 2020 4:38 PM UTC

    You got it right, @inhoso.

     

    Ensure to put a checkmark inside the box beside Also update this account in historical transactions. This way, it'll update all your past transactions that are linked to the item. 

     

    However, if it's associated with an inventory item, you'll want to change the new inventory item manually on each transaction.

     

    For more details about changing account for product/service item in QuickBooks Online (QBO), you can refer to this great article: Change the account for a product/service item.

     

    Then in case you need to merge your product/service in QBO, check this article for the detailed steps: Remove or merge a product or service.

     

    You're always welcome to post anytime you need more help. The Community is here to help.

    SmartSupply
    Oct 21, 2020 5:53 PM UTC

    Hello everyone.

    We are using Premier Manufacturing.

    Up until now, all sales transactions were affecting a unique Sales, COGS, and Inventory accounts (system default).

    We decided to split them into 4 different categories for  Sales, COGS, and Inventory (all sub accounts of the main ones). Our system has over 10,000 items

    We understand changing the accounts one item at a time will trigger the option to affect past transactions; and that is exactly what we want to do. But one by one will take forever.

     

    Going through the Inventory List, there is an option to edit multiple items at once, but it does not prompt the option of affecting past transactions, only future ones.

     

    Would anybody know if there is a way to mass change the accounts AND to do it in a way that also alters past transactions ?

     

     

    Thank you !!

    JenoP
    JenoPQuickBooks Team
    QuickBooks Team
    Oct 21, 2020 8:14 PM UTC

    Hi there, SmartSupply.

     

    For now, we're unable to affect the changes on past transactions if you're editing the income account through the Add/Edit Multiple Items feature.

     

    You'll want to go over the item one at a time through the List window, so you'll get the prompt to update all existing transactions. 

     

    Let me share these articles and quick guides about managing inventories in QuickBooks Desktop:

     

    Let me know if you have other questions. We're always here to help.

     

     

    Need QuickBooks guidance?
    Log in to access expert advice and community support instantly.
    Terms & ConditionsAccessibility statement