Profit and Loss Class Advanced (Standard Period) Data Model

Modified on Wed, 29 Jul at 5:25 AM

Model Summary

The QQube Profit and Loss Actual/Budget/Forecast by Class Data Model combines Actual, Budget, and Forecast values in one traditional Profit and Loss by Class statement. It is a three-year, Excel-based financial model with 36 monthly periods.

Model Type	Three-year Profit and Loss Actual/Budget/Forecast by Class
Period Coverage	36 monthly periods controlled in the QQube Configuration Tool
Primary Values	Actual, Budget, Forecast, and related % Sales values
QuickBooks Availability	QuickBooks Enterprise
Application Availability	Excel with the QQube Add-In
Primary Use	Compare Actual, Budget, and Forecast values in one Profit and Loss by Class report

Best Used For

Comparing Actual, Budget, and Forecast values side by side.
Building a traditional three-year Profit and Loss by Class statement in Excel.
Reviewing monthly, quarterly, yearly, and year-to-date results.
Analyzing Actual, Budget, and Forecast values as a percentage of Sales by class.
Using prepared shortcuts such as Current Month, Last Month, and Previous Year Month by class.

Key Capabilities

Combines Actual, Budget, and Forecast values in one report by class.
Includes 36 monthly periods across three years.
Provides monthly, year-to-date, quarterly, and yearly measures.
Includes % Sales measures for Actual, Budget, and Forecast values.
Includes 606 prepared Excel measures.
Provides special Microsoft Access views for the wide financial structure.
Includes the Excel Add-In Presentation Clean-Up Tool.
Supports classes side by side or in a hierarchy.

Three-Year Period Logic

The 36 monthly periods are controlled in the QQube Configuration Tool.

The period labels change with the configured financial reporting range. The prepared model retains the same measure structure for Periods 01 through 36.

QuickBooks and Application Availability

This report is available only for QuickBooks Enterprise users.

QuickBooks requires separate reports for Actual versus Budget and Actual versus Forecast. QQube combines all three values in one prepared Excel model by class.

This model is designed for Excel.

For daily aggregation, dynamic reporting periods, and Power BI or Excel Power Pivot, use the Profit and Loss by Class Flexible Period Data Model.

Prepared Excel Measures

The model includes 606 prepared measures. Repeating monthly, quarterly, and yearly measures are summarized below instead of listing every period separately.

Shortcut Measures (84)

Current Measures	Previous and Antecedent Measures
Current Month Actuals, Budget, and Forecast Current Quarter Actuals, Budget, and Forecast Current Year Actuals, Budget, and Forecast Current Year-to-Last Month Actuals, Budget, and Forecast Current YTD Actuals, Budget, and Forecast Each value includes a corresponding % Sales measure	Last Month Actuals, Budget, and Forecast Last Quarter Actuals, Budget, and Forecast Previous Year Month Actuals, Budget, and Forecast Previous Year Quarter Actuals, Budget, and Forecast Previous Year Actuals, Budget, and Forecast Previous Year-to-Last Month Actuals, Budget, and Forecast Previous YTD Actuals, Budget, and Forecast Previous Year Last Month Actuals, Budget, and Forecast Previous Year Last Quarter Actuals, Actuals % Sales, Budget, Budget % Sales, Forecast, and Forecast % Sales Each value includes a corresponding % Sales measure

Current Measures

Previous and Antecedent Measures

Current Month Actuals, Budget, and Forecast
Current Quarter Actuals, Budget, and Forecast
Current Year Actuals, Budget, and Forecast
Current Year-to-Last Month Actuals, Budget, and Forecast
Current YTD Actuals, Budget, and Forecast
Each value includes a corresponding % Sales measure

Last Month Actuals, Budget, and Forecast
Last Quarter Actuals, Budget, and Forecast
Previous Year Month Actuals, Budget, and Forecast
Previous Year Quarter Actuals, Budget, and Forecast
Previous Year Actuals, Budget, and Forecast
Previous Year-to-Last Month Actuals, Budget, and Forecast
Previous YTD Actuals, Budget, and Forecast
Previous Year Last Month Actuals, Budget, and Forecast
Previous Year Last Quarter Actuals, Actuals % Sales, Budget, Budget % Sales, Forecast, and Forecast % Sales
Each value includes a corresponding % Sales measure

Specific Monthly Period Measures (216)

Actual	Budget	Forecast
Periods 01-36 Actuals Periods 01-36 Actuals % Sales	Periods 01-36 Budget Periods 01-36 Budget % Sales	Periods 01-36 Forecast Periods 01-36 Forecast % Sales

Specific Year-to-Date Measures (216)

Actual	Budget	Forecast
Periods 01-36 YTD Actuals Periods 01-36 YTD Actuals % Sales	Periods 01-36 YTD Budget Periods 01-36 YTD Budget % Sales	Periods 01-36 YTD Forecast Periods 01-36 YTD Forecast % Sales

Specific Quarter Measures (72)

Actual	Budget	Forecast
Quarters 1-4 for Years 1-3 Actuals Quarters 1-4 for Years 1-3 Actuals % Sales	Quarters 1-4 for Years 1-3 Budget Quarters 1-4 for Years 1-3 Budget % Sales	Quarters 1-4 for Years 1-3 Forecast Quarters 1-4 for Years 1-3 Forecast % Sales

Specific Year Measures (18)

Actual	Budget	Forecast
Years 1-3 Actuals Years 1-3 Actuals % Sales	Years 1-3 Budget Years 1-3 Budget % Sales	Years 1-3 Forecast Years 1-3 Forecast % Sales

Included Dimensions

Lists

Account (Profit and Loss)

Class

Company

Technical Details

Model Structure	One prepared Profit and Loss Actual/Budget/Forecast by Class table with related Account, Class, and Company dimensions
Financial Model Type	Three-year advanced financial statement
Aggregation	Monthly
Period Range	36 configured monthly periods
QuickBooks Edition	QuickBooks Enterprise
Application Availability	Excel with the QQube Add-In
Prepared Excel Measures	606
DAX Support	None
Power BI Alternative	Profit and Loss Flexible Period Data Model
Microsoft Access	Special views are included for the wide financial structure

Expected Result

Customers can immediately compare Actual, Budget, and Forecast values across monthly, year-to-date, quarterly, and yearly periods in one Excel Profit and Loss by Class report.

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