ConnectWise Accounting Package Setup Table

The Accounting Package setup table controls how ConnectWise Manage exports invoices, expenses, and procurement items to your accounting software — QuickBooks, Microsoft Dynamics GP, or another supported package.

The table has two required tabs: Accounting Package and Accounting Package Path. Both must be configured for the integration to work.

Set Up the Accounting Package

1. Go to System > Setup Tables > Accounting Package.
2. In the Accounting Package field, select your accounting software from the drop-down. If your package is not listed or you use a third-party integration, select Other.
3. If you use Microsoft Dynamics GP or QuickBooks, select the Direct Transfer checkbox. This is the recommended transfer method. Leaving it deselected also disables the Product Type Setup Table for product type configuration.
4. Configure the remaining options on the Accounting Package tab (see field descriptions below).
5. Select Save.
6. Select the Accounting Package Path tab.
7. Select the New Item icon.
8. Enter the required path information (see field descriptions below).
9. Select Save And Close.

Note: The five settings below — when configured here — also become the defaults on the Accounting Interface screen. You can override them per-run on that screen.

• Include Invoices
• Invoice Format
• Include Expenses
• Expense Format
• Include Procurement Items

Warning: Sage ERP 100 and Sage ERP 100 v4 are legacy integrations. You cannot create new accounting package setups with these versions. Existing setups continue to work, but new integrations should use a supported package from the ConnectWise Marketplace.

Accounting Package Tab Fields

Accounting Package Setup

Field	Description
Accounting Package	Select your accounting software. Options: Microsoft Dynamics GP, QuickBooks, Sage ERP 100, Sage ERP 100 v4, Other.
Direct Transfer	Select to export records directly to the accounting package. Recommended for Dynamics GP and QuickBooks. Required to configure product types.

Invoice Options

Field	Description
Include Invoices	Select to include invoices in the export. Sets the default on the Accounting Interface screen.
Invoice Format	Select the level of invoice detail sent to the accounting package. Becomes the default on the Accounting Interface screen.

Invoice Format options:

• Default — Posts invoices with minimal information.
• Condensed — Posts a summary per work type:
  • Projects: project name / project phase.
  • Service tickets: ticket number / summary line. Multiple tickets on one invoice are separated by ticket number.
  • Special Invoice / Miscellaneous, Down Payment, Credit Memo: maps to the corresponding type in QuickBooks if there is an amount in the Service field.
  • Agreements: the agreement name appears as the caption when there is an amount in the Billing Amount field.
  • Activities: the subject of the activity transfers if it is billable.
• Detailed — Posts full time entry detail. Available for Dynamics GP, QuickBooks, and Other.
  • Dynamics GP: Details go into the product description (truncated at 100 characters) and the product comment (limited to 500 characters). For each time record: ticket number, work role, work type, resource name, ticket summary, time entry notes, hours (quantity), and rate. Time entries must be set up as a Service class item in Dynamics GP to allow decimal quantities. A Product ID and Class on the GL entry are required — if the product is not found in Dynamics GP, the invoice does not post.
  • QuickBooks: Details go to the Summary column. For each time entry: ticket number, work role, work type, resource name, ticket summary, time entry notes, hours (quantity), and rate.

Note: Time entries are summed per ticket. If different rates exist on the same ticket, each rate becomes a separate line item in the accounting package.

Expense Options

Field	Description
Include Expenses	Select to include expenses in the export. Sets the default on the Accounting Interface screen.
Transfer Expense as a Bill	Select to export expense items directly to accounts payable. Requires that the member’s Vendor Number in the System pod of the Members Details tab matches the vendor set up in the accounting package.
Expense Format	Select how expenses are grouped. Default: summary entry per GL expense account, grouped by expense type. Condensed: individual journal entries per expense type. Becomes the default on the Accounting Interface screen. Only available when Transfer Expense as a Bill is deselected.

Miscellaneous Options

Field	Description
Suppress Memo Entry	Select to hide the batch import memo (“Imported from ConnectWise (Batch:XXBatchIDXX)”) from the Invoice Memo field. That text can appear on statements and reports in your accounting software.
Sync Payment Info From Accounting Package	Select to sync payments from a supported accounting package back to ConnectWise Manage. Available for Dynamics GP and QuickBooks with Direct Transfer selected.
Sync WisePay Payments to Accounting Package	Select to sync WisePay payments from ConnectWise Manage to QuickBooks.

Note: Sync WisePay Payments to Accounting Package requires the WisePay API lab to be enabled. To disable the feature, go to System > Setup Tables > PSA Labs and turn off the WisePay API lab.

Sales Tax Options

Field	Description
Include Sales Tax	Select to transfer tax amounts to the appropriate tax items in the accounting package.
Enable Tax Groups	Select if your accounting package uses tax groups (common when paying tax to multiple jurisdictions — state, city, county, or parish). When selected, all tax levels after level 1 post into the tax area of the invoice. When deselected, additional tax levels post as line items. If unsure, consult your accountant.
Set Zero Dollar Tax Amounts to Non-Taxable	Select to prevent zero-dollar products from appearing as taxable in the accounting package.

Product Options

