Skip to content

Financial Statements

The Financial Statements section allows administrators to configure structured financial statement templates and users to generate standard financial reports.

Navigation: Administration → Reporting → Financial Statements

What Are Financial Statement Templates?

Financial statement (FS) templates define the structure and layout of your core financial reports. Unlike ad-hoc reports that return raw data, FS templates define:

  • The line items and their hierarchy (sections, subtotals, totals)
  • Which GL accounts feed into each line
  • How amounts are calculated (sum, difference, formula)
  • Comparative columns (current period vs. prior period, budget vs. actual)

Standard Templates

PinkApple supports these standard financial statement types:

TemplateDescription
Balance SheetAssets, liabilities, and equity at a point in time
Income Statement (P&L)Revenue and expenses over a period
Cash Flow StatementCash inflows and outflows by activity type
Statement of Changes in EquityMovement in equity accounts over a period

Template Structure

Each template consists of lines organised in a hierarchy:

Balance Sheet
├── ASSETS (Section Header)
│   ├── Current Assets (Group)
│   │   ├── Cash & Bank Balances (Line → mapped to COA accounts)
│   │   ├── Loans Receivable (Line → mapped to COA accounts)
│   │   └── Total Current Assets (Subtotal → sum of above)
│   ├── Non-Current Assets (Group)
│   │   ├── Fixed Assets (Line → mapped to COA accounts)
│   │   └── Total Non-Current Assets (Subtotal)
│   └── TOTAL ASSETS (Total → sum of all asset groups)
├── LIABILITIES (Section Header)
│   └── ...
└── EQUITY (Section Header)
    └── ...

Line Types

TypeDescription
Section HeaderA heading with no amount (e.g., "ASSETS")
GroupA grouping of related lines
Detail LineMaps to specific COA accounts and displays their balance
SubtotalCalculates the sum of lines above it within the group
TotalCalculates the sum of specified groups or subtotals
FormulaA calculated line using a custom formula

Configuring a Template

  1. Navigate to Administration → Reporting → Financial Statements
  2. Select an existing template or create a new one
  3. Add lines in the desired order and hierarchy
  4. For each detail line, map COA accounts — select which GL accounts contribute to that line
  5. Configure subtotal and total references
  6. Save the template

Comparative Statements

Financial statements support comparative columns:

ComparisonDescription
Current vs. Prior PeriodThis month vs. last month
Current vs. Same Period Last YearThis January vs. last January
Actual vs. BudgetActual amounts vs. budgeted amounts
Multi-PeriodMultiple periods side by side

When generating a statement, select the comparison type and the system produces the comparative columns automatically.

Generating a Financial Statement

  1. Navigate to the reporting section
  2. Select a financial statement template
  3. Choose the period and business unit(s)
  4. Select comparison type if desired
  5. Click Generate

The output renders as a formatted statement with:

  • Structured line items matching the template
  • Amounts pulled from the GL for the selected period
  • Comparative columns if configured
  • Drill-down capability on any amount

Notes and Disclosures

FS templates can include notes — supplementary disclosures that provide additional detail:

  • Accounting policies
  • Breakdown of significant balances
  • Contingent liabilities
  • Related party transactions

Next Steps

PinkApple ERP by Stat Solutions Network