34 Tips And Tricks for Increasing Your NetSuite Admins’ Productivity.

34 Tips And Tricks for Increasing Your NetSuite Admins’ Productivity.

Two NetSuite experts, Toast Senior NetSuite Administrator Oxana Kabakova and NetSuite Principal Compliance Manager Lisa Robinson, ran through a number of oft-overlook tips and tricks in a session at SuiteWorld 2022. They covered a lot of ground, so we broke their handy suggestions into categories. Here are the highlights:

Keyboard Shortcuts

1. When inputting a date, type “t” in the box to autofill with today’s date.

2. Type “y” to autofill with the previous day’s date.

3. Press “Shift + t” to autofill with the following day’s date.

4. Type “m” to autofill with the final day of the current month.

5. To reach the global search bar, press “Alt + g” (Windows) or “Option + g” (Mac).

6. Enter the first three letters of several record types in the search bar with either a colon or carat to search specific record types, like cus: for customer, con^ for contact, inv^ for invoice or “emp:” for employee

7. Search only exact matches by putting the term in quotation marks, e.g. “Tech Services Corp.”

8. Add % at the end of a search term for everything that starts with those letters. For instance, tech% will pull up anything that starts with “tech.” 

9. Put percentages around a numeral to pull up any records containing that number, as in %495%.

10. Put an underscore between numbers to pull up customer numbers starting and ending with those numerals. Cu: 4_5, for example, shows customer records 415, 425, 435, etc.

11. To search up to three terms simultaneously, use “OR” (use capital letters) between the terms. Te% OR Tech% OR Techno% would turn up records with any of those prefixes.

12. To see your 12 most recently viewed records, hover over the circular arrow in the top-left corner. Click on the record to open it or hover over it and click edit to change the record. 

General and User Preferences

13. Adjust the number of rows in a list or entries in a search bar dropdown by going to Home > Set Preferences and under Optimizing NetSuite selecting the preferred number of results. 

14. Admins can standardize date formats on that same Set Preferences General tab under Formatting.

15. Seeing internal IDs for all fields, records, lists, workflows and custom forms is useful when you’re making customizations through SuiteScript. To make these visible, in the General under Defaults select Show Internal IDs.

16. Change your NetSuite UI color scheme by navigating to Home > Set Preferences > Appearance. The Color Theme dropdown shows all available colors, including school colors for many US colleges.

17. Admins can give all non-admin users the same toolbars rather than role-specific ones by navigating to the same Appearance tab and under Centers & Dashboards selecting the box next to “Use Classic Interface.”

18. If you’re booking out-of-period transactions that you want tied to the general ledger for reporting purposes, go to the Analytics tab in Set Preferences, and under reporting change Report By Period to All Reports instead of Financials Only (the default setting). 

Reports and Searches

19. Web queries allow admins to share many reports with colleagues that don’t have a NetSuite license. Navigate to the Report, click Customize and under the More Options tab, click the box for Allow Web Query. You can export the report to Excel and, once saved, the report will refresh with the latest data every time you open it. Note: this does not work for reports with the Financial Statement Layout.

20. Set up an audit trail custom search by creating a new saved search and selecting Analytics Audit Trail as the search type. The results will show who made any changes to records in a certain time period. 

21. To see a list of who deleted what records and when, start a new saved search and select Deleted Record as the search type. 

22. You can also delete multiple records at once by going to Lists > Relationships > Customers. Make sure Edit is enabled at the top of the screen, then hold the CTRL key and select all the lines you want to delete. After that, hover over the New column on the far left and select Delete Record.  

Dashboards

23. The Navigation Portlet SuiteApp can provide a major assist to admins, as it allows them to create a role-specific home dashboard portlet with categorized quick links to commonly accessed reports, records and other information for different users.

24. Sales and operations employees can quickly get the information they need with customer or vendor dashboards. First pull up a list of customers or vendors. Hover over the record and a Customer/Vendor Dashboard button should appear to the right of the Edit button. You can also access this when in a customer or vendor record by clicking View Dashboard in the upper-right hand corner. 

25. For more information on the latest NetSuite release, hit Personalize in the upper-right corner of your home screen. Click the icon labeled “New Release” to add the New Release Portlet to your dashboard. From the portlet you can review release notes and access your Release Preview account.

26. Change how reports are categorized to what makes the most sense for you by navigating to Customization > Centers and Tabs > Center Categories > New.  

Performance

27. Double-click the Oracle NetSuite logo in the top left-hand corner for quick details on the performance of your NetSuite instance to quickly identify potential issues.

28. Download the NetSuite Application Performance Management SuiteApp for a deeper look into system performance, including customizations and mission-critical operations. It shows a dashboard highlighting potential issues, performance KPIs, server and client response times, helps prioritize problems by usage and traffic, and more. 

29. Visit status.netsuite.com to see if problems with NetSuite are only affecting your account or hitting multiple companies. 

Other tips

30. If admins are not seeing a certain feature, make sure it’s turned on by going to Setup > Setup Manager. Then search for the feature you’re looking for and see if it’s enabled.

31. Admins can reschedule system maintenance by navigating to Setup > Company > Customer-Scheduled Maintenance and clicking Reschedule next to the maintenance item. You can then select from available dates and times (slots are first come, first served).

32. Use the Copy to Account tool to move custom objects between accounts by going to Customization > Lists, Records & Fields > Record Types, then selecting the record adn clicking Copy to Account. You can select a target account, choose dependencies and record instances to include, then preview and deploy the custom record. Copy to Account is best for simple objects like custom fields.

33. There are two types of non-production accounts: sandbox and development. Sandbox accounts include a full replication of your production account, including all customizations and data. Development accounts have all the features of your production account but none of the data if you don’t want users to see sensitive information. They also don’t include third-party SuiteApps.

34. SuiteAnswers is a great place for admins to direct others for self-service as it’s accessible to all users. They can access it from any page in NetSuite by clicking Support > Go to SuiteAnswers or from the Help button at the top of the screen.

Want to know more?

Our experts are more than happy to listen to your enquires and provide you with the information you need.

Related Post

Straightening Out Your Financial Reports

Straightening Out Your Financial Reports

Consistency in data management and control is the key to preventing messy books.

The Start

The very essence of accounting is organization. Recording transactions, summarizing activity, and reporting results fundamentally revolve around organized data and information. But good accounting is all about organizing data correctly — that is, in a manner that lends itself to further analysis. 

A new business with few transactions may not have difficulty keeping its accounting organized or quickly putting together clean, accurate financials. But as a company grows and transaction volumes increase, it becomes increasingly difficult to juggle all the processes necessary to keep accounts and financials in order. Inconsistent sorting, random adjustments, and too many unwieldy and ultra-specific accounts are all too common.

The result? Unreliable, messy books that make it difficult for leaders to get an accurate picture of the company’s past and present positions. 

The Mess

Duplicate, incorrectly sorted, and unmatched transactions obscure the true picture of income and expenses in a period. Trusting — and acting on — misstated account balances can be costly for a business, and realizing that the financial information presented is essentially meaningless can be extremely frustrating.

One miscategorized transaction can throw off two or more accounts. And the more those mistakes multiply, the less our books depict an accurate picture of past, present, and future positions.

The mess creeps up slowly at first. A few transactions are sorted into the wrong accounts and left to fix “later.” An executive decision is made to include location-specific expense accounts, exponentially expanding the chart of accounts. The summer intern accidentally duplicated all of last month’s transactions. And now, all of a sudden, the financials are all wrong, a deadline is approaching, and you have no idea where to even start.

For this very reason, periodic clean-ups have become a standard process in many accounting departments. Time is earmarked to determine just how far the books have strayed from the truth, if the difference is material or not, and what adjustments are needed to bring the financials back to order.

Problem is, in no time at all after each in-depth review and adjustment session, the errors collect just as fast as before. Limited resources and overstretched employees make it near impossible to manually improve data management, oversee every single accounting decision, and avoid all errors.

And since adjustments and short-term fixes fail to address the root cause, it’s inevitable that poor data management stemming from ineffective tools, rules, and processes will continue to produce chaos.

The Solution

Permanently breaking the cycle of errors requires better tools and efficient information structures that support enhanced control over data. NetSuite’s cloud accounting software solution is an intelligent, rules-based engine that automatically classifies transactions, applies accounting treatments consistently, and assigns accounts based on defined criteria.

When incoming transactions are sorted into the correct accounts all the time, every time, it reduces the need to locate errors and keep making adjustments, year over year. Additional accounting tools specifically built for managing complex processes, like accounts receivables and fixed assets, simultaneously provide a deeper level of control and better management while reducing manual effort and human error.

NetSuite’s platform operates from one single source of data that ensures the information from these systems supports the accuracy and reliability of core financial statements. With these tools and NetSuite’s multidimensional data capabilities, finance professionals can address the root cause of messy financial data, eliminate errors, and improve oversight and control.

Want to know more?

Our experts are more than happy to listen to your enquires and provide you with the information you need.

Related Post

How AP Automation Saves Money, Reduces Risk, and Increases Efficiency

How AP Automation Saves Money, Reduces Risk, and Increases Efficiency

While accounting software has been around for decades, manual processes still play a major role in many accounts accounts payable (AP) operations. From manually entering vendor bills to generating check runs and mailing payments, accounting personnel often spend several hours a day performing mundane, repetitive tasks that could easily be automated. This is highly inefficient.

The Hidden Costs of Manual AP Processes

Manual processes are time consuming, labor intensive and prone to error. They also put a strain on accounting resources, taking time away from higher-value tasks like analyzing data and investigating anomalies. Companies that rely heavily on manual AP processes also tend to have higher overhead costs, spending by some estimates nearly five times more to process a single invoice versus organizations that are fully automated.

Manual AP processes can delay payments to vendors. This isn’t necessarily a bad thing if a company is experiencing a temporary cash shortfall. If payments are habitually late, however, it can lead to higher supply costs and missed savings opportunities. 

Suppliers tend to offer good customers the best prices. Purchase volume is the main consideration, but the customer/supplier relationship also plays a role. When customers don’t pay on time, it hurts that relationship. So a company that consistently pays late is unlikely to get the same pricing as one that always pays on time. 

Many companies offer early-payment discounts. While it may not be feasible to take advantage of every discount, an occasional early payment still saves money. But if manual AP processes make it difficult even to pay on time, then those potential savings are out of reach.   

Manual AP processes also increase the risk of errors and financial fraud. Manual data entry is a common source of errors. It’s easy to transpose numbers or leave out a digit when entering a vendor invoice or moving data between two systems. Caught in time, these errors are easily corrected, but with limited time during the close process, it’s not always possible to review every transaction. 

Identifying and correcting inconsistent or misapplied accounting rules is more difficult. Companies may not even be aware they’re making these errors, but they can prove quite costly for publicly traded companies and those preparing for an IPO.

Payment fraud is a growing concern, and relying heavily on manual processes increases the risk of falling victim. Maintaining separation of duties and other financial controls is essential to prevent internal personnel from submitting and approving fraudulent invoices. Avoiding this kind of fraud requires careful monitoring of every transaction to ensure approval hierarchies and other procedures are consistently followed. Overworked controllers and managers rarely have the bandwidth to do this, however, especially if it requires sifting through hundreds or thousands of daily transactions. This makes enforcement of internal controls spotty at best.

Automation Opportunities

Automating AP simplifies invoice processing, approvals and payments; helps accounting staff keep track of invoice due dates; and reduces the risk of fraud by ensuring vendor invoices are legitimate. Automation can also save money by ensuring on-time payment of vendor bills and making it easier for companies to identify and take advantage of early-payment discounts.

Invoice capture. As previously mentioned, manually entering vendor bill data into the accounting system takes an inordinate amount of time and is a significant source of errors. Fortunately, technologies like object character recognition (OCR) and machine learning have progressed significantly in recent years, making it possible to convert PDF and image files into digital text with a high degree of accuracy. 

For AP staff, this means bills in electronic format can be imported automatically into the accounting system rather than entered manually, reducing the potential for errors.  

Invoice matching and approvals. It’s important to make sure goods and services have been delivered before a vendor invoice is paid. Matching the purchase order, invoice details, and receiving documents is standard practice, but the process typically requires input from multiple departments, which can lead to delays. Automating three-way matching simplifies the process. Receiving data can be captured electronically and linked to the PO and invoice in the accounting or ERP system, making it easier to compare documents to ensure accuracy. 

