BlueCollar reporting spans three layers that work off the same data:
BlueCollar reports are largely saved-search driven, but the system doesn't leave value definitions to end users — it enforces consistent calculations (Billed to Date, Over/Under Billings, Earned Revenue, etc.) across all accounts. This is valuable because everyone in the company sees the same numbers computed the same way, rather than each person's saved search producing a slightly different answer.
Two checkboxes on each GL Account record control how it appears in job-cost reporting (see Chart of Accounts for detail):
Account hierarchy rule: when a parent account is budgeted and children are used for transacting, budget either the parent or the children — never both — or job cost will appear doubled (parents sum their children's activity).
Job-cost reporting is built on the intersection of three dimensions:
Divisions are strictly a reporting grouping for Cost Codes — they carry no transactional significance, and the link between a Cost Code and a Division can change anytime without affecting historical data. Divisions drive:
Best practice: number your Division names (e.g., "01 - Site Work", "02 - Concrete") so they sort correctly in reports.
| Metric | Calculation |
|---|---|
| Total Cost | Committed Costs + Actual Costs |
| Committed Costs | Unbilled portion of approved Purchase Orders |
| Actual Costs | Approved posting transactions coded to the project |
| Costs to Complete | Current Estimate − Total Cost |
| Proj Cost Complete | Projected Estimate − Total Cost |
| Over / Under | Projected Estimate − Current Estimate |
For where these surface interactively, see the Project Budget and the WIP Report.
BlueCollar applies consistent number formatting across every UI and export, and numbers follow your NetSuite number-format preference so they read the way your team expects:
| Rule | Format | Example |
|---|---|---|
| Decimal places | Two | 1,000.00 |
| Grouping & decimal separators | Follow your NetSuite number-format preference | 1,000.00 or 1.000,00 |
| Percentages | Two decimals + sign | 10.00% |
| Zero values | Shown explicitly | 0.00 / 0.00% |
Because the grouping and decimal style come from your NetSuite preference, the same figures display correctly whether your account is set up for 1,000.00 or 1.000,00. The same rules apply across all tabs (Labor, Per Diem, Transactions, Inventory), and exports match the clean formatting of the budget export.
Unapproved invoices appear in Billed to Date on the Rev Rec and WIP reports. This is intentional, so the Contract and Billing views tie out to the WIP/Rev Rec views. The Over/Under Billings calculation, however, correctly excludes unapproved invoices. A feature flag lets you control what "Billed to Date" means for your account.
| Application | Action | Level | Grants |
|---|---|---|---|
| WIP_REPORT | WIP_REPORT_VIEW_CONTRACTS | VIEW | View the WIP Report |
| WIP_TOOL | WIP_TOOL_VIEW_CONTRACTS | VIEW | View the revenue recognition view |
| WIP_TOOL | WIP_TOOL_RECOGNIZE_REVENUE | FULL | Recognize revenue |
| PROJECT_REVENUE | PROJECT_REVENUE_VIEW_REVENUE | EDIT | View the project status UI |