# Customer account statement - info for customer
**URL:** https://discuss.tryton.org/t/customer-account-statement-info-for-customer/5941
**Category:** User
**Created:** [February 16, 2023, 8:54am UTC](https://discuss.tryton.org/t/customer-account-statement-info-for-customer/5941 "2023-02-16T08:54:05Z")
**Posts on this page:** 8
**Page:** 1
### Author:  [@dotbit](https://discuss.tryton.org/u/dotbit)
#### Post date: [February 16, 2023, 8:54am UTC](https://discuss.tryton.org/t/customer-account-statement-info-for-customer/5941/1 "2023-02-16T08:54:06Z")
It is customary to confirm the invoices/payments of a customer/supplier periodically, or in case for example the customer has not registered an invoice and has the wrong balance, then it is useful to send an extract/report from the customer account that shows all the moves to the customer account.
Many people call this payable/receivable account statement, but this should not be confused with a bank account statement, which is what it would refer to in Tryton.
I suspect it can be solved with some account analytic module.
I would like to ask how to do this in Tryton.
---
### Author:  [@pokoli](https://discuss.tryton.org/u/pokoli)
#### Post date: [February 16, 2023, 9:17am UTC](https://discuss.tryton.org/t/customer-account-statement-info-for-customer/5941/2 "2023-02-16T09:17:22Z")
In tryton we use the [statement module](https://docs.tryton.org/projects/modules-account-statement/en/latest/) for encoding bank accounts moves and reconcile them with invoices.
We also have several modules that import the bank information based on standard format. For example, there is the [SEPA](https://docs.tryton.org/projects/modules-account-statement-sepa/en/latest/) format for all european countries.
I explain such feature in a talk in Spanish days. The [video](https://www.youtube.com/watch?v=C0iUD6ukEzg) is recorded but only in Spanish.
---
### Author:  [@udono](https://discuss.tryton.org/u/udono)
#### Post date: [February 16, 2023, 9:21am UTC](https://discuss.tryton.org/t/customer-account-statement-info-for-customer/5941/3 "2023-02-16T09:21:53Z")
IIUC what you name the "Party Account Statement\* could be the payable/receivable report for a party. You’ll find it by selecting a party, enter _Open related Records_ and choose _Payable/Receivable Lines_. In the resulting table choose tab _All_, remove the `Reconciliation: =` from _Filters_ and activate button _Reload/Undo_ the results. E.g.:
[https://demo6.6.tryton.org/#demo6.6/model/account.move.line;domain=[[“OR”%2C[“account.type.receivable”%2C"%3D"%2Ctrue]%2C[“account.type.payable”%2C"%3D"%2Ctrue]]%2C[“party”%2C"%3D"%2C2]%2C[“company”%2C"%3D"%2C1]]&name=“Payable%2FReceivable%20Lines%20(Albright%20Memorial%20Library)”&tab\_domain=[[“Payable”%2C[[“account.type.payable”%2C"%3D"%2Ctrue]]%2Cfalse]%2C[“Receivable”%2C[[“account.type.receivable”%2C"%3D"%2Ctrue]]%2Cfalse]%2C[“All”%2C[]%2Cfalse]]&views=[243]](https://demo6.6.tryton.org/#demo6.6/model/account.move.line;domain=%5B%5B%22OR%22%2C%5B%22account.type.receivable%22%2C%22%3D%22%2Ctrue%5D%2C%5B%22account.type.payable%22%2C%22%3D%22%2Ctrue%5D%5D%2C%5B%22party%22%2C%22%3D%22%2C2%5D%2C%5B%22company%22%2C%22%3D%22%2C1%5D%5D&name=%22Payable%2FReceivable%20Lines%20(Albright%20Memorial%20Library)%22&tab_domain=%5B%5B%22Payable%22%2C%5B%5B%22account.type.payable%22%2C%22%3D%22%2Ctrue%5D%5D%2Cfalse%5D%2C%5B%22Receivable%22%2C%5B%5B%22account.type.receivable%22%2C%22%3D%22%2Ctrue%5D%5D%2Cfalse%5D%2C%5B%22All%22%2C%5B%5D%2Cfalse%5D%5D&views=%5B243%5D)
Also have a look at _Open related Records_ and choose _Account_.
The analytic modules are used for collecting costs and profits in parallel in a separate chart of accounts which collects business related information.
---
### Author:  [@ced](https://discuss.tryton.org/u/ced)
#### Post date: [February 16, 2023, 9:37am UTC](https://discuss.tryton.org/t/customer-account-statement-info-for-customer/5941/4 "2023-02-16T09:37:50Z")
There is also the “Aged Balance” report which can be used to find parties.
By the way we could [Add relate from Aged Balance to Payable/Receivable lines (#12088) · Issues · Tryton / Tryton · GitLab](https://foss.heptapod.net/tryton/tryton/-/issues/12088)
About the statement indeed it may be useful to have a report to print. But I’m wondering if it is not actually the job of the [_Account Dunning Module_](https://docs.tryton.org/projects/modules-account-dunning/en/latest/).
---
### Author:  [@dotbit](https://discuss.tryton.org/u/dotbit)
#### Post date: [February 16, 2023, 12:30pm UTC](https://discuss.tryton.org/t/customer-account-statement-info-for-customer/5941/5 "2023-02-16T12:30:55Z")
> [@udono](#):
>
> You’ll find it by selecting a party, enter _Open related Records_ and choose _Payable/Receivable Lines_.
It becomes quite useful when also showing column Move Origin and sorting by reconciliation in order to have the invoices paired up with the payments. For communicating this to the customer, in order to help the customer figure out what is going on two things are missing here: a report to create a pdf file, and the customer balance, but it is not the right place to show the customer balance.
> [@udono](#):
>
> Also have a look at _Open related Records_ and choose _Account_.
It is really useful to double click the account and you are taken to general ledger lines associated with the customer. But again there is no report, and while we can see the balance here, I can not see the description/origin of the line, such as payment/invoice nr x, etc. Also I can not see the associated accounts for each transaction. I wonder why the description/origin fields are empty for me in general ledger, I should investigate.
> [@ced](#):
>
> There is also the “Aged Balance” report which can be used to find parties.
> By the way we could [Add relate from Aged Balance to Payable/Receivable lines (#12088) · Issues · Tryton / Tryton · GitLab](https://foss.heptapod.net/tryton/tryton/-/issues/12088)
Yes, this will help me find parties who have a balance and make it easy to see how late they are with their payments. But from what I can tell it does nothing to communicate the invoice/payment history with the customer. While it is useful to have a relate to payable/receivable lines it does not solve the issue at hand.
> [@ced](#):
>
> About the statement indeed it may be useful to have a report to print. But I’m wondering if it is not actually the job of the [_Account Dunning Module_](https://docs.tryton.org/projects/modules-account-dunning/en/latest/).
I have not used the Dunning modules, but I tested it. From what I can tell a Dunning is for a particular line, because the line is obligatory in Financial / Dunnings. What I need to do is to communicate the whole history of invoices/payments/balance for a particular customer and period.
This is the way the local accounting program does it. 4111.00304 is a sort of analytic account, and it makes a report of that analytic account.
---
### Author:  [@ced](https://discuss.tryton.org/u/ced)
#### Post date: [February 16, 2023, 12:39pm UTC](https://discuss.tryton.org/t/customer-account-statement-info-for-customer/5941/6 "2023-02-16T12:39:23Z")
> [@dotbit](#):
>
> the customer balance
Added with [Show cumulative balance to payable/receivable lines (#11994) · Issues · Tryton / Tryton · GitLab](https://foss.heptapod.net/tryton/tryton/-/issues/11994)
---
### Author:  [@pokoli](https://discuss.tryton.org/u/pokoli)
#### Post date: [February 16, 2023, 2:22pm UTC](https://discuss.tryton.org/t/customer-account-statement-info-for-customer/5941/7 "2023-02-16T14:22:33Z")
> [@ced](#):
>
> Added with [Show cumulative balance to payable/receivable lines (#11994) · Issues · Tryton / Tryton · GitLab](https://foss.heptapod.net/tryton/tryton/-/issues/11994)
I think this is not enought. It will be great to have a report for it so it can be sent to other party in a printable format.
---
### Author:  [@udono](https://discuss.tryton.org/u/udono)
#### Post date: [February 17, 2023, 9:14am UTC](https://discuss.tryton.org/t/customer-account-statement-info-for-customer/5941/8 "2023-02-17T09:14:36Z")
> [@dotbit](#):
>
> What I need to do is to communicate the whole history of invoices/payments/balance for a particular customer and period.
IIUC you are looking for a report of all account move lines with a receivable/payable account for a particular party and period. Higher level objects like _Invoice_ or _payment_ are origins of move lines.
I highly recommend to base this report on account move line level, because it will also be usable with pure financial accounting without invoice.
> [@dotbit](#):
>
> This is the way the local accounting program does it. 4111.00304 is a sort of analytic account, and it makes a report of that analytic account.
This kind of _analytic account_ for each customer/supplier is only needed when the party is not a unique identifier in the system. I have seen this, - IMHO _old_, - design comes from starting a simple ledger software which doesn’t know about customer, supplier, parties at all. Over time this software grows to a _factura_, where invoices and parties are needed.
But you could simulate the _analytic account_ number by the account number + party code in Tryton.
In Tryton the payable and receivable accounts having a [_party required_ flag](https://demo6.6.tryton.org/#demo6.6/model/account.account/5;name=%22Financial%20%2F%20Configuration%20%2F%20General%20Account%20%2F%20Accounts%22&views=%5B200%2C202%5D) set. To create an account move line with these accounts a party is required. So you immediately choose the _correct_ party for each move line.
To refine the above report idea: we could filter the _account move line_ report by one _party_, period and none, one or more accounts with _party required_ flag. With this report we can catch any move line where a specific party is related. The account name could give information about the relation of the party: wages, salaries, receivable, payable, bank payments, cash payments, rents, …
For every (filterd) account a total is calculated and a total balance for all accounts.