• Skip to main content
  • Skip to footer
Revelwood Logo

Revelwood

Your SUPER-powered WP Engine Site

  • Who We Are
    • About Us
      • Our Company
      • Our Team
      • Partners
    • Careers
      • Join Our Team
  • What We Do
    • Solutions
      • Workday Adaptive Planning
      • IBM Planning Analytics
      • BlackLine
    • Services
      • Implementation Services
      • Customer Care
        • Help Desk
        • System Administration as a Service
      • Training
        • Adaptive Planning Training
        • IBM Planning Analytics / TM1 Training
    • Products
      • DataMaestro
      • LightSpeed
      • IBM Planning Analytics Utilities
  • How We Help
    • Workday Adaptive Planning Use Cases
    • IBM Planning Analytics Use Cases
    • BlackLine Use Cases
    • Client Success Stories
  • How We Think
    • Knowledge Center
    • Events
    • News
  • Contact Us

Planning & Forecasting

IBM Planning Analytics Tips & Tricks: How to Set Up Action Buttons in Planning Analytics for Excel

December 6, 2022 by Dillon Rossman

Revelwood’s latest IBM Planning Analytics Tips & Tricks video features Dillon Rossman, a consultant with our IBM Planning Analytics practice, demonstrating how to set up action buttons in IBM Planning Analytics for Excel (Pax).

In this video, Dillon shows your three approaches: 

  • Default approach
  • Creating the action button in a different workbook or sheet
  • Run a process and then go to another worksheet

Revelwood has worked with IBM Planning Analytics / TM1 for more than 27 years. We’ve partnered with hundreds of companies on the design, development, maintenance and updates of IBM Planning Analytics applications, across every industry. Have a challenge with Planning Analytics / TM1? We can help you!

Watch more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: How to Set Up Synchronizations in IBM Planning Analytics Workspace

IBM Planning Analytics Tips & Tricks: Filtering in IBM Planning Analytics Editor

IBM Planning Analytics Tips & Tricks: Global Settings in Overview Area of Exploration

Home » Planning & Forecasting » Page 2

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: Financial Performance Management, IBM Cognos TM1, IBM Planning Analytics, Planning & Forecasting, TM1

IBM Planning Analytics Tips & Tricks: How to Set Up Synchronizations in IBM Planning Analytics Workspace

November 29, 2022 by Dillon Rossman

Revelwood’s latest IBM Planning Analytics Tips & Tricks video features Dillon Rossman, a consultant with our IBM Planning Analytics practice, demonstrating how to set up synchronizations in Planning Analytics Workspace (PAW).

In this video, Dillon walks you through how to:

  • Change an exploration to a pie chart
  • Edit the synchronization properties
  • Select the dimensions you want to be synchronized
  • Perform synchronizations on both a sheet and a book

Revelwood has worked with IBM Planning Analytics / TM1 for more than 27 years. We’ve partnered with hundreds of companies on the design, development, maintenance and updates of IBM Planning Analytics applications, across every industry. Have a challenge with Planning Analytics / TM1? We can help you!

Watch more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: Filtering in Planning Analytics

IBM Planning Analytics Tips & Tricks: Global Settings in Overview

IBM Planning Analytics Tips & Tricks: Color in Planning Analytics

Home » Planning & Forecasting » Page 2

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: IBM Cognos TM1, IBM Planning Analytics, Planning & Forecasting, TM1

IBM Planning Analytics Tips & Tricks: Planning Analytics Workspace Borders in Preview

November 1, 2022 by Lee Lazarow

Tips & Tricks

IBM Planning Analytics Workspace (PAW) allows you to easily create selector widgets that can be used for updating the data in your PAW book. This is done by adding a dimension as a selector widget.

You can edit the list of elements (e.g., the set) and the way the list appears. The selector widget allows you to easily select an element that is synchronized to your charts and explorations. When selecting the element, a border appears around the widget.

Diagram

Description automatically generated with low confidence

