2. Setup Wise-Sync Company


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

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!


TabSettingWhat to do
Company OptionsAccounting 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 ZoneTimezone 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.
TrackingEnable tracking classesTick to enable Tracking classes to be updated on the invoice lines.
Before enabling this option 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.
Create missing tracking classes
Quickbooks Online Only
Tick to allow Wise-Sync to create tracking classes, if they are missing.
Tax CodesQBO 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 lists the tax codes from your accounting package, that you will need to make sure are configured in ConnectWise.
Adjustment ItemsAdjustment item codeWise-Sync will attempt to make minor adjustments where the invoices lines do not match the invoice header.

Define how Wise-Sync handles the adjustment:
The 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 ItemsRounding item codeWise-Sync will attempt to round invoices where lines do not match the invoice header.

Define how Wise-Sync handles the rounding:
It 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 OptionsPart ship purchase ordersAvailable on Sync Ninja and Mr Miyagi plans only.

Tick 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 OptionsPayment 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.
InventoryEnable COGS InventoryAvailable on Sync Ninja and Mr Miyagi plans only. Both plans must be subscribed to Enhanced Support.
Tick to enable.
See ConnectWise Inventory Overview for more information.
Expenses
See ConnectWise Expenses Overview for more information.
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 REAlter 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 NREAlter 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 PEAlter the prefix to suit your requirements.
Personal expenses will be synced as PE-xxxx.
Contact OptionsAppend account name to company nameTick to append the Account Name to the Company Name for all customers/suppliers in your accounting package.
The Account Name is sourced from the Company Finance page of the Customer/Vendor in ConnectWise.
E.g. If Company Name is Wise-Sync and Account Name is WSC001, the company in your accounting package will be Wise-Sync (WSC001).
Invoice OptionsShow unit of measureTick to display the unit of measure for products sold in ConnectWise.
Include project referenceTick to include a project reference prefix.
The prefix is defaulted to Project. Alter the prefix to suit your requirements.
Include your PO ReferenceTick to include a Your PO reference prefix.
The prefix is defaulted to Your PO. Alter the prefix to suit your requirements.
Service Invoice Detail LevelChoose the level of detail to sync services.
See ConnectWise - Time Details to Invoice Lines for more information.
Service Date HandlingConfigurable only when Service Invoice Detail Level is set to Detailed. Choose where the service date appears on the invoice line in your accounting package.
Item Service Date - Quickbooks Online Only
Wise-Sync will sync the service date to the Service Date field of the invoice line
Item Details
Wise-Sync will append the service date to the Description of the invoice line.
Extended Product ID Length Handling
Xero Only
Xero has a 30 character limit on item codes.
Choose how Wise-Sync handles ConnectWise products that exceed the 30 characters limit.

None
Wise-Sync will use the ConnectWise product name as the item code. This is the default setting.

Truncate
Wise-Sync will use the first 30 characters of the product as the item code.

Product ID
Wise-Sync will use the ConnectWise Product's unique database ID as the item code.

QBO AST Shipping Address Handling
Quickbooks Online Only

QBO has introduced Multiple Business Location support as part of the Automated Sales Tax functionality where you can calculated business tax even in a different location. Read more about this - Set up and use automated sales tax (if the article doesn't load, view it in incognito mode - there's an issue with the rendering of the QBO support portal which makes it difficult to read and navigate).

We identified that this is a problem that when syncing invoices to Quickbooks Online, where the tax applied by QBO's Automated Sales Tax was incorrect because the location the item was sold from wasn't being represented in the QBO invoice. Control how Wise-Sync handles shipping address coming from ConnectWise Manage. If you are collecting sales tax from multiple tax agencies, we encourage that you enable this feature.

Sync Shipping From
Wise-Sync will take the address of the location/territory of the invoice and set this as the Shipping From address. If the ConnectWise Manage location/territory does not have an address configured, the QBO invoice Shipping From address will be populated with the primary address configured in your QBO Company.

Sync Shipping To
If the invoice in ConnectWise Manage contains an address to ship to, that address sync over as the Shipping To address in QBO. Otherwise, Shipping To in QBO will be blank. 

Static Account MappingsEnable static mappings for all revenue typesBy default, Wise-Sync will use the Account Codes in the ConnectWise GL Entry to post to the General Ledger in the accounting package.
Tick to allow Wise-Sync to post revenue to a default accounts, defined here, in the instance a ConnectWise GL Entry isn't provided.
Use all set static account instead of ConnectWise GL entry.Tick to ignore ConnectWise GL entries (regardless of whether a GL Entry is provided from ConnectWise or not) and post to the Static Mappings defined here instead.
Disable warnings for default accountsTick to disable warnings about where Wise-Sync has had to fall back to a static account mapping. The warning looks like this:
A Static revenue account {Static Account ID - Name} has been applied for {revenuetype} revenue type. Check your GL Account Mappings to ensure that a valid account is provided for all mappings.
Static MappingsTick to select the GL Mapping you wish to make static. Then, select the account from your accounting package to post to.
Here is a list of GL Mappings you can make static:
  • Revenue
  • Default COGS
  • Revenue Expenses
  • Revenue-Agreements
  • Revenue-Agreement-Products
  • Revenue Products
  • Deferred Revenue
  • Expense-Internal
  • Expense-External
  • Inventory Adjustments
  • Product Discounts


Where a mapping has not been set, Wise-Sync will not be able to fall back to a static mapping for that revenue type. An error may be seen on sync similar to this:

A Non-ProductID has not been provided for Revenue {Revenue Type} and the awesome feature Set Static Non-ProductID {StaticID} has been disabled for this revenue type. Check your GL Account Mappings to ensure that a Non-ProductID is provided for all non-product revenue.

CurrencyEnable Multiple Currency SupportTick to enable.
To sync Multi-Currency invoices, ConnectWise 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. Where there is a mismatch of currencies in both Autotask and your Accounting Package, invoice sync will fail.

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.