# Cash Summary report subtraction is not correct
**URL:** https://forum.manager.io/t/cash-summary-report-subtraction-is-not-correct/5684
**Category:** Uncategorized
**Created:** [May 6, 2016, 12:40am UTC](https://forum.manager.io/t/cash-summary-report-subtraction-is-not-correct/5684 "2016-05-06T00:40:17Z")
**Posts on this page:** 15
**Page:** 1
### Author:  [@timl206](https://forum.manager.io/u/timl206)
#### Post date: [May 6, 2016, 12:40am UTC](https://forum.manager.io/t/cash-summary-report-subtraction-is-not-correct/5684/1 "2016-05-06T00:40:17Z")
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?
---
### Author:  [@Tut](https://forum.manager.io/u/Tut)
#### Post date: [May 6, 2016, 1:05am UTC](https://forum.manager.io/t/cash-summary-report-subtraction-is-not-correct/5684/2 "2016-05-06T01:05:58Z")
What version of Manager do you have installed (under About Manager)?
---
### Author:  [@Tut](https://forum.manager.io/u/Tut)
#### Post date: [May 6, 2016, 1:07am UTC](https://forum.manager.io/t/cash-summary-report-subtraction-is-not-correct/5684/3 "2016-05-06T01:07:40Z")
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?
---
### Author:  [@lubos](https://forum.manager.io/u/lubos)
#### Post date: [May 6, 2016, 1:17am UTC](https://forum.manager.io/t/cash-summary-report-subtraction-is-not-correct/5684/4 "2016-05-06T01:17:47Z")
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?
---
### Author:  [@timl206](https://forum.manager.io/u/timl206)
#### Post date: [May 6, 2016, 1:22am UTC](https://forum.manager.io/t/cash-summary-report-subtraction-is-not-correct/5684/5 "2016-05-06T01:22:07Z")
I’m using the Manager version 16.4.42
---
### Author:  [@timl206](https://forum.manager.io/u/timl206)
#### Post date: [May 6, 2016, 1:29am UTC](https://forum.manager.io/t/cash-summary-report-subtraction-is-not-correct/5684/6 "2016-05-06T01:29:18Z")
I’ll send my accounting file to [lubos@manager.io](mailto:lubos@manager.io)
---
### Author:  [@timl206](https://forum.manager.io/u/timl206)
#### Post date: [May 6, 2016, 1:36am UTC](https://forum.manager.io/t/cash-summary-report-subtraction-is-not-correct/5684/7 "2016-05-06T01:36:20Z")
I sent you the file
---
### Author:  [@Tut](https://forum.manager.io/u/Tut)
#### Post date: [May 6, 2016, 1:45am UTC](https://forum.manager.io/t/cash-summary-report-subtraction-is-not-correct/5684/8 "2016-05-06T01:45:02Z")
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.
---
### Author:  [@timl206](https://forum.manager.io/u/timl206)
#### Post date: [May 6, 2016, 2:20am UTC](https://forum.manager.io/t/cash-summary-report-subtraction-is-not-correct/5684/9 "2016-05-06T02:20:53Z")
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.
---
### Author:  [@lubos](https://forum.manager.io/u/lubos)
#### Post date: [May 6, 2016, 3:26am UTC](https://forum.manager.io/t/cash-summary-report-subtraction-is-not-correct/5684/10 "2016-05-06T03:26:14Z")
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.
---
### Author:  [@timl206](https://forum.manager.io/u/timl206)
#### Post date: [May 6, 2016, 12:13pm UTC](https://forum.manager.io/t/cash-summary-report-subtraction-is-not-correct/5684/11 "2016-05-06T12:13:12Z")
Wow awesome! Thanks for the fast replies. Love this community and the product! 🙂
---
### Author:  [@timl206](https://forum.manager.io/u/timl206)
#### Post date: [May 6, 2016, 1:21pm UTC](https://forum.manager.io/t/cash-summary-report-subtraction-is-not-correct/5684/12 "2016-05-06T13:21:37Z")
It’s balanced, but now when I put another column with the same starting date as the other column, my Cash at the beginning of the period is different.
Cash at the beginning of the period should be $4687.42
but it shows $4592.83
I think something’s not quite right with the Foreign exchange gains (losses)
(Sorry to bother you again)
---
### Author:  [@Tut](https://forum.manager.io/u/Tut)
#### Post date: [May 6, 2016, 1:58pm UTC](https://forum.manager.io/t/cash-summary-report-subtraction-is-not-correct/5684/13 "2016-05-06T13:58:10Z")
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.
---
### Author:  [@timl206](https://forum.manager.io/u/timl206)
#### Post date: [May 6, 2016, 6:31pm UTC](https://forum.manager.io/t/cash-summary-report-subtraction-is-not-correct/5684/14 "2016-05-06T18:31:09Z")
Oh yeah, you’re right. I changed the main column to 3/2/2016 - today, and now it’s good. Thanks 🙂
---
### Author:  [@Ealfardan](https://forum.manager.io/u/Ealfardan)
#### Post date: [January 18, 2023, 3:33pm UTC](https://forum.manager.io/t/cash-summary-report-subtraction-is-not-correct/5684/15 "2023-01-18T15:33:18Z")