Account - Balance Sheet Dimension

Modified on Mon, 27 Jul at 10:57 PM

Balance Sheet Account Summary

The QQube Balance Sheet Account Dimension contains QuickBooks accounts and hierarchy fields designed specifically for balance sheet reporting.

Dimension Type

QuickBooks list dimension

Account Represents

A balance sheet account from the QuickBooks Chart of Accounts

QuickBooks Source

Account List

Primary Use

Construct balance sheet classifications and account hierarchies

Included Data Models

Finance: Balance Sheet - Standard Period, Balance Sheet by Class - Standard Period

QuickBooks Source

The fields are derived from the Account List in QuickBooks. The dimension is filtered to balance sheet accounts.

The Balance Sheet Account Dimension includes preconfigured hierarchy levels for:

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

Source Example

QuickBooks Account List source for the Balance Sheet Account Dimension

Balance Sheet Classifications

QQube adds four balance sheet classification groups. These fields organize accounts into the sections needed to construct a balance sheet and accommodate account structures with unequal hierarchy depths.

QQube Balance Sheet Account classifications

Hierarchy and reporting-tool considerations

QuickBooks accounts can contain up to five hierarchy levels. QQube internal notation numbers these levels from 0 through 4.

Power Query, Power Pivot, and Power BI use a modified Balance Sheet Account Dimension with additional sorting fields.

Available Fields

Display Order	Field Name
1	Account Active
2	Account Level
3	Account Has Children
4	Account Balance
5	Account Parent Full Name
6	Account Full Name
7	Account Name
8	Account Number
9	Account Number and Name
10	Account Bank Number
11	Account Description
12	Account Type
13	Account Posting Type
14	Account Special Type
15	Account is Tax Account (CAN)
16	Account Sales Tax Code (CAN)
17	Account Cash Flow Classification
18	Account Tax Line Description
19	Account Trial Balance Sort
20	Account BS - Classification Group A
21	Account BS - Classification Group B
22	Account BS - Classification Group C
23	Account BS - Classification Group D
24	Account (NAME) - Hierarchy Level 1
25	Account (NAME) - Hierarchy Level 2
26	Account (NAME) - Hierarchy Level 3
27	Account (NAME) - Hierarchy Level 4
28	Account (NAME) - Hierarchy Level 5
29	Account (DESCRIPTION) - Hierarchy Level 1
30	Account (DESCRIPTION) - Hierarchy Level 2
31	Account (DESCRIPTION) - Hierarchy Level 3
32	Account (DESCRIPTION) - Hierarchy Level 4
33	Account (DESCRIPTION) - Hierarchy Level 5
34	Account (NAME · DESCRIPTION) - Hierarchy Level 1
35	Account (NAME · DESCRIPTION) - Hierarchy Level 2
36	Account (NAME · DESCRIPTION) - Hierarchy Level 3
37	Account (NAME · DESCRIPTION) - Hierarchy Level 4
38	Account (NAME · DESCRIPTION) - Hierarchy Level 5
39	Account (NUMBER) - Hierarchy Level 1
40	Account (NUMBER) - Hierarchy Level 2
41	Account (NUMBER) - Hierarchy Level 3
42	Account (NUMBER) - Hierarchy Level 4
43	Account (NUMBER) - Hierarchy Level 5
44	Account (NUMBER · NAME) - Hierarchy Level 1
45	Account (NUMBER · NAME) - Hierarchy Level 2
46	Account (NUMBER · NAME) - Hierarchy Level 3
47	Account (NUMBER · NAME) - Hierarchy Level 4
48	Account (NUMBER · NAME) - Hierarchy Level 5