Cash IQ · Add-on Module

"We had $11 million past due and three collectors who didn't know which customers were the same company across four ERPs."

Know what's past due.
Know who owns it.
Before it becomes a write-off.

Cash IQ consolidates every open receivable across your ERP portfolio into a single enriched view. Assign collectors, track dunning activity, monitor payment terms compliance, and surface at-risk accounts by industry or geography.

Marquis IQ · Cash IQ
MIQ 603
AGING TREND COLLECTIONS AGING DETAILS STATEMENT
AR Collections
Past Due AR Amt
$11.4M
 
Current AR Amt
$2.1M
 
This Month
$4.2M
36.8% of total
Next Month
$0.6M
5.3% of total
This Quarter
$8.9M
78.1% of total
Collections by week  ·  Past Due %
43% 27%

The collections problem

Your collectors are working harder than the data they have.

The same customer exists under seven different names

Each ERP site created its own customer record. Your collector is chasing "Meridian Attractions Co," "Meridian Attract LLC," and "MERIDIAN ATTRACT" simultaneously. Same company. Same debt. Three separate chase threads and no view of total exposure.

Past due reports with balances and nothing else

You see what's owed. You don't see the customer's industry risk, the family-level exposure across subsidiaries, what the collector promised on the last call, or whether this account is trending worse. The number exists. The context doesn't.

Dunning rules that live in the collector's head

When do you call? When do you send a formal notice? When do you escalate to leadership? When do you put the account on hold? That knowledge walks out the door with your most experienced collector and no one can reconstruct it from a spreadsheet.

Enrich Customer

One clean customer record. Across every ERP, every site, every subsidiary.

Cash IQ starts with your raw ERP customer records, deduplicates them automatically across every system and site, and enriches the master record with third-party attributes. The result is a single golden record for every customer that carries the full receivable history, the payment behavior pattern, and the risk context your collectors need to prioritize intelligently.

Family assemblance connects subsidiaries and parent companies so your collectors see total family exposure, not just the individual entity they happen to be chasing. Industry classification via NAICS or SIC codes lets you surface at-risk customer segments before late payments become a pattern. Geographic data adds tariff and geopolitical context for customers in regions under pressure.

What gets added at enrichment
NAICS / SIC industry codes, standard classification for every customer relationship, enabling industry-level risk analysis
Parent / subsidiary family structure, so total family exposure rolls up correctly across all entities
Geographic and geopolitical data, country, region, and tariff exposure for customers in volatile markets
Payment behavior pattern, days-to-pay history and trend, not just the current open balance
Collector assignment, each master customer has one owner accountable for the full relationship
Before: Raw ERP Records
!
MERIDIAN ATTRACTIONS CO
!
Meridian Attract. LLC
!
MERIDIAN ATTRACT
!
Meridian Attractions
No industry classification
No family / parent linkage
AR fragmented across 4 ERPs
No collector assigned
Master Customer Record
Meridian Attractions LLC
NAICS713110 — Amusement Parks
IndustryEntertainment / Leisure
CountryUnited States
FamilyMeridian Group Holdings
ERP Sites4 systems unified
LTM Invoiced$62.3M consolidated
CollectorClark Whitfield

AR Aging Trend

Track every dollar. Watch every bucket. Every week.

Cash IQ takes a daily snapshot of your full AR balance across every ERP and shows you exactly how the aging distribution is shifting over time. Not a point-in-time report. A living trend you can act on before the over-90 bucket gets worse.

The past due percentage line tracks whether your collections effort is actually moving the needle. A shrinking current balance that moves into the 6-30 bucket looks fine on a standard aging report. On the trend chart, it's a visible signal that calls are being made but payments aren't arriving.

Filter by business unit, payment terms, assigned collector, or customer family to isolate where the problem is concentrated. A portfolio-wide trend that looks flat often hides one segment that's deteriorating rapidly.

