Skip to main content

Sales Order Summary Report

Overview​

The Sales Order Summary report provides a comprehensive view of all sales orders issued within a specific period, displaying key order details including customer information, order dates, delivery dates, order values, and unbilled amounts. Use this report to track sales pipeline, monitor billing progress, and analyze order patterns.

When to Use This Report​

Use this report when you need to:

  • Track all sales orders placed within a specific time period
  • Monitor unbilled amounts and billing pipeline
  • Analyze order values and payment status
  • Identify orders requiring invoice generation
  • Review delivery schedules and commitments
  • Filter orders by amount range for large order analysis
  • Export sales data for financial forecasting

How to Run the Report​

Step 1: Navigate to Sales Reports​

Access through main navigation: Reports → Sales Reports

The Sales Reports page displays available report types.

Step 2: Select Report Type​

Reports Dropdown

Click the Reports dropdown and select Sales Order Summary from the list.

The filter panel updates to show relevant filters for this report.

Step 3: Configure Filters​

Apply filters to focus your analysis:

Date Range Filter

Select the time period for order analysis:

  • Click Date Range field
  • Choose start date from calendar picker
  • Choose end date from calendar picker
  • Common ranges: Last month, Current quarter, Last 90 days

Orders with order dates falling within this range will be included.

Status Filter

Filter by order fulfillment status:

  • Click Status dropdown
  • Options available:
    • Select a status... (shows all)
    • Open - Orders not yet fulfilled
    • Partial Fulfilled - Some items delivered, some pending

Select specific status or leave blank to show all orders.

Amount Range Filter

Filter by order value:

  • Start Amount - Enter minimum order value
  • End Amount - Enter maximum order value
  • Leave blank to include all order values
  • Use for large order analysis (e.g., orders above ₹1,00,000)

Step 4: Run Report​

Click Run Report button to generate the report.

The system retrieves all sales orders matching your filter criteria and displays results in the table below.

Understanding the Report​

Report Structure​

The report displays as a detailed table with the following columns:

ColumnDescriptionExample
SO#Sales Order number (clickable link)SO-1005, SO-1002
Customer NameCustomer business nameAMAR ENTERPRISES, Connaught Place INvent
Order DateDate when order was created06-10-2025, 29-09-2025
Delivery DateExpected/committed delivery date06-10-2025, 29-09-2025
StatusOrder fulfillment status badgePartial Fulfilled, Open
SO Amount*Total order value including GST₹1,18,000.00, ₹47,20,000.00
Unbilled Amount*Portion not yet invoiced₹90,000.00, ₹35,40,000.00

Note: Values marked with asterisk (*) include GST as indicated in the footer.

Understanding Key Fields​

SO# (Sales Order Number)

Unique identifier for each sales order. Clicking the SO# link navigates to the detailed sales order view showing complete line items, customer details, shipping information, and transaction history.

Format typically follows: SO-#### where #### is a sequential number.

Customer Name

Full business name of the customer as registered in the customer master. Orders are listed individually even if multiple orders exist for the same customer, allowing line-by-line analysis of order details.

Order Date vs Delivery Date

Order Date records when the customer placed the order and it was entered in the system.

Delivery Date shows the committed delivery date promised to the customer. Compare these dates to identify long lead times or urgent orders requiring expedited processing.

Same dates indicate same-day delivery commitments. Different dates show planned delivery schedules.

Status Badge

Visual indicator of order fulfillment progress:

Open (typically shown in gray/default badge) - Order created but no items shipped yet. Full order value remains to be fulfilled.

Partial Fulfilled (shown in status column) - Some items delivered to customer, some items still pending shipment. Mix of fulfilled and open line items.

Status helps prioritize which orders need fulfillment attention and which are progressing normally through the delivery pipeline.

SO Amount

Total value of the sales order including all line items, discounts, and GST. This is the complete revenue commitment from the customer for this order.

The amount includes:

  • Base item value (quantity × rate)
  • Any line-item or order-level discounts applied
  • Applicable GST at configured rates
  • Shipping charges if included

This represents the total invoice value when the order is fully billed.

Unbilled Amount

The portion of the SO Amount not yet converted to customer invoices. This tracks the billing pipeline and pending revenue recognition.

Calculation: Unbilled Amount = SO Amount - Invoiced Amount

High unbilled amounts indicate:

  • Orders delivered but not yet invoiced (revenue recognition pending)
  • Partially delivered orders (unbilled portion awaiting fulfillment)
  • Orders with delayed invoicing requiring attention

Zero unbilled amount means the order is fully invoiced (but payment may still be pending).

Working with Report Data​

Example Scenarios​

Scenario 1: Weekly Billing Pipeline Review

Filter by orders from the past month with any unbilled amount. Sort by unbilled amount descending to prioritize large unbilled orders. Create invoices for fully delivered orders showing high unbilled balances.

Example from report:

  • SO-1005 to AMAR ENTERPRISES shows ₹90,000 unbilled from ₹1,18,000 total
  • SO-1002 to Connaught Place shows ₹35,40,000 unbilled from ₹47,20,000 total

Both orders require invoice generation to recognize revenue.

Scenario 2: Large Order Tracking

Use amount range filter with Start Amount ₹5,00,000 to view only major orders. Monitor these high-value orders closely for delivery performance and customer satisfaction. Export the list for executive reporting.

Scenario 3: Delivery Performance Analysis

Run report for last quarter. Compare Order Date to Delivery Date columns to calculate average delivery lead time. Identify orders where delivery date has passed but status remains "Open" - these are delayed orders requiring escalation.

Scenario 4: Customer Order Frequency

Export the full report. Use Excel to count orders per customer and calculate average order values by customer. Identify customers with high order frequency for relationship management priority.

Export and Analysis​

Exporting Data​

Click the Export icon (typically in top-right of table) to download report data.

Available formats:

  • Excel (.xlsx) - Includes formatting, suitable for further analysis
  • CSV - Raw data format for import into other systems

Exported file includes all visible columns with applied filters preserved.

Report footer displays:

"Values marked with an asterisk (*) include GST."

This clarifies that SO Amount and Unbilled Amount are GST-inclusive figures, important for financial analysis and revenue recognition calculations.

Quick Tips​

Best Practices

Review unbilled amounts every Friday to create invoices before month-end, ensuring timely revenue recognition and cash flow.

Filter by Partial Fulfilled status to identify orders stuck in fulfillment, indicating potential inventory issues or operational delays.

Use date range to compare same periods year-over-year for sales growth analysis and seasonal trend identification.

Sort by SO Amount descending to prioritize customer service attention on high-value orders requiring white-glove treatment.

Need help? Contact support at support@bizconnekt.com