• 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
        • Workday Adaptive Planning Training
        • IBM Planning Analytics / TM1 Training
    • Products
      • DataMaestro
      • LightSpeed
      • IBM Planning Analytics Utilities
  • How We Help
    • Use Cases
    • Client Success Stories
  • How We Think
    • Knowledge Center
    • Events
    • News
  • Contact Us

Financial Performance Management

IBM Planning Analytics Tips & Tricks: Charts in Planning Analytics Workspace, Part 1

January 10, 2023 by Revelwood

Did you know IBM Planning Analytics Workspace (PAW) gives you many options for showing data in charts? Here are some tips and tricks for working with charts in PAW.

Scatter Chart vs Bubble Chart

A scatter chart is used to show relationships within your data. This type of chart is great to see patterns and groupings over a large set of values. A bubble chart is also used to show relationships and it is also great to see patterns. So what is the difference between the two types of charts? 

In this blog post, we explain the difference between the two types of charts. As you’ll learn, the type of chart makes a difference when reviewing your data. How to decide which chart to use? It’s simple – ask yourself how many details you want to see at once. 

The Waterfall Chart

PAW includes various visualizations that can be used to view your data. One of these visualizations entails a chart called a waterfall chart. This type of chart will help you show the components of a summarized number. It is very helpful in determining which values are beneficial to the total and which values are detrimental.

This blog post shows an exploration in PAW and its corresponding waterfall chart. 

Lines vs Area for Multiple Elements

A line chart is typically used to show values over time. This type of chart is great to see trends with your data. An area chart is also used to show values over time and is sometimes referenced as a line chart with the area below the line filled. While this is the case in PAW for a chart that contains a single line, it is not the case for a chart with multiple lines. 

Read this blog post to learn about a line chart versus an area chart. 

IBM Planning Analytics, which TM1 is the engine for, is full of new features and functionality. Not sure where to start? Our team here at Revelwood can help. Contact us for more information at info@revelwood.com. And stay tuned for more Planning Analytics Tips & Tricks weekly in our Knowledge Center and in upcoming newsletters!

Read more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: DefineCalc

IBM Planning Analytics Tips & Tricks: Top 3 Blog Posts of 2022

IBM Planning Analytics Tips & Tricks: 2022’s Top 3 Tips & Tricks Videos

Home » Financial Performance Management » Page 7

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

IBM Planning Analytics Tips & Tricks: 2022’s Top 3 Tips & Tricks Videos

December 20, 2022 by Revelwood

The Revelwood team has created many IBM Planning Analytics Tips & Tricks videos. Which ones made it into the top 3 with the most views on YouTube? [Drumroll please!]

They are (in order of the most views):

1. Shortcuts in PAW Models

In this video, we demonstrate how to save time when creating dimensions, cubes, processes and chores. We explain how to use a shortcut to create the components in your model. In legacy tools, such as Architect, you had to create these components piece by piece. With Planning Analytics you can create multiple components without having to navigate back and forth.

2. Color in Planning Analytics Workspace Charts

This video shows you how to add color to your multidimensional charts in IBM Planning Analytics Workspace (PAW). We demonstrate how to do this using an Exploration. You’ll learn how to easily add/change colors to make your charts easier to read and understand.

3. Filtering in Planning Analytics Editor

In this video, we demonstrate some approaches to filtering your elements when defining a subset in the Planning Analytics editor. You’ll learn how to:

  • Filter dimensions
  • Use descriptors such as “contains,” “equal,” and “start.” This eliminates the need to use *ZYX.
  • Filter elements
  • Reset filters
  • Add a second filter

Want to learn more? Take a look at all our IBM Planning Analytics Tips & Tricks videos. Get notified when we have a new video by subscribing to our Youtube channel.

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 Videos:

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

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

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

Home » Financial Performance Management » Page 7

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

IBM Planning Analytics Tips & Tricks: Excel TEXTBEFORE & TEXTAFTER

December 13, 2022 by Lee Lazarow

