QuickBooks Online Integration
Push invoices from WISK into QuickBooks Online by connecting your accounts
Nick Neale avatar
Written by Nick Neale
Updated this week

Article Contents

Introduction

If you use QuickBooks Online as your accounting software, you can push your distributor invoices in WISK to your QuickBooks Online account.

Pushed invoices appear as Bills under your Expenses and you can make payments / mark them as paid.

Note: This integration is only available for QuickBooks Online. There is no integration with QuickBooks Desktop software.

Connecting WISK with Your QuickBooks Account

Before you can push invoices, you must first connect WISK with your QuickBooks account.

To connect WISK with your QuickBooks Account:

  1. Place your cursor over your username on the bottom left corner and click “Venue Settings”’

    The "Venue Settings" button on the side menu bar is highlighted.
  2. Scroll down on the “Venue Settings” window and click the “Setup” button.

    The "Setup" button at the bottom of the "Venue Settings" window is highlighted.
  3. A new window opens to the QuickBooks website. Enter your QuickBooks username and password and click “Sign In”

    The QuickBooks user ID and password have been entered and the "Sign In" button is highlighted.

    Note: If the QuickBooks website doesn’t appear, please temporarily disable your browser's pop-up blocker and try again.

  4. A message displays that the integration is in progress.

    The integration in progress messages that displays. A few messages will display in quick succession.
  5. When the integration is complete, it displays “Setup completed” on the Venue Settings.

Beside the "Set up" button, it now reads "Setup completed".

Connecting Multiple WISK Accounts

If your venue has Food and Beverage accounts in WISK, and you use the same Quickbooks Online account for both (instead of having separate accounts), only one WISK account can be connected at a time.

We recommend picking one of the WISK accounts and going through the setup steps below. When finished, you can then switch to the other account and complete the setup for that one.

At that point, each account has all the required GL accounts and taxes to export invoices.

Whenever you want to export invoices to your Quickbooks Online account from either account, you'll just need to follow the steps in "Connecting WISK with Your QuickBooks Account" above to make it one with the active connection.

Linking GL Accounts, Taxes & Distributors/Suppliers

With your WISK and QuickBooks accounts integrated, the next step is to link your GL Accounts, Taxes, and Suppliers between the two platforms.

This ensures that when you send your invoices from WISK to QuickBooks that they are being filed under the correct accounts and payees/suppliers.

Note: After integrating your QuickBooks account, WISK refreshes/syncs your data once daily. If you add any GL accounts, taxes, or suppliers, they'll appear in WISK the next day, so plan accordingly.

GL Accounts

Before you can push invoices from WISK to your QuickBooks accounts, take a moment to set up your GL accounts if you haven’t already. You won’t be able to push an invoice until GL accounts have been assigned to each line item.

Setting up your GL accounts requires the account name and number. To learn more, please see:

Note: You will need account numbers enabled in Quickbooks to export invoices.

After adding your GL accounts to WISK, you can link them to the matching accounts in QuickBooks. Otherwise, when you push an invoice, it will create new accounts if they don't find an exact match.

To link your GL accounts:

  1. Hover your cursor over your username on the bottom left and click “Venue Settings”

    The "Venue Settings" button on the side menu bar is highlighted.
  2. Click the "GL Accounts" tab

    An arrow points to the "GL Accounts" tab.
  3. Click the "Details" button beside a GL account

    An arrow points to the "Details" column beside the GL Accounts.
  4. Click the + button beside "Accounting accounts"

    An arrow points to the "+" button on the "Accounting accounts" tab.
  5. Click into the "Accounting accounts" drop-down menu. You'll see all of the accounts from your QuickBooks account. Select the one that the matches, put a percentage of 100%, and click the checkmark

    Note: If you need to link more than one GL account, see "Split GL Accounts" below

  6. The GL accounts are now linked. When you export items to that GL account(s) they will appear in the right place in QuickBooks.

Split GL Accounts

If you have items that need to be linked to multiple GL accounts, for example, citrus fruits that could be used in both food and alcoholic drinks, you can click the "+" button to add another.

Note: If adding another, make sure that the "Percentage" field for the other account is set to under 100%.

Select an accounting account and then adjust the percentages. The percentage designates how much of the value goes towards each account.

