Accounting Package Setup > Xero Setup

Realigning your Account numbers to your chart of accounts will not affect the functions of reporting, it can in some circumstance help in the financial entry of transactions, by allowing users to type the account code, rather than the text (both will work).

Common Account Number Ranges

In principal ranges can be defined for any purpose, it is however recommended that the accounts are ranged to help in the grouping and reporting. The following represents a common table of accounting number ranges. The ordinal ranges can be arranged with or without the dash, in hundreds (100) or thousands (1000), it is really up to you and your accountant to work out the best CoA that fits the needs of the business.

Principles in Revenue and COGS Mapping

Good practice is to align your direct costs of sales to the direct revenues which are reported. This can help to identify your profitability of specific services or groups of services or products that you sell.

Cost of Goods Sold (COGS or COS) should align to your revneue in numbering, so that it can make coding of transactions and mapping Revenue and COGS in ConnectWise GL Accounts setup more intuitive.

Here's how to do it:

1. From the Settings Menu, select Chart of Accounts.

   Note: If it is not visible in the menu, select "General Settings" and then "Chart of Accounts"

2. Update your Chart of Accounts to reflect the changes required.

Xero Online Setup

• Have Account Numbers for each of your accounts in the Chart of Accounts.
• Added numbers to all of your Chart of Accounts.
• Setup at least one Tax Group in Xero
• Setup Matching Payment Terms between ConnectWise and Xero.

Once you have the above checked off, you are now ready to start the ConnectWise Setup Steps.

Wise-Sync will map ConnectWise tax based on the selection made in the Tax Codes setup in Wise-Sync. The recommended setting to ensure taxes are applied for each invoice is GST on Income. This setting will match the ConnectWise Tax Code Name on the Invoice to the Tax Rate Name in Xero.

Xero Tax Rates Setup

Here's how to do it:

1. Go to Settings > General Settings
2. Click Tax Rates
3. Add/Edit the Tax Rates you require to match up with your ConnectWise setup
4. Click New Tax Rate at the top of the screen
5. Enter the TaxCodeXRef based on your preferred selection - example GST on Income
6. Select the Tax Type
7. Enter Tax Components - ie: GST
8. In the Rate (Percentage) enter the Percentage of the tax component as a whole number -ie: 10%

Note: It is important to set the Xero Tax Rate Display Name to Match against ConnectWise Tax Code Description

ConnectWise Tax Rates Setup

1. Go to Set Up Tables > Invoicing > Tax Codes Screen > Add Tax Code
2. In the Setup Screen, Enter the Same Name as defined in the ConnectWise Tax Code Description
3. Enter the Rate (as whole units I.e. 10% = 10)

Xero supports three different tax structures

• Static: Where a single rate is applied to the invoice and payable to a single tax agency
• ConnectWise Group: Where a (combined) set of tax rates payable to different agencies is set for each invoice.
• ConnectWise Tax Line: Where a multiple level tax calculation can be set for each line on an invoice. Each level of the ConnectWise Tax Group (level) is mapped to a specific Xero tax rate.

Wise-Sync will map ConnectWise tax based on the selection made in the Tax Code setup in Wise-Sync. The recommended setting to ensure taxes are applied for each invoice should be set to "Tax Group", as this will match the ConnectWise Tax Code Name on the Invoice to the Tax Rate Name in Xero.

To access the Tax Rates page in Xero, click Settings > General Settings > Tax Rates

Step 1: [Check] Add Tax Rates for each of your required tax rates as per the ConnectWise setup

Xero will load with default Tax Rates. However tax rates applicable to your use and sales will be required to be added. You will be required to add each tax rates based on your preferred mapping level, Static, Group, Line.

Here's how to do it:

1. Click on "New Tax Rate" button at the top of the form
2. Enter the Tax Group | TaxCodeXRef based on your preferred selection below
3. In the Component Setting, add the Tax Agency Name
4. In the Rate (Percentage) enter the Percentage of the tax component as a whole number.
5. Press Save

Step 2: Create a Single Tax Rate

Here's how to do it:

1. Press the "New Tax Rate" button to create a Single Tax Rate

   Note: If you already have Tax Rates setup in Xero, then you only need to check the names match between the systems.

2. If you require a Multi-Component Tax Rate, press Add a Component

   Single: If you only need to pay a single Agency.

   Combined: If you need to pay multiple Agencies.

3. Set the Xero Tax Rate Display Name to Match against ConnectWise Tax Code Description