Profit and Loss by Class for 52/53 Tax Year Data Model

Modified on Wed, 29 Jul at 4:02 AM

Model Summary

The QQube 52/53 Tax Year by Class Data Model provides a three-year Profit and Loss statement by class for businesses using week-based accounting periods. It supports 4-4-5, 4-5-4, 5-4-4, and 13 x 4 reporting patterns.

Model Type	Three-year 52/53 Tax Year Profit and Loss by Class
Period Coverage	36 configured periods for 4-4-5, 4-5-4, and 5-4-4; 39 configured periods for 13 x 4
Primary Values	Actuals and Actuals % Sales
Primary Use	Produce Profit and Loss statements by class using week-based tax-year periods

Best Used For

Preparing a traditional Profit and Loss by Class statement for a 52/53 tax year.
Comparing current and previous tax-year periods by class.
Reviewing period and year-to-date actuals by class.
Analyzing Actuals as a percentage of Sales by class.
Building Excel PivotTable, Power Pivot, and Power BI financial reports.

Key Capabilities

Supports 4-4-5, 4-5-4, 5-4-4, and 13 x 4 reporting patterns.
Provides current, previous-year, period, year-to-date, and full-year shortcuts.
Includes up to 39 configured periods across three years.
Includes period and year Actuals % Sales measures.
Adds Class analysis to the prepared financial statement.
Provides prepared DAX measures for Power BI and Excel Power Pivot.

52/53 Tax Year Configuration

The period structure is controlled in the QQube Configuration Tool.

The 4-4-5, 4-5-4, and 5-4-4 patterns use 36 periods across three years. The 13 x 4 pattern uses 39 periods. Period labels and ending dates change with the selected fiscal-year and week configuration.

QQube Configuration Tool settings for the 52/53 Week Tax Year type, ending day, and ending month

QuickBooks Data Limitations

QuickBooks does not provide this 52/53 Tax Year Profit and Loss by Class structure.

QQube prepares the configured week-based periods, class detail, and related comparison measures outside QuickBooks.

Prepared Excel Measures

The Excel and Excel PivotTable model includes 182 prepared measures. These are the same measures included in the 52/53 Tax Year model without Class. The period-specific measures are summarized below instead of listing each configured period separately.

Shortcut Measures (20)

Current Measures	Previous-Year Measures	Antecedent Measures
Current Period Actuals Current Period Actuals % Sales Current Year Actuals Current Year Actuals % Sales Current Year-to-Last Period Actuals Current Year-to-Last Period Actuals % Sales Current YTD Actuals Current YTD Actuals % Sales	Previous Year Period Actuals Previous Year Period Actuals % Sales Previous Year Actuals Previous Year Actuals % Sales Previous Year-to-Last Period Actuals Previous Year-to-Last Period Actuals % Sales Previous YTD Actuals Previous YTD Actuals % Sales Previous Year Last Period Actuals Previous Year Last Period Actuals % Sales	Last Period Actuals Last Period Actuals % Sales

Specific Period Measures (156)

Actuals	Year-to-Date Actuals	Percent of Sales
Periods 1-39 Actuals	Periods 1-39 YTD Actuals	Periods 1-39 Actuals % Sales Periods 1-39 YTD Actuals % Sales

Specific Year Measures (6)

Actuals	Percent of Sales
Years 1-3 Actuals	Years 1-3 Actuals % Sales

Power BI and Excel Power Pivot Measures

The prepared 52/53 Tax Year by Class examples include 191 visible DAX measures in six display folders, plus one measure without a display folder. Hidden measures are not included.

Measure Folder	Visible Measures
Measures Without a Display Folder	1
Antecedent Measures	2
Comparison Measures	8
Current Measures	8
Previous Year Measures	10
Specific Period Measures	156
Specific Year Measures	6

Power BI Class filtering

The measure without a display folder filters the Class slicer by the selected company in Power BI. Excel Power Pivot handles this filtering automatically.

Included Dimensions

Lists

Account (Profit and Loss)

Class

Company

Technical Details

Model Structure	One prepared financial statement table with related Account, Class, and Company dimensions
Financial Model Type	Three-year financial statement by Class
Aggregation	Profit and Loss values by account, class, and configured 52/53 tax-year period
Period Range	36 or 39 configured periods across three years
Excel Availability	Available for Excel and Excel PivotTables
DAX Support	191 visible measures for Power BI and Excel Power Pivot

Expected Result

Customers can immediately build a three-year Profit and Loss by Class statement using configured 52/53 tax-year periods, current and previous-period shortcuts, year-to-date values, and Actuals % Sales.

The prepared financial statement table, Account, Class, and Company dimensions, Excel measures, relationships, and visible DAX measures are already included.