cancel
Showing results for 
Search instead for 
Did you mean: 
camille3
Level 1

How to change "Account" from an invoice? I have 2 invoices that QB Online placed the wrong COA to. How do I change the account? I see no place in invoice to change it.

 
Solved
Best answer November 22, 2019

Best Answers
Rustler
Level 15

How to change "Account" from an invoice? I have 2 invoices that QB Online placed the wrong COA to. How do I change the account? I see no place in invoice to change it.

You can not do that from the invoice

QB works on items, each item has a selection you make to determine what account is posted to, you have to that from the item in the products & services menu under the gear

View solution in original post

41 Comments 41
Rustler
Level 15

How to change "Account" from an invoice? I have 2 invoices that QB Online placed the wrong COA to. How do I change the account? I see no place in invoice to change it.

You can not do that from the invoice

QB works on items, each item has a selection you make to determine what account is posted to, you have to that from the item in the products & services menu under the gear

DEBW2020
Level 1

How to change "Account" from an invoice? I have 2 invoices that QB Online placed the wrong COA to. How do I change the account? I see no place in invoice to change it.

If  you change Account number in product and services does it change it on the invoice?

 

MadelynC
Moderator

How to change "Account" from an invoice? I have 2 invoices that QB Online placed the wrong COA to. How do I change the account? I see no place in invoice to change it.

Yes, it will changed @DEBW2020.


Once you change the account under the Product and Services, it will automatically update the transaction to the latest account set up.


You run can Transaction Journal report to see the accounts affected to every transaction you created. Here’s how:

 

  1. Open a transaction.
  2. Click More at the bottom.
  3. Choose the Transaction journal.

To view important details of your finances and learn more about report features, you can always run a report in QuickBooks Online. 


If you have additional concerns, just let me know. I’m always here ready to help.

edevries50
Level 1

How to change "Account" from an invoice? I have 2 invoices that QB Online placed the wrong COA to. How do I change the account? I see no place in invoice to change it.

I make the changes to the Products & Services but it does not change on the income statement. Is there an additional step?

Anna S
QuickBooks Team

How to change "Account" from an invoice? I have 2 invoices that QB Online placed the wrong COA to. How do I change the account? I see no place in invoice to change it.

Allow me to chime in, @edevries50.

 

When you update the product/services settings, a checkbox should appear: "Also update this account in historical transactions." If you don't see this message, then you might need to change the account, save the product/service, and then change it back to the correct one. I've included a screenshot below to show you where the message is:

 

 

You can also check out this article for more information: Change the account for a product/service item.

 

Feel free to comment below if you have any other questions or concerns. Take care!

AngelBK
Level 3

How to change "Account" from an invoice? I have 2 invoices that QB Online placed the wrong COA to. How do I change the account? I see no place in invoice to change it.

I am recording an invoice for a payment for a sublease.  This is being recorded on the P&L as a service under income, but I want it to be classified as a sublease expense.  Is there a way change the General Ledger account in invoicing?

Tori B
QuickBooks Team

How to change "Account" from an invoice? I have 2 invoices that QB Online placed the wrong COA to. How do I change the account? I see no place in invoice to change it.

Hey there, @AngelBK

 

Thanks for following the thread. 

 

To clarify, do you mean to change the account from which the payment is deposited into? Or do you mean from the invoice directly? If you mean the invoice, then you'll need to change the accounts in which the items are associated with. The invoice only connects to the accounts through the item/service you're using for them. Whereas, the account in which the payment is deposited into would be changed from the payment screen. 

 

While I await your response, check out the steps I've included below for both scenarios.  

 

To change the account from the payment screen:

 

  1. Go to the invoice that you wish to update the account.
  2. Click on the Receive payment drop-down button. 
  3. Select View/Edit.
  4. Change the account from the Account drop-down.  
  5. Hit Save

To change the account the item/service is associated with:

 

  1. From the Gear icon, choose Products and Services.
  2. Find the item or service you want to change.
  3. Select Edit in the Action column.
  4. Make your changes.
  5. Once you're done, hit Save and close.

Here are a couple of articles that go into more details:

 

I look forward to your response. Please let me know if you have additional questions or concerns. You can reach out to the Community at any time. Take care!

 

amarcano
Level 1

How to change "Account" from an invoice? I have 2 invoices that QB Online placed the wrong COA to. How do I change the account? I see no place in invoice to change it.

Hi, I already change the account in the service icom and saved it, it did not showed the check box to update historical transactions, so ones i saved it I went to Profit and losses report and it did not change to the new account. What can I do?

DivinaMercy_N
Moderator

How to change "Account" from an invoice? I have 2 invoices that QB Online placed the wrong COA to. How do I change the account? I see no place in invoice to change it.

I'm here with some instructions that make changing the account for your products a breeze, @amarcano.

 

