Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
We decided to change a couple of our product/services to be under a different income account/category.
After doing so, when running reports on those products, transactions are still showing up under the old income account/category. How do we fix this?
Hello there,
Let's run some steps to isolate the issue.
To start with, let's run the report using an incognito window. Incognito won't save your browsing history, which can result in unusual behavior.
You can use these keyboard keys to open one:
Also, you'll want to clear the cache and make sure you're using a supported and up-to-date browser. This can fix any browser-related issues.
From there, you can run the report again. I've added this article as your guide in customizing report: Modify report.
I'll be around whenever you have concerns about customizing report.
It's not customizing a report I have problems with. I changed the income account for a few products. However when I run the P&L or the Income account reports, transactions for those products have not changed to the new income account. I have already signed out, closed my browser, ran CCleaner and when I try the report again, those product transactions are still showing up in the old income account.
Hi there, SG_Commexis.
Thank you for doing the troubleshooting steps. Let me continue to help.
When you change the income account of an item and want to affect past transactions, you'll want to put a checkmark in the Also update this account in historical transactions checkbox. Please refer to the attached file.
What you can do now is temporarily change the income accounts of the affected items. Then, change them back to the final income account and make sure to put a check in the said checkbox.
On the other hand, we have helpful articles for QBO should you need some references in the future.
I'm just around if you have other questions in mind. Take care and have a good one!
Thanks for your reply, @SG_Commexis.
In the first instance, I appreciate you adding a screenshot to your concern. Let me clear things out so you'll be able to see the option in QuickBooks Online.
You can see the option once you've changed the Income account of your item. Then, the Also update this account in historical transactions box will appear. Please see the visual guide below for your reference:
You can visit this article for additional information: Change the account for a product/service item.
Moreover, I'll be adding this handy resource that can help you pull up reports that can give you a snapshot of your business and personalize them to modify the information according to your needs.
I’m always ready to assist you if you have any other questions or concerns about managing your items in QBO. Thanks for dropping by, wishing you a good one.
I have the same problem. I have changed the income account in the Product section BUT DO NOT have the option to update previous transactions. Please help!
Hi there, Christi11.
Please know that the option Also update this account in historical transactions checkbox is only available for Service and Non-inventory products. With this, the said checkbox doesn’t appear if you're changing an Inventory item and this could be the reason why you don't have the option to update previous or historical transactions.
Furthermore, only new entries are affected when you adjust the income account for inventory items. To update previous transactions, I recommend creating a new item with the appropriate income account and replacing the old item with it.
Here's how:
You can repeat this process for any previous transactions you want to update. Then, you can open this article to see further details: Change the account for a product/service item.
Lastly, you may refer to this article to see steps on how you can make items inactive in QBO so they don't show up on sales forms, lists, or financial reports anymore: Add product and service items to QuickBooks Online.
Let me know if you have more concerns about managing your items in QBO, Christi11. I'm always around to help. Have a great day!
Hi - like others above us here , I am unable to see t he checkbox to update historical transactions.
I am definitely only interested in SERVICE items and we dont ever track stock.
Seems to me that many people are having this problem, does it depend what QB we are using? I am Online, more than that I dont know?
Thank you for dropping by the Community, @lionliver.
I am here to share some insights to help you find the checkbox to update your historical transactions.
If you are unable to locate the checkbox to update historical transactions even after following the troubleshooting steps provided by my colleagues. In that case, I suggest contacting our support team for further investigation.
Here's how:
Moreover, I'm adding this helpful article as your reference in managing your inventory: Set up and track your inventory in QuickBooks Online.
Let me know if you have further questions or concerns regarding service items and historical transactions. I'll be here to lend a helping hand.
I did check the box to include historical transactions, and that didn't work either.
Thanks for joining this thread, @Marfa. I'm here to assist you in changing the income account for your product or service items.
It's important to note that you can only change the account for an item once.
Since your past transactions aren't updating even after checking the Also update this account in historical transactions box, you can change the income account and then switch it back to the correct one.
Additionally, if you're changing the income account while opening a report, you can close the report and reopen it to check if the modifications were applied.
If the same thing happens, you can perform some troubleshooting steps. A cache-related issue is likely causing the situation. You can use a private or incognito window to rule out cache problems in your browser. Here are the shortcut keys:
After that, you can log in to your QuickBooks Online (QBO) account and change the income account of your item again. If it works, you can clear your browser's cache. This removes the webpage data that's causing the issue. If a private browser won't work, you can use other installed supported browsers.
Moreover, you can use this article as a guide to changing the income account for your items: Change the account for a product or service item in QuickBooks Online.
In case you want to organize your products and services, you can check out this article for more guidance: Group products and services into different categories in QuickBooks Online.
I'm still ready to back you up if you have any other concerns besides changing the income account of your items. Feel free to leave a reply to this thread. Have a great day!
Hi. I have the same issue, I edit the income account of a product but there is no option to tick " update historical transaction". Pls note this is service type not inventory.
Is it because of my subscription which is Essential only? If no, can you help this resolve?
Thanks for letting me know, @Marie. I'm available to help you by sharing some insights about finding the checkbox to update your historical transactions.
Since you're unable to locate the checkbox to update historical transactions even after following the troubleshooting steps provided by my colleagues. I recommend contacting our support team for further investigation.
Here's how:
Moreover, I'm adding this helpful article as your reference in handling your financial information: Run reports in QuickBooks Online.
Feel free to reach out if you have any more questions or require assistance with service items and historical transactions. I'm here to support you.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here