Basics of Customizing Financial Reports
Customizing financial reports allows you to tailor your statements to your business. You can rearrange your accounts, add new sections, formulas, and other information that does not come standard in NetSuite.
To customize a financial statement like your balance sheet, income statement, or statement of cash flows click the “Customize” button at the bottom left of the report.
This will take you to the financial report builder. This interface is different from the standard report customization screen. Financial reports have an additional section called “Edit Layout”. This is unique to customizing financial statements and allows you to rearrange how the sections display. This post will go over the basics of customizing financial reports, but for more detailed information read the Financial Report SuiteAnswers Article.
On the left side of the customization screen, you will see a list of the existing sections in your report. You can click a section and drag-and-drop it into a new position. You can also click the arrows at the top to move it up or down. In this example, the Ordinary Income/Expense is a “Header/Summary” row. Underneath you can see the Income, Cost of Sales, and Gross Profit are “Rows/Sections” in that Header group.
Adding new Financial Sections
You will see a dropdown where you can add different elements to the report. There are different types of rows that you can add including formulas, texts, and reference rows.
Formula row: Displays a custom calculation based on values of other rows in the financial statement (Change in Net Income, Gross Profit, etc.)
Reference row: Displays a value referenced from a financial section or rows in another financial statement. (Available only for Balance Sheet and Cash Flow Statement reports – e.g. Net Income).
Text row: Displays static text or provides a blank row in between financial statement sections.
Header and Summary Rows Ordinary Income/Expenses is a Header/Summary Row. Header rows allow you to put Financial Sections below them (Income). Income is a Row/Section. You can define which accounts or type of accounts display.
Name your Header and Total row and define which section you want this to display under.
- Total label row will display the total amount for that section (Total Income)
- When you create a new Row/Section, you need to specify which Header section it will go under. This is done by adding that header (in this example, Ordinary Income/Expense) in the “Child Of” field.
Define your filters
Once you create a new section you will need to specify which accounts you want to include. At the bottom of the screen, there is a subtab called “Section” where you can add different filters. For this example, we want to include all accounts that are income accounts. You would select “Account Type” and then choose “Income.
You can also have a filter for Account Name or Account Number if you want to just include certain accounts in this section.
Click Ctrl to select multiple account types, names, or numbers.
Next to the “Section” subtab, you will see “Format”. This is where you can change the font and row color of the Header, Total, and Account rows.