Financial Prompts

The Financial prompt samples include common tasks and workflows such as:

Period narratives
Margin analysis
Budget variance flags
Anomaly detection

Prompt Name	Suggested Roles	Prompt Sample
Current Period Financial Overview	Chief Executive Officer Chief Financial Officer Controller	`Use the ns_runReport tool to analyze the Income Statement for [current period] in [subsidiary] and identify any notable financial metrics and trends. Highlight any significant line items that require attention.`
Profitability Deep Dive	Chief Executive Officer Chief Financial Officer Controller	`Use the ns_runReport tool to analyze the Income Statement for [current period] in [subsidiary], drill down into our gross margin, operating margin, and net margin. What are the main drivers behind our profitability performance, and which cost categories had the most impact?`
Period-over-period Comparison	Chief Executive Officer Chief Financial Officer Controller	`Use the ns_runReport tool to analyze the Income Statement in [subsidiary] to compare [period range], to the same period the previous year. Calculate percentage changes for revenue, gross profit, operating expenses, and net income. Identify the 3 biggest positive and negative variances between the periods compared.`
Trend Analysis	Chief Executive Officer Chief Financial Officer Controller	`Use the ns_runReport tool to analyze the Income Statement in [subsidiary] to compare [period range] to the same period the previous year. Identify emerging trends in our key performance indicators. Are there any concerning patterns in expense growth relative to revenue growth?`
Operational Efficiency Metrics: Consolidated	Chief Executive Officer Chief Financial Officer Controller	Use the ns_runReport tool to analyze the Income Statement by Department in [subsidiary]to calculate and analyze expense ratios across [mon YYYY to mon YYYY] to the prior period and to the same period in the previous year. "SG&A as % of Revenue" (Selling, General and Administrative) will be calculated as the Total Expense for Department tagged as [General & Admin, Marketing, and Sales, with their underlying children departments] divided by Total Revenue. This mertic is delivered as a percentage. "R&D as % of Revenue" (Research & Development) will be calculated as the Total Expense for Departments tagged as [Research & Development, as its children departments] divided by Total Revnue. This metric is delivered as a percentage. Provide these metrics across the comparison requested and provided analysis of our operational leverage and scalability.
Operational Efficiency Metrics: SGA Operating Expense Only	Chief Executive Officer Chief Financial Officer Controller	`Use the ns_runReport tool to analyze the Income Statement by Department in [subsidiary] to calculate and analyze SGA Expense across [mon YYYY to mon YYYY] to the prior period and to the same period in the previous year. SG&A as % of Revenue' (Selling, General, and Administrative) will be calculated as the Total Expense for Departments tagged as [General & Admin, Marketing, and Sales, with their underlying children departments] divided by Total Revenue. This metric is delivered as a percentage.`
Operational Efficiency Metrics: R&D Operating Expense Only	Chief Executive Officer Chief Financial Officer Controller	`Use the ns_runReport tool to analyze the Income Statement by Department in [subsidiary] to calculate and analyze R&D Expense across [mon YYYY to mon YYYY] to the prior period and to the same period in the previous year. R&D as % of Revenue' (Research & Development) will be calculated as the Total Expense for Departments tagged as [Research & Development, and its children departments] divided by Total Revenue. This metric is delivered as a percentage.`
Cash Flow Implications	Chief Executive Officer Chief Financial Officer Controller	`Use the ns_runReport tool to analyze the Income Statement for [current period] to summarize the organization's cash flow and working capital. Additionally, highlight any non-cash items that are impacting the actual cash generation`
Cash Flow Statement Detail	Chief Executive Officer Chief Financial Officer Controller	Generate a comprehensive Cash Flow Statement for [current period] categorizing cash activities into Operating, Investing, and Financing. Provide a detailed breakdown of the cash flow into the following sections: 1. Cash Flow Summary: Tabulate the total cash inflows and outflows for each of the three activity categories (Operating, Investing, Financing) for the entire period. 2. Monthly Operating Cash Flow: Present a monthly breakdown of the operating cash flow from [January 2025 to December 2025]. For each month, calculate the net cash flow and flag any month with a negative net cash flow with a red dot. 3. Explanation of Negative Months: For each month flagged with a red dot, provide a concise explanation for the negative cash flow, categorizing the reason into one of the following: - Large inventory purchase - Slow customer payments - Timing of vendor payments - Other (please specify) Ensure the output is in a structured format, preferably in tables for Sections 1 and 2, and bullet points or short paragraphs for Section 3, to facilitate easy understanding and analysis of the cash flow statement.
Board Report Synthesis	Chief Executive Officer Chief Financial Officer Controller	Create a concise financial narrative comparing performance between [period] and [period] for the [subsidiary], using the Income Statement report. Focus on analysis and narrative clarity for this executive audience. The report should include analysis on period over period changes in revenue, expense, gross profit, and trending metrics. Include SG&A as % of Revenue, R&D as % of Revenue, Cash Flow summary. Identify 1) Key Headlines 2) Variance Analysis & Explanation 3) Strategic Implications 4) Action Items. Example Output for a Key Headline: [Revenue grew 8% month-over-month, reaching $1.26M, driven by higher subscription renewals. Cost of sales nearly doubled from additional software licensing fees, reducing gross margin to 79%. Operating expenses increased 51% as marketing and personnel costs rose, leading to a 66% decline in net income. Overall, results show continued sales growth but margin pressure from rising service costs.]
Forward-Looking Insights	Chief Executive Officer Chief Financial Officer Controller	`Use the ns_runReport tool to analyze the Income Statement for [current period] to identify any positive or negative trends for the organization. Then provide 3-5 opportunities for the organization to improve in the upcoming period, based on this analysis; also provide 3-5 risks to monitor for the upcoming period.`
Customer Analysis	Chief Executive Officer Chief Financial Officer Controller	Use the ns_runReport tool to analyze our customer base. For [period], use the Customer Profitability Summary to provide our 10 largest customers by Total Revenue, Total Profit, and % of total revenue. Review our list of customers and provide a narrative summary on the locations (City, State, Country) where customers are located. Compare that to the locations of our Sales Reps to assess appropriate geographical coverage. Review our list of customers and provide a narrative summary of the industries that these customers are comprised of. Use the Customer Category tag on the customer record for this information, along with publicly available information for that customer. Do a few items or services dominate sales? This can be found from the Sales by Item report. In your analysis of these, identify any trends in the data, flag any risks - concentrated customers, over-reliance on top customers/categories, etc., as well as opportunities for growth
Payment Behavior Scoring	Chief Executive Officer Chief Financial Officer Controller A/R Analyst	Analyze customer payment patterns from [January 1 to Dec 31 2025]. For each customer, calculate: Average Days to Pay: Calculate the average number of days between the Invoice Date and the Payment Date for each invoice. Formula: (Sum of all (Payment Date - Invoice Date)) ÷ Total Number of Invoices. Percentage of Invoices Paid Within Terms: Calculate the percentage of invoices paid on or before the agreed payment terms (e.g., Net 30, Net 60, etc.). Classify Payment Behavior Based on the Following Criteria: Excellent: Average payment ≤ 20 days, 90%+ invoices paid within terms. Good: Average payment between 21-30 days, 75-89% invoices paid within terms. Slow: Average payment between 31-45 days, 50-74% invoices paid within terms. Problem: Average payment > 45 days or < 50% invoices paid within terms. For customers classified as "Problem": Provide a trend analysis (is the payment behavior improving or worsening over time?). Recommend credit policy actions (e.g., "Place on credit hold", "Require advance deposits", etc...).
Balance Sheet Health Check	Chief Executive Officer Chief Financial Officer Controller	Generate a comprehensive financial report as of [today's date], following these steps: 1. Calculate the total assets, liabilities, and equity. 2. Verify that the accounting equation Assets = Liabilities + Equity holds true. 3. Compute the Current Ratio by dividing Current Assets by Current Liabilities. 4. Identify and flag any account that exceeds 20% of its respective category. Present the report in two distinct sections: - Financial Position Summary: Include totals for Assets, Liabilities, and Equity. - Health Check: Provide the calculated Current Ratio and list any flagged accounts, highlighting unusual items in the format "Account Name: $Amount (Percentage of Category) Brief Explanation of Unusual Item". Ensure the report is concise, well-structured, and adheres to standard accounting principles. Deliver the output as a formatted text report.
YoY Income Statement Comparison	Chief Executive Officer Chief Financial Officer Controller	Compare Income Statements for the periods [January 1 - Dec 31 2025] and the same period in [2024], and provide a detailed analysis of the variances between the two years. For each line item in the income statements, perform the following calculations: 1. Calculate the dollar variance by subtracting the 2024 amount from the 2025 amount. 2. Calculate the percentage change by dividing the variance by the 2024 amount and multiplying by 100. 3. Flag any line item with a percentage change greater than 10% (either increase or decrease) as notable. Present the results in a table with the following columns: Line Item \| [2025] Amount \| [2024] Amount \| $ Change \| % Change \| Status Then, provide a separate list of all flagged line items, including a brief contextual explanation for each (approximately 1-2 sentences per item), using the format: "[Line Item] [dollar change] ([percentage change]%) [↑/↓] [Brief context]". Ensure the output is in a clear and readable format, with proper headings and concise descriptions.
Budget Overruns Alert	Chief Financial Officer Controller	Analyze the Q4 expenses from [Jan 1-Jan 31] 2025, and compare them to the budget, considering only expense accounts. Perform the following analysis: 1. Categorize expenses and group them by category. 2. Calculate the actual spending versus budget for each category. 3. Compute the variance as (Actual - Budget) ÷ Budget × 100 for each category. 4. Identify categories with a variance exceeding 10% of the budget. For categories exceeding the 10% budget variance threshold, provide detailed information, including: - The three largest transactions within each flagged category. - The primary driver or reason for the variance. - Recommended actions to address the variance. Organize the output into three sections: Section 1: A table detailing all expense categories, including their corresponding variances. Section 2: A detailed breakdown of flagged categories, including the three largest transactions, drivers, and recommended actions. Section 3: An executive summary outlining the total budget overage and key findings. Present the output in a structured format, using examples like "Category: Actual vs Budget (% variance) - Description of largest transactions - Recommended action" to facilitate clear and concise communication of the analysis results.
Slow Inventory Analysis	Inventory Manager	Review the inventory as of [M D, YYYY], and perform a two-part analysis based on the provided Inventory Summary and Inventory Detail data. First, calculate the turnover rate for each category in the Inventory Summary. Next, analyze the Inventory Detail to identify items with zero sales in the last 90 days. For these slow-moving items, provide the following information: - Quantity and total value - Days since the last sale - Assign a priority level based on the days since the last sale: - Priority 1: 150+ days since last sale, recommend a discount of 30-40% - Priority 2: 90-150 days since last sale, suggest a promotional bundle - Priority 3: 60-90 days since last sale, recommend close monitoring Generate the following output: 1. A category summary table with turnover rates for each category 2. A table of slow-moving items, sorted in descending order by total value, including quantity, total value, days since last sale, and assigned priority 3. A liquidation strategy for slow-moving items, including expected recovery values, presented in the following format: "Item Name: Quantity units, $Value, Days since last sale - Recommended action = Expected recovery" Ensure all calculations are accurate and based on the provided data. The output should be in a clear, tabular format for easy analysis.
Open Invoices - Critical Notices	Controller A/R Analyst	Use the ns_runReport tool on the NetSuite Open Invoices report (Report ID: 261) for [subsidiary] as of today and format the output as follows: 1. Title: "Outstanding Invoices Report" with current date 2. Summary section: Total outstanding amount and invoice count 3. Invoice Details table: Invoice #, Customer, Invoice Date, Due Date, Days Past Due, Amount Due 4. Aging Analysis table: Show counts and totals by aging bucket (Over 90, 61-90, 31-60, 1-30, Current) 5. Top 5 Outstanding Balances: Ranked list of customers with highest balances 6. Critical Notices: Use :warning: bullets to highlight overdue invoices, aging issues, and recommended actions 7. Footer: Ask if user wants collection list, statements, bad debt analysis, or export. Sort invoices by date ascending. Use currency formatting with 2 decimals. Include horizontal rules between sections.
Customer Analysis - Geographic	Controller A/R Analyst	`Review our list of customers and provide a narrative summary on the locations (City, State, Country) where customers are located. Compare that to the locations of our Sales Reps to assess appropriate geographical coverage.`
Customer Analysis - Industries	Controller A/R Analyst	`Review our list of customers and provide a narrative summary of the industries that these customers are comprised of. Use the Customer Category tag on the customer record for this information, along with publicly available information for that customer.`
Customer Payment Analysis	Chief Executive Officer Chief Financial Officer Controller A/R Analyst	`Analyze customer payment trends and risks in the [subsidiary]. Use the A/R Aging Report to summarize: - Total A/R Balance - Aging Distribution - Top 10 Overdue customers - Average Days to Payment - Customers with Credit Risk - A/R Balance by Customer Category`
A/R Analysis - Summarized by Customer	Chief Financial Officer Controller A/R Analyst	`Run the A/R Aging Summary report (report ID 274) for the [subsidiary] as of [today]. If the ns_runReport tool returns null values, use SuiteQL to query the transaction table directly for all open customer invoices with unpaid amounts, grouped by customer, and calculate aging buckets based on due dates. Provide the total A/R balance by customer.`
A/R Analysis - Summarized by Age Distribution	Chief Financial Officer Controller A/R Analyst	`Run the A/R Aging Summary report (report ID 274) for the [subsidiary] as of [today]. If the ns_runReport tool returns null values, use SuiteQL to query the transaction table directly for all open customer invoices with unpaid amounts, grouped by customer, and calculate aging buckets based on due dates. Provide the total A/R balance by customer with aging bucket breakdowns`
A/R Analysis - By Customer Category	Chief Financial Officer Controller A/R Analyst	`Run the A/R Aging Summary report (report ID 274) for the [subsidiary] as of [today] to summarize unpaid amounts by Customer Category. Provide the total A/R balance by category`
A/R Analysis - Top 10 Customers	Chief Financial Officer Controller A/R Analyst	`Run the A/R Aging Summary report (report ID 274) for the [subsidiary] as of [today] to list the 10 highest receivable balances in order by unpaid amount. Then list the 10 customers with the oldest/most overdue receivable balances.`
A/R Analysis - Days to Pay	Chief Financial Officer Controller A/R Analyst	`Use the ns_runReport in the A/R Payment History by Payment Report to summarize the Average Days to Payment by customers in [period]. Summarize the Median Days to Payment by customers in this period as well`
A/R Analysis - Customers with Credit Risk	Chief Financial Officer Controller A/R Analyst	`Provide a list of Customers with an open accounts receivable balance with Credit Risk. This list should be a table with a hyperlink to the customer record, the customer name, the sales rep, and the date they became a customer`
A/R Analysis - By Revenue Account	Chief Financial Officer Controller A/R Analyst	`Using the A/R Aging Report, provide the accounts receivable balance by Sales Item. Understanding that NetSuite does not record customer payments or accounts receivable at the item level, you should be able to add a column to the A/R Aging Report indicating Item or GL Account. This would look at open invoices/receivables, grouped by GL account. The total amount will net to zero as Accounts Receivable will be included in the report.`
Vendor Analysis	Chief Executive Officer Chief Financial Officer Controller	Analyze vendor payment trends and risks in [subsidiary]. Identify the Top Vendors by spend over the trailing 12 months. How much of our total spend is allocated to these top vendors? Highlight if there is risk in the concentration of our purchasing. Review A/P Payment History by Bill to summarize how discounts, rebates, payment terms, etc. are being leveraged in the purchasing process. Review Income Statement Detail trends in operating expenses and cost of goods sold to summarize rising costs and areas exposed to overspend. Provide the Finance and Purchasing teams with actionable insights and opportunities to improve ROI in future periods.
Vendor Spend Across Currencies	Controller A/P Analyst	`Tell me my top 10 vendors by spend in the United States subsidiary for the year 2025. Create a bar chart containing this information. Are there any vendors outside of this subsidiary that spend more? What subsidiary typically pays them? Convert all spend to USD.`
Vendor Payment Trend Analysis	Controller A/P Analyst	`Analyze vendor payment trends and risks in [subsidiary]. Identify the Top Vendors by spend over the trailing 12 months. How much of our total spend is allocated to these top vendors? Highlight if there is risk in the concentration of our purchasing.`
COGS Detail and Trends	Chief Executive Officer Chief Financial Officer Controller	`Use the ns_runReport to review the Income Statement Detail report in [subsidiary] over [period] to identify trends in operating expenses and cost of goods sold to summarize rising costs and areas exposed to overspend.`
Employment Engagement Metrics	Controller	`Generate an Employee Engagement Metrics report from our NetSuite HR data including: - Turnover rates by department and tenure - Management span of control analysis - Career progression indicators (promotions, role levels) - New hire retention at 30/60/90 days - Department-specific engagement scores Create visual charts showing trends and department comparisons.`
Anomaly Detection	Chief Executive Officer Chief Financial Officer Controller	Use the ns_runReport tool to analyze all transactions [this month] to identify unusual relationship combinations that deviate from historical patterns, such as: GL accounts paired with vendors/customers that have rarely/never been used before; transactions in GL accounts from users who do not usually post to those accounts; GL account and department combinations that are statistically rare; transaction amounts that are outliers for specific account types; posting times that deviate from normal patterns (e.g., late-night posting to revenue account).
Budget vs Actual Risk Flags	Chief Executive Officer Chief Financial Officer Controller	Use the ns_runReport tool to review the Budget vs. Actual report for [period] in [subsidiary] to flag Departments with Expenses above their Budget for that period. Highlight these departments with their amount over budget and % variance to budget. Then review NetSuite instance to explain the drivers of this variance. Possible drivers could be headcount changes in that department (new employees or reduction in employees), Vendor spend, or other. Summarize your findings and recommend corrective actions for future periods.
Working Capital Analysis	Chief Executive Officer Chief Financial Officer Controller	Perform comprehensive working capital analysis using NetSuite financial data in [subsidiary] over [period]. Requirements: 1. Extract data using ns_runCustomSuiteQL: - AR aging (current and historical 12 months) - AP aging (current and historical 12 months) - Inventory balances and turnover data - Monthly revenue and COGS 2. Calculate working capital components: - Days Sales Outstanding (DSO) - trend over 12 months - Days Inventory Outstanding (DIO) - trend over 12 months - Days Payable Outstanding (DPO) - trend over 12 months - Cash Conversion Cycle (CCC = DSO + DIO - DPO) - Working capital as % of revenue 3. Perform trend analysis: - Month-over-month changes in each metric - Identify inflection points and drivers - Seasonal pattern recognition - Peer comparison (if benchmark data provided) 4. Build comprehensive dashboard: - Working capital waterfall chart - CCC trend with components stacked - DSO/DIO/DPO trends with target lines - Working capital efficiency metrics - Cash tied up in operations calculation - Scenario analysis: impact of 10-day improvements - Industry benchmark comparison table 5. Create working capital optimization report: - Current state assessment with peer comparison - Component-level analysis (AR, Inventory, AP) - Root cause analysis for each inefficiency - Improvement opportunities ranked by impact: * DSO reduction initiatives * Inventory optimization strategies * DPO extension opportunities - Implementation roadmap with timeline - Expected cash release quantified - Risk assessment and mitigation Focus on: - Quantifying cash trapped in working capital - Identifying quick wins vs strategic initiatives - Balancing customer/vendor relationships with cash optimization - Measuring progress with specific KPIs Example insights to surface: - "10-day DSO reduction would free up $2.3M in cash" - "Inventory carrying costs: $180K annually, reduction opportunity: 20%" - "Extending AP terms from 30 to 45 days improves CCC by 15 days"
Vendor Bill Fraud Detection	Chief Financial Officer Controller	Analyze vendor bill data in [subsidiary] across [period] to create a comprehensive fraud detection analysis that identifies: 1. Duplicate payments: Bills with identical or very similar amounts to the same vendor within short time periods 2. Round number patterns: Unusually high frequency of round-number amounts (e.g., exactly $1,000, $5,000) which may indicate fabricated invoices 3. Suspicious timing: Bills submitted or approved outside normal business hours, on weekends, or holidays 4. Velocity anomalies: Vendors with unusual spikes in billing frequency or amounts compared to their historical patterns 5. Sequential invoice numbers: Multiple bills from the same vendor with sequential or nearly sequential invoice numbers submitted simultaneously 6. Amount patterns: Bills just under approval thresholds (e.g., multiple bills at $9,950 if threshold is $10,000) 7. Vendor anomalies: New vendors with immediate high-value transactions, PO box addresses, or vendors sharing bank account details 8. Statistical outliers: Bills with amounts that are statistical outliers (>3 standard deviations) for that vendor or category Please provide: - A summary of high-risk findings with specific examples - A prioritized list of vendors/bills for investigation - Visualization of patterns where helpful - Specific recommendations for which transactions to review first

Prompt Name

Suggested Roles

Prompt Sample

Current Period Financial Overview

Chief Executive Officer
Chief Financial Officer
Controller

                    Use the ns_runReport tool to analyze the Income Statement for [current period] in [subsidiary] and identify any notable financial metrics and trends. Highlight any significant line items that require attention.

Profitability Deep Dive

Chief Executive Officer
Chief Financial Officer
Controller

                    Use the ns_runReport tool to analyze the Income Statement for [current
    period] in [subsidiary], drill down into our gross margin, operating margin, and net margin.
    What are the main drivers behind our profitability performance, and which cost categories had
    the most impact?

Period-over-period Comparison

Chief Executive Officer
Chief Financial Officer
Controller

                    Use the ns_runReport tool to analyze the Income Statement in
    [subsidiary] to compare [period range], to the same period the previous year. Calculate
    percentage changes for revenue, gross profit, operating expenses, and net income. Identify the 3
    biggest positive and negative variances between the periods compared.

Trend Analysis

Chief Executive Officer
Chief Financial Officer
Controller

                    Use the ns_runReport tool to analyze the Income Statement in
    [subsidiary] to compare [period range] to the same period the previous year. Identify emerging
    trends in our key performance indicators. Are there any concerning patterns in expense growth
    relative to revenue growth?

Operational Efficiency Metrics: Consolidated

Chief Executive Officer
Chief Financial Officer
Controller

                    Use the ns_runReport tool to analyze the Income Statement by Department in [subsidiary]to calculate and analyze expense ratios across [mon YYYY to mon YYYY] to the prior period and to the same period in the previous year. 

"SG&A as % of Revenue" (Selling, General and Administrative) will be calculated as the Total Expense for Department tagged as [General & Admin, Marketing, and Sales, with their underlying children departments] divided by Total Revenue. This mertic is delivered as a percentage.

"R&D as % of Revenue" (Research & Development) will be calculated as the Total Expense for Departments tagged as [Research & Development, as its children departments] divided by Total Revnue. This metric is delivered as a percentage.

Provide these metrics across the comparison requested and provided analysis of our operational leverage and scalability.

Operational Efficiency Metrics: SGA Operating Expense Only

Chief Executive Officer
Chief Financial Officer
Controller

                    Use the ns_runReport tool to analyze the Income Statement by Department in [subsidiary] to calculate and analyze SGA Expense across [mon YYYY to mon YYYY] to the prior period and to the same period in the previous year. 

SG&A as % of Revenue' (Selling, General, and Administrative) will be calculated as the Total Expense for Departments tagged as [General & Admin, Marketing, and Sales, with their underlying children departments] divided by Total Revenue. This metric is delivered as a percentage.

Operational Efficiency Metrics: R&D Operating Expense Only

Chief Executive Officer
Chief Financial Officer
Controller

                    Use the ns_runReport tool to analyze the Income Statement by Department in [subsidiary] to calculate and analyze R&D Expense across [mon YYYY to mon YYYY] to the prior period and to the same period in the previous year. 

R&D as % of Revenue' (Research & Development) will be calculated as the Total Expense for Departments tagged as [Research & Development, and its children departments] divided by Total Revenue. This metric is delivered as a percentage.

Cash Flow Implications

Chief Executive Officer
Chief Financial Officer
Controller

                    Use the ns_runReport tool to analyze the Income Statement for [current period] to summarize the organization's cash flow and working capital. Additionally, highlight any non-cash items that are impacting the actual cash generation

Cash Flow Statement Detail

Chief Executive Officer
Chief Financial Officer
Controller

                    Generate a comprehensive Cash Flow Statement for [current period] categorizing cash activities into Operating, Investing, and Financing.

Provide a detailed breakdown of the cash flow into the following sections:

1. Cash Flow Summary: Tabulate the total cash inflows and outflows for each of the three activity categories (Operating, Investing, Financing) for the entire period.

2. Monthly Operating Cash Flow: Present a monthly breakdown of the operating cash flow from [January 2025 to December 2025]. For each month, calculate the net cash flow and flag any month with a negative net cash flow with a red dot.

3. Explanation of Negative Months: For each month flagged with a red dot, provide a concise explanation for the negative cash flow, categorizing the reason into one of the following:
- Large inventory purchase
- Slow customer payments
- Timing of vendor payments
- Other (please specify)

Ensure the output is in a structured format, preferably in tables for Sections 1 and 2, and bullet points or short paragraphs for Section 3, to facilitate easy understanding and analysis of the cash flow statement.

Board Report Synthesis

Chief Executive Officer
Chief Financial Officer
Controller

                    Create a concise financial narrative comparing performance between [period] and [period] for the [subsidiary], using the Income Statement report.  

Focus on analysis and narrative clarity for this executive audience.

The report should include analysis on period over period changes in revenue, expense, gross profit, and trending metrics. Include SG&A as % of Revenue, R&D as % of Revenue, Cash Flow summary. 

Identify 1) Key Headlines 2) Variance Analysis & Explanation 3) Strategic Implications 4) Action Items.

