Fully-configurable 2-way, integrated Income Statement and Balance Sheet report.

You can try out its functionality here:

The template is a .pbix file and Excel workbook with typical accounting data and metadata to control the presentation of the report.

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

• Two pages to visualise the account mappings for your custom charts of accounts (one for the income statement and one for the balance sheet)

• 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.

• Example Power Query dates-table generation, configurable to any fiscal year (that ends at the end of a month)

• 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, configurable via an external metadata spreadsheet

Suitable for

This template is ideal for someone who wants quickly to create an intuitive, functional income statement and balance sheet based on a:

• Journal entries list

• List of general ledger accounts

• Customer list

• Supplier list

It is expected that someone working with this template will have sufficient Power Query expertise to be able to transform their data to match the tables listed above.

Using the external metadata spreadsheet you can:

• Completely customise / create new charts of accounts

• Create new summary totals and ratios, and determine where they appear in your Chart of Accounts

• Control the presentation of expenses as positive or negative values

• Define which income accounts to include in a % of sales calculation

• Define which balance sheet categories (if any) float between current assets and current liabilities

Example Budget workbooks are also provided, which you can adapt to your own accounts list.