To update the past transactions when changing the account for your product or service item, you have to check the box for Also update this account in historical transactions option. Here's how:

 

  1. Go to the Sales menu and select Products and services
  2. Look for the item you'll need to update. Then click Edititem1.JPG
  3. If you don't see the Also update this account in historical transactions box under the Sales price/rate field. Do the next step. 
  4. In the Income Account drop-down, type the name of the correct account or any account in the list. For example, enter the word "income"
  5. Once you click an account, the Also update this account in historical transactions checkbox will appear.
  6. Check the box.
  7. Then, go back to the Income account drop-down and choose the correct account. 
  8. When finished, hit Save and close to confirm the action. item2.JPG

 

Here's the article that will provide info about the process: Change the account for a product/service item

 

Also, you can pull up inventory reports in QuickBooks Online to see your best selling items, what’s on hand, the cost of goods, etc. 


Don't hesitate to post again here if you have any other concerns about changing the accounts of your product items in QBO. I'm always here to help. Have a great day ahead.

AngelBK
Level 3

How to change "Account" from an invoice? I have 2 invoices that QB Online placed the wrong COA to. How do I change the account? I see no place in invoice to change it.

Hi,  thank you for your help.  To explain further this isn't an income account because it is a sub lease.  The CPA wants to go to the checking account and the expense account Sub Lease/. I hope that this makes since?

Moto155
Level 1

How to change "Account" from an invoice? I have 2 invoices that QB Online placed the wrong COA to. How do I change the account? I see no place in invoice to change it.

Hello,

 

I don't see the update historical box when changing the income account.  I would like to change this in historical transactions but that option doesn't appear in the dialog box.  

Kristine Mae
Moderator

How to change "Account" from an invoice? I have 2 invoices that QB Online placed the wrong COA to. How do I change the account? I see no place in invoice to change it.

Let me share how it works, Moto155.

 

The feature to update historical transactions is available for service and non-inventory items only.

 

If you're trying to change an inventory item, you'll have to toggle the transactions manually. This way, our program will recognize the new income account. Here's how:

  1. Open the sales transaction.
  2. Switch the item to a different one.
  3. Change it back to the original item, then click Save and close. 

Once done, you can pull up the Profit and Loss report and check if the transactions are added to the new income account. 

 

Reach out to us again if you have other concerns. We're around 24/7 to help you. Take care!

Doreen9159
Level 1

How to change "Account" from an invoice? I have 2 invoices that QB Online placed the wrong COA to. How do I change the account? I see no place in invoice to change it.

Hello!

 

I need to go back into 5 invoices and direct them to a different account. They were somehow pointed to cost of goods sold and it is giving me a negative number on my profit and loss report.

 

I have tried literally EVERYTHING! PLEASE HELP!!

Mark_R
Moderator

How to change "Account" from an invoice? I have 2 invoices that QB Online placed the wrong COA to. How do I change the account? I see no place in invoice to change it.

Your confusion ends here, @Doreen9159.

 

The possible reason why your invoices are associated with Cost of Goods Sold (COGS) is that you have COGS as an expense account and then created the invoice. That said, it won't change the account when changing the items to the invoice transaction and causing a negative amount on your profit and loss report. To get this fixed, you'll want to delete and recreate the invoices to allocate the correct account. Here's how:

 

  1. Find and open each of the invoices you want to update.
  2. Click More, then select Delete.1.PNG
  3. Select Yes to confirm.
  4. Once done, recreate the invoice with the updated item.

 

You might want to check out this article to learn more about the impacts of inventory tracking on balance sheet and profit & loss reports.

 

Please let me know if you need clarification about this, or there's anything else I can do for you. I'll be standing by for your response. Have a great day.

Doreen9159
Level 1

How to change "Account" from an invoice? I have 2 invoices that QB Online placed the wrong COA to. How do I change the account? I see no place in invoice to change it.

Thank you! I will work on this today and let you know if I still have questions!

angel16
Level 1

How to change "Account" from an invoice? I have 2 invoices that QB Online placed the wrong COA to. How do I change the account? I see no place in invoice to change it.

Hi,

The transaction journal enters the invoice into our Gift Card Receivable account.  Is there a way I can change it to another receivable account?  Thank you.

Jen_D
Moderator

How to change "Account" from an invoice? I have 2 invoices that QB Online placed the wrong COA to. How do I change the account? I see no place in invoice to change it.

Hello, @angel16,

 

Joining the thread to share some more information on how QuickBooks Online post transactions to respective accounts.


QuickBooks Online uses the Source and Targets concept. For example, when you create an expense for an inventory, the source of the information is the Products and Service page where you initially assign accounts.

 

These accounts you assign to the items or categories on transactions will determine the transaction journal posting.

 

Since the entry will use the data from its source, you need to update the accounts used on the items. You can follow the steps shared by my colleagues in this thread.

 

Learn more about inventory or products and services tracking in QBO using the links below:

 

 

Let me know if you have other questions about this. I'll be right here if you need anything else. Have a good one!

zilch000
Level 1

How to change "Account" from an invoice? I have 2 invoices that QB Online placed the wrong COA to. How do I change the account? I see no place in invoice to change it.

