2. Setup Wise-Sync Company (ConnectWise)

A Wise-Sync Company provides the connection to your Accounting Package company. Depending on the PSA you're using, you may have one or many companies included in your subscription.

Wise-Sync Company settings help you control how tax and invoice adjustments/rounding are handled. This is also where you control how the GL is mapped from your PSA to your Accounting Package.

Account Administrators (i.e. users with the role account-admin) are able to manage a Wise-Sync Company. For more information about User Roles, read up on Wise-Sync Users.

How do I get there?

To configure your Wise-Sync Company, click Companies from the top Menu.

What do I do?

Check out the settings below and what you need to do with them. Click Save when you're done!

If you're using Datto Autotask PSA please read 2. Setup Wise-Sync Company (Datto Autotask PSA)

Company Options
Accounting Platform Connection

Connect to your Accounting Platform. You must connect to your accounting package before you can configure your Wise-Sync Company settings.

Wise-Sync will try to detect that you're already logged into your accounting package in your browser session. If you're not signed in, you will be prompted to to finalise the connection.

Supported Browsers - Some versions of Internet Explorer may have undesired results - Chrome, Firefox or Safari are best used to perform the connection to your accounting package.

Company NameEnter the name of the company.
LocaleSelect the locale for your taxation system, this will define the tax codes which are available to select from in the next screens. The locale cannot be changed once it has been set.
Post Sales Invoice As
Xero Only
Choose what to sync sales invoices as in Xero.

Draft Invoice
Wise-Sync will sync invoices as Draft Invoices requiring approval in order to be paid. Invoices will not appear as "Awaiting Payment" until approved.

Approved Invoice
Wise-Sync will sync invoice as Approved Invoices, available for payment.
Apply 'Sent' flag when posting invoice to Xero
Xero Only
Tick to mark invoices as sent in Xero.
Post Purchase Bills As
Xero Only
Choose what to sync purchases as in Xero.

Draft Bill
Wise-Sync will sync bills as Draft Bills requiring approval in order to be paid. Bill will not appear as "Accounts Payable" until approved.

Approved Invoice
Wise-Sync will sync bills as Approved Bills, available for payment.
Time Zone
Timezone OffsetEnter the Timezone of where your ConnectWise server is located. This is required to ensure that the "Get Unposted Transactions" returns results based on your location.
GL Owner Levels

Define the ConnectWise company owner level (Billing Location) that you wish to sync. Leave this blank to sync all locations.

These settings are only required if you have more than one billing location in ConnectWise and are syncing these 'owner levels' to more than one organisation.

Click + to add multiple levels.

Tracking

Tracking

Before enabling Tracking, ensure that:

  1. Your accounting package has Tracking enabled and Tracking Classes/Categories have been configured
  2. That your Tracking Classes/Categories are configured in the ConnectWise GL Account Setup.
  3. That your Tracking Classes/Categories have been defined in your Wise-Sync Account.
Enable tracking classesTick to enable Tracking classes to be updated on the invoice lines.
Create missing tracking classes
Quickbooks Online Only
Tick to allow Wise-Sync to create tracking classes, if they are missing.
Tax Codes
QBO US Tax: Override Sales Tax Level
Quickbooks Online Only
This setting applies to items that are marked as "Taxable" in ConnectWise.
If QBO AST is in use, select Override Sales Tax Option - as described in QBO Automated Sales Tax (US Region).
Tax code when soldThis setting applies to items that are marked as "Taxable" in ConnectWise. Select the Tax Code source to apply to the invoice in your accounting package.

The first option allows you to choose a tax code from your accounting package to apply to all taxable items when sold.

Tax Group
This will apply the tax code of the company the invoice is made out to in ConnectWise.

Tax Level
This will apply the tax code of the invoice in ConnectWise.

GL Entry
This will apply the tax code of the GL Entry in ConnectWise.
Tax code when boughtThis setting applies to items that are marked as "Taxable" in ConnectWise. Select the Tax Code source to apply to supplier invoices (bills) in your accounting package.

