Sonar AI Prompt Library

296 professionally engineered NetSuite prompts across 15 categories — turning Sonar AI into a CFO-grade analyst on demand. 25 are free; the full library is a one-time purchase.

$499 one-time · per NetSuite account
(covers sandboxes & RCs)
Find it in Sonar AI under the ⓘ About panel.
Buy the library

After purchase, reopen the Library in Sonar AI — every prompt unlocks automatically for your account. No license key to enter.

✅ Audit & Assurance (17)

✅ Account Reconciliation Auditor
Audit account reconciliations with GL-to-subledger matching and exception analysis.
📍 Address Quality Audit
Audit billing and shipping addresses on entities and transactions for missing components, invalid states, and mismatched country codes.
🎚️ Approval Threshold Bunching
Detect statistical bunching of POs and vendor bills just below approval thresholds — the signature of spending-policy gaming.
✅ Audit Question Responder
Draft professional audit responses with appropriate scope and risk-aware communication.
✅ Audit Trail Investigator
Investigate audit trails with transaction lineage and anomaly detection.
✅ Audit Workpaper Preparer
Prepare organized, audit-ready workpapers with assertion coverage and cross-references.
📆 Backdated Transaction Detector
Find transactions whose posting date predates the entry date by more than a tolerance — a primary indicator of period manipulation.
🔢 Benford's Law Forensic Audit
Run first-digit Benford analysis on transaction amounts to detect anomalous distributions that warrant investigation.
✅ Compliance Checklist Generator
Generate customized compliance checklists with deadlines, ownership, and certification workflows.
🔍 Compliance Gap Analyzer
Identify compliance gaps between current NetSuite configuration and required controls frameworks (SOX, COSO, SOC 1/2).
📋 Control Documentation Generator
Auto-generate COSO-aligned internal control documentation with evidence requirements and test procedures.
✂️ Cutoff Testing Analyzer
Test period-end cutoff accuracy for revenue and expenses — identify transactions recorded in the wrong period.
🔒 Internal Controls Compliance Review (SOX/SOC)
Comprehensive SOX 302/404 and SOC 1/2 internal controls review against COSO 2013 framework with live NetSuite evidence.
📒 Journal Entry Testing Tool
Structured audit testing of journal entries with risk-based sampling, population statistics, and exception reporting.
✅ Management Assertion Validator
Validate management assertions for financial statements against live NetSuite data with PCAOB/AICPA assertion framework.
📄 Reconciliation Documentation Writer
Auto-generate complete account reconciliation documentation with supporting schedules, exception tracking, and sign-off workflow.
🎲 Transaction Sample Selector
Generate audit-defensible transaction samples using risk-based, monetary unit, and random selection methods from live NetSuite data.

📊 Budgeting, Forecasting & Planning (18)

Free
📊 Budget vs Actual Variance Analyzer
Compare budget against actuals with trend, drill-down, and corrective action recommendations.
🎯 Annual Budget Assumptions Documenter
Document budget assumptions with validation rules and sensitivity analysis.
🎯 Break-Even Analysis Tool
Calculate break-even points with cost-volume-profit analysis and sensitivity.
🎯 Budget Commentary Writer
Generate professional budget narratives for board packages with executive summary format.
🎯 Budget Variance Diagnostic Tool
Diagnose budget variances with root cause analysis and corrective actions.
🏗️ Capital Expenditure vs Budget Analyzer
Analyze CapEx actuals against budget with project-level drill-down and commitment tracking.
🏗️ Capital Project Spend Tracker
Track capital project spending against approved budgets with commitment and completion analysis.
🔄 Cost Allocation Modeler
Model cost allocations across departments, products, and cost centers with driver-based methodology.
💰 Expense Budget Analyzer
Analyze expense budget performance with variance drill-down, trend analysis, and reforecast.
🎯 Goal Attainment Tracker
Track goal attainment with projections and at-risk identification.
📈 Investment ROI Calculator
Calculate investment returns with NPV, IRR, payback period, and sensitivity analysis.
📦 Product Line Profitability Analyzer
Analyze gross and contribution margin by product line with trend and strategic recommendations.
📝 Revenue Forecast Narrative
Generate executive-grade revenue forecast narratives with supporting data and risk analysis.
🔮 Revenue Forecasting Tool
Generate data-driven revenue forecasts using statistical methods and pipeline integration.
🔄 Rolling Forecast Generator (Budget-Based)
Generate rolling forecasts anchored to the approved budget with YTD variance adjustments.
🔄 Rolling Forecast Generator (Performance-Based)
Generate rolling forecasts anchored to recent performance trends rather than the approved budget.
🎭 Scenario Modeling Assistant
Build and compare financial scenarios (bear/base/bull) with full P&L impact analysis.
🔧 What-If Scenario Modeler
Model discrete what-if financial scenarios with impact on P&L, cash flow, and key metrics.

💰 Cash Flow & Treasury (22)

