Numeric Reporting: 8 Reports Your Accounting Team Needs

8 Reports Your Team Can Build Today 

Below are eight of the most common reports accounting teams build in Numeric, organized by use case. Each includes the reporting logic needed to build it and the business context for when to use it.

💼 Management & FP&A Reporting

Expense by Department + Vendor

How It Works:

This report groups all expense transactions first by department (e.g., G&A, R&D, S&M), then breaks down spend within each department by vendor. 

How to Build:

1. Filter to expense accounts only (OPEX + COGS account types)
2. Pivot by Department first, then add Vendor as a secondary pivot
3. Configure for your desired comparison period (typically MoM or QoQ)
4. Optional: Add variance columns to track changes period-over-period

Why It’s Useful:

This report is essential for understanding departmental burn rates and vendor concentration.

Finance teams use it to answer questions like "How much is R&D spending on AWS?" or "Which vendors are we using across multiple departments?" It's particularly valuable during budget reviews, vendor negotiations, and when leadership asks "Where is our money going?"

The team at STASH finds this report useful for tracking important expenses such as their spend on AWS, etc.

Adjusted EBITDA

How It Works:

This report builds a bridge from Net Income to EBITDA to Adjusted EBITDA by creating calculated metric rows that add back non-operating expenses. The report structure shows your standard income statement flowing to Net Income, then systematically adds back interest, taxes, depreciation, and amortization to arrive at EBITDA. From there, you add back one-time or non-recurring expenses (like legal fees, restructuring costs, or stock-based compensation) to calculate Adjusted EBITDA.

How to Build:

1. Start with your standard I/S structure flowing through to Net Income
2. Create metric rows to add back D&A, taxes, and interest to calculate EBITDA
3. Create groups for adjustment categories (Legal Expenses, One-time Costs, Stock Comp, etc.)
4. Build final metric row for Adjusted EBITDA that sums EBITDA + all adjustments
5. Configure comparison periods to show the bridge calculation across time

Why It's Useful:

Adjusted EBITDA is the metric investors and boards use to evaluate operating performance by stripping out non-cash expenses and one-time costs. This report is critical for board presentations, investor updates, and debt covenant compliance where lenders often tie requirements to Adjusted EBITDA thresholds.

The beauty of building this in Numeric is the flexibility of custom groupings and in-report reconciliation - you can clearly show the walk from Net Income through each adjustment layer. Instead of maintaining complex Excel reconciliations that break when your chart of accounts changes, this report automatically recalculates as transactions flow through. 

Income Statement with Functional Expense Disaggregation

How It Works:

This report displays your standard income statement structure (Revenue → COGS → Gross Profit → OPEX → Net Income) but breaks out operating expenses by functional expenses like G&A, R&D, and S&M. Some teams include a "No Department" line item that flags any transactions missing department coding.

Note: If you set up this structure and see “No Department” appear in a report even once, then create a Monitor that flags the relevant data issue. Doing so will ensure you catch data issues before they appear in a report. 

How to Build:

1. Start with your standard income statement account structure
2. Add department as a grouping specifically for the OPEX section
3. Configure your department groupings to match your reporting structure (typically G&A, R&D, S&M)
4. Add a condition to capture and display transactions where department is empty
5. Set formatting to show both current period and prior period columns for variance analysis

Why It’s Useful:

Leadership and board members expect to see expenses broken out by functional area to understand the cost structure of the business - how much you're investing in product development versus sales versus keeping the lights on.

The "No Department" check serves as a data quality control, ensuring you catch miscoded transactions before they distort departmental metrics. This report is typically used in monthly board decks, budget vs. actual reviews, and when calculating unit economics like CAC or LTV where you need clean departmental expense allocation.

Income Statement with Natural Expense Disaggregation

How It Works:

This report displays your income statement with operating expenses broken out by natural expense classification - the type of expense (salaries and wages, rent, software, professional fees, insurance, depreciation, etc.) rather than functional areas. Unlike functional expenses which are typically tagged at the transaction level in fields like "Department," natural expenses require grouping entire GL accounts or specific slices of accounts based on what the expense actually represents.

How to Build:

1. Start with your standard income statement account structure
2. Create custom groups for each natural expense category (Compensation & Benefits, Occupancy Costs, Professional Services, Software & Technology, etc.)
3. Use dynamic filters within each group to capture relevant GL accounts - for example, the Compensation group might include accounts 6000-6999, or use "Account Name contains 'Salary'" logic
4. Apply additional filters if needed to slice accounts by Class, Department, or other dimensions when a single GL contains mixed natural expense types
5. Reorder groups to present natural expenses in a logical flow for your audience

Why It’s Useful:

Natural expense classification is increasingly required for financial statement disclosures, and is becoming more common in investor reporting where stakeholders want to understand the composition of expenses rather than just departmental allocation.

The challenge with natural expenses is that they don't map cleanly to standard ERP fields - your "Salaries" might span 20 different GL accounts across multiple departments. 

Numeric's grouping capabilities let you define the logic once (using dynamic rules like account code ranges or account name patterns) and the report automatically includes new accounts that match your criteria. This eliminates the monthly Excel gymnastics of manually categorizing accounts and ensures your natural expense disclosures stay accurate as your chart of accounts evolves.

For companies that need both functional AND natural expense views, you can build complementary reports - one showing the traditional departmental breakout, another showing natural classification.

📋 Balance Sheet Reporting

Detailed Grouped Balance Sheet

How It Works:

This report takes your chart of accounts and organizes balance sheet line items into custom groupings that go beyond the standard asset/liability/equity structure. You might group multiple prepaid accounts under "Prepaid Expenses," consolidate various accrual accounts into "Accrued Liabilities," or create specific groupings for different liability types (current vs. non-current, operating vs. financing leases, etc.).

