Reporting System Flowchart

Consolidated Reporting for Sales, Inventory, Waste, and Financials

Last Updated: Jan 07, 2026
Flow Information

Purpose: Provide actionable insights via centralized dashboards.

User Roles: Admin, Owner, Finance, Head Section

Data Sources: POS (Sales), Inventory (Stock), Purchasing (Cost), Production (Recipes)

Outlets: Pudak, Eyckman, BTC Botanica

flowchart TD subgraph Data_Sources ["Data Sources (Real-time Integration)"] direction TB POS[("1 POS System
Sales Data
(Per Outlet)")] INV[("2 Inventory
Stock Levels &
Stock Opname")] PROD[("3 Production
Recipes, COGS,
& Waste Data")] PURCH[("4 Purchasing
Expenses &
Incoming POs")] end subgraph Central_Processing ["Central Reporting Engine"] direction TB ETL["5 System
Data Aggregation
& Processing"] CALC_PL["6 System
Calculate P&L
(Rev - COGS - Exp)"] CALC_VAR["7 System
Calculate Variance
& Waste Cost"] end subgraph Report_Output ["Report Dashboards (Admin View)"] direction TB subgraph Fin_Report ["1. Jurnal (Financial)"] R_FIN[["8 Dashboard
Profit & Loss
(Weekly/Monthly/Yearly)"]] end subgraph Waste_Report ["2. Waste Analysis"] R_WASTE[["9 Dashboard
Waste Report
(Daily/Weekly/Monthly)"]] end subgraph Inv_Report ["3. Inventory Status"] R_INV[["10 Dashboard
Stock Opname &
Incoming Goods (Ordered)"]] end subgraph Sales_Report ["4. Sales by Outlet"] R_SALES[["11 Dashboard
Multi-Outlet Sales
(Pudak, Eyckman, BTC)"]] end end POS --> ETL INV --> ETL PROD --> ETL PURCH --> ETL ETL --> CALC_PL ETL --> CALC_VAR CALC_PL --> R_FIN CALC_VAR --> R_WASTE ETL --> R_INV ETL --> R_SALES classDef styleStart fill:#E3F2FD,stroke:#1976D2,stroke-width:1px,color:#1976D2 classDef styleSubmit fill:#FFFFFF,stroke:#808080,stroke-width:1px,color:#6a6a6a classDef styleEnd fill:#c1fabd,stroke:#35c454,stroke-width:1px,color:#0c6d12 classDef styleSystem fill:#e9ecef,stroke:#495057,stroke-width:1px,color:#495057 class POS,INV,PROD,PURCH styleStart class ETL,CALC_PL,CALC_VAR styleSubmit class R_FIN,R_WASTE,R_INV,R_SALES styleEnd style Data_Sources fill:none,stroke:#333,stroke-width:2px,stroke-dasharray: 5 5 style Central_Processing fill:none,stroke:#333,stroke-width:2px,stroke-dasharray: 5 5 style Report_Output fill:none,stroke:#333,stroke-width:2px,stroke-dasharray: 5 5
Color Legend
Start Process Submit Actions Decision Points Payment Types Cancel/Error End Process Link to other flow

Report Dashboard Preview

Total Revenue (Dec 2025)

IDR 245,000,000

+12.5% vs Last Month

Total Expenses

IDR 148,500,000

-2.3% vs Last Month

Net Profit

IDR 96,500,000

39.4% Margin

Profit & Loss Statement (Bakery Division)
Category Amount (IDR) % of Sales Trend
Total Revenue (Sales) 245,000,000 100% 12%
    Sales - Bakery 180,000,000 73.5%
    Sales - Beverage 65,000,000 26.5%
COGS (Cost of Goods Sold) (85,750,000) 35% Stable
    Ingredients (Flour, Butter, etc.) (75,000,000) 30.6%
    Waste / Spoilage (10,750,000) 4.4% High
Gross Profit 159,250,000 65%
Operational Expenses (62,750,000) 25.6%
    Payroll (35,000,000) 14.2%
    Utilities & Rent (20,000,000) 8.1%
Net Profit 96,500,000 39.4% Healthy
Top High Waste Items (This Week)
1. Saltbread Dough 12.5 kg (IDR 1,500,000)
Reason: Over-proofing, Production Error
2. Fresh Milk 8.0 L (IDR 240,000)
Reason: Expired
3. Croissants (Baked) 15 pcs (IDR 375,000)
Reason: Unsold (End of Day)
Waste Summary
Total Waste Cost (Dec)

IDR 10.75M

4.4% of Total Revenue

Waste Log (Recent)
  • Butter
    Today, 10:00 AM - Outlet 1
    Dropped
  • Eggs
    Yesterday, 4:00 PM - Kitchen
    Broken

Total Items

452 SKUs

In Stock

410 SKUs

Low Stock

35 SKUs

Out of Stock

7 SKUs

Incoming Goods (Ordered)
PO Number Vendor Items Details Est. Arrival Value Status
PO-2023-005 PT Trisna Pangan
  • Tepung Cakra (50kg)
  • Butter Anchor (20kg)
 Tomorrow, 10 AM IDR 5,200,000 Ordered
PO-2023-006 Fresh Dairy Co. Milk Greenfields (100L) Today, 2 PM IDR 2,800,000 Out for Delivery
Daily Stock Opname Results
Item System Qty Physical Qty Difference Action
Vanilla Essence 12 btl 11 btl -1
Sugar (White) 50 kg 49.5 kg -0.5 kg
Outlet Performance Overview (December 2025)
Outlet 1: Pudak

IDR 85.5M

5.2% vs last month
Target Achievement 85%
Outlet 2: Eyckman
Top Performer

IDR 105.2M

12.8% vs last month
Target Achievement 105%
Outlet 3: BTC Botanica

IDR 54.3M

0.5% vs last month
Target Achievement 60%
Top Selling Products (Consolidated)
Rank Product Name Category Units Sold Total Revenue Top Outlet
#1 Premium Saltbread Bakery 1,250 pcs IDR 18,750,000 Eyckman
#2 Chicken Curry Rice Kitchen 850 portions IDR 29,750,000 Pudak
#3 Iced Matcha Latte Beverage 600 cups IDR 15,000,000 Eyckman