📊 Product Intelligence Analytics

Upload NetSuite exports to analyze profitability, inventory health, and sales trends by SKU and customer.

📁

Item Cost CSV

NetSuite Path: Reports → Inventory → Item Cost
Required: Item, Avg Item Rate, Avg Est. Unit Cost, Quantity

📊

Sales by Item Summary (XLS)

NetSuite Path: Reports → Sales → Sales by Item Summary
Required: Item, Description, Qty Sold, Total Revenue

👥

Sales by Customer Detail (XLS)

NetSuite Path: Reports → Sales → Sales by Customer Detail
Required: Customer, Transaction Type, Date, Total Revenue

🏭

Purchase Order Details (XLS)

NetSuite Path: Reports → Purchasing → Purchase Order Detail
Required: Vendor, Item, Date, Total Cost, Quantity

📈 Profit vs Loss Analysis

🎯 Product Performance

⚡ Quick Export Actions

Items requiring price review or discontinuation

Items running low on stock needing immediate orders

Overstocked & dead stock items to liquidate

← Back to Overview

TREASURY MANAGEMENT

💰 Advanced Cash Flow Intelligence

Enterprise-grade cash flow forecasting with predictive analytics and working capital optimization.

📋

General Ledger Data

NetSuite Path: Reports → Financial → General Ledger
Required: Account, Account Name, Balance, Date

💳

Accounts Receivable

NetSuite Path: Reports → Financial → A/R Aging Detail
Required: Customer, Invoice Date, Due Date, Amount

💰

Accounts Payable

NetSuite Path: Reports → Financial → A/P Aging Detail
Required: Vendor, Bill Date, Due Date, Amount

📊

Historical Cash Flow

NetSuite Path: Reports → Financial → Cash Flow Statement
Required: Period, Operating Activities, Investing, Financing

Business Intelligence by Mitch

New vs Returning — last 30 days

Sales — Last 14 Days