Skip to main content
Integrations

ConnectWise PSA (Ready to Agreement)

How BillingBot works when your PSA is ConnectWise: it keeps the additions of each client's ConnectWise agreement up to date from the period's Pax8 charges, and ConnectWise creates the invoices. ConnectWise is not offered to customers yet.

Last updated 9 days ago

ConnectWise is not available to customers yet. It is being tested with a pilot, and the option to choose ConnectWise when you set up a new BillingBot account is switched off. If your PSA is ConnectWise and you would like to take part, contact TechPulse. Everything below applies only to an account whose PSA is ConnectWise; with HaloPSA or AutoTask you will not see any of it.

With ConnectWise, BillingBot does not create invoices. It keeps the additions (the products) of each client's ConnectWise agreement up to date with the period's Pax8 charges. ConnectWise then creates the invoices when your billing team runs Agreement Invoicing in ConnectWise, as usual.

Before you start

  • Only Pax8 is supported for now. Other distributors and Universal CSV files cannot be sent to ConnectWise yet.
  • If you already sync Pax8 to ConnectWise with Pax8's own integration, do not let BillingBot write the same clients: they would be billed twice.
  • BillingBot never creates agreements or catalog products in ConnectWise. Both must exist in ConnectWise first.

How it is set up

  1. Connect ConnectWise. When the BillingBot account is created, choose ConnectWise PSA and enter the ConnectWise Site (the address you sign in to, for example na.myconnectwise.net), the Company ID, and the Public Key and Private Key of an API Member. Create the API Member in ConnectWise under System > Members > API Members, with a security role that can read companies, the product catalog and agreements. Click Test Credentials to check the connection before you continue.
  2. Choose each client's agreement. In Client Management, use Assign Agreement on each client. The Assign ConnectWise Agreement window lists the client's active agreements; click Assign on the one BillingBot should keep up to date.
  3. Map the products. In Map Products, use Map to ConnectWise Product on each Pax8 product and click Assign on the matching product of your ConnectWise catalog.
  4. (Optional) Set prices. In Map Products, Edit Product opens a small window for the product's price and billing settings (see below).

To change the connection later, open Integrations and click Edit on the ConnectWise card (it cannot be removed): the ConnectWise PSA Connection window shows whether the connection works and lets you change the site, the company id and the keys. Leave a key empty to keep the one already stored.

About Prorate

Choose agreements that have Prorate turned on in ConnectWise. BillingBot leaves prorating to ConnectWise, so with Prorate off a change in the middle of a period is billed for the whole period. The Prorate column of the agreement list shows a warning icon for those agreements, and BillingBot asks you to confirm (Prorate is off) before assigning one.

Ready to Agreement

Ready to Agreement (in the side menu, where HaloPSA accounts see Ready to Invoice) is the monthly screen.

  • Integration and Period: the Pax8 integration and the month (year-month) to process.
  • Import Pax8 Charges: reads the period's charges from Pax8.
  • Refresh Preview: reads the agreements in ConnectWise again and shows what would change.
  • Send to ConnectWise: writes the changes shown in the preview. It is enabled only when the preview has something to write.

Preview tab

The Preview tab lists, for each client, agreement and product, what sending would do:

ChangeWhat it means
CreateA new addition is added to the agreement.
ChangeThe addition already exists; its quantity or price is updated (the Qty now → new and Price now → new columns show both values).
CancelAn addition BillingBot created earlier is no longer billed by any charge, so it is cancelled. BillingBot never deletes additions.
BlockedThe charge cannot be sent until something is fixed; the Notes column says what.
Not sentThe charge is left out on purpose, for example a prorated charge, or credits that cancel the charges out.
UnchangedThe agreement is already correct. Hidden by default.

The chips above the list show how many rows of each kind there are; click a chip to show or hide those rows. A product marked No charge is sent with Track Cost Only: the cost is recorded in ConnectWise and nothing is billed. When several charges of a product have different unit prices, the addition uses their average and the Notes column says so.

Sending and undoing

Send to ConnectWise starts straight away, with no extra confirmation: the preview on screen is what you review. The send runs in the background, so you can leave the page; a banner shows its progress. BillingBot always writes the plan it works out again at that moment, never an old copy of the screen.

The History tab lists the sends of the period, with how many changes were Saved, Refused or Unknown. Details shows every change, before and after. Undo puts the agreements back as they were before that send: additions it created are cancelled, changes are reverted and cancellations are taken back.

Edit Product (ConnectWise)

The Edit Product window of a ConnectWise account only changes how the product is billed:

  • Fixed price, Margin over cost (%) and Fixed cost. Without a fixed price or margin, the charge keeps the price Pax8 sent.
  • Track Cost Only (sent as a No Charge addition), Prorates Track Cost Only and Excluded (never sent).

Saving updates the period's charges of that product. Nothing changes in ConnectWise until you send the period from Ready to Agreement.

Common errors

  • "The Pax8 company '…' is not assigned to a client in Client Management." Assign it in Client Management, then click Refresh Preview.
  • "The client has no ConnectWise agreement. Assign one in Client Management (Assign Agreement)."
  • "The product has no ConnectWise product. Map it in Map Products (Map to ConnectWise Product)."
  • "Prorated charge: not sent to ConnectWise in this version." Bill it by hand in ConnectWise if it applies.
  • "The agreement already has N addition(s) of this product added by hand…" BillingBot never changes additions added by hand. Check the client is not billed twice.
  • "This company has no active agreement in ConnectWise." Create the agreement in ConnectWise, then assign it.
  • "The ConnectWise catalog has no active products." Create the product in ConnectWise, then map it.
  • Send finished with problems / Undo finished with problems: some changes were refused by ConnectWise or their result is unknown. Open Details in the History tab to see which, then click Refresh Preview before sending again.