2-way, integrated Income Statement and Balance Sheet report with pre-transformed sample data.

You can try out its functionality here:

The template is a .pbit file and Excel workbook with pre-transformed data.

Included features:

• Seven-page income statement report, as per the demo above, plus drill-through and transaction detail tooltip

• Four-page advanced balance sheet as per the demo above, with floating categories (configurable), opening, closing, maximum, minimum and average balances, movements and drill through

• Fully-working example of using DAX Dates Measures to provide simple, highly-intuitive selection of dates ranges by the user - set up with Month, YTD and rolling 12-month dates selection.

• Dynamic matrix columns, based on slicer selection (PY or Budget)

• Budget/PY to Actual Bridge visuals

• YTD-plus view with actuals YTD and the remainder as Budget/PY

• Two working Charts of Accounts

Suitable for

This template is ideal for someone who wants to examine a finished working example of an integrated Income Statement and Balance Sheet. All the DAX code is visible and can be modified.
Note: the dataset is already pre-transformed and optimised for this kind of report. If your intention is use this with a typical, untransformed accounting dataset, then the “fully configurable” product is more likely to be a better fit for your needs, as this that template includes all the transformations from a typical accounting dataset.