A while back, I wrote a blog about using Excel to manipulate text. The functions in that blog allow you to rip text apart and put the pieces together so you can parse out pieces of your text strings. Since that writing, Microsoft has introduced two additional functions that can help you search for specific text values. These functions are TEXTBEFORE and TEXTAFTER.

  • TEXTBEFORE will return text before the characters you are searching for
  • TEXTAFTER will return text after the characters you are searching for

Both functions have two required parameters:

=TEXTBEFORE(text,delimiter)

=TEXTAFTER(text,delimiter)

  • The text parameter defines the string value you are searching for
  • The delimiter parameter defines the point after you want to extract

In addition, there are optional parameters that can be used to determine case sensitivity and what to do if no match if found.

The following example shows how to use these functions:

Graphical user interface, text, application, chat or text message

Description automatically generated

This approach will simplify your searches by eliminating the need to merge functions such as FIND, and LEN and LEFT/RIGHT together.

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: How to Set Up Action Buttons in Planning Analytics for Excel

IBM Planning Analytics Tips & Tricks: Excel SEQUENCE

IBM Planning Analytics Tips & Tricks: PAW Go To Line in Process

Home » Financial Performance Management » Page 7

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

Modern Accounting: Adjusting Journal Entries

December 8, 2022 by Revelwood

This is a guest post from David Brightman at our partner BlackLine, explaining why it’s necessary to adjust journal entries. 

What Are Adjusting Journal Entries?

Adjusting journal entries are used to adjust a company’s financial statements and bring them into compliance with relevant accounting standards, such as generally accepted accounting principles (GAAP) or International Financial Reporting Standards (IFRS). The activity of adjusting journal entries is routinely performed by accountants to allocate income and expenses to the actual period in which the income or expense occurred or earned—a feature of accrual accounting.

Five Common Types of Adjusting Journal Entries

There are many different types of adjusting journal entries, but the five most common types are:

1)    Accrued revenue is revenue that has been recognized by the business, but the customer has not yet been billed. This type of revenue is common in service-related businesses, as services can be performed several months before a customer is invoiced. Revenue must be accrued, otherwise revenue totals would be understated, especially compared to expenses for the period. 

2)    Accrued expenses are those that have been incurred before they have been paid. For example, a company purchases supplies from a vendor but has not yet received an invoice for the purchase. Other examples of accrued expenses include interest payments on loans, warranties on products or services, and taxes.

3)    Deferred revenues indicate when a company receives payment in advance of work that has not yet been completed. This is common for professional firms that work on a retainer—such as a law or CPA firm. A client may pay in advance for work that is to be done over a period of time. When the revenue is later earned, the journal entry is reversed.

4)    Prepaid expenses need to be recorded as an adjusting entry. Many companies prepay rent for an entire year. The company will record the expense each month for the next 12 months to account for the rental payment properly. Without this, financial statements will reflect an unusually high rental expense in one month, followed by no rental expenses at all for the following months.

5)    Depreciation expenses, including depreciation expense and accumulated depreciation, need to be posted to properly expense the useful life of a fixed asset. Depreciation is a fixed cost and does not negatively affect cash flow, but the balance sheet would show accumulated depreciation as a contra account under fixed assets.

Given the nature of adjusting entries, they often impact both the balance sheet and the income statement. Adjusting entries are also used to correct financial errors and must be completed before a company’s financial statements can be issued. For example, something is capitalized and booked to a Fixed Asset account that, under company policy, should be booked to an expense account like Supplies Expense, or vice versa.

Where Do Adjusting Journal Entries Fit into the Financial Close Process?

At the end of each financial period, accountants go through all the prepaid and accrued expenses as well as unearned and accrued revenue and identify necessary adjusting entries.

This is often a time-consuming process that involves spreadsheets to track expenses and payments made against those expenses as well as revenue earned and payments received against that revenue.

These adjustments are often a result of the account reconciliation process during the financial close. They may also be detected by doing variance analysis of account balances to detect any unusual balance fluctuations.

How to Record Adjusting Journal Entries

