…
Get started on Day 1 with these ready-to-use reports, planning forms, and dashboard templates.
P&L Variance Report
P&L report with budget and actual results for this year and last year, with variances.
P&L Opening Balance Roll Forward
Report to verify opening balance and prior year activity reconciliation.
Balance Sheet – Opening Balance Roll Forward
Report to verify opening balance and prior year activity reconciliation.
Accounts Payable Spending Trend by Vendor
AP spending trend by vendor with the spending by month for a rolling 13 months.
Accounts Receivable Detail
AR detail with details including customer, invoice number, invoice dates, and aging buckets in graphical and list format.
Accounts Payable Detail
AP detail with details including vendor, invoice number, invoice dates, and aging buckets in graphical and list format.
P&L – Top-Down Driver Based Forecast Template
Driver-based P&L model used to forecast P&L by month for the remainder of the year.
Balance Sheet Consolidating Report
Multi-entity Balance Sheet consolidating assets, liabilities, and shareholder equity into one report.
Balance Sheet Current Year Trend
Balance Sheet trend reflecting assets, liabilities, and shareholder equity for current year only.
Balance Sheet with Change by Month
Balance Sheet reflecting monthly changes with YTD totals for current and prior year.
P&L Variance with Consolidation & SPV Entity
Multi-entity P&L report with consolidated report, plus individual reports for each entity.
Balance Sheet Variance Report
Balance Sheet reflecting assets, liabilities, and shareholder equity for both this year and last year actuals, with variances.
P&L Summary Level by Month and by Quarter
P&L report with summary for executive-level updates for YTD financials, presented in monthly and quarterly views.
P&L Consolidating Report
Multi-entity P&L report consolidating entities into one report with last year to date, current year to date, and budget.
P&L Forecast Summary
P&L report with YTD actual results and forecast of remainder of year, for full-year estimate.
P&L YTD Actual, Budget Rest of Year
P&L report with YTD actual results and budget for remainder of year, for full-year estimate.
Trial Balance Report
GL report that lists account closing balances for this year and last year, with variances.
Dashboard Navigation and Overview
Power BI dashboard menu that provides quick navigation to each financial dashboard.
GL Dashboard – Business Comparison – KPIs
Power BI comparison across business units for P&L and Balance Sheet KPIs.
GL Dashboard – KPI Benchmarking
Power BI P&L and Balance Sheet amounts and ratio benchmarking of one entity against the average of other internal entities.
GL Dashboard – Revenue Benchmarking
Power BI revenue benchmarking of one entity against the average of other internal entities.
GL Dashboard – Profitability Benchmarking
Power BI profit and margin benchmarking of one entity against the average of other internal entities.
GL Dashboard – Business Comparison – Balance Sheet
Power BI comparison across business units for asset and liability account categories.
GL Dashboard – Expense Benchmarking
Power BI expense benchmarking of one entity against the average of other internal entities.
GL Dashboard – Business Comparison – Profit
Power BI profitability comparison across business units.
GL Dashboard – 8 Quarter KPI Trend
Power BI rolling quarterly KPI trend for P&L and Balance Sheet metrics.
GL Dashboard – 8 Quarter Balance Sheet Trend
Power BI rolling quarterly asset and liability trend by category and account.
GL Dashboard – 8 Quarter Profitability Trend
Power BI rolling quarterly profitability trend for Gross Profit, EBITDA, and Net Profit.
GL Dashboard – 48 Month KPI Trend
Power BI monthly trends by P&L KPIs and comparisons for Balance Sheet ratios.
GL Dashboard – 48 Month Balance Sheet Trend
Power BI monthly trends by asset and liability category and account.
GL Dashboard – 8 Quarter Expense Trend
Power BI rolling quarterly expenses trend by category and account.
GL Dashboard – 48 Month Profit Trend
Power BI monthly trends for Gross Profit, EBITDA, and Net Profit margins and amounts.
GL Dashboard – 48 Month Expense Trend
Power BI monthly and annual trends by expense category and account.
GL Dashboard – 8 Quarter Revenue Trend
Power BI rolling quarterly revenue trend by category and account.
GL Dashboard – 36 Month KPI Trend
Power BI monthly trends by P&L KPIs and comparisons for Balance Sheet ratios.
GL Dashboard – 48 Month Revenue Trend
Power BI monthly and annual trends by revenue category and account.
GL Dashboard – 36 Month Revenue Trend
Power BI monthly and annual trends by revenue category and account.
GL Dashboard – 36 Month Profit Trend
Power BI monthly trends for Gross Profit, EBITDA, and Net Profit margins and amounts.
GL Dashboard – 36 Month Expense Trend
Power BI monthly and annual trends by expense category and account.
GL Dashboard – 36 Month Balance Sheet Trend
Power BI monthly trends by asset and liability category and account.
GL Dashboard – 24 Month Balance Sheet Trend
Power BI monthly trends by asset and liability category and account.
GL Dashboard – 24 Month KPI Trend
Power BI monthly trends by P&L KPIs and comparisons for Balance Sheet ratios.
GL Dashboard – 24 Month Profit Trend
Power BI monthly trends for Gross Profit, EBITDA, and Net Profit margins and amounts.
GL Dashboard – 24 Month Revenue Trend
Power BI monthly and annual trends by revenue category and account.
GL Dashboard – 24 Month Expense Trend
Power BI monthly and annual trends by expense category and account.
GL Combo Dashboard – Profitability
Power BI profit and margin analysis with monthly trends and YTD variances.
GL Forecasting Dashboard – KPIs
Automatically creates year-end estimate based on available information. Use sliders to adjust in Power BI.
GL Forecasting Dashboard – Balance Sheet
Automatically creates year-end estimate based on actual YTD. Use sliders to adjust in Power BI.
GL Forecasting Dashboard – Profit Margins
Automatically creates full-year estimate based on actual YTD + budget. Use sliders to adjust in Power BI.
GL Forecasting Dashboard – Expenses
Automatically creates full-year estimate based on actual YTD + budget. Use sliders to adjust in Power BI.
GL Forecasting Dashboard – Revenues
Automatically creates full-year estimate based on actual YTD + budget. Use sliders to adjust in Power BI.
GL Exception Dashboard – Profit Margins
Power BI Top 5 ranked profitabiity variances versus budget and last year.
GL Exception Dashboard – Balance Sheet
Power BI Top 5 ranked Balance Sheet variances versus budget and last year.
GL Exception Dashboard – Expenses
Power BI Top 5 ranked expense variances versus budget and last year.
GL Variance Dashboard – KPIs
Power BI view of financial KPIs with variance of current year versus budget and last year.
GL Exception Dashboard – Revenues
Power BI Top 5 ranked revenue variances versus budget and last year.
GL Variance Dashboard – Balance Sheet
Power BI asset and liability variance analysis with comparison to prior year.
GL Variance Dashboard – Expenses
Power BI expense variance analysis with monthly and YTD figures by account category and account.
GL Variance Dashboard – Profit Margins
Power BI profitability variance analysis for Gross Profit, EBITDA, and Net Profit.
GL Variance Dashboard – Revenues
Power BI revenue variance analysis with monthly and YTD figures by account category and account.
Revenue Analysis – Monthly Actual and Budget Comparison
Graphical, monthly analysis of revenue variances and trends.
P&L Account Analysis by Entity
Trend analysis by Account Category for this year and last year, including actuals and budget information and variances.
Revenue Analysis – Quarterly Actual and Budget Comparison
Graphical, quarterly analysis of revenue variances and trends.
Revenue Analysis – 10 Quarter Rolling by Revenue Type
Graphical, rolling quarterly analysis of revenue variances and trends.
Gross Margin Analysis – Monthly Variances and Trend
Graphical variance and trend analysis of gross margin.
Revenue Analysis – Multi-Year Annual Trend
Graphical, multi-year analysis of revenue variances and trends.
P&L with Interactive Analysis by Row
P&L Report with full graphical dashboard that displays a row based on user selection.
Accounts Receivable Trend by Customer
Accounts Receivable summary of the largest 20 vendors, in graphical and list format.
Accounts Payable Analysis
Power BI dashboard with Accounts Payable detail, including invoice information, payment status, and aging information.
Accounts Payable to General Ledger Reconcilation
Reconciliation between the General Ledger and Accounts Payable subledger, including detail to support reconciliation.
Balance Sheet Lead Schedule
Control report providing a balance sheet with separate tabs for each account category.
Balance Sheet with Sheet per Entity
Balance Sheet reflecting assets, liabilities, and shareholder equity with each entity on a separate sheet.
Trial Balance Report with Sheet Per Entity
GL report that lists account closing balances for this year and last year, with variances and separate sheets per entity.
Exceptions Report
Report that indicates accounts that are unmapped or have been mapped in a manner inconsistent with the ERP.
Accounts Payable Summary Dashboard
Power BI dashboard with a summary of AP aging and a preview of upcoming payments as well as trend analysis.
Trial Balance Basic
GL report that lists account closing balances for initial validation of the data being loaded.