NetSuite OpenAir PSA: Project Accounting for Professional Services Firms

NetSuite implementation services OpenAir PSA NetSuite for professional services firms use it for a specific reason: the gap between project delivery and financial reporting is where margin disappears. A consulting firm might close an engagement on time and still lose money because unbilled hours aged out, a revenue schedule ran ahead of actual progress, or resource costs were absorbed by the wrong project. OpenAir closes that gap by combining project management, time and expense tracking, resource scheduling, and revenue recognition inside a single system that posts directly to NetSuite’s general ledger. This guide covers how it works in practice, who benefits most, and how it compares to the two main alternatives.  

What Is NetSuite OpenAir PSA and Who Uses It

OpenAir is a cloud-based professional services automation platform that Oracle acquired in 2012 and integrated into the NetSuite product family. It covers the full services delivery lifecycle: project setup, resource scheduling, time and expense capture, billing, and revenue recognition. Because it shares a database with NetSuite ERP, project financials flow directly to the general ledger without an ETL process or manual journal entries. The platform is best suited to firms where people are the primary cost and billable hours are the primary revenue driver. The most common adopters are:

• Management and strategy consulting firms with 50 to 5,000 consultants billing time-and-materials or fixed-fee engagements.
• IT services and systems integrators running multi-phase NetSuite implementation cost India projects with milestone billing.
• Engineering and architecture firms that need percentage-of-completion revenue recognition and project-level WIP tracking.
• Staffing and workforce solutions firms managing large contractor pools across client accounts.
• Marketing and creative agencies billing retainer or project-based arrangements.

OpenAir is less suitable for product companies, manufacturing, or any business where project work is a secondary function rather than the core revenue model. For those scenarios, NetSuite’s native project module is usually adequate. Licensing is per user per month, with separate rates for professional users (full access), collaboration users (limited time entry), and reporting-only users. Pricing is negotiated directly with Oracle NetSuite and varies by contract term and user count.

Project Setup in OpenAir: Phases, Tasks, Resource Roles, and Budgets

Every engagement in OpenAir starts with a project record. The project record holds the client, contract type, billing rules, and the work breakdown structure. A typical project hierarchy has three levels: project, phase, and task. Phases might represent discovery, design, build, and go-live. Tasks sit below phases and define the actual units of work. Each task carries a resource role assignment. A role defines the skill set required and, importantly, the cost rate and bill rate associated with it. When you assign a senior architect to a task, OpenAir pulls that role’s standard cost rate from the resource configuration and calculates the budget impact automatically. This means budget variance reports are available the moment a project is set up, not after actuals start accumulating. Budget tracking works at four levels simultaneously: hours budgeted versus logged, costs budgeted versus incurred, revenue budgeted versus recognised, and billing scheduled versus invoiced. Most firms monitor all four, but the most operationally useful combination is hours versus billing: it tells you whether the project is running over-effort before the invoice cycle closes. Project templates speed up the setup process considerably. A consulting firm with a repeatable service line can build a template with standard phases, tasks, roles, and billing rules, then instantiate it for each new engagement in minutes. Templates also reduce configuration errors because billing rules and revenue schedules are inherited rather than re-entered manually.

Time and Expense Entry: Mobile Capture, Approval Workflows, and Policy Enforcement

Time is entered by consultants via browser or the OpenAir mobile app. The mobile app supports both iOS and Android, includes offline mode for travel scenarios, and allows receipt photos to be attached directly to expense lines. Expense reports are built from individual expense entries and routed through approval workflows defined by the administrator. Approval workflows are configurable. A standard setup routes time sheets to the project manager for approval, then to a finance reviewer if billable hours exceed a threshold or if the timesheet contains unbillable time requiring reclassification. Expense reports can follow a separate path, often routing to a department manager and then to accounts payable. Policy enforcement happens at the point of entry, not after the fact. Administrators configure rules such as maximum daily hours, allowable expense categories per project type, per-diem caps by country, and mileage rates. If a consultant attempts to log a hotel expense against a project flagged as no-travel, OpenAir flags the entry before it reaches the approver. This reduces the back-and-forth that delays billing cycles by one to three days at many firms. A common pain point at firms migrating from spreadsheet-based time tracking is adoption. Consultants accustomed to filling in a Friday-afternoon spreadsheet resist daily time entry. OpenAir addresses this with configurable reminder notifications and timesheet lock policies that prevent submission of timesheets with gaps or implausible entries, which creates an incentive for real-time logging.  

Resource Management: Utilisation Targets, Scheduling, and Bench Visibility

Resource management is where OpenAir separates itself from generic project tools. The platform maintains a resource pool of all billable staff with their roles, skills, cost rates, and availability. Project managers submit resource booking requests specifying the role, required hours per week, and date range. Resource managers review the requests against the pool’s current schedule and confirm or adjust the booking. Utilisation tracking is built around two metrics: scheduled utilisation and actual utilisation. Scheduled utilisation measures booked hours against available capacity before the time period closes. Actual utilisation measures logged billable hours against capacity after timesheets are submitted. The gap between them is the utilisation leakage number, which typically runs 4 to 8 percentage points at firms without a formal resource management process. Bench visibility is one of the most operationally valuable outputs. The resource management dashboard shows every consultant whose booking ends within the next 30 or 60 days and who has no confirmed follow-on assignment. Sales and delivery teams can act on that data before the resource goes fully unassigned. At a 50-person firm billing $250 per hour on average, one consultant sitting unassigned for two weeks costs roughly $20,000 in lost revenue, so the visibility has direct financial impact. OpenAir also supports skill-based searching within the resource pool. If a project requires a certified Salesforce architect with German-language capability, the search filters by both criteria and returns available candidates with their cost rates and current utilisation levels, allowing the resource manager to make a cost-aware booking decision.