While this border offers features such as the ability to expand the screen, it clearly makes the list into a separate section of the page. You can remove the border by using the property called “Show selected border in preview” (within the area called General, Appearance). Here is the same list without the border enabled:

Text

Description automatically generated

This property will allow you to create the perception of a single page and not a set of independent objects.

Revelwood has worked with IBM Planning Analytics / TM1 for more than 27 years. We’ve partnered with hundreds of companies on the design, development, maintenance and updates of IBM Planning Analytics applications, across every industry. Have a challenge with Planning Analytics / TM1? We can help you!

Read more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips &Tricks: Rounded Buttons in Planning Analytics Workspace

IBM Planning Analytics Tips & Tricks: MDX Syntax Explained

IBM Planning Analytics Tips & Tricks: Global Settings in Overview Area of Exploration

Home » Planning & Forecasting » Page 2

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: IBM Cognos TM1, IBM Planning Analytics, IBM Planning Analytics Tips & Tricks, Planning & Forecasting, TM1

IBM Planning Analytics Tips &Tricks: Rounded Buttons in Planning Analytics Workspace

October 25, 2022 by Lee Lazarow

IBM Planning Analytics Workspace (PAW) allows you to easily create buttons that can be used for navigation and to run TurboIntegrator (TI) scripts. This is done by dragging the Action Button widget onto the sheet.

By default, the button appears as a rectangle.  

Shape

Description automatically generated

You can make the button more rounded by using the property called “Corner Radius” (within the area called General, Appearance).  Here is the same button with a corner radius setting of 90:

Shape, rectangle

Description automatically generated

You can also update the height of the button to make it appear even more rounded:

Shape, circle

Description automatically generated

From there, you can further customize the formatting associated with colors, fonts, and text size.

This property will allow you to define various ways to incorporate simple “press this button to…” approaches within your PAW books.

Revelwood has worked with IBM Planning Analytics / TM1 for more than 27 years. We’ve partnered with hundreds of companies on the design, development, maintenance and updates of IBM Planning Analytics applications, across every industry. Have a challenge with Planning Analytics / TM1? We can help you!

Read more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: Working with Two Time Zones in Google Calendar

IBM Planning Analytics Tips & Tricks: New Filter Option in Set Editor

IBM Planning Analytics Tips & Tricks: 21/21/21

Home » Planning & Forecasting » Page 2

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: Financial Performance Management, IBM Cognos TM1, IBM Planning Analytics, Planning & Forecasting, TM1

Three Reasons You Need IBM Planning Analytics / TM1 Training

October 21, 2022 by Revelwood

Whether you are new to IBM Planning Analytics / TM1 or you consider yourself an all-star, you could still benefit from training. Over our 27+ years of designing, implementing and maintaining IBM Planning Analytics / TM1 applications and environments, we’ve found there are three primary reasons for investing in training. 

1. Staff Turnover in the Office of Finance

According to Gartner, the U.S. total annual turnover rate will jump by nearly 20% from the pre-pandemic average. Maybe your Planning Analytics administrator left your organization. Maybe your organization is growing rapidly and needs to add more TM1 developers and administrators. Regardless of the reasons, training is a smart move when you have new team members joining the organization or taking on new roles in your company.

People often give their employers two weeks’ notice that they are leaving their job. That does not leave enough time for a company to hire a new employee for the position. Even if you are temporarily assigning the role to a current employee, two weeks is still not enough time to get up and running on your Planning Analytics / TM1 implementation. 

There’s also an additional complication – how accurate and up-to-date is your Planning Analytics documentation? Old and out-of-date documentation makes it even more difficult for new TM1 administrators and developers to get up to speed. 

2. Expanding use of Planning Analytics / TM1 to Extended Planning & Analysis (xP&A)

xP&A is an enterprise planning strategy that combines and extends financial and operational planning. Gartner describes it as “taking the F out of FP&A).” xP&A offers “cross-organization leaders an ‘extended,’ holistic view of their company’s operations so that they can pivot the business with greater agility and more rapidly model future business scenarios.” [Gartner].