Automation also makes it easier to ensure proper oversight of payments by enforcing payment authorization policies. Once the accuracy of a vendor bill is confirmed, it can be emailed automatically to the appropriate person or people based on the company’s internal approval hierarchy.

Making payments. Printing and mailing physical checks is time consuming, increases processing costs and makes it more difficult for companies to pay bills early. Automating the payment processes improves AP staff’s efficiency by eliminating these manual tasks. Electronic payment options give companies greater flexibility to decide how and when to make payments, allowing them to hold on to cash longer while avoiding late charges.

Automating Accounts Payable with NetSuite

NetSuite helps companies save money, reduce risk and increase efficiency by automating the entire vendor bill settlement process. NetSuite AP Automation provides a simple, fast, secure way to process invoices and make payments. NetSuite digitizes and automates the entire vendor bill settlement process, saving time by making it easier to pay suppliers and helping businesses scale their entire accounts payable process, allowing AP teams to support business growth without adding headcount. 

  • Receive. Capture and convert electronic invoices into digital text.
  • Match. Automatically match vendor invoices to purchase orders and receiving documents.
  • Approve. Route bills to the appropriate personnel for review and approval, with automated reminders.
  • Pay. Make payments via virtual credit card, ACH, or check with embedded banking services provided by HSBC.
  • Reconcile. Track the status of payments and reconcile transactions with full audit control.

Want to know more?

Our experts are more than happy to listen to your enquires and provide you with the information you need.

Related Post

Take AP Automation to the Next Level While Reducing Fraud with NetSuite & HSBC

Take AP Automation to the Next Level While Reducing Fraud with NetSuite & HSBC

NetSuite Suite Banking aims to transform the way financial services and ERP work together, because ‘there’s magic to be had there.’

Why is accounts payable automation all the rage? An expected $7 trillion dollars of embedded banking flows by 2026, to start. Companies that are still manually entering and paying vendor bills — a labor-intensive and fraud-prone process — will fall further behind competitors that have automated their AP systems to process bills and make payments via banking integration. 

NetSuite not only automates the entire invoice-to-pay process, from data capture to reconciliation. Companies can also take advantage of embedded banking services executed by HSBC to pay bills directly from NetSuite, and businesses that use HSBC virtual credit cards to pay suppliers can earn cash-back rewards.

At SuiteWorld, NetSuite announced new AP automation functionality, and Scott Derksen, Senior Director of Business Development at NetSuite, and Brian McKenney, Chief Business Officer at HSBC Platforms, shared insights on added benefits from the NetSuite/HSBC partnership.

Cutting the Phishing Line

NetSuite AP Automation automatically imports bank and card data into NetSuite each day, which smooths reconciliation and allows for greater visibility.

“This will help you reduce fraud and human error,” said McKenney. “For organizations, about 5% of their revenue is lost to fraud every year, and about 80% of organizations in any given year will experience a fraud attack. Payments is one of the main vectors.”

In fact, AP accounts for 18% of business fraud, with an average loss of $300 per month for 10 months before it’s discovered. Often, the fraudulent payment goes out repeatedly until the legitimate vendor goes, “Hey, you haven’t paid me for 10 months!” 

These attacks are often accomplished via phishing, where a fraudster acts like a supplier or potentially even the CEO or CFO.

“They’ll send a spoofed email and target someone that works in accounts payables or in treasury and say, ‘You have an urgent payment that’s overdue. Can you please make this now?’” said McKenney.

Where in the past, an employee would receive that request, log on, and make the payment, AP Automation adds a layer of protection. A minor change in, for example, the supplier’s bank account information would flag as an exception that requires additional approval.

The process goes like this: With bill capture, finance drags and drops digital invoices into NetSuite, or vendors send them to a designated email inbox. Bills are scanned, and relevant details are converted into digital text. NetSuite uses machine learning to compare the bill to previous invoices, including bank routing info. The bill is then automatically matched with the associated POs and receiving documents to ensure details like unit pricing, quantity and totals are accurate, then routed to the appropriate personnel for review and approval. 

‘Quantifiable Savings’ with HSBC Partnership

As for the HSBC partnership, at SuiteWorld, NetSuite group VP of product management Craig Sullivan showed how NetSuite AP Automation now goes beyond scanning and matching bills to save on headcount, add business agility, and improve cash management. 

“This is the kind of thing that fuels growth,” said Derksen. Having banking embedded inside of NetSuite will eventually change the way companies access capital.

Sullivan walked through how customers can now track balances on their HSBC virtual cards and quickly and seamlessly make payments, all from the SuiteBanking dashboard. 

Additionally, a new account reconciliation tool can automatically match thousands of transactions across all journals and general ledger accounts, including transactions from third-party point-of-sale systems and corporate credit cards. 

“It’s just the beginning,” said McKenney. “We’ll be working to continuously improve the product, bring additional payment types in and also open up a world of opportunity, helping customers internationally.”

HSBC operates and has banking licenses in over 60 markets. By embedding that global outlook in NetSuite, finance can easily manage international vendor payments, currencies, and foreign exchanges across jurisdictions.

From vendor billing through three-way matching, approvals, and convenient, automated payments via HSBC, AP Automation and embedding financial services in the suite is all about keeping finance teams from having to leave NetSuite to jump into a banking portal — another significant time-saver. 

AP Automation has long delivered better security, reduced fraud, and fewer human errors. Now, add in cash back.

Want to know more?

Our experts are more than happy to listen to your enquires and provide you with the information you need.

Related Post

Cost Analysis: What Is It and Why Is It Used?

Cost Analysis: What Is It and Why Is It Used?

Clean data and quality reports are traditionally the result of painstaking efforts to gather the required information and organize it meaningfully quickly enough to ensure relevance. Companies can do better.

To deliver valuable business insights and rich comparative reports, any kind of business analysis needs to follow an organized approach, beginning with gathering and sorting data. Cost analysis follows much of the same methodical process but maintains a narrow focus on the total costs for a company’s goods and services. That close tracking and examination of cost patterns enables organizations to identify what may be driving spending higher, determine if they are getting enough value for their money and understand if there are alternative materials, suppliers or processes worth exploring.

This systematic review categorizes expenditures by their direct and indirect effects on goods and services produced. Once you have this data, you can review costs, revenues and profit margins and compare and analyze spending by product, location and across different levels of the business. 

Understanding how your organization generates costs, spends money and where improvements may be found can make all the difference when margins are tight and competition is fierce.

For business leaders determined to make informed decisions, the first step is to ensure the information at hand reflects an accurate business position. Confidence in data inputs and understanding of informational outputs help finance leaders create more accurate budgets, plan better and control cost drivers. But manual processes for gathering data, calculating variances and analyzing comparisons consume a substantial amount of time and effort that companies can scarcely afford — not to mention often delivering incomplete or error-filled results.

Challenge: Unorganized, Inconsistent Data

Faced with the challenge of obtaining and aligning data from multiple sources, most companies try their best to piece it all together. But a constant need for ever-more accurate and timely information clashes with complex and manual cost accounting processes, where methods of allocations, analysis and comparisons typically involve manual and repetitive entries, multiple tabs and dozens of summary spreadsheets.

Without timely and automated coverage and analysis of each angle and level of the business, the risk of errors and omissions increases exponentially. Missed opportunities for expansion, course correction and savings can prove costly. Like an arrow launched from a bow slightly off course, imperfect and stale data used in cost budgets and forecasts can yield wildly off target results or worse — provide an advantage for competitors.

The answer: A solid foundation on which to analyze reports and accurate, timely information to form assumptions. Both are critical in cost analysis.

Automate Cost Analysis with Oracle NetSuite

Automating repetitive tasks like data collection and reporting ensures uniformity and consistent application of rules. Accounting databases primed with this normalized data can then retrieve critical information in an organized, timely manner. That supports better decisions and frees up time for value-added activities and analysis.

NetSuite, an accounting software suite dedicated to automation, instantly captures, categorizes, calculates and analyzes transactions with synced data, automated allocations and journal entries and live dashboards and KPIs. Saved searches and configurable reports simplify analysis, ensuring that current information is automatically displayed in an organized fashion by location, product line and customizable classifications.

Forget the struggle of sorting data, updating spreadsheets and racing against time. NetSuite provides the precise data capabilities companies need for comprehensive cost analysis and automates these procedures, ensuring better control over your decisions — and your business.

Want to know more?

Our experts are more than happy to listen to your enquires and provide you with the information you need.

Related Post

How to Reduce Customer Churn as CFO

How to Reduce Customer Churn as CFO

We all know it’s more expensive to acquire new customers than keep current ones – a premise that’s especially relevant now. What CFOs may not know: Even though they aren’t involved in customer relationships day-to-day, they hold the power to dramatically reduce customer churn.

  • First off, finance chiefs can help reduce customer churn by translating raw churn rates into KPIs that serve as indicators for other teams to act on. Imagine showing the sales team its “monthly dollar churn” as a way to convey the urgency of lost ARR. 
  • CFOs can also segment lost customers by characteristics like their sales rep or acquisition date to illuminate patterns and spur their colleagues to make changes. 
  • They might also do the tough job of making a calculations-backed case to “fire” customers that just aren’t profitable.

Get the full guide to reducing customer churn as a CFO:

CFOs know that customer churn isn’t the only metric requiring extra attention in the current economy. Other insight-driving SaaS metrics – which many non-SaaS businesses can use, too – include average revenue per account (ARPA). This metric can reveal whether your pricing is appropriate in a climate where price adjustments have become especially common. If ARPA is decreasing over time, finance might prompt discussions with other teams to determine why the business is making less from new customers.

CFOs can influence metrics beyond financials, too. Use this cheat sheet, which includes marketing and sales metrics, to start:

saas metrics

Want to know more?

Our experts are more than happy to listen to your enquires and provide you with the information you need.

Related Post

A Practical Guide to Financial Modeling and Projections for Growing Businesses

A Practical Guide to Financial Modeling and Projections for Growing Businesses

CFOs are prioritizing improvements in the financial planning and analysis capabilities of their businesses in 2022. In a recent Deloitte survey, financial planning and analysis (FP&A) topped the list of the finance functions North American CFOs are focused on improving. Financial leaders also want to strengthen the data analytics and forecasting capabilities of their finance teams.

As FP&A skills become a must-have for all finance professionals, it’s worth revisiting a core analytics discipline they need to understand and can continually improve upon: financial projections and the modeling techniques used to produce them. Enhancing these skills has grown more important to remaining agile, resilient and profitable in the wake of unpredictable business, economic and supply chain events, as well as to inform strategies for future growth as the economy starts to expand.

Financial projections and the modeling techniques that shape them are in sharp focus because they help companies input assumptions, see the projected outcomes and choose the most favorable ones so they can take the best steps to move the organization forward.

Businesses of any size can take advantage of financial projections and modeling. What’s more, while much of the basic work can be done in spreadsheet applications, more sophisticated tools are now accessible for smaller organizations. This ebook will explain the value of financial projections, what information you need to get started, a few popular models and how your business can leverage these techniques to thrive and grow.

What Are Financial Projections and How Do They Differ From Forecasts?

The term financial projection is often used interchangeably with forecast, but there are key differences. Financial projections and financial forecasts are alike in that they both aim to predict outcomes based on specific assumptions. But where forecasts present the assumptions that reflect what the business expects to happen, financial projections apply a financial model to play out various assumptions to see what might happen. The output, projections, is a forecast of what might happen as a result of those assumptions along a spectrum of best-case and worst-case scenarios, what ifs and more. All that information allows the business to plan and think about its actions in the event that any of these outcomes—good, bad or neutral—occur.

In the past, forecasts provided a sort of internal map to guide business decision-making, and projections were used to show outside investors how their money would be used. For instance, if a bank gives you a loan for $200,000, what will you do with it? How do you plan to pay it back?

More recently, projections have become essential business tools to recalibrate strategies and build contingency plans in light of unanticipated supply chain disruptions, changing expectations from the workforce (like a growing preference for working remotely) and more.

Watch the Video: What is Financial Modeling?

Why Do Companies Use Financial Projections?

