# Sales by customer by period

**URL:** https://forum.manager.io/t/sales-by-customer-by-period/1840
**Category:** Uncategorized
**Created:** [November 24, 2014, 1:12pm UTC](https://forum.manager.io/t/sales-by-customer-by-period/1840 "2014-11-24T13:12:28Z")
**Posts on this page:** 13
**Page:** 1

<div class="post-metadata">

### Author: ![raya](https://avatars.discourse-cdn.com/v4/letter/r/df788c/32.png) [@raya](https://forum.manager.io/u/raya)
#### Post date: [November 24, 2014, 1:12pm UTC](https://forum.manager.io/t/sales-by-customer-by-period/1840/1 "2014-11-24T13:12:28Z")

</div>

I am still having trouble running a fairly simple report. I would like to run a report showing me the net sales by one customer for a particular period say current month. Thanks in anticipation.

---

<div class="post-metadata">

### Author: ![lubos](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/lubos/32/62798_2.png) [@lubos](https://forum.manager.io/u/lubos)
#### Post date: [November 26, 2014, 5:40pm UTC](https://forum.manager.io/t/sales-by-customer-by-period/1840/2 "2014-11-26T17:40:11Z")

</div>

When you say sales by one customer, this can mean different thing to different users. For example, some users imagine to see sales invoice totals (accrual-basis) while others imagine how much customer has paid (cash-basis) and others mean to see sales by customer by particular income account or inventory item.

Can you be more specific as to what you expect to see?

---

<div class="post-metadata">

### Author: ![raya](https://avatars.discourse-cdn.com/v4/letter/r/df788c/32.png) [@raya](https://forum.manager.io/u/raya)
#### Post date: [November 27, 2014, 4:21pm UTC](https://forum.manager.io/t/sales-by-customer-by-period/1840/3 "2014-11-27T16:21:46Z")

</div>

Not to sure of the terminology.  
I would like to run a report sales invoice totals by a particular customer. Say for month or year  
I.E

Customer ABC 1/11/14…30/11/14

01/11/14 200.00  
15/11/14 150.00  
30/11/14 100.00

Total 450.00

Hope that makes more sense.

Many thanks for your help.

---

<div class="post-metadata">

### Author: ![vravani](https://avatars.discourse-cdn.com/v4/letter/v/51bf81/32.png) [@vravani](https://forum.manager.io/u/vravani)
#### Post date: [January 15, 2016, 6:00am UTC](https://forum.manager.io/t/sales-by-customer-by-period/1840/4 "2016-01-15T06:00:19Z")

</div>

I too wish the same. Is it available in manager?

---

<div class="post-metadata">

### Author: ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)
#### Post date: [January 15, 2016, 6:21am UTC](https://forum.manager.io/t/sales-by-customer-by-period/1840/5 "2016-01-15T06:21:37Z")

</div>

Look at the Customer Statement report. For statement type, select Transactions and enter date range. Does that tell you what you want to know?

---

<div class="post-metadata">

### Author: ![vravani](https://avatars.discourse-cdn.com/v4/letter/v/51bf81/32.png) [@vravani](https://forum.manager.io/u/vravani)
#### Post date: [January 15, 2016, 8:08am UTC](https://forum.manager.io/t/sales-by-customer-by-period/1840/6 "2016-01-15T08:08:53Z")

</div>

In Manager Desktop version 15.6.93, this shows balance (pending receivables) only. Not the sales 😒

---

<div class="post-metadata">

### Author: ![lubos](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/lubos/32/62798_2.png) [@lubos](https://forum.manager.io/u/lubos)
#### Post date: [January 15, 2016, 10:45am UTC](https://forum.manager.io/t/sales-by-customer-by-period/1840/7 "2016-01-15T10:45:39Z")

</div>

`Custom reports` will be the way to extract this information.

---

<div class="post-metadata">

### Author: ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)
#### Post date: [January 15, 2016, 2:56pm UTC](https://forum.manager.io/t/sales-by-customer-by-period/1840/8 "2016-01-15T14:56:50Z")

</div>

> [@vravani](#):
>
> n Manager Desktop version 15.6.93, this shows balance (pending receivables) only. Not the sales

Then you did not select Transactions for the statement type. Do this when you create a new report.

---

<div class="post-metadata">

### Author: ![vravani](https://avatars.discourse-cdn.com/v4/letter/v/51bf81/32.png) [@vravani](https://forum.manager.io/u/vravani)
#### Post date: [January 16, 2016, 4:44am UTC](https://forum.manager.io/t/sales-by-customer-by-period/1840/9 "2016-01-16T04:44:05Z")

</div>

I assume that “sales by customer by period” is not a super complex requirement for which SQL type solution Custom Reports you are suggesting. 😕

Custom Reports feature is not-friendly to non-advanced users like me.

---

<div class="post-metadata">

### Author: ![lubos](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/lubos/32/62798_2.png) [@lubos](https://forum.manager.io/u/lubos)
#### Post date: [January 18, 2016, 1:25pm UTC](https://forum.manager.io/t/sales-by-customer-by-period/1840/10 "2016-01-18T13:25:59Z")

</div>

@vravani, even if you don’t know how to make SQL queries, there will be many examples you can just copy and paste.

---

<div class="post-metadata">

### Author: ![vravani](https://avatars.discourse-cdn.com/v4/letter/v/51bf81/32.png) [@vravani](https://forum.manager.io/u/vravani)
#### Post date: [January 19, 2016, 4:35am UTC](https://forum.manager.io/t/sales-by-customer-by-period/1840/11 "2016-01-19T04:35:09Z")

</div>

@lubos  
from where can i get these examples to simply copy and paste?

---

<div class="post-metadata">

### Author: ![lubos](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/lubos/32/62798_2.png) [@lubos](https://forum.manager.io/u/lubos)
#### Post date: [January 20, 2016, 7:27am UTC](https://forum.manager.io/t/sales-by-customer-by-period/1840/12 "2016-01-20T07:27:04Z")

</div>

Not yet, custom reports are still work in progress. Ask again sometime next month.

---

<div class="post-metadata">

### Author: ![Ealfardan](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ealfardan/32/63166_2.png) [@Ealfardan](https://forum.manager.io/u/Ealfardan)
#### Post date: [January 18, 2023, 3:35pm UTC](https://forum.manager.io/t/sales-by-customer-by-period/1840/13 "2023-01-18T15:35:16Z")

</div>


