QQube Schema for QuickBooks Desktop | CLEARIFY

QQube™Analytic Schemas for QuickBooks Desktop

QQube contains 36 QuickBooks Analytic areas and over 7,000 available fields with each area engineered according to standard data warehousing principles: one FACT table, and multiple DIMENSION tables.

QQube eliminates the need to deal with tables, relationships, reverse engineering, or connection strings. Yet there is total flexibility for advanced users.

Use this section for either an overview of the layout for each analytic, and to assess the proper analytic for your project or report..

Advanced users, please refer to this document for using DSN's to connecting externally to the QQube data structures.

	QUICKBOOKS ANALYTIC AREA	ANALYTIC
	CUSTOMERS AND RECEIVABLES	Sales Open Sales Orders Accounts Receivable
	JOBS, TIME, AND MILEAGE	Job Cost Details Time Tracking Vehicle Mileage Profit and Loss by Job Profit and Loss by Job by Class
	INVENTORY	Inventory Management Bill of Materials (BOM)
	VENDORS AND PAYABLES	Purchases Open Purchase Orders Accounts Payable
	PAYROLL AND HUMAN RESOURCES	Payroll
	FINANCIAL STATEMENTS	Balance Sheet - Standard Profit and Loss - Standard Profit and Loss - Act/Budg/Forecast Profit and Loss - Freestyle Trial Balance - Current Trial Balance - All Dates Trial Balance - Activity Statement of Cash Flows
	FINANCIAL STATEMENTS BY CLASS	Balance Sheet by Class - Standard Profit and Loss by Class - Standard Profit and Loss by Class - Act/Budg/Forecast Profit and Loss by Class - Freestyle Trial Balance by Class - Activity Statement of Cash Flows by Class
	FINANCIALS FOR 52/53 TAX YEAR	Profit and Loss - 52/53 Tax Year Profit and Loss by Class - 52/53 Tax Year
	GENERAL LEDGER AND ACCOUNTANT	General Ledger Detail Profit and Loss Detail Fixed Assets Cash Position
	AUDITING	Audit Trail Sales Tax (USA)