Point of Sale SubsystemCore Module

POS Daily Reporting

1. Overview & Purpose

What is POS Daily Reporting?

POS Daily Reporting consolidates operational retail performance metrics across outlets. It provides daily sales turnover, tender breakdown across cash/electronic methods, cashier performance comparisons, and end-of-day shift closing summaries.

Menu Location:Point of Sale > Reporting

2. When to Use POS Reporting

Store Manager End-of-Day Gross vs Net Sales Closing

Outlet manager assesses daily turnover, average basket size (Rp/ticket), guest count, and promotional coupon deductions immediately after store doors close.

Recommended Action:Filter by current business date and store branch to review Gross Sales, total discount deductions, sales returns, and Net Realized Revenue scorecards.

Payment Tender Breakdown & Bank Deposit Matching

Store finance lead prepares bank deposit slips and matches electronic gateway settlements (QRIS, EDC BCA Debit, Mandiri Credit, Bank Transfer).

Recommended Action:Open the Payment Tender Breakdown tab to match total electronic currency collected per payment channel against physical terminal batch settlement slips.

Cashier Discrepancy & Over/Short Variance Analysis

Internal store auditor investigates repetitive cashier drawer shortages (e.g. Cashier B consistently reporting -Rp 20.000 shortages on weekend shifts).

Recommended Action:Examine the Closing Summary table filtered by cashier user to evaluate cumulative cash variances, shift notes, and supervisor approval logs.

Hourly Sales Velocity & Peak Rush Staffing Optimization

Operations director analyzes customer transaction traffic by hour of day (e.g. 12:00 - 14:00 lunch rush) to allocate part-time cashier lane staffing.

Recommended Action:Inspect the hourly sales velocity chart to identify high-density shopping windows and ensure maximum register lanes are manned during peak hours.

Top-Selling SKU Contribution & Pareto Analysis (80/20 Rule)

Merchandise buyers examine which 20% of inventory items generate 80% of daily retail turnover to prioritize supplier restock orders.

Recommended Action:Open the Product Sales Ranking tab to evaluate sales volume, revenue contribution, and unit margin percentages per SKU.

Monthly Tax Compliance Audit & Official Excel / PDF Export

External auditors and tax consultants require verified monthly point-of-sale turnover reports showing gross sales, discounts, net sales, and VAT output.

Recommended Action:Apply month-long date filter and click Export to Excel / PDF to generate an audited summary matching the monthly corporate tax return.

3. Data Dictionary & Fields

Data contract and aggregated summary metrics structure:

Field / Column	Input Type	Requirement	Description & Operational Guide
period	ENUM(DAILY, WEEKLY, MONTHLY, YEARLY)	Required	Aggregation time bucket applied to sales summary statistics.
grossSales	DECIMAL(18,4)	Required	Total revenue rung up before deducting promotional discounts and returns.
netSales	DECIMAL(18,4)	Required	Net realized revenue after subtracting item discounts and sales returns.
totalTax	DECIMAL(18,4)	Required	Aggregate value-added tax collected across all completed POS transactions.
paymentBreakdown	OBJECT[]	Required	Array of tender types (Cash, QRIS, Card, Transfer) with counts and collected totals.
cashDifferenceTotal	DECIMAL(18,4)	Required	Cumulative cash surplus or shortage recorded across closed shifts in the period.

4. Interface Preview

POS Reporting dashboard showcasing turnover KPIs, payment tender breakdown chart, and shift reconciliation summaries.

inventories-web

Menu Location:Route: /admin/point-of-sale/reporting

Screen Preview: POS Reporting Dashboard Interface

Visual interface illustration and control layout for menu Route: /admin/point-of-sale/reporting

1Sales KPI Scorecards2Payment Tender Breakdown3Shift Audit & Over/Short4Excel & PDF Export

POS Reporting analytics view displaying daily gross/net sales cards, payment tender distribution charts, and shift reconciliation tables.

5. Daily Turnover & Gross Revenue

Navigate to POS Reporting

Select Point of Sale > Reporting from the primary sidebar navigation.

Apply Filter Parameters

Select target Branch, Location, Counter, and Date Range filter criteria.

Review Metric Scorecards

Inspect top KPI cards showing Total Sales, Total Transactions, Average Ticket, and Returns.

6. Payment Tender Breakdown

Analyze Tender Breakdown

Switch between Cash and Non-Cash breakdown tabs to view distribution percentages.

Inspect Closing Summaries

Examine shift-level closing logs including cashier names, opening cash, and cash variance.

7. Shift Audits & Data Export

Periodic Archival

Export shift logs at the end of each fiscal week to preserve historical cashier discrepancy signatures and manager notes.

Export Report

Click Export to Excel or PDF button in the upper toolbar for offline financial filing.

8. Cross-Module Impact

Target Subsystem	Relational & Transactional Effect
General Ledger Accounting	Provides source figures for monthly financial closing and revenue reconciliation against bank deposits.
User Management & Staff KPI	Calculates transactions per hour and checkout speed benchmarks for frontline cashier evaluations.

Operational Best Practices

Reconcile QRIS and EDC terminal settlement summaries daily before closing physical registers.
Export closing summaries weekly to spot repetitive cash discrepancies before month-end closing.