Asking the ledger a question

What comes back with the number

Ask a finance question in plain language. It is computed live off your NetSuite account, and the statement that produced it comes attached — the query, and the rows it returned. The number never arrives on its own.

These questions are scoped to the whole account Frontier is connected to. See connecting your NetSuite account.

The standard reports are fixed, instance-validated queries, not SQL improvised per question.

The nine standard statements

Each was validated against a real NetSuite instance before it shipped.

statement	answers	you supply
A/R aging	which customer invoices are open, how late, in which bucket	an as-of date; optionally a subsidiary
A/P aging	which vendor bills are open, how late, in which bucket	an as-of date; optionally a subsidiary
Income statement	detail-level income, COGS and expense for a period	fiscal year start, period end date; optionally a subsidiary; an accounting book
Balance sheet	per-account balances through a date, balance-sheet accounts only	an as-of date; optionally a subsidiary; an accounting book
Trial balance	per-account debit, credit and net — income-statement YTD plus balance-sheet cumulative	an as-of date, fiscal year start; optionally a subsidiary; an accounting book
Direct cash flow	monthly cash impact split operating / investing / financing, with a bank validation row	start and end dates; optionally a subsidiary; an accounting book
Revenue per customer	monthly revenue per customer, from GL postings to income accounts	start and end dates; optionally a subsidiary; an accounting book
Vendor spend	monthly spend per vendor, from GL postings to expense and COGS accounts	start and end dates; optionally a subsidiary; an accounting book
Script audit	what customization exists in the account — scripts, deployments, errors, run times	nothing; it is role-gated and probes first

The accounting book decides the number

Six of the nine — income statement, balance sheet, trial balance, direct cash flow, revenue per customer, vendor spend — read the accounting-line table, and must be constrained to one accounting book.

On a multi-book account — a primary US-GAAP book plus an IFRS or tax-basis book — an unconstrained query counts every posting once per book. The result looks plausible and is two or three times wrong.

Each of the six defaults to the primary book, book 1, so the default is safe. If your account's primary book is not book 1, say which book you mean.

A/R aging and A/P aging read transaction headers only and take no book. The script audit touches no financial data.

Scope, dates and signs

• Subsidiary scope is optional on every report. Left off, the report is consolidated.
• Dates are NetSuite's display format, MM/DD/YYYY.
• Revenue is credit-normal and flipped positive for display. Expense and COGS are debit-normal.

Questions the nine do not cover

For a question no standard statement answers, the agent writes a query. It writes it against documented references for NetSuite's query dialect and its per-table schema, so a generated query names columns that exist.

That query is generated, not pre-validated — it has not been run against a real instance and checked the way the nine were. This is the path where the attached statement matters most. Read the query and the rows before you use the figure.

Check it before you rely on it

Frontier's output can be wrong. It can be incomplete, out of date, or confidently mistaken.

It is not accounting, tax, audit, legal, or financial advice, and it is not a substitute for your own review or for a qualified professional. You remain responsible for what you file, post, publish, or decide.

Check it before you rely on it, and always before it affects your books, your close, or a filing. Where the answer shows you the query and the underlying rows, that is what they are for. The terms say this in full.