Free
💰 Cash Flow Forecast Generator
Create detailed cash flow forecasts with scenario modeling and liquidity risk assessment.
Free
💰 DSO/DPO/DIO Calculator & Advisor
Calculate working capital metrics with benchmarking and improvement action plans.
Free
💰 Working Capital Analyzer
Analyze working capital components with trend analysis and optimization recommendations.
💰 13-Week Cash Flow Builder
Create detailed 13-week rolling forecasts with variance tracking and alert thresholds.
💰 Accounts Payable Optimizer
Optimize AP processes with DPO management and early payment discount analysis.
💰 Accounts Receivable Optimizer
Optimize AR collections with DSO reduction strategies and aging analysis.
💸 AR Collections Optimization & Working Capital Acceleration
Turns a Claude-class AI into a CFO-grade AR analyst. It pulls your NetSuite data via Sonar's tools, diagnoses your AR health, identifies why customers pay late, and produces a prioritized action plan with quantified working capital unlock potential — all as a single self-contained HTML report.
🏦 Bank Account Activity Profile
Profile every bank account on inflow, outflow, average balance, and idle balance to surface unused accounts and concentration risk.
🔄 Cash Conversion Cycle Decomposition
Decompose DSO, DIO, and DPO to compute CCC and surface the primary cash-cycle bottleneck.
💰 Cash Conversion Cycle Optimizer
Develop comprehensive CCC optimization plans with ROI analysis and implementation roadmap.
💰 Cash Flow Forecaster
Generate rolling cash flow forecasts with scenario analysis and liquidity projections.
💰 Cash Flow Projection Generator
Create detailed cash flow projections with scenario analysis and liquidity planning.
💰 Cash Position Executive Summary
Create concise executive cash summaries with runway analysis and covenant monitoring.
💓 Cash Position Pulse Dashboard Generator
13-week cash forecast rendered hurricane-track style — scenario fan chart with confidence bands, weekly flows, and liquidity metrics.
📅 Days in AR Trend Monitor
Monitor days in A/R trends with benchmark comparison and improvement tracking.
💰 Foreign Currency Exposure Analyzer
Analyze FX exposure with hedging recommendations and translation impact assessment.
💰 Intercompany Transaction Analyzer
Analyze intercompany transactions with balance matching and netting opportunities.
💰 Payment Processing Analyzer
Analyze payment processing with method optimization and fee reduction strategies.
🔮 Predictive Cash Position
Project cash position over the next 30 days using open AR due dates, open AP due dates, and current bank balances.
💳 Vendor Payment Terms Optimizer
Optimize vendor payment terms with working capital impact and relationship considerations.
💰 Working Capital Optimizer
Optimize working capital with CCC analysis and capital efficiency recommendations.
🧪 Working Capital Stress Test
Stress-test cash position under DSO slippage, sales drop, and AP acceleration scenarios.

📈 Expense & Cost Management (18)

Free
📈 Expense Trend Identifier
Identify expense trends, seasonality patterns, and cost anomalies across the P&L.
Free
🔍 Vendor Cost Analyzer
Analyze vendor costs, price trends, and cost reduction opportunities by vendor and category.
📝 1099 Preparation Assistant
Identify 1099-eligible vendors, aggregate YTD payments, and flag compliance gaps.
📋 AP Aging Commentary Writer
Generate comprehensive AP aging analysis with payment prioritization and cash-flow commentary.
📊 Blanket PO Utilization Monitor
Monitor PO utilization, identify over/under-utilized purchase orders, and surface expiry risk.
✂️ Cost Reduction Opportunity Finder
Identify and quantify cost reduction opportunities across expense categories, vendors, and operational spend.
🔍 Cost Variance Investigator (Cost Management)
Investigate cost variances between budget and actual, and between current and prior periods.
🧮 Cost Variance Investigator (Expense)
Investigate expense account variances — period-over-period, budget-to-actual, and transaction-level drill-down.
🔬 Expense Category Deep Dive
Deep dive into a specific expense category — GL trend, vendor breakdown, departmental split, and anomaly detection.
🚦 Expense Policy Compliance Monitor
Monitor expense report submissions for policy compliance, limit violations, and approval workflow gaps.
🧾 Expense Report T&E Audit
Audit travel and entertainment expense reports for policy compliance and anomalies.
👥 Labor Cost Efficiency Tracker
Analyze labor and payroll cost trends, efficiency ratios, and department-level cost performance.
🏗️ Overhead Allocation Analyzer
Analyze overhead costs, allocation methods, and department-level cost burdens.
📦 PO Receipt Variance
Identify price and quantity variances between purchase orders, receipts, and vendor bills.
🛂 Purchase Order Approval Console
Review the pending-approval PO queue with full decision context — vendor history, line detail, receipt status — then approve selected POs through an explicit, itemized confirmation gate. Write-capable; nothing changes without the user's named approval.
🗂️ Spend Category Optimizer
Analyze spend by GL account and vendor category to identify consolidation and optimization opportunities.
🏅 Vendor Performance Scorecard
Score every vendor on spend, PO volume, bill lag, and concentration risk.
💰 Vendor Spend Analyzer
Analyze vendor spend patterns, concentration risk, and procurement optimization opportunities.

📊 Financial Statement Analysis & Reporting (30)

