Cash Position Data Model

Overview of the QuickBooks Cash Position Data Model

The Cash Position data model 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 data model is unable to contain.

It strictly lists on hand cash (bank account types), and open A/R and open A/P.  The "as of" dates are all controlled in the QQube Configuration Tool.

Features

• Over 1,250 available fields
• 15 Pre-Calculated Measures including 6 not available in QuickBooks
• DAX measures for Power/Pivot and Power BI
• Home and Foreign Currencies

Output Examples

Schema

AVAILABLE FIELDS	DIMENSION DETAIL LINKS
	Dates and Calendar Dimensions: Billed Date Due Date Service Date Ship Date Suggested Discount Date Transaction Date Job End Date Job Projected End Date Job Start Date More Info on Calendars
	Document Based Dimensions:  Document Attributes Line Attributes Geography
	List Based Dimensions:  Account Class Company Currency Customer Customer Rep Customer Message Employee Item Item Sales Tax Code Job Job Rep Other Name Sales Rep Sales Tax Item Ship Method Source Name Template Terms Vendor
	Linked Information:  Cash Position Linked Transactions

Additional DAX Measures for PowerPivot and Power BI