Profit and Loss Detail Data Model

Modified on Wed, 29 Jul at 3:09 AM

Model Summary

The QQube Profit and Loss Detail Data Model provides line-level detail for posting transactions that affect Profit and Loss reporting.

Model Type	Profit and Loss transaction detail
Transaction Coverage	Posting transactions only
Available Fields	More than 1,500
Historical Coverage	All available years with no model date-range limitation
Primary Use	Analyze income and expense activity using actual, budget, forecast, and foreign-currency values

Best Used For

Creating traditional Profit and Loss detail reports.
Filtering income and expense activity by class.
Comparing actual results with budgets and forecasts.
Reviewing summary and detail transaction lines.
Analyzing home and foreign-currency activity.
Reporting by calendar year, fiscal year, or 52/53 tax year.

Key Capabilities

Includes posting and linked transactions.
Places actual, budget, and forecast values side by side.
Includes debit, credit, paid, open, home-currency, and foreign-currency values.
Supports calendar, fiscal, and 52/53 tax-year reporting.
Includes advanced line descriptions not available in QuickBooks.
Covers all available transaction years.

Profit and Loss-Specific Logic

Posting Scope

This model contains posting transaction detail only.

Non-posting transactions are not included.

Budget and Forecast Dates

Budget and forecast dates use the first day of the applicable period.

For example, January and February values use January 1 and February 1 as their transaction dates.

Quantity, Rate, and Amount Fields

The model contains 16 primary Profit and Loss fields. Native fields provide transaction quantities, rates, actual amounts, paid amounts, and open amounts. QQube field extensions add budget and forecast amounts.

Native Fields (10)

Quantity Fields	Rate Fields	Amount Fields
Line Quantity	Line Rate Line Rate Percent Line Exchange Rate	Line Amount (Foreign) Line Amount Line Debit Amount Line Credit Amount Line Paid Amount Line Open Amount

QQube Field Extensions (6)

Amount Fields
Line Budget Amount Line Budget Debit Amount Line Budget Credit Amount Line Forecast Amount Line Forecast Debit Amount Line Forecast Credit Amount

Power BI and Excel Power Pivot Measures

The prepared Profit and Loss Detail examples include 91 visible DAX measures. Hidden measures are not included.

Measure Section	Visible Measures
Measures Without a Display Folder	4
Antecedent Measures	12
Calendar Pattern Measures	21
Comparison Measures	6
Current Measures	24
Previous Year Measures	18
Today Measures	2
Tomorrow Measures	2
Yesterday Measures	2

Power BI includes four company-filter support measures.

These measures restrict Account, Class, Job, and Source Name slicers to values associated with the selected company. Excel Power Pivot handles company filtering automatically.

Included Dimensions

Calendars

52/53 Tax Year	Billed Date	Fiscal Year
Fully Paid Date	Service Date	Transaction Date
Job End Date	Job Projected End Date	Job Start Date
More Info on Calendars

Document

Document Attributes

Line Attributes

Lists

Account (Profit and Loss)	Account (Summary)	Class
Company	Currency	Customer
Customer Rep	Employee	Item
Job	Job Rep	Other Name
Payment Method	Payroll Item	Source Name
Template	Vendor

Technical Details

Model Structure	One prepared FACT table with the required dimensions and relationships already included
Transaction Scope	Posting transactions only
Historical Coverage	All available years with no model date-range limitation
Primary Model Fields	16 fields: 10 Native Fields and 6 QQube Field Extensions
DAX Availability	91 visible measures for Power BI and Excel Power Pivot

Expected Result

Use the prepared Profit and Loss Detail model to analyze income and expense activity, actual results, budgets, forecasts, period comparisons, and foreign-currency values.

The FACT table, dimensions, relationships, Native Fields, QQube Field Extensions, and DAX measures are already included.