Free
📊 Company Health Overview
Comprehensive company financial health assessment across profitability, liquidity, efficiency, and growth.
Free
📊 Executive Summary Creator
Create a concise executive financial summary with key performance highlights and strategic commentary.
Free
📊 Financial Ratio Analyzer
Calculate and interpret key financial ratios across liquidity, profitability, efficiency, and leverage dimensions.
Free
📊 Income Statement Variance Analyzer
Analyze income statement variances across periods with driver identification and materiality classification.
Free
📊 Period-over-Period Comparison
Generate comprehensive comparison analysis with professional narrative and variance waterfalls.
📊 Balance Sheet Trend Analyzer
Analyze balance sheet trends across periods to identify working capital, leverage, and liquidity movements.
📊 Board Report Narrative Generator
Generate board-quality financial narrative with variance explanations and strategic context.
📊 Board-Ready Financial Summary Generator
Generate a concise, board-ready financial summary with key metrics, highlights, and actionable insights.
📊 Competitive Benchmarking Analysis
Benchmark company performance against industry peers using internal metrics and user-supplied external data.
📊 EBITDA Calculator & Explainer
Calculate EBITDA with a full bridge from net income and an explainer suitable for non-finance audiences.
🎛️ Executive Command Center Generator
Dark-mode single-screen dashboard — cash, AR/AP, revenue trend, pipeline funnel, geo, top customers, and a live anomaly ticker.
📊 Financial Health Scorecard
Generate a comprehensive financial health scorecard with weighted scoring across profitability, liquidity, efficiency, and growth dimensions.
📊 Financial Highlights Presenter
Present key financial highlights in a visually compelling format for stakeholder communication.
📊 Financial Statement Commentary Writer
Write professional financial statement commentary with variance explanations and business insights.
📊 Financial Statement Validator
Validate financial statement integrity, internal consistency, and reconciliation across NetSuite data sources.
📊 GL Account Velocity vs Mass
Plot every GL account by posting frequency against dollar magnitude to expose dead accounts and sub-scale clutter in the chart of accounts.
📊 Gross Margin Deep Dive
Comprehensive gross margin analysis with product, customer, and cost driver decomposition.
🧭 KPI Alignment Executive Summary
Produces a quarterly executive summary covering 6 KPIs (Sales, Retention, CAC, LTV, Margin, NPS or substitutes). Output is an HTML report with a metric-of-the-quarter headline, status dashboard, root-cause analysis, and SMART action plan. Designed for 5-minute executive readability.
📊 KPI Dashboard Commentary Writer
Generate insightful KPI commentary with trend analysis and actionable recommendations.
📊 Management Discussion Writer
Create MD&A style narratives with SEC-quality structure and forward-looking statements.
📊 Management Report Generator
Generate executive-ready financial management reports with KPIs, trend charts, budget variance, and narrative commentary from live NetSuite data.
📊 Management Reporting Packager
Package management reports with executive summaries and board-ready presentations.
💧 Margin Waterfall Decomposition
Break gross margin into list price, discount, mix, cost, and freight contributions across periods.
💸 Money Flow Sankey Generator
Render the full P&L as an interactive Sankey — customers through revenue streams, COGS, opex, and net income.
🏦 PE Due Diligence Readiness Analyzer
Build a seller-side financial profile of the business the way a private equity diligence team would — growth, margins, concentration, earnings quality, and balance sheet health.
📊 Period Comparison Analyzer
Compare performance across periods with variance explanations and trend identification.
📊 Profitability Analysis by Segment
Analyze profitability across business segments with contribution margin analysis and allocation methodology.
📊 Segment Reporting Analyzer
Produce ASC 280 segment reports by class and department from live NetSuite GL data with completeness warnings.
📊 Trend Analysis Tool
Identify trends and patterns in financial and operational data with statistical insights.
📊 YoY Revenue Decomposition
Decompose year-over-year revenue change into volume, price, mix, new-customer, and lost-customer contributions.

🏷️ Fixed Assets (7)

🏷️ Asset Disposal Gain Loss Calculator
Calculate gains and losses on asset disposals with tax impact and documentation.
⚠️ Asset Impairment Screener
Screen assets for potential impairment with indicator identification and testing recommendations.
📍 Asset Location and Assignment Auditor
Audit asset locations and assignments with discrepancy identification and update tracking.
🛠️ Asset Maintenance Cost Tracker
Track asset maintenance costs with trend analysis and replacement timing recommendations.
⏳ Asset Useful Life Reviewer
Review asset useful life assumptions with benchmark comparison and adjustment recommendations.
📈 Asset Utilization Tracker
Track asset utilization rates with underutilized asset identification and ROI analysis.
📉 Depreciation Expense Forecast (Fixed Assets Management)
Multi-year, month-grained depreciation expense forecast built from live FAM asset records — actual methods, lives, conventions, and book values — reconciled against posted depreciation history, delivered as an interactive dashboard.

🗓️ Forensics & Anomaly Detection (7)

