← Back to team overview

openerp-expert-accounting team mailing list archive

Re: Year-end closing

 

Thank you very much for your detailed message!

On 11. 05. 11 12:02, Borja LS wrote:
> In Spain the process is similar: We do a P&L regularization, and
> afterwards we 'bring forward' the balances to the next year.
>
> About 'how we do it'... as Davide mentioned the Spanish localization
> has it's own "fiscal year closing" wizard (as OpenERP default wizard
> just creates 1 move, it does't perform the regularization nor the
> balance-to-0 steps, so it is not valid for us).
>
>     * We use 3 special periods:
>           o Regularization period (31th Dec of year X; usually named
>             PG/YY/ where /YY/ is the year)
>           o Closing period (31th Dec of year X; named C/YY/)
>           o Opening period (1st Jan of year X; named A/YY/)
>
why do you need two closing periods?
>
>     * The fiscal year closing wizard performs this steps:
>           o Checks the integrity of the accounting:
>                 + Checks that there are no unconfirmed moves in the
>                   year to be closed.
>                 + Checks that the year of the fiscal period and the
>                   year of the move date match for every move.
>                 + Checks that all the moves are really balanced.
>
checks are really missing from the standard version... very useful!
>
>           o Creates a P&L regularization move (though it preselects
>             the expected accounts from the Spanish chart of accounts
>             [src: 6, 7; dest: 129], it's completely configurable [it's
>             just a map of accounts]).
>           o Creates a net equity P&L regularization move if needed
>             (again the accounts are detected and preselected but it's
>             configurable).
>           o Creates the closing move (preselects the accounts 1*, 2*,
>             3*, 4*, 5*; but again the list of accounts is configurable)
>           o Creates the opening move (as the inverse of the closing one).
>           o Closes (locks) all the periods of the last fiscal year,
>             and the fiscal year itself.
>     * The wizard is:
>           o Preconfigured (tries to detect the fiscal years, journals,
>             periods, dates and accounts) so the user just need to do a
>             few clics; but at the same time it is totally configurable
>             (you can configure the journal/period/dates for the
>             created moves, and set the maps of accounts for the
>             regularization steps, and the list of accounts for the
>             closing step).
>           o Able to undo all those steps with just one click (also you
>             can also run/undo a step at a time; btw, the 'wizard' it's
>             not an osv_memory, but a real osv).
>           o Protected against the dreaded OpenERP client timeouts. If
>             the process takes more than 20 seconds a progress dialog
>             is shown allowing to keep waiting or continuing in the
>             background :)
>
>
> Some images:
>
>
> Hope this gives you ideas :)
sure it does! excellent work! thank you!
> -- 
> Borja López Soilán
> borja@xxxxxxx
   

Follow ups

References