GL Entries Tab in ConnectWise Invoice Search
The GL Entries tab appears on an invoice only after it reaches a closed status. It shows all account allocations ConnectWise generated for that invoice, based on your GL Accounts Setup Table configuration.
List view columns
Each row in the list view represents one account allocation line. The columns are:
| Column | What it shows |
|---|---|
| Batch Id | The batch ID for the invoice. |
| Type Name | The account type. |
| Description | The product description. |
| Account | The account number or account name from your accounting package. |
| Debit | The amount debited in your accounting package. |
| Credit | The amount credited in your accounting package. |
| Cost | Total cost of the time, product, or expense tied to this GL account on the invoice. |
| GL Product ID | The product ID from your accounting package. |
| Sales Code | The sales code (similar to Item ID). |
| COGS | The Cost of Goods Sold account number. |
| Inventory | The inventory account number. |
| Last Update | When this GL entry was last updated. |
Field descriptions
Selecting a row opens the GL entry detail. The fields map directly to what gets sent to your accounting package.
Account Type — Indicates what kind of account to enter in the Account field. For revenue and expense items, this also identifies which part of ConnectWise the revenue or expense originates from, so you can route different revenue or expense types to different accounts.
Amount — Total amount of the time, product, or expense tied to this GL account on the invoice.
Description — The product description.
Account — The account number or account name from your accounting package. This must match exactly. If your accounting package uses multiple segments, you may see multiple Account fields depending on how many segments are configured in the Accounting Package Setup Table.
Class — The class from your accounting package. This field only applies when the Accounting Segments Type in the Accounting Package Setup Table includes a Class segment.
- For QuickBooks: Class equals a location/company or department.
- For Dynamics GP: Class equals the Product Class ID set up in GP, which also matches the ConnectWise product’s Category or Sub-category.
Product ID — A product ID from your accounting package. Required by some accounting packages, optional for others. Accounting packages that use this field reference it to identify items in the General Ledger for reporting. For QuickBooks: what you enter here appears in the Item column on QuickBooks invoices. Leaving it blank in time entries will leave the Item field blank on the QuickBooks invoice.
Cost — Total cost of the time, product, or expense associated with this GL account on the invoice.
Sales Code — Used only for Sage ERP integrations.
COGS — Cost of Goods Sold account number.
Inventory — Inventory account number.
Note: When batching a product that does not yet exist in your accounting package, ConnectWise uses the COGS, Cost, Sales Code, and Inventory fields to create the product. If the product already exists in your accounting package, your accounting package settings override the values shown here.