A financial projection predicts a likely outcome based on one or more hypothetical assumptions. Those assumptions are the inputs of the financial model, which is a statistical tool used to predict what might happen as a result of different business decisions, market scenarios and more. With that information, the model can then show the expected financial position, operational results and cash flow.

Calculating several financial projections simultaneously in order to evaluate multiple scenarios and the possible responses is a common practice. Projections help a company better plan for risks, like a natural disaster that prevents it from getting a key part from a supplier or a sudden drop in demand after a competitor launches a superior product. They also help prepare for positive outcomes, like a spike in demand for a certain product or the increased capacity from opening a third warehouse. They give the business a much better idea of how external factors will impact its financials and the adjustments and investments it needs to make to achieve its goals.

Projections cover multiple financial metrics. Revenue projections can give investors and lenders a sense of how, for example, a 20% increase in sales could impact operating expenses on the income statement. Cash flow projections show where you will get that money—from receivables, loans, a line of credit or another source. A balance sheet projection can suggest the anticipated rate of return for someone who invests in your company.

Financial projections are useful for:

  • Developing business plans. The financial section of a business plan should provide quarterly or even monthly projections for the first year and annual projections for the four years after These include projected income statements, balance sheets, cash flow statements and budgets for capital expenditures. The projections are important internally to determine everything from break-even points to growth plans, and to measure the company’s performance in its early years.
  • Informing growth strategies and business management. Financial projections show discipline in financial management, and better financial management increases the chance of overall business success in a big way. By using a financial model to make projections, you can see if, when and whether your business will make a profit with its initial business model, what could happen if it added new products or services, when to hire new people to support the company, when to make capital investments and their potential payoff, and
  • Due diligence for investors and lenders. The people and institutions investing and lending money will need to see proof that you can pay them back, and have a solid understanding of how you plan to do that. Some common benchmarks to project include how long it will take until the company turns a profit, sales in years three and five and data showing how your numbers compare to industry standards.

What Do You Need to Get Started?

Both financial forecasts and financial projections rely on current and historical transactional data, coupled with information on market conditions and industry trends.

Financial projections take the analysis a step further by applying a financial model to determine how certain variables will change the assumptions. Financial projections use information from current and past financial statements and external market information from government agencies, such as the U.S. Department of Labor, or market and industry projections from leading research and advisory firms.

Many finance leaders complete their first models in a spreadsheet program like Microsoft Excel, and the formulas allow you to model assumptions you’ve made. To build a financial model, you will ideally have at least three years of historical data, and the Journal of Accountancy provides a comprehensive list of financial data and metrics to include, such as:

  • Revenue (including revenue levers, drivers, revenue driver activity assumptions and pricing)
  • Cost of sales
  • Selling, general and administrative (SG&A) expenses
  • Capital investments

Oftentimes, the hardest part for startups and younger small businesses is getting these numbers in the first place.

Startups often run into the problem of trying to figure out what data to use for the foundation of their financial models since they have little to no sales history or metrics to work from. One source is industry and market research, like Standard and Poor’s (S&P) or Dun & Bradstreet, which provide national averages for businesses in different markets.

Newer companies can then pare down that information into the numbers most relevant to their organization. These figures can include the standard costs of revenue in every industry, the percentage of revenue attributed to the direct cost of sales or what percentage of revenue goes to overhead.

Another approach is to base calculations on the market share you want to capture in a certain time frame (top-down) or based on the resources at hand and the current data (bottom- up). Bottom-up forecasts are usually best for the shorter term (one to two years) and top-down for the longer term (three to five years). Used together, these two strategies offer a healthy balance between ambition and the reality of how much market share you can capture.

What Financial Models Should My Business Use?

Once you have these inputs, you can build and apply a financial model.

The three-statement model is the most important financial model and the one on which every other financial model is based.

True to its namesake, it takes the three core financial statements—income statement, balance sheet and cash flow statement—and uses assumptions and formulas to create a forecast for a given time period. The forecast starts with revenue and can also calculate expenses, debtors, creditors, fixed assets and more. Once the three-statement financial model is in place, employees can apply other financial models to conduct scenario planning and sensitivity analysis.

An employee building a financial model in a spreadsheet will create tabs for the income statement (showing revenue and expenses), balance sheet (detailing assets and liabilities), cash flow statement (money in versus money out), capital expenses and depreciation costs to establish a clear picture of the current financial health of its business. A finance professional then uses the assumptions as inputs and applies formulas to drive outputs that are projections. On the income statement, for example, assumptions can include revenue, average order value, refunds as a percentage of revenue, discounts as a percentage of revenue, cost of goods sold (COGS) as a percentage of revenue and operating expenses as a percentage of revenue.

Once the three-statement financial model is in place, other financial models can be applied to further understand the impact of various assumptions. These include:

  • Sensitivity Analysis (What-If Analysis): A sensitivity analysis shows the effects of changes in assumptions such as selling price, supply chain costs, fixed costs, forecasted sales, delivery costs and other Sensitivity analysis models generally change one variable at a time and then demonstrate the impact of that change. For instance: How does changing the price of packaging or the advertising budget affect the forecast? Can the company boost profits if it changes the average selling price? For this reason, sensitivity analysis is also called what-if analysis. It challenges the person looking at the numbers to consider the reliability of the assumptions made. What happens if actual results turn out to be much different than expectations? Which factors have the biggest impact on the forecast or projections?
  • Scenario Analysis: This financial model is closely related to sensitivity analysis but involves changing all or many variables at the same time, rather than one at a time. A scenario analysis looks at what happened in the past and what could happen in the future, including major changes that would have a lasting impact on the company. It typically includes base-case, worst-case and best-case scenarios. Scenario analysis could be used, for instance, to model the impact on total revenue of launching a direct-to-consumer channel, adding a new enterprise customer or, on the more challenging end, a natural disaster or the loss of a critical customer.
  • Strategic Forecast Model: Businesses use a strategic forecast model to see how various initiatives they’re considering would affect long-term, strategic Also called long-range forecasting, this model helps organizations evaluate the impact of corporate projects, major finance initiatives and marketing and analysis plans on its long-term strategy. For example, a company may use the strategic forecast model to project the costs and potential revenue of opening a second manufacturing plant, building stores in another country or launching a new product line. It can then help leaders determine whether it’s in the business’s best interest to pursue those projects.
  • Discounted Cash Flow Analysis: A dollar today is always worth more than a dollar two years from now. If you do nothing to your business and it makes a predictable amount of money each month, you know your cash flow. If you make an investment now—acquiring another company, for instance—that will produce new revenue streams in the future, that future money is not worth as much on a dollar- per-dollar basis as the money you’re spending right now. If you have a customer who is ready to sign a five-year contract to purchase a specific quantity of your product, that’s the basis for your new investment. As long as that customer has a strong business, you have a sure thing— you know the company will receive a certain amount of income for five years. You can use the interest rate on some other sure thing (like a five-year Treasury bill) to determine your discounted cash flow. If your estimated return on investments has historically been 90% of what you initially expected, then your discount rate needs to reflect that. In that way, your discount rate reflects both what you could earn if you just invested the money, plus a measure of risk based on market trends, your own history or both. You’ll use that discount rate to calculate the net present value of your investment, and if it’s positive, you’re making a good investment.

Calculating the net present value of investments is the best way to determine whether an investment is a good one or not. But the quality of calculation is highly dependent on your ability to set the right discount rate.

Step-by-Step Guide to Creating Financial Projections

While many finance departments rely on customized spreadsheets to do financial modeling and impact analysis for these models, there are several issues with this approach. Spreadsheets are challenging to manage, lack data transparency and integrity, do not integrate with operational plans, and are generally not efficient at handling financial modeling activities.

With planning and budgeting software, models don’t have to be created from scratch every time an executive asks for a projection. Cloud-based planning solutions enable users to create and compare multiple models that incorporate real- time financial and operational data. Since there’s less legwork required, the business can scale and apply this type of analysis to more business decisions, leading to faster insights for decision-makers. Despite those clear benefits, only 11% of small businesses surveyed by Robert Half said they have automated their financial modeling practices.

Small businesses just getting started with financial planning can create a basic model in Excel by following these steps below. 

1. Create a new spreadsheet and label the first row “Assumptions.” Label columns B, C, and D with three future fiscal In these columns, you’ll make predictions about your performance in each of those years for a variety of metrics.

2. Label rows with revenue, units, price, COGS and operating expenses like marketing, labor or other categories of expenses that are relevant to your business.

3. Fill in the values with your assumptions, based on financial forecasts and your current financial Use a font color that is easily distinguished from black in the corresponding cells (like blue). Remember to format any dollar figures with the accounting number format by right- clicking the cells, going to “format cells” and selecting “accounting” in the “numbers” tab.

4. This is a good time to freeze panes. To do this, highlight cell B4 or its equivalent in your worksheet, go to “View” in the task bar, and click “Freeze panes.” This keeps your labels visible as you toggle around in the If you pay attention to the row numbers as we move on, you’ll see how this improves readability.

5. Next, move down a couple of rows to start calculating projections for your income statement, beginning with net The font for these values will be black. You will run the numbers in your assumptions through a formula to calculate net revenues by multiplying units by price (=B6*B7 in the sample from Figure 1). Copy and paste the formula to the next two cells to the right. The spreadsheet should automatically apply the formula appropriately for the year you’re working in, but it’s a good idea to make sure that it did by double-clicking the cell to view the formula. Ensure that the letters match the column for that cell. Make sure your number formatting is set to “accounting.”

6. Calculate COGS by multiplying units by unit cost (=B6*B10 in our example). Just as before, copy and paste that formula in the two cells to the right, checking to make sure it was applied appropriately for each column. Check your number formatting to ensure that it’s “accounting.”

Now, the format of your worksheet should resemble Figure 2.

7. Still within the income statement area, calculate gross profit by subtracting COGS from net revenue (=B18–B20 in our example). Copy and paste the formula to the next two cells to the Check the formulas and the number formatting for the correct column and “accounting.”

8. If you would like to see margins, you can divide the gross profit by revenue (=B22/B18 in Figure 3) and change the number format to percentage so you get the gross profit percentage.

9. While still within the income statement, calculate operating For our sample, this included labor and marketing in our assumptions—you may want to include additional costs—and we will reflect those same expenses in the income statement. Remember that you don’t want to enter the same value in two cells, so fill in these cells by using a formula to pull numbers from the source in the assumptions. In this example, we would compute labor for 2020 by entering =B13 because we got that number from the assumptions. That way, if we change the assumption later, the income statement will adjust along with it. Repeat this step for the remaining five cells in the operating expenses section of the income statement. Check your number formatting.

10. Calculate the total for operating expenses by adding all of the costs in this section together. In our case, we can simply add labor and marketing, but if you have more than two items here, you can use the sum formula. As always, check the number formatting.

11. Calculate operating income by subtracting operating expenses from gross profit (=B22–B28 in Figure 5, see next page). Copy and paste the formula in the cells to the Check your formula and number formatting.

12. Determine operating income margins by dividing operating income by revenue (=B30/B18 in Figure 5, see next page). Again, copy and paste the formula for the next two years, and check your formulas and change the number format to “Percentage.”

Now you have built a dynamic model using best practices that automatically calculates gross and operating margins as you change assumptions. While this is a basic model, it’s one of many that can help you set goals and make decisions for your company. It quickly gives you an idea of what your finances would look like based on projected revenue and expenses, and you could create multiple versions based on expected, high or low sales estimates.

Enabling Easier, Accurate Financial Projections With Software

There are clear advantages to automating financial modeling capabilities with a planning and budgeting tool. Software can process more data and create visualizations to make projections easier to consume and glean information from.

The automation enabled by these systems means less time spent finding and entering data, and more time using the outputs of the model to inform and shape business decisions.

But any investment in automated financial modeling or manual calculations will be for naught without reliable, accurate inputs. That’s why it’s so important to start any journey to financial analysis by first automating as many accounting and finance processes as possible, since all other activities will use those numbers. As noted earlier, accurate financial statements are the baseline for solid financial analysis. In that sense, an ERP platform with robust financial planning capabilities like NetSuite often serves as the foundation for financial modeling and projections. Having a central database that updates in real time assures decision-makers that they’re using trustworthy numbers across all departments.

That single source of information helps financial planning and analysis teams overcome their chief challenge: data collection.

