Fully-functioning, configurable Power BI Profit & Loss template with sample dataset (> 300k transactions), plug and play with Sage 50 Accounts data plus ability to configure additional charts of accounts and summary rows and ratios.

Try the demo below:

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

Included features:

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

• Fully-working example of using DAX Dates Measures to provide simple, highly-intuitive selection of dates ranges by the user

• 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

• Configurable Chart of Accounts via an external metadata spreadsheet

Suitable for

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

• Journal entries list (AUDIT_JOURNAL)

• List of general ledger accounts (NOMINAL_LEDGER)

• Customer list (SALES_LEDGER)

• Supplier list (PURCHASE_LEDGER)

• Chart(s) of accounts groupings (CAT_TITLE)

• Chart(s) of accounts account categories (CATEGORY)

We can provide assistance, if required, to provide an automated connection to these tables in Sage 50 Accounts.

Using the external metadata spreadsheet you can:

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

• Create totally new charts of accounts that are not set up in Sage.

• Control the presentation of expenses as positive or negative values

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

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