When the need for an adjusting journal entry is identified, accountants prepare the journal entry to credit and debit appropriate accounts. In theory, the process for recording an adjusting journal entry can be broken into 3 steps:

1)    Determine the current account balance

2)    Determine what the current balance should be

3)    Record an adjusting entry

This is likely oversimplifying, since companies may have hundreds or thousands of adjusting journal entries to make each period, but it gives an overview of the process needed for each entry. In addition, adjusting journal entries should include supporting documentation, links to applicable policies and procedures, and be properly reviewed and approved before being posted.

Examples of Adjusting Journal Entries

One example is to accrue for unpaid wages at month-end. A potentially more intricate example may be rebate accruals. Rebates are payments made back to you from a supplier (or from you to a customer) retrospectively, reducing the overall cost of a product or service.

In this case, you may have an arrangement with a supplier to earn a quarterly rebate based on your overall spend with that supplier. Imagine the supplier’s policy is to pay the rebate at the end of the year. Then, from an accounting perspective, this may need to be accrued for when the rebate is earned, not when it is received.

When preparing the entry, it’s helpful to reference your company’s policy and procedure to ensure compliance, and it is best practice to attach supporting documents to the journal entry, like the contract and terms. This will help speed up the approval process, as well as any audit work later.

This blog post was originally published on the BlackLine blog.

Read more about Modern Accounting:

Modern Accounting: Highlights from Beyond the Black 2022

Modern Accounting: Does Your Accounting Team Have SMART Goals?

Modern Accounting: The Impact of Investing in Accounts Receivable

Home » Financial Performance Management » Page 7

Filed Under: Financial Close & Consolidation Tagged With: BlackLine, Financial Performance Management, modern accounting, 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 » Financial Performance Management » Page 7

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: Excel SEQUENCE

November 22, 2022 by Lee Lazarow

Have you ever needed to quickly generate a list of numbers? Maybe you need to create a list from 1-100. Maybe you want to create a list of the first 100 even numbers. Maybe you want to create those same lists in descending order. Did you know that Excel has a function called SEQUENCE which allows you to quickly create these lists?

The SEQUENCE function is used to generate an array of sequential numbers.  The syntax of the function is:

=SEQUENCE (rows, [columns], [start], [step])

  • Rows (required)
    • This is the number of rows to be filled
  • Columns (optional)
    • This is the number of columns to be filled
    • If skipped, this defaults to 1
  • Start (optional)
    • This is the starting number in the sequence
    • If skipped, this defaults to 1
  • Step (optional)
    • This is the increment for each subsequent value
    • If skipped, this defaults to 1
    • This can be negative to provide a descending list

The following example shows a single column list from 1-10

Chart

Description automatically generated with medium confidence

The same formula doubles the result when the column parameter is defined. Note that the results read from right to left (e.g., the entire row) and then goes down.

Table

Description automatically generated with medium confidence

Here is the same formula when adding both a starting value and an increment.

Table

Description automatically generated

Not only can this formula be used to quickly generate lists, but it can also be used as part of a combination:

  • With the DATE formula to define a calendar
  • With the TIME formula to create a daily schedule
  • With data from another column to create unique IDs for items like products or employees

Read more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: Creating Control Objects from the Modeling Workbench

IBM Planning Analytics Tips & Tricks: Shortcuts in PAW Models

IBM Planning Analytics Tips & Tricks: Customizing Background Colors for Data and Header Cells

Home » Financial Performance Management » Page 7

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

FP&A Done Right: ESG – An Imperative for Growth

November 18, 2022 by Revelwood

FP&A Done Right

As part of our series on ESG reporting, we are featuring guest blog posts from our partners. This post from Workday Adaptive Planning highlights thoughts from finance leaders on ESG and more.

How can companies “walk the talk” to create value for society and improve business outcomes by investing in environmental, social, and governance (ESG) efforts? Barbara Larson, a finance leader at Workday, joined McKinsey & Company partner Giulia Siccardo and Ann Dennison, executive vice president and CFO at Nasdaq, to discuss this topic and more at Conversations for a Changing World.

