Angage Docs

Appearance

Financial Reporting ​

Comprehensive financial reporting provides insights for decision-making and ensures compliance with accounting standards. This guide covers all aspects of financial reporting in Angage ERP.

Understanding Financial Reports ​

Core Financial Statements ​

Balance Sheet ​

Shows financial position:

  • Assets
  • Liabilities
  • Equity
  • Working capital
  • Financial ratios

Income Statement ​

Displays performance:

  • Revenue
  • Expenses
  • Gross profit
  • Operating income
  • Net income

Cash Flow Statement ​

Tracks cash movements:

  • Operating activities
  • Investing activities
  • Financing activities
  • Free cash flow

Statement of Changes in Equity ​

Shows equity movements:

  • Share capital
  • Retained earnings
  • Reserves
  • Dividends
  • Comprehensive income

Standard Reports ​

Running Financial Reports ​

  1. Navigate to Finance → Reports
  2. Select report category:
    • Financial Statements
    • Management Reports
    • Analytical Reports
    • Compliance Reports
    • Custom Reports

Report Parameters ​

Common options:

  • Period: Month/Quarter/Year
  • Company: Single/Consolidated
  • Currency: Reporting currency
  • Comparison: Prior period/Budget
  • Detail Level: Summary/Detail

How-To Guides ​

How to Generate Monthly Financial Statements ​

Balance Sheet ​

  1. Go to Reports → Balance Sheet
  2. Set parameters:
    • As of Date: Month-end
    • Format: Classified
    • Level: 3 (Show sub-accounts)
    • Comparison: Prior month & year
  3. Run report
  4. Export to Excel/PDF

Income Statement ​

  1. Select Income Statement
  2. Configure:
    • Period: Current month
    • YTD: Include
    • Budget: Show variance
    • Prior Year: Compare
  3. Generate report
  4. Review key metrics

How to Create Management Reports ​

Executive Dashboard ​

Build KPI dashboard:

  1. Financial Metrics

    • Revenue growth
    • Gross margin
    • Operating margin
    • EBITDA
    • Working capital

  2. Operational KPIs

    • Sales per employee
    • DSO/DPO
    • Inventory turns
    • Customer metrics

  3. Visualizations

    • Trend charts
    • Gauges
    • Heat maps
    • Scorecards

Departmental P&L ​

  1. Run P&L by Department
  2. Include:
    • Direct revenue
    • Direct costs
    • Allocated overhead
    • Contribution margin
  3. Compare periods
  4. Analyze variances

How to Perform Variance Analysis ​

Budget vs Actual ​

  1. Generate variance report
  2. Review by:
    • Account level
    • Department
    • Major variances
    • Percentage/amount

Variance Investigation ​

For significant variances:

  1. Identify Causes

    • Volume changes
    • Price variations
    • Timing differences
    • One-time items

  2. Document Findings

    • Create commentary
    • Link supporting data
    • Propose actions
    • Track resolution

How to Create Consolidated Reports ​

Multi-Company Setup ​

  1. Define consolidation:

    • Parent company
    • Subsidiaries
    • Ownership percentages
    • Reporting currency

  2. Elimination Rules:

    • Intercompany sales
    • Intercompany balances
    • Unrealized profits
    • Investment elimination

Running Consolidation ​

  1. Execute consolidation
  2. Review:
    • Individual statements
    • Elimination entries
    • Consolidated results
    • Minority interests
  3. Validate totals
  4. Generate reports

How to Build Custom Reports ​

Report Builder ​

  1. Access Report Designer

  2. Select data source:

    • General ledger
    • Sub-ledgers
    • Dimensions
    • Calculated fields

  3. Design layout:

    • Row definitions
    • Column definitions
    • Calculations
    • Formatting

Advanced Features ​

  • Drill-down capability
  • Dynamic filters
  • Conditional formatting
  • Embedded charts
  • Export automation

How to Create Board Packages ​

Monthly Board Report ​

