Fixed Assets Data Model

Modified on Wed, 29 Jul at 3:27 AM

Model Summary

The QQube Fixed Assets Data Model analyzes fixed-asset information entered in the QuickBooks Item List. It supports asset cost, depreciation, book value, purchase, sale, and asset-count analysis.

Model Type	Fixed-asset list and value analysis
Record Coverage	Fixed Asset Items from the QuickBooks Item List
Available Fields	More than 95
Primary Use	Review asset details, depreciation, book value, purchases, and sales

Best Used For

Reviewing fixed-asset details.
Analyzing purchase cost and cost basis.
Reviewing accumulated depreciation and year-end book value.
Analyzing asset purchases and sales by date.
Supporting fixed-asset and tax reporting.

Key Capabilities

Uses fixed-asset information maintained in the QuickBooks Item List.
Includes purchase cost, cost basis, sales price, and sales expense values.
Includes year-end accumulated depreciation and book value.
Supports purchase-date, sales-date, and warranty-expiration analysis.
Provides prepared DAX measures for Power BI and Excel Power Pivot.

QuickBooks Data Source

This model does not use the QuickBooks Fixed Asset Manager module.

The model depends on fixed-asset information entered in the QuickBooks Item List.

Asset Value Fields

The primary model fields contain the fixed-asset values available for reporting. The highlighted QQube field extension adds an asset-count value.

Native Fields (6)

Cost Fields	Sale Fields	Depreciation and Book Value Fields
Fixed Asset Purchase Cost Fixed Asset Cost Basis	Fixed Asset Sales Price Fixed Asset Sales Expense	Fixed Asset Year End Accum Depreciation Fixed Asset Year End Book Value

QQube Field Extensions (1)

Asset Count Field
Fixed Asset Count

Power BI and Excel Power Pivot Measures

The prepared Fixed Assets examples include 17 visible DAX measures in three display folders. Hidden measures are not included.

Measure Folder	Visible Measures
.Base Measures	7
Asset Related Measures	1
Calendar Pattern Measures	9

Included Dimensions

Calendars

Asset Purchase Date	Asset Sales Date
Asset Warranty Expiration Date	More Info on Calendars

Lists

Account (Fixed Asset)

Company

Technical Details

Model Structure	One prepared Fixed Assets table with related dimensions and relationships already included
QuickBooks Source	Fixed Asset Items in the QuickBooks Item List
Excluded Source	QuickBooks Fixed Asset Manager module
Primary Values	Asset count, purchase cost, cost basis, sales price, sales expense, accumulated depreciation, and book value
DAX Support	17 visible measures for Power BI and Excel Power Pivot

Expected Result

Customers can immediately analyze fixed-asset costs, depreciation, book value, purchases, sales, and asset counts.

The prepared table, dimensions, relationships, fields, QQube extension, and visible measures are already included.