The first option allows you to choose a tax code from your accounting package to apply to all taxable items when purchased.

Tax Code (Vendor)
This will apply the tax code of the company the purchase order is made out to in ConnectWise.

Tax Code (Purchase Order)
This will apply the tax code of the purchase order in ConnectWise.

GL Entry
This will apply the tax code of the GL Entry in ConnectWise.
Create tracking class for tax lines
Quickbooks Only
This setting applies to items that are marked as "Taxable" in ConnectWise and where applying the tax code from GL Entry in ConnectWise.

Tick to allow Wise-Sync to create the tracking class for tax lines.
Tax exempt when soldThis setting applies to items that are not marked as "Taxable" in ConnectWise.

Choose a tax code from your accounting package to apply to all tax exempt items when sold.
Tax exempt when bought
Xero Only
This setting applies to items that are not marked as "Taxable" in ConnectWise.

Choose a tax code from your accounting package to apply to all tax exempt items when purchased.
Tax exempt compliance levelThis setting applies to items that are not marked as "Taxable" in ConnectWise.

Choose how Wise-Sync handles the sync of transactions that aren't compliant.

None
Wise-Sync will sync the transaction with no warning or error that a transaction is non-compliant.

Warning
Wise-Sync will sync the transaction with a warning that a transaction is non-compliant.

Halt Batch
Wise-Sync will stop the sync with an error that a transaction is non-compliant.
Tax Code Rates

This is a list of tax codes from your accounting package, that you will need to make sure are configured in ConnectWise.

Adjustment Items

Adjustment Items

Wise-Sync will attempt to make minor adjustments where the invoices lines do not match the invoice header. Define how Wise-Sync handles these adjustments.

Adjustment item codeThe value will default to WISESYNC_ADJUSTMENT. It shouldn't need to be changed as it allows the adjustment to be easily identifiable when looking at the invoice in your accounting package.
Adjustment item sales accountSelect the GL account from your accounting package to post the adjustments for sales.
Adjustment item sales tax
Xero Only
Select the tax code from your accounting package to apply to adjustments for sales.
Adjustment item purchase accountSelect the GL account from your accounting package to post the adjustments for purchases.
Adjustment item purchase tax
Xero Only
Select the tax code from your accounting package to apply to adjustments for purchases.
Limit Adjustments AmountThe amount use as the limit to display errors where the adjustment calculated is less than or greater to the amount specified here.

This is defaulted to 10.00. Keep the amount low - if you need to increase this amount, think about whether the resulting adjustments would be due to a bigger process problem.

Set this setting to 0 (zero) if you wish to ignore errors
Rounding Items

Rounding Items

Wise-Sync will attempt to round invoices where lines do not match the invoice header. Define how Wise-Sync handles rounding.

Rounding item codeIt shouldn't need to be changed. This allows the adjustment to be easily identifiable in the invoice in the accounting interface.
Rounding item sales accountSelect the GL accounts from your accounting package to post the adjustments for sales.

Tick Check to use item sales account instead to override the selected account.
Rounding items sales taxSelect the tax code from your accounting package to apply to adjustments for sales.
Rounding item purchase accountSelect the GL accounts from your accounting package to post the adjustments for purchases.

Tick Check to use item purchase account instead to override the selected account.
Rounding item purchase taxSelect the tax code from your accounting package to apply to adjustments for purchases.
Limit Rounding AmountThe amount use as the limit to display errors where the adjustment calculated is less than or greater to the amount specified here.

This is defaulted to 10.00. Keep the amount low - if you need to increase this amount, think about whether the resulting rounding would be due to a bigger process problem.

Set this setting to 0 (zero) if you wish to ignore errors.
Procurement Options

Procurement Options

Available on Sync Ninja and Mr Miyagi plans only.

Part ship purchase ordersTick to sync part shipped purchase orders to your accounting package. ConnectWise will batch part shipments as supplier invoices to your accounting package by Packing Slip ID.

See Explaining the Supplier Invoice Process for more information.
Part ship purchase compliance levelAvailable when Part ship purchase orders is ticked.

