Quickbooks Import QBI Support Thread

[SblantonMMP]

Hello,
We've got the latest version installed onto a version 1.5.6c Zencart installation. I've followed the instructions on getting it configured and I've setup and matched the products/payments/etc. I've been able to create an iif file and download orders to QuickBooks. When I import the file it will create the sales receipt like I want. It includes the payment method (Credit Card) and shipping method (US Mail) on the receipt with all the other information.

Based on what I've read it should also import payments. It does put the correct amounts into the correct accounts, but it does not mark the sales receipts as paid. When I go to customer accounts, it does not show open balances for these receipts and customers. Is there something else I need to configure to have the sales receipts marked as "Paid" so that the "Paid" stamp will print when the invoice is printed? Am I expecting something that this won't do?

Thanks for any help and suggestions!

[Techiant]

Hello,
We've got the latest version installed onto a version 1.5.6c Zencart installation. I've followed the instructions on getting it configured and I've setup and matched the products/payments/etc. I've been able to create an iif file and download orders to QuickBooks. When I import the file it will create the sales receipt like I want. It includes the payment method (Credit Card) and shipping method (US Mail) on the receipt with all the other information.

Based on what I've read it should also import payments. It does put the correct amounts into the correct accounts, but it does not mark the sales receipts as paid. When I go to customer accounts, it does not show open balances for these receipts and customers. Is there something else I need to configure to have the sales receipts marked as "Paid" so that the "Paid" stamp will print when the invoice is printed? Am I expecting something that this won't do?

Thanks for any help and suggestions!

Hey, this won't work not because of the data you are importing but because of QuickBooks. I import Invoices but the same deal. No matter how perfectly matched the payments are in a transaction, it just refuses to put them together.

Be prepared for lots of repeat points and clicks to first RECEIVE payments - where you receive the payment already. If you only have a few transactions it's not that bad, but I usually do mine in batches, so if you do the same, here are the steps that go the fastest for me from years of experience.

1. Create memorized report that you would use each time.
i. Reports > Customers & Receivables > Transactioon List by Customer
ii. Click Customize report and set Dates: to whatever range you will be using as default (last month, quarter, year, etc. - don't worry, you can change this later each time you use)
iii. On Display tab, under columns, uncheck everything and only check Date, Name, amount fields
iv. Filters tab: Remove all but Date, Posting Status, and add Transaction Type > Payment
v. Click okay and save as Memorized report for future use

2. Pull up the memorised report, set date range if necessary
3. You need to developp click, keystroke routine that works for you to do this fast on multiple items in succession.
My procedure is double-click name > Click Auto Apply Payment > Click Save & Close > Click Yes.
Alternative is to use program called "Do It Again" which lets you capture/record mouse click procedure and then replay it multiple times to do large batches of repeat operations.
4. Deposit funds: This is trickier with automation as the payment date needs to be set manually.
i. Home > Record Deposits (or banking Make Deposits)
ii. Starting with topmost item: Tick checkmark > Hit Enter
iii. On next screen set date, make sure Deposit To shows correct Deposit To account and hit Save & New
iv. Rinse and repeat - you should only have to set correct date for consecutive deposits (umnless account also changes), so procedure is: Checkmark, Enter (optionally change deposit date) + Enter.

When I researched this years ago, there were a couple of third-party "approved" add-ons/applications that directly manipulated the database but they were outrageouslty expensive for what they id, and i think were either subscription model or per-transaction fee-based.

Good luck!