« Return to Thread: Year End Automation

Re: Year End Automation

by xony :: Rate this Message:

Reply to Author | View in Thread

Hi Nathan,
First version of french translation is finished...
I'll give you the files as soon as possible.

Here the french ledger questions.

Nathan Gray a écrit :
> I'm doing up some automatic year end stuff, and I'd like some  
> confirmation against some other nations, to make sure pERP doesn't  
> violate anyone's laws (including Canada).
>
> What has been requested:
> 1.  After the fiscal year end date, any invoice posted for goods  
> received in the previous fiscal year should be posted as at the fiscal  
> year end date, but the date on the invoice should be unchanged.  I  
> suppose services received might be covered as well, but pERP can't  
> detect that, so they would have to be manually corrected.

In french ledger, the invoice is posted on the date the document is made (customer invoice),
or at the date the document is received (supplier invoice).
But the yearly result must include all that is rattached to the fiscal period.
(the fiscal year  period can be different as a january-december year):
They are two accounts "charges à payer" et "produits à recevoir" ("accrued liabilities" and  "accrued income")
in wich the operations are posted (products or services are delivered but the invoice isn't etablished).
The next fiscal year, you must reverse the accounting entry when you receive or etablish the invoice.

> After a certain, variable period of time (maybe up to a month or two),  
> an accountant can begin the year end procedure.
Can be more than two months...

Months are closed provisory, month after month, journal by journal, and there is a definitively  year end procedure, after making the year end operations :
Accrued liabilities and  accrued income
Depreciation and provisions
Inventory variation
Income and expenses recorded in advance
Disposals of fixed assets ("immobilisations") and cession of stocks ("Valeurs Mobilières de Placement")

> 2.  pERP checks for a year end inventory count (if you use inventory)  
> and suggests maybe you should do one if you haven't

Inventory variation is an year end operation

> 3.  pERP checks for a year end bank reconciliation, and suggests maybe  
> you should do one if you haven't

bank reconciliation is done month after month, operation after operation when you do the daily accounting

> 4.  pERP creates and posts a Journal Entry that moves the balance of  
> all Revenue & Expense accounts to a single GL account, Retained Earnings
> 5.  The General Ledger is locked, and no posting is allowed prior to  
> the year end date, except for accountant / auditors with extra admin  
> permissions.

There is a journal called "Bilan d'ouverture" or "Reports à Nouveau" created by the year end procedure
 in wich all accounts are automaticly reversed for the balance of each account
and the result goes in a result account.

>
> After this point, everything is sent off the external accountants /  
> auditors, who analyze and come back with any corrections that need to  
> be made.  These corrections are made by a user with the extra admin  
> permissions mentioned above.

The correction and the year end operation are posted in a special journal and it's before the year end procedure.
Before the year end procedure, you have two years opened. And after it, you can't touch anything in the closed year.
Each account (and the non balanced operation history) are reversed by the result account and they appear  in the new year, in a opening journal...

>
> Does that sound reasonable?
> Anything to add?
> Anything that needs to be made optional or removed?
>
> Nathan Gray
> nathan at goarctic dot com
>

There are three types report of year end

Yearly general balance, supplier balance, customer balance.

They're regroupement of the accounts in sections in the "Bilan" and the "Compte de Résultat ".
(Balance sheet and income sheet)

Le "Grand Livre" :
Yearly detailled operations, account by account, operation after operation, general account
Yearly detailled operations, account by account, operation after operation, customer account
Yearly detailled operations, account by account, operation after operation, supplier account

I'll post you as soon as possible a french example with the real french accounts.

a+

 « Return to Thread: Year End Automation