Account - Profit and Loss Dimension

Modified on Mon, 24 Jun at 2:19 AM

Overview

The QQube Profit and Loss Account Dimension is a list dimension, and the fields are derived from the Account List in QuickBooks.

The Account Dimension includes pre-configured hierarchy levels for:

Name only
Description only
Name and Description
Number only
Number and Name

It also includes the necessary profit and loss hierarchies to construct a profit and loss statement and is used specifically for profit and loss data models.

QQube Implementation

Profit and Loss Classifications

Usage

Customers	NONE
Operations	NONE
Finance	Profit and Loss - Standard Profit and Loss - Act/Budg/Forecast Profit and Loss - Flexible Period Profit and Loss by Class - Standard Profit and Loss by Class - Act/Budg/Forecast Profit and Loss by Class - Flexible Period Profit and Loss - 52/53 Tax Year Profit and Loss by Class - 52/53 Tax Year Profit and Loss Detail
Auditing	NONE

Notes

The Account - Profit and Loss Sheet Dimension is specifically for Profit and Loss Sheet Summary data models.

PowerPivot and Power BI use a slightly modified balance sheet account dimension with some additional sorting fields.

Accounts have a maximum of 5 levels (0 thru 4 in QQube notation)