Quickbooks Online Integration

Setting up the Link

Settings->Quickbooks page. 

Account Structure

InflatableOffice creates a standard account structure to properly categorize and record information in your account. A sales tax account is created for each sales tax rate and is named after the rate. Additionally accounts are created for each line item on a lead and sub accounts are created for each rental item. Accounts are not created until they are needed by an invoice that is being imported. When importing customer records, InflatableOffice first tries to find a match that already exists in your QB account. If it cannot, we create a new record. If there is a conflict we cannot resolve, we append "_IO" to the customer name. We use the organization name if it exists and otherwise the first and last name of the customer as the display name in QB.

How it Works

Now that the link is complete, InflatableOffice will automatically keep your QB file up to date. Any lead with a payment associated with it, or any lead in the confirmed or complete status will be imported into QB. Imports are triggered by leads. When a lead is imported, the customer record and payments are also imported. If something with the lead or a payment is changed, these records will be updated in your QB file. However, InflatableOffice never deletes any items from your QB file. So, if an event cancels, you will have to manually remove the corresponding invoice and payments from your QB file as necessary. The pre-saved lead filter titled "Delete from QB" will show you records that are in QuickBooks that need deleted. InflatableOffice does not import refunds or negative payments associated with leads. You will have to enter those manually. Any changes that need made to something InflatableOffice imported should be done first in InflatableOffice. Changes made in QB can potentially be overwritten by the data in InflatableOffice if an update to that item is triggered in InflatableOffice. Updates are triggered by changes to a lead that has already been imported into QB.

The tool will set the sync start date as the date/time that you initiate or setup the syncing. We can back date it or set the date forward. It will bring in any lead that has a start date after the sync start date that is in a status set to send to QB or has a payment on it.

When the Import Occurs

InflatableOffice queues items for import every hour. The QB web connector activates the InflatableOffice QB App every 5 hours to import these queued items. There is no need to have your QB file open, but if you have a different QB file open when the web connector runs, it will fail. Error messages are shown in the web connector. If you see an error message, run the web connector manually until they clear out. Most of the time these errors will correct themselves. To run the InflatableOffice App sooner than 5 hours, change the time inside the web connector. To force it to run on demand, select the InflatableOffice App in the web connector and then choose 'run selected'.

Reviewing Import Information

You can review queued items by clicking the appropriate link from the QuickBooks settings page in InflatableOffice. After the web connector runs completely, these items will be removed from the queue. You may also review the log for more information on what was imported and whether it errored or not. The log only contains a limited number of the latest entries and is helpful for troubleshooting. It will also explain some of the errors and how they have corrected themselves.

Click the View Queue or View Log links at the top-right of the Settings->Quickbooks page.

Is this article helpful?
0 0 0