Quickbooks Import QBI

[nonfinite]

I'm currently attempting to wrap my head around set up and match...

This is easily the most confusing and terrifying module I have ever attempted to use.

Also ridiculously powerful, but... yeah, this is a bit frightening.

[nonfinite]

I can't even begin to figure out where to start.

I somehow managed to import all of my customers to quickbooks, and my items, but can't import orders.

As I've clearly done something wrong, I deleted my company profile and started a fresh one this morning.



Shipping configuration: Until just now I had no idea what an "other charge" is because I'm new to Quickbooks. I was lucky enough to stumble on the answer when I was trying to figure out what to put in the Item income account field, since I don't have any items currently in Quickbooks to look at! So, I entered Parts-Inc, as that's what's entered in the manual. Hopefully that will work.

For anyone else who is similarly confused by this:
Lists -> item list -> new -> select "other charge"

Anyways, do I need to configure a shipping charge? Probably not, right? But it doesn't say that anywhere. I did, however, see you mention elsewhere that fields in red NEED to be filled out, thus my confusion. The other red fields explained in the Configuration and User manual say things like (required only if ...), the shipping area has no such addition. So, I guess I'll make this item and just set it to 0%, since I don't have a shipping and handling charge.

I don't have any items in Quickbooks, since I'm brand new to the program. Should I download an item list iif from zen cart, then re-upload it back to zen cart in order to have a list to match to?

Up until yesterday, I didn't have model numbers on my items in zen cart. Is this going to cause an issue when I attempt to import to Quickbooks? Will I be able to see my orders as they're meant to be seen, or will everything before yesterday be "broken" once everything's done?

[nonfinite]

I just tried to import orders again, and got:

"The transaction is not in balance. Make sure the amounts in the detail area on the form for this transaction equal the amount at the top of the form."

This is the same error I received last time.

Sadly, I have seen other people having this issue, and, even sadder still, reading the responses to these issues hasn't provided any clear answers thus far, at least for me, as I'm painfully new at this a perhaps a bit less knowledgeable than the average person using this module. I'll keep digging...

[nonfinite]

I've uploaded a sample of the orders iif with censored content to protect the customers name, address, etc. Maybe this will help show what the problem is?

xlsx format.


http://nonfinite.org/sample.xlsx

[nonfinite]

It seems the most thorough advice given on this topic can be found below:

1) Sales tax is not set up properly in QBI and does not exactly match the settings in QB, or you are using Sales tax groups (not ok, due to a bug in QB),
2) You have discount coupons or low order fees and you have not set them up in QBI.
If you open the downloaded iif file in Excel, you will be able to view the data for each order and you'll instantly see what is missing or calculated wrong.


I don't use sales tax at all. It's disabled both in Quickbooks and QBI. I don't use discount coupons or low order fees, either.

[nonfinite]

Again, more of the same found in the OScommerce forums:


This is likely due to a sales tax issue. Make sure that sales tax is turned on in QBI, that the sales tax fields exactly match what is in QB for tax name and agency, and that the percentage is exactly the same. Don't put the percent sign in, just the number (ie 8.75% shoud just be 8.75) (if this is being a problem I will add code that automatically strips out the % sign).

The other reason for the problem could be a gift certificate or low order fee. This is not yet supported, but I hope to add them within the next week or so.





I've been staring at this IIF for about 30 minutes now, and I have no idea what's wrong with it. I know you've said elsewhere that I should be able to see what's wrong almost immediately, but that doesn't seem to be the case here.

[nonfinite]

I just checked over my configuration settings a third time, and I don't see any discrepancies... I'm almost certain I'm missing something mundane.

[nonfinite]

OK, it seems a good number of orders imported successfully, with a large number being omitted due to the aforementioned error.

Still looking at the IIF, I actually found a cell that said "Discount and Fee matching not set up".

So clearly something is amiss.


Also, importing orders caused a list of all of the items I already had in QB to load again, except these new ones are marked as Service.

[nonfinite]

It also seems I can't delete these new items, since they're the ones bonded with the orders that did manage to process, instead of the ones marked as inventory. Why is it doing that?

I'm giving up for now. I'll load a backup that will take me back to right after I imported customers and products and wait for advice.

[nonfinite]

It appears the first dozen or so failed items are items I no longer have on the shop. No wonder...

Now my problem becomes much easier. I need to figure out how to show in the invoice what shipping method they purchased and indicate what has shipped already.