Docs
User Manual
Volume 9: Administration, Studios & System Governance
#27: Enterprise Financial & Business Intelligence Reports Suite (Income Statement P&L, SARS VAT201 Return, Aged Debtors, Stock Valuation, Accountant Audit Pack & Studio)

User Manual Volume 9: Administration, Studios & System Governance Verified Guide

#27: Enterprise Financial & Business Intelligence Reports Suite (Income Statement P&L, SARS VAT201 Return, Aged Debtors, Stock Valuation, Accountant Audit Pack & Studio)

Updated 21 hours ago 7 min read 1 views

Volume 9 · Article #27 Executive BI & Financial Statements SARS VAT201 & Accountant Year-End Pack

Enterprise Financial & Business Intelligence Reports Suite (Income Statement P&L, SARS VAT201 Return, Aged Debtors, Stock Valuation, Accountant Audit Pack & Studio)

Turn your operational data into board-ready financial statements and statutory filings: understand Gross Profit vs. Net Operating Profit, generate your Income Statement (P&L), reconcile your SARS VAT201 Return worksheet, audit Aged Trade Receivables and Multi-Warehouse Stock Valuation, download your 1-Click Accountant's Year-End Audit Pack PDF & CSV schedules, and customize your Reporting Governance Studio.

1. Plain-English Financial Statements 101: Revenue, COGS, Gross Margin & Net Profit

When you open the **Income Statement (Profit & Loss)** or the **Accountant's Year-End Pack**, Keystone X structures your performance into a four-tier waterfall. Here is what each tier means in plain English:

1. Revenue (Sales Excl. VAT) [GL 4000] — Invoiced goods & services (excluding 15% SARS Output VAT, which belongs to SARS, not you) R 1,000,000.00

2. Less: Cost of Goods Sold (COGS) [GL 5000] — Direct landed/FIFO purchase cost of the inventory items sold (R 600,000.00)

= GROSS PROFIT (Gross Margin % = Gross Profit ÷ Revenue = 40.0%) R 400,000.00

3. Less: Operating Expenses (OPEX) [GL 6000–6999] — Rent, Salaries, Fuel, Software, Bank Charges (Excl. claimable Input VAT) (R 220,000.00)

= 4. NET OPERATING PROFIT BEFORE TAX (Net Margin % = 18.0%) R 180,000.00

Why VAT Never Appears on Your Profit & Loss Statement: If you are VAT-registered, the 15% Output VAT you charge customers is a tax liability (`GL 2200`), and the 15% Input VAT you pay suppliers is a tax asset (`GL 2210`). Neither is your income or expense—they are netted off in your **SARS VAT201 Return** (`report/sarsVat201`).

2. The 6-Mode Executive BI Command Center (`report/index`) & Smart Date Presets

Navigate to Reports & BI → Executive Reports Hub (`report/index`). At the top of every report is the **Universal Fiscal Period Filter Bar** supporting both custom `start_date` / `end_date` pickers and 6 instant presets: This Month, Last Month, This Quarter, Current Tax Year (automatically aligned to your fiscal start month, e.g., `01 Mar – 28 Feb`), Year-to-Date (YTD), and Rolling 12 Months.

📸 SCREENSHOT PLACEHOLDER: `reports-executive-bi-command-center.png`

Navigate to report/index?mode=overview.
Capture the Executive BI Command Center showing the Fiscal Period preset bar, the 6-Mode navigation pills (Overview, Financial Statements, SARS Tax & VAT201, Sales & AR, Inventory & Procurement, Audit & Operations), the 12-Month Revenue vs. COGS vs. OPEX chart, and the report directory cards.

3. Financial & Tax Reports: Income Statement (`sales`), VAT Control (`vat`) & SARS VAT201 (`sarsVat201`)

Report Name & Route	Target Audience	Exact Schedules, Columns & Calculations
Income Statement (Profit & Loss) `report/sales`	Directors, CFO, External Accountant	Displays Gross Invoiced Revenue (Ex-VAT), Less Credit Notes Issued, Net Revenue, Less Cost of Goods Sold (COGS), Gross Profit & Gross Margin %, itemized Operating Expenses grouped by GL Category (`6000–6999`), and Net Operating Profit & Net Margin %.
VAT Control & Tax Reconciliation `report/vat`	Bookkeeper, Tax Practitioner	Itemizes every taxable customer invoice, credit note, and supplier/operating expense in the period, reconciling total Output VAT (`GL 2200`) against total Input VAT (`GL 2210`).
SARS VAT201 eFiling Return Worksheet `report/sarsVat201`	SARS eFiling Submitter	Replicates the official South African Revenue Service VAT201 Return box-by-box: • Part A (Output Tax): `Box 1` Standard-Rated Supplies, `Box 2 / 2A` Zero-Rated Local & Export Supplies, `Box 3` Exempt Supplies, `Box 4` Output VAT on Box 1, `Box 12 / 13` Total Output Tax. • Part B (Input Tax): `Box 14` Capital Goods & Equipment, `Box 15` Other Goods & Services Claimable, `Box 18 / 19` Total Deductible Input Tax. • Net Settlement: `Box 20` Net VAT Payable to SARS (or Refundable by SARS), with 1-click CSV export (`report/exportLedger?type=vat201`).
GL Expense & Departmental Budget Report `report/expenses`	Financial Manager, Department Heads	Groups all operating expenses by GL Account Code and Category, comparing Period Ex-VAT Spend, Claimable Input VAT, and Total Inc-VAT against each category's monthly/annual GL Budget allocation.