Need Help - Read the previous posts but it does not fix the issue I am trying to solve - which is the following:

Previously - We had one Income stream and sales invoices were all registered under the same account SalesIncome
then we added two new revenue streams SalesIncome01 and SalesIncome02 and SalesIncome became a parent category for SalesIncome01 and SalesIncome02

How can I migrate old invoices showing under account SalesIncome to exclusively SalesIncome01 or SalesIncome02

When updating the Income Account under Sales > Product/Services we missed to click on 
"Also update this account in historical transactions"
Note. Deteling invoices and recreating it is not an option, hundreds of them linked to received payments.

Thank you. Hope you can help.

Catherine_B
QuickBooks Team

How to change "Account" from an invoice? I have 2 invoices that QB Online placed the wrong COA to. How do I change the account? I see no place in invoice to change it.

Hello there, zilch000.

 

I can help you update your items.

 

As mentioned by my colleague, Kristine Mae, The Also update this account in historical transactions option is available for service and non-inventory items only.

 

If you're trying to update these types of items, change the income account then switch it back to the correct one to trigger the option. Make sure that the Also update this account in historical transactions checkbox is already selected before you click Save and close.

 

For inventory items, the only way you can update existing or past transactions is to open each transaction and re-toggle and toggle the item for the changes to apply. 

 

You can check out these links to help you manage your product/services list: 

 

Let me know if there's anything else that you need. I'll be around the corner to help. Take care!

tennistown
Level 1

How to change "Account" from an invoice? I have 2 invoices that QB Online placed the wrong COA to. How do I change the account? I see no place in invoice to change it.

I changed the account in "products and services" but it did not change the account the previously created invoices have posted to. Still showing posting to the old account.

SarahannC
Moderator

How to change "Account" from an invoice? I have 2 invoices that QB Online placed the wrong COA to. How do I change the account? I see no place in invoice to change it.

Hello there, tennistown.

 

Once you change the account in Products and Services, it'll also update your previous transactions and historical accounts. As shared by my colleagues above, make sure to tick the Also update this account in the historical transactions box. 

If you're trying to update the inventory, you can change it directly. Then, make sure to click the Save and close button to reflect the changes.

 

In this situation, we can log in to your QBO account in a private browser to determine if it's the browser that is causing the old account to still show. To guide you further, please follow the steps below:

 

  1. Refresh your browser by clicking the Reload icon or pressing F5 on your keyboard.
  2. If the same thing happens, we can log in to your account through an incognito window. This mode doesn't store cache that's why we recommend using it.

 

If it works fine, we can clear the cache of your regular browser. This helps remove any browser-related issues and refresh your browser's settings. Aside from that, you can use other compatible browsers in QuickBooks Online. Below are the things that you can try on:

 

  • Mozilla
  • Google Chrome
  • Microsoft Edge
  • For Safari, make sure to use the latest one.

 

Once you’re done with the changes, you can run a report on the new account to see if your historical transactions have moved over. Here's how:

 

  1. Go to Accounting on the left panel.
  2. Within the Chart of Accounts tab, search the associated account of the item.
  3. Click Run report.

 

If you want to track your total sales for each product or service, you can refer to this article: Use reports to see your sales and inventory status.

 

Know that you can always go back in this thread if you ever need anything else with QuickBooks. I'll be around to back you up. Stay safe!

perminus
Level 1

How to change "Account" from an invoice? I have 2 invoices that QB Online placed the wrong COA to. How do I change the account? I see no place in invoice to change it.

what if the number of transactions are many and you dont see that option updating historical data

ShiellaGraceA
QuickBooks Team

How to change "Account" from an invoice? I have 2 invoices that QB Online placed the wrong COA to. How do I change the account? I see no place in invoice to change it.

Thanks for joining us here today, @perminus.

 

I have some information about changing an item's account. First, you'll want to make sure you're logging in as the account Admin. This way, you're able to see the Also update this account in historical transactions checkbox. Otherwise, the previous transaction's account will not be changed.

 

After that, go to the Product and Services page to change the account. Refer to @DivinaMercy_N's post for details.

 

Additionally, try signing in to your QuickBooks Online (QBO) account using a private or incognito window. This mode doesn't use the existing cache data and helps us confirm browser-related issues. Here's how:

  • For Google Chrome browser: Ctrl + Shift + N
  • For Mozilla Firefox browser: Ctrl + Shift + P
  • For Safari browser: Command + Option + P

 

That's all there is to it. In case you need help with other customer-related tasks, browse this link: Sales and customers.

 

Let me know how you get on after trying the steps, as I want to ensure this is resolved for you. Feel free to reply to this post and I'll get back to you as quickly as possible. Have a nice day ahead.

ccmagna1
Level 2

How to change "Account" from an invoice? I have 2 invoices that QB Online placed the wrong COA to. How do I change the account? I see no place in invoice to change it.

Hi, I do not get the box to check that changes previous invoices. How do I make the changes in that case. I have tried change the account under the chart of accounts, in the services in sales, and nothing will change where that income is going to. Help.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us