Revenue Recognition from Project Milestones and Percentage-of-Completion

Revenue recognition is the area where professional services firms most frequently encounter accounting complexity, and where OpenAir provides the most differentiated value compared to generic project tools. OpenAir supports four primary recognition methods:

• Fixed-fee percentage-of-completion: Revenue is recognised in proportion to hours logged versus total budget, or cost incurred versus total estimated cost. The system calculates the recognised amount each period and posts it to the revenue account, with deferred revenue adjusting accordingly.
• Milestone billing: Revenue is tied to contractual milestones. When a milestone is marked complete and approved, the associated revenue amount is released. Common in IT implementation projects with defined deliverables.
• Time-and-materials: Revenue is recognised as hours are logged and approved. The simplest method, often used by staffing firms and smaller consulting practices.
• Subscription or retainer: Fixed monthly amounts recognised evenly across the contract period, with manual adjustments for scope changes.

Because OpenAir posts recognition directly to NetSuite’s general ledger, the monthly close process for revenue is largely automated. Finance teams review a revenue recognition journal summary rather than manually calculating amounts from spreadsheets. For firms subject to ASC 606 or IFRS 15, this audit trail is also the compliance record, with each recognition transaction linked to the project, contract, and approval that triggered it. Unbilled revenue, the amount earned but not yet invoiced, appears on a dedicated report that feeds directly into the month-end balance sheet process. WIP tracking is maintained at the project and task level, giving finance visibility into which engagements have earned revenue ahead of billing cycles.

OpenAir Reporting: Project Profitability, WIP, Unbilled Revenue, and Utilisation Rate

OpenAir ships with a library of pre-built reports covering the metrics most relevant to professional services operations. The most frequently used are:

• Project profitability report: Revenue recognised minus direct costs (labor at cost rates plus expenses) for a selected period or over the project lifetime. Sortable by project, client, practice, or project manager.
• Utilisation report: Billable hours as a percentage of available hours, broken down by individual, team, or practice group. Compares scheduled versus actual and tracks trend over time.
• WIP and unbilled revenue report: Shows earned but uninvoiced amounts by project, with aging buckets to flag stale unbilled items that may be at risk of write-off.
• Billing forecast: Projects future invoicing based on scheduled resources and milestone dates, useful for cash flow planning 30 to 90 days out.
• Backlog report: Total contracted revenue not yet recognised, giving leadership a forward view of the revenue pipeline in delivery.

Custom reports can be built using OpenAir’s saved search and report builder. For firms needing deeper analytics, the integration with NetSuite’s SuiteAnalytics or a third-party BI tool via the OpenAir SOAP and REST APIs is the standard approach. Most mid-size firms run standard OpenAir reports for operational management and export to a BI tool for executive dashboards.  

NetSuite OpenAir vs Certinia vs Salesforce PSA: Comparison

Three platforms dominate the mid-market professional services automation space. Here is how they compare across the dimensions that matter most to a services firm evaluating a PSA investment:

Criterion	NetSuite OpenAir	Certinia (FinancialForce)	Salesforce PSA (Rootstock / Conga)
ERP integration	Native NetSuite ERP integration, shared GL	Native Salesforce platform, requires separate ERP	Native Salesforce platform, requires separate ERP
CRM integration	Connector to Salesforce CRM; not native	Native Salesforce CRM, opportunity-to-project in one platform	Native Salesforce CRM
Revenue recognition	Strong: ASC 606 / IFRS 15 support, direct GL posting	Strong: native Salesforce revenue cloud integration	Depends on implementation; varies by partner
Resource management	Purpose-built, utilisation dashboards, skill search	Solid, deeply integrated with Salesforce scheduler	Varies; generally lighter than OpenAir or Certinia
Best for	Firms already on NetSuite ERP or planning migration	Firms on Salesforce CRM with complex services-to-CRM workflows	Salesforce-centric firms with lighter PSA needs
Typical implementation time	8–16 weeks	10–20 weeks	6–14 weeks
Pricing model	Per user/month, negotiated with Oracle	Per user/month on Salesforce licensing	Per user/month on Salesforce licensing

The decision usually comes down to the existing ERP and CRM landscape. Firms running NetSuite financials get the most value from OpenAir because project costs and revenue flow directly to the GL without integration overhead. Firms deeply embedded in Salesforce, where the sales team manages pipeline and the delivery team manages projects, often find Certinia’s single-platform approach reduces hand-off friction even if the ERP connection requires additional integration work. For firms evaluating netsuite openair psa professional services fit, the clearest signal is whether your current reporting can answer three questions without a manual spreadsheet build: what is my billable utilisation this month, which projects are running over budget, and how much unbilled revenue is sitting in WIP. If none of those answers are available in under five minutes, OpenAir is worth a serious look.