Almost 9 in 10 (87%) people believe a company should create value for society, not only its shareholders. But only half think that companies actually place people over profit, said Giulia Siccardo, partner and environmental, social, and governance (ESG) expert at McKinsey & Company. Siccardo added there’s much at stake in closing that gap, because companies that invest in ESG are able to deliver higher returns to shareholders.

At our digital event Conversations for a Changing World, Siccardo teed up a discussion on how companies can “walk the talk” when it comes to ESG. Ann Dennison, executive vice president and CFO at Nasdaq, and Barbara Larson, senior vice president of accounting, tax, and treasury at Workday, shared deeper insights on how organizations can roll out these efforts. 

Dennison explained that Nasdaq has begun helping to shape ESG reporting in the U.S. “We believe in a sustainable future, and we believe we can be part of helping to build a sustainable future,” Dennison said of Nasdaq, which has been carbon neutral for three years.

As one example of its progress: In August, the SEC approved Nasdaq’s new rule requiring listed companies to annually disclose board-level diversity statistics using a standardized template. “We believe this is about transparency that will help build a better reporting framework for the future, and help drive knowledge and diversity across the listed companies,” Dennison said.

ESG isn’t a nice-to-have. For Nasdaq, Dennison said, ESG is imperative for growth. “Gone are the days of the investor being the only stakeholder,” she said. An organization’s stakeholder base now includes its customers, employees, and communities.

“If you want to grow your investor base, you need to be focused on ESG,” Dennison said.

Nasdaq provides several solutions to help companies do that. With its ESG Data Hub, investment managers enter their diversity data, while asset owners assess that data to determine how to allocate their dollars. Nasdaq OneReport assists corporate clients in navigating the reporting complexity of ESG. And with Nasdaq’s carbon removal marketplace Puro.earth, corporate clients can procure offsets to neutralize their carbon footprint.

To bolster its own ESG reporting, Nasdaq placed its ESG function within its finance function within the past year. That shift in its ESG reporting structure is part of Nasdaq’s long-term vision, Dennison said, “to fully leverage our data across the organization.” For instance, Nasdaq has used Workday data to get a holistic look at its suppliers’ diversity. “Without that data, we can’t have a plan,” Dennison said.

Dennison shared three strategies for CFOs to meet their own ESG goals:

  • “ESG has to be part of your overall business strategy, not a side job,” Dennison said. It should be part of board-level conversations and objectives.
  • Think about the long-term strategy. “Then break that down into smaller pieces in the short term,” shared Dennison. That should include identifying near-term key performance indicators.
  • “Use your data in the most powerful way,” she explained. Automate where you can.

Interested in learning more? Watch the full session here.

Read more in our series on ESG Reporting:

FP&A Done Right: ESG Reporting Tools

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

Modern Accounting: Driving Sustainability

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

More from Workday Adaptive Planning:

FP&A’s Role in ESG Planning and Reporting

Planning for a Sustainable Future: How Organizations Can Deliver Data-Driven Results

This blog post was originally published on the Workday Adaptive Planning blog. https://blog.workday.com/en-us/2021/finance-leaders-discuss-why-esg-imperative-business-growth.html

Home » Financial Performance Management » Page 7

Filed Under: FP&A Done Right Tagged With: Budgeting Planning & Forecasting, Environmental Social Governance, esg, Financial Performance Management, Workday, Workday Adaptive Planning

IBM Planning Analytics Tips & Tricks: PAW Go To Line in Process

November 15, 2022 by Lee Lazarow

Sometimes your TurboIntegrator scripts can become very long. While it’s nice to be able to scroll up and down throughout your code, there are times that you may want to go directly to a specific line. IBM Planning Analytics Workspace (PAW) version 79 allows this via the “Go to Line” button.

Once clicked, you are prompted to select a section and a line within the section.  

When defining a line, note that the line numbers restart within each section. In the example below, each set of generated statement lines begin at line 2 (since I like to skip a line for easy reading) and the first line of code in the Data section begins at line 5.

