Profit and Loss by Job | CLEARIFY

Profit and Loss By Job Analytic (QuickBooks Enterprise Only)

Purpose and Usage

Attributes and Fields

AVAILABLE FIELDS	LINKS TO MORE INFORMATION
	Dates and Calendar Dimensions: Job End Date Job Projected End Date Job Start Date
	Document Based Dimensions:  NONE
	List Based Dimensions:  Account (Profit and Loss) Company Customer Customer Rep Job Job Rep
	Linked Information:  NONE

Notes

Traditional Profit and Loss Standard Analytic for QuickBooks Jobs, with shortcuts for periods e.g. Current Month, Last Month.  36 Periods controlled in the QQube Configuration Tool.

RT stands for "Running Total" so that you can look at jobs that go beyond one year.  However the RT only starts within the 3 year period in the QQube Configuration Tool.

Ability to Filter by Customer (to include the jobs underneath the Customer), or a single job - or multiple jobs.  Filter by Job Status, Job Start or End Date.  Or Organize/filter by Customer Rep or Job Rep.

The Profit and Loss by Job Analytic is summary only, with no drill down detail other than to the account level.

This report is based upon budgets and accounts.  If you use estimates and items, then you would use the Job Cost Details Analytic

Measure Shortcuts were introduced in QQube Version 6.1

Available Application Shells

• Microsoft Excel
• Microsoft PowerPivot 2013-2016
• Microsoft PowerBI
• Microsoft Access
• SAP Crystal Reports
• Tableau