Discrepancy on Cash Flow Statement

1

I have encountered an issue where the cash amount at the end of a period in the Cash Flow Statement does not match the amount listed on the corresponding Balance Sheet.

To demonstrate, I created a test company with a few transactions, with the reports below:

Screenshot 2023-07-24 131518
Screenshot 2023-07-24 131518946×804 31.5 KB

Screenshot 2023-07-24 131453
Screenshot 2023-07-24 131453952×661 18.3 KB

Screenshot 2023-07-24 131428
Screenshot 2023-07-24 131428942×533 18.4 KB

I believe the issue is the Currency Gains/Losses. If they are not added back in the Cash Flow Statement, the Net Increase in Cash Held becomes:

177,000 - 47,500 - 33,250 = 96,250
(Net Income - Change in AR - Change in Inventory = Net Increase in Cash)

…which matches the Balance Sheet cash figure.

Is this a bug?

2

This would be definitely a bug. Those reports need to be consistent no matter what.

Can you send me the test file to lubos@manager.io ? I’ve noticed you are using the new way to calculate realized / unrealized currency gains (losses) and I must have missed something.

2 Likes