One survey found that the teams spend 75% of their time gathering and processing data. A system like NetSuite Planning and Budgeting eliminates that work by automatically pulling in historical data and applying it to pre-built, industry-specific statistical models that include revenue and expense modeling. That allows businesses to more accurately model what-if scenarios and predict potential results. NetSuite’s planning and budgeting application then generates a dashboard summarizing those predictions, and users can apply predicted values directly into their plan or forecast. Finally, the module eases the presentation of those results with drag-and-drop capabilities to build reports for different audiences and make it easier to share them with various stakeholders.

Financial models and projections have become increasingly crucial for finance teams. As companies become more aware of the various risks that could have a dramatic impact on their operations and revenue, they’re doing everything they can to plan for such events and avoid scrambling. Although financial modeling may sound daunting, anyone with a basic understanding of your finances should be able to perform basic projections. An ERP solution and planning and budgeting software will take your efforts to the next level and make more complicated and frequent projections feasible.

Want to know more?

Our experts are more than happy to listen to your enquires and provide you with the information you need.

Related Post

7 Strategies for Growth

7 Strategies for Growth

It’s been 60 years since U.S. business leaders have had the chance to ride a 6% GDP expansion. Grabbing more than your share of new business requires innovative pricing, supply chain and customer acquisition actions. Our 7 strategic pillars range from fulfill inventory anywhere to making metric-driven decisions and capturing new revenue streams.

By Art Wittmann

We are in the midst of the biggest single-year economic expansion since the 1960s. That’s the consensus from the International Monetary Fund, various U.S. government agencies, the Federal Reserve and most leading economists. The Conference Board predicts 6% U.S. GDP growth for 2021 after a 3.5% decline in 2020, and the Bureau of Labor Statistics confirms that, in the first quarter of 2021, the country topped that 6% annualized figure.

With almost no institutional memory of those halcyon days of the 1960s remaining in C-suites, however, optimizing for success is uncharted territory for business leaders. Capitalizing on this opportunity will come down to planning, positioning and a careful reading of — and quick reaction to — incoming data.

To drive thinking about how to capitalize on the boom now underway, we’ve identified seven areas that warrant strategic consideration. We’ll discuss each briefly here, with links to some deeper dives, and continue to provide best practices as the year progresses.

As with any forecast, that 6% projection from The Conference Board comes with risk factors — both downside and upside. Keeping these in mind will help temper expectations and shape your own best practices.

Of all of these, the only risk that business leaders directly control is a productivity boost driven by digitalization. We will therefore recommend best practices for technology use throughout our discussion. Still, upside risks are more likely than downside, with the exception of unstable worldwide supply chains. In other words, if you aren’t already, treat this boom as fact, not forecast.

It’s time to move fast and make money.

Supply Chain Responsiveness

Many supply chains will remain unsettled through 2021, and some of the biggest, most sophisticated global manufacturers are affected. It’s been headline news that most automakers are slowing production because they can’t get the microchips they need. In the worst cases, some manufacturers will produce only half of their capacity in the coming months.

And yet, at least one Japanese automaker says its production won’t be affected because it has a four-month supply of these critical components on hand.

Clairvoyance, a fluke or exceptionally good luck?

None of the above, actually. These critical parts come from only a few foundries in Hong Kong and Taiwan, and this automaker understands the threats endemic to that region. It also calculated that the carrying costs of a four-month supply of chips isn’t all that high. So it stocked up, just in case.

The company didn’t take the same approach with other components, ranging from glass and leather to the myriad subassemblies that go into cars. It had multiple sources for these materials, and the risk of those supplies failing to appear on time was low.

Granted, that simplified explanation belies the intense statistical analysis that carmakers apply to their supply chains. But it is a useful anecdote to illustrate the need for differentiated supplier management.

Point is, when a necessary component is available from only a limited number of suppliers in a small geographic area, companies should carry more safety stock. That is, unless that supply chain hadn’t been substantially disrupted in decades, as was more or less the case for chips and other raw materials and finished goods coming from Pacific Rim countries.

A tanker blocking the Suez Canal. Brexit. A ransomware attack shutting down a major petroleum pipeline. Nobody would blame a supply chain manager for dismissing risks not seen in years, or ever. And if you had foreseen and presented a case to buy a few months’ worth of chips, leaders in the throes of the just-in-time craze would likely have dismissed your concerns as improbable — in which case, Scarlett Johansson or Morgan Freeman will play you in the upcoming sci-fi blockbuster about the one lone manager who knew a disaster was looming.

Action Items

  • Diversify — no matter your company size: Big manufacturers know all about supply chain In our example above, Hong Kong and Taiwan are just 450 miles apart in the South China Sea. The political environment alone should be cause for significant concern. Whether you take a highly rigorous statistical approach or rely on your teams’ understanding of your supply chain, there’s a clear mandate to diversify if you can, hold more safety stock if you can’t. Geographic diversification is a first line of defense for critical supplies, and the time to develop those relationships is before there’s a crisis.
  • Adopt a hybrid JIT/JIC inventory approach: An obsession with just-in-time inventory — getting components in the door just before they’re needed on the line — is both ingrained and increasingly old school. When critical items are not available from multiple suppliers in geographically diverse parts of the world, carrying a larger stock of those items — a hybridized just-in-case model — is now the norm. Of course, you need to weigh carrying costs. A few months’ supply of microchips could probably fit in the automaker CEO’s conference room. Not so with most of the components it takes to make a car. And for most companies, carrying months of inventory of anything will impact cash flow. CFOs will want to bring a careful analysis to bear, but going forward, we expect a hybrid JIC/JIT inventory management strategy to become the norm. In the real world, it’s not one or the other.
  • Hone supply chain visibility and demand planning: If critical stock is an issue and carrying costs threaten margins, it’s time to The 80/20 rule states that 80% of results — sales, and more importantly, profits — come from 20% of efforts, customers or another unit of measurement, often a comparatively small set of products or services. An ABC inventory analysis exercise, where you group SKUs based on demand, cost and risk data, will typically reveal production priorities. Companies with a good grasp of unit economics tend to gain significant clarity. Hopefully, implementing systems and gathering data to better manage demand planning and supply chains, create forecasts and understand unit economics were part of your work in 2020. If not, now is the time.

Capturing New Revenue Streams

As we’ve discussed, the opportunity for substantial growth should extend into 2022, especially for businesses poised to capitalize on the opportunities that emerged in 2020. There are some challenges — disrupted supply chains, skills gaps, distribution and customer acquisition costs — we know will remain as headwinds. It’s less certain whether inflation and policies to manage it from central banks around the world will be a factor.

While the Fed increased its U.S. inflation forecast for 2021 from 1.8% in December to 2.2% in March, officials have long predicted “transitory inflation” as the economy reopens. With spiking demand for everything from rental cars to lumber, most experts don’t expect reactionary tightening of monetary policy as of now. But those March Fed numbers are way too optimistic. The U.S. Bureau of Economic Analysis says Q1 inflation clocked in at 6.4%. So unless we see some deflation in coming quarters, 2.2% for the year is a virtual impossibility.

CFOs need to chart a range of inflation scenarios and have plans in place for pricing strategy, supply chain diversification and how raising the cost of your goods and services might affect customer acquisition and retention. Standard customer churn analysis can shed light on the latter two factors.

One thing is for sure: Finance teams will have their hands full as they determine risks and margins with new revenue streams.

Action Items

  • Make that “temporary” new revenue channel permanent: Many companies planned for or opened new revenue channels in 2020, and that experience is a huge It may be tempting to look at those moves as temporary. Some owners of high-end restaurants, for instance, have talked about ending their takeout programs. They don’t want to compete in that market with what they consider to be inferior versions of their products. That’s a fair point. But most businesses, like manufacturers that stood up direct-to-consumer ecommerce sites or firms that dabbled in the subscription economy, will be happy to continue nurturing new revenue streams as long as the customer experience and margins remain acceptable.
  • Overcome the pricing challenge: Pricing may be one of the trickier factors to get right during the recovery, so it’s well worth adopting an analytical approach. Consumers with cash and pent-up demand don’t seem to be highly price conscious — at this point, simply being able to deliver goods and services that are in demand is a strong differentiator. At the same time, workers aren’t rushing back to jobs that both paid low wages and put them in harm’s way, whether from the virus or belligerent customers, so labor costs may rise. Want to get really serious about revamping your pricing? Consider adding a chief revenue officer to focus not just on price but on overall customer happiness and revenue optimization.
  • Make scenario planning part of your DNA: Everything from unit costs to customer satisfaction will likely be in flux over the next 12 to 18 Price hikes acceptable to the market could get chewed up by increases in other areas. 2020 required fine-tuned financial analysis to survive; 2021 and 2022 will require that level of analysis to thrive. Those scenario planning skills you gained in 2020? Refine and refocus plans as the level of unevenness in the recovery becomes apparent. Didn’t get started? There are a number of templates and formalized frameworks. What’s important is choosing a method that works for your team.

Flexible Fulfillment

This past year saw a number of customer engagement trends accelerate. Ecommerce took off as consumers became comfortable shopping for more, and more types of, goods from their homes. Manufacturers learned how to sell directly to consumers, and many traditional retailers doubled down on their already effective omnichannel approaches.

In service of those new channels, marketers are pushing hard on their own new ways to attract attention, from engaging social media influencers to flooding consumers with retargeted ads. And it’s working. Those efforts are bringing in new business that helps offset losses due to restricted in-person selling. And, in many cases, those new sales are via new fulfillment channels.

This year, the challenge is keeping customers happy with fast and predictable fulfillment. Success is bound to your ability to manage inventory holistically.

Action Items

  • Connect inventory, fulfillment and ecommerce: Managing customer expectations as delivery services struggle to keep up is perhaps the most challenging part of opening and maintaining new sales channels. Businesses with storefronts can fulfill many orders and ease returns using existing facilities, leading to the rise of BOPIS. But success with “buy online, pick up in store” requires centralized inventory management, ideally connected to your order fulfillment system. Further, since ecommerce often accounts for a significant share of sales, those systems should connect to the ecommerce engine so that customers can see what’s in stock and when orders will be ready. Whether or not your business has a network of stores, it’s smart to think about alternate fulfillment channels. If business is brisk and getting serious about new channels will make it more so, using third-party logistics (3PL) companies for fulfillment is a good short-term strategy — and potentially long term as well, depending on your profit margin target and current fulfillment capabilities. If your operation is geared to fulfilling orders in pallet volumes, 3PL companies can help with smaller orders.
  • Beef up new ecommerce systems: In some cases, the ecommerce sites businesses stood up last year showed a fraction of available inventory or offered only rudimentary ecommerce functionality. For some, these sites were a first, quick foray into selling direct to consumers (D2C); for others, it was a way to sell unique goods, like PPE, that required a different channel than a direct sales team. Now it’s time to refine websites to offer more products, take better advantage of data for personalization programs and improve the ecommerce customer experience, including adding the ability to track shipments, estimate when orders will be fulfilled and accurately show available inventory. Success with every bit of this requires tying fulfillment management to the ecommerce site as well as tracking new order fulfillment and inventory KPIs.
  • Automate fulfillment: It’s a theme we’ll return to repeatedly. Automation is the next logical step once you’ve implemented cloud-based business and fulfillment/order management systems. A primary task when automating any process is to build in your business rules so that the system handles new transactions properly, minus the inefficient, legacy processes that are likely slowing you down now. Some rules are fairly generic. Say a customer pays for two-day delivery; that order goes toward the head of the FedEx or DHL queue. Other rules may be highly specific to your business. Perhaps long-term or high-value customers get full shipments of popular products, while smaller or newer retailers may receive only partial orders. Without automation, managing complex business fulfillment rules is an error-prone and confusing matter for staff. With automation initiatives to fine-tune business rules are more likely to come off without a hitch.

Automation for Scale

Automation, like exercising and reading more, always makes the annual resolutions list but never quite bubbles to the top. 2020 likely changed that. Whether it was to better support remote work, enable scenario planning or remote closes, get serious about ecommerce, improve supply chain management or all of the above, lots of companies at least laid the groundwork for automation.

So, unlike using the treadmill that’s now draped in clothes and shame, the automation resolution is one you can and should keep.