Example Output for a Key Headline:
[Revenue grew 8% month-over-month, reaching $1.26M, driven by higher subscription renewals. Cost of sales nearly doubled from additional software licensing fees, reducing gross margin to 79%. Operating expenses increased 51% as marketing and personnel costs rose, leading to a 66% decline in net income. Overall, results show continued sales growth but margin pressure from rising service costs.]

Forward-Looking Insights

Chief Executive Officer
Chief Financial Officer
Controller

                    Use the ns_runReport tool to analyze the Income Statement for [current period] to identify any positive or negative trends for the organization. Then provide 3-5 opportunities for the organization to improve in the upcoming period, based on this analysis; also provide 3-5 risks to monitor for the upcoming period.

Customer Analysis

Chief Executive Officer
Chief Financial Officer
Controller

                    Use the ns_runReport tool to analyze our customer base. For [period], use the Customer Profitability Summary to provide our 10 largest customers by Total Revenue, Total Profit, and % of total revenue. 

Review our list of customers and provide a narrative summary on the locations (City, State, Country) where customers are located. Compare that to the locations of our Sales Reps to assess appropriate geographical coverage.

Review our list of customers and provide a narrative summary of the industries that these customers are comprised of. Use the Customer Category tag on the customer record for this information, along with publicly available information for that customer. 

