Accounts Receivable Data Model

Overview of the QuickBooks Accounts Receivable Data Model

This data model is based upon the actual Accounts Receivable report in QuickBooks, and the date is controlled in the QQube Configuration Tool.

You have the ability to due aging by Transaction Date AND Due Date in the same report.

Features

• Over 750 available fields
• 22 Measures including 9 not available in any QuickBooks Report
• 35 Additional DAX measures for Power/Pivot and Power BI
• Posting and Linked Transactions
• Printed and Base U of M Quantities
• Home and Foreign Currencies
• Simultaneous Due Date and Transaction Date buckets

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

Additional DAX Measures for PowerPivot and Power BI