A GL account where it is split between both food and liquor purchases, each at 50%.

When exported to Quickbooks, any line items using the Split GL appear as a separate item for each account, with the percentage amount designated to each. In the example below, an invoice with $100 of lemons goes towards both food and liquor expenses:

The $100 worth of lemons is split into two entries of $50.

Taxes

When your QuickBooks account is integrated with WISK, it imports your taxes / tax rates. Similar to GL accounts, you'll must create each tax in your WISK account and link it to the corresponding tax imported from QuickBooks.

Note: If you don't link the taxes, you won't be able to export invoices to QuickBooks.

To learn more about taxes, please see:

To link taxes between WISK and QuickBooks:

  1. Hover your cursor over your username on the bottom left and click “Venue Settings”

    The "Venue Settings" button on the side menu bar is highlighted.
  2. Click “Taxes”

    An arrow points to the "Taxes" tab under Venue Settings

    Note: If you can’t see this tab, please contact WISK Support and they will enable it in your account

  3. Click “New Tax”

    An arrow points to the "New tax" button.
  4. Before entering a Tax name, click into the "Tax name in accounting" field. You should see all of your taxes from QuickBooks. Click one of the taxes from the drop-down

    The "Tax name in accounting" field has been clicked and shows all the taxes from the accounting software.
  5. The "Tax name" field populates with what you selected from the drop-down. Click Save.

    The "Save" button is highlighted for emphasis.

  6. On the next screen, enter the tax rate for this tax. This must be the same rate in your QuickBooks account.

    The tax rate has been entered as 13%

    Note: For more information about setting up tax rates, please see:

  7. Your taxes are now linked. When you export invoices, they'll appear under the correct tax in QuickBooks.

Distributors / Suppliers

In this step, you'll link your distributors in WISK to your suppliers / payees in your QuickBooks account. This ensures that the invoice is filed under the correct supplier/payee.

Otherwise, when you push an invoice, it will create a new supplier in QuickBooks if it doesn't find an exact match.

  1. Click on "Distributors" on the left-hand menu bar

    The "Distributors" menu button is highlighted for emphasis.
  2. Click the "Details" button beside a distributor

    An arrow points to the "Details" column beside a distributor.

  3. Click the "Accounting distributor" drop-down menu. You'll see all of the suppliers from your QuickBooks account. Select the one that the matches.

    The "Accounting distributor" field is highlighted for emphasis. It shows all suppliers from your Quickbooks acocunt.
  4. The distributors are now linked. Any invoices sent from WISK from that distributor will appear under what you selected under "Accounting distributor".

Pushing Invoices to QuickBooks

To push an invoice to QuickBooks:

  1. Click Orders > Invoices / Returns

    The "Invoices / Returns" button is highlighted.
  2. Click the details button beside the invoice you want to push

    An arrow points to the "Details" column beside an invoice

  3. Before sending, make sure the "Invoice Total on Paper" field matches the "Total" field, that GL accounts have been assigned to all items, and that you've selected the correct tax format (inclusive, exclusive, no tax). Otherwise, you'll receive an error message when sending. When ready, click “Actions” > “Send to accounting”

    The "Actions" button is highlighted and an arrow points to the "Second to accounting button".

    Note: If you've attached an image to the invoice, it will also get imported into your Quickbooks account. You can only send a specific invoice to Quickbooks once.

  4. You’ll see a confirmation message, and can also verify it was sent by clicking the “Timeline” tab.

    The "Timeline" tab that shows the invoice was sent to QuickBooks.

  5. Sign in to your QuickBooks account and you’ll see the invoice appear as a bill on the Expenses page. The “Payee” field populates with the distributor name, and the “Category” depends on the GL accounts that were marked on the invoice. If more than one GL account was used, it displays as "Split", and you can click the bill to see a breakdown by line item.

    Note: If any line item used a Split GL, the value of that line item is split into separate entries based on the percentages that were set.

    If any images were attached to the invoice, they will appear in Quickbooks.

    If taxes were included in the exported invoice, you can view it inclusive or exclusive of tax.

    The QuickBooks interface showing the invoice that was imported from WISK.

    Note: If the Payee/Supplier and Category didn’t already exist in your QuickBooks account, they’ll be created.

    The invoice breakdown on Quickbooks.

Did this answer your question?