Adding better digital systems, or finally fully using existing capabilities, helped lots companies get through 2020. Now, many are looking at taking the next steps toward eliminating the rote, slow, error-prone, human-based processes that suck the life out of staffers and leave decision- makers with incomplete or suspect data. Once digitalization happens, leaders not only get more timely and accurate insights, they have more staff resources to devote to interpreting and acting on them.

Capturing that 6% expected growth for the second half of the year requires a fresh look at automation — it can be the difference between winning new business versus ceding ground to competitors because you’re too busy reading spreadsheets.

Action Items

  • Plan automation holistically: Automation by its nature needs to be a holistic exercise — develop a vision of your perfect system, then chip away at making it reality. Think about self-driving cars. Automating steering, acceleration and braking separately without a plan of how you’ll tie them together won’t get you a vehicle that safely drives itself. In business, operations groups want automatic visibility into activities across the company. Sales wants to acquire new customers and sell more to existing Marketing wants to understand the results of its campaigns. Production wants to automatically monitor supply chains, stock levels and output. And finally, finance wants to automate closes, AP and AR and get more timely data to improve its ability to provide financial planning and analysis for the company. But to really grow in a scalable way, sales needs to know about inventory and production. Marketing needs to know which products produce the most revenue and profit, and production needs to track sales forecasts so that it’s churning out items that are in demand. And finance needs a high-level understanding of how all these functions are performing so that it can guide the business toward growth and profit. That sort of powerful integrated business planning starts with a vision of data sharing as a means of empowering each part of the company to be better and more efficient at what it does.
  • Define processes, set business rules, repeat: As with automating fulfillment, a customer might get discounts if it maintains a $10,000-per-month spend, for example, while in another company that threshold might be $25,000. With automation, you define these rules in the applications you’re using and let the system implement them consistently and automatically. Rules can define how you recognize revenue, when you order more stock, how you set production quotas — whatever makes your company tick. What was once manual now happens according to defined policies, including requirements for approvals of various actions. Automated tasks happen faster and with fewer errors. Fraud is minimized. KPIs and dashboards are created automatically for executives, freeing up managers’ time to pay more attention to the business. In the end, you get more consistency, more timely data and more effective use of staff. All of which are needed to capitalize on current growth opportunities.
  • Drive payoffs in efficiency and productivity: On average, larger businesses drive more revenue on a per-employee basis than smaller ones, and automation is a big reason With automation, marketers can manage more campaigns, sales teams can deal with more customers and finance teams need fewer resources to close the books. This efficiency accrues with time, so it can be difficult — though not impossible — to lower your headcount through automation. Instead, a growing company shouldn’t need to add employees as rapidly as it would if it hadn’t automated its processes. That’s a critical competitive edge as you compete for talent. And, staff time moves from the tactical job of entering and verifying data to the strategic job of using that data to deliver better products and services. In other words, the ROI should be apparent early on, and break even on the investment should follow fast.

Operate from Anywhere

Of the practices that got businesses through 2020, “work from home” was paramount. For those employees able to function remotely, productivity turned out to be surprisingly high, and morale often flourished as work got done, and done well. Various business leaders have expressed a full range of opinions on whether and how the practice should continue, and CFOs likely have their own thoughts on the matter in light of the tangle of tax implications that come with a geographically dispersed workforce.

Still, workers whose jobs allow are clearly for either a work-from-anywhere policy or a flexible arrangement, with some days in the office and others at home. In 2021, a strict “back to the cube farm” stance may cost you talent.

Whether you can, and/or intend to, allow remote work once restrictions are fully lifted, it’s smart to at least retain the muscle memory because things happen: Pipes break, hiring accelerates faster than you can add space, blizzards close schools. Coping is easier with remote-work capabilities and protocols in place.

Because employees favor it and productivity seems to benefit, we advocate flexibility. First, talent doesn’t have a zip code. If you find a perfect marketer or data analyst in Montana, it’s worth considering a fully remote arrangement. That same worker in San Francisco or Boston is likely going to cost a lot more, and some highly talented people are longing for more open spaces.

  • Adopt a cloud-centric policy for software systems: Assuming a hybrid or fully remote schedule works for your company, several actions taken in 2020 should now be made permanent. Primary among them is providing the tools workers need, preferably delivered from the cloud. Cloud providers live and die by the reliability and security of their products. Even the largest companies will be challenged to implement in-house versions of collaboration, productivity and core business systems that perform as well and reliably as cloud-based alternatives. Software delivered in an as-a-service model performs no matter where people are working and often costs less to boot.
  • Rethink your real estate: There are savings to be gained by providing employees with the flexibility they First, losing the commute increases hours worked, surveys show. Flexible schedules also give employers the opportunity to rethink how they use office space, including whether they need as much as they have. But don’t limit your thinking to simply number of workstations or square footage. Tuning for collaboration without the need to give everyone a desk can be a game changer. For example, an emerging trend is tracking work output versus hours logged. In a recent survey, only 36% of employees at organizations with standard, 9-to-5, 40-hour workweeks were classified as high performers compared with 55% at companies that offer employees choice in when and where they work. Maybe some people want to come back more or less full time, while others want to drop in on an irregular schedule to sit in on meetings. As with software, when thinking about office design, focus on flexibility.
  • Rethink core HR processes: All that sounds But some of you are thinking, “In the real world, there are challenges with remote workers, particularly new ones.” Getting them going on the technology kit is tricky, as is integrating new hires into the company and work team’s culture. That’s where HR comes in. Remote onboarding is its own discipline, all about bringing new employees up to speed so they’re productive, engaged and working toward company goals no matter where that work is done. This begins with the hiring process and continues with orientation, training and ongoing bi-directional feedback. Rethinking onboarding with a nod toward simplification and coworker mentoring will go a long way.

Metric-Driven Decisions

March 2020 demanded we make business decisions without much to back them up. There simply wasn’t data about how a once-in-a-century pandemic would impact global business and when to expect a recovery. Over in a few months? Years? Nobody could predict the extent of lockdowns. Hitting the brakes hard was a common first instinct, but for some it was an overreaction that left room for more daring competitors to take market share.

The sharp spike followed by a recovery in the unemployment rate is a good primary indicator of this overreaction.

Bottom line: There is a boom, but it’s a lumpy one, and if you expect workers to come back for less than $10 per hour, that’s probably not going to happen. On the other hand, consumer spending is also booming. Airports are packed. Many service-sector businesses simply can’t meet demand. If there was ever a time for careful data analysis, this is it.

But now, entering into what appears to be a V-shaped recovery, we do have data. Much of it is good, but not all of it. We’ve already talked about the worldwide supply chain issues that are likely to persist. Housing stock is below demand, building material prices are spiking, rental cars are impossible to get and summer gas shortages are predicted. Unemployment remains high even as companies are plagued by skills shortages. In March 2021, there were more unfilled job openings than during any month since we began recording that data more than 20 years ago.

Action Items

  • Expand your data view: Analysis needs to consider internal and external data sources. If that hasn’t been part of your approach, this is a good time to fix that. It’s also a good time for B2B companies to reach out to customers to gauge their own business outlooks and expected demand for your goods and services. They’ll be eager to hear how confident you are in terms of fulfilling their orders. Most B2C companies are seeing the result of pent-up demand. However, goods from appliances to furniture are currently in short supply, and so are the parts to make them. So your analysis needs to broaden to include the economic forces at hand. Demand planning is a cross-functional, data-driven process that helps businesses meet their customers’ needs without overshooting on inventory.
  • Instrument your operations: Do you have systems in place to report on operations throughout the business, from sales engagements to marketing lead generation to raw materials costs? How about traditional finance metrics ranging from the big three — cash flow, revenue and profits — to more tactical but still highly important measures that provide insights on efficiency and progress? For instance, customer acquisition costs are rising for many sectors and, in some cases, threaten to substantially reduce margins. But CAC is only one factor in customer lifetime value, and only one of many critical financial metrics to track. Your challenges may be around rising supply or shipping costs, or higher wage demands. In the current red-hot market, choosing the right KPIs is more important than ever.
  • Make financial analysis continuous: Whether or not your business had the right data to support scenario planning in 2020, most found a way to make plans for various contingencies. For finance teams, that often meant 55-hour-plus workweeks as they labored to understand cash flows, unit economics and other critical metrics that they’d never studied at the frequency or detail now required. Teams that had ERP systems in place, or that implemented them in 2020, have an automated way to gather data for ongoing financial analysis. As the volume and velocity of business increases in 2021, manual methods of analyzing data will be a strategic disadvantage.

Raising Capital

Is now the time to seek funding? A merger or acquisition target? Take your company public? There’s a lot of money out there looking for a home in a strong market. Many firms believe they could achieve growth, if they can just get some cash to seize the moment.

Attracting the attention of equity investors will require demonstrated growth and a clear path to profit for young companies — this was a loud trend heading into 2020, following a few years of perhaps irrational exuberance, and it’s here to stay.

If that sounds like you and your Rolodex doesn’t include many venture capitalists, get yourself to a pitch contest and make the case. Otherwise, consider other options.

Action Items

  • Don’t count on bank loans, which are likely to be more scarce after post-relief funding: Last year saw the federal government loan or grant hundreds of billions of dollars to businesses in the form of Paycheck Protection Program (PPP) loans and Economic Injury Disaster Loans. Some of that continued in this year’s pandemic relief bill, including targeted funds for the businesses most impacted, like restaurants and entertainment venues. Some money is still out there, but prospects for future government stimulus remain uncertain. As loan and grant programs wind down, regular bank loans will pick up again. However, if trends continue, total loan pools will slowly shrink. In 2007, banks held $721 billion in loans of $1 million or less, according to The Wall Street Journal. In 2019, that was down to $680 billion. Meanwhile, bigger business loans more than doubled during that period to $2.82 trillion. So, while loans to smaller businesses aren’t unheard of, the underwriting standards are historically tight.
  • If you’re angling for private equity funding, get your Rolodex out: Private equity is a path between conservative banks and high-growth-focused VCs. Last year as a group, PE funds raised over $200 billion, with much of it going to help stabilize companies that PEs already owned. Beyond that, tech/ IT deals grew by over 72%, according to PitchBook. Still, that’s only about one-third of PE investing — and an anemic number compared with the $2.9 trillion that’s sitting with PE companies uninvested.
  • The M&A market looks promising, so be bold: If fast growth and/or diversification are on your agenda, a merger or acquisition may make sense in 2021. Private equity plays here too, backing over one-quarter of last year’s M&A activity in 2020. Particularly for established businesses that have solid customer bases but aren’t up for making the technology investments seen as critical for success in 2021 and beyond, selling to, or buying, a company with tech chops may be the best course. For many such deals, you just need a few lawyers, an idea of your valuation and an interested buyer. In some sectors, that may be a SPAC or PE firm, or more commonly, you may have a complementary business in mind to sell to or buy. If yours is one of the sectors that’s turning sharply up, creating a win/win scenario should be very possible. As with a valuation exercise, stress your assets: historically strong cash flow, a healthy profit margin, high customer lifetime value, low employee churn, bookings for the near future. Larger firms can position themselves for acquisition by increasing margins or adopting key technologies popular within their sectors, but unless that’s been a work in progress, it’s likely your books will do most of the talking. Finally, while there is VC money up for grabs right now, historically this has been a small, albeit extremely visible, niche within the financing market. Venture investments hit $125 billion in the first quarter of 2021. That’s up 50% from the previous quarter and a 94% jump from a year ago. Crunchbase details how this money is distributed. The lion’s share goes to late-stage companies — that is, those that already have ties to VCs. Most, though certainly not all, early-stage investment also goes to companies familiar to VCs. If you believe you have a shot, here’s how to get some attention. But there are plenty of other funding sources. If you’re outside the tech hubs where VCs roam, a different finance route may be more doable.

Want to know more?

Our experts are more than happy to listen to your enquires and provide you with the information you need.

Related Post

Understand Which ERP Modules Your Business Needs – And When

Understand Which ERP Modules Your Business Needs – And When

What Are ERP Modules?

An Enterprise Resource Planning (ERP) system is like the central nervous system for a business, collecting and organizing key information to support lean, efficient operations, even as it expands. The ERP platform automates business processes and provides insights and internal

controls, drawing on a central database that collects inputs from various departments.

Once information is compiled in that central database, leaders gain cross-departmental visibility that empowers them to analyze various scenarios, discover process improvements and generate major efficiency gains. That translates to cost savings and better productivity as people spend less time digging for needed data or completing mundane tasks.

