HubSpot payments missing data or not linked to an invoice

Why it matters

Payment data in HubSpot feeds customer history, refund context and revenue reporting. A payment with no amount or status tells the account team nothing, and a refund total above the payment amount is a sign that the records disagree with the processor.

A payment not linked to an invoice may be legitimate, for example a payment link with no invoice behind it. A payment with no invoice, no order and no customer at all, though, cannot be attributed to anyone.

How to find it in HubSpot

1. 1Open the payments index under Commerce, if your subscription includes it.
2. 2Add the Amount, Currency, Status, Initiated date and Refunded amount columns.
3. 3Look for blank amounts, currencies, dates or statuses.
4. 4Sort by refunded amount and compare it with the original amount for the largest refunds.
5. 5Open a sample of payments and check whether each has an associated invoice, order, contact or company.

How to fix it safely

1. 1Treat the payment processor and the accounting system as the source of truth. Export the matching records from both.
2. 2Match each affected HubSpot payment to its processor transaction and note any difference in amount, fees, refunds or chargebacks.
3. 3Have finance decide which relationships to add and which records need correction, and document the decision.
4. 4Check the connection between HubSpot and your processor, because most of these gaps start at the point of sync.

Before you change anything: Payment records are financial records. This page is not accounting advice. A responsible person in finance should approve every change.

How Ancil checks this

Rule

COMMERCE-005, COMMERCE-012, COMMERCE-015, COMMERCE-017

What it looks for

Reads up to 1,000 payment records. Flags payments missing the initial amount, currency, initiated date or latest status, and payments where the refunded amount is greater than an initial amount above zero. It also checks the same payments against their associations: it notes payments linked to no invoice, and flags payments linked to no invoice, no order, no contact and no company. The full relationship check runs only when all four association reads succeed.

Severity

Warning for missing core data, refunds above the initial amount, and payments with no customer, order or invoice. Info for payments that only lack an invoice, because some payment types never have one.

Evidence shown

Payment IDs, names, status, amounts, refunds and currency for up to 50 payments, plus the sample size and IDs for each relationship gap.

Governed fix

Not automated. Ancil reports the evidence only. Your finance team, or an INSIDEA expert, reconciles payments, because Ancil never changes commerce or financial records automatically.

Related checks