Reports in Detail
Report Navigation
Click "Reports" in the left-hand menu to open the report navigation page. All report groups are displayed as cards:
| Group | Reports | Purpose |
|---|---|---|
| Statements | Customer statement, Supplier statement | Reconcile transaction details with customers/suppliers |
| Summary reports | Sales receivables summary, Purchase payments summary, Product sales overview, Negative stock summary | Macro-level data overviews and rankings |
| Performance & cash flow | Sales performance report, Sales detail report, Annual income & expense report | Performance reviews and annual financial analysis |
| Business decisions | Business analysis | Analysis of overall operating conditions |
Click any report card to open its detail page.
Statements
Customer Statement
Purpose: Reconcile sales and receipt details with a customer to confirm both sides' accounts agree.
How to use:
- The left panel shows a list of all customers, with search supported.
- Click a customer name; the right side shows that customer's transaction ledger.
- You can set a date range filter.
Ledger composition:
| Document type | Effect on outstanding balance | Notes |
|---|---|---|
| Sales order | Increases outstanding | Delivered amounts count toward receivables |
| Receipt | Reduces outstanding | The customer's payment offsets the outstanding balance |
| Sales return | Reduces outstanding | The return amount offsets receivables (negative) |
Key metrics:
- Opening outstanding: the accumulated outstanding balance before the selected date range.
- Running outstanding: the real-time outstanding balance after each transaction.
- Closing outstanding: the outstanding balance at the end of the selected date range.
Notable features:
- Expand product details: click a transaction row to expand and see the specific products, quantities, and amounts of that order.
- Pin customers: hover over a customer name to reveal a pin icon; click it to pin frequently used customers to the top.
- Export to Excel: click the export button to generate a complete statement Excel file including product details.
- Print: the statement can be printed directly.
- Document traceability: click at the end of each transaction row to view the original sales order or receipt.
Common use cases:
| Scenario | How to do it |
|---|---|
| View a customer's current total outstanding | Don't set a date range; look at the running outstanding of the last transaction |
| View total outstanding across all customers | Don't select a specific customer; view the running outstanding across all transactions |
| The customer has a prepayment | The running outstanding shows as negative, meaning the customer has overpaid |
| Monthly reconciliation | Set the date range to the current month, export to Excel, and send to the customer to verify |
Supplier Statement
Purpose: Reconcile purchase and payment details with a supplier.
It works the same way as the customer statement; the key difference is that the money flows in the opposite direction:
- Customer statement: money the customer owes us (accounts receivable).
- Supplier statement: money we owe the supplier (accounts payable).
| Document type | Effect on outstanding balance |
|---|---|
| Purchase order | Increases outstanding (we owe the supplier) |
| Payment | Reduces outstanding (we've paid) |
| Purchase return | Reduces outstanding (the return offsets payables) |
It likewise supports expanding product details, pinning, exporting to Excel, and printing.
Summary Reports
Sales Receivables Summary
Purpose: See all customers' outstanding balances at a glance and quickly find who owes the most.
Page contents:
- Summary cards: total contract amount, amount received, total outstanding.
- Customer outstanding table: one row per customer, showing order count, contract amount, amount received, and outstanding amount.
- Supports sorting by outstanding amount.
- Click a customer name to jump to that customer's statement detail.
Purchase Payments Summary
Purpose: See all suppliers' payment status at a glance and quickly find who has the most outstanding.
Page contents:
- Summary cards: total purchase amount, amount paid, amount unpaid.
- Supplier payment table: one row per supplier, showing order count, purchase amount, amount paid, and amount unpaid.
- Supports sorting by unpaid amount.
- Click a supplier name to jump to that supplier's statement detail.
Product Sales Overview
Purpose: Track sales data by product to understand which fabrics sell best.
Page contents:
- Date range filter: supports quick options (last month, last three months, this year).
- Total sales card: total sales amount for the selected period.
- Product ranking table: ranked by sales amount, showing rank, number, product name, order count, sales quantity, sales amount, and share.
Negative Stock Summary
Purpose: See which products currently have negative stock so you can replenish in time.
Page contents:
- Summary cards: number of products with negative stock, total negative stock quantity.
- Warehouse filter: view by warehouse.
- Negative stock table: shows photo, number, product name, color, warehouse, stock quantity, and pieces.
Performance & Cash Flow
Sales Performance Report
Purpose: Track sales performance by salesperson, used for performance reviews.
Page contents:
- Date range filter
- Salesperson filter: select from a dropdown to view a specific salesperson.
- Performance data: contract amount, amount received, amount outstanding.
- Supports expanding to view each salesperson's specific order details.
Sales Detail Report
Purpose: View sales details by salesperson, switchable between summary and detail modes.
Page contents:
- Display modes: summary view (same product and color merged into one row; click + to expand each sale) or detail view.
- Time filters: today, yesterday, this week, last week, this month, last month, this quarter, last six months, full year, custom.
- Salesperson collapsible panels: one group per salesperson; expand to view the sales details under that name (date, sales order, customer, product number, product name, etc.).
Annual Income & Expense Report
Purpose: Track full-year income, expenses, and profit by month to keep tabs on business performance.
Page contents:
- Year selector: switch to view different years.
- Summary cards: annual total income, total expenses, total profit.
- Monthly detail table: one row per month, showing income, expenses, and profit.
- Profit is shown in red when negative.
Business Decisions
Business Analysis
Purpose: Get a top-down view of business performance and analyze the aging of receivables and payables.
Page contents:
- Key metric cards: total receivables, total payables, total account balance, estimated inventory value (estimated using the most recent purchase price).
- Aging analysis: toggle between receivables (customers) and payables (suppliers), with details displayed across aging buckets of 0–30 days, 30–60 days, 60–90 days, 90–180 days, and 180+ days.
Related Articles
- Inventory & Sales in Detail — Sales, purchases, funds, and other operations
- Contacts & Data Permissions — Data permissions affect what's visible in reports