This can mean using IBM Planning Analytics / TM1 for:

  • Human resources
  • Sales
  • Marketing
  • Operations
  • Supply Chain
  • IT
  • Research and development

There are many benefits to xP&A. The business unit leaders in these functional areas may not be the Excel experts that the Office of Finance are. Before rolling out Planning Analytics applications to other areas, you should make sure new developers and end users receive training. It will make a significant positive impact on your roll out and eventual user adoption and satisfaction. 

3. Upgrading from TM1 to Planning Analytics

Migrating from TM1 to Planning Analytics is a big opportunity to modernize your planning environment. It’s not just a standard update or migration. You’ll learn a new, rich data exploration and visualization experience in Planning Analytics Workspace. You’ll have a new Excel add-in, Planning Analytics for Excel (PAx). And you’ll leverage hierarchies – the ability to turn attributes into dimensions for faster and more flexible data analysis.

Migrating to Planning Analytics requires training. Planning Analytics is powered by TM1 but delivers a whole new environment for your planning activities.

Revelwood’s Planning Analytics / TM1 Training Options

Revelwood has offered TM1 and Planning Analytics training for decades. We’ve refined our approach, expanded our best practices, and have the answers to all your TM1 and Planning Analytics questions. 

We offer several options for training, including: 

  • IBM Planning Analytics Fundamentals
  • IBM Planning Analytics Custom Report Building
  • Personalized Training Courses, working with your data and environment. Example courses include:
    • IBM Planning Analytics / TM1 Administrator Training
    • IBM Planning Analytics / TM1 Developer Training
    • TM1 10.2.2 and earlier versions User Training
    • Customized IBM Planning Analytics User Fundamentals Training
    • Customized IBM Planning Analytics Custom Report Building Training

All training options are virtual, enabling your team members worldwide to participate in training. Take advantage of our Planning Analytics experts! Contact us about training options.

Home » Planning & Forecasting » Page 2

Filed Under: FP&A Done Right Tagged With: Financial Performance Management, IBM Planning Analytics, Planning & Forecasting, TM1

The Cost of Spreadsheet Errors

October 20, 2022 by Revelwood

News & Events

Using disconnected spreadsheets for forecasting, budgeting, planning and reporting creates a host of issues, including:

  • Wasting weeks every year manually consolidating a mass of individual spreadsheets
  • Inability to easily model potential future scenarios or answer what-if questions
  • Measuring actual spend against plan is a major chore
  • Talented finance staff spends too much time on low-level, non-value add activities.

These challenges are ongoing and exponential. The longer you rely on spreadsheets for “collaborative” planning, the higher the costs are. Most of these costs are “soft” costs – time, manpower, delays. But there are hard costs too – in the form of errors. Some of these errors might be small. Some might have a significant impact on your company. Here are a few examples:

Famous Spreadsheet Errors

J.P. Morgan’s “White Whale” debacle was a result of a spreadsheet user error. The firm was using Excel spreadsheets to model Value at Risk (VaR) for the Chief Investment Office. The model was built by copying and pasting data from one spreadsheet to another. Several cells in this model contained faulty equations due to a failed copy-and-paste process. This led the firm to severely underestimate the downside risk of one of its credit portfolios, which led to approximately $6.5 billion in losses and fines. 

The municipality of West Baraboo, Wisconsin, relied on spreadsheets to calculate how much its borrowing would cost. The spreadsheet had a sum that was missing one cell. This resulted in West Baraboo underestimating the total cost of a 10-year bond, meaning the village had to pay $400,000 more interest on the bond than it originally thought.

Lazard, Ltd. Is an investment bank that advised SolarCity Corp. The bank had a computational error in a spreadsheet. This error led Lazard to discount the value of SolarCity Corp by $400 million. This happened when Tesla Motors Inc. was purchasing SolarCity Corp.