🗓️ Day-of-Week / Hour Anomaly Heatmap
Visualize transaction creation patterns by day-of-week and hour to surface after-hours or weekend activity.
🗑️ Deletion Forensics
Audit every record deletion — who deleted what, when, through which mechanism — with special attention to deleted transactions near period close, deleted scripts/deployments, and bulk purge events.
🔎 Journal Entry Forensics
Deep forensic analysis of manual journal entries — weekend/after-hours posting, round amounts, top-sided entries, and preparer/approver SoD testing.
👤 Manual Journal Entry User Map
Map every manual journal entry to its creator — identify dominant users, outlier behavior, and concentration risk.
🌙 Off-Hours Transaction Audit
Identify all posting transactions created outside normal business hours or on weekends — flag high-value off-hours activity for review.
👻 Phantom Entity / Duplicate Detection
Detect duplicate and potentially phantom vendors, customers, and employees — name similarity, shared addresses, shared bank accounts, and zero-transaction entities.
📈 Z-Score Transaction Outliers
Apply Z-score statistical analysis to transaction amounts to identify statistical outliers warranting investigation.

👥 HR & Workforce Analytics (12)

👥 Benefits Utilization Analyzer
Analyze benefits utilization with cost-per-employee and optimization recommendations.
⏱️ Billable vs Non-Billable Hours Monitor
Monitor billable ratio with trend analysis and non-billable categorization insights.
👥 Compensation Benchmarker
Benchmark compensation with pay equity analysis and market positioning.
👥 Employee Expense Analyzer
Analyze employee expenses with policy compliance and cost control insights.
🏢 Employee Tenure & Org Topology
Map active employees by department, supervisor, and tenure band to expose retention hotspots and unintended single-person teams.
👥 Employee Turnover Analyzer
Analyze turnover rates with cost impact and retention risk identification.
👥 Headcount Planning Tool
Plan workforce capacity with demand forecasting and hiring recommendations.
👥 Payroll Cost Analyzer
Analyze payroll costs with department breakdown and trend analysis.
🎯 Sales Rep Conversion Efficiency
Compare each rep's estimate-to-SO and SO-to-invoice conversion against the team median.
👥 Sales Rep Workload Distribution
Compare opportunity counts, transaction volume, and revenue per rep to find overloaded and underused sellers.
👥 Time & Attendance Analyzer
Analyze time and attendance with overtime tracking and compliance monitoring.
👥 Workforce Productivity Analyzer
Analyze workforce productivity with revenue-per-employee and efficiency metrics.

📅 Month-End Close & Reconciliation (13)

Free
📅 Journal Entry Reviewer
Analyze journal entries for errors, policy compliance, and unusual patterns with control testing.
Free
📅 Month-End Close Checklist Generator
Generate customized close checklists with dependencies, ownership, and timeline tracking.
Free
📅 Trial Balance Analyzer
Analyze trial balance for anomalies, errors, and close readiness with quality scoring.
📅 Account Reconciliation Assistant
Generate structured reconciliations with variance explanations and roll-forward analysis.
📅 Accrual & Prepaid Calculator
Calculate accruals and prepaid amortization with journal entry templates and schedules.
📅 Bank Reconciliation Analyzer
Analyze bank reconciliation with exception identification and clearing optimization.
📅 Close Process Bottleneck Identifier
Analyze close process timeline to identify bottlenecks and optimization opportunities.
📅 Flux Analysis Performer
Perform comprehensive flux analysis with materiality thresholds and investigation workflows.
📒 Month-End Accrual Identification & Proposed Journal Review
Identify month-end cutoff issues on both sides of the ledger — received-not-billed POs, missing or under-billed recurring vendor bills, bills stuck in approval, late-arriving invoices, fulfilled-not-invoiced revenue, and stale or missing prepaid amortization — classify them, draft the correcting journal entries, and deliver everything as a professional HTML close workpaper.
📅 Month-End Close Quality Monitor
Monitor close process quality with error detection and compliance tracking.
🔗 Orphaned Transaction Chains
Trace the document chains that should connect — fulfillments to invoices, receipts to bills, credits to applications — and surface every broken link, quantified in dollars, before month-end turns them into surprises.
📅 Period Close Crunch Profile
Profile posting activity by day-of-month to quantify how much of each close is back-loaded into the final business days.
🕳️ Unapplied Cash & Credits Sweep
Every customer payment, credit memo, vendor credit, and deposit with an unapplied balance — aged, sided, and matched to its likely application target. Real money sitting in limbo, misstating both AR and AP.

💱 Multi-Entity & Consolidation (10)

💱 Currency Exposure Heatmap
Map open AR, AP, and bank balances by currency and subsidiary to surface unhedged FX exposure.
🌐 Currency Translation Analyzer
Analyze currency translation with ASC 830 / IAS 21 compliance and CTA impact.
🌐 Elimination Entry Generator
Generate consolidation eliminations with automated validation and audit trail.
🌐 Global Tax Position Analyzer
Analyze global tax position with ETR optimization and transfer pricing insights.
🌐 Intercompany Reconciler
Reconcile intercompany balances with automated matching and exception resolution.
🌐 Legal Entity Rationalization Advisor
Advise on entity simplification with cost-benefit analysis and implementation planning.
🌐 Multi-Subsidiary Consolidator
Consolidate multi-subsidiary financials with currency translation and eliminations.
🌐 Shared Services Allocator
Allocate shared services costs with driver-based methodology and compliance.
🌐 Subsidiary Activity Asymmetry
Compare transaction volume, GL activity, and master-data freshness across subsidiaries to find under-used or unintended-default entities.
🌐 Subsidiary Performance Comparator
Compare subsidiary performance with benchmarking and ranking analysis.

