Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Monthly Budget vs Actual KPI Scorecard
Our team wanted a monthly budget vs actual KPI for revenue and expenses on the main dashboard in a scorecard format so we could show each month of the year that has already closed. After much searching, there didn’t seem to be a good solution for this as the budget feature in NetSuite is only searchable by year. I came up with a custom solution, but am curious if there are better ways to do this.
To show budget by month, I created a new custom record type to save the monthly budget for revenue and expenses. This does mean double entering the budget each year though, which isn’t ideal. This custom record contains the following fields: Date, Period, Budget Type, Budget Amount.
0