Skip to main content
LeithG
LeithG
March 4, 2021
Solved

Edit / reclassify the account under a sale/invoice

  • March 4, 2021
  • 2 replies
  • 0 views

Hi guys

 

Recently, I decided to split my sales on my COA/Financials to show separately Sales - USD, Sales - CAD.

In attempting to edit historical invoices so they show under the correct categorization I cannot locate the option to change the account.

 

I've updated Product/Service to link to the new COA account, and the Customer to the sales item, but in attempting to edit the historical transaction to move it to Sales - CAD I cannot find a place to do that.

 

Any suggestions?

Best answer by JamesM4

Hello lashedlifter, 

It's great to hear from you. I trust that all is going well on your end. I'll be happy to steer you towards the right path with changing the account on your historical invoices. QuickBooks is a powerful program that enables you to get more work done and in less time. 

You can edit the account that the invoice is affecting by editing the payment account instead. To do this, you'll need to open the invoice in question, and on the top right side, you'll see a blue link that says 1 payment made. When you click on that link, you'll see an option to edit the account where that invoice is going. Let me know if this what you're referring to. You're more than welcome to send screenshots of what you're seeing so we're both on the same page. 

Since you've already updated the Product/Services link to the COA, it's important to note that this affects new transactions. If you'd like to update past transactions, you'll have to create a new item with the correct income account and use it to replace the old item. Here's how: 

  1. Navigate to Settings ⚙ and select Products and Services.
  2. Click New, then choose Inventory. Stock.
  3. Enter all the information needed. Make sure to select the correct income account.
  4. Hit Save and close.
  5. Go to the Sales menu, then select Invoices.
  6. Select the invoice you want to update.
  7. Click on the delete (trash can) icon at the end of the line of the old inventory item.
  8. Add the new inventory item, and enter the corresponding quantity.
  9. Select Save. You'll have to do this for the past transactions you want to update.

If past transactions aren't showing the changes, change the income account then switch it back to the correct one.

  1. Click on the Gear/Settings ⚙ and select Products and Services.
  2. Under the Action column of the appropriate item, select Edit.
  3. From the Income account ▼ drop-down, choose a different account.
  4. Click Save and close.
  5. Under the Action column of the same item, select Edit.
  6. From the Income Account ▼ drop-down, choose the correct account.
  7. Select the Also update this account in historical transactions checkbox.
  8. Select Save and close.

Let me know if this info helps. I'll be on standby in case you need anything else. 

2 replies

J
JamesM4Answer
March 4, 2021

Hello lashedlifter, 

It's great to hear from you. I trust that all is going well on your end. I'll be happy to steer you towards the right path with changing the account on your historical invoices. QuickBooks is a powerful program that enables you to get more work done and in less time. 

You can edit the account that the invoice is affecting by editing the payment account instead. To do this, you'll need to open the invoice in question, and on the top right side, you'll see a blue link that says 1 payment made. When you click on that link, you'll see an option to edit the account where that invoice is going. Let me know if this what you're referring to. You're more than welcome to send screenshots of what you're seeing so we're both on the same page. 

Since you've already updated the Product/Services link to the COA, it's important to note that this affects new transactions. If you'd like to update past transactions, you'll have to create a new item with the correct income account and use it to replace the old item. Here's how: 

  1. Navigate to Settings ⚙ and select Products and Services.
  2. Click New, then choose Inventory. Stock.
  3. Enter all the information needed. Make sure to select the correct income account.
  4. Hit Save and close.
  5. Go to the Sales menu, then select Invoices.
  6. Select the invoice you want to update.
  7. Click on the delete (trash can) icon at the end of the line of the old inventory item.
  8. Add the new inventory item, and enter the corresponding quantity.
  9. Select Save. You'll have to do this for the past transactions you want to update.

If past transactions aren't showing the changes, change the income account then switch it back to the correct one.

  1. Click on the Gear/Settings ⚙ and select Products and Services.
  2. Under the Action column of the appropriate item, select Edit.
  3. From the Income account ▼ drop-down, choose a different account.
  4. Click Save and close.
  5. Under the Action column of the same item, select Edit.
  6. From the Income Account ▼ drop-down, choose the correct account.
  7. Select the Also update this account in historical transactions checkbox.
  8. Select Save and close.

Let me know if this info helps. I'll be on standby in case you need anything else. 

LeithG
LeithGAuthor
March 5, 2021

Thanks James; after removing and replacing the item on the invoice with the modified one it worked as expected.  Not how I would have anticipated having to do it, but every software has its own idiosyncrasies.

Much appreciated.

L
LauraAB
March 5, 2021

I'm glad to hear what James suggested worked out for you. I hear what you're saying about it not being the expected solution, and I invite you to submit feedback about the process using the steps here: How do I submit feedback? As you may have seen me mention on other threads, this helps our product development team get a sense of the way folks would like to use the product and helps as we continue to evolve the software.

 

We also have a great new page, QuickBooks Online Feature and Product Updates, which you're welcome to bookmark to keep on top of changes made to the program.

 

Have a great weekend!

A
Ann38
March 10, 2021

Hi,

 

I recently started using QuickBooks online and I would like to transfer my January 2021 financial information from Connected by Accountek accounting system into QuickBook. What is the safest way for me to do this without having to enter all the transactions?

J
JamesM4
March 10, 2021

Hi Ann38. Connecting your bank to QuickBooks allows you to get a better view of your transactions. QuickBooks allows you to connect your bank and upload your transactions so you can put your financials into focus. I'd be glad to share more information about connecting your bank to QuickBooks. 

 

Here's how to connect your bank to QuickBooks:

  1. Click on the Banking menu.
  2. Select Link account.
  3. Search for the name of your financial institution.
  4. If QuickBooks is unable to find your bank, you will get the message, "Hmm, we can’t find [name of the bank you entered] in our list of supported banks," and you will be presented with helpful tips to try and locate your bank account.
  5. If you’re still unable to find your bank, select Request support for your bank.
  6. Enter your bank's web address (URL) in the field provided, then select Request.

After you submit your request to add your financial institution, you may be able to use one of the alternative methods for downloading and importing your bank transactions. Here are the alternative methods you can use to import your bank transactions:

After manually importing your transactions, you can now run powerful reports in QuickBooks. 

 

Let me know if this info helps. Feel free to reach back to me if you need anything else, I've got your back. 

Terms & ConditionsAccessibility statement