How to Build:

1. Start with all balance sheet account types (Assets, Liabilities, Equity)
2. Create custom groupings that match your financial statement presentation
3. Organize accounts into meaningful categories (e.g., "Current Assets" → Cash & Cash Equivalents, Accounts Receivable, Prepaid Expenses)
4. Set up the standard balance sheet equation flow: Assets → Liabilities → Equity
5. Add prior period columns for balance change analysis

Why It's Useful:

Standard balance sheets in NetSuite often show too much detail (every single GL account) or not enough structure (minimal groupings). This report lets you present the balance sheet exactly how your board, investors, or auditors expect to see it.

It's particularly valuable for companies with complex balance sheets - multiple entities, various prepaid/accrual accounts, or detailed fixed asset tracking. You can create the clean, professional balance sheet that goes in your board deck while maintaining the ability to drill into the underlying detail when needed. This is also the foundation for creating balance sheet footnotes and disclosures.

Mapped Disclosures for Footnotes

How It Works:

This report groups specific balance sheet accounts into disclosure categories required for financial statement footnotes. For example, you might map several different accrual accounts (accrued payroll, accrued bonuses, accrued vacation, accrued taxes) into a single "Accrued Liabilities" disclosure line. The report shows both the individual accounts and their rolled-up disclosure presentation.

How to Build:

1. Identify which accounts need to be disclosed together in your financial statement footnotes
2. Create groupings that match your footnote disclosure requirements (e.g., "Property & Equipment, net" might include multiple fixed asset accounts and accumulated depreciation)
3. Filter to the specific balance sheet sections relevant for footnotes
4. Configure to show both the detail (individual accounts) and summary (disclosure grouping)
5. Set as period-end report (typically month-end or quarter-end for audit purposes)

Why It's Useful:

Auditors and investors require specific disclosures about balance sheet composition - you can't just show "Accrued Liabilities" as one number, you need to break down what's in there. This report creates the bridge between your detailed GL and your disclosure requirements.

During audit season, this saves hours of manually pulling account details and grouping them into footnote schedules. It's also critical for companies preparing for IPO or raising capital, where financial statement footnotes need to follow GAAP presentation standards. Instead of rebuilding these disclosures every quarter in Excel, you have a repeatable report that automatically pulls the right accounts into the right disclosure categories.

Classified Balance Sheet Views for Investor or Board Reporting

How It Works:

This report presents your balance sheet with strategic reclassifications that differ from your statutory books. You might reclassify certain assets or liabilities to better align with how investors or your board thinks about the business, combine immaterial line items, or restructure the presentation to highlight key metrics like working capital or net debt.

How to Build:

1. Start with your standard balance sheet structure
2. Create custom groupings that reflect investor/board preferences (e.g., "Cash & Marketable Securities" combining multiple accounts, "Net Working Capital" showing current assets minus current liabilities)
3. Apply reclassifications - for example, moving debt issuance costs, reclassifying certain assets from non-current to current, or netting related accounts
4. Create metric rows for calculated values (Total Debt, Net Cash Position, Current Ratio components)
5. Format to emphasize key metrics your audience cares about

Why It's Useful:

Your GAAP balance sheet and your investor-friendly balance sheet often aren't the same thing. Investors care about cash position, total debt, and working capital trends - they don't need to see every individual prepaid account.

This report lets you maintain GAAP compliance in your books while presenting a cleaner, more strategic view to external stakeholders. It's particularly valuable for board presentations where you want to focus the conversation on high-level financial health rather than accounting minutiae.

You can also use this to create "management balance sheets" that align with how your CFO talks about the business, even if the underlying books follow standard accounting categories.

🧾 Audit & Legal Support Reports

Account Tie-Out & Reconciliation Support Reports

How It Works: This report groups transaction detail for accounts that require tie-outs or sub-ledger reconciliation - commonly deferred revenue, accrued liabilities, prepaid expenses, or any balance sheet account where you need to validate the GL balance against supporting schedules. It shows both summary balances and the underlying transaction composition.

How to Build:

1. Select the account(s) requiring tie-out (e.g., Deferred Revenue, Accrued Expenses)
2. Group by relevant dimensions - might be by customer for deferred revenue, by vendor for accruals, or by project/contract
3. Configure to show beginning balance, period activity (debits/credits), and ending balance
4. Add transaction detail that supports the activity
5. Format to make it easy to compare against sub-ledger or supporting schedules

Why It's Useful: Auditors don't just want to see account balances - they need to understand what's in them and validate they tie to supporting documentation. This report is critical during audits for accounts like deferred revenue (where you need to show contract-by-contract detail), accrued liabilities (vendor-by-vendor breakdown), or prepaid expenses (what's prepaid and when it's being amortized).

Instead of manually building tie-out schedules in Excel every quarter, this report automatically generates the structure auditors expect. It's also valuable for monthly close processes where Controllers need to review balance sheet accounts and ensure everything reconciles properly. The grouped presentation makes it easy to spot anomalies - if you see a customer with negative deferred revenue or a vendor accrual that's been sitting for 6 months, those issues jump out immediately.

Conclusion

The accounting teams at Masterworks, STASH, and Parafin have built comprehensive reporting frameworks in Numeric that rival standalone BI tools—complete with custom dimensions, dynamic groupings, and automated variance analysis.

The difference?

Their reports stay connected to the source data, update in real-time, and live alongside the rest of their close process. No more bouncing between NetSuite, Excel, and three other tools to answer a single question. These days, just one tool – Numeric – does the trick.