Quickbooks Import QBI

[adam5532]

I have tried for 2 days to get this working and I don't know what I am doing wrong!

I followed all the instructions. I just installed a clean copy of QB Premier 2007. I installed QBI and updated the configure with defaults. I uploaded the lists.iif file from QB and then did the setup tab in QBI. I downloaded new products, customers, previous orders and imported into QB.

Everything imported fine, all my products, customers, but the orders.iif WILL NOT import. I keep getting this error that the transaction is not in balance.

Sales tax is setup. I don't know where to check the shipping and income accounts in QB to see if those entries in QBI are giving me the issue.

Please help!!!

Open the iif file in Excel. Look at the order -- the error message in QB will give you the line number for the last line of the order with the problem.

Compare the order in the iif file to the order Invoice in Zen Cart. You will see the problem because a line item will be missing or have the wrong amount -- missing item, incorrect sales tax, discount coupon or low order fee not configured in QBI, etc.

Thanks,
Adam

[simetra]

It shows line 11.

When I look at the excel file line 11 only shows:
ENDTRNS

any ideas?

[adam5532]

It shows line 11.

When I look at the excel file line 11 only shows:
ENDTRNS

any ideas?

Read again:

"Look at the order -- the error message in QB will give you the line number for the last line of the order with the problem."

Thanks,
Adam

[simetra]

I deleted all those lines out and it worked!

[adam5532]

I deleted all those lines out and it worked!

The point wasn't to delete the lines. The point was to look at them to determine what the problem was, so that it could be corrected and not happen in the future. By deleting the lines, you are in exactly the same place you were before -- the order has not been imported.

- Adam

[simetra]

You are right. It shows that the import was successful but no orders show.
The ones with errors are blank rows with just ENDTRS in one cell. I don't understand how to figure out what is wrong with the line. Does it stand for end of transaction? There is no item or anything there, just that one word and then a blank row....

[simetra]

Any ideas on how i can tell what part of the transaction is causing the issue?

[adam5532]

Any ideas on how i can tell what part of the transaction is causing the issue?

The transaction is in the lines above ENDTRNS.
Compare those line items to the receipt in Zen Cart.
You'll have a line for each product purchased, and lines for discounts and sales tax, if you use them. If the line doesn't match the invoice, then you know where the problem is.
If you charge sales tax, make sure that you have set it up properly in QBI. Discounts and Low Order fee must be set up. And, all products must have a Model.

Thanks,
Adam

[barrys]

Adam,
I have been through the configuration manual and all related threads here. I cannot get QBI to import as a sales receipt. Payment methods have been setup and matched as you describe. Is it possible that I have an issue because all of my products are actually services in Quickbooks?
Thanks,
Barry

[adam5532]

Adam,
I have been through the configuration manual and all related threads here. I cannot get QBI to import as a sales receipt. Payment methods have been setup and matched as you describe.

What payment module are you using?

Is it possible that I have an issue because all of my products are actually services in Quickbooks?
Thanks,
Barry

This is unrelated. But, your products should not be set up as services in Quickbooks. I'm not sure if you mean that you did that on purpose, or they got created when you imported orders. Products must be set up in QB before importing orders. If they are not, they will incorrectly be created as services.

Thanks,
Adam