ERP systems typically come with several modules that are like building blocks for the software used to run the world’s businesses, whether they make hundreds of thousands or hundreds of billions of dollars in revenue every year. Each module brings a bundle of functionality that helps complete

a particular process, or a part of that process. These building blocks help various departments, from finance to supply chain to human resources to sales, perform their individual functions. The modules connect to the ERP’s common database and should easily integrate with one another to ensure every department has accurate, consistent

data and support interconnected business processes. The end game is that employees can access the information they need to answer questions about their department’s current performance, target areas for improvement, assist with future planning and collaborate with other teams.

Again, all of these modules interact with each other in a way that often augments their capabilities. For example, an ecommerce manager can find the original purchase order for a particular product

to ensure an upcoming promotion will still leave room for an acceptable profit margin. The finance department may review data that originates in the CRM about salespeople’s commission earnings to make sure they’re compensated appropriately.

Years ago, an on-premises ERP was the sole option, and privy only to the largest, most deep-pocketed companies. ERP implementations were extensive and extremely time-consuming projects, so many companies implemented everything at once, maybe never even “turning on” or under-using certain modules. They may not have needed that functionality right away but took a just-in-case approach to ensure they could leverage it,

if necessary, without enduring another lengthy project.

Then came the cloud, which revolutionized ERP by vastly simplifying the process of implementing a system and scaling its functionality.

For the first time, the promise of modular ERP was truly fulfilled—the company didn’t have to build out the hosting infrastructure and implement a bulky system, but rather could start with only the functionality it needed and add more as it evolved.

The cloud put the benefits of ERP within reach of the smallest businesses since it removed the long, painful implementations and high upfront costs of legacy systems. The subscription-based pricing of a cloud system played a part here, too. ERP could be taken off the balance sheet as a capital project, and put onto the books as an operating expense, meaning functionality could be implemented and paid for as the business actually needed it.

So what can these ERP modules do and how can your business start to put them together to build a competitive advantage?

12 Key ERP Modules and How to Use Them

A finance ERP module, which handles accounting, cash management, financial reporting and basic budgeting, is typically the first one a business implements, because getting accurate “numbers” is the basis for driving and measuring efficiency across the organization. More than half of small- to-midsize companies said they use some or only cloud-based software for finance and accounting in a recent survey by Robert Half. At the same time, the number of smaller businesses that report relying on Excel for budgeting and planning has dropped significantly over the last few years.

Modules that manage processes related to Human Capital Management (HCM), including workforce management, are often implemented alongside

or within quick succession of the finance module. This is software that manages everything related to your employees—from benefits, to personnel information for each member of your staff, to benefits—and payroll, a feature most businesses need early on.

As the business grows and needs to improve how it manages inventory, customer orders or purchase orders, it will bolt on new functionality, all of which draws information from and feeds information

into the same database to maintain a single source of accurate information. The data in one module drives information or outcomes in another—the true value of an ERP system.

Companies typically build their ERP landscape by adopting these modules first:

  • Finance. This module includes standard bookkeeping functionality, automatically updating the general ledger and tracking accounts receivable and accounts payable. It can handle account reconciliations to help the accounting department close the books in a timely manner. The finance module often has billing capabilities, as well as functionality to generate key financial statements like balance sheets, profit and loss statements and cash flow statements. Tools that automate complex calculations such as revenue recognition, consolidation of data from various subsidiaries or business units for reporting purposes and planning and budgeting may be grouped in here, as well. Companies typically adopt an ERP module to handle finance when their needs outgrow the limited functionality of accounting software designed for small organizations. For instance, a company may need this application when its transaction volume gets too high, and it can’t easily produce the financial statements required for statutory and regulatory compliance. Or perhaps it requires support for multiple currencies.The finance application enables a company to gain real-time visibility into its cash position and makes for a faster, easier month-end close.
  • Human Capital Management (HCM). Establishing strong control over data and processes related to people, such as payroll and employee records, is a must-have for any business with more than a few An HCM module stores employee data in a central location and tracks the basic information—like salary or hourly rate, reporting structure and paid time off—that’s needed to accurately calculate payroll. Organizations implement HCM functionality not only to track personnel information, but to afford employees basic self-service functionality to request time off or input time, track their accruals and maintain compliance with tax and labor laws. Payroll functionality is incredibly important in ensuring the latter, automating what can be a complex process of calculating tax withholdings, benefit contributions, overtime and more. As organizations seek to leverage more data to recruit, reward and engage employees, a broader category of HCM software now offers more support for talent management. This type of application can assist with recruiting, onboarding, performance management and succession management. In some cases, an HCM module may provide talent analytics to help track against key performance indicators (KPIs) for turnover, retention, training and more.

Once solid finance and HCM processes are in place, organizations often look to improve the efficiency and performance of their operations. This may involve adding all or some combination of the following modules:

  • Procurement. The procurement module, also known as the purchasing module, allows the organization to improve the processes involved in a company getting the goods, services and materials it needs to build or sell its own products or services. Companies can keep a list of approved vendors in this module and tie those suppliers to certain items. It can also automate requests for a quote, then track and analyze all those quotes in one place. By centralizing the purchase order process, the procurement application enables the company to better rationalize invoices, track purchase orders and prepare payments to suppliers. Functionality in the system often allows companies to categorize and analyze spend to identify areas for potential cost savings.
  • Inventory Mangement. For companies that sell products, automated inventory management is a must. You can’t sell what you don’t have—or don’t know you have. Inventory management software moves the tracking of individual SKUs from spreadsheets to a database that updates in real time to enable accurate and real-time tracking of quantities and location, including goods in transit. Implementing inventory management software is an essential first step in gaining a complete view of inventory, which is particularly valuable if items are stored across multiple locations, and helps companies find the right inventory balance. Reporting tools within the application can weigh sales trends against available product on a daily or weekly basis to help companies keep the right amount of inventory on hand. Better inventory management helps companies improve cash flow and increase inventory turn (a measure of how often inventory is sold over a certain period). They can also allocate inventory across online and physical channels and deliver new fulfillment options, such as buy online, pick up in store. An inventory management module, for instance, allows a company to set preferred stocking levels and lead times to determine reorder points and alert staff when it’s time to place replenishment orders.
  • Order Management. Tracking orders in spreadsheets can also quickly become a fool’s errand in a growing The order management module helps track orders from when they are first received, to when they are matched with available inventory in one of your facilities (whether a warehouse or retail store), to shipping and delivery. An order management solution integrated with your inventory management tool ensures that items ordered are actually in stock to prevent backorders and deliver a positive customer experience. This connection can also help improve demand forecasting. More innovative order management applications can help a company determine the most cost-effective option for fulfilling an order—a store vs. a distribution center vs. a third-party fulfillment partner, for example—based on available inventory and the buyer’s location. They can also prioritize orders on parameters like date received, shipping speed and more.
  • Warehouse Management. For any business that operates a warehouse—whether a distributor, manufacturer or retailer—a warehouse management module can lead to major efficiency gains by digitizing and automating put-away, fulfillment and shipping processes. A warehouse management module complements the features of inventory and order management modules. This application can support different picking strategies like batch picking, wave picking and zone picking depending on which is most efficient for a given business, to increase order fulfillment rates and the accuracy of orders. A warehouse management module can also boost customer satisfaction because more buyers receive the correct goods on-time and in the condition they expect.
  • Manufacturing. Manufacturers are typically looking for a tool that helps them build and execute against a bill of materials (BOM), which is like a recipe for the creation of a product. The BOM helps the company plan for production of its goods by ensuring that it has the correct parts or materials in the right amount to execute all work orders. In that way, the manufacturing module is tied directly to demand and supply planning, which the SCM module usually manages. There’s also functionality that ensures product quality, as well as operational efficiency on the plant floor. For instance, are all the workers and required machinery available to execute a production run next week? How does planned production for the next few months stack up to available materials, as well as what’s on order? How can the company adjust production if there are disruptions in supply, or spikes in demand? A manufacturing module can assist with all of these situations. Manufacturing ERP is one of the most exciting spaces to watch, as it’s a testing ground for the intersection of operational technology and information technology like the Internet of Things (IoT).
  • Supply Chain Management (SCM). Another module with a bucket-load of features that can help optimize operations is supply chain management (SCM). Some of the SCM module’s functionality overlaps with that of inventory, order and warehouse management, but its basic aim is to lend end-to-end visibility into the company’s supply chain and its partners, from sub-suppliers to distributors, in order to ensure business continuity and compliance and reduce supply chain risk. This application can look at purchase orders, inventory, current and planned production and expected demand to enhance supply chain planning. The SCM module also manages returns—when customers return products, an associate scans each item, records its condition and, if necessary, initiates an exchange. More advanced capabilities include demand forecasting and measuring supply chain sustainability. The latter category is becoming important not only to ensure and report on sustainability measures and targets for the company itself, but to provide customers with greater visibility into what’s in a product they purchase and how it was sustainably and safely sourced and made.

From there, businesses may add more specialized modules designed to meet the needs and challenges of certain industries and business models. Some of these support the customer- facing side of a business, rather than the back end.

  • Customer Relationship Management (CRM). A treasure trove of customer and prospect data is stored in the company’s CRM Leading CRM applications have three core capabilities: sales force automation, customer service management and marketing automation. The first helps sales reps manage leads and opportunities and put together quotes. More robust CRM modules can also forecast sales by leveraging historical data about transactions and buying behavior. The customer service piece tracks the company’s communication history with customers and prospects—the date and time of calls and emails, for example—and their purchase history. Finally, marketing automation capabilities help businesses manage campaigns and segment their audience to determine who should be targeted for certain promotions or cross-sell opportunities. When a customer or prospect fills out a form on a business’s website, that information flows into the CRM, which generates a notification so a sales rep can follow up promptly. Sales and marketing teams can also see where that customer is in the sales cycle to decide what to do next. When customers have questions about or issues with a product or service, a customer service agent can resolve the situation more quickly because he can see all previous interactions with the buyer.
  • Professional Service Automation (PSA). Also called a service resource management module, this application allows an organization to plan and manage The PSA module tracks the status of projects, managing human and capital resources throughout, and allows managers to approve expenses and timesheets. It facilitates collaboration between teams by keeping all related documents in a shared place. Additionally, the PSA module integrates with the finance module to automatically prepare and send bills to clients based on the agreed- upon billing schedule. Companies adopt PSA when tracking hours and billing individual clients becomes too time-consuming and difficult to track or when late and erroneous bills become common. The software shows project status, tracks consultants assigned, hours logged, travel expenses and communications with the client, and can use all of that information to automate billing.
  • Ecommerce. For businesses that want to sell products online, whether to consumers (B2C) or other businesses (B2B), an ecommerce module is vital. There’s a reason for the urgency to start selling online—the National Retail Federation reports that online sales grew nearly 24% year-over-year during the 2020 holiday shopping season. This module typically comes with user-friendly tools that empower non- technical employees to easily add new items, update product content (item descriptions, titles, specs, images, etc.) and change the look and feel of the website. Many ERP vendors offer an ecommerce application, with the primary benefit being native integrations with modules for inventory, order and warehouse management, so all order, customer and payment information seamlessly flows into the ERP.
  • Marketing Automation. Marketing While the CRM can often handle basic marketing automation, a module dedicated to this can offer more extensive capabilities. Data from the CRM system can feed into the marketing automation tool to drive targeted marketing campaigns across various channels, including social, email, video and more. A marketing automation module can also maintain various contact lists. It can measure the performance of various campaigns in detail, as well, to shape future marketing plans and spend. Ultimately, a marketing automation module should help a business grow revenue across all sales channels and increase the loyalty of existing customers.

 

Popular Modules By Industry

Every company, regardless of the industry in which it operates, will need to manage its revenue, its people and its customers. For this reason, many companies share a need for the basic functionality offered by finance, human resources and CRM modules once they reach a certain size. But a professional services company will not need inventory management, just as a wholesale distributor will probably not require a PSA module. There are many modules that provide capabilities more specific to certain industries, but here are what companies in several major sectors typically need:

Retail