See aging trend by business unit
AR Aging Trend  ·  12 Weeks  ·  Past Due %
>120 Days 91–120 61–90 31–60 6–30 1–5 Current
50% 40% 30% 20% 42% 27% Wk 1 Wk 4 Wk 7 Wk 10 Wk 12
Stacked bars: AR balance by aging bucket Line: Past due % (right axis) — declining = improvement

Collector Intelligence

Assign, track, and hold every collector accountable.

Every master customer in Cash IQ has one assigned collector who owns the full relationship. Not one collector per ERP site. One collector per customer, with visibility into every open invoice across every system.

Collector compliance tracks contact frequency against dunning rules, measures how quickly accounts move through escalation stages, and flags portfolios where past due percentages are growing relative to the team average. Your best collectors become the benchmark. Everyone else sees where they stand.

Dunning alerts fire automatically based on configurable rules: days since last contact, days past due threshold crossed, invoice amount over limit, or customer entering a new risk tier. Every alert routes to the assigned collector and to the right manager, with full context attached.

See collector compliance by team
Collector Contact Compliance
Clark Whitfield
91.2% On Plan
47 accounts Avg 12 days PD $18.4M portfolio
Dana Morel
85.4% On Plan
52 accounts Avg 18 days PD $22.1M portfolio
Lee Stratton
78.3% Review
38 accounts Avg 24 days PD $15.7M portfolio
Pam Everett
72.1% Below Target
61 accounts Avg 31 days PD $27.6M portfolio
Dunning Alert — Escalation Required

Pam Everett — Meridian Attractions: $134K open balance, 47 days past due. Last contact 12 days ago. Dunning stage: Call escalation required. No collector note on file since initial outreach.

$14M+
AR consolidated and tracked daily across every ERP and site
97%
invoice-level match rate across ERP integrations at go-live
-4.2
average days reduction in days-past-due within the first quarter on platform
1 view
single consolidated AR dashboard replacing six separate ERP aging reports

Within sixty days of go-live, our collectors knew exactly which accounts to call in what order every morning. We stopped chasing the same customer in three different systems and cut our over-90 bucket by thirty-two percent in a single quarter. The data was always there. We just couldn't see it together.

VP Finance, PE-owned multi-site manufacturer
Running Dynamics 365 BC, SAP Business One, and NetSuite across six locations

Built on the Marquis IQ Platform

Cash IQ is an add-on module. It runs on top of your existing Marquis IQ subscription, sharing the same ERP connections, master customer data, and payment records already in the system.

Pricing IQ — when payment slows, margin often follows

Customers who start paying late are sometimes signaling financial stress. Pricing IQ shows you where margin is under pressure on the sell side, and Cash IQ shows you where cash is backing up on the AR side. Together they give your finance team an early warning system for customer health that neither module delivers alone.

Procurement IQ — customer and supplier risk on one platform

Your largest customers are sometimes also your largest suppliers. Cash IQ and Procurement IQ share the same master data foundation, so a company that shows up on both sides of your ledger has one record, not two separate views. Understanding the full relationship changes how you manage payment disputes and credit terms.

Daily Pulse — escalation alerts before the morning standup

Every dunning threshold crossed, every collector contact gap, and every account entering a new aging bucket flows into the Daily Pulse before the workday starts. Collectors don't run queries. Managers don't build reports. The right information reaches the right person automatically, so action happens when it still makes a difference.

Built on Marquis IQ
Enrich
Customer records deduplicated across every ERP, one AR record per customer, regardless of how many ways their name was entered across systems.
Analyze
Aging trends, payment behavior shifts, and collection performance tracked week over week, so finance sees problems forming, not just the ones already past due.
Act
Go-Gets surface high-risk balances and deteriorating payment trends and assign them to the right collector before the number gets worse.

Your past due accounts have a story. Cash IQ tells it.

Bring your AR aging file. We'll walk through how enriched customer data changes the conversation your collectors have every morning, and show Cash IQ running on real data in a live environment.

No commitment. We'll tell you honestly if Cash IQ fits your situation.