# Cash shown in report does not match cash in account **URL:** \ **Category:** V4 Issue\ **Created:** [May 7, 2014, 10:10pm UTC](https://forum.sambapos.com/t/cash-shown-in-report-does-not-match-cash-in-account/1223 "2014-05-07T22:10:11Z")\ **Posts on this page:** 15\ **Page:** 1
**Author:** ![plume](https://forum.sambapos.com/user_avatar/forum.sambapos.com/plume/32/1190_2.png) [@plume](https://forum.sambapos.com/u/plume)\ **Post date:** [May 7, 2014, 10:10pm UTC](https://forum.sambapos.com/t/cash-shown-in-report-does-not-match-cash-in-account/1223/1 "2014-05-07T22:10:11Z")
Hello, We went live this morning, everything rocks except cash in Report. ## In Account - Cash: OK After the first work period, I have **731.30** in cash (which is correct and match the reality) This the sales in `cash` + `the cash-in` - `the cash-out` - `Change`. See figure 1. ## In Report : Not OK The work period report shows cash = **887.10** This is `the sales` only … **(BUT the cash-out is not deduced, + `the cash-in` is not added, …)** See figure 2. It looks like that the cash in report does not take in account the transaction related to: - Change - Cash in - Cash out Which affect the CASH account though. _Note: I have 2 extra buttons (cash in and cash out), which seems to work as it can be seen in Account - Cash. I also have a Change transaction to give the change in local currency when paid in USD, it also seems to work._ Did I miss something when creating Change, cash in cash out ? Figure 1: ![](https://forum.sambapos.com/uploads/default/original/3X/3/d/3d6e552921f1a7a78f5b9ae53a2554fa69656959.png) Figure 2: ![](https://forum.sambapos.com/uploads/default/original/3X/c/9/c975ce5ce59a8df43a22017e37da47b034ec600c.png) Thank you Marc ---
**Author:** ![emre](https://forum.sambapos.com/user_avatar/forum.sambapos.com/emre/32/39073_2.png) [@emre](https://forum.sambapos.com/u/emre)\ **Post date:** [May 8, 2014, 6:22am UTC](https://forum.sambapos.com/t/cash-shown-in-report-does-not-match-cash-in-account/1223/2 "2014-05-08T06:22:28Z")
Work period report displays cash income not cash drawer balance. For example you sold $300 items. Tendered $200 cash and $100 cc. When all tickets settled the `Total Income` amount should match with `Total Sales` amount. So even you cashout income value won’t change. As you’ve also noticed you’ll track actual cash balance through cash account. ---
**Author:** ![plume](https://forum.sambapos.com/user_avatar/forum.sambapos.com/plume/32/1190_2.png) [@plume](https://forum.sambapos.com/u/plume)\ **Post date:** [May 8, 2014, 4:35pm UTC](https://forum.sambapos.com/t/cash-shown-in-report-does-not-match-cash-in-account/1223/3 "2014-05-08T16:35:41Z")
Thank you for your reply, emre. It would be really usefull to have such a report, when waiter closing his shift, he has to report to the manager. He has to hand over Cash, Cash $, Credit Card vouchers, Credit Card $ vouchers, bills that have been paid during the shift, etc … With such a report (how many I should have in cash, cc, etc ), he just prints out his report, next shift can start while he goes some place to count his money, etc before reporting to the manager. Maybe in the future 😉 in the mean time we will use accounts to close the shift. Thank you, Marc ---
**Author:** ![panda1269](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/p/a587f6/32.png) [@panda1269](https://forum.sambapos.com/u/panda1269)\ **Post date:** [May 8, 2014, 8:37pm UTC](https://forum.sambapos.com/t/cash-shown-in-report-does-not-match-cash-in-account/1223/4 "2014-05-08T20:37:36Z")
Try to use Ticket Explorer for the waitress at the end of the shift… Bye Maurizio ---
**Author:** ![emre](https://forum.sambapos.com/user_avatar/forum.sambapos.com/emre/32/39073_2.png) [@emre](https://forum.sambapos.com/u/emre)\ **Post date:** [May 9, 2014, 8:05am UTC](https://forum.sambapos.com/t/cash-shown-in-report-does-not-match-cash-in-account/1223/5 "2014-05-09T08:05:19Z")
@plume this is in our todo list. Thanks. ---
**Author:** ![plume](https://forum.sambapos.com/user_avatar/forum.sambapos.com/plume/32/1190_2.png) [@plume](https://forum.sambapos.com/u/plume)\ **Post date:** [May 10, 2014, 3:29pm UTC](https://forum.sambapos.com/t/cash-shown-in-report-does-not-match-cash-in-account/1223/6 "2014-05-10T15:29:35Z")
Thanks emre ! In the meantime, I’ll try to learn how scripts are working to make personal report. @QMcKay seems to be a reference in that matter 😄 Marc ---
**Author:** ![plume](https://forum.sambapos.com/user_avatar/forum.sambapos.com/plume/32/1190_2.png) [@plume](https://forum.sambapos.com/u/plume)\ **Post date:** [May 10, 2014, 5:17pm UTC](https://forum.sambapos.com/t/cash-shown-in-report-does-not-match-cash-in-account/1223/7 "2014-05-10T17:17:38Z")
Something a bit different but related. I follow the [Change in Local Currency thread](http://forum.sambapos.com/t/change-in-local-currency/783) to give the change in local currency when paid in $. Everything works fine, as in the post, 2 payment transactions: - Payment Tansaction (Cash in $) - Change Transaction (Cash in local currency) In Work Period Report I can see: **Sales** - Sales = xxx - Discount = yyy Total : `1000` **Income** : - Cash = xxx - Cash $ = yyy - CC = zzz Total Income is not matching the sales: `1000 - all change transactions`. I wonder if it would not be “natural” to include the change transactions in the income report (under Cash or an additional line), as the real income has to take in account the changes we gave back. I am not talking about paying a bill which cash-out money transactions, or what so ever, I am only talking about the change transactions, which affect the income. Marc ---
**Author:** ![emre](https://forum.sambapos.com/user_avatar/forum.sambapos.com/emre/32/39073_2.png) [@emre](https://forum.sambapos.com/u/emre)\ **Post date:** [May 11, 2014, 8:48am UTC](https://forum.sambapos.com/t/cash-shown-in-report-does-not-match-cash-in-account/1223/8 "2014-05-11T08:48:38Z")
@plume I have to configure SambaPOS as you’ve configured to be able to test this. Can you send a screenshot of report so I can understand the problem better? ---
**Author:** ![plume](https://forum.sambapos.com/user_avatar/forum.sambapos.com/plume/32/1190_2.png) [@plume](https://forum.sambapos.com/u/plume)\ **Post date:** [May 11, 2014, 6:20pm UTC](https://forum.sambapos.com/t/cash-shown-in-report-does-not-match-cash-in-account/1223/9 "2014-05-11T18:20:26Z")
@emre. Ok I’ll do - Now I cannot I don’t have access, as soon as I can, I’ll do. ---
**Author:** ![plume](https://forum.sambapos.com/user_avatar/forum.sambapos.com/plume/32/1190_2.png) [@plume](https://forum.sambapos.com/u/plume)\ **Post date:** [May 11, 2014, 11:08pm UTC](https://forum.sambapos.com/t/cash-shown-in-report-does-not-match-cash-in-account/1223/10 "2014-05-11T23:08:15Z")
Hola @emre Below are the screenshots of report and Cash Account. ``` Total Sales: 1056.93 Total Income: 1108.73 Difference: 51.8 ``` Sum of the 3 Change Transactions for that period: ``` 41.2 + 3 + 7.60 = 51.8 ``` **Report** ![](https://forum.sambapos.com/uploads/default/original/3X/2/b/2beff0cbfce4570041f70e5a1f701ef85613dac0.png) **Cash Account** ![](https://forum.sambapos.com/uploads/default/original/3X/2/e/2e3f30af440f7471ae1c7cd65574ef06313acbf4.png) Thanks ! Marc ---
**Author:** ![emre](https://forum.sambapos.com/user_avatar/forum.sambapos.com/emre/32/39073_2.png) [@emre](https://forum.sambapos.com/u/emre)\ **Post date:** [May 12, 2014, 4:27pm UTC](https://forum.sambapos.com/t/cash-shown-in-report-does-not-match-cash-in-account/1223/11 "2014-05-12T16:27:10Z")
Hello Marc. Still couldn’t reproduce it. Is it possible to PM me a backup zip of your database? ---
**Author:** ![plume](https://forum.sambapos.com/user_avatar/forum.sambapos.com/plume/32/1190_2.png) [@plume](https://forum.sambapos.com/u/plume)\ **Post date:** [May 12, 2014, 4:35pm UTC](https://forum.sambapos.com/t/cash-shown-in-report-does-not-match-cash-in-account/1223/12 "2014-05-12T16:35:33Z")
Sure, I can do that this tonight after we close, Be aware that we went live about a week ago, but I changed some stuff during that week, new rules, new accounts name, etc … However the exemple I gave you was after my changes. That brings me a question I have in mind for some time: If I make an update of the SambaPOS (SambaPOS 4.1.3 BETA) to the last version, do I keep all my customisation (rules, templates, etc …) ? Marc ---
**Author:** ![JohnS](https://forum.sambapos.com/user_avatar/forum.sambapos.com/johns/32/24916_2.png) [@JohnS](https://forum.sambapos.com/u/JohnS)\ **Post date:** [May 12, 2014, 11:32pm UTC](https://forum.sambapos.com/t/cash-shown-in-report-does-not-match-cash-in-account/1223/13 "2014-05-12T23:32:35Z")
Updating SambaPOS keeps all of your settings, sales, etc. Always do a manual backup of the database first. Then update to the latest. ---
**Author:** ![emre](https://forum.sambapos.com/user_avatar/forum.sambapos.com/emre/32/39073_2.png) [@emre](https://forum.sambapos.com/u/emre)\ **Post date:** [May 19, 2014, 5:39pm UTC](https://forum.sambapos.com/t/cash-shown-in-report-does-not-match-cash-in-account/1223/14 "2014-05-19T17:39:12Z")
Hello @plume. Thank you very much for helping me solving this issue. After next update reports will include change transactions. Does it solve your problem? ![](https://forum.sambapos.com/uploads/default/original/3X/a/3/a38b34912be4f7c58c5b48d71ac03b5b0a9aa3ea.jpeg) ---
**Author:** ![plume](https://forum.sambapos.com/user_avatar/forum.sambapos.com/plume/32/1190_2.png) [@plume](https://forum.sambapos.com/u/plume)\ **Post date:** [May 19, 2014, 6:39pm UTC](https://forum.sambapos.com/t/cash-shown-in-report-does-not-match-cash-in-account/1223/15 "2014-05-19T18:39:02Z")
Hi @Emre, yes this will solve my problem, thanks ! If I could abuse 😊 I would ask you if it would be possible to: - Add a “Cash/CC… in Drawer” section in that report It would be almost the same report as `Incomes` (Payment transactions + Change Transactions) except that it would also include **all the other transactions** done on these Income accounts (Like CashIn, CashOut) Marc