When Vista Equity Partners purchased Tibco Software, Tibco shareholders received $100 million less than originally anticipated. This was a result of a spreadsheet error that overstated Tibco’s equity value.

The chances might be slim of your company suffering one of these financial disasters. But if you are still relying on spreadsheets for forecasting, budgeting, planning and reporting, you are likely to be experiencing one – if not many – of the nine circles of spreadsheet hell. 

What are they? Download this eBook, The Nine Circles of Spreadsheet Hell, to learn them – and the hidden costs of spreadsheets. 

Home » Planning & Forecasting » Page 2

Filed Under: News & Events Tagged With: Financial Performance Management, Planning & Forecasting, Workday Adaptive Planning, Workday Adaptive Planning Tips & Tricks

FP&A Done Right: The Role of Narrative Reporting in ESG

October 14, 2022 by Revelwood

ESG (environmental, social, governance) reporting is the talk of the Office of Finance. Does our company need to start thinking about ESG? When do we need to start reporting on our ESG efforts? And most importantly, how do we do this?

There are many approaches: leveraging existing investments in planning software and data analytics, relying on home-grown solutions, purchasing new, purpose-built applications, and more. One aspect of the ESG reporting continuum is that of narrative reporting.

In July 2022, Revelwood’s partner, Fluence Technologies, acquired Sturnis365, a solution for collaborative disclosure management and narrative reporting. “[The Sturnis365 acquisition] complements Fluence’s robust, enterprise financial consolidation, close and reporting solution, enabling time-pressed finance departments to spend more time on analysis while addressing broader mandates for narrative reporting, including internal board books, investor presentations and more stringent ESG reporting,” said Robert Kugel, SVP and Research Director at Ventana Research. 

What is Narrative Reporting?

Narrative reporting goes beyond the numbers – and statutory disclosure – to automate the production and distribution of any internal or external report. It enables you to combine and consolidate financial, operational and external data sources and narrative text components such as management letters and notes to financial statements. It allows for input from multiple contributors from across a business – from auditors to executives.

Fluence states, “Bringing financial and non-financial together through integrated reporting sets you up to tell a more meaningful story about the business … You can tell those stories through an annual report, board books, lender reports or other investor updates.” 

Narrative reporting provides meaning and context to your reports. 

Narrative Reporting and ESG

According to Accenture, 68% of CFOs globally take responsibility for their organization’s ESG performance. ESG reporting encompasses non-financial data that needs to be linked to financial information. ESG metrics can help uncover business opportunities, attract investors and offer a competitive advantage. More and more companies are incorporating ESG concerns into capital allocations and plans. Sustainability is falling under organizations’ enterprise risk management strategy. All of these factors point to the significance and importance of reporting accurately and thoroughly on ESG. But numbers alone won’t tell the story. 

“Organizations need to understand their ESG reporting obligations – today and into the future – and this reporting responsibility typically falls on the Office of Finance,” said Michael Morrison, CEO, Fluence. “At Fluence, we are committed to addressing these ESG reporting needs with our modern consolidation, close and reporting platform.”

Read more in our series on ESG reporting:

FP&A Done Right: Finance’s Role in ESG Reporting

Home » Planning & Forecasting » Page 2

Filed Under: FP&A Done Right Tagged With: Environmental, esg, Fluence Technologies, Planning & Forecasting

Modern Accounting: Streamlining the Month-End Close

October 13, 2022 by Revelwood

This is a guest post from our partner BlackLine, explaining how to streamline and optimize the month-end close procedss.

What Is the Month-End Close Process?

The month-end close process is the series of activities accounting teams must monitor, perform, and review, on a monthly basis, to produce timely, accurate, and complete financial statements and related reporting. While the most important closing period comes at the end of the financial year, most businesses use month-end procedures to accurately track performance—a monthly closing process as part of regular accounting ensures that the numbers are reliable, stable, and accurate.

Why Is Optimizing the Month-End Close Important?

