Hey, so I was calculating the Cash Summary report, and I noticed that when I subtracted the Inflow with the Outflow, my calculations were different from what it is on my report.
Here’s what it is on the report:
Total inflows: $3346.95
Total outflows: $2753.94
Net increase (decrease) in cash held: $773.39
Here’s what I calculated:
Total inflow - total outflow = net increase (decrease) in cash held
$3346.95 - $2753.94 = $593.01
Can someone please explain what I did wrong or it there a bug in the report that needs to be fixed?
Also, are you doing cash or accrual based account? And does your Summary page show anything in the Suspense account? And does the cash at the end of the period on the report agree with your actual total of cash on hand in cash and bank accounts on the end date of the report?
This is definitely a bug. Under no circumstances should report show discrepancy. Any possibility you could send me your accounting file to lubos@manager.io so I can have a look at this?
I thought perhaps you had an ancient version, but you are quite up to date. I am also at a disadvantage, because I don’t know how Manager calculates the net increase for the report. @lubos’s quick reply suggests there is no hidden magic, just the difference between the two numbers. I was grasping at straws.
My quick guess is that it probably has something to do with the Foreign exchange gains (losses), because I work with 3 different currencies, and I recognise that it doesn’t take those exchange gains (losses) into account.
Your assumption is correct. The report was missing foreign exchange gains (losses). I fixed the report in the latest version (16.4.52) so it should all balance now.
Were there transactions on 3/1/2016? The far right column in your screen shot shows ending balance on that date. According to what you wrote, the main column shows results beginning on 3/1/2016.
