Reports
Sales • Stock • Profit • Party ledger (Prototype)
Net Sales
Rs 1,284,600
Prototype KPI cards
Gross Profit
Rs 214,900
Add charts in production
Top Party
Ali Traders
Filters connect to backend
| Metric | Details | Value |
|---|---|---|
| Total Invoices | Count of invoices in period | 148 |
| Average Basket | Avg invoice total | Rs 8,679 |
| Low Stock Items | Items below reorder | 23 |
Sales
—
Purchases
—
Money In
—
Money Out
—
Expenses
—
Entries
—
| Date | Type | Ref # | Party / Category | Description | Money In | Money Out |
|---|---|---|---|---|---|---|
| Loading… | ||||||
Opening Balance
—
Money In
—
Money Out
—
Net Change
—
Closing Balance
—
| Date | Opening | Money In | Money Out | Closing | Entries |
|---|---|---|---|---|---|
| Select Cash Flow to load. | |||||
Net Sales
—
Gross Profit
—
Expenses
—
Net Profit
—
| Select Profit & Loss to load. |
Expense Breakdown
No expenses in this range.
—
—
Opening Balance
—
Total Debit
—
Total Credit
—
Closing Balance
—
| Date | Type | Reference | Debit | Credit | Balance |
|---|---|---|---|---|---|
| Select a party and date range, then click Generate. | |||||
Current
—
1–30 Days
—
31–45 Days
—
46–60 Days
—
>60 Days
—
Grand Total Due
—
| Party | Phone | Current | 1–30 | 31–45 | 46–60 | >60 | Total Due | Oldest Invoice | |
|---|---|---|---|---|---|---|---|---|---|
| Select filters and click Generate. | |||||||||
Current
—
1–30 Days
—
31–45 Days
—
46–60 Days
—
>60 Days
—
Grand Total Due
—
| Supplier | Phone | Current | 1–30 | 31–45 | 46–60 | >60 | Total Due | Oldest Bill | |
|---|---|---|---|---|---|---|---|---|---|
| Select filters and click Generate. | |||||||||
Total Items
—
Total Qty
—
Stock Value
—
Low Stock Items
—
| Item | SKU | Category | Unit | Min Qty | Qty | Buy Price | Value | Status |
|---|---|---|---|---|---|---|---|---|
| Select filters and click Refresh. | ||||||||
Items Below Min
—
Unique Items
—
Total Shortfall
—
Restock Cost
—
| Item | SKU | Category | Unit | Warehouse | Qty | Min Stock | Shortfall | Buy Price | Restock Cost |
|---|---|---|---|---|---|---|---|---|---|
| Select filters and click Refresh. | |||||||||
Invoices
—
Total Value
—
Total Received
—
Outstanding
—
| Date | Invoice No | Customer | Outlet | Grand Total | Paid | Balance | Status |
|---|---|---|---|---|---|---|---|
| Select filters and click Refresh. | |||||||
Bills
—
Total Value
—
Total Paid
—
Outstanding
—
| Date | Bill No | Supplier | Outlet | Grand Total | Paid | Balance | Status |
|---|---|---|---|---|---|---|---|
| Select filters and click Refresh. | |||||||
Total Revenue
—
Total Profit
—
Total Qty Sold
—
No Cost Data
—
| Item | SKU | Category | Unit | Qty Sold | Returns | Revenue | Cost | Profit | Margin |
|---|---|---|---|---|---|---|---|---|---|
| Select filters and click Refresh. | |||||||||
Parties
—
Sale Discounts
—
Purchase Discounts
—
Total Combined
—
| Party | Phone | Type | Sale Disc | Sale Invoices | Purch Disc | Purch Bills | Total Discount |
|---|---|---|---|---|---|---|---|
| Select filters and click Refresh. | |||||||
Parties
—
Total Sales
—
Total Purchases
—
Sale Outstanding
—
Net Balance
—
| Party | Type | Group | Total Sale | Sale O/S | Total Purchase | Purch O/S | Net Balance | Activity |
|---|---|---|---|---|---|---|---|---|
| Select filters and click Refresh. | ||||||||
Groups
—
Total Sales
—
Total Purchases
—
Sale Outstanding
—
Net Balance
—
| Group | Parties | Sales | Purchases | Sale O/S | Purchase O/S | Net Balance |
|---|---|---|---|---|---|---|
| Select filters and click Refresh. | ||||||
Categories
—
Expenses
—
Total Amount
—
| Category | Expense Count | Total Amount | Avg per Expense |
|---|---|---|---|
| Select filters and click Refresh. | |||
Expenses
—
Total Amount
—
| Date | Category | Description | Bank Account | Amount |
|---|---|---|---|---|
| Select filters and click Refresh. | ||||
Invoices
—
Total Revenue
—
Total Cost
—
Total Profit
—
Overall Margin %
—
Unknown Cost
—
| Date | Invoice No | Party | Outlet | Revenue | Cost | Profit | Margin % | Lines | Cost Basis |
|---|---|---|---|---|---|---|---|---|---|
| Select filters and click Refresh. | |||||||||
Parties
—
Total Revenue
—
Total Cost
—
Total Profit
—
Overall Margin %
—
Unknown Cost
—
| Party | Type | Group | Invoices | Revenue | Cost | Profit | Margin % | Unknown Cost | Cost Basis |
|---|---|---|---|---|---|---|---|---|---|
| Select filters and click Refresh. | |||||||||
Items
—
Total Opening
—
Total In
—
Total Out
—
Total Closing
—
| Item | SKU | Category | Unit | Opening | Total In | Total Out | Closing | Net | |
|---|---|---|---|---|---|---|---|---|---|
| Select filters and click Refresh. | |||||||||
Total Assets
—
Cash & Bank
—
Total Liabilities
—
Owner's Equity
—
Select Balance Sheet to load.