Finance View

Reconcilable to the transaction level.

Every dollar of reported sales, calculated royalty, reported royalty and variance ties back to a partner report line item, not a spreadsheet formula finance can't audit.

Q3 2026 Reconciliation, Standards Library A

Reported vs. calculated, by partner
PartnerReported SalesCalculated RoyaltyReported RoyaltyVarianceStatus
Northbridge Media Partners$22,100,000$3,978,000$3,978,000$0Matches
Vantage Distribution Group$16,500,000$2,475,000$2,431,000-$44,000Under-reported
Continental Licensing Alliance$9,600,000$1,152,000$1,204,000+$52,000Over-reported
Total$48,200,000$7,605,000$7,613,000+$8,000

Vantage's -$44,000 variance traces to 3 line items on PartnerA_Q3_Royalty_Report.xlsx reported at last quarter's rate tier, flagged as an exception during intake.

Royalty Adjustments & Prepay

Every product line reconciles on its own calculation method, this sheet is where the variances between them get corrected
PartnerProduct linePeriodAdjustment typeAmountStatus
Harborview Standards GroupDigital Standards Library, short-term subscriptionsQ2 2026Missed approval, rate applied before tier upgrade was approved-$9,400Correcting Q3
Harborview Standards GroupIndividual Standard DocumentsQ1 2026Revised approval, list price updated after report was filed+$3,150Applied
Vantage Distribution GroupStandards Library AQ3 2026Prepay, royalty paid ahead of reconciled report$50,000Carried to Q4
Continental Licensing AllianceAdvanced Certification SuiteQ3 2026Missed approval, seat count reported before minimum-royalty true-up+$6,800Pending review

Each row here is a real correction to a real transaction, never a plug to make a total match. "Missed approval" and "revised approval" trace back to the specific approval record on Approvals; prepay balances carry forward until the matching report clears.

Receivables, Payables & Margin

Two-sided accounting, rolled up for the period
$1,180,000
Invoiced this period
Received: $960,000 · Outstanding: $220,000
$690,000
Downstream payable
Paid: $540,000 · Remaining: $150,000
$490,000
Retained margin, this period

Financial System Outputs

Export to Finance, not a replacement for your ERP
Structured export includes: Partner · Customer · Period · Product · Revenue · Royalty Receivable · Royalty Payable · Margin · Currency · GL Code · Cost Center · Invoice Reference.