Wise-Sync can check if items are received on the same Packing Slip ID at different times. Choose how Wise-Sync handles this this compliance.

None
Wise-Sync will sync the purchase order with no warning.

Warning
Wise-Sync will sync the purchase order and provide a warning.

Halt Batch
Wise-Sync will not sync the purchase order and provide an error.
Vendor invoice date sourceChoose the ConnectWise source to apply as the invoice date of the supplier invoice in your accounting package.

See Selecting Alternate Purchase Order Invoice Dates for more information.
Payment Sync Options
Payment Sync Cutoff DateTick to stop Wise-Sync from syncing payments before the selected date.
To use this feature, Wise-Sync users must have their REST API Keys configured. See How to create REST API Keys for a ConnectWise Member for more information.
Payment Sync Invoice Number Override
Xero Only
Tick to include the invoice reference to match against the ConnectWise Invoice number, for invoices dated before the entered conversion date.
Enter a conversion date.
Inventory

Learn more

Available on Sync Ninja and Mr Miyagi plans only. Both plans must be subscribed to Enhanced Support.

Read ConnectWise Inventory Overview to learn more about COGS Inventory.

Enable COGS InventoryTick to enable.
Expenses

Learn more

Read ConnectWise Expenses Overview to learn more about ConnectWise Expenses.

Weekly group expenses by Member IDTick to group expenses weekly by Member ID.
Expenses Tax Code
(Xero Only)
Select the tax code from your accounting package to apply to synced expenses.
Required expenses approval statusSet the approval level required.

Any
Pending Approval
Approved Tier 1
Approved Tier 1 and Approved Tier 2
Require second tier approval (Project Manager) for project ticketsTick if a second tier of approval is required for project tickets.
Required expenses billing statusChoose the billing status of synced expenses.

Any
Awaiting Approval
Ready to Bill
Billed
Expense approval sync notificationSilent
Error
Save reimbursable expenses asChoose how to save Reimbursable expenses.

Draft Bill - Xero Only

Employee Reimbursable expense claims will be synced to Xero as Draft Bills requiring approval in order to be paid.
Invoices will not appear in a "Accounts Payable" list until approved.

Approved Bill
Employee Reimbursable expense claims will be synced to the accounting package as Approved Bills, available for payment.
Save company paid expenses asChoose how to save Expense Bills paid by a Company Account.

Offset Account (Paid Bill)
Offset provides for the simplest management of expenses where expenses are allocated to an Unclaimed Expenses Account (Liability).
This account can then be used to clear payments made for expenses from reconciled accounts or manual journals.

Draft Bill - Xero Only
Company Paid expense claims will be synced to Xero as Draft Bills requiring approval in order to be paid.
Invoices will not appear in a "Accounts Payable" list until approved.

Approved Bill
Company Paid expense claims will be synced to the accounting package as Approved Bills, available for payment.
Default offset accountIf Save company paid expenses as is set to Offset Account (Paid Bill) is set, Wise-Sync will allocate all expenses to this account.
Default offset item codeEnter a Current Liability account from your accounting package to be used to offset invoice line items.
Company personal expense accountChoose the account from your accounting package to post personal expenses that are to be reimbursed to the company.
Reimbursable Prefix - (reference)Set a prefix for the Bill Reference and the Batch Transaction ID for Reimbursable expenses for easy differentiation.

The prefix is defaulted to RE. Alter the prefix to suit your requirements.

Reimbursable expenses will be synced as RE-xxxx.
NonReimbursable Prefix - (reference)Set a prefix for the Bill Reference and the Batch Transaction ID for NonReimbursable expenses.

The prefix is defaulted to NRE. Alter the prefix to suit your requirements.

NonReimbursable expenses will be synced as NRE-xxxx.
Personal Prefix - (reference)Set a prefix for the Bill Reference and the Batch Transaction ID for Personal expenses for easy differentiation.

The prefix is defaulted to PE. Alter the prefix to suit your requirements.

Personal expenses will be synced as PE-xxxx..
P
Paul is the author of this solution article.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.