4. Revenue & Treasury Reports: Aged Receivables, Sales by Customer/SKU, Quotes & Payments

Report Name & Route	Exact Schedules, Columns & Calculations
Aged Trade Receivables (Debtors Book) `report/agedReceivables`	Buckets every unpaid and partially paid customer Tax Invoice into statutory aging columns: Current (Not Yet Due), 1–30 Days Overdue, 31–60 Days Overdue, 61–90 Days Overdue, and 90+ Days Overdue (Legal/Collection Risk), with drill-down by Customer and 1-click CSV export (`report/exportLedger?type=debtors`).
Sales & Collection Performance by Customer `report/salesByCustomer`	Ranks your customers by Invoice Count, Gross Billed Revenue, Total Cash Collected, Outstanding Debtor Balance, and Collection Efficiency %.
Sales & Revenue Velocity by SKU / Item `report/salesByItem`	Ranks every catalog product and service SKU by Total Quantity Sold, Average Selling Price, Total Revenue (Ex-VAT), Unit Cost, and Gross Profit Contribution.
Quotation Pipeline & Win-Rate Conversion `report/quoteConversion`	Analyzes commercial proposals created in the period: Total Quotes Issued, Rand Pipeline Value, Accepted/Invoiced Quotes, Declined/Expired Quotes, and overall Win-Rate Conversion %.
Customer Payment & Treasury Receipts Register `report/paymentReport`	Chronological audit register of all customer receipts showing Receipt Date, Customer, Invoice #, Payment Method (`EFT`, `Card`, `Cash`, `Credit Wallet`), Reference #, Receiving Bank Vault, and Amount.

5. Inventory & Procurement Reports: Stock Asset Valuation, Low Stock & Vendor Spend

Report Name & Route	Exact Schedules, Columns & Calculations
Inventory Asset Valuation & Retail Margin `report/stockValuation`	Calculates your Balance Sheet Inventory Asset (`GL 1200`) across all managed SKUs: Item Code, Item Name, Category, ABC Velocity Class (`A`, `B`, `C`), On-Hand Quantity, Unit Cost Price, Total Cost Asset Value, Projected Retail Value, and Potential Unrealized Gross Profit. Includes 1-click CSV export (`report/exportLedger?type=inventory`).
Low Stock & Replenishment Alert Report `report/lowStock`	Lists every stock-managed SKU where `stock_quantity <= reorder_level`, showing the shortfall quantity, preferred Supplier, and estimated replenishment PO cost.
Procurement Spend by Supplier (SRM) `report/purchasesByVendor`	Summarizes Purchase Order count, received GRN value, and total AP spend per Supplier.
Procurement Volume & Spend by SKU `report/purchasesByItem`	Tracks total units purchased, lowest/average/highest supplier unit cost, and total procurement spend per inventory SKU.

6. Accountant's Year-End Report, AFS PDF (`accountantPdf`) & CSV Audit Exports (`exportLedger`)

At financial year-end (or when applying for bank finance), navigate to Reports & BI → Accountant's Year-End Pack (`report/accountant`). This consolidated executive dossier combines your **Annual Financial Statements (AFS) Income Summary**, **VAT Control Reconciliation**, **Aged Debtors Summary**, and **Closing Inventory Valuation** on one screen:

📸 SCREENSHOT PLACEHOLDER: `reports-accountant-year-end-audit-pack.png`

Navigate to report/accountant.
Capture the Accountant's Year-End Audit Pack showing the 4 consolidated financial schedules and the top-right export buttons (Download Official AFS PDF, Export Trial Balance CSV, Export Debtors CSV, Export Inventory CSV, and Export SARS VAT201 CSV).

7. 3-Tab Reports, BI & Statutory Audit Customization Studio (`report/settings`)

Click **Customize** (`report/settings`) in the Reports Command Center to configure three governance tabs:

Tab 1 — Fiscal Calendar & P&L Basis (`?tab=fiscal`): Set your **Fiscal Year Start Month** (`rpt_fiscal_year_start_month`, default `3` = March for South Africa), **Accounting Recognition Basis** (`Accrual / Invoice Basis` vs. `Cash Receipts Basis`), **Default Date Preset** (`this_month`, `tax_year`, `last_12_months`), **Target Gross Margin Benchmark %**, and **AFS PDF Page Orientation** (`Landscape` or `Portrait`).
Tab 2 — SARS VAT201 & Tax Reconciliation Rules (`?tab=vat`): Toggle Deduct Credit Notes from Box 1 Output VAT (`rpt_vat_include_credit_notes`) and Include Unpaid Supplier Bills in Box 15 Input VAT (`rpt_vat_include_unpaid_expenses`).
Tab 3 — Inventory Valuation & ABC Thresholds (`?tab=inventory`): Configure your Stock Valuation Cost Basis (`FIFO`, `WAVCO`, `Standard Cost`) and ABC Pareto classification thresholds (`Class A Top 80%`, `Class B Next 15%`, `Class C Bottom 5%`).