This approach will help you speed up your navigation as you write code in TurboIntegrator.

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: Planning Analytics Workspace Borders in Preview

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

IBM Planning Analytics Tips & Tricks: MDX Syntax Explained

Home » Financial Performance Management » Page 7

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

FP&A Done Right: Approaches to Long-Term Planning

November 14, 2022 by Lee Lazarow

“If you fail to plan, you are planning to fail.” – Ben Franklin

In our collective rush to react to ever-changing marketplace dynamics and shifts in the economy, it’s easy to focus on short-term plans, to the neglect of long-term planning. Today’s leaders need to have several plans – short-term, medium-term, and long-term.

Different plans for different needs

How do these plans differ? A short-term plan is designed to show granular details for a limited time frame. This is often updated monthly, although we have some clients updating their plans on a weekly basis. One of our clients follows a process where local managers update their plans on Mondays and Tuesdays, have the regional managers review the data on Thursdays, and allow senior management to analyze and assess the data on Fridays. Each Monday they start the process over.

Most organizations utilize a medium-term plan that looks out anywhere from a few quarters to a full year. Most people will think of this as a standard monthly forecast with data at a bit more of a higher level, but still somewhat details.

A long-term plan often goes out multiple years. Many companies create a 5-year plan, although some industries such as entertainment and pharmaceutical often create 20-25 year plans. A long-term plan is a high-level view of the business. It’s not nearly as granular as short, or even medium-term plans. The plan does not get down to the level of looking at a GL account or a customer. It’s a measuring tool and a defined way of reviewing the progress of the company. In short, long-term planning helps to set the company’s direction.

The essentials of long-term planning

The long-term plan gives you guidance on how to answer several questions, including:

  • How can we expand the company?
  • How can we look into acquisitions?
  • What products, geographies, and verticals can we or should we add?
  • What products no longer make sense?
  • How do debt payments impact cash flow?
  • What type of labor, buildings, locations, and equipment do we need?

A long-term plan can be considered a proactive approach to risk mitigation, enabling companies to plan, think ahead, prepare for, and lessen the impact of potential negative effects. At Revelwood, we recommend two approaches to long-term planning: the growth percent approach and a driver-based approach.

We often see both of these methods used when performing long-term planning in IBM Planning Analytics with Watson:

Growth percent approach

The growth percent approach allows you to adjust groups of data (accounts, departments, etc.) by increasing or decreasing the values from the previous year. Some clients prefer to simply use a single percentage (example: reduce all expenses by 2% each year for the next five years) whereas some clients prefer to include more variation (example: reduce utilities expenses by 2% next year, by 3% the following year, and by 4% for the next three years). But no matter what level of detail is used, Planning Analytics’ powerful scripting tool will perform the entire long term plan in a matter of seconds.

Driver-based approach

A driver-based approach uses operational activity to calculate key variable revenues and expenses. This approach allows you to simplify the input by defining a set of drivers and creating calculations that use the drivers.  For example, a single driver of “units sold” can be used to immediately calculate revenue, COGS, and some of your variable expenses using the tool’s efficient calculation engine.

Mitigate risk with long-term planning

Long-term planning is your company’s assurance against planning to fail. There’s a reason why Franklin’s quote has lasted through the years. And it should be the motto of every planning team.

Learn more about long-term planning by watching our on-demand webinar – Long-Term Planning in IBM Planning Analytics.

This post originally appeared on IBM’s Journey to AI blog.

Home » Financial Performance Management » Page 7

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

  • « Go to Previous Page
  • Page 1
  • Interim pages omitted …
  • Page 5
  • Page 6
  • Page 7
  • Page 8
  • Page 9
  • Interim pages omitted …
  • Page 47
  • 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

World Headquarters

Florham Park, NJ | 201 984 3030

European Headquarters

London & Edinburgh | +44 (0)131 240 3866

Latin America Office

Miami, FL | 201 987 4198

Email
info@revelwood.com

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