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: For QuickBooks Desktop, you can export invoices from WISK in a format that can be uploaded to your account. For more information, see:
Connecting WISK with Your QuickBooks Online Account
Before you can push invoices, you must first connect WISK with your QuickBooks Online account.
To connect WISK with your QuickBooks Account:
Place your cursor over your username on the bottom left corner and click “Venue Settings”’
On the Venue Settings window, make sure the Accounting Integration dropdown has "QuickBooks Online" selected and click "Setup accounting integration"
A new window opens to the QuickBooks Online website. Enter your QuickBooks Online username and password and click “Sign In”
Note: If the QuickBooks website doesn’t appear, please temporarily disable your browser's pop-up blocker and try again.
A message displays that the integration is in progress.
When the integration is complete, it displays as “Completed, active” on the Venue Settings
Note: If your QuickBooks Online account uses Classes, you'll see a drop-down menu where you can select the default Class that gets assigned to invoice items.
After the integration is complete, it can take a few minutes to sync the data from QuickBooks to your WISK account (GL accounts, distributors, taxes, etc)
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 Online accounts integrated, the next step is to link your GL Accounts, Taxes, and Suppliers between the two platforms.
This ensures when you send your invoices from WISK to QuickBooks Online that they're filed under the correct accounts and payees/suppliers.
Note: After integrating your QuickBooks Online 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 send 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'll need account numbers enabled in QuickBooks Online 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'll create new accounts if they don't find an exact match.
To link your GL accounts:
Hover your cursor over your username on the bottom left and click “Venue Settings”
Click the "GL Accounts" tab
Click the "Details" button beside a GL account
Click the + button beside "Accounting accounts"
Click into the "Accounting accounts" drop-down menu. You'll see all of the accounts from your QuickBooks Online 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
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.
When exported to QuickBooks Online, 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:
Taxes
When your QuickBooks Online 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:
Hover your cursor over your username on the bottom left and click “Venue Settings”
Click “Taxes”
Note: If you can’t see this tab, please contact WISK Support and they will enable it in your account
Click “New Tax”
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" field populates with what you selected from the drop-down. Click Save.
On the next screen, enter the tax rate for this tax. This must be the same rate in your QuickBooks account.
Note: For more information about setting up tax rates, please see:
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.
Click on "Distributors" on the left-hand menu bar
Click the "Details" button beside a distributor
Click the "Accounting distributor" drop-down menu. You'll see all of the suppliers from your QuickBooks Online account. Select the one that the matches.
The distributors are now linked. Any invoices sent from WISK from that distributor will appear under what you selected under "Accounting distributor".
Classes
If your QuickBooks Online account has access to class tracking, your classes are imported into your WISK account and can be assigned to invoice items. To learn more about class tracking, see:
Selecting a Default Class for Invoices
To select the default class to be used on invoices:
Place your cursor over your username on the bottom left corner and click “Venue Settings”’
Scroll down to the "Account Integration" section and click the "Default QuickBooks class' drop-down menu. Select the class you want to use as the default
The selected class will be applied to each line item on an invoice by default, but can be changed manually if needed
Classes on Invoices
If using classes, you'll see a "QuickBooks Class" field/column appear when viewing invoices. If you selected a default class, it's assigned to each invoice item automatically.
To change the class, click into the field and select a new class from the drop-down menu.
You can also select the class when adding items to the invoice.
Exporting / Pushing Invoices to QuickBooks Online
Before you can export an invoice or return you need to make sure that each line item:
has a GL account assigned
taxes are included (if applicable) and
that the invoice total matches the "invoice total on paper" field
Note: When you go to export an invoice/return, please confirm all details are correct. You can resend invoices if you make a mistake, but every time you send an invoice it creates a new bill/expense. You may need to delete the previous one in QuickBooks.
Only users with the Admin role can export invoices to QuickBooks Online.
Exporting an Invoice
To export an invoice to QuickBooks Online:
Click Orders > Invoices / Returns
Click the details button beside the invoice you want to push
Before sending, make sure:
the "Invoice Total on Paper" field matches the "Total" field
that GL accounts have been assigned to all items
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”
Note: If you've attached an image to the invoice, it will also get imported into your QuickBooks account.
A window appears where you must confirm the invoice details are correct. If all details are correct, click "OK"
The invoice is sent and a message displays in the invoice saying it's been sent to accounting in its current state. If you make any further changes to the invoice you should resend it to accounting
Exporting Multiple Invoices
To export multiple invoices at a time:
Click the checkbox beside each invoice you want to export
After checking each invoice, click "Send to accounting" on the side menu that appears
Note: If you select an invoice that has already been sent to accounting, the option won't appear. This is because in most cases you should only send an invoice to QuickBooks Online once. The "Sent to accounting" column shows a check for invoices that you've already sent. If you need to resend an invoice you can only. do it one invoice at a time.
A window appears where you must confirm the invoice details are correct. If all details are correct, click "OK"
The invoices are sent and the "Sent to accounting" boxes are checked. A message displays in each invoice saying it's been sent to accounting
Note: If one or more of the selected files is missing required information, you'll receive an error message. Click the details button beside the noted invoice(s) and add the missing information. Click "Retry" after making your changes.
To learn more about potential errors, see "Troubleshooting / Errors" below.
Troubleshooting / Errors
When you export an invoice, you must:
Have a GL account assigned to every line item
Make sure the totals match
Missing GL Accounts
If a line item is missing a GL account, you'll receive the following message when you try to export the invoice.
Assign a GL account to the missing item(s) and try again.
Totals Don't Match
When exporting an invoice, the "Total" and "Scanned Total" fields have to match. If they don't, you'll see this message:
Total is the sum of all items on the invoice in WISK, and Scanned Total is also known as the invoice total on paper. In other words you need to add items to the invoice in WISK to get both values to match.
Make sure you've added the following to the invoice:
Taxes
Charges & Credits
Discounts (if applicable)
Note: If the "Scanned Total" field is blank, you'll need to enter a value.
Viewing Invoices / Returns on QuickBooks Online
Sign in to your QuickBooks Online account and you’ll see any sent invoices/returns on the Expenses page.
Invoices appear as bills, and returns as vendor credits.
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 setIf using classes, the assigned classes appear in the "Class" field.
If any images were attached to the invoice in WISK, they will appear in QuickBooks
If taxes were included in the exported invoice, you can view it inclusive or exclusive of tax.
Note: If the Payee/Supplier and Category didn’t already exist in your QuickBooks account, they’ll be created.
Resending an Invoice
If you have sent an invoice to QuickBooks Online but discovered a mistake, you can resend the invoice after making your changes.
Important: When you resend an invoice to QuickBooks it makes a new expense / bill. Make sure you notify your accounting department so they can make any necessary changes (delete the original invoice that was sent, etc.).
To resend an invoice:
Open an invoice and Click Actions > Resend to accounting
Click "OK" on the confirmation page
Click "OK" on the secondary confirmation. This message tells you this action will create a duplicate expense/bill in your QuickBooks Online account.
Note: There will be some upcoming UI changes to make it clearer when the invoice has been resent. In the meantime you can check the timeline tab to see each time it was sent.