AR Collections & Cash Flow
Money actually in · material actually out — daily / weekly / monthly · loading…
Hub home
DailyWeeklyMonth-end TrendsCollection rate13-week forecast MarginPipeline & backlog

Daily — receivables collected

"Collected" = money actually received (payment receipt date in Stone Profits) — not invoices issued, not promises to pay.

Weekly — building through the month

Month-end — money in vs material out

Money in = A/R actually collected in the month (all payment types). Invoiced out = the month's invoice register — only real invoices from confirmed deliveries / packing slips ever reach it (quotes, holds and unconfirmed orders never do).

Month-over-month trends

Cash collected vs invoiced-out, trailing 13 months — the gap between what ships and what collects.

Collection rate by invoice month

The key metric: of each month's invoiced dollars, how much has been collected to date. Payments count toward the month their invoice was issued (Stone Profits applies payments against specific invoices), so older months climb toward 100% as cash lands.

Rolling 13-week cash forecast

Projected, not actual — a squeeze should show up 6–8 weeks before it arrives. Model assumptions are listed under the table.

Margin & rep profitability

Gross margin from the Stone Profits invoice register (invoiced-out minus cost of goods), on the same months as the invoiced-out trend.
By sales rep / product line: ties into the Commission System's monthly run — lands here in the next build (needs the commission workbook's per-rep margin published to the hub, not a new SPS pull).

Forward pipeline & backlog

The forward view: sold-but-not-delivered is the next 60–90 days of invoicing, before it happens.