Extra time spent on the month-end close means less time spent on adding value through analysis and business partnering. Optimizing the month-end close will get financial numbers into the hands of leadership sooner to assist with timely analyses and smarter decision-making. Other reasons to optimize include better discipline, more structure, improved controls, more visibility, and reduced risk.

Flowchart for Month-End Close Process

Here is a month-end close process flowchart to visualize some of the key steps and processes.

BlackLine month end flowchart

What Are Month-End Procedures?

While traditionally a lot of the heavy lifting is done during a few peak days, the month-end close process is ongoing throughout the month as transactions are recorded in various systems.

Before reporting, accounting must capture, review, and make adjustments to data from disparate sources, which often include a primary ERP, other ERPs, sub-ledgers, banks, point-of-sale systems, and many others. When results are solidified and reviewed, accounting then reports results to stakeholders including internal management, external shareholders, regulatory bodies, and others.

When accountants think about the month-end close, they’re likely referring to the activities in the middle of the figure above, like substantiating balance sheet accounts, reconciling transactions, recording recurring journal entries, analyzing variances, monitoring critical tasks and controls, and supporting audits. These are the processes that require the most effort. These activities are traditionally performed manually in spreadsheets and stored in difficult to access emails or on shared drives.

How Long Does a Month-End Close Take?

Each company is different, so it’s impossible to say how long your month-end close should take. Surveys and research over the years show the month-end process generally takes between 5-10 days.

However, over the past decade, with help from technology, the close has been getting faster. According to Ventana Research in 2019, “63% of participants indicated their organization completes its monthly close within six business days, up from 53% in 2014, with nearly half (46%) now closing within four business days (the previous rate was 29%).”

Accounting teams face a lot of pressure to close the books fast because executives use the previous month’s financials to make business decisions for the upcoming months and quarters. Ventana Research notes, “Closing faster has value: 62% of those that close within six days say that the information they provide is timely, while only 39% of those that take longer say that.”

However, closing faster can mean a tradeoff between speed and accuracy. For example, using estimates rather than actuals can shave hours or days off your close, but that means your numbers may not be exact, and when it’s time to close the fiscal year, the actuals will still need to be determined. This may end up adding days to your year-end close.

What Are the Steps in the Closing Process?

Again, because all companies are different, there is no perfect month-end close checklist. For example, businesses that sell physical products will have the extra steps of tracking inventory while companies that are service-focused will not. Smaller companies may have fewer accounts while multinationals will have hundreds or thousands. But there are some key items most accounting teams will need and steps they’ll need to follow.

Some of the information accounting teams need to have on hand in order to close the monthly books:

  • Total revenue numbers
  • Bank account information
  • Inventory levels (if applicable)
  • Petty cash total
  • Financial statements
  • Balance sheets
  • Total fixed assets
  • Income and expense accounts
  • General ledger

Common steps in closing the month-end books:

  • Record all incoming cash and accounts receivable
  • Review expenses and accounts payable records
  • Reconcile accounts
  • Review fixed assets
  • Inventory count (if necessary)
  • Collect and review financial documents
  • Prepare financial statements
  • Review all information for accuracy

Best Practices for a Month-End Close Process

When thinking about best practices for the month-end close, you may want to ask yourself these three questions about your month-end close process:

1.     Do I have sufficient visibility into the entire month-end close process?

2.     Have we done all we can to mitigate risk?

3.     Am I paying highly trained professionals to perform remedial tasks?

If you identify challenges based on those questions, you may want to implement some of these month-end close best practices.

Conduct Pre- and Post-close Team Meetings

During pre-close meetings, the team should discuss follow-up items from the previous month’s post-close meeting and determine the current month’s close schedule and timeline. This way everyone is clear on responsibilities and deadlines. You should also determine what staff should do if they run into barriers and how they should communicate any bottlenecks.

In post-close meetings, discuss what worked and what didn’t, and review assigned roles and responsibilities for the next month. Review any lessons learned, any variances or abnormalities, and entertain any proposed changes to the process.

