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 Name | Enter the name of the company. |
| Locale | Select 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 Offset | Enter 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.
If you have Real-Time Sync enabled in your Account settings, you must select the ConnectWise GL Owner level/s for the ConnectWise Location/s you wish to auto-sync invoices for and check the 'Enable Auto-Sync' box for each Location
Tracking
Procurement Options
Available on Sync Ninja, Sync Master and Mr Miyagi plans only.
Tracking
Before enabling Tracking, ensure that:
- Your accounting package has Tracking enabled and Tracking Classes/Categories have been configured
- Quickbooks Online - see Using Classes and Locations in Quickbooks Online
- Xero - see Setup tracking categories;
- That your Tracking Classes/Categories are configured in the ConnectWise GL Account Setup.
- See GL Accounts Setup Table and Accounting Package Setup Table for more information and;
- That your Tracking Classes/Categories have been defined in your Wise-Sync Account.
- See Tracking for Product Categories for more information.
| Enable tracking classes | Tick 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 sold | This 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 bought | This 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 sold | 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 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 level | This 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 code | The 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 account | Select 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 account | Select 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 Amount | The 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 code | 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 account | Select 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 tax | Select the tax code from your accounting package to apply to adjustments for sales. |
| Rounding item purchase account | Select 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 tax | Select the tax code from your accounting package to apply to adjustments for purchases. |
| Limit Rounding Amount | The 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 orders | 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 level | Available 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 source | Choose 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 Inventory | Tick to enable. |
Expenses
Learn more
Read ConnectWise Expenses Overview to learn more about ConnectWise Expenses.
| Weekly group expenses by Member ID | Tick 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 status | Set 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 tickets | Tick if a second tier of approval is required for project tickets. |
| Required expenses billing status | Choose the billing status of synced expenses. Any Awaiting Approval Ready to Bill Billed |
| Expense approval sync notification | Silent Error |
| Save reimbursable expenses as | Choose 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 as | Choose 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 account | If 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 code | Enter a Current Liability account from your accounting package to be used to offset invoice line items. |
| Company personal expense account | Choose 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 Name | Enable 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 measure | Enable to display the UoM (unit of measure) for products sold in ConnectWise. |
| Include Project Reference | Tick the box to use Prefix |
| Include Your PO Reference | Tick 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 Handling | Choose 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 Date | Tick 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: