openerp-expert-accounting team mailing list archive

[Borja López Soilán (Pexego) <borjals@xxxxxxxxx>]

Hervé Proust - www.kazacube.com escribió:
> Hello,
>
> I see improvements on an issue I consider as critical for the future of
> OpenERP (quality, fiability and coverage of financial reports and also
> good level of performance, i.e. capacity to print a general ledger
> without timeout...). We agree mostly with requests from c2c.
>
> Some additional comments:
> - Account balance: initial balance is requested by our certified accountant on one single report (and not by generating one report per fiscal year)
>   * Fiscal year report: if the report shows the full year N, the initial balance should be equal to balance beginning of year N (= opening entries for balance sheet accounts)
>   * Period report: if the report is limited to one period N, the initial balance should be equal to balance end of period N-1 (for all acounts..., but only for the running fiscal year for income statement accounts. That is where I guess it becomes tricky... )
>   

On the 5.0 you have a module called account_financial_report that gives 
you extra reports, like a 'full balance' report that shows the balance 
on a given period and the full year:




> - Comparison of yearly results: is it possible or planned to add "comparison" reports as proposed by the module "Account_balance_compare years" to the standard reports? (which would be presented in columns and not in two reports in one)
>   
On 5.0, you have the account_balance_reporting module, that lets create 
report templates for comparisons of two fiscal years/periods:

Selecting the template (official Spanish templates are available for the 
Spanish localization) and fiscal years / periods:


Calculated data:


Printed example (everything):


Printed example (non-zero):



Sample P&L template (taken from Spanish localization) - Template 
information:



Sample P&L template - Template lines:


Note: A formula like "760,761" means 'the balance of the account with 
code 760 plus the balance of the account with code 761", parenthesis 
might be used to negate the values. A formula like "49300+41900" means 
"the sum of the line with code 49300 and the line with code 41900".


Maybe some of this reports (the ones account_financial_report provides) 
could be integrated into the standard accounting reports in the future 
6.X versions...

Best regards.

-- 
Borja López Soilán
borjals@xxxxxxxxx

Pexego Sistemas Informáticos S.L.
Avenida de Magoi 66 - 27002 Lugo (España)
Tel./Fax 982801517
http://www.pexego.es 


AVISO LEGAL - CLÁUSULA DE PRIVACIDAD
Este mensaje se dirige exclusivamente a su destinatario y puede contener información privilegiada o confidencial. Si no es usted el destinatario indicado, queda informado de que la utilización, divulgación y/o copia sin autorización está prohibida en virtud de la legislación vigente. Si ha recibido este mensaje por error, le rogamos que nos lo comunique inmediatamente por esta misma vía y proceda a su destrucción.

-- 
Financial reports to review for 6.0
https://bugs.launchpad.net/bugs/551630
You received this bug notification because you are a member of OpenERP
Accounting Experts, which is a direct subscriber.

Status in OpenObject Addons Modules: Confirmed

Bug description:
Hello,

As discuss during the community days, all financial reports have to be reviewed.

The list of modification has been created by Quentin, please ask him for more information => here are the most important things to change :

== Account balance  ==

 * Wizard
     * add currency balance amount => check box
     * add comparison with other fiscal year
     * filter => only by date / by periode / none => from ... to for both date and period (period really based on period and not on dates) 
     * filter => dependant to the fiscal year (only see period related to the fiscal year selected)

* Calculation
     * sum of all entries related to the account into the date filter selection

== General ledger ==
 * Wizard
     * add “with opening balance" => to have a new line with the sum of all entries that are before the begin date/periode
     * Use the “Display history” check box => add a new select field (see quentin notes)
     * add cumulative balance column

Calculation
     * list of all entries related to the account into the date filter selection

== Partner balance ==
* Wizard
     * add "balance date"
     * add new selection “partner with movement / balance <> 0 / all
     * Also available on the partner (automatic selection of the partner) => important if multi selection

* Calculation
     * selection of client vs supplier based on the internal account type
     * sum of all entries related to the account into the date filter selection group by partners

== Partner ledger ==
 * Wizard
     * add "balance date"
     * add new selection “partner with movement / balance <> 0 / all
     * Add choice “open amount only / paid amount only / all entries”
     * Add sort option (date, entry number, amount, due date)
     * Also available on the partner (automatic selection of the partner)

* Calculation
     * add store field “last pmt date” => define if paid or date at a specific date
     * selection of client vs supplier based on the internal account type
     * list of entries group by client