The coronavirus pandemic accelerated a shift already in motion for retailers already grappling with changing business models and an increasing need to support customer-centric buying experiences. At the very least, retailers must be able to sell online and should be prepared to deliver on new channels customers now seek, such as buy online, pick up in store. For that reason, retailers need ecommerce functionality. On the back-end, most retailers will also require robust procurement, inventory management and order management modules to lay the foundation for multi-channel order management and fulfillment that meets customers’ soaring expectations. Retailers that operate their own warehouses may need a warehouse management module to ensure orders are shipped and delivered quickly while keeping costs down. Finally, as customers seek increasingly personalized experiences, retailers should invest in marketing automation applications that can tailor messages to specific shoppers.

Manufacturing and Wholesale Distribution Companies that run their own manufacturing processes need strong SCM functionality in order to efficiently and effectively manage work orders, make and/or build items, track inventory at various stages and ensure strong quality assurance processes. ERP modules for procurement, manufacturing and inventory management can bring all of this data together and make it consumable in the form of a dashboard. That makes it easier to proactively alert the general manager of issues in production, allow them to identify new opportunities and become a stronger partner in business strategy.

For wholesale distributors, it’s also crucial to have similar SCM capabilities, including warehouse management and order management modules, to streamline manual, error-prone and time- consuming pick, pack and ship processes. Ideally, warehouse workers use handheld barcode scanners connected to the warehouse management module to maximize the speed and accuracy of fulfillment. A CRM could be especially valuable for distributors by helping them provide customers with a higher level of service in an industry that’s become intensely competitive.

Food and Beverage

Many food and beverage companies function like manufacturers—their processes necessitate rich manufacturing and supply chain functionality.

Assembling a food or drink recipe has a lot in common with a BOM, and there are the same needs for quality management and visibility into their supply chain to ensure the right ingredients for the product will be there in the right quantities, at the right time. Other food and beverage companies take on the characteristics of retailers— sometimes in addition to manufacturing—requiring ecommerce and marketing automation systems that integrate with back-end finance, manufacturing and inventory management systems. Together, these systems enable the organization to consistently measure profitability and learn what’s selling and what isn’t so it can adjust its strategy accordingly.

Software and Technology

Most companies in the software and technology space are adopting the cloud in some way, and may be using the subscription pricing model that has grown in popularity over the last decade. This business model requires companies adopt some specific practices for recognizing revenue that

are made much easier with a feature-rich finance module—or in some cases, a separate billing module—that can automate forecasting, allocation, recognition, reclassification and auditing through a rule-based event-handling framework. Functionality specific to these requirements will make it much easier to schedule, calculate and present revenue on financial statements for financial reporting.

Technology businesses often need a PSA module, as well, to handle the implementation and consulting work they offer for their products.

Professional Services

As you would expect, companies in the professional services space will benefit from a PSA module that facilitates project collaboration, resource allocation and accurate costing and billing. Software that automates the complete bid-to-bill process and integrates project activities with the company’s financials will help services businesses strike the right balance between project resources and profitability. A services company in rapid-growth mode may decide a marketing automation tool is a worthwhile investment to acquire new clients and earn more work from existing ones, as well.

Which ERP Modules Does My Business Need?

Your business’s ERP strategy and which modules you invest in will depend on not only your industry, but your business strategy and goals.

Are you looking to add new customers or drive additional value from existing ones? Launch a new line of services or products? Cut costs or drive inefficiencies out of a certain process?

Technology can also be deployed to solve specific business problems. Is too much cash tied up in stock sitting in your warehouse? Are suppliers or contract manufacturers unable to keep up with customer demand? Above all: Are customers able to solve their problems when they turn to you?

As you try to determine the ERP modules your company needs right away, and ones it might add in the future, keep this framework in mind:

Look at the books. If the business is struggling with inefficient accounting processes, has little visibility into cash flow and its current financial position or is constantly receiving late payments from customers, it’s time to look at automating accounting and financial processes. A finance module will streamline the processes associated with accounts payable and accounts receivable and make sure that everything in the general ledger is accurate to simplify the complexities of financial reporting and compliance.

Look to the people. If the business isn’t accurately keeping track of data on and finding new ways to engage with its employees, it’s not going to have the talent it needs to accomplish key business objectives or be able to tell when and where it needs to hire new people that will help it make progress toward new goals. Taking care of the people that work for you will pay dividends in how they do their jobs and ultimately translate to happier customers and growth. Strong payroll and HR tools will build the foundation for business- differentiating talent management.

Find out what’s bugging customers. Focus on what’s causing friction for the customer and let that guide you to the issues with the underlying processes. Can customers get the items they want in the manner they expect? Are there too many items on backorder? How can the business better predict and meet demand? Look to inventory management and the planning tools within. Are shipping costs leading customers to look to competitors? Look to warehouse management and other supply chain modules. Are certain projects and customers becoming too costly and time- consuming to manage because of the number of people involved? Look to the capabilities of a PSA tool.

Establish a clear plan for growth. For most companies, the growth strategy revolves around adding new customers and keeping existing ones happy to convince them to buy more items and services. Does the business have the information it needs to create targeted marketing campaigns that resonate with customers? How is your company generating sales leads, and do reps spend most of their time on the most valuable ones? And how are you measuring everything, including the effectiveness of different sales and marketing strategies? Strong CRM and marketing automation solutions enable these capabilities for all companies, whether B2C or B2B.

NetSuite offers each of the ERP modules covered here, and connects them all on a unified platform that provides invaluable visibility across your business. NetSuite offers dedicated modules for finance, inventory management, order management, procurement, warehouse management, manufacturing, CRM, HCM, PSA, ecommerce and email marketing.

Additionally, NetSuite has other modules designed to handle industry-specific processes or challenges.

Customers who choose NetSuite can realize the benefits of a modular approach with a vendor that can support all of their current and future needs. That often starts with the basics like financials, CRM and tax management. As businesses grow and expand into other countries, they might add procurement, planning and budgeting and HCM modules. That growth leads to increasing complexity, and companies often add functionality for upgraded billing and revenue, analytics and multi-book accounting. From there, organization can add whatever else they need to expand their reach and fuel their success.

In helping more than 24,000 customers across more than a dozen industries improve their back- end operations and build exceptional customer experiences, NetSuite has gathered industry- leading practices over more than two decades. That experience forms the foundation of its SuiteSuccess methodology. SuiteSuccess offers a tailored approach to implementation and beyond based on industry and business size (with four different market segments). That leads to not only faster deployments, but an ERP that comes pre-configured with KPIs, reports, dashboards and reminders that allow your company to hit the ground running. SuiteSuccess drives faster time- to-value, greater user adoption and sets up your business to establish itself as an industry leader.

Value of ERP

The true value of ERP is in the integrated organization that it enables, unifying siloed functions and ensuring that accurate, consistent data is driving processes and decision-making. Some businesses will adopt functionality piecemeal, and others will need a number of different modules from the start. The best ERP systems will allow the organization to scale functionality as needed, adding capabilities to meet their business needs and future initiatives. Leading ERP software providers allow business strategy to dictate technology strategy—not the other way around.

While every organization will need certain ERP modules, how it configures each module will be unique to its specific business processes. It’s important to partner with a vendor capable not just of delivering out-of-the-box functionality, but that can tailor the software to the particular needs of your business in a way that won’t disrupt operations or require extensive retraining. Cloud-based ERP software gives companies that flexibility, and top vendors have modules that can support each business’s journey every step of the way.

Want to know more?

Our experts are more than happy to listen to your enquires and provide you with the information you need.

Related Post

What to Look for in Your Next ERP

What to Look for in Your Next ERP

Looking for a new Enterprise Resource Planning (ERP) solution is not something you do every day. According to the Mint Jutras 2019 Enterprise Solution Study, the average age of ERP implementations today is approximately 7.75 years. If you’ve implemented a new solution within the last five years, hopefully you are not looking again quite so soon.

Therefore, it is safe to say that (unless you’ve recently changed jobs), anyone looking today hasn’t done so in the past eight to ten years, or even longer. And a lot has changed.

Whereas fit and functionality once drove most decisions, basic and even not so basic features and functions are table stakes today. While an 80% fit used to be acceptable, today’s flexible and technology-enabled solutions should get you much closer to 100% than ever before, without the need for invasive customization. Of course, you still need to perform due diligence and confirm robust functionality, including industry-specific features and functions, but if you haven’t looked around for awhile, expect to be pleasantly surprised.

Also equally important today is the whole user experience, including easy navigation, visual appearance and personalization. And don’t forget integration capabilities and the quality of built in reporting and analytics. Any evaluation today requires you to raise the bar in terms of your search. Read on for some inspiration and tips on what to look for.

WHERE TO START

In the early days of ERP, in searching for solutions, companies would start by creating a long list of vendors, sometimes on their own, but more often with the aid of an independent consultant. They might also create a feature check list and send that out as a request for proposal (RFP) to those vendors. That would start the long and arduous process of whittling that long list down to a short list of two to three (maybe up to five) vendors, usually after a first round of presentations and demonstrations. Of course, if you look back far enough, before the Internet and web-enabled solutions, this often meant traveling to the vendors’ offices or hosting them at your own office and dialing in over a phone line on a (very) slow connection. No wonder it took so long and thank goodness for the Internet and virtual meetings today!

Fast forward to 2019 and chances are your search starts online and you have your short list before you ever reach out and contact a single vendor. We asked our 2019 Enterprise Solution Study participants…

The different sources shown in Table 1 are sequenced (top-down) from most valuable to least valuable, although even those at the very bottom of the list are perceived to be very valuable. Industry analyst reports, inquiries and rankings are most often cited as the place where participants look first and foremost. Note that different industry analyst firms offer a wide range of different “products” ranging from educational reports (like this one you are reading now), to consulting and advisory services, to reports that stack rank and rate vendors and their products. When looking at these rating reports, bear in mind there is always a degree of subjectivity to these rankings. And often times viable vendors and solutions are excluded because of the size of their installed bases or the vendor’s willingness to participate. Some (not all) of these research/analyst firms require a vendor to pay a fee to be included. The larger, more reputable analyst firms do not, but they may have quite stringent requirements for inclusion.

All of these sources of information can be quite useful both in terms of providing a place to start, as well as narrowing down your search. But ultimately you will need to engage directly with the vendors on your short list.

TRADITIONAL CRITERIA IS STILL IMPORTANT

One of the reasons (perhaps the biggest reason) why so much has changed in terms of searching for a new ERP is the underlying technology. Today’s component-based architectures and development platforms make solutions more extensible, providing you with the ability to add or change functionality with less disruption to the core. They provide the ability to configure, personalize and tailor your solution with little or no invasive code changes.

The best platforms today allow you to add features with low code or even no code.

While early ERP solutions were rigid, monolithic structures, today’s modern solutions are more component-based. Every technologist in our audience knows a microservice architecture is defined as an architectural style that structures an application as a collection of loosely coupled services. For those nontechnical readers, think of it as constructing a solution from a set of Lego building blocks. In other words, agile ERP is no longer an oxymoron.

Yet, while it is very important to look under the covers of any new enterprise solution, we can’t forget some of the more traditional criteria for evaluation. We asked our study participants to stack rank six of those more traditional evaluation criteria from most important to least important. Since number one was most important, the lower the number, the more important the factor.

The first thing we notice is that we don’t have a very wide spread from the top of the list to the bottom – less than a single ranking point separates the most important from the least important. This means there is quite a bit of variability in perspective even in our sample of 464 study participants. And we can conclude all of these are very important. That comes as no surprise because we selected what we had found over the years to be the most important to the most survey respondents.

But we do see the widest gap separating the top-ranked criteria from the rest. We’ve been observing the selection process for years, asking this or similar questions, just in slightly different ways. For many years fit and functionality was clearly at the top of the list, but the user experience has been steadily rising in importance and this year it rose to claim the definitive top spot.

USER EXPERIENCE IS MOST IMPORTANT

This didn’t surprise us either. We are all spoiled by easy-to-use, intuitive consumer technology. Some of our millennial workers today have never used software that came with a user manual.

But there is another reason for this jump. In the early days of ERP very few of your employees ever put their hands directly on ERP. That privilege was reserved for data entry staff and select super users, who became a conduit (bottleneck?) to answers. Of course, the information technology (IT) staff also ran and distributed paper-based reports. Back then the look and feel had a more limited impact on your success.

