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. Only available when posting invoices as Approved.
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 Bill
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 Manage 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 Manage and are syncing these 'owner levels' to more than one organisation.

Click + to add multiple levels.

Tracking

Procurement Options

Available on Sync Ninja, Sync Master and Mr Miyagi plans only.

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 Manage.
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 Manage. 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 Manage.

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

GL Entry
This will apply the tax code of the GL Entry in ConnectWise Manage.
Tax code when boughtThis setting applies to items that are marked as "Taxable" in ConnectWise Manage. 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 Manage.

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

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

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 Manage.

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 Manage.

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 Manage.

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 Manage.

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 item 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 stop adjustments from occurring
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 stop adjustments from occurring
Procurement Options

Procurement Options

Available on Sync Ninja, Sync Master 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.
Inventory

Learn more

Available on Sync Master 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..
Contact Options
Append Account Name to Company NameEnable to show the "Account Name" for all Customers and Suppliers in XERO. The account name is located on the Finance Page in Connectwise. This name / code will then be appended to the "Company Name"
Invoice Options
Show unit of measureEnable to display the UoM (unit of measure) for products sold in ConnectWise.
Include Project Reference Tick the box to use Prefix
Include Your PO ReferenceTick the box to use Prefix
Service Invoice Detail Level

Standard - No detail, only "Service" will appear

Summary- Ticket Summary, including ticket number

Detail - Full detail of Billable Time entry.

Service Date HandlingChoose where the service date appears on the invoice line in your Accounting Package. Select Item Details to append the service date to the Description of the invoice line. Configurable only when Service Invoice Detail Level is set to Detailed.
Extended Product ID Length Handling 

Default: Use the ConnectWise Product name as the item code by default.

Truncate: Uses the first 30 characters of the product as the item code

Product ID: Uses the ConnectWise Product's unique database ID as the item code

QBO AST Shipping Address Handling (QBO AST only)
QBO Automated Sales Tax will calculate sales tax based on where you are selling items from and where you are selling them to, for each tax agency in QBO. Choose how Wise-Sync handles shipping address from ConnectWise. If you are collecting sales tax from multiple tax agencies, we encourage that you enable this feature.
Sync Shipping From
Tick to sync the invoice's location address from ConnectWise to QBO. If the location/territory is missing an address (or the option is disabled), the primary address configured in your QBO company will be used as the Shipping From address instead.
Sync Shipping To
Tick to sync the Ship To address from ConnectWise to QBO, if it's been set.
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.
Static Account Mappings
Enable static mappings for all revenue types Tick to enable account mappings for all revenue types.
This will override the GL mapping and post the transactions into these accounts with no breakup.
Currency
Enable Multiple Currency Support Enable or Disable.
To sync Multi-Currency invoices, ConnectWise Manage and your Accounting Package must have Multi-Currency enabled and both systems must contain matching currencies configured.
Invoices will be synced in the currency set in ConnectWise Manage. Where there is a mismatch of currencies in both ConnectWise Manage and your Accounting Package, invoice sync will fail.

A warning for Quickbooks Online users You cannot change a Customer's currency in Quickbooks Online, once it has been set.
Please ensure that before you start to sync invoices for your foreign customers, that the currency is configured in both ConnectWise Manage and Quickbooks Online. Quickbooks Online will set the Customer's currency to the Home Currency set in your Advanced Account Settings. See About Multi-currency for more information.
Exclude Batch Rules

You may select the Batch Rules to excluded based on Prefix, Record Type, Mark as paid and Batch Prefix

Onboarding Sync

This is used to handle existing records that are unposted quickly without having the hassle of creating manual batches.



Companies Activation Video:

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.