QuickBooks Online Integration

This document will cover how Furniture Wizard can be used with QuickBooks Online.

Journal Entry Option

Use a Journal Entry to Enter Summary Information.
1. Payments may be brought in using a bank feed or a summary payment entry.
  1. If using a Bank feed, the offset account should be A/R or a Customer Deposit Liability account.
  2. A Journal Entry will need to be entered for the payments if not using a Bank Feed.
    1. A payment report like 234 from Wizard can be used to break down daily payments to match Bank deposits.
2. Use reports from Furniture Wizard to get Sales, Sales Tax, and Cost of Goods into QBO.
  1. Report 204 has all the required information on one page.
  2. We will add a report that multi-location retailers can use with all the values at the branch/location level.
3. The timeframe of the entries best suits the store. The most common frequencies are daily, weekly, or Monthly.
The journal entry below is an example that includes Sales tax.
1. In states without sales tax, line 3 can be omitted.

IIF Customer Level Detail Option

Use AAATex IIF Importer for Integration. A yearly license is required for the import tool.
1. IIF Importer to QuickBooks Desktop and QuickBooks Online | AAATEX
  1. Working with the IIF importer's developer, we can extend a discount for his software.
    1. Contact support for the code.
2. This method uses a file export from Furniture Wizard to import customer-level details into QuickBooks Online.
3. Items included in the export
  1. Initial export includes Vendors (Fresh QBO setups)
    1. If a desktop QB file has been converted with vendors, I recommend removing the vendors from the initial IIF export to prevent duplicate vendors from QBO.
  2. Customers
  3. Invoices
    1. Based on the Order Date or Complete Date preference in Wizard
    2. Line item level detail, but using one generic item in QBO allows for mixed tax/nontax line items.
  4. All payments received, regardless of invoice date preference.
  5. Sales Tax
4. If converting from QuickBooks desktop SDK by Complete Date there are a few extra steps that need reviewed.
  1. All pending invoices once the QB file is converted to QBO will need removed.
    1. These invoices will end in a D. example 11000D.
  2. The Start Date in Wizard will need updated to the date the last push to QB was done on the desktop so duplicates aren’t presented in the IIF.
  3. Before importing the IIF into QBO the supplier section should be removed from the file. You will open the IIF in excel and delete the rows and header lines dealing with suppliers.

Process to use the IIF Importer