BC-GL-RT4 Cash Flow Statement

Applies to

• Product version: Velixo NX
• ERP: Dynamics 365 Business Central
• Functional area: Financials, Other
• Plan: All
• Template type: Production Report template

TABLE OF CONTENTS

• Applies to
• Description
• Coverage
• Typical audience
• Features
• Preview
• Download this template
• Documentation
  • Filters
  • Cash Flow Statement Structure
  • Time Period
• User Guide
  • Configuring the report
  • Using the report
  • Managing Account Structures
• Version History

Description

The BC-GL-RT4 Cash Flow Statement is a generic report for users to have a comprehensive view of their company’s cash inflows and outflows during a specific period. This report offers valuable insights into how cash is generated and utilized in Operating, Investing, and Financing activities.

Coverage

This workbook includes the following sheets:

• Cash Flow Statement: the cash flow statement reflecting the operational, investment, and financing activities during a specific period of time.
• Options: the template’s settings sheet that used for data validation lists and various lookups and configurations.
• Information: the information sheet of the report, used for storing useful details about the report such as: code, version, article link to keep track of the origin of the report.

Typical audience

The typical users of this type of report are Finance professionals: Accountants, CFOs, Controllers 

Features

The following features are used by this report. To use this report, please ensure that your Velixo license includes all of them, (or contact Support or Sales):

• Financial functions
• List functions
• Query functions

Preview

Download this template

Template will be available for download soon

💡Having trouble downloading the file?

Simply right-click on the link and select Save Link As

Documentation

Navigating and utilizing the BC-GL-RT4 Cash Flow Statement is an intuitive process, designed for simplicity, genericity and efficiency. The template comes pre-configured with the most common line items, streamlining the reporting process with minimal user effort.

Filters

Located in the upper left of the sheet, the filters include:

• Dimensions: lists all dimensions present in Dynamics 365 Business Central instance
• As of (Period): a date field. Please use the last date of a financial period/month

These filters are seamlessly linked to the data on the Options tab.

Note: The dimension list updates dynamically based on the number of dimensions configured in your instance. However, the template can process a maximum of 10 dimensions per company. If your instance includes more than 10 dimensions, please contact Velixo Support for assistance.

Cash Flow Statement Structure

Sections: Velixo has thoughtfully structured the Cash Flow statement using the most common sections that should be generic, by default.

The following activities are used:

• Operating Activities
• Investing Activities
• Financing Activities

Default line items were added as well per activities and are highly customizable depends on the user’s requirements. These are based on the native Dynamics 365 Business Central cash flow statement report, making it as streamlined with the ERP as possible.

Time Period

The incorporated time periods encompass the following:

Month-to-date:

• Provides the movement balance for the selected month on the As of date.
• For example, if a user selects 6/30/2019, the returned balance spans from June 1st, 2019, to June 30th, 2019.

Year-to-date:

• Provides the accumulated balance from the start of the fiscal year (depending on the user input for the fiscal start month on the Options tab) up to the indicated as-of-date.
• For example, if a user selects 6/30/2019, and the specified fiscal start month is April, the returned balance spans from April 1st, 2019, to June 30th, 2019.
• To obtain the full year position, it is crucial to specify the last date of the fiscal year.

Prior Months YTD:

• Velixo added prior months on the time period to provide a better view of the cash position for different periods. This can be used as well for comparison and analysis.
• For example, if a user selects 6/30/2019, the Prior Months YTD will return the balance for May and April 2019.

User Guide

Configuring the report

A quick setup is needed to get the most out of the report. These settings control how balances are pulled from the system and displayed in the report.

Setting Up Account Subcategories or Account Codes/Ranges

Each statement line in the report should be mapped to the corresponding account subcategories or account codes. This mapping defines how Velixo retrieves data from the system. To set this up:

• Expand the grouped columns on the leftmost side of the report

• Doing so will display the configuration columns D and E for the Account Subcategory and Account Code/Range.

• The report includes default subcategories based on the Velixo demo instance. These may not match your company’s configuration. Update the subcategories or account codes as needed to align with your instance setup.

Note: By default, the Account Code takes priority over the Account Subcategory. If both are specified in the configuration, the template will ignore the subcategory and extract balances based solely on the account code.

Using the report

Now that we've covered the report overview, let's dive into a step-by-step guide on effectively utilizing the report:

• Set the Connection Name on the Options Sheet: crucial for all processes, set the Connection Name on the Options sheet by updating cell A2. Ensure it matches the name used during Velixo application login.

• Update the Options Sheet: As the foundation for filters on the Cash Flow Statement sheet, keep the Options sheet up to date. It should always and automatically capture the latest dimensions and structures from your Dynamics 365 Business Central instance.

• Choose Desired Filters: after updating the Options sheet, select desired filters for the report:
  • Dimensions
  • As of (Period)

• Automatic Report Update: selecting any filter will automatically update report balances. Begin analyzing the report with the latest data.

• Variances Investigation: if discrepancies arise between data extracted at the account subcategory and account code levels, conduct a thorough investigation to resolve any differences.

Managing Account Structures

As outlined earlier in this document, users have the flexibility to tailor this report to their specific needs. It is not required but may be useful if the default statement lines don't quite fit the requirements.

Adding a new line item

If users desire a structure beyond the provided default line items, they can leverage account groups set up in their ERP instance. However, caution is crucial to avoid overlap between account subcategories, preventing inaccuracies.

Users have two options when adding new account structure:

1. Re-purposing an existing line item:
   • Rename an existing line item, replacing it with the desired custom account line item
   • Assign the corresponding account subcategories or account codes to the new line item
2. Adding a Row in the required Cash Flow Activity section:
   • Use Excel functions to add a new row in the desired section
   • Be cautious with formulas in the newly added rows; copying from existing rows in the same section ensures accurate results

Version History