Manage your Time, be Organized, and Communicate Efficiently

Understanding deadlines and schedules is critical so you can work toward an ideal close date. Being organized will help you stay on track. In addition, accountants must begin to cultivate strong written communication skills with the ability to think critically. They will also need strong oral communication skill and the ability to convey pertinent financial information to executive teams and stakeholders.

Build Relationships

Exceptional accountants know how to manage numbers and people. That requires cultivating a broader range of relationship skills today, such as how to work in a team and how to engage with other departments. If other departments are aware of what you are doing and what you’ll need for each month-end in advance, they may be more willing to contribute the financial data you need on time.

Take Advantage of Automation

Refocus your teams on analysis by replacing repetitive, spreadsheet-heavy work with leading-practice automation. Centralize data and close activities, automate journal entries and reconciliations, strengthen controls, and enhance visibility.

Common Challenges in a Month-End Close Process

Some challenges finance and accounting teams encounter when performing a manual close process include:

  • Team members don’t know what needs to be done and/or what is already completed
  • Inaccurate or incomplete data
  • Lack of standardization
  • Processes that are not clearly defined
  • Discrepancies between numbers
  • Delayed reconciliations due to errors, adjustments, and reclassifications
  • Lack of real-time data that results in little or no visibility and transparency

These challenges during the month-end close are likely why nearly 70% of CAOs recognize a need to change. The month-end close process relies on many people, technology, processes, and other inputs. As a result, accounting organizations are challenged by inconsistent data and processes and a lack of standardization across the enterprise—all while depending on spreadsheets, emails, phone calls, and in-person meetings to bring it all together.

As business leaders look for accounting to provide more real time insights, and while regulatory environments are increasingly complex, it becomes even more difficult for accounting to do it all on time without compromising compliance or control. Traditional manual accounting processes are simply not sustainable.

Transitioning away from manual workflows will give you access to one of the most efficient tools you’ll ever use: accounting automation.

How Financial Close Automation Technology Improves the Closing Process

In order to optimize the month-end close process, companies should embrace technology and innovation that enables transformation. Integrated solutions that address more than one aspect of the close process, and in particular, cloud solutions, are helping companies make the move to modern accounting—bit by bit. Let’s take a closer look at how automation technology improves the financial close process.

While there’s no one size fits all approach, many successful accounting organizations begin their optimization journey with close management by unifying data and processes and driving better accountability through visibility. Technology can be used to capture all tasks and embed workflow and segregation of duties. Leading solutions also help centralize supporting documents and provide dashboards for reporting on status and KPI’s.

Optimizing balance sheet substantiation and high-volume reconciliation processes is a natural next step, as preparing, reviewing, and retaining account reconciliations is a common pain point for accounting, and valuable resources spend a disproportionate amount of time on repetitive tasks like ticking and tying.

Technology not only standardizes account reconciliations using templates but improves continuity by embedding policies and procedures, reduces risk by importing general ledger account balances and other data directly from source systems, and drives efficiency by automating matching activities and up to 80% of certifications.

Another way to optimize the financial close is by addressing the journal entry process. Many organizations record hundreds, if not thousands of journal entries each month. Technology not only centralizes the journal entry process with workflow and integration to related balance sheet reconciliations but automates the creation, posting, and certification of a significant portion of a company’s entries. Harmonizing the process and supporting documentation in the cloud not only saves time during the close but also reduces audit testing and preparation.

Finally, intercompany accounting and governance is another area ripe for transformation, as it poses numerous challenges for accounting with complex regulatory requirements and cross-functional dependencies involving legal, tax, and other stakeholders. Accounting can use technology to proactively govern their intercompany process from transaction initiation through netting and settlement. End-to-end intercompany solutions facilitate the process with defined workflows, embedded controls, and automation.

This blog post was originally published on the BlackLine blog.

Read more about Modern Accounting:

Modern Accounting: The Impact of Investing in Accounts Receivable

Modern Accounting: Driving Sustainability

