After a recent import products are not showing as taxable anymore

userbeveragesunlimit · ‎January 05, 2022

Yesterday we did an import to update the quantity on hand for 270 products. Today, these same 270 products are no longer showing as taxable. Invoices are therefore incorrect and we are having to manually add the green checkmark within the invoice that contains any of these products.
The products still show as taxable (when you click to edit them) but you don't see the green checkmark on the Products/Services page.

JasroV · ‎January 05, 2022

Great job in importing your products, @userbeveragesunlimit.

I also appreciate you for sharing an update with us. To steer away from any issues in importing your product and services, You'll want to ensure you've map your imported files correctly and select Yes in the Taxable column. This way, it'll automatically show as taxable in your QuickBooks Online (QBO) account. I'll show you how.

Go to the Gear icon, and select Import Data.
Select Products and Services.
Click Browse to upload the file from your computer. Choose the file, and then select Open.
Select Next.
Map your information, and select Next.
If you see some cells highlighted in red, this means the cell is invalid. Check the cell in your spreadsheet and try importing again.
Select Yes in the TAXABLE column to make the product/service taxable.
Click Import.

On the other hand, you can adjust your stocks without importing them. You can refer to the steps outlined in this article for details: Adjust inventory quantity on hand in QuickBooks Online.

Furthermore, I'm adding this link that you can read for reference in seamlessly tracking your inventories: Set up and track your inventory in QuickBooks Online.

If you need more help with inventories or with your QBO account, you can always tag me in your reply. I'll be more than happy to help you anytime. Have a good one!

View solution in original post

userbeveragesunlimit · ‎January 05, 2022

Just to add something to this post...If we edit one of these products and simply save and close (without changing anything), the green checkmark appears again.

JasroV · ‎January 05, 2022

Great job in importing your products, @userbeveragesunlimit.

I also appreciate you for sharing an update with us. To steer away from any issues in importing your product and services, You'll want to ensure you've map your imported files correctly and select Yes in the Taxable column. This way, it'll automatically show as taxable in your QuickBooks Online (QBO) account. I'll show you how.

Go to the Gear icon, and select Import Data.
Select Products and Services.
Click Browse to upload the file from your computer. Choose the file, and then select Open.
Select Next.
Map your information, and select Next.
If you see some cells highlighted in red, this means the cell is invalid. Check the cell in your spreadsheet and try importing again.
Select Yes in the TAXABLE column to make the product/service taxable.
Click Import.

On the other hand, you can adjust your stocks without importing them. You can refer to the steps outlined in this article for details: Adjust inventory quantity on hand in QuickBooks Online.

Furthermore, I'm adding this link that you can read for reference in seamlessly tracking your inventories: Set up and track your inventory in QuickBooks Online.

If you need more help with inventories or with your QBO account, you can always tag me in your reply. I'll be more than happy to help you anytime. Have a good one!

userbeveragesunlimit · ‎January 05, 2022

Thanks for the reply.

If I only needed to update the quantity on hand, I still need to include on my excel import document "taxable"? I wasn't making any changes as to whether a product was taxable or not. My excel document didn't have cost or sales price, yet those fields didn't erase from the product.

Kurt_M · ‎January 05, 2022

I appreciate you for posting this here in the Community, @userbeveragesunlimit. Allow me to share some information about your concern.

You can find that you have an incorrect amount of inventory items than QuickBooks Online (QBO) indicates. In this case, you can manually edit the amount to match your actual stock without recording a purchase or sale.

In your case, you will have to manually update the quantity on hand without using the import or table option.

To begin with, these are the steps:

Select + New and then click Inventory Qty Adjustment.
Enter the Adjustment Date.
In the Inventory adjustment account drop-down, select the appropriate account.
Select the products in the Product field. Note: The description and current quantity on hand auto-populate.
For each item, enter either a new quantity or a change in quantity.
In the Memo field, enter the details about the adjustment.
When you're done, select Save and close.

For an instructional video, you can refer to this article about adjusting inventory quantity on hand in QuickBooks Online.

In case you would want to edit previous adjustments, here’s an article about it.

Feel free to place a comment anytime you need assistance with QuickBooks. I'm here to help you always. Keep safe!

userbeveragesunlimit · ‎January 06, 2022

It just seems that the import of an excel file is more efficient than doing 270 adjustments as suggested. I'm wondering why my case is different where an import file won't work. Just not making sense to me...

Topics

Training

Community

Resources

After a recent import products are not showing as taxable anymore