My purchases are not subject to taxes but Quickbook won't let me import my products via excel file with tax on purchases at zero. It says make valid entry. What do I do?

Welcome to the Community, luc3.

To make sure we’re on the same page, are you trying to import transactions (bills or expenses) or items? Any details shared can help me provide the steps to move forward.

While waiting for the complete details, let’s perform some basic troubleshooting steps to move past the error. For items/purchases that are non-taxable, make sure to use the zero-rated or NO VAT code on the transactions.

This way, you will not have any issues when importing them. If you haven’t created the zero-rated tax, follow these steps to add it.

1. Go to the Taxes menu and select VAT to open the VAT Centre.
2. Click the Add tax button in the upper right.
3. This will take you to another window where you can choose the tax type.
4. From there, tap the Tax rate link to display the Add Tax window.
5. Type in the tax information in the field boxes.
6. Click Save to keep the changes.

The following link provides an overview of how to activate the sales tax feature. It includes steps to help add, edit or group sales tax: How do I set up sales GST/VAT rates and use them on forms? (International QBO).

Next, let’s go to the Products and Services page and open each item (purchases) that are not subject to tax. Then, change the tax rate in the Purchase tax section to zero-rated.

1. Tap the Products and Services option under Lists.
2. On the All Lists page, select the items you’re working on and click the Edit link under the Action column.
3. When the Product/Service information window opens, scroll down to the Purchase tax section to select the correct tax rate.
   
4. Hit the Save and close button.

If you’re importing transactions, we’ll have to open each one and use the No VAT code. Here’s how:

1. In the left panel, click the Expenses menu to select Expenses.
2. On the Expense Transactions page, choose the entry you’re trying to update the tax information.
3. Click the View/Edit link under the Action column.
4. This will take you to the entry page.
5. Go to the Amounts are section and click the drop-down to choose No VAT.
   
6. Click Save and close.
7. Hit Yes to confirm the action.

Perform the same procedure to all purchases you’re trying to import. Once done, you can start with the import process.

For additional resources, check out the Common questions about importing data to QuickBooks Online guide. It contains links to help import data seamlessly into the program.

Reach out to me if you have any other concerns or questions. I’ll be right here to answer them for you. Have a good one.