Modern Accounting: Why Does Intercompany Accounting Crash Your Close?


Home » Planning & Forecasting » Page 2

Filed Under: Financial Close & Consolidation Tagged With: BlackLine, Financial Performance Management, FP&A, modern accounting, Planning & Forecasting

Modern Accounting: The Impact of Investing in Accounts Receivable

September 29, 2022 by Revelwood

This is a guest blog post from our partner BlackLine, explaining how to gain confidence cash flow.

Historically, accounts receivable (AR) has been the victim of a lack of investment from a technological perspective. Primarily, this lack of investment in AR is the result of something simple: a misunderstanding.

AR is largely regarded as a necessary but transactional back-office function and not something that creates a “value-add” for the business. Unlike the core accounting of bookkeeping, AR’s reputation is that of a kind of conveyor belt. Necessary, but low impact in the grand scheme of things. As a result, AR is the victim of fundamental misunderstandings regarding how it can be optimized—and the business impact that the right optimization can have.

When finance professionals think about how to streamline or optimize AR, typically it has been viewed as something that may be better offshored or that the ERP already handles. This is due to it being largely manual, time-consuming, and often transactional. But this simply moves the problem elsewhere, rather than solving the underlying issue.

Investing in technology that automates the accounts receivable function grants you complete visibility over the flow of cash into your business, in real-time. The data, intelligence, and real-time oversight of working capital that optimized AR offers to businesses are invaluable, for several key reasons.

Unlocking Working Capital

Applying customer payments to customer accounts quickly and accurately is the cornerstone of successful AR. However, manual processes lead to significant delays in unlocking crucial cash flow.

Money owed by customers is one of the largest assets on any balance sheet. A recent report by PwC estimated that the amount of working capital held hostage in this way is an enormous €1.2 trillion globally. According to PwC, releasing this cash would be enough for global companies to boost their capital investment by 55%, without the need to look externally for funding or put their cash flow under unnecessary pressure. With interest rates as they are right now, never mind what might be on the horizon, looking internally to find opportunities to streamline cash flow and payment processes is a no-brainer.

Let me give you an example: on average, organizations are paid on day 50-55. For a business with $500m revenue, each day is worth $2m. By automating and optimizing payment processes, businesses can potentially release a significant amount of cash into the bottom line that can then be put to work in the business.

Releasing cash from receivables is the quickest and cheapest way to more working capital, yet organizations continue to rely on manual processes which don’t provide proper visibility and tie up cash for far longer than necessary. Investing in AR frees up more working capital, which means stronger business resilience and enables more effective decision-making. Put simply, it puts much more power in your hands and leaves much less up to guesswork.

Maintaining Lasting Customer Relationships

Credit controllers used to be a lot more persistent. This was clear in the terminology they used. They looked at customers as “debtors.” This sounds more akin to something you’d read in a Dickens novel than the way a business refers to its trusted partners.

The way you treat your customers not only reflects your efficiency internally but crucially shapes perceptions, both for potential new customers and those who might be on the fence about jumping ship. Chasing a customer for a payment that was made days before, simply because you’re reliant on manual processes that don’t give you proper visibility, could reflect poorly on your organization. Aside from the wasted time and effort, receiving an erroneous demand for payment on a bad day could be the difference between a continued relationship and a swift parting of ways.

Customers provide the value for our organizations. It’s our customers that are going to support us through the tough times. A mindset shift is required here at all levels of business, including the C-suite. Customers should be treated with the same respect when they owe money as when they don’t. Investing in AR creates the visibility over customer payment behaviors that is essential to this.

The right solution can unlock decision intelligence by removing time-consuming and error-prone processes involved in preparing, transforming, and visualizing data. This lets your teams make more informed decisions around credit risk policies, collection strategies, or credit limit increases to create greater value for the business. It can help you gain visibility into customer behavior changes. This could unlock opportunities for you to work with customers to solve payment challenges before they become a major problem, or increase their line of credit and in turn, your revenue. This can improve profitability by reducing the financial risks posed by write-offs and late payments.

