# Separate payable/receivabe based on fiscal year

**URL:** https://discuss.tryton.org/t/separate-payable-receivabe-based-on-fiscal-year/2462
**Category:** Developer
**Created:** [March 18, 2020, 6:24pm UTC](https://discuss.tryton.org/t/separate-payable-receivabe-based-on-fiscal-year/2462 "2020-03-18T18:24:10Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![wifasoi](https://discuss-cdn.tryton.org/letter_avatar_proxy/v4/letter/w/ed655f/32.png) [@wifasoi](https://discuss.tryton.org/u/wifasoi)
#### Post date: [March 18, 2020, 6:24pm UTC](https://discuss.tryton.org/t/separate-payable-receivabe-based-on-fiscal-year/2462/1 "2020-03-18T18:24:10Z")

</div>

This is just a quick question about a niche user case.

Context:  
I stumble about this when creating the [Italian chart of account](https://discuss.tryton.org/t/italian-chart-of-account/2400).  
I need to report separately if the debt(or part there of) will be pay in the current fiscal year, or the next.  
An example of a balance sheet with this quirk:

 ![Screenshot_2020-03-18 Microsoft Word - Seconda prova intermedia Ecoaz B 2005 doc - Schemi_di_Bilancio pdf](https://discuss-cdn.tryton.org/uploads/default/original/1X/d2c5a1ad1df59c70280c8a93cee070b55e6c8e8b.png)  
_Glossary:_

- Crediti: credit (separated by “type of debtor” this case)
- Entro 12 mesi: the credit will be paid this fiscal year (Within 12 months is the literal translation)
- Oltre 12 mesi: the credit will be paid in the next fiscal year (after 12 months is the literal translation)

Usually this is done manually by the accountant and two sub account, but I’m wondering if this can be(or already is) automated.

I know the information is there (by using the payment term), so the question is if there is a already a way to create a report with this information automatically.  
(dind’t tested it yet, but does [Reporting based on date range](https://discuss.tryton.org/t/reporting-based-on-date-range/393) keep track of the payment terms for each line)

If there is not a solution right away, what should be the best approach resolving for this problem?

---

<div class="post-metadata">

### Author: ![pokoli](https://discuss-cdn.tryton.org/user_avatar/discuss.tryton.org/pokoli/32/22_2.png) [@pokoli](https://discuss.tryton.org/u/pokoli)
#### Post date: [March 18, 2020, 7:16pm UTC](https://discuss.tryton.org/t/separate-payable-receivabe-based-on-fiscal-year/2462/2 "2020-03-18T19:16:28Z")

</div>

> [@wifasoi](#):
>
> I need to report separately if the debt(or part there of) will be pay in the current fiscal year, or the next.  
> An example of a balance sheet with this quirk:

Normally the debt is separated on two clases:

- Short term (to be paid on the next year)
- Long term (to be paid on another fiscalyear)

Usually most chart of accounts separate them using diferent accounts (which are reported on diferent types of the balance).

So probably in this case you can create a sub-type for each of the debt. For example:

1. Crediti  
a. verso imprese controllate  
1. Entro 12 messi  
2. Oltre 12 messi

The account for short term will has the _Entro 12 messi_ as type and the account with long-term will have _Olter 12 messi_.

This will allow the accountant to see the full details directly from the balance sheet, without having to modify anything in Tryton. Also it will be possible to see the amount of parent types as the behaviour of tryton is to sum the amounts of the children types.