Topics covered

Income statement, advanced balance sheet

Included Files

.pbix file, sample data with over 300,000 journal entries, account listings and supporting data, external report metadata workbook (Excel) Example budget files (account-level budgets)

Report Structure

13Pages: 7 Income Statement, 4 Balance Sheet, 2 Validation/Mapping

Income statement views

Actual vs Budget, Actual vs Previous Year, Year-to-Date Plus, Account Level Analysis, Sales Analysis, Expense Analysis, Dimensional Analysis (Department & Project), Drill Through

Balance Sheet Views

Summary Balance Sheet, Working Capital, Monthly Balance Sheet, Balance Sheet with Trial Balance, Drill Through

Charts of Accounts

Configurable via Excel, 3 levels, two examples provided, unlimited charts, floating category support

Date & Period Management

3-click selection (Fiscal Year, Month, Analysis Period), configurable fiscal year end, Period, Year-to-Date, Trailing 12 months

Budget integration

OneDrive folder, account level budget structure, one workbook per year

Analytical capabilities

Budget variance, prior year variance, budget & PY to actual bridge, working capital, period-by-period, cumulative YTD & 12 months, opening balance, movement, closing balance, average, maximum, minimum balances

Dimensions

Department, project, customer, supplier

Validation features

Visual mapping checks, account duplication detection, chart of accounts coverage verification, unmapped account highlighting, regular vs. irregular subtotal validation

Balance sheet features

Opening/closing balance calculations, period movement analysis, daily average calculations, maximum balance tracking, minimum balance tracking, floating category support (assets/liabilities auto-classification)