Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Suggested answer

Management Reporter Question

Posted on by 2

Hi, I have a question I need to ask regarding the Management Reporter. I have a financial report of a cash flow statement that summarizes the cash and cash equivalent of the company. That was all built and designed properly in the Management Reporter. But there is one issue, the client wants to deduct the cash and cash equivalent of that year the report got generated by, minus the cash and cash equivalent of the previous year. So basically, if the report got generated in 2023, I want the cash and cash equivalent of the previous year to be also generated based on the previous year. Therefore, I can deduct the cash and cash equivalent of 2023 minus cash and cash equivalent of 2022. Is that something I can do in the Management Reporter. Note that this is not a main account, but it is a calculation formula. Here is an example. Is there a way I can calculate the cash and cash equivalent for a previous year knowing that it has the same formula for that of 2023.

 

Statement of Cash Flow for December 31, 2023

 

 

 

Net Cash used in Operating Activities

 $ (2,643,047.00)

Net Cash used In Operating Activities

 $ (469,090.00)

Net Cash provided by Financing Activities

 $  5,404,720.00

 

 

Net Increase in Cash and Cash Equivalent for 2023

 $   2,292,583.00

Cash and Cash Equivalent for 2022

$    1,000,000

 

 

Cash and Cash Equivalent on December 31, 2023

 $   1,292,583.00

  • Suggested answer
    salman ahmad Profile Picture
    salman ahmad 97 on at
    Management Reporter Question
    Hi 
    based on the statements looks like you want to compare the both years and then wants to checck the variance of both years.
    1.Go to column definition.
    2.open column of your CFS.
    3.add a new column and in base year enter base-1 and save.
     
    it will give you the previous year calculated value now if you want to deduct the or want variance just do this "calc A-B".
  • Management Reporter Question
    @KevinXia
     
    Hi Kevin,
     
    Thank you for your response. But my question was not meant like that. The thing is that I want to calculate the 2022 cash and cash equivalent in the same report I generated the 2023. cash and cash equivalent.  So basically, if the report got generated in 2023, I want the cash and cash equivalent of the previous year to be also generated based on the previous year. Then and only then, I can deduct the 2023 cash and cash equivalent minus 2022 cash and cash equivalent.
     

    Statement of Cash Flow for December 31, 2023

     

     

     

    Net Cash used in Operating Activities

     $ (2,643,047.00)

    Net Cash used In Operating Activities

     $ (469,090.00)

    Net Cash provided by Financing Activities

     $  5,404,720.00

     

     

    Net Increase in Cash and Cash Equivalent for 2023

     $   2,292,583.00

    Cash and Cash Equivalent for 2022

    $    1,000,000

     

     

    Cash and Cash Equivalent on December 31, 2023

     $   1,292,583.00

     
    In this example, I generated the report for Cash and Cash equivalent in 2023, but I also want to generate the Cash and Cash equivalent for 2022 in the same report knowing that this is not a main account. Is there a way I can bring that to the report and show that balance for that previous year
     
    Thank you and I hope that helps better
  • Suggested answer
    Kevin Xia Profile Picture
    Kevin Xia Microsoft Employee on at
    Management Reporter Question
    Hi,

    Based on the information you provided, in the cash flow statement, you want to deduct the cash and cash equivalent of the previous year from the cash and cash equivalent generated in the current year.

    To achieve this, you can follow these steps:

    1. Open the design of the financial report in Management Reporter.
    2. Insert a new calculation row at the appropriate position.
    3. Use the correct formula to subtract the cash and cash equivalent of the previous year from the cash and cash equivalent of the current year. For example, the formula could be "=2023 cash and cash equivalent - 2022 cash and cash equivalent".
    4. Ensure that the formatting and positioning of the calculation row are set correctly to display the desired result in the report.

    With this setup, you should be able to calculate and display the difference between the cash and cash equivalent of the current year and the previous year in Management Reporter.

    Best regards,
    Kevin

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans