Financial Systems

Practical Tips for Budgeting Using NetSuite & PBCS

In my professional experience, one of the biggest challenges faced by startups and small companies is the lack of resources to manage the workload within the finance department. This lack is especially painful in the area of budgeting and financial planning. Financial forecasting is a highly detailed activity that requires cross-functional communication, and it can be very time consuming to maintain on an ongoing basis. Because startups and small companies rarely have the resources to budget for every department, their finance departments are often limited to accountants managing month-end close and treasury functions.

To minimize the workload, and still ensure that relevant detail can be easily managed, NetSuite offers syncing with Oracle’s Planning and Budgeting Cloud Service (PBCS), which replaces the budgeting functionality within the NetSuite’s core accounting software. While the software is intuitive to use, here are a few suggestions to make it easier to budget using NetSuite and PBCS.

Creating Templates in PBCS

One of the advantages of PBCS is that it can be used to create custom budgeting templates, where GL accounts can be organized by departments with the flexibility to edit certain GL accounts while locking other account / department combinations. Preferably, budgeting templates should be created with the following best practices:

  • The template(s) should build up revenue from basic assumptions, including those that can be captured and actualized, on a weekly / monthly basis.
  • Expense budget templates by GL accounts should be set up by department. Only specific people, or mostly a single point of contact within each department, should have the permission to edit the template(s).
  • Amortization and depreciation schedules should be set up in a separate template of their own.

Financial Template in Excel

Once the budgeting templates have been created, a financial forecasting / budgeting package can be built in Excel and maintained along the same lines as Essbase. The best practices to create a template within Excel are:

  • Setup data retrieval and upload on separate tabs to ensure that changes made are being accurately captured.
  • A single person should actualize the file with actuals from the previous week or month and use conditional formatting to highlight variances to target or items that need to be re-forecasted based on actuals (e.g., cash flow, Departmental GL expenses, etc.).
  • Build a dynamic template that requires minimal ongoing maintenance and lock the cells within the Excel template to prevent unauthorized changes.
  • Once the re-forecast process is complete, the results should be reviewed and approved prior to uploading the new forecast.

Reporting Template in Excel

The financial forecasting process outputs include the proforma financial statements and executive / board packages. Templates can be built in Excel on top of the PBCS cube such that reports can be easily updated with the latest forecast. In order to ensure that this process is error free, the following suggestions are recommended:

  • Save each version of the forecast, and clearly identify the forecast versions that align with certain reporting packages.
  • Minimize or replace the use of linking various Excel files with different forecast versions (e.g., actuals, last month forecast, this month forecast, etc.) as that will minimize errors. This may slow down Excel during the data retrieval process, but it will likely lead to more accuracy.

Optimizing NetSuite and PBCS and Other Systems

The above practices have helped me to effectively use the NetSuite and PBCS integration and the subsequent download into Excel to manage huge amounts of data. If you’re curious about optimizing your use of NetSuite and PCBS or other financial systems, please reach out! We have a broad base of expertise to help you understand how to use various tools to maximize your productivity.

If you’d like to learn more about financial process automation and selecting and implementing a financial system, you can download our free checklist:

financial system selection checklist

About the Author

Prashant has over 15 years of finance and accounting experience. Having worked in private equity as well as a variety of other industries, he has years of experience in dissecting financial statements to understand the key performance drivers and increase revenue and profitability. He has led finance and accounting at various startups, implemented and streamlined processes and financial systems. Prashant holds a Bachelor in Mechanical Engineering, Masters in Industrial Engineering from Ohio State University, MBA from University of California-Berkeley and CPA (Inactive) from the State of Pennsylvania.

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