QQube Cash Position for QuickBooks | CLEARIFY

QQube for QuickBooks Cash Position

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 Handling Dates
	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 Template Terms Vendor
	Linked Information:  Cash Position Linked Transactions

Notes

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.