Creating greater visibility over real-time payments allows you to leave the war of attrition over unpaid invoices behind. This leads to a more customer-centric approach to credit, collections, and complaints that can help you to maintain good customer relationships.

Retaining Talent for a Competitive Advantage

In an increasingly competitive business environment, the ability to attract and retain top talent is crucial to business success. A recent survey commissioned by BlackLine suggests that one of the first steps finance and accounting needs to take to retain their best workers is to eliminate transactional, mundane work. More than a quarter (28%) of FP&A professionals surveyed said there weren’t opportunities to learn new skills because transactional work takes up so much time, while a similar number (26%) claimed that they had become bored of the mundane, repetitive nature of their jobs. What’s more, a quarter (26%) also claimed not to have time to focus on future career development.

It’s clear that your talent wants to spend their time adding value, regardless of function. Completing a long list of manual tasks, which could be automated, is not adding value. If 80% of your time is spent on routine tasks that can be automated, that’s 80% of your value gone before any major or strategic tasks arise. This wasted energy wastes your employees, which passes on up the chain. 

Automation frees up F&A team members to focus on strategic, more career-focused goals, ensuring their motivation and energy is spent bringing value to your business (and not someone else’s).

Don’t Let Manual Processes Decide Your Fate

Many organizations have now automated processes such as accounts payable, but the prevalence of manual processes in accounts receivable continues to pose serious health issues for businesses. The problem is that automating some processes and not others could ultimately cost you more than you bargained for. If the budget only stretches so far, it’s essential to upgrade the process that will have the biggest impact. Let me explain by way of an analogy.

Imagine you need to dig a hole somewhere in your back garden. You could do it with a shovel, but it needs to be a very large hole, so doing it that way would take a huge amount of time and exhausting effort. So, you hire a contractor with the right equipment. This gets the job done much faster and with much less effort. The problem is, you didn’t know where exactly to dig the hole to begin with and you’ve dug it in the wrong place. Now, not only do you still need to dig the hole, but you need to repair the large area of back garden that is now a building site.

Automating some FP&A processes but leaving AR up to manual processes creates a similarly traumatic scenario. Choosing to invest in accounts receivable opens up a treasure trove of intelligence and profitability that could make the difference between success or failure. When it comes to accounts receivable, investment is no longer a nice-to-have, it is now a must-have for survival.

Read more about Modern Accounting:

Modern Accounting: Driving Sustainability

Modern Accounting: Why Does Intercompany Accounting Crash Your Close?

Modern Accounting: Four Key Ways AR Automations Propel Financial Operations

This blog post was originally published on the BlackLine blog.

https://www.blackline.com/blog/investing-in-ar-essential-for-survival

Home » Planning & Forecasting » Page 2

Filed Under: Financial Close & Consolidation Tagged With: accounting, accounting automation, BlackLine, Financial Performance Management, Planning & Forecasting, Planning & Reporting

  • « Go to Previous Page
  • Go to page 1
  • Go to page 2
  • Go to page 3
  • Go to page 4
  • Interim pages omitted …
  • Go to page 16
  • Go to Next Page »

Footer

Revelwood Overview

Revelwood helps finance organizations close, consolidate, plan, monitor and analyze business performance. As experts in solutions for the Office of Finance, we partner with best-in-breed software companies by applying best practices guidance and our pre-configured applications to help businesses achieve their full potential.

EXPERTISE

  • Workday Adaptive Planning
  • IBM Planning Analytics
  • BlackLine

ABOUT

  • Who We Are
  • What We Do
  • How We Help
  • How We Think
  • Privacy

CONNECT

Contact:

25B Vreeland Road, Suite 111 Florham Park, NJ 07932
201.984.3030
info@revelwood.com

Copyright © 2023 · Revelwood Inc. All rights reserved. Revelwood® and the Revelwood logo are registered marks of Revelwood Inc.