A monthly consolidated balance sheet in NetSuite gives finance teams a point-in-time view of assets, liabilities, and equity across subsidiaries. To create one reliably, configure the subsidiary hierarchy and accounting structure, confirm currency and intercompany settings, run the standard Balance Sheet report at the correct consolidated level, apply the proper period-end filters, and validate eliminations and translated balances before distributing the report. NetSuite OneWorld handles the rollup, but the quality of the result depends on the underlying entities, accounts, exchange rates, and close controls.
The key distinction is that a balance sheet reports balances as of a date, not activity across a date range. A monthly consolidated balance sheet for March, for example, should use the final day of the March accounting period as the reporting endpoint. Selecting a month as a range or running the report at a subsidiary level produces a different result from a consolidated point-in-time statement.
What a monthly consolidated balance sheet in NetSuite shows
A consolidated balance sheet combines the financial position of a parent company and its subsidiaries into a single report. It generally includes cash, accounts receivable, inventory, fixed assets, accounts payable, debt, other liabilities, equity, and retained earnings.
NetSuite’s consolidated reporting structure uses the relationship between subsidiaries rather than requiring finance teams to export each entity’s trial balance into a spreadsheet. In a OneWorld account, the parent-child subsidiary hierarchy determines which entities roll into a consolidated view. The reporting currency and consolidation context then determine how foreign-currency balances appear in the parent’s books.
The report is not simply a total of every ledger balance. Several accounting processes affect the final presentation:
Foreign subsidiaries require currency translation into the parent or group reporting currency.
Intercompany balances may require elimination so receivables and payables between related entities do not inflate group assets and liabilities.
Intercompany revenue, expenses, and equity activity may also require elimination.
Retained earnings and other equity accounts reflect the account structure and period-close process.
Multi-book accounts may produce different balances depending on the selected accounting book.
Consolidation adjustments must be posted and reviewed in the appropriate context.
For broader system design, our guide to building a single finance backbone in NetSuite explains why entity structure and controlled consolidation matter before reporting begins.
What must be configured before you run the report?
The most important preparation is confirming that NetSuite knows which entities belong in the consolidated group and how their transactions should be treated. A report cannot correct a subsidiary hierarchy, chart of accounts, or intercompany design that is incomplete.
Confirm the subsidiary hierarchy
Open the subsidiary records and verify the parent-child relationships. Each subsidiary should roll into the intended parent, and the parent subsidiary should use the correct base currency and reporting structure.
Check for:
Active subsidiaries that should be included
Inactive or divested subsidiaries that should be excluded
Correct parent subsidiaries
Correct base currencies
Appropriate tax and accounting classifications
Consistent accounting periods across the reporting group
A subsidiary that sits outside the intended hierarchy will not appear in the expected consolidated context. Conversely, a subsidiary placed under the wrong parent can affect group reporting even when its local financial statements look correct.
Review the chart of accounts
Consolidation works best when equivalent accounts are used consistently across subsidiaries. If one entity records deposits in a cash account while another uses a differently classified account, the consolidated report may still run, but the presentation will be harder to interpret and reconcile.
Review account types, numbering, names, and classifications for major balance sheet categories. Pay particular attention to:
Cash and cash equivalents
Accounts receivable
Inventory
Prepaid assets
Fixed assets and accumulated depreciation
Accounts payable
Accrued liabilities
Debt
Intercompany receivables and payables
Contributed capital
Retained earnings
NetSuite’s Financial Report Builder can help organize rows and sections, but it does not replace account governance. A custom layout can change presentation without fixing inconsistent source accounts.
Confirm the reporting period
The accounting period must be open or closed according to the organization’s reporting policy, and the report should use the intended month-end date. A balance sheet for a month is not a monthly activity report. It is a statement of balances at the end of that month.
For example, a report labeled “March 2026” should use the last day of the March 2026 period as the as-of date. If March is a 31-day accounting period, the report should not accidentally include April transactions or exclude late-posted March entries because of an incorrect date selection.
If your financial reporting requires a locked month-end view, run the report after approved close entries, foreign exchange updates, and consolidation adjustments have been posted.
How do you create the report in NetSuite?
The standard Balance Sheet report is the right starting point for most monthly consolidated reporting. Exact menu names can vary by role, permissions, and account configuration, but the process follows the same control points.
1. Open the standard Balance Sheet report
Navigate to the financial reports area and open the standard Balance Sheet report. Start with the standard report before creating a custom version. This gives you a known baseline for testing balances and identifying whether a discrepancy comes from data or report presentation.
The standard report typically includes the primary asset, liability, and equity sections. If your organization has customized financial layouts, confirm that the selected layout is approved and has not changed the underlying row logic unexpectedly.
2. Select the consolidated reporting context
Set the report’s subsidiary or consolidation context to the parent or top-level reporting entity. The exact label may appear as a subsidiary selector, reporting context, or consolidated subsidiary option depending on the NetSuite configuration.
Do not assume that selecting the parent entity automatically means every subsidiary is included. Review the hierarchy and confirm the selected context contains the intended entities. A parent-level report can also differ from a report run for an individual subsidiary because the consolidated report applies translation and elimination logic.
The selected accounting book matters as well. In a multi-book environment, run the report against the book used for group financial reporting. A local primary book and a secondary accounting book can contain different balances, classifications, or adjustments.
3. Set the month-end date
Use the period or date controls to select the final date of the month. For a period-based report, choose the correct accounting period. For a date-based report, choose the last calendar day covered by the period.
This step deserves special attention because the balance sheet is cumulative by nature. The report includes balances accumulated through the selected date, while the income statement measures activity over a period. Changing the date by one day can include late entries, reversals, depreciation, or closing journals that materially change the presentation.
4. Apply approved report filters and layout settings
Use the standard layout unless finance has approved a custom layout. If the organization needs a different row order, account grouping, or display format, configure the layout through the Financial Report Builder and test it in a non-production environment first.
NetSuite supports report presentation settings such as:
Account detail or summarized account rows
Comparative columns
Custom row and section labels
Negative numbers displayed with parentheses
Account grouping and ordering
Foreign currency display options
Department, class, or location dimensions where appropriate
A layout change can affect scheduled reports and internal review workflows even when the general ledger remains unchanged. Our article on customizing NetSuite balance sheet and income statement layouts covers the role of row layouts and why sandbox testing is important.
5. Run and save the report
Run the report and review the results before saving a recurring version. Save the report only after the subsidiary context, accounting book, date, columns, and layout are correct.
A saved report should have a clear name that identifies its purpose, such as “Monthly Group Balance Sheet” or “Consolidated Balance Sheet, Month End.” Document the intended reporting context in the report description or related close procedure so another user understands what the report includes.
If the report is distributed through a scheduled process, confirm that the schedule uses the correct period logic. A report saved with a fixed calendar date will not automatically become a month-end report for future periods unless its date settings are configured appropriately.
How should you validate eliminations and currency translation?
The report is not complete when it runs successfully. Finance should validate the accounting logic behind the consolidated balances, especially when subsidiaries use different currencies or transact with one another.
Review intercompany balances
Intercompany receivables and payables should be reviewed between both sides of each material relationship. A difference can result from timing, currency conversion, account mapping, an incorrect entity, or a transaction posted to the wrong period.
NetSuite intercompany transactions and elimination entries depend on correct entity relationships and elimination settings. Review the underlying transactions and compare the originating entity’s balance with the counterparty’s balance. Do not treat a clean-looking consolidated total as proof that the underlying balances agree.
A practical reconciliation should identify:
The sending subsidiary
The receiving subsidiary
The intercompany account used by each side
The transaction currency
The period posted
The expected elimination amount
Any remaining difference and its owner
For a detailed look at governance around entity reporting and intercompany review, see our discussion of entity-wide control with NetSuite.
Confirm elimination behavior
Elimination entries should remove qualifying intercompany balances from the consolidated view without removing legitimate third-party activity. Review the elimination subsidiary and related elimination accounts used by the account configuration.
Common problems include:
One side of an intercompany transaction is missing
The transaction uses a non-eliminating account
A customer or vendor is not identified as intercompany
The transaction is posted after the reporting period closes
The elimination entry is recorded in a different book
A manual journal duplicates an automated elimination
The correct resolution is to trace the source transaction and the elimination logic, not to plug the consolidated report with an unexplained journal entry.
Check foreign currency translation
For subsidiaries with foreign base currencies, NetSuite translates balances into the parent reporting currency using consolidation exchange rates and the applicable account treatment. Balance sheet accounts and income statement accounts do not necessarily use the same translation method.
Review the exchange rates used for the reporting period and confirm that rate updates were completed before the report was finalized. Pay attention to accumulated translation differences, which may appear in equity rather than operating income depending on the account and configuration.
A useful control is to compare the translated balance sheet with the prior month and investigate changes in:
Cash caused by currency movement
Accounts receivable and payable
Debt balances
Fixed assets
Equity and accumulated translation adjustments
The purpose is not to eliminate every month-over-month change. The purpose is to distinguish expected currency movement from an incorrect rate, missing transaction, or account classification problem.
Our NetSuite accounting services page provides more detail on accounting controls, period-end close, multi-entity reporting, and maintaining reliable records in NetSuite.
How do you reconcile the consolidated balance sheet?
A reliable reconciliation starts with the report total and drills into the accounts that explain movement. Do not review only the final total assets and total liabilities plus equity. A consolidated balance sheet can balance mathematically while still containing a material classification or elimination error.
Compare the current month with the prior month and ask whether each major movement has a documented cause. The explanation may be a posted transaction, depreciation, debt repayment, foreign exchange, an acquisition, an elimination, or a reclassification.
Use the general ledger and transaction detail to support unusual changes. Saved Searches can help identify postings by subsidiary, account, intercompany entity, currency, and period. They are especially useful when the standard financial report shows a consolidated amount but the reviewer needs to trace it to source activity.
The reconciliation should also confirm the accounting equation:
Total assets = Total liabilities + total equity
This equation is necessary but not sufficient. A report can satisfy it while still including an intercompany receivable that should have been eliminated or omitting a subsidiary from the reporting context.
For recurring close management, establish review ownership for each major section. Cash, receivables, inventory, fixed assets, payables, debt, and equity often require different supporting schedules and reviewers.
What should you do when the consolidated balance sheet is wrong?
Start by isolating whether the issue is presentation, scope, source data, currency, or elimination. Changing the report layout will not correct a transaction posted to the wrong subsidiary, and posting a journal entry will not correct an incorrectly selected report context.
Use this diagnostic sequence:
Rerun the report at the affected subsidiary level.
Compare the subsidiary report with the consolidated report.
Check the reporting date and accounting book.
Review the account balance in the general ledger.
Inspect intercompany and elimination activity.
Confirm the applicable exchange rate.
Compare the current period with the prior period.
Document the correction and rerun the report.
If a balance is correct locally but incorrect in consolidation, focus on hierarchy, currency, elimination, or consolidation settings. If the balance is incorrect locally, focus on transaction posting, account classification, period status, or source-system integration.
Avoid editing a custom report until the source of the discrepancy is known. A custom report can hide the symptom while leaving the underlying accounting issue unresolved.
How do you automate monthly distribution?
After the report has been validated, NetSuite can support recurring distribution through saved reports, scheduled reporting, dashboards, or controlled exports. Automation should follow the close process, not replace it.
Define when the report is considered final. For example, the report might be distributed only after bank reconciliations, intercompany reconciliation, foreign currency updates, depreciation, accruals, and consolidation entries are complete.
Control the recipient list and access permissions carefully. A consolidated balance sheet contains sensitive financial information, and report access should align with the user’s role and subsidiary visibility. Use role-based permissions rather than distributing unrestricted exports by email.
For management reporting, consider whether the standard NetSuite report is sufficient or whether approved dashboards and reporting tools should provide trend analysis. NetSuite Reporting Services can support financial reports, dashboards, and Saved Searches built around agreed metrics and source data. The important control is maintaining one defined calculation for each reported figure.
Conclusion
Creating a monthly consolidated balance sheet in NetSuite is primarily an accounting structure and close-control exercise, not just a report-running task. Start with the subsidiary hierarchy, chart of accounts, accounting book, reporting period, currencies, and intercompany configuration. Then run the standard Balance Sheet report at the correct consolidated level, validate eliminations and translation, reconcile major movements, and automate distribution only after the report is approved.
When the configuration or close process needs a deeper review, contact our NetSuite team to discuss the reporting structure, controls, and next steps for your environment.