Standard package includes:

  1. Executive Summary

    • Key highlights
    • Major events
    • Outlook

  2. Financial Statements

    • Balance sheet
    • Income statement
    • Cash flow
    • Key ratios

  3. Analysis

    • Variance commentary
    • Trend analysis
    • Segment performance
    • Risk factors

  4. Appendices

    • Detailed schedules
    • Assumptions
    • Definitions

Distribution ​

  • Generate PDF package
  • Secure distribution
  • Track access
  • Gather feedback

Advanced Reporting ​

IFRS/GAAP Compliance ​

Disclosure Requirements ​

Ensure complete reporting:

  • Accounting policies
  • Segment reporting
  • Related parties
  • Subsequent events
  • Going concern

Note Preparation ​

Create standard notes:

  1. Revenue recognition
  2. Significant estimates
  3. Financial instruments
  4. Contingencies
  5. Equity movements

Ratio Analysis ​

Liquidity Ratios ​

Current Ratio = Current Assets / Current Liabilities
Quick Ratio = (Current Assets - Inventory) / Current Liabilities
Cash Ratio = Cash / Current Liabilities

Profitability Ratios ​

Gross Margin = Gross Profit / Revenue
Operating Margin = Operating Income / Revenue
Net Margin = Net Income / Revenue
ROA = Net Income / Total Assets
ROE = Net Income / Equity

Efficiency Ratios ​

Asset Turnover = Revenue / Average Assets
Inventory Turnover = COGS / Average Inventory
Receivables Turnover = Revenue / Average AR

Segment Reporting ​

Define Segments ​

Based on:

  • Geographic regions
  • Product lines
  • Customer types
  • Distribution channels

Segment Analysis ​

Report by segment:

  • Revenue
  • Operating profit
  • Assets employed
  • Capital expenditure
  • Key metrics

Predictive Analytics ​

Trend Analysis ​

  • Revenue forecasting
  • Expense trending
  • Cash flow projection
  • Ratio evolution

Scenario Modeling ​

  • Best/worst case
  • Sensitivity analysis
  • Break-even analysis
  • Investment returns

Report Distribution ​

Automated Distribution ​

Schedule Setup ​

  1. Configure schedules:

    • Daily: Cash position
    • Weekly: Sales flash
    • Monthly: Full package
    • Quarterly: Board report

  2. Define recipients:

    • Email lists
    • Portal upload
    • Shared folders
    • API delivery

Security Controls ​

  • Encryption
  • Access controls
  • Watermarking
  • Audit trail
  • Expiration dates

Self-Service Reporting ​

User Access ​

Enable users to:

  • Run standard reports
  • Modify parameters
  • Save favorites
  • Schedule delivery
  • Export data

Governance ​

Maintain control:

  • Approved reports only
  • Data access limits
  • Change tracking
  • Usage monitoring
  • Performance limits

Best Practices ​

Report Design ​

  • Clear layouts
  • Consistent formatting
  • Meaningful titles
  • Proper grouping
  • Executive summaries

Data Quality ​

  • Reconcile before reporting
  • Validate calculations
  • Check reasonableness
  • Document assumptions
  • Version control

Performance ​

  • Optimize queries
  • Use caching
  • Schedule off-peak
  • Archive old reports
  • Monitor usage

Configuration ​

Report Settings ​

Navigate to Settings → Finance → Reporting:

  • Default Formats: PDF/Excel
  • Branding: Logo/colors
  • Decimal Places: 0 for thousands
  • Negative Numbers: (Brackets)
  • Date Formats: MM/DD/YYYY

Security Setup ​

  • Report access roles
  • Data filtering rules
  • Approval workflows
  • Distribution lists
  • Retention policies

Troubleshooting ​

Common Issues ​

Report not balancing

  • Check report date
  • Verify GL posting
  • Review mappings
  • Check calculations

Performance issues

  • Reduce date range
  • Limit detail level
  • Schedule off-hours
  • Review indexes

Access problems

  • Verify permissions
  • Check role assignment
  • Review data filters
  • Update security

Next Steps

Learn about Budget Management for planning and control.

Angage ERP Documentation

Copyright © 2024-present Angage