Present your month-end close to your leadership team

Every report ships connected to an Excel file, the simplest setup when you don't have a data infrastructure. You can swap that file for your own Excel files, and, more importantly, connect the report directly to your sources.

• Power BI Desktop file (.pbix), ready to publish to the Power BI service.
• Two pages: Overview (six KPIs vs. prior year and budget, six ratios, three charts) and Financial Statements (income statement, balance sheet, and cash flow, with budget, actual, variances, prior year, and change, for the month or year to date); Year and Month filters.
• Data loaded by Power Query from the "Data" sheet of an Excel workbook, the anonymized dataset, which you replace with your numbers; a single query points to the file to read.
• 18 expected lines: Domestic revenue, International revenue, Other revenue, Gross profit, Personnel expenses, Marketing, G&A expenses, Other expenses, EBITDA, and Net income; Total assets, Cash, Total liabilities, Debt, and Equity; Operating cash flow, Investing cash flow, and Financing cash flow. An added line shows up in the financial statements matrix.
• Revenue calculated by Power Query (Domestic + International + Other revenue), as is a D&A, interest and taxes line (EBITDA minus net income), so the income statement reads down to net income; gross profit, EBITDA, and net income taken from your accounting, not recalculated.
• Star schema: one fact table (amounts by scenario, month, statement, and line) linked to the actual or budget scenario, the statement lines, the three statements, and a calendar rebuilt at every refresh.
• DAX measures: actual, prior year over the same months, budget and variances, six non-annualized ratios, financial statements matrix.
• Variances and changes in % are relative to the absolute value of the reference, to keep the right sign when the budget or prior year is negative; colors follow each line's favorable direction: an expense under budget shows in green.