Financial Systems

Transform Your Budget and Forecast Process: From Excel to Oracle NetSuite PBCS

For small to mid-size companies, relying on Excel can create stress every budget season, including a forecast cycle or two, if time permits! Excel is a great tool for analysis and data representation. However, the pain of consolidating, linking and maintaining version control with multiple spreadsheets and several users to create an annual budget takes up valuable time and resources. The finance team should be spending time on actual analysis, reviewing information and telling the story of the company’s financials. Let’s review how moving from Excel to a platform like Oracle NetSuite PBCS (Planning & Budgeting Cloud Service).

Consider an Enterprise Performance Management Solution

Are you and your team drowning in Excel files during budget season? Is the business changing rapidly, making it more difficult for your team to maintain static templates? Are static Excel templates emailed to budget owners and returned via email to your team for consolidation? This situation is an all-too-familiar scenario for many finance groups. And to add fuel to the fire, emails go missing, or multiple versions are re-sent to your team.

An Enterprise Performance Management (EPM) solution facilitates a budget process more efficiently. Utilizing an EPM system provides a central repository of financial data that can be sliced and diced using an Excel add-in, which is a familiar tool used for financial analysis. Many of the EPM solutions have reporting and dashboarding capabilities for senior leadership to digest financial information quickly. Budgets can be entered and reviewed by P&L owners, and there can be an approval workflow and audit trail of changes.

Having experienced implementing an EPM solution, specifically Oracle NetSuite PBCS, switching from Excel to an EPM tool brought the following benefits to the budget process:

  1. Transparency
  2. Manageability
  3. Collaboration
  4. Data Integrity

Learn more about identifying whether you need an automated system for budgeting and forecasting:

automating budgeting and forecasting checklist

Finding the Right Solution, and Selecting Oracle NetSuite PBCS

The selection process of an EPM solution can be overwhelming. Factors to consider include, but are not limited to, the speed to implement, integrations and application features. To speed up implementations, a cloud-based option is the path businesses often choose. Another consideration involves the integration of data between your ERP and EPM tool, specifically how data will be loaded. Each tool has unique features and specifications. During the RFP and demonstration process, the solutions considered were Workday Adaptive Insights, Host Analytics and Oracle NetSuite PBCS. Though there are many Oracle Planning and Budgeting Cloud benefits, with NetSuite as the company’s Enterprise Resource Planning (ERP) system, implementing PBCS was the most obvious option for four main reasons:

  1. Compatibility within the same Oracle ecosystem meant there would be a seamless connection to and from NetSuite and PBCS.
  2. A drill through feature from PBCS to NetSuite allowed users to access transactional data.
  3. PBCS utilizes the popular Excel add-in, Smart View, which all other vendors were comparing themselves against.
  4. PBCS was robust and could scale with our rapid growth, both organically and through acquisition.

Learn more about the process of system selection in our guide to selecting a system for ASC 606. It offers transferrable principles and processes: “Selecting a Revenue Management System for ASC 606” [Whitepaper]

Design for the Future

After an EPM solution is selected and requirements are gathered, the design phase of the project begins. During the design sessions, it usually becomes clear that current budget processes and finance views will not work in a future-state solution. For example, a finance process improvement and redesign process may include the requirements for how workforce would be budgeted, how volumes and rates would be captured (which may not be readily available by product) and structuring the organization for proper workflow approvals.

To meet the requirements within PBCS, the Workforce cube can be utilized to manage existing and new employees, and a Revenue cube can be developed to capture volume and rates—along with the enablement of the Financials cube for a consolidated view of all financial data. You can also take advantage of PBCS Valid Intersections functionality, where foreign entities can budget in their home currency with no concerns of inputting data to invalid currencies. Finally, PBCS can perform allocations where applicable, such as Cost of Goods Sold.

Training, Testing & Roll Out of Oracle NetSuite PBCS

Before go-live of PBCS, routine meetings with internal stakeholders and sponsors can help mitigate risks and surprises and ensure requirements are being met. Training for users is often completed before, during and after User Acceptance Testing (UAT). During the UAT phase, bugs will be identified and fixed by your implementation partner. Input and review forms are also modified during UAT to help increase performance, when applicable. Once the model successfully passes UAT, the solution is rolled out to all end users.

An important consideration, and a cost not usually considered, is a resource to administer PBCS. If the current finance team does not have the bandwidth and/or skillset, a systems administrator is strongly recommended. The administrator will be responsible for updates and maintenance, running business rules, documentation, and security controls.

The phases of implementation for an EPM solution take time from the day-to-day operations of the finance team. For future Oracle NetSuite PBCS implementations, keep 8020 Consulting in mind and we can guide you through the selection, design, and implementation process. If you have questions or would like to connect, take the first step by contacting us, or visit our financial systems consulting services page to learn more:

financial systems consultants

About the Author

Desiree is a results-driven finance professional with more than 12 years of progressive experience in strategic planning, budgeting and forecasting, financial modeling, system implementation, post-acquisition integration and M&A due diligence. Prior to joining 8020, she served in various leadership roles and management positions ranging from large global corporations to mid-sized, PE-backed companies. Her industry experience spans across aerospace, aviation, professional services and cable and communications industries. As a Director of Finance, she led the finance functions and successfully implemented an EPM solution. As a Senior Business Manager, she built sophisticated, dynamic dashboards utilizing the industry leading data visualization tool, Tableau. Desiree holds a B.A. in Business Administration from California State University, Fullerton and an EMBA from the University of Southern California, Marshall School of Business.

Categorized in: ,

similar articles

Learn to think and approach problems like our financial consultants.

Financial Reporting & Accounting

How to Improve Accounting Processes Using ESOAR (Part 1)

Organizations pursue process improvements to achieve a combination of higher efficiency, higher quality or better accuracy within their operations. If you’re struggling with how to improve accounting processes, you might take advantage of ESOAR, a process improvement methodology that can help you drive long-term value. When approaching processes using this methodology, one should: Eliminate wasteful… View Article

July 22, 2021Justin Vu

Financial Planning & Analysis

Accounting & Finance as a Strategic Business Partner or: 3 Ways to Shift from Bean Counter to Bean Grower

The bean counter is dead. Long live the bean grower. Finance and Accounting professionals’ role within the corporate ecosystem over the decades has evolved from the proverbial bean counter to emerge as a bean grower. No longer is the finance team viewed as the pocket-protector-sporting, 10-key-toting, necessary annoyance relegated to the back rooms of the… View Article

July 14, 2021Jo Ann Eilers

Project Management

About Project Scope Management in Finance and Accounting Projects

A project’s scope includes everything needed to get from the objectives to the results – all the work required to complete the project’s deliverables. “Project Scope Management” is the discipline composed of the processes required to ensure that a given project is on track to complete successfully. It involves defining and controlling what is included… View Article

June 29, 2021Olga Christodoulides

See All

Back to Insights