sales tax code mapping

I can share some information on how you can map your products when importing and how QuickBooks Online (QBO) calculates taxes, lisaperlie.

If your item hasn't been imported yet to QBO, kindly follow the correct format so the system will directly recognize and match the details according to their corresponding fields. This way, we can reduce the manual corrections after importing.

Correct formatting includes avoiding special characters, your Income and Expense accounts must not contain subaccounts, and the Quantity as-of Date must follow the format MM/DD/YY. You can also download a sample file from the Import Products and Services window to view it in your Excel. In the mapping section, you can locate the Taxable dropdown and choose according to your preference.

Here's how to import your products and services:

1. Go to the Sales menu, then choose Products & Services.
2. Click the New dropdown, then select Import.
3. When importing, you can choose how you can upload your CSV. Select a CSV or Excel file to upload, or Select Google Sheet.
4. Once done, click Next.
5. When mapping, please know that the CSV column headers represent the headers on your spreadsheet. Select the one that matches a field in QBO from each dropdown.
6. Click Next.
7. If there are cells that contain red, the cell is invalid. We can resolve this by reading the error message and then correcting it, or you can edit your CSV file and upload it again.
8. Click Save.

After importing the product and you want to create a new transaction with this, QBO will automatically calculate your taxes based on where you sell and where you ship, your customer's tax-exempt status, and what you sell.

Additionally, please know that a list of tax codes is currently unavailable in QBO. Alternatively, you can manually assign the appropriate sales tax category for the product or service item.

You can also set up where you collect sales tax in QBO so you can track your state's tax laws and accurately calculate sales tax and returns.

We're still here if you have additional questions regarding sales tax or importing your product, lisaperlie. Please let us know in the comment section.

i am simply looking for a list of  the items in the  "Taxable dropdown" so i can plan how my items will map to those codes. My items already exist in QB online so i do not need help importing them. i have so many items that will be to mapped, it will help to have this list ahead of time.

Glad to know you successfully added your products to QuickBooks Online (QBO), Lisa. I'm here to share details about mapping them accurately in the program. 

QBO allows you to assign your products to the correct sales tax category and rate. However, we don't have a list of the QBO tax codes, along with a description of how they apply to products.

As a workaround, I recommend manually editing each product. Then, under the Sales tax field, enter and select the correct item's description to find the right sales tax category and rate.

Here's how:

1. Go to the Gear icon and then select Products and services.
2. Locate the item and then click Edit.
3. Scroll down to the Sales tax section.
4. Click Edit sales tax.
5. Set the correct tax rules.
6. After that, hit Done, then Save and close.

Rest assured that the Product Development Team is continuously improving QuickBooks Online. They're constantly introducing updates and improvements to cater to the diverse business needs of all users.

For now, I recommend sending a feature request to the development team. Let me share these steps on how you can do it from your QBO account:

1. Go to the Gear icon and select Feedback.
2. Type in your suggestions about utilizing sales tax codes when mapping items.
3. Then, submit your request.

Additionally, I've added these resources to help you set up and use the automated sales tax feature in QuickBooks Online:

• Learn how QuickBooks Online calculates sales tax
• Set up and use automated sales tax in QuickBooks Online

I'm always ready to help if you still have other questions about utilizing and navigating the Sales tax feature in QBO. You can reply to this thread or start a new one to let me know.