Inforiver

Upcoming webinar on 'Inforiver Charts : The fastest way to deliver stories in Power BI', Aug 29th , Monday, 10.30 AM CST.    Register Now

Create no-code financial reports in Power BI

create-no-code-financial-reports in-power-bi

Track performance with Excel-like reports

Create monthly trackers with Excel-like formatting to track performance

Build formatted financial reports

Create financial statements as they appear in annual reports

Integrate chart elements in financial reports

Leverage 50+ charts and visualizations to create visual financial reports

Deliver context with annotations & footnotes

Provide explanations or supplementary information in your financial reports

Facilitate conversations between stakeholders

Add data-level comments with @ mentions and reply to comments by other users

Deliver financial reports with variances

Create variance reports following IBCS standards in a few clicks

Perform YTD/MTD/QTD comparisons

Leverage IBCS table templates for out-of-the-box, till-date comparisons

Perform what-if simulations

Use a graphical slider to simulate and roll-up or spread-down changes in hierarchies

Display negative values the way you want

Invert signs for expense items and define how to handle aggregations

Highlights

1. Build Excel-like financial & management reports that track performance

Create financial reports with Excel-like formatting in Power BI. Inforiver supports an Excel-like cell editing experience where you can enter data directly in any cell. Notice that the column headers are vertically oriented to deliver tightly packed columns, just as in your Excel financial reports.

build-excel-like-financial-reports-in-powerbi

2. Build formatted financial reports with corporate branding guidelines

Create financial statements supporting brand guidelines (as they appear in annual reports). Here is Nike's 2020 cash flow statement taken from the annual report (on the right) and the same statement reproduced using Inforiver in Power BI (on the left). Inforiver helps you perform a variety of formatting that is harder to implement in Power BI, such as having multiple number formats within a single column​, indenting row headers​, grouping column headers​, formatting cells with currency symbols, borders, and more.

build-formatted-financial-reports-in-powerbi

3. Integrate chart elements in your financial reports

Leverage a variety of in-cell charts within your financial reports to enhance viewer engagement and experience. The report shown below supports account hierarchies along with variances in an expand/collapse-enabled interface. The scale band (in blue) used for variances ensures that even smaller variances are magnified to this scale.

hierarchical-financial-report-chart-elements

4. Deliver context to your financial reports with annotations & footnotes

Provide explanations or supplementary information in your financial reports using data-level notes and footnotes.

financial-reports-with-annotation-footnotes

5. Facilitate data-level conversations in your financial reports

Add data-level comments with @ mentions, reply to comments by other users, and receive instant email notifications. Collaborative commenting is available as part of Inforiver Enterprise. You can also schedule periodic commentary digests to notify users of conversations, tasks, and exceptions.

interactive-financial-report-annotations-in-power-bi

6. Deliver financial reports with variances for executives

Deliver summarized income statements, balance sheets, and statements of cash flows for executives and external stakeholders.

ytd-mtd-qtd-analysis-financial-report

7. Design reports with YTD/MTD/QTD analysis and comparisons

Inforiver provides IBCS table templates (T01 and T02) out-of-the-box for performing YTD/MTD/QTD analysis. As seen below, the categories are listed in the middle. Actuals (AC), Forecast (FC), and AC-FC variance in absolute & % terms are shown for the current month and year-till-date on either side. Performance can be analyzed dynamically by changing the periods in the dropdown.​​

ytd-mtd-qtd-analysis-financial-reports

8. Perform what-if simulations in your financial reports

Perform what-if analysis on the fly using a graphical slider to simulate and roll-up or spread-down changes in hierarchies. ​​Use in-cell editing that supports percentage calculations (e.g., +10%) as well as scaled values (e.g., -35m)​.

what-if-simulations-financial-reports-in-powerbi

9. Display negative values the way you want in financial reports

The data for financial statements may have positive numbers for expense or deduction items, especially when the income and expense values come from different tables. Inverting signs to accommodate the accounts can be achieved by simply selecting the line item and using the ‘Invert Sign’ option. The +/- signs can be displayed in the table or hidden. ​​

You can also configure whether the sign inversion affects only the display or the aggregation as well using the ‘Influence Total’ option.​

display-negative-values-in-financial-report

Featured Videos

formatting-font-style-borders

Cell, row, and column formatting

Apply borders, font, and background colors at cell/row/column levels, show, hide, resize rows, and more.
1-click-number-formattings

Number Formatting

Format numbers, manage decimals, add prefixes and suffixes at the table, measure, or cell levels.
manage-totals-and-sub-totals

Manage totals and subtotals

Configure various row and column subtotal and grand total options, including an option to freeze totals.
invert-signs-for-reporting-power-bi-with-scenarios

Manage accounting signs

Manage signage for financial or general accounts (e.g., Expenses)
excel-like-cell-editing-power-bi-table-matrix-reports

Excel-like cell editing

Enter values or Excel-like formulas simply by double-clicking a cell.
inforiver-smart-analysis

Smart analysis

Perform contribution and variance analysis without using DAX.
insert-calculate-and-sub-totals

Insert calculated and static rows​

Add static rows for manual entry​ or calculated rows using an intuitive Excel-like editor.
insert-formula-measures

Insert calculated columns

Insert visual-level formula calculations; includes pre-set column options.
group-row-columns

Group rows and columns

Create row and column hierarchies at the visual level.
reorder-row-columns

Sorting rows

Drag-and-drop of rows to custom sort your financial/General Ledger (GL) accounts.
reo-column-cell-alignment-power-bi-table-matrix

Indenting & aligning accounts

Add indentations to your financial statements using excel-like options.
notes-and-annotations-power-bi

Add footnotes

Add footnotes and annotations for specific accounts, just like in the annual reports.

Featured Videos

Build a P&L / income statement report in Power BI in less than 5 minutes
Achieve 20x Productivity in P&L/Financial Statement Reporting in Power BI
8 challenges in creating P&L statements in Microsoft Power BI

Get Your FREE ebook

Financial Model

Get Inforiver brochure

Maximize your business potential with Inforiver's paginated reporting, data entry, planning & budgeting capabilities
Download now
Inforiver

Inforiver helps enterprises consolidate planning, reporting & analytics on a single platform (Power BI). The no-code, self-service award-winning platform has been recognized as the industry’s best and is adopted by many Fortune 100 firms.

Inforiver is a product of Lumel, the #1 Power BI AppSource Partner. The firm serves over 3,000 customers worldwide through its portfolio of products offered under the brands Inforiver, EDITable, ValQ, and xViz.

linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram