Live value of all open Orders not yet invoiced in Sage Intacct. The forward revenue book.
At a glance
Live dollar value of all Sage Intacct Orders that are open (not yet voided, not yet fully invoiced). The forward-looking revenue book that Operations and Finance use to plan fulfilment, billing capacity, and cash arrival. Every line carries the eight Intacct dimensions, so the same total can be cut by Department, Location, Project or Customer without re-querying.
| What it counts | SUM(SODOCUMENT.TOTAL) for Order Entry documents where STATE IN ('In Progress', 'Pending Approval', 'Pending Fulfilment', 'Partial Fulfilment') and WHENVOID IS NULL. Excludes converted-to-Invoice (those flow to GL revenue, captured by Revenue Booked into GL). Includes draft Orders only if Order Entry workflow has them in approval, otherwise excluded. |
| Tax treatment | Inclusive of estimated tax. Order Entry calculates expected tax at quote-to-Order conversion. The card sums Order Total which includes that estimate. When the Invoice posts, tax moves to the liability account and the revenue line is net; this card sits before that split and so is gross. |
| Shipping | Included (estimated shipping line on the Order). |
| Discounts | Already deducted at line level. |
| Refunds and Credit Memos | Not applicable here, Credit Memos act on Invoices not on open Orders. |
| Cancelled / voided orders | Excluded (Voided state). Orders cancelled before Invoice are excluded; the customer no longer owes anything. |
| Currency | Multi-Entity Console: each Order in entity base currency, then translated to reporting currency at period-average. |
| Entity scope | Card respects dashboard entity filter. |
| Dimensions | Department, Location, Project, Customer (plus Item on the line level) all flow through. Sibling cards expose per-dimension cuts. |
| Time window | Real-time snapshot (RT) |
| Alert trigger | None on the headline; alert lives on Open Orders Blocked. |
| Roles | owner, finance, operations |
Calculation
Calculated automatically from your Sage data. See the At a glance summary above for what the metric tracks and the worked example below for a typical reading.Worked example
A US digital-agency-services firm running Sage Intacct (single entity, USD). Project dimension is populated on every Order. Snapshot 14 Apr 26.| Order state | Count | Dollar value |
|---|---|---|
| In Progress (drafted) | 18 | $124,000 |
| Pending Approval | 9 | $86,000 |
| Pending Fulfilment | 47 | $612,000 |
| Partial Fulfilment | 12 | $148,000 |
| Open Order Value (this card) | 86 | $970,000 |
| Project | Open Order Value | % of total |
|---|---|---|
| PRJ-VEGA-2026 (strategic implementation) | $324,000 | 33.4% |
| PRJ-ATLAS-RETAINER (managed services) | $218,000 | 22.5% |
| PRJ-NEBULA-DISCOVERY | $142,000 | 14.6% |
| PRJ-ORION-ANALYTICS | $98,000 | 10.1% |
| Other / unassigned | $188,000 | 19.4% |
- $970K is the forward revenue book, not yet GL revenue but contractually the customer’s liability once delivery is complete. The agency’s CFO uses this as the leading indicator for the next 30 to 60 days of GL revenue.
- One project (PRJ-VEGA-2026) carries a third of open Orders. Concentration risk: if that project slips, 970K” and the concentration would be invisible.
- Pending Fulfilment is the biggest bucket. Healthy for a delivery-led services firm; the work is sold and the operations team is executing. If this bucket grows faster than Revenue Booked into GL over time, fulfilment is the bottleneck.
- Pending Approval ($86K) is internal friction. Nine Orders sitting in approval workflow longer than 48 hours typically means an approver is offline. The card surfaces this directly via the Open Orders Blocked sibling.
- **Last week’s Open Order Value was 90K growth in 7 days means new bookings are outpacing GL conversion. Combined with stable DSO, this is the picture of a healthy growing book; if DSO were spiking too, the growth would be cash-trapped.
Sibling cards merchants should reference together
| Card | Why pair it with Open Order Value |
|---|---|
| Open Orders Blocked | The subset stuck on inventory, credit, or approval holds. The action list. |
| Revenue Booked into GL | The historical complement. Today’s open Orders are tomorrow’s GL revenue. |
| Order to Invoice Lead Time | How fast Orders convert. Long lead time + high open value = working capital trapped. |
| Order State Breakdown | Per-state count + value. Identifies which transition is the bottleneck. |
| Open Orders Count | Count complement to this dollar figure. |
| Average Order Value | Mix shift indicator: if AOV drops sharply, large customers may be slowing while small ones grow. |
| Revenue Gap vs Commerce | Pending Invoicing in this card is the Pending Invoicing bucket of the gap card. |
Reconciling against the vendor’s own dashboard
Where to look in Sage Intacct:Reports → Order Entry → Sales Order Register Order Entry → List View → Filter: Open states Interactive Custom Report (ICR) against the Order Entry data sourceThe Sales Order Register (filtered to open states) is the closest native equivalent. Sum the Total column. The number should match this card to within a couple of dollars per entity. Why our number may legitimately differ from Sage Intacct’s reports:
| Reason | Direction | Why |
|---|---|---|
| Connector sync lag | Card slightly low | An Order placed in the last 5 to 15 minutes appears in Intacct but not yet in the connector. |
| State filter mismatch | Either | Some merchants exclude In Progress (treating drafts as not committed). Card includes them by default; configurable. |
| Multi-Entity scope | Either | Card defaults to all entities the API user can see; per-entity ICR runs to one entity. |
| Currency translation | Small | Reporting currency vs entity base currency; period-average vs spot rate. |
| Card | Direction | Notes |
|---|---|---|
| shopify.open_orders_value | Commerce-side complement | Orders placed but not yet fulfilled on Shopify; will become Intacct Orders within 5-15 minutes via connector. |
| bigcommerce.open_orders_value | Commerce-side complement | As above for BigCommerce B2B. |
Known limitations / merchant FAQs
What is a healthy Open Order Value relative to monthly revenue? Rule of thumb for B2B services: 0.8 to 1.5 months of revenue. Distributors and product businesses: 0.4 to 0.8 months. SaaS subscription businesses on Intacct Contracts: this card is less meaningful because contracted revenue lives in Deferred Revenue, not Open Orders. Should new Orders or repeat Orders dominate? Mix shift over time matters more than absolute. If new-customer Orders are growing share month over month, the firm is winning logos; if repeat-customer Orders dominate, the firm is in retention mode. Why does this card show drafts (In Progress)?
Default includes drafts because Intacct’s Order Entry treats them as committed forward revenue once Sales has entered them. Configurable per workspace; some Controllers prefer to exclude drafts and start the count at Pending Approval.
Multi-Entity Console behaviour?
Each entity contributes its open Orders, FX-translated to reporting currency. The breakdown view exposes per-entity totals; ideal for regional Operations Managers.
Project dimension drives Project-based services billing. How does this card behave?
Each Order is Project-tagged. Pivoting by Project shows forward revenue by deliverable. Combined with Intacct’s Project Accounting module, this view is the primary forward-revenue dashboard for digital agencies and consultancies on Intacct.
Does the card include Quotes?
No. Quotes are pre-Order in Intacct’s Order Entry workflow. Once converted to an Order they appear here. Quote-to-Order conversion rate is a separate KPI.
How does this compare to NetSuite’s Open SO Value?
Conceptually identical. NetSuite uses Pending Approval / Pending Fulfilment / Pending Billing states; Intacct uses In Progress / Pending Approval / Pending Fulfilment / Partial Fulfilment. The state semantics map cleanly.
My Implementation Partner says I should track this daily. Why?
Because the lag from Order to Invoice is the working-capital problem. If Open Order Value is climbing while Revenue Booked into GL is flat, fulfilment or billing is the bottleneck. Daily visibility catches this within a week; monthly would catch it after 30 days.
How does Intacct REST API freshness affect this card?
The card refreshes every 5 to 15 minutes. For real-time intraday checks (e.g. month-end fulfilment chase), the native Intacct Order Entry list is always live; the card is the trend layer.