Multi-Column Balance Sheets

A multi-column balance sheet enables you to compare account balances for the selected reporting period with account balances for previous reporting periods and to include columns for the sum of all debits and credits posted to each account within a selected reporting period. NetSuite enables you to customize the standard balance sheet report to produce a multi-column balance sheet.

Customization options for the Balance Sheet Report enable you to comply with different international legal requirements by adding columns to the report using the Financial Report Builder. For example, in addition to the account balances for the selected reporting period shown in the standard report, you can display columns for the previous period balance, the total debits, and the total credits. The same options are available for the Trial Balance Report using the Report Builder.

For information about the permissions required to view and customize financial statements, see Permissions and Roles.

To create a multi-column balance sheet report:

1. Go to Reports > Financial > Balance Sheet, and wait for the standard report to load.

2. Click Customize to open the Financial Report Builder.

3. In the Name field, enter a new name for the report, such as Multi-Column Balance Sheet.

4. Click Edit Columns. For more information, see Financial Report Builder Edit Columns Page.

   The Report Preview displays the single Amount column from the standard report. This column is automatically selected.

5. Change the Column Label from Amount to Closing Balance.

   Do not remove the original Amount column.

6. Add a column for the opening balance as follows:

   1. In the Add Fields area, open the Financial folder and select Amount.

   2. Move the new column to the left of the Closing Balance column, and change the Column Label from Amount to Opening Balance.

   3. In the Alternate Period Range Type list, select Relative to report date. Additional options appear below the list.

   4. Check the Cumulative Value box.

   5. In the Alternate Period Range list, select Last Period.

7. Add a column for the total debits as follows:

   1. In the Add Fields area, open the Financial folder and select Amount (Debit).

   2. Move the new column to the left of the Closing Balance column, and change the Column Label if desired.

   3. In the Alternate Period Range Type list, select Relative to report date. Additional options appear below the list.

   4. Clear the Cumulative Value box.

   5. In the Alternate Period Range list, select This Period.

8. Add a column for the total credits as follows:

   1. In the Add Fields area, open the Financial folder and select Amount (Credit). This adds a new column to the right of the Closing Balance column.

   2. Move the new column to the left of the Closing Balance column, and change the Column Label if desired.

   3. In the Alternate Period Range Type list, select Relative to report date. Additional options appear below the list.

   4. Clear the Cumulative Value box.

   5. In the Alternate Period Range list, select This Period.

9. Click Save.

Related Reports

Balance Sheet Report

Balance Sheet Detail Report

Comparative Balance Sheet Report

Multi-Book Balance Sheet Report

Multi-Book Balance Sheet Detail Report

Navigating a Report

Setting Report Footer Options

Graphing a Report

Printing a Report

Emailing a Report

Scheduling a Report

Exporting a Report

Financial Report Builder

Available Financial Statements

General Notices