# Workperiod report totals not the same

**URL:** <https://forum.sambapos.com/t/workperiod-report-totals-not-the-same/26613>\
**Category:** V5 Question\
**Created:** [December 30, 2022, 3:32am UTC](https://forum.sambapos.com/t/workperiod-report-totals-not-the-same/26613 "2022-12-30T03:32:43Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![jerryfin](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/j/d78d45/32.png) [@jerryfin](https://forum.sambapos.com/u/jerryfin)\
**Post date:** [December 30, 2022, 3:32am UTC](https://forum.sambapos.com/t/workperiod-report-totals-not-the-same/26613/1 "2022-12-30T03:32:43Z")

</div>

I am running the work period report however the totals are not the same.

My setup:  
4 terminals 1 server  
2 department 1 ticket type

Payment type:  
USD  
Cash (local currency)  
Credit Card

2 change type for USD and Local currency.

I am trying to run the Work Period report howerver :  
1- The Grand Total and the Payment total are different

 ![20221229_165108](https://forum.sambapos.com/uploads/default/original/3X/9/8/981460ab1f835138c488c069e179ba291a23f958.jpeg)

2- the user sales and settled total are different.

 ![20221229_165057](https://forum.sambapos.com/uploads/default/original/3X/d/c/dcb23d8b0a4bcbafdd4b5a0e767428de10b6423b.jpeg)

---

<div class="post-metadata">

**Author:** ![Posflow](https://forum.sambapos.com/user_avatar/forum.sambapos.com/posflow/32/63001_2.png) [@Posflow](https://forum.sambapos.com/u/Posflow)\
**Post date:** [December 30, 2022, 5:59am UTC](https://forum.sambapos.com/t/workperiod-report-totals-not-the-same/26613/2 "2022-12-30T05:59:42Z")

</div>

Do you have any service charges or something special you arent reporting in Work Period report?

---

<div class="post-metadata">

**Author:** ![jerryfin](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/j/d78d45/32.png) [@jerryfin](https://forum.sambapos.com/u/jerryfin)\
**Post date:** [December 30, 2022, 7:39am UTC](https://forum.sambapos.com/t/workperiod-report-totals-not-the-same/26613/3 "2022-12-30T07:39:09Z")

</div>

No service charge, I only have foreign currency and users can select to tender change in USD or local currency.

---

<div class="post-metadata">

**Author:** ![Posflow](https://forum.sambapos.com/user_avatar/forum.sambapos.com/posflow/32/63001_2.png) [@Posflow](https://forum.sambapos.com/u/Posflow)\
**Post date:** [December 30, 2022, 8:53am UTC](https://forum.sambapos.com/t/workperiod-report-totals-not-the-same/26613/4 "2022-12-30T08:53:50Z")

</div>

> [@jerryfin](#):
>
> 2- the user sales and settled total are different.

If one invoice/ticket has 10$ worth of orders from person A and 1$ worth of orders from person B, with total of 11$.

And person A settles this ticket in full, it will say in that report that they settled 11$ which is more than their sales.

---

<div class="post-metadata">

**Author:** ![jerryfin](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/j/d78d45/32.png) [@jerryfin](https://forum.sambapos.com/u/jerryfin)\
**Post date:** [December 30, 2022, 9:02am UTC](https://forum.sambapos.com/t/workperiod-report-totals-not-the-same/26613/5 "2022-12-30T09:02:37Z")

</div>

@Posflow i am wondering if this is the same issue

> [@Cash shown in report does not match cash in account](https://forum.sambapos.com/t/cash-shown-in-report-does-not-match-cash-in-account/1223/14):
>
> 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?

---

<div class="post-metadata">

**Author:** ![jerryfin](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/j/d78d45/32.png) [@jerryfin](https://forum.sambapos.com/u/jerryfin)\
**Post date:** [December 30, 2022, 9:05am UTC](https://forum.sambapos.com/t/workperiod-report-totals-not-the-same/26613/6 "2022-12-30T09:05:14Z")

</div>

@Posflow, what about the 1$ change that was tendered to the customer? This should be accounted for on the report.

How can i get the Tendered change on my report like this:

> [@Cash shown in report does not match cash in account](https://forum.sambapos.com/t/cash-shown-in-report-does-not-match-cash-in-account/1223/14):
>
> 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?

---

<div class="post-metadata">

**Author:** ![Posflow](https://forum.sambapos.com/user_avatar/forum.sambapos.com/posflow/32/63001_2.png) [@Posflow](https://forum.sambapos.com/u/Posflow)\
**Post date:** [December 30, 2022, 9:14am UTC](https://forum.sambapos.com/t/workperiod-report-totals-not-the-same/26613/7 "2022-12-30T09:14:27Z")

</div>

Change doesnt affect reports. Meaning if you settled 50$ bill with 100$. Report will say you have 50$.

Are you using V4 or V5? V5 this issue was solved.

---

<div class="post-metadata">

**Author:** ![jerryfin](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/j/d78d45/32.png) [@jerryfin](https://forum.sambapos.com/u/jerryfin)\
**Post date:** [December 30, 2022, 9:23am UTC](https://forum.sambapos.com/t/workperiod-report-totals-not-the-same/26613/8 "2022-12-30T09:23:49Z")

</div>

We are using V5, i was thinking the samething this shouldnt be an issue.

But what if we settled a bill in foreign currency USD 50$ with 100$, but the change tendered is in the local currency?

---

<div class="post-metadata">

**Author:** ![Posflow](https://forum.sambapos.com/user_avatar/forum.sambapos.com/posflow/32/63001_2.png) [@Posflow](https://forum.sambapos.com/u/Posflow)\
**Post date:** [December 30, 2022, 9:38am UTC](https://forum.sambapos.com/t/workperiod-report-totals-not-the-same/26613/9 "2022-12-30T09:38:25Z")

</div>

I never used foreign currency to that capacity, sorry, I cant really help you with that

---

<div class="post-metadata">

**Author:** ![jerryfin](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/j/d78d45/32.png) [@jerryfin](https://forum.sambapos.com/u/jerryfin)\
**Post date:** [December 30, 2022, 9:46am UTC](https://forum.sambapos.com/t/workperiod-report-totals-not-the-same/26613/10 "2022-12-30T09:46:17Z")

</div>

@Posflow thank you for your help so far. If you dont mine me asking. How do you use or setup your foreign currency? Does it reconcile on your reports?

---

<div class="post-metadata">

**Author:** ![Posflow](https://forum.sambapos.com/user_avatar/forum.sambapos.com/posflow/32/63001_2.png) [@Posflow](https://forum.sambapos.com/u/Posflow)\
**Post date:** [December 31, 2022, 12:44am UTC](https://forum.sambapos.com/t/workperiod-report-totals-not-the-same/26613/11 "2022-12-31T00:44:45Z")

</div>

I dont use Foreign Currencies, I update Global Settings, just to highlight Sub-Totals, Totals, Tenders and Change in other currencies on invoices and use ticket tags to mark the exchange rates for the day on the invoices. Accountants usually deal with the rest.
