QuickBooks Subject Areas and QQube Data Models

Customers and Receivables

• Sales Details including Sales Orders and Estimates
• Open Sales Orders
• Accounts Receivable

Examples

 

Jobs and Time

• Job Cost Details
• Time Tracking
• Vehicle Mileage
• Profit and Loss (aggregated by day)
• Profit and Loss by Class (aggregated by day)

Time Tracking and Vehcle Mileage are also contained with the Job Cost Details data model.

Examples

 

Inventory

• Inventory Management
• Bill of Materials

Includes quantities on-hand, valuation, open SO & PO, sales/consumption history, lot numbers, serial numbers, sites, and more.

Examples

Vendors and Payables

• Purchase Details including Purchase Orders
• Open Purchase Orders
• Accounts Payable

Examples

 

Financial Statements

• Standard Monthly Period Balance Sheet
• Standard Monthly Period Profit and Loss
• Standard Monthly Period Statement of Cash Flows
• Advanced Monthly Period Profit and Loss
• Flexible Custom Period Balance Sheet
• Flexible Custom Period Profit and Loss with EBITDA

Examples

 

Financial Statements by Class

• Standard Monthly Period Balance Sheet
• Standard Monthly Period Profit and Loss
• Standard Monthly Period Statement of Cash Flows
• Advanced Monthly Period Profit and Loss
• Flexible Custom Period Profit and Loss with EBITDA

Standard and Advanced = 36 periods.
Flexible Custom Period = 10 years of daily aggregation.
Advanced includes Actual/Budget/Forecast.

Examples

Financials for 52/53 Tax Year

• Profit and Loss for 52/53 Tax Year
• Profit and Loss by Class for 52/53 Tax Year

Choice of Tax Year Weeks: 4-4-5, 4-5-4, 5-4-4, 13x4

Examples

 

General Ledger and Accountant

• Standard Trial Balance
• Trial Balance Activity
• Trial Balance Activity by Class
• General Ledger Detail
• Profit and Loss Detail
• Cash Position
• Fixed Assets

Examples

 

Payroll and Human Resources

• Payroll Details

Posting and Non-Posting details for payroll registers, liability reconciliation, and vacation and sick status.

Examples