Quickbooks Import QBI

[poolfiltersusa]

Second is there a way to import the paypal fees with each order?

[christinefred]

Hi, I am in Australia and looking at accounting packages for my new business. I am nearly finished setting up my zencart store and was wondering if this add on is suitable for the Australian versions of quickbooks? Is anyone down under using it? Thanks........Hopeful

[adam5532]

Can anyone give me some advise about making this work with paypal pro -- everything that I have tried all my orders are imported as Invoices and I need them to be sales receipts?

Check if PayPal Pro has been added properly to the qbi_paycart db table. The payment module and the payment text in qbi_paycart must match the module and text in your orders table.

If you have to make any modifications to qbi_paycart, then coment out $matching=new match($dbqbi); in the file qbi_pay.php. This will disable the automatic detection which will over-write your changes.

Make sure that Set Up Payment and Match Payment are done properly, and that you have set the Configuration option "Import Orders As" to Sales Receipts.

Adam

[adam5532]

Second is there a way to import the paypal fees with each order?

No. They aren't part of the customer order, so they don't need to be imported. The fees are an expense that you can enter when you pay them.

Adam

[adam5532]

Hi, I am in Australia and looking at accounting packages for my new business. I am nearly finished setting up my zencart store and was wondering if this add on is suitable for the Australian versions of quickbooks? Is anyone down under using it? Thanks........Hopeful

QBI is untested on Australian QB, but I have been told that it might work. So, try it out.

Adam

[lseibert]

Zen Cart Version 1.3.6
No add-ons other than QBMS
We have QBMS plugin set up on the site, got our AppID from the Intuit Developers Site, got the Connection Ticket from the merchant service site and set everything up for desktop hosting. The transactions process (customer received approval or denial), order goes through, but the funds do not show in QBMS nor depost to our bank account. QB said it was the cart setup. Can you help? THank you.

Lesa Seibert

[adam5532]

Zen Cart Version 1.3.6
No add-ons other than QBMS
We have QBMS plugin set up on the site, got our AppID from the Intuit Developers Site, got the Connection Ticket from the merchant service site and set everything up for desktop hosting. The transactions process (customer received approval or denial), order goes through, but the funds do not show in QBMS nor depost to our bank account. QB said it was the cart setup. Can you help? THank you.

Lesa Seibert

I think you have posted in the wrong forum. This does not have anything to do with QBI.

Thanks,
Adam

[mcarbone]

I apologize ahead of time if this topic has been discussed in the forum already. I did a specific search and nothing came up.

I am getting a QuickBooks import error ("Transaction not in balance etc.) with an order from a customer who is designated for group pricing. (At least I think this is where the error is steming from).

In QBI -> match -> discounts/fees section there is no option for group pricing.

Any thoughts?

Thank you,

Michelle

[adam5532]

I apologize ahead of time if this topic has been discussed in the forum already. I did a specific search and nothing came up.

I am getting a QuickBooks import error ("Transaction not in balance etc.) with an order from a customer who is designated for group pricing. (At least I think this is where the error is steming from).

In QBI -> match -> discounts/fees section there is no option for group pricing.

Any thoughts?

Thank you,

Michelle

Group pricing will not cause any problem - it is something else. Usually:
An item is missing the Model.
A discount or added fee is not matched.
Taxes are not set up properly.
A payment module is used that rounds numbers incorrectly (rare, random errors).

Open the iif file in Excel. For each order, you'll see all its line items, and the total amount. The line items must add up to the total. It should be clear what is missing -- some item or discount will be missing. Then, fix the problem in QBI, download the iif file again, and check if it is fixed.

Thanks,
Adam

[mcarbone]

Adam,

You are definitely the guru!

I pulled from the excel file:

Accounts Receivable - "Customer name" - $239.92
Web Sales - $350
(blank cell) (blank cell) - Discount and Fee matching not set up
Web Sales Shipping - $12
Sales Tax Payable - Tax Board - ST -$17.92

I can't help but still think that because the QBI - > Match -> Discounts/Fees under "shopping Cart" section it does not have a group pricing option that it is the reason why we are coming up with " Discount and Fee matching not set up.

Here's the customer's order total:

Sub-Total: $350.00
United Parcel Service (20.60lbs) (Ground): $12.00
Group Discount: -$140.00
Tax (8.25%): $17.92
Total: $239.92

Maybe I can update a file that recognizes the zen cart group pricing function as a "discount/fee" in QBI. My PHP programming is primative.

Thanks again!!!

MC