Luckily those days are long gone. Today expect at least 40% of your employees to be regular ERP users and even more will have some access through self- service functions such as purchase requisitions, paid time off or expense reimbursement requests. And make no mistake, these self-service functions can be a significant source of productivity leakage if not well-supported with intuitive and easy-to-use software.

THE USER INTERFACE (UI)

Over the past decade, solution providers have applied significant resources to improving the whole user experience. New software is developed with an entirely different paradigm than in the days of “green screens.” And many vendors have completely redesigned and rewritten user interfaces. You might hear them talk about “beautiful software,” but tastes vary, and “beauty” is in the eye of the beholder. Look for a user interface that looks familiar, one that mimics your interaction with your favorite consumer app. You should be able to tailor it to your needs and personalize it to your preferences and your particular role in your organization.

THE DIGITAL ASSISTANT

Not only have user interfaces become more intuitive, making systems easier to use, some have even learned to “listen” and “speak.” Several different solution providers have introduced digital assistants to the market, changing the way users interact with solutions. While they vary in function, these virtual assistants tend to have one common element. You can speak to them and they understand what you are saying – for the most part. And they can even answer you. These solutions make use of natural language processing (NLP), a form of artificial intelligence (AI). While not long ago these were considered pretty far-fetched, they are no longer the stuff of science fiction. They have become quite pervasive in consumer technology. We regularly “speak” to our smart phones and even our televisions. It’s time to start talking to your ERP.

ROBOTIC PROCESS AUTOMATION (RPA)

Also look for automation. Sometimes the best user interface is no user interface at all. Can you automate your bank reconciliation process? Can you capture an RFID tag with a reader, and have it initiate an inventory transaction? Can you take a picture of a receipt and have it automatically attached to your expense report? And can the software tell the difference between a receipt for parking and one for lunch? Can you readily import customer purchase orders transmitted electronically directly into your ERP?

This last question is indicative of the impact of the digital economy on business applications like ERP. We asked our Enterprise Solution Study participants how they captured orders today and also whether that was changing. Thirty-seven percent (37%) said, yes, it would change over the next two years and another 45% said it might. Only 18% expect no change. As you can see from Figure 2, the percentage that will be manually entered is expected to drop while the percentages created electronically are rising. This all impacts the overall ERP customer experience and your solution must be able to accept these transmissions.

EXPECT A BETTER FIT AND MORE FUNCTIONALITY

While fit and functionality dropped to second place this year, make no mistake, it is even more crucial than ever. In fact, it is time to start breaking the 80/20 rule.

Where did this 80/20 rule of software come from? With many of the early versions of ERP, software vendors tried hard to be all things to all businesses. With few exceptions, most early solution providers cast a wide net. Unwilling to turn any potential business away without a try, they came to market with very broad solutions. By trying to please everyone, they never had a complete solution for anyone. The 80/20 rule prevailed. Nobody expected a solution to satisfy all their needs (an 80% fit was often the goal), resulting in invasive (and sometimes expensive) customizations that built barriers to further innovation. It also resulted in a proliferation of disparate systems that may or may not (still) be integrated today.

But a “one size fits all” solution is not the most effective approach to meeting the needs of a wide range of businesses. No software vendor can be successful in trying to be all things to all businesses. But it is still possible to get “last mile” functionality today with a strong platform and microservices to make ERP more “extensible.” In the context of ERP: to make it easier for the vendor (and possibly its partners with deep domain expertise) to add specialized features and functions to a solid code base, with minimal disruption.

This is really the (not so) secret sauce behind any solution provider’s ability to deliver “last mile” functionality, not just for major industries like manufacturing, or even verticals like food and beverage, but also micro- verticals like dairy, beverage, bakeries, prepared/chilled foods and meat/poultry/fish. While some features and functions might be the same across all manufacturing, food and beverage manufacturers and distributors also must deal with lot and sub-lot traceability and recall. Many within food and beverage must also deal with catch weights.

AN EXAMPLE: CATCH WEIGHT IN MICRO-VERTICALS

Catch Weight is a food industry term that means “approximate weight” because unprocessed food products (particularly meats) naturally vary in size. A retailer might order a case of 12 turkeys. The manufacturer (food processor) will estimate the price of the order by the approximate weight (e.g. 15 pounds per turkey) but will then invoice for the exact weight shipped. This can wreak havoc in an ERP solution not well-prepared to handle it.

But catch weight doesn’t affect all food industries in the same way in. It is also used in the cheese industry to manage shrinkage as the cheese ages. So, handling catch weight varies for different types of food. By handling all the different types of catch weights in a single line of programming code, you add a level of complexity that adds little or no value to the customer beyond the single problem it is facing. A cheese processor doesn’t care if you can satisfy the needs of a butcher. A butcher doesn’t care about shrinkage of cheese.

This is just one example of specialized features that represent “last mile” functionality – different components of code to insert depending on the needs of the specific micro-vertical, preserving simplicity without sacrificing very specific functionality. This is what produces a more “complete” solution, which was stack-ranked third in priority for our traditional criteria.

AFFORDABILITY

Affordability has always been a key consideration in selecting a new ERP, but the better question today would be: Can you afford not to be running a modern, technology-enabled ERP? Of course, there will be some up-front costs associated with a new implementation, but savings in efficiency and productivity, in addition to hard cash savings, can help defray those short-term costs. More than half (54%) of our survey respondents achieved 100% of their return on investment (ROI) within two years with an overall average time of just under 20 months.

New ERP solutions used to always require capital investment, putting a hard stop on buying something out of your price range. But cloud options,

subscription-based pricing and solutions that are delivered as Software as a Service (SaaS) provide more options today. Capital investments (CapEx) in hardware and software can often now be replaced with operating expense (OpEx). In a SaaS environment you are removing the hardware costs, including maintenance and repair, along with the cost of obsolescence. And you need to look beyond the up-front costs and look at the recurring costs in order to determine total cost of ownership. A purchase of a license up-front does not mean you won’t have recurring maintenance costs.

INTEGRATION CAPABILITIES

Regardless of how complete your solution is, you still need to consider integration capabilities. Even with a suite that is intended to be a complete end-to-end solution, running a single application throughout your enterprise is very rare. And even if you could, how well can you inter-operate with your trading partners (customers and suppliers)? If any applications other than your ERP create transactions or touch any of the assets managed by your ERP, data must be synchronized, and connections must be made. As mentioned earlier, component-based architectures and standardized data models can simplify integration between applications, making the platform on which any new ERP is built of paramount importance.

BUILT IN REPORTING AND ANALYTICS

Reports are quite basic to enterprise applications, but they provide a historical and quite static perspective. While you should expect any enterprise application to provide some minimal reporting, you should also recognize that no matter how extensive the reporting is, it probably won’t provide exactly what you want. There are simply too many variables to consider. Therefore, a good report-writer or the ability to easily tailor reports and inquiries, without invasive code changes, is a pre-requisite for any application. Look for one that does not require a lot of technical (programming) skills or expert knowledge of how the data is stored. Otherwise your business users will likely be placed in the queue, waiting for IT to deliver what you need. And they will grow impatient and turn to spreadsheets instead.

Also, nobody can anticipate everything you will actually need to see in your inquiries and reports. Reports are intended to answer questions you already have. But once you have those answers, you are likely to have more questions. You don’t really know the next question to ask until you start digging into the data. That’s why it is called “analysis.”

For this you need good analytics. Basic analytical tools make use of data cubes, which are multidimensional arrays of data. An example of a three-dimensional array might be sales by product, region and time. Any array that requires more than three dimensions is called a hypercube. Most analytical tools today have some sort of “visualization” capabilities, which allow you to present the data,

not just in tabular format, but also with more visually intuitive charts and graphs. Of course, visualizing more than two dimensions becomes harder.

The use of analytical tools generally requires special skills, especially in the creation of cubes. Therefore, they remain in the hands of a few power users or information technology (IT) staff. Some vendors will seek to put the power of these tools in the hands of the business users. They will ship products with preconfigured cubes and construct purpose-built apps that exploit the tools.

While this empowers the business users, it also imposes limitations similar to those associated with reporting. Yes, a vendor can deliver them “out of the box” but must make some assumptions in terms of which dimensions are most likely to meet the needs of their users and what questions they might ask. So, there are some trade-offs between empowering the business users and constraining the power of the tool itself.

In building these analytical applications, either as embedded modules or extensions to the enterprise applications where the business data is housed, some solution providers are adding powerful new features, like the ability to connect from different data sources, in addition to the data in the application itself. Others are adding “data discovery” mechanisms that will point you in the direction of looking at the data from different angles, including some you have not thought of yourself. They are also adding predictive elements.

Predictive analytics is all about detecting patterns and scoring probability, most typically in terms of measuring risk or opportunity (think predicting equipment failures or forecasting demand). Algorithms are created that can make suggestions and/or automate decision-making processes. In this regard, it is artificial intelligence (AI) because it does not require human interaction.

The earliest AI to which most consumers were exposed was Amazon’s suggested reading list. It was in fact pretty rudimentary. If you read that, then surely you would enjoy this. The fewer purchases made, the lower the probability Amazon would discover your real interests and preferences; the more historical data available, the better the accuracy. The same is true for pattern recognition and predictive modeling in an enterprise setting. If you are using predictive models to forecast demand for a product, the more historical data available, the higher the scored probability.

This is really what machine learning (ML) is all about – getting smarter over time without a human directing the learning process. Indeed, machine learning is computing capability that learns without being explicitly programmed. A travel and expense application that can detect a previous destination and imply a pattern in your travel is a very simplistic application of machine learning. But there is a huge potential for far more complex uses.

Consider for example how you might forecast demand for a product you have never sold. In this case, the predictive analytics might seek and detect similarities with other products for which you do have data, similarities that might not be immediately obvious to a human.

These types of predictive and cognitive analytics, powered by technologies like machine learning, image recognition and natural language processing are finding their way into digital assistants, forecasting applications, and more. As automation frees us up from simple, repetitive tasks… as we shore up productivity leakage, now is the time to empower knowledge workers with analytic tools.

KEY TAKEAWAYS AND CONCLUSION

If you are currently shopping for a new ERP, chances are it has been a long time since your last evaluation. A lot has changed in recent years. Or perhaps this is your first experience in being on the selection committee. Fit and functionality are (still) important, and an 80% fit should no longer be the goal. Look for that last mile of functionality to be delivered without costly and invasive customizations that build barriers to innovation and lead to stagnation.

But there is also danger in making a decision based solely on what you need today. We live in disruptive times and the pace of change is truly accelerating beyond anyone’s expectations. Change and disruption can have a cascading effect on your business applications requirements, making agility – the ability to innovate, evolve and change – equally, if not more important. For that you need the right approach to innovation and the right architecture and platform to support it.

But even as you look carefully under the covers, don’t forget some of the traditional basics. Do your due diligence on fit and functionality, but also closely examine the user experience. Will it feel comfortable to all your employees, from the millennials that grew up using technology, to the baby boomers that might not be quite as tech-savvy? The interface should be intuitive and easily personalized. But don’t make the mistake of thinking your employees won’t need training. This is the software that is running your business.

Also look carefully at integration capabilities. Even with a suite that is intended to be a complete end-to-end solution, running a single application throughout your enterprise is very rare. And even if you could, how well can you inter- operate with your trading partners (customers and suppliers)?

Early ERP solutions were rigid and inflexible, hard to install and implement and even harder to use. Functionality was limited (and limiting) and implementations were not for the faint of heart. Horror stories of failed implementations costing millions of dollars were fairly common. For many, those perceptions live on, in spite of the fact that solutions today are far more technology-enabled, provide many more features and functions, and are easier to install, easier to implement and easier to use.

Yes, ERP implementation is difficult and potentially disruptive to your business during the project. You really must expect this. After all, it is the software you use to run your business. And implementing ERP requires a different skill set than running your business. So secure top management commitment and create a plan. Don’t be afraid to seek guidance and assistance from those that do this for a living. ERP experts can help you identify goals, set a realistic schedule and budget and keep you on track. These experts will not be distracted by the day-to-day firefighting intrinsic to any business.

Selecting a new ERP is an adventure. Set the bar high in terms of expectations and prepare yourself well.

Want to know more?

Our experts are more than happy to listen to your enquires and provide you with the information you need.

Related Post

Request a consultation with Us!