Accounts Receivable Data Model

Modified on Tue, 28 Jul at 2:21 PM

Model Summary

The QQube Accounts Receivable Data Model is based on the QuickBooks Accounts Receivable report. It analyzes original, applied, and open receivable amounts using the date selected in the QQube Configuration Tool.

Model Type	Accounts receivable and aging analysis
Transaction Coverage	Posting and linked transactions
Available Fields	More than 750
Primary Use	Analyze balances, aging, payment behavior, and customer credit activity

Best Used For

Aging receivables by Transaction Date or Due Date.
Creating traditional 30-60-90 aging reports.
Comparing average days to pay with customer terms.
Reviewing balances by customer, job, class, territory, or sales representative.
Analyzing customer notes and credit standing.

Key Capabilities

Provides Transaction Date and Due Date aging in the same model.
Includes original, applied, and open receivable amounts.
Includes printed and base units of measure.
Includes home and foreign currency values.
Includes related transaction links.

Aging Methods

Use either aging basis in the same report.

The model includes separate aging buckets based on Transaction Date and Due Date.

Power BI and Excel Power Pivot Measures

The prepared Accounts Receivable examples include 31 visible DAX measures. Hidden measures are not included.

Measure Section	Visible Measures
Power BI Company-Filter Measures	3
.Base Measures	22
Average Days Measures	2
Calendar Pattern Measures	4

Power BI company filtering

The Account, Class, and Customer slicers use bridge tables and three support measures to show only values associated with the selected company. Excel Power Pivot handles this filtering automatically.

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
Calendar Overview

Document

Document Attributes

Line Attributes

Geography

Lists

Account	Class	Company
Currency	Customer	Customer Rep
Customer Message	Customer Sales Tax Code	Employee
Item	Item Sales Tax Code	Job
Job Rep	Other Name	Sales Rep
Sales Tax Item	Ship Method	Template
Terms	Vendor

Linked Information

A/R Linked Transactions

Technical Details

Model Structure	One Accounts Receivable FACT table with related dimensions and relationships already included
Date Control	The report date is selected in the QQube Configuration Tool
DAX Availability	Power BI and Excel Power Pivot examples

Expected Result

Open the prepared example and analyze receivables by aging method, customer, job, class, territory, or sales representative.

The FACT table, dimensions, relationships, and measures are already included.