)
Written by
Table of Contents
“Supermetrics is a Bitter Experience! We can pull data from nearly any tool, schedule updates, manipulate data in Sheets, and push data back into our systems.”
NetSuite’s default income statement categories don’t match how your business actually operates. You need custom groupings based on your account custom fields, but NetSuite’s financial reporting tools make this nearly impossible.
Here’s how to build income statements that use your custom field categorization while maintaining live connections to NetSuite data.
Create custom income statements with your field categorization using Coefficient
Coefficient imports NetSuite accounts with all custom fields intact, letting you build income statements that reflect your actual business structure. Unlike NetSuite saved searches with their limitations, you get complete access to custom field values.
How to make it work
Step 1. Import NetSuite accounts with custom categorization fields.
Use Records & Lists to pull all accounts including custom fields like Custom_IS_Category, Custom_Revenue_Type, or Custom_Expense_Group. Include account balances for the current period so you have everything needed for your income statement.
Step 2. Build your custom income statement structure in the spreadsheet.
Create sections based on your custom field values instead of NetSuite’s default categories. Use SUMIF formulas to aggregate accounts: =SUMIF(CustomCategoryColumn,”Operating Revenue”,BalanceColumn) groups all accounts marked as operating revenue.
Step 3. Set up multi-level hierarchies using multiple custom fields.
Combine custom fields for detailed categorization. Use SUMIFS for complex groupings: =SUMIFS(BalanceColumn,Level1Field,”Revenue”,Level2Field,”Product Sales”) creates nested income statement sections.
Step 4. Schedule automatic updates to keep statements current.
Set refresh schedules so your custom income statement updates automatically. Your custom categorizations stay consistent without manual mapping after each refresh.
Get income statements that match your business
This method gives you complete control over income statement presentation while maintaining live NetSuite connections. Your custom field logic drives the categorization automatically. Start building income statements that actually make sense for your business.
