ConnectWise Accounting Checklist
Use this checklist when configuring accounting in ConnectWise Manage for the first time, or when auditing an existing setup. For the mapping of PSA records to their accounting-side equivalents, see How PSA Integrates with Your Accounting Package.
Sales Tax Setup
Go to System > Setup Tables > Invoicing > Tax Code.
| Task | Notes |
|---|---|
| Create tax codes | Create a tax code for every specific tax situation that applies to your customers. |
| Tax Code Xref | Set the Tax Code Xref on each tax code level. The value must match the tax code name exactly as it appears in your accounting package. |
| Agency Xref | Set the Agency Xref on each tax code level. The value must match the agency code name exactly as it appears in your accounting package. |
Expense Setup
Go to System > Setup Tables > Expense > Expense Type.
| Task | Notes |
|---|---|
| Create expense types | Set up expense types before mapping GL accounts. Each expense type can be mapped to a specific GL account. |
Company Finance Setup
Go to Finance > Company Finance > Company.
| Task | Notes |
|---|---|
| Billing contact | Set the billing contact on the Summary tab — the individual who receives invoices for this company. |
| Account name | Enter the customer name or customer ID exactly as it appears in your accounting package. Invoices can’t close without this. |
| Tax code (site) | Go to Sites and set the tax code for the customer’s site if it differs from the company default. |
| Billing terms | Set the default billing terms for this customer. These terms appear on all their invoices. |
| Invoice delivery | Set the preferred delivery method for invoices sent to this customer. |
Member Setup
Go to System > Members > Details.
| Task | Notes |
|---|---|
| Vendor number | Set the Vendor Nbr for any member whose expenses you reimburse through Accounts Payable in your accounting package. |
Structure Setup
Go to System > My Company > Structure > Level.
| Task | Notes |
|---|---|
| Sales Rep Xref | Set the Sales Rep Xref on each applicable level. The value must match the sales rep name or ID exactly as it appears in your accounting package. Financial data for companies at that level transfers to this rep for commission reporting. |
Product Setup
| Task | Location | Notes |
|---|---|---|
| Product types | System > Setup Tables > Products > Product Type | Create product types and set the corresponding Type Xref. The xref sets the item type when creating a new product in your accounting package. |
| Product subcategories | System > Setup Tables > Products > Subcategory | Create subcategories to associate with individual products. Subcategories can map to specific GL accounts. |
| Individual products | System > Products | Set up individual product records after types and subcategories are in place. |
Vendor Setup (Procurement Module)
Go to Finance > Company Finance > Company.
| Task | Notes |
|---|---|
| Vendor Xref | Set the Vendor Xref for each vendor using the Procurement module. The value must match the vendor name exactly as it appears in your accounting package. If the vendor is also a customer, you may need to set the Account field as well. |
Inventory Setup (Procurement Module)
Go to System > My Company > Owner.
| Task | Notes |
|---|---|
| Inventory costing method | Under Purchasing and Inventory Setup Options, set the costing method: Average Costing, LIFO, or FIFO. This applies to all Inventory class products and must match the setting in your accounting package. |
Note: The inventory costing method cannot be changed after transactions exist. Set this before entering any inventory.
Accounting Package Setup
Go to System > Setup Tables > General Ledger > Accounting Package.
| Task | Notes |
|---|---|
| Configure accounting package | Select your accounting package and configure the connection settings used to pass data out of ConnectWise Manage. |
GL Accounts Setup
Go to System > Setup Tables > General Ledger > GL Accounts.
| Task | Notes |
|---|---|
| Map GL accounts | Set up the GL Accounts table to map journal entries from ConnectWise data to your accounting package. |
Note: GL account mapping drives how every transaction exports. Errors here cause silent mismatches in your accounting package — double-check each mapping against your chart of accounts before going live.