Skip to main content
September 9, 2024
Question

Product List import From Excel Spreadsheet

  • September 9, 2024
  • 1 reply
  • 0 views

I wanted to change all my products (which are all services and non-inventory) to be under more specific sales accounts that I just made. So, I exported all the products to update in excel, and then reimported them with their new sales accounts implemented. Afterwards, I noticed that every item was properly updated when I looked them up under the "Products/Services" tab. The problem is that none of the historical transactions with these items have changed accounts. I'd really like to be able to see all my past sales under these new accounts so that I can analyze the revenue centers of my company with greater detail.

 

What did I do wrong? Is there any way to update my historical data?

1 reply

September 9, 2024

Thanks for reaching out here in the Community space, @TynanF. I'll share information about making changes to the income account of the service or non-inventory item and how to affect previous transactions inside QuickBooks Online (QBO).

 

When updating the income account of an item inside the Products and Services page, you'll want to tick the box beside the Also update this account in historical transactions. Doing this will ensure they get posted to your preferred income account. We'll outline the steps below to get you going:

 

  1. Access your QuickBooks Online company.
  2. On the top right corner, click the Gear icon and select Products and services.
  3. Locate the service or non-inventory product that you wish to edit.
  4. Click Edit and then in the Income account field, choose your preferred posting account.
  5. Tick the box beside Also update this account in historical transactions.
  6. Once done, click the Save and close button.

 

If it doesn't affect the previous transactions, you'll want to change the income account and modify it to your preferred account. For more details, please see this page: Change the account for a product or service item in QuickBooks Online.

 

In addition, here are articles to help you manage accounts in your chart of accounts and keep track of your inventory items inside QBO:

 

 

If you need assistance managing previous transactions or inventory items inside QuickBooks, visit us anytime or comment below. As always, our team is ready to help you out again. Stay safe.