🗺️ Operational Intelligence (42)

Free
🗺️ Account Configuration Summary
One-page configuration atlas of the account — enabled features, subsidiary tree, fiscal calendar, user/role census, and utilization signals — built entirely from live introspection.
Free
🩺 Account Data Quality Composite Score
One scored dashboard for overall account data health — six cheap, fast probes (addresses, mandatory-field gaps, broken chains, unapplied cash, dimension tagging, duplicate names) normalized to 0–100 with drill-down pointers to the specialist prompts.
Free
⚙️ Operational Efficiency Analyzer
Identify operational inefficiencies and bottlenecks across transaction flows.
Free
📆 Stale Open Transaction Groomer
Every open PO, SO, and estimate that has outlived any plausible fulfillment horizon — aged, dollar-quantified, with per-document close-out recommendations. The backlog grooming NetSuite never prompts anyone to do.
Free
📊 Transaction Volume Analyzer
Analyze transaction volume trends, patterns, and anomalies across all document types.
⚙️ Benchmark Comparison Tool
Compare performance against industry benchmarks with gap analysis.
📦 Bundle & SuiteApp Inventory
List every installed bundle and SuiteApp with version, publisher, and footprint to support upgrade and rationalization decisions.
🗓️ Calendar Heatmap of Activity
Render transaction volume as a year-long calendar heatmap to surface seasonality, dead zones, and crunch periods at a glance.
⚙️ Capacity Planning Assistant
Develop capacity plans based on demand forecasts and resource availability.
⚙️ Capacity Utilization Monitor
Monitor and report on capacity utilization across departments and facilities.
📸 Configuration Drift Snapshot & Diff
Capture a timestamped JSON baseline of the account's configuration surface — features, roles, mandatory fields, workflows, deployments, forms — persist it to the File Cabinet, and on every subsequent run diff against the prior baseline. Turns one-shot audits into change monitoring only an embedded agent can do.
🔧 Custom Field Mortality
Identify custom fields that are unused, misnamed, or duplicating native fields — the technical debt hiding in plain sight.
🗂️ Custom Record Type Sprawl
Map every custom record type, its bundle origin, and estimated row count to expose unused types and rationalize the data model.
🏢 Department Performance Scorecard
Score every department on revenue, cost, margin, and activity volume.
📊 Department Productivity Scorecard
Measure output per department against cost and headcount.
⏱️ Document Cycle Latency Atlas
Map average and P95 cycle times for every document flow — SO→Invoice, PO→Receipt, Bill→Pay — and flag bottlenecks.
📧 Email Template & PDF Form Audit
Inventory email templates and advanced PDF/HTML form templates, flag unused or outdated assets, and surface formatting risk.
📊 Executive Metrics Monitor
Surface the 12 most critical business metrics in a single executive dashboard.
📁 File Cabinet Health & Growth
Storage profile of the file cabinet — size by folder and type, growth trend, largest and stalest files, duplicate-name clusters — the visibility layer for an asset most accounts pay overage fees on blind.
🧾 Form Customization Inventory
Inventory every custom transaction and entry form — grouped by record type, standard vs. custom, preferred-form gaps, and naming-convention sprawl — via UI-page extraction, since NetSuite exposes no form table to SuiteQL.
🏷️ GL Class / Department Tagging Quality
Measure the completeness of class and department tagging on GL transactions — flag blank/null segments that impair segment reporting.
🔁 Hidden Rework Tax
Quantify post-submission edit churn from the systemnote audit trail to expose training gaps, weak validation, and process instability.
📊 KPI Dashboard Generator
Generate a customized KPI dashboard with drill-down capability.
📍 Location Performance Comparator
Compare revenue, cost, and margin across all locations.
💤 Master Data Dormancy
Surface customers, vendors, and items that have gone dormant — no transactions in 12+ months — to drive cleanup and re-engagement campaigns.
📝 Memo / Free-Text Anti-Patterns
Scan transaction memo fields for data-quality anti-patterns: nulls, duplicates, numeric dumps, and compliance red flags.
⚙️ NetSuite Customization Audit
Audit deployed NetSuite customizations — scripts, workflows, saved searches, custom records — for governance, change control, and risk.
🔭 NetSuite Release Impact Review Generator
Cross-references an upcoming NetSuite release's changes against a live inspection of THIS account — features, SuiteApps, scripts, integrations, transaction mix — and delivers a prioritized, interactive HTML review checklist.
🩺 NetSuite Utilization & Adoption Analyzer
Audit how fully a NetSuite instance is actually being used — module adoption, dimension discipline, process gaps, and data quality — and deliver a prioritized, evidence-based improvement roadmap as a polished HTML report.
📦 NetSuite Warehouse Download
Paginated bulk export of core NetSuite tables to a structured data warehouse format.
📉 Open Document Decay Curve
Plot the aging of open invoices, bills, and orders by origination month to surface systemic collection and payment delays.
🚚 Order Fulfillment Performance Tracker
Track order fulfillment rates, cycle times, and on-time delivery performance.
⏱️ Process Cycle Time Calculator
Calculate end-to-end cycle times for all key business processes.
🕳️ Required Field Compliance Audit
Find records with empty values in fields that are mandatory today — the silent legacy of fields made required after data already existed — with per-field violation counts and a backfill plan.
👥 Resource Utilization Analyzer
Analyze resource utilization across departments and projects.
🌪️ Sales Order Edit Storm
Identify sales orders subjected to excessive post-submission edits — a leading indicator of quoting instability, approval bypass, and customer churn risk.
🔍 Saved Search & Workbook Inventory
Inventory all saved searches and Analytics workbooks, flag stale or duplicate assets, and surface governance gaps.
🗝️ Saved Search Ownership & Exposure Map
The governance layer over the saved-search estate — who owns what, what breaks if they leave, which searches are load-bearing for scripts and dashboards — answered with inspection tools, not just a list.
🖥️ Script & Deployment Sprawl Audit
Audit every script and deployment record to quantify technical debt, identify undeployed code, and rank performance risk.
🔄 Workflow State Topology
Map every active workflow, its trigger conditions, and record type scope to surface automation gaps and redundancy.
🏭 Yield Rate Analyzer
Calculate manufacturing yield rates, scrap costs, and quality trends.
🧟 Zombie Automation Audit
Find automation that exists but does nothing — NOTINITIATING workflows, deployments on record types with zero activity, scheduled scripts with no recent execution trace — by cross-referencing configuration against runtime evidence instead of just cataloging it.

