← All postsStatistics

Beyond the Dollars: How Operating Statistics Turn Oracle NetSuite and Sage Intacct Into a Metrics Engine

Shogo Team·August 8, 2026·6 min read
Beyond the Dollars: How Operating Statistics Turn Oracle NetSuite and Sage Intacct Into a Metrics Engine

Your financials tell you how much you made — not your average check, your occupancy, or your average daily rate. Those need the counts, not just the dollars.

Companion to how Shogo segments your sales. There we split the dollars by revenue center, daypart, and channel; here we post the counts behind them.
(cross-link to companion post)

A P&L is all numerators and no denominators. Restaurant revenue is up 8%: more guests, or a bigger check? Room revenue is up 8%: more rooms sold, or a higher rate? Same top line, different playbooks, and dollars alone can't tell you which. Shogo posts the counts behind the dollars — checks and guests from the POS, room counts from the PMS, plus any metric you define — as a statistical journal entry alongside your sales.

The numbers behind your numbers

Every metric that matters in an operating review is a ratio, and every ratio needs a count in the denominator. Average check is sales divided by checks. Sales per guest is sales divided by guests. Comps as a percent of sales, guests per check, table turns: none of them exist without the counts. When the counts live in a spreadsheet and the dollars live in the general ledger, someone rebuilds the bridge by hand every month. When both live in the same place, the ratios are just report columns. That "same place" is a statistical account — a non-financial ledger account that holds a count, like guests or rooms, instead of a dollar amount.

Take a $16,300 day. It might be 370 checks at a $44 average, or it could be 550 checks at closer to $30: the same top line, a completely different restaurant, with different labor, prep, and staffing. The dollars land in the same place; only the counts tell you which one you're running.

What is a statistical journal entry?

A statistical journal entry is a general-ledger entry that records operational counts and metrics — guests, checks, rooms occupied — instead of dollars. Every day, right beside your sales journal entry, Shogo posts one: the same date and the same breakouts, just those counts and calculated metrics. A restaurant might break it out by daypart:

Statistic Breakfast Lunch Dinner Day
Counts
Checks 90 160 120 370
Guests 210 300 360 870
Calculated
Average check $30.00 $40.00 $60.00 $44.05
Guests per check 2.3 1.9 3.0 2.4

Counts and calculated metrics, broken out by daypart: the same segmentation Shogo applies to your sales, one row per statistic and breakout.

A hotel runs on the same statistical accounts with different counts, the raw numbers straight from its PMS:

Statistic Count
Rooms available 150
Rooms occupied 120
Room vacancies 30

Room counts posted straight from the PMS. Occupancy comes straight from these; average daily rate and revenue per available room combine them with the room revenue on the same day's sales entry, computed by your GL or by Shogo.

Let the GL do the math — or let Shogo

There are two ways to land a metric like average check in your books, and Shogo supports both:

Post the inputs, let the GL calculate. Shogo sends the sales and the counts — order count, check count, guest count — as statistical accounts, and Oracle NetSuite or Sage Intacct computes the ratio in a KPI or report. The math lives in the GL, so it aggregates correctly across dayparts, locations, and periods.

Or post the finished number. Shogo can do the math itself and post the pre-calculated statistic directly, which is useful when you'd rather the metric land ready to read, or when it's easier to define once in Shogo than to rebuild in every report.

You just saw both: the restaurant entry carries a pre-calculated average check, while the hotel entry carries raw room counts the GL turns into average daily rate, revenue per available room, and occupancy.

The metrics themselves are yours to define. Shogo's formula builder composes a custom statistic from built-in variables like order count, guest count, rooms occupied, and refunds, then posts it every day, segmented like everything else. Some are the ratios everyone tracks; others are ones no report ships with:

Most operators mix the two: raw counts for the ratios their GL handles cleanly, pre-calculated stats for everything else.

What you gain when the stats live in Oracle NetSuite and Sage Intacct

Because the statistics post to NetSuite statistical accounts and Sage Intacct statistical accounts — carrying the same breakouts as your sales — your KPIs become native report columns and dashboard tiles instead of a monthly spreadsheet. A few of the reads that come essentially for free once the counts are in:

  • Average check & average daily rate · revenue per check, rate per room — The per-unit revenue number for each business, trended and sliced the same way you slice sales, not recomputed by hand each period.

  • Sales per guest & revenue per available room · yield per guest, per available room — The truest read on whether you're earning more from what you already have, independent of raw traffic.

  • Occupancy & table turns · how full, how fast — Utilization of your most constrained asset, seats or rooms, visible daily and by segment, not just at month-end.

  • Per-property benchmarking · one report, every unit — Average check, average daily rate, occupancy, and guests, compared across the whole portfolio in a single report, because the stats post consistently everywhere.

How Shogo does it

Shogo captures the counts as it normalizes each day's sales, calculates the metrics you've defined, and posts a statistical journal entry alongside the sales entry, automatically every morning, segmented to match. It also handles the part of statistical setup that quietly breaks reports: counts like checks and guests are set to accumulate across the period, while a capacity figure like rooms available is posted as a period-end level rather than summed, so your quarter-to-date occupancy and averages hold up instead of turning into nonsense. Before anything reaches your accounting system, a preview shows the exact statistical entry, one row per statistic and breakout, so you can confirm it's complete and mapped. You set it up once; after that, it just runs.

Counts and metrics, posted the same way as your dollars: segmented like your sales and reconciled to the same day's totals, so your operating numbers and your financials always agree.

Frequently asked questions

What are statistical accounts?

Statistical accounts are non-financial accounts in your general ledger that hold counts and metrics — guests, checks, rooms, units — instead of dollars. Because they live alongside your financial accounts, you can build ratio KPIs like average check or sales per guest directly in your accounting reports and dashboards.

What statistics can Shogo post to Oracle NetSuite and Sage Intacct?

Shogo posts counts such as order count, check count, and guest count — or, for hotels, rooms occupied, rooms available, and room vacancies — plus calculated metrics like average check, average daily rate, occupancy, and revenue per available room. Depending on the metric, Shogo can post the raw counts for Oracle NetSuite or Sage Intacct to do the math, or calculate the value itself and post the finished statistic. You can also define your own custom statistics, all posted as a statistical journal entry alongside your daily sales.

Can I create my own metrics?

Yes. Shogo's stat builder lets you compose custom statistics from built-in variables — order count, guest count, average table-turn minutes, refunds, and more — with a simple formula. Once defined, a custom stat posts automatically every day, segmented like the rest of your data.

Are the statistics segmented like my sales?

Yes. The statistical journal entry carries the same breakouts as your sales — daypart, revenue center, channel, and more — with one row per statistic and breakout combination. So you can read average check by daypart or guests by revenue center natively in your GL.

Which accounting systems support statistical accounts?

Oracle NetSuite and Sage Intacct both provide statistical accounts and statistical journals, which is why they're the focus here. Most other general ledgers, including QuickBooks and Xero, don't offer statistical accounts, so posting operating metrics this way is specific to Oracle NetSuite and Sage Intacct.