Are you paying commission on unpaid invoices?

To identify commission paid on unpaid invoices, match CRM deals to accounting invoices, payment allocations and commission payout records. Salesforce tracks bookings; QuickBooks tracks collections. Booking-based commission is a valid compensation choice. The exposure becomes visible when paid commission, unpaid balances and collected cash appear together for each representative and deal.

By SIGNLD Editorial · · 7 min read · Perspective
Connected customer, deal, invoice, and payment records supporting a commission paid on unpaid invoices comparison.

In this article

Why can't one system answer this?

Salesforce records the opportunity, owner, amount and close date. Those fields support booking-based commission calculations but do not establish that a customer has paid.

QuickBooks records invoices, credits and payment allocations. It does not establish which compensation plan applies to a representative or whether a payroll payout included that deal.

Commission exposure therefore requires another record: the approved commission calculation and actual payout. Distinguish earned, approved and paid amounts instead of labeling every calculated commission as money already transferred. For the wider measurement framework, read which deals actually made money across sales, accounting and delivery.

The business question is not whether booking-based plans are wrong. It is whether finance knows how much compensation has left the company before the corresponding customer cash arrives.

How do people answer it today?

Export closed opportunities from Salesforce with stable identifiers and owners. Export QuickBooks invoices, credits and payments using a matching reporting cutoff. Then obtain the approved commission ledger and payout records from the compensation process.

Map each opportunity to its invoice records and each commission line to its earning event. Preserve rep ownership at the relevant event rather than using only the current account owner. Transfers otherwise rewrite historical exposure.

Allocate payments to invoices before calculating unpaid balances. A customer’s overall account credit does not prove that a particular deal’s invoice has been settled. Separate customer-level balances from deal-level evidence.

Finally, compare paid commission against the associated collections. The spreadsheet often loses the reason for a manual mapping or excludes a later credit. Save those exceptions with a named reviewer, because an unexplained deduction creates a compensation dispute.

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

Illustrative example: Harbor Services sells through Salesforce and invoices through QuickBooks. All amounts and payment proportions in this example are illustrative, not reported company performance.

The owner asks, “Which representatives received commission on deals whose invoices remain unpaid?” The answer reads opportunities, invoice balances, payment allocations and the approved payout ledger.

An illustrative deal has a booked amount of 40,000 currency units and an illustrative commission payout of 2,000 currency units. Its invoice remains unpaid at the reporting cutoff. The answer identifies the payout and open invoice without declaring the commission improper.

Another illustrative deal has the same booking and payout amounts, but illustrative collected cash of 20,000 currency units. The answer shows partial collection instead of grouping it with either fully paid or completely unpaid deals.

Each row includes the representative, opportunity, invoice, outstanding balance, paid commission and compensation basis. The owner sees the cash exposure while the sales leader sees whether the payment followed the agreed plan.

Is paying commission on bookings a mistake?

Paying on bookings rewards the commercial commitment that the sales team controls. That choice supports a clear earning event when delivery and collection responsibilities sit elsewhere.

Paying on collections reduces the gap between commission outflow and customer receipts. It also makes representative income depend on billing accuracy, delivery acceptance and customer payment behavior. Those factors are not always controlled by sales.

A mixed plan separates the earning event from payout timing. Whatever the design, record its basis and effective dates before comparing representatives. Different plans create different exposures without proving different sales quality.

Existing compensation terms govern actual payouts. Do not treat a reporting exception as permission to recover wages or rewrite a signed plan. Involve the responsible payroll, finance and legal reviewers before changing payment rules.

Which fields should the commission review include?

The review needs enough detail to explain both the compensation obligation and the customer’s unpaid balance. A rep-level total alone hides disputed invoices and mismatched records.

  • Representative identity and ownership at the commission earning event.
  • Opportunity identifier, booking date and eligible commission basis.
  • Invoice identifiers, due dates and remaining balances after credits.
  • Payment allocations and the collection cutoff used for the comparison.
  • Commission approval, payout date and the applicable plan version.

Split overdue exposure from invoices that are unpaid but still within terms. Both affect cash, but they require different conversations. A current invoice does not automatically justify a collection escalation.

Show unmatched payouts as a separate review queue. Missing invoice links are not evidence of nonpayment, and missing payout records are not evidence that a representative received nothing. Assign each gap to its source owner.

How should sales and finance act on the results?

Start with exceptions that combine a recorded payout and an identifiable unpaid invoice. Ask finance to confirm payment allocations before sales contacts the customer.

Then separate billing errors, customer disputes, timing differences and genuine collection risk. A delayed invoice requires a billing fix; an approved installment requires monitoring against its schedule. Neither should become a performance accusation.

Review exposure by deal age and plan basis before ranking representatives. A representative selling longer-term contracts naturally carries a different collection pattern. Compare like terms and preserve the explanation for any manual adjustment.

Use the findings to discuss future plan design, not to quietly alter historical entitlements. Publish the calculation definition with the report so the sales team understands exactly what the commission exposure figure measures.

How does SIGNLD answer it?

SIGNLD connects read-only to Salesforce and QuickBooks. Its connected records preserve the customer, deal, invoice, and payment evidence needed for this question.

The Knowledge Graph builds automatically from connected sources. No data engineering required. SIGNLD matches the same customer, deal and invoice across systems. A Decision Brief cites the system, table and row behind each number. Review those records before assigning a customer follow-up or changing a payment assumption.

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.

Key takeaways

  • Booking-based commission is a compensation choice, not an accounting error.
  • Commission paid and customer cash collected require different source records.
  • Compare rep exposure using invoice balances after credits and payment allocations.
  • Review plan terms before changing eligibility, timing or recovery rules.

FAQ

Does an unpaid invoice mean commission was paid incorrectly?

An unpaid invoice does not establish that commission was paid incorrectly. A booking-based plan deliberately pays for a completed sale before collection. Compare the payout with the applicable compensation terms, then report the associated unpaid invoice separately. The report measures cash exposure rather than judging whether the representative earned the payment.

Which date belongs in the commission comparison?

Use the date defined by the compensation plan for the earning event and the recorded payout date for cash outflow. Use a consistent reporting cutoff for QuickBooks collections. Keeping these dates separate explains why commission was earned, when it was paid and whether the customer had paid by the review date.

How should credits and refunds be handled?

Credits reduce invoice balances, while refunds return previously collected money. Keep both events visible when comparing collections with commission payouts. Apply commission adjustments only according to the relevant plan and required review process. A net customer balance alone conceals whether an invoice was paid, credited or followed by a refund.

Can the comparison work without a commission application?

The comparison needs approved commission records and evidence of actual payouts, not necessarily a dedicated commission application. A controlled ledger provides the required deal, representative, amount and date fields. Reconcile its paid status against payroll or payment records, and document manual links before presenting a rep-level exposure total.

Related reading

Try SIGNLD free

Choose a representative and reporting cutoff, then compare booked deals, invoice balances and recorded commission payouts before discussing changes to compensation. Explore SIGNLD.

Try SIGNLD free · Browse all articles