📈 Revenue & Customer Analytics (54)

Free
📈 AR Aging Analysis & Commentary
Generate comprehensive AR aging analysis with collection priorities and management commentary.
Free
📈 Customer Profitability Analyzer
Analyze customer-level profitability with cost-to-serve and margin analysis.
Free
🏁 Customer Revenue Bar Chart Race Generator
Animated bar chart race of top customers by cumulative revenue — watch ranks shift, compounders climb, and whales teleport in.
Free
📈 Revenue Trend Analyzer
Analyze revenue trends with segmentation, seasonality detection, and growth projections.
Free
📅 Sales Calendar Heatmap Generator
GitHub-style daily sales heatmap revealing seasonality, weekday patterns, outlier days, and data-quality artifacts.
💸 Bad Debt by Payer Analyzer
Analyze bad debt trends by payer with collection strategy recommendations.
📈 Bad Debt Reserve Estimator
Calculate bad debt reserves using CECL methodology with audit documentation.
📣 Campaign Performance Comparator
Compare fundraising campaign performance with ROI analysis and best practice identification.
🛒 Cart Abandonment Pattern Analyzer
Identify patterns in cart abandonment with recovery opportunity and revenue impact analysis.
📈 Channel Partner Analyzer
Assess partner performance with commission analysis and channel mix optimization.
📡 Channel Performance Comparator
Compare sales performance across channels (web, EDI, phone, retail) with profitability analysis.
🚫 Claim Denial Pattern Analyzer
Identify patterns in claim denials with root cause analysis and prevention recommendations.
🔥 Cohort Retention Heatmap
Render acquisition-cohort retention as a heatmap to see which cohorts decay fast and which stick.
📈 Collections Priority Ranker
Prioritize collection efforts with scoring models and automated action recommendations.
📈 Contract Profitability Analyzer
Analyze contract-level profitability with cost allocation and margin optimization.
🔗 Cross-Sell Opportunity Map
For each customer, list the items they don't buy that look-alike customers do — a data-driven cross-sell shortlist.
📈 Customer Churn Predictor
Predict customer churn risk and identify retention intervention opportunities.
📈 Customer Cohort LTV Curves
Build acquisition-cohort lifetime-value curves to compare how each cohort's revenue accumulates over months since first transaction.
🎯 Customer Concentration HHI
Compute the Herfindahl–Hirschman Index across customers and surface top-N revenue share to quantify concentration risk.
📈 Customer Credit Risk Monitor
Monitor customer credit risk with early warning indicators and limit recommendations.
🌎 Customer Geographic Distribution
Map customers and revenue by state, country, and metro to surface geographic concentration and untapped regions.
🩺 Customer Health Matrix Generator
Quadrant scatter of payment behavior × revenue with open-AR bubbles, plus a never-paid credit exposure watchlist.
💚 Customer Health Score (RFM)
Score every customer on Recency, Frequency, and Monetary value and segment into health tiers.
🏆 Customer Health Scorecard
Rank active customers on a composite 0–100 health score: revenue, payment discipline, and recency.
📈 Customer Payment Behavior Analyzer
Analyze customer payment patterns with DSO tracking and collection prioritization.
🫧 Customer Profitability Bubbles
Plot every customer as a bubble on revenue × margin × volume to find the top-line names dragging down profitability.
📈 Customer Profitability Calculator
Calculate true customer profitability with activity-based costing and strategic tiering.
🔁 Customer Segment Migration
Track customers moving between revenue and health segments quarter over quarter to expose silent upgrades and downgrades.
📈 Customer Segment Performance Analyzer
Compare performance across customer segments with strategic recommendations.
👥 Customer Segmentation Blueprint
Produces 3-7 operational customer segments from your dataset using RFM + behavioral overlay methodology. Output is HTML with segment profiles, explicit LTV formulas, churn risk classification, prioritized marketing strategies (with channels, costs, expected lift, ROI, confidence), and segment migration logic for ongoing measurement.
🔀 Customer Status Flow
Render quarter-over-quarter customer flow (retained, churned, new, reactivated) as a Sankey to expose the mechanism behind net-new totals.
📈 Deal Desk Analyzer
Analyze deal structures with discount approval workflows and margin protection.
📈 Discount Pattern Analyzer
Analyze discount patterns and identify margin leakage opportunities.
🗺️ Geographic Sales Map Generator
Plot customer revenue on an interactive map with growth/decline trends, metro rollups, and state rankings.
🔁 Hidden Recurring Revenue
Detect de-facto recurring revenue patterns not tagged as subscriptions — customer/item pairs that transact on a predictable cadence.
📣 Lead Source & Marketing Campaign ROI
Attribute closed revenue to lead source and campaign to compute realized ROI per channel.
🧺 Market Basket Co-Occurrence
Find items frequently bought together across sales orders to inform bundling, cross-sell, and merchandising decisions.
🫧 Per-Customer Margin Profile
Per-customer bubble chart of revenue, gross margin %, and order count to expose the unprofitable share of the book.
🚀 Pipeline Velocity
Measure deal-count, win-rate, average deal size, and sales-cycle length to derive a single pipeline velocity number per period.
📈 Pricing Optimization Analyzer
Analyze pricing strategies with margin impact assessment and competitive positioning.
📈 Profitability Improvement Planner
Analyze P&L profitability, identify margin improvement opportunities, and build a prioritized improvement plan.
🏷️ Promotion & Discount Effectiveness
Compare margin and volume of orders carrying promotional discounts against the baseline to quantify true promo lift.
🚪 Quiet-Quitting Customer Detector
Identify long-tenured customers whose rolling spend has silently dropped >50% — the churn signal that doesn't trip exception reports.
💬 Quote Aging and Follow-up Prioritizer
Prioritize quote follow-ups based on aging, value, and win probability.
🎯 Quote Win Rate Analyzer
Analyze quote/estimate win rates, conversion patterns, and sales pipeline effectiveness.
🌊 Quote-to-Cash Funnel
Measure conversion and drop-off at every stage from estimate to cash receipt, with median elapsed time per stage.
📈 Revenue Quality Analyzer
Assess revenue quality and sustainability with risk indicators.
📈 Revenue Recognition Checklist
Ensure ASC 606 compliance with step-by-step checklist and documentation templates.
📈 Revenue Recognition Validator
Validate ASC 606 / IFRS 15 revenue recognition with performance obligation analysis.
💼 Sales Commission Reconciliation
Reconcile sales commissions — earned vs paid — and identify discrepancies for resolution.
📈 Sales Territory Analyzer
Evaluate territory performance with quota attainment and coverage optimization.
📈 Subscription Revenue Tracker
Track MRR/ARR metrics with churn analysis and revenue expansion insights.
📋 The Forgotten Estimate Pipeline
Surface old open estimates by age, owner, and customer to recover stalled pipeline value and clean up dashboard noise.
🔝 Top Revenue Spike Days
Rank the highest-revenue calendar days, decompose drivers (customers, items, channels), and tag campaign vs anomaly causes.

