Solved

If you raise a product sales invoice, is it possible to change the sales code the product has been allocated to afterwards?

Forum|Forum|5 years ago
February 23, 2021
3 replies
6 views

No text available

QuickBooks Accountant Online

Best answer by AlexV

Let me share more details about invoices, Roxror.

Once you create an invoice, it'll automatically affect the Accounts Receivable and the product's Income Account.

The best way to reflect it on the different income accounts is to set up three cabbages (products) and three income accounts. Then, assign each cabbage to their respective income accounts.

For easier tracking, you can create subaccounts in your Chart of Accounts. Also, here's how to add product and service items to QuickBooks Online. If you want to edit the items, you can go back to the Products and Services tab and update them at any time.

Need more help? Just post again here. Take care!

R

ReymondO

Moderator

It's great to see you here in QuickBooks Community, @Roxror.

Yes, you can still undo the sales tax code in your invoice. All you have to do is to open the transaction again and change it from there. Let me show you how:

Go to the Sales menu and select Invoices.
Look for the transaction, then click it to open the Invoice window.
Click Edit invoice and update the sales tax rate.
Select Save.

Please take note that you will be prompted once the invoice is already paid. Changing it will also affect your customer's balance.

I'd recommend reaching to your accountant for further guidance before taking this action. However, if the transaction isn't yet paid, you can always reopen it and apply your changes.

For more details, you can check out this article on how QuickBooks Online automatically tracks your sales tax using the Tax feature.

Additionally, there are several financial reports you can run to track your sales income in QuickBooks. They will show you helpful insights on the things you buy and sell, and the status of your inventory.

Let me know if you need further assistance with this. I'm always around to provide answers and clarifications to your questions. Have a great day ahead and take care.

L

Lvdm

No, i do not want to update a specifuc invoice, i want the labour and transport on my products and services to change the price for every customer onward from today. The is now more for transport abd labour. How do I change that??

N

NerbynMaeI

QuickBooks Team

Hi there, Lvdm.

I noticed that one of my colleagues has already shared an efficient solution to address your issue. To make this easier, I’ve included the link to their suggestion here: Solved: Re: If I want to change the price of a service without affecting past sales, should I create a new service item with the new price or can I just change the sales price? | QuickBooks Community

If you have any additional questions, please don't hesitate to reply below.

R

RoxrorAuthor

Hi, Thank you however that wasn't what I meant.

When you create a product in QB you set it to a sales nominal code such as Sprout Sales for example. What I would like to know is once that sales invoice has been raised, is it possible to change that Sprout Sales code to Lettuce Sales for example?

M

Maybelle_S

QuickBooks Team

Thanks for providing more information, @Roxror.

We can change the income account from Sprout Sales code to Lettuce Sales to the item used on the invoice. Also, there's an option to update historical transactions depending on the item used on the invoice (service, non-stock, or stock item).

Here's how:

Go to the Gear icon, and then select Products and Services.
From the Action column of the appropriate item, select Edit.
Select the Income account drop-down arrow.
Choose the account you want to use.

Check out this link for more information: Change the account for a product/service item. It also provides step if you want to update past transactions.

I've also added these articles about adding and changing product items in QBO:

You can always back to me if you have other questions. I'm always happy to help. Take care!

R

RoxrorAuthor

Thank you for your further help, however I don't think I am explaining myself properly.

A Product is assigned a sales code from the chart of accounts.

When a product sales invoice is raised, the sales code in the COA is where the entry is posted.

If I have one product that I wish to allocate to more than one sales code in the COAs, is this possible.

For example, I sell cabbages via the internet, via wholesale and on a market.

I wish to see the sales of cabbages split in my Tb as follows:

Sales Internet

Sales Wholesale

Sales Market

Can I do this or do I need to journal the transactions to the correct sales code?

Or

Do I have to set up 3 different product codes for cabbages - as follows:

Cabbages Internet

Cabbages Wholesale

Cabbages Market

AlexVAnswer

Level 10

Let me share more details about invoices, Roxror.

Once you create an invoice, it'll automatically affect the Accounts Receivable and the product's Income Account.

The best way to reflect it on the different income accounts is to set up three cabbages (products) and three income accounts. Then, assign each cabbage to their respective income accounts.

For easier tracking, you can create subaccounts in your Chart of Accounts. Also, here's how to add product and service items to QuickBooks Online. If you want to edit the items, you can go back to the Products and Services tab and update them at any time.

Need more help? Just post again here. Take care!

Sign up

Login with SSO

Let's get you signed in

Login with SSO

Scanning file for viruses.

This file cannot be downloaded