Which lead sources become paying customers?

Identify paying lead sources by linking marketing source records to CRM customers and deals, then matching those deals to accounting invoices and payments. HubSpot shows lead origins and sales outcomes; QuickBooks shows collected cash. Define attribution and payment windows first, then compare sources using allocated receipts rather than leads or bookings alone.

By SIGNLD Editorial · · 7 min read · Playbooks
Connected customer, deal, invoice, and payment records supporting a lead source to revenue comparison.

In this article

Why can't one system answer this?

Marketing reports show where contacts originated and how many entered the funnel. HubSpot deal reports show which opportunities closed and what sales expected them to be worth. QuickBooks shows invoices and payments, but does not independently explain the original marketing source.

A lead source with many contacts can produce few customers, and a closed deal can remain unpaid. Counting leads or bookings therefore answers a different question from identifying sources that produce collected cash. The connection must preserve source history, customer identity and the relationship between deals, invoices and payments.

The guide to understanding which deals actually made money takes the next step beyond receipts. A source producing collected revenue still needs delivery costs before anyone calls it profitable.

How do people answer it today?

Marketing exports contacts with source labels and creation dates, then sales operations exports deals and account associations. Finance adds invoices and payments from QuickBooks, usually grouped by customer name.

The analyst joins contacts to deals, assigns a source and attaches invoice amounts. They then remove unpaid invoices or attempt to replace invoice values with payment totals. Customer aliases, multiple contacts and consolidated invoices make those joins difficult to inspect.

A contact-level join can repeat the same deal for every associated contact. A customer-level join can credit every source with every payment from that customer. Both mistakes inflate apparent returns even when each exported report is individually correct.

Save the attribution rule and mapping evidence alongside the workbook, then retain the reporting cutoff. Otherwise a contact source update changes last month's result without explaining why. A repeatable review needs retained definitions, not just a refreshed spreadsheet.

What does the answer look like when the systems are connected?

Illustrative example: a 40-person agency using HubSpot and QuickBooks. Every count, amount and period in this example is illustrative.

The owner asks: “Which original lead sources produced collected cash from customers acquired in this quarter?” The review reads HubSpot contacts, companies and deals alongside QuickBooks customers, invoices and applied payments.

This illustrative comparison uses original source, a defined acquisition cohort and an illustrative 90-day collection window. Each payment is allocated once to its associated invoice and deal before the source totals are calculated.

Illustrative source Illustrative won deals Illustrative collected cash
Customer referral 6 $48,000
Organic search 8 $32,000
Paid campaign 10 $20,000

The illustrative paid campaign produced the most won deals, but referrals produced the most collected cash within the chosen window. That does not establish which channel is most profitable, because campaign spending and delivery costs are absent.

The answer also lists unallocated receipts and unmatched customers instead of quietly excluding them. A customer paying outside the collection window remains visible in later cohort reviews. The owner sees what has been collected so far, not a claim about eventual lifetime value.

Why does lead source data break between systems?

Source labels usually begin with a contact, while invoices belong to a legal customer. Between those records sit company associations, sales opportunities, billing entities and payment allocations. Losing any relationship breaks the route from the original source to collected cash.

Source changes also alter the question. Original source, latest source and campaign influence are different definitions, even for the same deal. Choose one model and preserve its evidence before judging channel performance.

Review these common breaks before using a channel ranking to change spending:

  • A renamed company loses the link between the CRM account and accounting customer.
  • Several contacts bring different source labels into the same closed deal.
  • A parent company pays invoices for customers with different acquisition histories.
  • An invoice covers several deals whose sources require separate payment allocation.
  • A changed contact field overwrites the source used in an earlier review.

Keep unknown source values visible as a separate group with an owner for correction. Hiding those records makes the named channels look more complete than the source evidence supports.

Which attribution and payment rules make comparisons fair?

Start with one declared attribution model and keep it stable throughout the comparison. Original source answers where the relationship began; latest source answers a different question about a later interaction. Neither should silently substitute for the other inside the same report.

Next, define the cohort and collection window before calculating source totals. Comparing older referral customers with newly acquired campaign customers gives referrals more time to collect payments. Use comparable customer acquisition windows, then identify late receipts separately.

Count applied payments rather than simply treating issued invoices as cash. Handle partial receipts, refunds and credits consistently, keeping receipts separate from noncash adjustments. Where payment allocation is uncertain, leave the amount unallocated for review rather than assigning it by guesswork.

Finally, keep acquisition spending and delivery costs outside a cash-only conclusion. Paid revenue identifies which sources collected money under your definition. It does not establish channel margin without the corresponding cost evidence and agreed allocation rules.

How does SIGNLD answer it?

SIGNLD reads HubSpot deals and QuickBooks invoices through read-only connections, without writing changes into either system. The Knowledge Graph builds automatically from connected sources. No data engineering required. SIGNLD matches the same customer, deal and invoice across systems, preserving the records behind each relationship.

The answer comes back as a Decision Brief citing the system, table and row behind each number. Review the cited deal and invoice before assigning an owner to an exception. Missing matches remain visible for review rather than becoming invented revenue or assumed payments.

Your data stays yours: read-only connections, a private LLM powered by AWS Bedrock on a single-tenant instance, and we never train on it.

See how SIGNLD works explains the next step for evaluating this workflow with your own reporting definitions.

Key takeaways

  • Lead-source reporting needs marketing origins, CRM deal relationships and accounting payment evidence.
  • Declare the attribution model, acquisition cohort and collection window before comparing source totals.
  • Allocate each receipt once so multiple contacts and deals do not duplicate collected revenue.
  • Collected cash by source does not establish profitability without acquisition and delivery costs.

FAQ

Is closed won revenue enough to judge a lead source?

Closed won revenue measures sales outcomes rather than customer payments. A HubSpot deal can close before QuickBooks records an invoice or receipt. Lead-source evaluation should separate leads, bookings, billing and collected cash. That separation shows whether a channel produces signed contracts, paying customers or unresolved collections exposure under the chosen reporting window.

Should first source or latest source receive the credit?

First source and latest source answer different attribution questions, so the report must name its chosen model. First source identifies the recorded origin of the relationship; latest source credits a later recorded interaction. Preserve the underlying source history where available and apply the selected model consistently across deals before comparing collected revenue.

How should partial payments appear in source reporting?

Partial payments should contribute only the collected amount allocated to the relevant invoice and deal. The unpaid balance remains separate from collected revenue, even when the deal is closed won. Where an invoice covers multiple deals, apply a documented allocation rule and flag uncertainty rather than crediting the entire payment to each associated source.

Does the highest cash-producing source deserve the largest budget?

The highest cash-producing source does not automatically deserve the largest budget because collections alone omit acquisition and delivery costs. Customer age and collection timing also affect the comparison. Review comparable cohorts, campaign spending, service costs and unpaid balances before changing budgets. Keep cash evidence distinct from a broader conclusion about channel profitability.

Related reading

Try SIGNLD free

Try SIGNLD free to examine your CRM and accounting questions using connected source records.

Browse all articles for more cross-system reporting questions and practical finance workflows.