🛡️ Risk Management & Controls (20)

🛡️ Credit Risk Assessment Tool
Assess customer credit risk with scoring models and limit recommendations.
🛡️ Customer Concentration Risk Scorer
Analyze customer concentration risk with diversification recommendations.
👋 Departed User Residue
Inventory everything still anchored to inactive or access-revoked users — owned scripts and workflows, saved searches, supervisor chains, open assignments — the silent breakage that surfaces months after offboarding.
🛡️ Enterprise Risk Heatmap Generator
Generate visual risk heatmaps with impact/likelihood assessment and mitigation priorities.
🛡️ Exception Transaction Analyzer
Identify and analyze exception transactions requiring review or approval.
🛡️ Financial Compliance Validator
Validate financial data and transactions against compliance requirements.
🩺 Financial Health Stress Test
Runs a three-scenario stress test on a company's financial statements (20% revenue drop, 15% cost increase, supply chain disruption) plus a Combined Stress Floor view. Outputs a self-contained HTML report with prioritized, quantified mitigation plans for each scenario.
🛡️ Fraud Pattern Detector
Detect potential fraud patterns in transaction data using anomaly analysis.
👻 Inactive User Phantom Activity
Find inactive NetSuite users still associated with recent transaction metadata — offboarding gaps and live token risk.
🛡️ Internal Control Evaluator
Evaluate internal controls with gap identification and remediation recommendations.
🛡️ Internal Control Gap Identifier
Identify gaps in internal controls with remediation recommendations.
🔐 Login Forensics & Anomaly Detection
Three-mode login forensics — new-IP appearances, failed-login bursts, and same-day multi-IP activity — from the LoginAudit table, with a risk-ranked narrative.
🛫 Mass Update Pre-Flight Impact Analysis
Before anyone runs a bulk change — quantify the exact record population, enumerate the user-event scripts and workflows wired to that record type, and grade the rollback difficulty. The report that prevents the "why did 4,000 records change?" postmortem.
🌐 Publicly Exposed Files Audit
Every file in the cabinet marked "Available Without Login" is downloadable by anyone with the URL — no session, no role. Inventory them, classify by sensitivity, and rank what should be locked down today.
🔐 Role & Permission Surface Map
Map every role to its permission set and active users to expose over-permissioned roles and rarely-used custom roles.
🔐 Roles, Permissions & Separation of Duties Security Review
Audit roles, permission grants, user-role assignments, and separation-of-duties conflicts; map findings to COSO's five components; deliver ISACA-aligned remediation as a professional HTML report.
🛡️ Segregation of Duties Matrix
Build a per-user matrix of transaction types touched (created, approved, paid) to surface SoD violations directly from createdby/lastmodifiedby.
🎯 Single-Source Risk Identifier
Identify single-source vendor risks with mitigation strategies and alternative sourcing recommendations.
🔑 Token & Integration Credential Audit
Audit the account's machine identities — access tokens, OAuth 2.0 applications, and integration login traffic — matching issued credentials against observed usage to find stale tokens, orphaned integrations, and unexplained API traffic.
⚠️ Vendor Concentration & Single-Source Risk
Identify items, GL categories, or spend buckets sourced from a single vendor to expose supply-chain single points of failure.

