You’re offline. This is a read only version of the page.
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 |
|
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 |
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:
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,228
Super User 2024 Season 2
#2
Martin Dráb
230,056
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (