Fixed Assets | CLEARIFY

Fixed Assets Analytic

Overview

• 6 Measures including column arrangements not possible in QuickBooks
• Additional Calculated Measures in Power BI
• 6 List, Attribute, Geography and Calendar Dimensions with over 125 available fields
• 3 Out-of-the box metrics using Power BI

Purpose and Usage

Attributes and Fields

AVAILABLE FIELDS	LINKS TO MORE INFORMATION
	Dates and Calendar Dimensions: Asset Purchase Date Asset Sales Date Asset Warranty Expiration Date More Info on Handling Dates
	Document Based Dimensions:  NONE
	List Based Dimensions:  Account (Fixed Asset) Company
	Linked Information:  NONE

Notes

The Cash Position Analytic is a rudimentary attempt at cash flow forecasting, however true forecasting almost always manual input, e.g. capital expenditures, loan payments, exact payroll, etc., - which this analytic is unable to contain.

It strictly lists on hand cash (bank account types), and open A/R and open A/P.  The Open A/R and Open A/P information is controlled by the dates in the available analytic area of the QQube Configuration Tool.

Available Application Shells

• Microsoft Excel
• Microsoft PowerPivot 2013-2016
• Microsoft PowerBI
• Microsoft Access
• SAP Crystal Reports
• Tableau