🏥 Supply Chain & Inventory (23)

Free
🏥 Inventory Health Monitor
Assess inventory health across turnover, coverage, dead stock, and overstock with actionable disposition recommendations.
🔧 Assembly Build Profitability Analyzer
Analyze profitability of assembly builds by comparing standard costs to actual GL costs and sales revenue.
📦 Backorder / Open SO Aging
Age open sales orders and surface overdue fulfillments with customer-level detail.
⏳ Backorder Aging & Priority Ranker
Surface and prioritize open backorders by age, customer value, and fulfillment risk.
🧩 Bill of Materials Cost Analyzer
Explode BOM structure to compute standard build cost, identify high-cost components, and flag cost roll-up gaps.
🔄 Inventory Reorder Point Calculator
Compute data-driven reorder points and safety stock levels per SKU using actual demand and lead time data from NetSuite.
⚠️ Inventory Stockout Risk Score
Score every active SKU by stockout risk using velocity, on-hand, and lead time data from NetSuite.
🗂️ Item Master Health Score
Score item master data completeness and flag missing attributes that break downstream workflows.
💲 Item Pricing Drift Forensics
Detect items sold at inconsistent prices across invoices and quantify revenue leakage from uncontrolled pricing variance.
🚦 Item Velocity Trend (Lifecycle View)
Trend unit velocity per SKU over rolling windows to classify items as ramping, mature, declining, or end-of-life.
📊 Item Velocity vs. Margin Quadrant
Plot SKUs by sales velocity and margin into a strategic quadrant to guide pricing, promotion, and discontinuation decisions.
🗺️ Multi-Location Inventory Imbalance
Identify SKUs with stock imbalances across warehouse locations and quantify rebalancing opportunities.
📈 PO Trend & Supply Risk Analyzer
Analyze purchase order volume, value, and vendor concentration trends to identify supply chain risks and demand misalignments.
💰 Procurement Spend Optimizer
Analyze procurement spend for consolidation opportunities, vendor rationalization, and unit-cost improvement targets.
↩️ Return Rate by Item
Measure return rates per SKU, identify root causes, and quantify the revenue and cost impact of product returns.
🚚 Shipping Cost Optimizer
Analyze shipment volume, order-to-ship cycle time, and carrier patterns to identify shipping efficiency opportunities.
🛡️ Supply Chain Resilience Analyzer
Assess supply chain resilience across vendor concentration, lead time reliability, inventory coverage, and single-source exposure.
📦 Vendor Fill Rate & OTIF Analyzer
Measure vendor fill rate (quantity received vs ordered) and on-time-in-full delivery performance using PO and ItemRcpt data.
🗺️ Vendor Lead Time Atlas
Map average and worst-case vendor lead times to calibrate safety stock and reorder point settings.
⏱️ Vendor Lead Time Reliability Tracker
Track vendor lead time reliability over time, flag high-variability vendors, and correlate lead time with fill rate.
🔗 Vendor Performance & Dependency Analyzer
Score vendor performance across spend, fill rate, and lead time; identify strategic dependencies and single-source exposures.
🏭 Warehouse Efficiency Analyzer
Measure warehouse throughput (receipts and shipments), inventory utilization, and fulfillment cycle time by location.
⚙️ Work Order Cost Variance Analyzer
Compare standard vs actual work order costs, compute variance by assembly and period, and surface the root causes of manufacturing cost overruns.

🗺️ Tax & Compliance (3)

🗺️ Sales Tax Trend by State
Analyze sales tax collected and accrued by state over time — identify nexus gaps, rate changes, and filing exposure.
🧾 Tax Code Coverage Audit
Audit tax code assignment completeness on sales invoices and cash sales — identify taxable lines with no tax code and measure overall coverage.
📅 Tax Filing Readiness
Assess readiness for upcoming tax filings — check sales tax payable balances, nexus coverage, period close status, and 1099 vendor completeness.