Do a few items or services dominate sales? This can be found from the Sales by Item report. 

In your analysis of these, identify any trends in the data, flag any risks - concentrated customers, over-reliance on top customers/categories, etc., as well as opportunities for growth

Payment Behavior Scoring

Chief Executive Officer
Chief Financial Officer
Controller
A/R Analyst

                    Analyze customer payment patterns from [January 1 to Dec 31 2025]. For each customer, calculate:

Average Days to Pay: Calculate the average number of days between the Invoice Date and the Payment Date for each invoice. Formula: (Sum of all (Payment Date - Invoice Date)) ÷ Total Number of Invoices.

Percentage of Invoices Paid Within Terms: Calculate the percentage of invoices paid on or before the agreed payment terms (e.g., Net 30, Net 60, etc.).

Classify Payment Behavior Based on the Following Criteria:

 Excellent: Average payment ≤ 20 days, 90%+ invoices paid within terms.

Good: Average payment between 21-30 days, 75-89% invoices paid within terms.

Slow: Average payment between 31-45 days, 50-74% invoices paid within terms.

 Problem: Average payment > 45 days or < 50% invoices paid within terms.

For customers classified as "Problem":

Provide a trend analysis (is the payment behavior improving or worsening over time?).

 Recommend credit policy actions (e.g., "Place on credit hold", "Require advance deposits", etc...).

