As part of the Accounting Integration package, you can create general ledger (GL) accounts and assign them to items on your invoices.
You can assign GL accounts to invoice items manually, or have them fill automatically based on the settings of the item, the item’s family, or distributor.
The invoices can then be exported to supported accounting software.
On each invoice, you’ll be able to see a breakdown by GL account. You can also access reporting to see entries for each GL account over a selected time period.
Adding GL Accounts
To add a GL account on the WISK Web Portal:
Hover your cursor over your username on the bottom left and click “Venue Settings”
Click “GL Accounts”
Click “New GL Account”
Enter the GL Account Number and Name into the corresponding fields
Note: If your accounting software is integrated with WISK, you'll see an additional field called "Accounting account". Here you'll select an account imported from your accounting software to create a link between the two. For more information, please see the specific article for supported integrations.
It now appears in your list of GL accounts. You can add as many GL accounts as necessary
Note: After adding a GL account, you can click the “Details” column beside an account to edit it.
Assigning GL Accounts
When adding invoices, you can assign GL accounts to invoice items manually, or you can assign them to higher level categories to have them populate automatically.
You can assign GL accounts at the following levels:
Note: When populating the GL account for an item on an invoice, it will check for GL accounts in this priority order: Item > Family > Distributor.
For example, if you assign a GL account to a distributor, but have also added GL accounts at the family level, it will pull the family’s GL account because it is a higher priority.
How you set this up will depend on your preferences and how your GL accounts are structured.
To assign a GL Account to a distributor:
From the “Distributors” page on the WISK Web Portal, click the “Details” column beside a distributor
Click the “GL Account” drop-down menu
Select the GL account you want to assign to this distributor
The GL account is now assigned to the distributor
To assign a GL account to an Item Family:
From the Families & Categories page on the WISK Web Portal, place your cursor over an Item Family and click “Edit Family”
Click the “GL Account” drop-down menu
Select the GL Account you want to assign to this Item Family
The GL account is now assigned to the Item Family
To assign a GL account at the individual item level:
On the “Items” page of the WISK Web Portal, place your cursor over the item and click the pencil icon
Scroll down to the “GL Account” field and click the drop-down menu
Select the GL Account you want to assign to this item
The GL account is now assigned to the item
GL Accounts on an Invoice
After adding the GL accounts and assigning them, it all comes together when adding invoices.
When adding an invoice, the GL account field for each invoice item populates automatically if you’ve assigned them earlier.
Selecting a GL Account
If you haven’t assigned them beforehand, you can select the GL account by clicking the drop-down menu:
Changing a GL Account
If an item has already been added to the invoice, you can click the “GL Account” field to change the account for the item.
Charges & Credits
When adding any Charges or Credits to the invoice, you can select a GL Account:
The charges and credits display underneath the line items on the invoice.
GL Account Breakdown
After adding GL Accounts to each item and charge/credit on the invoice, you can click the ‘GL Accounts” tab to see the invoice items by GL Account.
For each GL Account, you’ll see each item and the dollar amount.