Use these four practices to structure and clean your CRM data so your integration captures the key data required for revenue forecasting, contract tracking, and renewal management.
Before you start
- Connect and configure your CRM connection in ScaleXP. See Subscription management and renewal tracking: Getting started with CRM integration.
- If you use ScaleXP Invoicing, install and set it up. Start with How to set up ScaleXP Invoicing (Step 1): Installing the invoicing module.
Create separate pipelines for new sales and renewals in your CRM
Separating pipelines allows you to clearly distinguish between new business opportunities and customer renewals. This improves both forecast accuracy and renewal visibility:
- If all deals exist in a single pipeline, it becomes difficult to apply realistic probability weights for different types of deals (opportunities), making forecasts less accurate.
- Separating new business from renewals may also help in monitoring success within sales versus customer success teams.
Your CRM help documentation will explain how to create pipelines.
If your CRM data is messy, start by cleaning closed won deals
Many companies find that their CRM contains incomplete or inconsistent data. Cleaning the entire CRM can be overwhelming. Instead, start by ensuring that closed won deals (opportunities) contain complete contract data.
At a minimum, the following fields should always be captured:
- Total contract value (TCV)
- Contract start date
- Contract end date
- ARR (if relevant for your company)
- Product or plan purchased (ScaleXP Invoicing customers only - see Ensure the SKU or product code matches)
These fields form the core data required for forecasting and contract management in ScaleXP.
Note: All of these fields are captured automatically when using ScaleXP Invoicing.
When captured consistently, they enable:
- Accurate revenue forecasting
- Clear contract timelines
- Reliable renewal tracking
Over time, you should ensure that these fields are consistently populated across all deals. We also highly recommend creating a field for Renewal Deal Reference - see Auto-create renewal deals and link them.
Auto-create renewal deals and link them
To track renewals effectively, your CRM should automatically create renewal deals when a contract is confirmed. We recommend creating the renewal deal when the original deal is marked Closed Won. This links the renewal to the contract straight away, so your renewals schedule and forecast are complete from day one.
Your CRM workflow should then:
- Automatically create the renewal deal
- Place the deal in the renewals pipeline
- Link the renewal deal to the original contract deal
This ensures that every contract has a future renewal opportunity associated with it, preventing renewals from being missed.
Once renewals are linked, ScaleXP can automatically:
- Track upcoming renewals
- Include renewals in revenue forecasts
- Monitor the full lifecycle of each customer contract
See How to auto-link renewal deals in ScaleXP.
Ensure the SKU or product code matches between CRM and accounting products (if relevant)
Note: This is relevant for ScaleXP Invoicing customers only.
To automate invoicing and ensure financial data flows correctly between systems, the SKU or product code should match between your CRM products and your accounting products.
When SKUs are aligned:
- Invoices can be generated automatically from CRM deals
- Revenue is recorded against the correct accounting product
- Financial reporting remains accurate and consistent
This ensures that your business maintains a single source of truth for revenue and forecasting. See ScaleXP Invoicing: (Step 2) invoicing setup and data mapping with HubSpot invoicing.
How it works
Connecting your CRM deal data with accounting data creates a single source of truth for revenue and forecasting.