Balance Sheet Health Check

Chief Executive Officer
Chief Financial Officer
Controller

                    Generate a comprehensive financial report as of [today's date], following these steps:

1. Calculate the total assets, liabilities, and equity.
2. Verify that the accounting equation Assets = Liabilities + Equity holds true.
3. Compute the Current Ratio by dividing Current Assets by Current Liabilities.
4. Identify and flag any account that exceeds 20% of its respective category.

Present the report in two distinct sections:
- Financial Position Summary: Include totals for Assets, Liabilities, and Equity.
- Health Check: Provide the calculated Current Ratio and list any flagged accounts, highlighting unusual items in the format "Account Name: $Amount (Percentage of Category)  Brief Explanation of Unusual Item".

Ensure the report is concise, well-structured, and adheres to standard accounting principles. Deliver the output as a formatted text report.

YoY Income Statement Comparison

Chief Executive Officer
Chief Financial Officer
Controller

                    Compare Income Statements for the periods [January 1 - Dec 31 2025] and the same period in [2024], and provide a detailed analysis of the variances between the two years.

For each line item in the income statements, perform the following calculations:
1. Calculate the dollar variance by subtracting the 2024 amount from the 2025 amount.
2. Calculate the percentage change by dividing the variance by the 2024 amount and multiplying by 100.
3. Flag any line item with a percentage change greater than 10% (either increase or decrease) as notable.

Present the results in a table with the following columns:
Line Item | [2025] Amount | [2024] Amount | $ Change | % Change | Status

Then, provide a separate list of all flagged line items, including a brief contextual explanation for each (approximately 1-2 sentences per item), using the format: "[Line Item] [dollar change] ([percentage change]%) [↑/↓] [Brief context]".

Ensure the output is in a clear and readable format, with proper headings and concise descriptions.

Budget Overruns Alert

Chief Financial Officer
Controller

                    Analyze the Q4 expenses from [Jan 1-Jan 31] 2025, and compare them to the budget, considering only expense accounts. Perform the following analysis:

1. Categorize expenses and group them by category.
2. Calculate the actual spending versus budget for each category.
3. Compute the variance as (Actual - Budget) ÷ Budget × 100 for each category.
4. Identify categories with a variance exceeding 10% of the budget.

For categories exceeding the 10% budget variance threshold, provide detailed information, including:
- The three largest transactions within each flagged category.
- The primary driver or reason for the variance.
- Recommended actions to address the variance.

Organize the output into three sections:
Section 1: A table detailing all expense categories, including their corresponding variances.
Section 2: A detailed breakdown of flagged categories, including the three largest transactions, drivers, and recommended actions.
Section 3: An executive summary outlining the total budget overage and key findings.

Present the output in a structured format, using examples like "Category: Actual vs Budget (% variance) - Description of largest transactions - Recommended action" to facilitate clear and concise communication of the analysis results.

Slow Inventory Analysis

Inventory Manager

                    Review the inventory as of [M D, YYYY], and perform a two-part analysis based on the provided Inventory Summary and Inventory Detail data.

First, calculate the turnover rate for each category in the Inventory Summary. 

Next, analyze the Inventory Detail to identify items with zero sales in the last 90 days. For these slow-moving items, provide the following information:
- Quantity and total value
- Days since the last sale
- Assign a priority level based on the days since the last sale:
- Priority 1: 150+ days since last sale, recommend a discount of 30-40%
- Priority 2: 90-150 days since last sale, suggest a promotional bundle
- Priority 3: 60-90 days since last sale, recommend close monitoring

Generate the following output:
1. A category summary table with turnover rates for each category
2. A table of slow-moving items, sorted in descending order by total value, including quantity, total value, days since last sale, and assigned priority
3. A liquidation strategy for slow-moving items, including expected recovery values, presented in the following format: "Item Name: Quantity units, $Value, Days since last sale - Recommended action = Expected recovery"

Ensure all calculations are accurate and based on the provided data. The output should be in a clear, tabular format for easy analysis.

Open Invoices - Critical Notices

Controller
A/R Analyst

                    Use the ns_runReport tool on the NetSuite Open Invoices report (Report ID: 261) for [subsidiary] as of today and format the output as follows:

1. Title: "Outstanding Invoices Report" with current date
2. Summary section: Total outstanding amount and invoice count
3. Invoice Details table: Invoice #, Customer, Invoice Date, Due Date, Days Past Due, Amount Due
4. Aging Analysis table: Show counts and totals by aging bucket (Over 90, 61-90, 31-60, 1-30, Current)
5. Top 5 Outstanding Balances: Ranked list of customers with highest balances
6. Critical Notices: Use :warning: bullets to highlight overdue invoices, aging issues, and recommended actions
7. Footer: Ask if user wants collection list, statements, bad debt analysis, or export. 

Sort invoices by date ascending. Use currency formatting with 2 decimals. Include horizontal rules between sections.

Customer Analysis - Geographic

Controller
A/R Analyst

                    Review our list of customers and provide a narrative summary on the locations (City, State, Country) where customers are located. Compare that to the locations of our Sales Reps to assess appropriate geographical coverage.

Customer Analysis - Industries

Controller
A/R Analyst

                    Review our list of customers and provide a narrative summary of the industries that these customers are comprised of. Use the Customer Category tag on the customer record for this information, along with publicly available information for that customer.

Customer Payment Analysis

Chief Executive Officer
Chief Financial Officer
Controller
A/R Analyst

                    Analyze customer payment trends and risks in the [subsidiary]. Use the A/R Aging Report to summarize: 

-   Total A/R Balance
-   Aging Distribution
-   Top 10 Overdue customers
-   Average Days to Payment
-   Customers with Credit Risk
-   A/R Balance by Customer Category

A/R Analysis - Summarized by Customer

Chief Financial Officer
Controller
A/R Analyst

                    Run the A/R Aging Summary report (report ID 274) for the [subsidiary] as of [today]. If the ns_runReport tool returns null values, use SuiteQL to query the transaction table directly for all open customer invoices with unpaid amounts, grouped by customer, and calculate aging buckets based on due dates. Provide the total A/R balance by customer.

A/R Analysis - Summarized by Age Distribution

Chief Financial Officer
Controller
A/R Analyst

                    Run the A/R Aging Summary report (report ID 274) for the [subsidiary] as of [today]. If the ns_runReport tool returns null values, use SuiteQL to query the transaction table directly for all open customer invoices with unpaid amounts, grouped by customer, and calculate aging buckets based on due dates. Provide the total A/R balance by customer with aging bucket breakdowns

A/R Analysis - By Customer Category

Chief Financial Officer
Controller
A/R Analyst

                    Run the A/R Aging Summary report (report ID 274) for the [subsidiary] as of [today] to summarize unpaid amounts by Customer Category. Provide the total A/R balance by category

A/R Analysis - Top 10 Customers

Chief Financial Officer
Controller
A/R Analyst

                    Run the A/R Aging Summary report (report ID 274) for the [subsidiary] as of [today] to list the 10 highest receivable balances in order by unpaid amount. 
Then list the 10 customers with the oldest/most overdue receivable balances.

A/R Analysis - Days to Pay

Chief Financial Officer
Controller
A/R Analyst

                    Use the ns_runReport in the A/R Payment History by Payment Report to summarize the Average Days to Payment by customers in [period]. 
Summarize the Median Days to Payment by customers in this period as well

A/R Analysis - Customers with Credit Risk

Chief Financial Officer
Controller
A/R Analyst

                    Provide a list of Customers with an open accounts receivable balance with Credit Risk. This list should be a table with a hyperlink to the customer record, the customer name, the sales rep, and the date they became a customer

A/R Analysis - By Revenue Account

Chief Financial Officer
Controller
A/R Analyst

                    Using the A/R Aging Report, provide the accounts receivable balance by Sales Item. Understanding that NetSuite does not record customer payments or accounts receivable at the item level, you should be able to add a column to the A/R Aging Report indicating Item or GL Account. This would look at open invoices/receivables, grouped by GL account. The total amount will net to zero as Accounts Receivable will be included in the report.

Vendor Analysis

Chief Executive Officer
Chief Financial Officer
Controller

                    Analyze vendor payment trends and risks in [subsidiary]. Identify the Top Vendors by spend over the trailing 12 months. How much of our total spend is allocated to these top vendors? Highlight if there is risk in the concentration of our purchasing.

Review A/P Payment History by Bill to summarize how discounts, rebates, payment terms, etc. are being leveraged in the purchasing process.

Review Income Statement Detail trends in operating expenses and cost of goods sold to summarize rising costs and areas exposed to overspend.

Provide the Finance and Purchasing teams with actionable insights and opportunities to improve ROI in future periods.

Vendor Spend Across Currencies

Controller
A/P Analyst

                    Tell me my top 10 vendors by spend in the United States subsidiary for the year 2025. Create a bar chart containing this information. 
Are there any vendors outside of this subsidiary that spend more? What subsidiary typically pays them?
Convert all spend to USD.

Vendor Payment Trend Analysis

Controller
A/P Analyst

                    Analyze vendor payment trends and risks in [subsidiary]. Identify the Top Vendors by spend over the trailing 12 months. How much of our total spend is allocated to these top vendors? Highlight if there is risk in the concentration of our purchasing.

COGS Detail and Trends

Chief Executive Officer
Chief Financial Officer
Controller

                    Use the ns_runReport to review the Income Statement Detail report in [subsidiary] over [period] to identify trends in operating expenses and cost of goods sold to summarize rising costs and areas exposed to overspend.

Employment Engagement Metrics

Controller

                    Generate an Employee Engagement Metrics report from our NetSuite HR data including:
-   Turnover rates by department and tenure
-   Management span of control analysis
-   Career progression indicators (promotions, role levels)
-   New hire retention at 30/60/90 days
-   Department-specific engagement scores

Create visual charts showing trends and department comparisons.

Anomaly Detection

Chief Executive Officer
Chief Financial Officer
Controller

                    Use the ns_runReport tool to analyze all transactions [this month] to identify unusual relationship combinations that deviate from historical patterns, such as: GL accounts paired with vendors/customers that have rarely/never been used before; transactions in GL accounts from users who do not usually post to those accounts; GL account and department combinations that are statistically rare; transaction amounts that are outliers for specific account types; posting times that deviate from normal patterns (e.g., late-night posting to revenue account).

Budget vs Actual Risk Flags

Chief Executive Officer
Chief Financial Officer
Controller

                    Use the ns_runReport tool to review the Budget vs. Actual report for [period] in [subsidiary] to flag Departments with Expenses above their Budget for that period. Highlight these departments with their amount over budget and % variance to budget.

Then review NetSuite instance to explain the drivers of this variance. Possible drivers could be headcount changes in that department (new employees or reduction in employees), Vendor spend, or other.

Summarize your findings and recommend corrective actions for future periods.

Working Capital Analysis

Chief Executive Officer
Chief Financial Officer
Controller

                    Perform comprehensive working capital analysis using NetSuite financial data in [subsidiary] over [period].

Requirements:
 1. Extract data using ns_runCustomSuiteQL:
   - AR aging (current and historical 12 months)
   - AP aging (current and historical 12 months)
   - Inventory balances and turnover data
   - Monthly revenue and COGS

 2. Calculate working capital components:
   - Days Sales Outstanding (DSO) - trend over 12 months
   - Days Inventory Outstanding (DIO) - trend over 12 months
   - Days Payable Outstanding (DPO) - trend over 12 months
   - Cash Conversion Cycle (CCC = DSO + DIO - DPO)
   - Working capital as % of revenue

 3. Perform trend analysis:
   - Month-over-month changes in each metric
   - Identify inflection points and drivers
   - Seasonal pattern recognition
   - Peer comparison (if benchmark data provided)

 4. Build comprehensive dashboard:
   - Working capital waterfall chart
   - CCC trend with components stacked
   - DSO/DIO/DPO trends with target lines
   - Working capital efficiency metrics
   - Cash tied up in operations calculation
   - Scenario analysis: impact of 10-day improvements
   - Industry benchmark comparison table

 5. Create working capital optimization report:
   - Current state assessment with peer comparison
   - Component-level analysis (AR, Inventory, AP)
   - Root cause analysis for each inefficiency
   - Improvement opportunities ranked by impact:
     * DSO reduction initiatives
     * Inventory optimization strategies
     * DPO extension opportunities
   - Implementation roadmap with timeline
   - Expected cash release quantified
   - Risk assessment and mitigation

Focus on:
 - Quantifying cash trapped in working capital
 - Identifying quick wins vs strategic initiatives
 - Balancing customer/vendor relationships with cash optimization
 - Measuring progress with specific KPIs

Example insights to surface:
 - "10-day DSO reduction would free up $2.3M in cash"
 - "Inventory carrying costs: $180K annually, reduction opportunity: 20%"
 - "Extending AP terms from 30 to 45 days improves CCC by 15 days"

Vendor Bill Fraud Detection

Chief Financial Officer
Controller

                    Analyze vendor bill data in [subsidiary] across [period] to create a comprehensive fraud detection analysis that identifies: 
1. **Duplicate payments**: Bills with identical or very similar amounts to the same vendor within short time periods 
2. **Round number patterns**: Unusually high frequency of round-number amounts (e.g., exactly $1,000, $5,000) which may indicate fabricated invoices 3. **Suspicious timing**: Bills submitted or approved outside normal business hours, on weekends, or holidays 
4. **Velocity anomalies**: Vendors with unusual spikes in billing frequency or amounts compared to their historical patterns 
5. **Sequential invoice numbers**: Multiple bills from the same vendor with sequential or nearly sequential invoice numbers submitted simultaneously 
6. **Amount patterns**: Bills just under approval thresholds (e.g., multiple bills at $9,950 if threshold is $10,000) 
7. **Vendor anomalies**: New vendors with immediate high-value transactions, PO box addresses, or vendors sharing bank account details 
8. **Statistical outliers**: Bills with amounts that are statistical outliers (>3 standard deviations) for that vendor or category 

Please provide: 
- A summary of high-risk findings with specific examples 
- A prioritized list of vendors/bills for investigation 
- Visualization of patterns where helpful 
- Specific recommendations for which transactions to review first

General Notices