After connecting QuickBooks to SKULabs, you can decide which information you want SKULabs to push to QuickBooks Online account. Visit settings > advanced > accounting settings to get started.

See the QuickBooks FAQ at the bottom of this page for additional information.

Purchase orders

SKULabs can push purchase orders "closed" within the last 60 days to QuickBooks. To enable this, choose a selection for each of the following accounts:

  • Accounts payable

  • Inventory assets

  • Product sales income

  • Cost of goods sold expense

After selecting the correct QuickBooks accounts mentioned above, enable the switch to Sync purchase orders, then click save.


Sales receipts or invoices

SKULabs can push orders created within the last 30 days to QuickBooks as sales receipts, invoices, or both. To enable pushing orders, choose a selection for each of the following accounts:

  • Inventory assets

  • Product sales income

  • Cost of goods sold expense

  • Sales tax code – Optional. If left blank, "TAX" will be used as the default.

Push orders only as Sales Receipts

To push all orders as sales receipts, select the correct QuickBooks accounts mentioned above, then enable the switch to Sync orders and click save.

Choose which orders push as Sales Receipts and/or Invoices

Make use of customizable shipping rules to push orders as either Sales Receipts and/or Invoices. Choose the correct QuickBooks accounts mentioned above, then navigate to the shipping rules page.

Note: You can configure the filters as needed. When using multiple rules for QuickBooks sync, configure the rules criteria in a way that avoids crossover. For example, if all manual orders should be synced to QuickBooks as invoices, then ensure your other rules do not include manual orders.

Sales receipts:

  1. Create a shipping rule and add the action "Create sales receipt (accounting)" as shown below.

  2. Add filters to decide which orders this rule will apply to and push as sales receipts.

  3. After setting up your shipping rules and selecting the correct QuickBooks accounts mentioned above, enable the switch to Sync orders, then click save.

Invoices:

Tip: Depending on whether you bill pre or post shipment, consider using an order's status as a filter. For post-shipment invoicing, it is recommended to use shipped order status filter.

  1. Create a shipping rule and add the action "Create invoice (accounting)" as shown below.

  2. Add filters to decide which orders this rule will apply to and push as invoices.

  3. After setting up your shipping rules and selecting the correct QuickBooks accounts mentioned above, enable the switch to Sync orders, then click save.

Currency code and syncing items in multiple currencies

This requires turning on the Multi-currency setting and whitelisting currency codes on QuickBooks. Note: According to QuickBooks, once you turn this feature on in QuickBooks, you cannot turn it off. Only turn this feature on if you need it.

If you create purchase orders or receive orders with different currency codes:

  1. Enable SKULabs to push currency code to QuickBooks on your SKULabs Accounting Settings.

  2. Enable the multi-currency feature on QuickBooks

  3. Assign currency code to suppliers when creating or editing a supplier in SKULabs. And, ensure all suppliers in SKULabs have currency code

  4. Ensure all existing vendors in QuickBooks have currency code assigned to them

  5. Ensure vendor and supplier names match between QuickBooks and SKULabs. This allows SKULabs to use existing vendors on QuickBooks by looking them up by name instead of creating new vendors.

Sales Receipts / Invoices:

  • SKULabs pushes orders to QuickBooks Online with the currency code provided on the order by your sales channel upon import.

  • If a currency code is not provided by your channel, SKULabs will not push currency, which means QuickBooks uses the default currency code for the account.

Purchase orders:

  • When creating a PO, the supplier's assigned currency is automatically associated with the PO.

  • When a PO is pushed to QuickBooks, SKULabs includes the currency code associated to the PO.


FAQ

  1. How are accounts used and why are they required?

    QuickBooks API requires accounts to be assigned to purchase orders and items. The "Accounts payable" account you select is assigned as a payable account to POs pushed to QuickBooks. The "Inventory asset", "Product sales income", and "Cost of good sold expense" accounts you provide are used as default accounts for creating items on QuickBooks.

    SKULabs creates items that don't exist on QuickBooks, because QuickBooks API won't allow pushing a PO, Sales Receipt or Invoice that contains an item that doesn't already exist on QuickBooks. SKULabs first looks up an item by SKU to check whether an item exists on QuickBooks. If the item doesn't exist, SKULabs creates the item on QuickBooks to make the process of pushing POs, Sales Receipts and Invoices seamless.

  2. How do I assign different accounts to different items?

    Assigning different accounts to different items is possible by creating items directly on QuickBooks and associating the items to the desired accounts. When creating an item on QuickBooks, assign the following accounts:

    • Income Account

    • Expense Account

    • Asset Account

    Because SKULabs is not a listing publishing (product information management) software, it doesn't provide robust item information mapping, such as tax accounts, per item or group of items. For this reason, we recommend creating items directly on QuickBooks.

    When adding a new item to your catalog in the future, have a process in place to add the item on QuickBooks as well when the new item is first added to other sales channels or SKULabs. You can add an item on QuickBooks first and import it into SKULabs via listings sync. Otherwise, SKULabs would attempt to create the item on QuickBooks using default accounts when the first PO or Sales Receipt/Invoice containing that item is pushed to QuickBooks.

  3. Can SKULabs push sales receipts or invoices to QuickBooks for orders created manually in SKULabs?

    All orders, including manual store and sales channel orders can be pushed to QuickBooks as sales receipts or invoices.

  4. How often are sales receipts and invoices pushed to QuickBooks?

    Sales receipts and invoices are synced to QuickBooks every 30 minutes on average after they are created or imported into SKULabs.

  5. Are changes to orders pushed to QuickBooks to update sales receipt or invoice?

    No. Once an order is pushed to QuickBooks, it will not be re-pushed again. As a result, changes to orders (such as order edits, cancellations and refunds) after they have been synced to QuickBooks are not pushed to QuickBooks and would need to be applied directly in QuickBooks.

  6. Can I control which orders are pushed to QuickBooks as sales receipt or invoice?

    Yes, you can use shipping rules to control which orders are synced to QuickBooks. For example, you can configure shipping rules to push paid orders as sales receipts and unpaid orders as invoices.

    Note: By default, if shipping rules aren't setup, SKULabs pushes all orders to QuickBooks as sales receipts.

  7. How are updates to purchase orders synced to QuickBooks handled?

    Purchase orders are pushed to QuickBooks after they are closed. Updates to a purchase order after it has been synced to QuickBooks will not be pushed or reflected in QuickBooks and need to be applied directly in QuickBooks.

    If a PO fails to sync initially for some reason, the system automatically retries syncing 4 times per day for 60 days from the date a PO was initially closed on.

  8. Can Purchase Orders be pushed to QuickBooks by tag, rules or manually pushed?

    These functionalities are not currently supported.

  9. Can I use different SKUs in QuickBooks and SKULabs?

    Yes, you can use different SKUs between SKULabs and QuickBooks. All you need to do is to link the QuickBooks listings to the correct items in SKULabs, and this will allow SKULabs to use QuickBooks listing SKUs when communicating with QuickBooks.

  10. Is a listing sync required for SKULabs to begin pushing sales receipts or POs to QBO?

    No, only QBO stock sync requires having listings imported.

Did this answer your question?