Cash Position Data Model

Modified on Wed, 29 Jul at 3:17 AM

Model Summary

The QQube Cash Position Data Model combines cash on hand with open Accounts Receivable and open Accounts Payable to show an expected cash position.

Model Type	Cash position and short-term cash expectation analysis
Record Coverage	Cash on hand, open Accounts Receivable, and open Accounts Payable
Date Basis	As-of dates controlled in the QQube Configuration Tool
Available Fields	More than 1,250
Primary Use	Analyze expected cash availability by day, week, or month

Best Used For

Reviewing cash on hand together with expected customer receipts and vendor payments.
Projecting daily, weekly, or monthly cash position.
Analyzing open Accounts Receivable and Accounts Payable by due date.
Comparing home and foreign currency amounts.
Reviewing expected cash movement by customer, vendor, account, class, job, or source.

Key Capabilities

Combines cash on hand, open Accounts Receivable, and open Accounts Payable.
Includes original, applied, and open amounts.
Supports home and foreign currency values.
Includes printed and base quantities where available.
Provides prepared DAX measures for aging, terms, combined amounts, and running totals.

Cash Forecast Scope

This model provides an expected cash position, not a complete cash-flow forecast.

It does not include manual forecast inputs such as capital expenditures, loan payments, or exact payroll amounts.

As-of dates are controlled in the QQube Configuration Tool.

The selected dates determine the open Accounts Receivable and Accounts Payable values included in the model.

Quantity, Rate, and Amount Fields

Native fields come from QuickBooks Cash Position data. QQube field extensions add cash-on-hand, printed-quantity, original, and applied amount values.

Native Fields (9)

Quantity Fields	Rate Fields	Open Amount Fields
Line Quantity	Line Rate Line Rate [Printed] Line Rate Percent Line Exchange Rate	Line A/R Open Amount Line A/R Open Amount (Foreign) Line A/P Open Amount Line A/P Open Amount (Foreign)

QQube Field Extensions (6)

Quantity Fields	Cash and Original Amount Fields	Applied Amount Fields
Line Quantity [Printed]	Line Cash On Hand Amount Line A/R or A/P Original Amount Line A/R or A/P Original Amount (Foreign)	Line A/R or A/P Applied Amount Line A/R or A/P Applied Amount (Foreign)

Power BI and Excel Power Pivot Measures

The prepared Cash Position examples include 15 visible DAX measures in two display folders. Hidden measures are not included.

Measure Folder	Visible Measures
.Base Measures	11
Cash Position Measures	4

Included Dimensions

Calendars

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

Document Attributes

Line Attributes

Geography

Lists

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

Technical Details

Model Structure	One prepared FACT table with related dimensions and relationships already included
Record Scope	Cash on hand for bank account types, open Accounts Receivable, and open Accounts Payable
Date Control	As-of dates are controlled in the QQube Configuration Tool
Currency Support	Home and foreign currency values
DAX Support	15 visible measures for Power BI and Excel Power Pivot

Expected Result

Customers can immediately analyze cash on hand, expected customer receipts, expected vendor payments, and the resulting cash position across selected dates.

The FACT table, dimensions, relationships, fields, QQube extensions, and visible measures are already included.