Field	Description
Include Procurement Items	Select to export completed purchase orders, adjustments, and transfers. Sets the default on the Accounting Interface screen.
Include SOH Option	Select to post products using the item ID. Product IDs in ConnectWise must match item IDs in the accounting package. When selected, inventory counts in the accounting package decrease with each sale. When deselected, you can assign a GL account item from the GL Accounts Setup Table instead.
Send Component Amount	Select to control whether component prices carry over to the accounting package for bundle products. See bundle pricing behavior below.
Send UOM with Products	Select to transfer units of measure (UOM) from ConnectWise to QuickBooks. Only available for QuickBooks with Direct Transfer.
Include COGS Entries	Select to include cost of goods sold entries on the export file for non-inventoried line items during direct transfer. Does not affect COGS for products on an invoice — those transfer automatically if the product exists in Dynamics GP with a product ID and COGS fields filled in the GL account.
Include COGS and Inventory on Drop Ship Item	Select to use COGS and inventory account information for drop-shipped items. When deselected, drop-shipped items use the default distributions. Only available for Dynamics GP with Direct Transfer.

Send Component Amount — bundle pricing behavior:

The setting interacts with the Bundle Pricing method. The table below shows which price carries over:

Send Component Amount	Bundle Pricing Method	What carries over
Selected	List Price	Main bundle price ($0 for components)
Deselected	List Price	Main bundle price ($0 for components)
Deselected	Calculated Price	Main bundle price ($0 for components)
Selected	Calculated Price	Component prices ($0 for main bundle)

Note: Send Component Amount only applies to new invoices. To update existing invoices, re-open and re-close each invoice to regenerate the GL entries.

Send UOM with Products — prerequisites:

• The UOM Schedule Cross Reference field in the UOM Setup Table must have a matching cross-reference in QuickBooks. Inventory adjustments fail if the UOM does not exist in QuickBooks.
• In QuickBooks, go to Edit > Preferences > Items & Inventory. On the Company Preferences tab, select Multiple U/M Per Item.
• The UOM in ConnectWise must match the U/M set for the product in QuickBooks.
• UOM is not sent for other charge products, product discount products, or Avalara tax lines.

Note: Send UOM with Products requires a QuickBooks license that supports multiple units of measure. Transfers fail if the QuickBooks version does not support multiple U/M.

Account Segments

Field	Description
Segments	Enter the number of account segments (1–10) used to build account numbers. Must match the segment count in your accounting package. At least one segment is required.
Account segment name and type	Enter a label for each segment (for example: Account, Class, Group, Location) and select the field type. For QuickBooks, use Account or Class. Dynamics GP, Sage ERP 100, and Sage ERP 100 v4 do not accept Class.

COGS Segments

Field	Description
Segments	Enter the number of COGS account segments (1–10). Must match the COGS segment count in your accounting package.
COGS segment name and type	Enter a label for each segment. The type is fixed to Account and cannot be changed. Class is not available for COGS segments.

Note: COGS segments follow the same roll-up logic as Account Segments.

Accounting Package Path Tab

The Accounting Package Path tab sets the file or database path ConnectWise uses to connect to your accounting software. This tab is active for QuickBooks and Microsoft Dynamics GP. For all other packages, the tab is grayed out.

The list view shows:

Column	Description
Location	The ConnectWise location associated with this path.
Accounting Package Path	The path configured in path setup. Must be copied and pasted into this field — do not type it manually.
Last Update	Date and time the path was last saved.

QuickBooks Path Setup

Field	Description
Location	Select the ConnectWise location to transfer invoices from. Select Default to use the same path for all locations. Multiple locations can share one path — create a separate GL path entry for each location.
Company File Path	Paste the full path to the QuickBooks company file here.

Note: The file extension must be lowercase (.qbw, not .QBW).

Important: QuickBooks must be open using the same method each time you run the integration. If the method changes (for example, switching between local and network launch), the connection fails.

Microsoft Dynamics GP Path Setup

Field	Description
Location	Select the ConnectWise location to transfer invoices from. Select Default to use the same path for all locations.
SQL Server	Enter the name of the SQL server where the Dynamics GP database resides.
Database	Enter the name of the Dynamics GP database.

Option Availability by Accounting Package

Not all options are available for every accounting package and Direct Transfer combination. The table below shows which options are active.

Option	GP (no DT)	GP (DT)	Other	QB (no DT)	QB (DT)	Sage 100	Sage 100 v4
Include Invoices	Yes	Yes	Yes	Yes	Yes	Yes	Yes
Invoice Format	Yes*	Yes*	Yes*	Yes*	Yes*	Yes*	Yes*
Include Expenses	Yes	Yes	Yes	Yes	Yes	Yes	Yes
Transfer Expense as a Bill	Yes	Yes	Yes	No	Yes	No	No
Expense Format	Yes**	Yes**	Yes**	Yes	Yes**	No	No
Suppress Memo Entry	Yes	Yes	Yes	Yes	Yes	Yes	Yes
Sync Payment Info	No	Yes	No	No	Yes	No	No
Include Sales Tax	Yes (locked on)	No	Yes	Yes	Yes	Yes (locked on)	Yes (locked on)
Enable Tax Groups	Yes	Yes	No	No	Yes	No	No
Set Zero Dollar Tax to Non-Taxable	Yes	Yes	Yes	Yes	Yes	Yes	Yes
Include Procurement Items	No	Yes	Yes	No	Yes	No	No
Inventory SOH Option	Yes (locked on)	Yes (locked on)	Yes	Yes	Yes	No	No
Send Component Amount	Yes	Yes	Yes	Yes	Yes	Yes	Yes
Send UOM with Products	No	No	No	No	Yes	No	No
Include COGS Entries	Yes	Yes	Yes	No	No	No	No
Include COGS and Inventory on Drop Ship Items	No	Yes	No	No	No	No	No

*Requires Include Invoices to be selected. **Requires Include Expenses selected and Transfer Expense as a Bill deselected.

DT = Direct Transfer.