QuickBooks Desktop

invoiced integrates with quickbooks desktop out of the box to extend the accounts receivable capabilities of quickbooks this document describes how to set up the integration and how it works in detail overview the quickbooks desktop integration ships with the following capabilities importing outstanding invoices from quickbooks desktop importing customers from quickbooks desktop reconciling payments received on invoiced to quickbooks desktop syncing payments recorded on quickbooks desktop to invoiced data flow invoiced sync to invoiced sync to quickbooks quickbooks desktop customer ← customer contact ← contact invoice ← invoice credit note ← credit memo payment ← → payment supported quickbooks versions the quickbooks desktop integration works with these versions of quickbooks (windows only) quickbooks enterprise solutions (2015 or later) quickbooks premier (2015 or later) quickbooks pro (2015 or later) canadian editions of quickbooks (2015 or later) uk editions of quickbooks (2015 or later) setup in order to begin syncing with quickbooks desktop first go to apps → quickbooks desktop click install adjust the integration settings to suit your requirements click download qwc configuration click generate qwc configuration to download the qwc file install quickbooks web connector https //quickbooks intuit com/learn support/en us/install new products/set up quickbooks web connector/00/185852 on the computer where quickbooks is installed, if you have not already open the downloaded invoiced qwc file in quickbooks web connector enter in the generated password make sure you do this before closing the configuration screen on invoiced because the password is irretrievable once you click done once you have installed the web connector you can adjust the integration settings to suit your requirements usage in this section you will learn how to use the quickbooks desktop integration syncing data these are the steps to run an invoiced sync this will sync the supported data flows between quickbooks and invoiced open quickbooks web connector close any open windows on quickbooks associated with the documents that will be synced check invoiced and click update selected when the sync has completed you should see your data on invoiced once the integration is fully configured, new transactions will sync with invoiced on a going forward basis the integration does not sync data created prior to the integration being installed see importing data docid\ cqhu6gzbwe u3rmpceazh for instructions on how to import transactions prior to installing invoiced turning on automatic syncing you can tell quickbooks web connector to run syncs automatically by turning on the auto run setting and specifying how often you want the sync to run in the every min box edge cases here we have documented all of the limitations, nuances, and edge cases to be aware of when using the quickbooks desktop integration customers on invoiced are mapped to customers on quickbooks by the name if you have duplicate customer names in quickbooks, we recommend merging them before you set up the integration duplicate customers can cause syncing issues with invoiced changing the customer associated with an invoice, credit memo, or payment is not supported if you do this in quickbooks, it will cause a sync error instead, you should void the record in quickbooks and recreate it under the correct customer modifications to invoices on invoiced after they are synced will do nothing to the corresponding invoice in quickbooks refunds are not currently synced any refunds initiated through invoiced must be reconciled by hand if you are using jobs, the default behavior is that transactions will roll up to the top level customer on invoiced if you wish to have separate customers for each job, please contact invoiced support to enable that functionality for your account the integration is a going forward sync and only imports transactions that are created or updated after the initial sync if an invoice is partially paid before the initial sync and is then paid in full after, the invoice will have an incorrect balance on invoiced because the original partial payment was not seen by the integration in order to correct this, the original payment will need to be re created on invoiced, or the synced invoice and payment must be deleted on invoiced troubleshooting when a sync fails you will be able to see the error message in the recent syncs section in settings → accounting sync normally the error message will include the invoice # that failed and a detailed reason why it could not be synced oftentimes there is a manual action required on your end below we have documented commonly encountered errors and recommended resolutions if you are still unable to get your books synced then please contact invoiced support for further assistance sync is not working please make sure you are connected to the internet in order to connect to invoiced mismatched password every time you download a qwc file please make sure you are using the associated password each time you generate a configuration this will generate a fresh password updating the qwc file if you are installing a new qwc file, please make sure that you clear out the old sync first if you are replacing an existing sync could not start quickbooks you will run into this error if quickbooks is not open, and you are running the sync through the web connector the remedy is to give the sync the ability to login automatically into quickbooks, even when quickbooks is closed in quickbooks go to edit → preferences → integrated applications and then click properties under the connected integration in the properties screen, choose "allow this application to login automatically object specified in the request cannot be found the error message object " " specified in the request cannot be found on a payment record can often be caused by one of these reasons the invoice is already paid on quickbooks if you try to create a payment on invoiced for an invoice that is already paid on quickbooks then you can see this error the solution is to ignore the error message you use multiple a/r accounts in quickbooks if the payment is applied to multiple invoices that use different a/r accounts then you can see this error the solution is to first void the failing payment on invoiced then you must create a new payment for each a/r account that is only applied to invoices of the same a/r account 1000 error the error message 1000 there has been an internal error when processing the request happens when the data our integration requested cannot be extracted the 1000 error indicates that the quickbooks company file has corrupt data and needs to be rebuilt quickbooks company files can become corrupt for many reasons the probability of a corrupt company file increases as your company file size grows if rebuilding your company file does not work then we recommend sending your quickbooks web connector log file to intuit support to resolve the issue there are also quickbooks consultants that specialize in rebuilding or splitting corrupt company files as a possible solution moved or renamed company file if you move or rename your quickbooks company file, then you will find that you get qwc1013 could not start quickbooks errors in order to resolve the error, you need to download a new qwc file from invoiced and re install it into quickbooks web connector unable to get from registry key this can happen when you move your company file from one machine to another the web connector is missing settings, which are missing from the new machine in windows search, enter regedit navigate to computer\hkey current user\software\intuit\qbwebconnector\soapwebservices right click and delete each connection log in to your quickbooks company file as admin navigate to edit > preferences select integrated applications select company preferences next to each connection, select remove follow the setup instructions again and run the sync application is busy try again later this message in the web connector indicates that the sync is stuck to solve it, log in to invoiced and navigate to settings > accounting sync cancel the sync that is in progress then, start a new sync in the web connector