Skip to main content
Documentation
Documentation
Adaptive Planning
Last Updated: 2023-06-23
Example: Create Cash Flow Reports Using Existing Excel Report Format

Example: Create Cash Flow Reports Using Existing Excel Report Format

This example illustrates how to use an existing Excel cash flow report format to create a cash flow report in OfficeConnect. For a use case related to this topic, see Use Case: Create OfficeConnect Cash Flow Reports Using Excel in the Use Case Library.
You have an existing cash flow report format in Excel.
The report format includes these rows:
  • Beginning Balance
  • Total Operating Adjustments
  • Total Investing Adjustments
  • Total Financing Adjustment
  • Net Income
  • Net Cash Flow
  • Ending Balance
The report format includes these columns:
  • Actuals for Jan - Mar of FY 2025
  • Budget What if Scenario for Mar 2025
  • Variance amount for Mar 2025.
  • Variance percentage for Mar 2025.
You want to convert the static Excel report format into a live report by linking it with OfficeConnect elements. You can then refresh the report with data directly from Adaptive Planning.
Depending on how your model is set up, your cash flow accounts might not exactly match the ones mentioned in this example. Similarly, your organization might generate this report for different time periods and frequencies such as quarterly or annually.
  • Your model includes: .
    • Actual and budget versions.
    • Q1 monthly data for FY 2025.
    • The required cash flow accounts listed in the scenario
  • An existing cash flow report format in Excel with no data. To convert this to a live OfficeConnect report, you’ll update it with your Adaptive Planning dimensions while keeping the existing formatting.
  • Security:
    Access OfficeConnect
     permission
  1. In Excel, open your existing cash flow report format.
  2. Click the
    OfficeConnect
     tab and log in if you're not already logged in.
  3. From the
    Elements
     tab, search for each cash flow account and apply it to the corresponding cash flow account row in the Excel report:
    1. In the Excel report, select a cash flow account row. Example: Select the row for Total Operating Adjustments.
    2. In the
      Elements
       tab, search for the cash flow account. Example: search for Operating Adjustments.
    3. From the search results, select the appropriate cash flow account, right-click, and then from the context menu, select
      Apply to Selection
      . Example: Select and apply the Operating Adjustments OfficeConnect element to the Total Operating Adjustments row in the Excel report.
    4. Repeat these steps for each cash flow account.
  4. From the
    Elements
    tab, find each time period and apply it to the corresponding time period column in the Excel report:
    1. In the Excel report, select a time period column. Example: Select the column for Jan 2025.
    2. In the
      Elements
      tab, expand the
      Time
      element to display the calendars and their time strata. Example: Expand the DefaultTimeHierarchy element to display the years, quarters, and months in the hierarchy.
    3. Select and apply the appropriate time element to the selection. Example: Select and apply the Jan 2025 OfficeConnect element to the Jan 2025 column in the Excel report.
    4. Repeat these steps for each month in Q1 of FY2025.
  5. From the
    Elements
    tab, find each version and apply it to the corresponding version in the Excel report.
    1. In the Excel report, select a column with a version. Example: Select the Actuals column.
    2. In the
      Elements
      tab, expand the
      Versions
       element to display the different versions in your model.
    3. Select and apply the appropriate version element to the selection. Example: Select and apply the Actuals OfficeConnect element to the Actuals column in the Excel report.
    4. Repeat these steps for the Budget version.
  6. Add labels to display the monthly time periods:
    1. In the Excel report, select the cells where you want to display the time period labels. Example: Select the cells where the Excel time period labels currently display.
    2. From the OfficeConnect ribbon, select
      Labels
      . The Label Definitions dialog displays.
    3. Select the
      Time
      label.
    4. Select and add the
      {Time Display Name}
      label type value to the
      Label expression
       field. Click
      OK
      .
  7. Add labels to display the versions:
    1. In the Excel report, select the cells where you want to display the version labels. Example: Select the cells where the Excel version labels currently display.
    2. From the OfficeConnect ribbon, select
      Labels
      . The Label Definitions dialog displays.
    3. Select the
      Version
      label.
    4. Select and add the
      {Version Display Name}
      label type value to the
      Label expression
       field. Click
      OK
      .
  8. Click
    Refresh
    .
The report is now linked to Adaptive Planning and displays the latest cash flow data from your model. The amount and percentage variance columns continue to use Excel calculations to display the variance data based on the latest numbers.
Update your OfficeConnect cash flow report anytime by adding new time periods or replacing the existing ones and refresh it to display the latest data from Adaptive Planning.