Accounting allocation modification
Use this function to perform a mass modification of the account allocation for all the assets or for a selection of assets, belonging to one or more financial sites in a single company.
This change can affect the Holding type, the classification of the assets as Held for sale, the Asset group and/or the Accounting code, the Date put into service. It is used to perform start-up operations: transfer of a Fixed assets in progress account to a Fixed assets in service account.
If the section associations are defined for the Asset object, any change of the accounting allocation can generate method changes in one or more depreciation plans.
You can also use this function to view the new depreciation methods and to carry out any modification required.
Before being carried out in real mode, you can run the process in Simulation to assess the result using the report. To avoid having to re-enter the parameters at the time of each simulated then actual process start, the parameters linked to the account allocation change as well as the selection criteria can be saved.
The assets for which an allocation change is prohibited are excluded implicitly from the process. These are:
- Inactive assets
- Assets with the In template holding type
- Assets which have been subject to an actual asset issue,
- Assets in the process of an intra-group transfer
Prerequisite
Refer to documentation Implementation
Screen management
This function is composed of:
- A Header that is used to specify the processing options and to choose the company and the financial sites to which the assets to be processed belong.
- The Parameters tab used to enter the new account allocations.
- The Depreciation plans tab that is used to view any new depreciation methods determined by the field associations and to carry out any modifications required.
- The Extended selection tab that is used to select the assets to be processed.
Management method for the window
The management is the same for this window as for all the mass process functions that can be applied to assets.
Process setup
First, it is necessary to set up the process or to Recall a Memo code with previously used settings.
Setting up the process includes:
- Entering the process options. By default, the process is carried out in Simulation mode and generates a Detailed Log file displaying the different parameters applied at the time of the process execution as well as the list of updated assets.
- Selecting the company and potential other financial sites where the assets are registered.
-Entering new accounting allocations.
- Selecting the depreciation plans on which the deprecation methods determined by applying the field associations or entered manually are to be applied.
- Carrying out if necessary a selection of the assets concerned by the process.
Note When you complete the setup, you can save your settings by clicking Memo to Recall later.
Process launch
Once the setup is done, it is possible to:
- Either directly apply the entered parameters to each of the selected assets, by clicking OK. A coherence check on the new accounting allocations as well as the new methods is then carried out. For an asset with an error, the previous allocation and method are conserved and an error message is inserted in the process report.
Note: When an update of the Residual value is requested, OK is not available and you must go to the Check window to enter the market value of each asset.
- Or go through an intermediate control stage of the entered parameters by clicking Check.
A control window opens containing two tables.
1/ The first presents the list of assets selected and for each of them, if no error is detected, the new accounting allocations.
2/ The second table contains the depreciation plans for the asset highlighted by the cursor in the first table and on which a depreciation method change has been requested. If the asset has an accounting allocation error, no depreciation method is displayed in this table.
You can:
- View the depreciation new methods.
- Identify lines with errors with potential errors in red, along with the corresponding error messages. The assets with errors are not updated with the parameters entered; they are displayed with their original method parameters.
- Correct or adjust the depreciation parameters.
Click Save to validate any modification of one or more depreciation parameters carried out on an asset. To cancel the modifications under way on the asset, click Cancel.
After the manual adjustments are complete, click End to close the control window; the setup entry window is displayed again, which makes it possible to either confirm the mass update by clicking OK or click End to cancel the update.
Process description
An accounting allocation change performs the following operations:
- Update of the assets with the new allocations and depreciation methods, as long as the following rules are respected:
1/ An allocation change leading to a CoA account Nature of Charge or Fixed asset in process is not applied to assets with the nature Fixed asset in service, when an earlier depreciation total exists for one of the asset plans (outside of IAS/IFRS plan). The same goes for the IAS/IFRS accounting nature when an IAS/IFRS depreciation total exists for the IAS/IFRS plan.
2/ On exiting the account transfer, the assets must be posted to at least one fixed asset account either according to the CoA standards or to the IAS/IFRS standards.
- For each, generation of:
- A Main event of Allocation change (FASCHGIMP)
- If necessary, of method change event (FASMTC)
- As many Secondary events of Allocation change (FASCHGIMP), as periods with a Definitive posting on the original allocations (both on the current fiscal year and the next one).
- The effective operating date is saved in the EVTDAT field.
- The effective accounting date is saved in the CPTDATINT field.
Note :
When the allocation change corresponds to a start-up (transfer from an In progress account to an In service account), the EVTDAT field is loaded with the Date put into service, and the CPTDATINT field is loaded with the furthest of these dates: Depreciation start date, Start date of the current period.
When the allocation change does not involve a transfer from an In progress account to an In service account:
1/ In the Main event FASCHGIMP: EVTDAT and CPTDATINT display the furthest of these dates: Depreciation start date, Start date of the current period.
2/ In the Secondary event FASCHGIMP: EVTDAT is loaded with the start date of the period concerned (already posted in Final) and CPTDATINT is loaded either with the start date of the current period (for events pertaining to the closed periods of the current fiscal year), or the start date of the period concerned (for events pertaining to the open periods of the current or next fiscal year).
The inquiry of events in the Event journal window that can be accessed from the Other info tab of the Assets management function.
In this window, the Main events can be identified thanks to the icon displayed at the beginning of the line. Double-clicking this icon expands the tree view of the list of Secondary events linked to it.
In the event content, the field EVTPRINC - Main event of type Local menu, enables the distinction between main event and secondary event, both events are linked by an alphanumeric field: TIMSTPP - Time stamp.
Header
The header contains the process options and is used to select the company as well as the site(s) that are referenced to the assets to be processed.
Options
Simulation (field FLGSIM) |
This check box is selected by default and runs the closing in simulation mode. In this case, controls and the process are carried out but there are no updates recorded in the database. Clear this check box to run in actual mode. In this case, you cannot reverse the closing and updates are recorded in the database. If you are using intermediate commits, it is recommended that the NIVTRACE – Log file level parameter (AAS chapter, MIS group) value is 0. |
Report (field FLGETA) |
This indicator can be accessed only when one or several reports are linked to the massive process. In this case, the activation of this indicator enables the user to print these reports. |
Detailed log file (field FLGDET) |
A log file is automatically displayed on process completion, showing the processing parameters. A Statistics section gives the number of selected assets, the number of assets updated as well as the number of assets not processed due to an error. Assets with errors are listed with their error reason. The viewing and printing of log files are possible at any time via the report code ATRACE - Print log file print request, obtained from the Supervisor function in the Print/Group print menu. |
Grid Company selection
field FLGCPY |
Help common to all the mass processings. When the company setupACCPERCTL - Control of accounting periods (chapter AAS, group CPT) has the value 'Yes', the company is not displayed in the list if at least one of its contexts is not synchronized with the accounting period/fiscal breakdown. The desynchronization status of a context is visible in the screenDetailed status of contexts that can be accessed from the Actions icon.In that screen, on the Calculation tab, the field Modification type has the value 'CNX' and the field Modified parameter has the value 'DESYNC'.In this case, it is necessary to launch the processing of Contexts synchronization. |
Company (field CPY) |
This field displays the company code. |
Grid Site selection
field FLGFCY |
The grid displays the list of the sites attached to the companies and for which the user has authorizations. |
Company (field FCYCPY) |
Identification Code for the company which the site is linked to. |
Site (field FCY) |
Identification code of the site. |
Options
- Simulation
This check box, selected by default, is used to carry out a simulation of an accounting allocation change on the selected assets. The modification of the assets is not recorded in the database.
The impact of the processing on the assets can be viewed in the log file displayed at processing completion.
- Detailed log file
A log file is systematically displayed on completion of the process, showing the process options, the selection criteria, the new accounting allocations as well as, for each of the plans involved, any new methods. A Statistics section gives the number of selected assets, the number of assets updated as well as the number of assets not processed due to an error. Assets with errors are listed with their error reason.
If this check box is selected, the log file is displayed in the form of a detailed report presenting, in addition to the information indicated above, the list of the successfully processed assets as well as their previous accounting allocations.
Note: Viewing and printing the log files is possible at any time via the Print log file print request of the ATRACE report code, obtained from the Supervisor function in the Print/Group print menu.
Company selection – Site selection
These tables display both the list of managed companies for which the user is authorized and the list of financial sites corresponding to these companies where the user is authorized.
When the company parameterACCPERCTL - Control of accounting periods (chapter AAS, group CPT) has Yes for value, the company is not displayed in the list as soon as at least of one its context is not synchronized with the accounting period/fiscal breakdown.In this case, it is necessary to launch the Contexts synchronization process.
The situation of de-synchronization of a context can be viewed on the Detailed status of contexts,Calculation tab (the value of the Modification type field is CNX and the value of the field Parameter modified is DESYNC).
It is necessary to select the company and the sites in which the assets involved in the processing, are registered. After the selection of the company, all the sites linked to the company are selected by default. The user can de-select those that are not concerned by the processing.
Provided they belong to the same company, the site(s) involved in the processing can be directly selected, in which case the company to which they belong is automatically selected.
Reminder: the assets MUST be registered in sites attached to the same company. Selecting a second company, or sites linked to another company, leads to the de-selection of the first company selected, after validation of a confirmation message.
After having selected the company or the site(s), it is possible to refine the selection by entering other selection criteria in the dedicated Extended selection tab.
Tab Setup definition
This tab is used to:
- Specify the reason justifying the allocation change.
- Modify the accounting allocations:
- Holding type: Only the value In property can be selected. It cannot be applied except to assets where the holding type is In lease contract and for which no leasing contract reference has been entered.
- Classification of the assets as Held for sales: This classification stops the depreciation for the IAS/IFRS plans.
- Family and/or Accounting code
- View the new Nature and CoA allocation (and any IAS/IFRS if the IAS/IFRS standards are managed) if the accounting code is modified, either directly, or by means of the application of the section associations after the modification of the Family.
The effective date of the allocation change is automatically determined as follows:
- If the accounting allocation change does not involve the switch from a fixed asset account In process to an account In service, the operation effective date and the accounting effective date have two different values: Depreciation start date, Start date of the current period.
- If the accounting allocation change does involve the switch from a fixed asset account In process to an account , the operation effective date is the first use date, and the accounting effective date is the furthest of the following: Start-up date and Current period start date.
Transfer parameters
Reason (field MVTTYP) |
This field is used to enter the reason for an account posting change. This information is mandatory. |
Transfer type
Holding type (field FLGOWN) |
This indicator is linked to the field that follows. It enables the user to force the value of the field when it is activated. |
Holding type (field OWNTYPD) |
Help common to the single and mass processes for the account posting change. |
Asset held for sale (field FLGSAL) |
Help shared by the unit and mass processes of accounting allocation change. |
Classification date (field SALCLSDATD) |
Help shared by the unit and mass processes of accounting allocation change. Classifying an asset as held for sale stops the depreciation of the asset for each IAS/IFRS plan and changes the depreciation method to 'Residual'. If the classification date is greater than the current period end, the method will not go to 'Residual' upon closing the period containing the classification date. Deleting this date cancels the classification. This cancellation will be effective at the start of the current period, if the classification date is earlier than the current period start date. |
Expected sale amount (field EXTSALAMT) |
Use this field to specify the sufficient value which is expected for the sale when a sales date is entered in the Classified for sale field. It can only be accessed when the Asset held for sale option is checked. |
Currency (field ACGCUR) |
Family (field FLGACG) |
This indicator is linked to the field that follows. It enables the user to force the value of the field when it is activated. |
Family (field ACGGRPD) |
Help shared by the unit and mass processes of accounting allocation change. The definition screen of the Asset groups, which can be accessed from the Jump-to icon, can be used to: |
Accounting code (field FLGACC) |
This indicator is linked to the field that follows. It enables the user to force the value of the field when it is activated. |
Accounting code (field ACCCODD) |
Help shared by the unit and mass processings of accounting allocation change. |
General account (field GACD) |
Help shared by the unit and mass processings of accounting allocation change. |
CoA nature (field GACACND) |
This field displays the nature of the CoA account. |
In service date (field ITSDATD) |
Help shared by the unit and mass processings of accounting allocation change.
|
IFRS account (field IASACCD) |
This field displays the IAS/IFRS account, i.e. the accounting classification towards the IAS/IFRS national norms. It is loaded with the IAS/IFRS fixed asset account, defined at the level of the Accounting code it cannot be entered. |
IFRS nature (field IASACND) |
This field displays the nature of the IAS/IFRS account. |
Tab Deprec plans
This tab is made up of a table containing as many lines as there are depreciation plans managed by the company. It is used to:
- View the impact of the accounting allocation change (Family and/or Code) on the depreciation methods of each plan. Each of the elements in the method modified in this way if Update is set to Yes.
- Select each of the plans on which the new method will be applied. This selection is carried out by activating the Process indicator. It is possible, for the selected plans, to carry out any adjustment necessary on one or several elements of the depreciation method. To do so, the Update indicator preceding it must be set to Yes, if it isn't already.
The plans which the Process indicator is not active for, keep the depreciation methods which were applied to them before the accounting allocation change process.
- Specify the effective date of the method change. It can either be:
- The Period start date
- The FY start date
- The Depreciation start date
When the allocation change goes along with a method change, the process modalities linked to the selection of the effective date are described below. - Define the management terms of the potential variance on the depreciation when the change of method takes effect at the asset depreciation start date, which is earlier than the start date of the current fiscal year.
Note on the first use of the fixed assets: When the change of accounting allocation corresponds to a first use, the effect must have the value of the Depreciation start date and the compensation for the difference must be filled using the value of the Period charge. This adjustment is managed as follows:
- The cumulative of the previous FY E-1 equals 0 (the forcing flag is set to Yes)
- The charge that should have been applied in E-1 is adjusted in the current period of fiscal year E (the adjustment is added to the charge of this period).
Grid New deprec methods
Process (field TRTFLG) |
Indicator activated by double-click, which enables the user to precise the change of method generated by the modification of the account posting (Group and/or Accounting code) must be applied to the plan. |
Plan (field DPRPLND) |
The code for the depreciation plan. |
Chg effective start (field MTCTIATYP) |
Help common to the single and mass processes for the account posting change.
Specificities: when it corresponds to a first use, the account posting change is necessarily effective on the Depreciation start date. |
Rec. meth chge var (field MTCDEVADJ) |
Help common to the single and mass processes for the account posting change. |
Update-> (field STRFLG) |
When set to Yes, this forcing indicator enables to force the value of the field to which it is associated. |
Depr. start (field STRDPRDATD) |
Help shared by the unit and mass processings of accounting allocation change. |
Current mode (field DPMO) |
Method (field DPMD) |
Help common to the single and mass processes for the account posting change. The choice of the mode is submitted to the following restrictions:
The modification of the amortization mode can lead to the modification of the Depreciation start date of the plan and its loading, according to the setup carried out at the level of the Depreciation method, either with the First use date, or with the Purchase date, or with the Posting date. |
Update-> (field ENDDPRFLG) |
Depr. end (field ENDDPRDATD) |
Current duration (field DPRDURO) |
Update-> (field DURFLG) |
Upon opening the window, this indicator, if set to Yes, signals that the value of the field to which it is linked, has been updated on applying the field association. It can only be modified if the Process indicator is active. If set to Yes, the indicator enables to enter or change this value. |
Depre. durn (field DPRDURD) |
Help common to the single and mass processes for the account posting change. The rules for the entry and the value of the depreciation duration are a function of the depreciation method entered:
|
Current rate (field DPRRATO) |
Update-> (field DPRRATFLGD) |
Upon opening the window, this indicator, if set to Yes, signals that the value of the field to which it is linked, has been updated on applying the field association. It can only be modified if the Process indicator is active. If set to Yes, the indicator enables to enter or change this value. |
Rate (field DPRRATD) |
Help common to the single and mass processes for the account posting change. The rules for the entry of the depreciation rate are a function of the depreciation method entered:
|
Update-> (field DPRRA2FLGD) |
When set to Yes, this indicator enables to force the value of the field to which it is associated. It can only be modified if the Process indicator is active for the plan. |
Exc. depr rate (field DPRRAT2D) |
Help common to the single and mass processes for the account posting change. This field is linked with the management of the IT (Ordinario/Anticipato) mode. It is displayed only if the mode is allowed for company's country and can be entered only if the Maj flag is set to Yes. It is used to enter the depreciation rate used by the IT depreciation method (Ordinario/Anticipato) in order to calculate the Anticipato depreciation.
|
Update-> (field RSDVALFLG) |
When set to Yes, this indicator enables to force the value of the field to which it is associated. It can only be modified if the Process indicator is active for the plan. |
Residual value (field RSDVALD) |
Help common to the single and mass processes for the account posting change. |
Update-> (field ALWFLG) |
Upon opening the window, this indicator, if set to Yes, signals that the value of the field to which it is linked, has been updated on applying the field association. It can only be modified if the Process indicator is active. If set to Yes, the indicator enables to enter or change this value. |
Specif. rule - fiscal help (field ALWCODD) |
Help common to the single and mass process for the account posting change. When the Update indicator is set to Yes, this field displays the specific rule code defined by the field associations.
This code can only be entered or modified if the Process indicator is activated for the plan and if the Update field is set to Yes. The rule to apply is selected according to the depreciation mode selected and/or the depreciation plan. For example, rules generating fiscal help (Help 25 %, Help 50 %, Energy, Depreciation rise 30 %, ...) can only be applied for the Fiscal plan. Note on the 40% deduction [15/04/15-14/04/17] Specific rule for a French company: To apply this rule, the purchase date must be on or before 14/04/17. If not, you receive the message "If the specific rule no longer applies at the purchase date, make sure you have the rights to apply it. Do you confirm?" You can select Yes or No to dismiss the message.
|
Spc FYR rule amt (field ALWAMT) |
This field is used to enter a fiscal help. The amount should be less than the net value at the period start.
Note on the 40% deduction [15/04/15-14/04/17] Specific rule for a French company: To apply this rule, the purchase date must be on or before 14/04/17. If not, you receive the message "If the specific rule no longer applies at the purchase date, make sure you have the rights to apply it. Do you confirm?" You can select Yes or No to dismiss the message.
|
Update-> (field ACLCOEFLG) |
When set to Yes, this indicator enables to force the value of the field to which it is associated. It can only be modified if the Process indicator is active for the plan. |
Acceleration coeff. (field ACLCOED) |
Help common to the single and mass processes for the account posting change. The depreciation accelerator coefficient is used to manage depreciation modes: Declining balance, Belgian declining, Russian straight-line, Russian declining, Russian constant and Softy Russian modes. It can only be modified for these depreciation modes. |
Update-> (field PRATYPFLG) |
Upon opening the window, this indicator, if set to Yes, signals that the value of the field to which it is linked, has been updated on applying the field association. It can only be modified if the Process indicator is active. If set to Yes, the indicator enables to enter or change this value. |
Prorata (field PRATYPD) |
Help common to the single and mass processes for the account posting change. |
Fiscal year start date (field FIYSTRDAT) |
This field , non modifiable, displays the financial year start date of the context which the plan belongs to. |
Period start date (field PERSTRDAT) |
This field displays the period start date of the plan. |
Depre start date (field STRDPRDAT) |
This field, non modifiable, reminds the user of the asset amortisation start date. |
FY depre total (field DPRCUM) |
Standard (field PLNSTD) |
This field reminds the user of the accounting standard retained for the management of the depreciation plan. |
Periodic total P-1 (field PERCLOCUM) |
Potential effective dates and processing terms
The table below presents the adjustment or processing terms applied to each asset, according to the effective date of the method change.
1/ The depreciation start date is less than the start date of the current FY fiscal year.
Effective date |
Processing Terms |
Depreciation start date |
The depreciation total on FY-1 end is recalculated. |
Current F Fiscal year start date |
The depreciation total on FY-1 end is not recalculated. |
Start date of current period P |
The depreciation total on FY-1 end is not recalculated. |
2/ The depreciation start date is greater than or equal to the start date of the current FY and less than the start date of the current period P.
Effective date |
Processing Terms |
Depreciation start date |
The charge of the F fiscal year will be recalculated using the new method. |
Start date of current period P |
The depreciation total of the closed periods of the current fiscal year is not recalculated. |
3/ The depreciation start date is greater than or equal to the start date of the current period P.
Effective date |
Processing Terms |
Depreciation start date |
The charge of period P (or the depreciation start period) will be recalculated based on the new depreciation method. |
A list of examples is provided below, illustrating the implementations and processing terms available.
Effective date and consecutive method changes:
During an ongoing fiscal year, multiple depreciation method changes can be carried out. The implementation of a method change cannot be prior to the previous change.
Example
Let us consider a fiscal year containing 4 periods: P1, P2, P3 and P4.
- During P2, a change of method is made to be effective at Period start.
During P3, only a change of method to be effective at Period start will be possible. - During P1, a change of method is made to be effective at Fiscal year start.
During P3, a change of method to be effective at Fiscal year start or a change of method to be effective at Period start will be possible.
Examples of method change
Depreciation start date less than Current fiscal year FY
- Example 1
Effectiveness: Depreciation start date
Chosen terms: Variance on total at the end of F-1 in Carry forward balance
- Depreciation start date: 01/07/2004 (i.e. 184 holding days)
- Asset value: 10,000
- Method: linear
- Duration: 5 years
- Current fiscal year: 01/01/2006 - 31/12/2006
- Current period: 01/04/2006 - 30/06/2006
- Depreciation total on FY-1 end: 3,005.46
- Duration change (extended to 6 years)
Fiscal year | Period | Fiscal year start total | Fiscal year charge | Period charge | Period end total | Carry-forward |
01/01/04 - | (1,005.46) | |||||
01/01/05 - | (2,000.00) | |||||
01/01/06 - | 01/01/06 - 31/03/06 | 3,005.46 | 2,000.00 | 493.15 | 493.15 | |
01/04/06 - | (3,005.46) | 1,667.00 | (2) 333.50 | 826.65 | (-500.41) | |
01/07/06 - | 2,505.05 | 1,667.00 | 420.17 | 1,246.82 | ||
01/10/06 - | 2,505.06 | 1,667.00 | 420.18 | 1,667.00 | ||
01/01/07 - | 01/01/07 - | (3) 4,172.05 | 1,667.00 | 411.04 | 411.04 | |
01/04/07 - | 4,172.05 | 1,667.00 | 415.61 | 826.65 | ||
01/07/07 - | 4,172.05 | 1,667.00 | 420.17 | 1,246.82 | ||
01/10/07 - | 4,172.05 | 1,667.00 | 420.18 | 1,667.00 | ||
01/01/08 - | 5,839.05 | 1,667.00 | ||||
01/01/09 - | 7,506.05 | 1,667.00 | ||||
01/01/10 - | 9,173.05 | 826.95 | ||||
01/01/11 - | 10,000.00 |
(1) The variance between the new total on FY-1 and the previous one: 2,505.05 - 3,005.46 = -500.41 must be posted as Carry-forward at the start of F financial year.
The new total at the end of F-1 (2,505.05) cancels and replaces the previous one (3,005.46), even though the forcing flag is set to Yes for this total.
(2) The charge of the fiscal year is recalculated using the new duration, the charge of the P period contains the depreciation total variance of the closed periods of the F fiscal year:
(10,000.00 x 16,67 %) = 1,667.00 x (181 days / 365 days) = 826.65 - 493.15 = 333.50
(3) At the closing of 2006 fiscal year, the total at the end of the year is calculated as follows:
New total at the end of 2005 re-caculated after the change of method + Charge of 2006
Let us consider: 2,505.05 / 1,667.00 = 4,172.05
Depreciation start date less than Current fiscal year FY
- Example 2
Effectiveness: Depreciation start date
Chosen terms: Variance on total at the end of F-1 in Exceptional charge of the fiscal year
- Depreciation start date: 01/07/2004 (i.e. 184 holding days)
- Asset value: 10,000
- Method: linear
- Duration: 5 years
- Current fiscal year: 01/01/2006 - 31/12/2006
- Current period: 01/04/2006 - 30/06/2006
- Depreciation total on FY-1 end: 3,005.46
- Duration change (extended to 6 years)
Fiscal year | Period | Fiscal year start total | Fiscal year charge | Period charge | Period end total | Fiscal |
01/01/04 - | (1,005.46) | |||||
01/01/05 - | (2,000.00) | |||||
01/01/06 - | 01/01/06 - 31/03/06 | 3,005.46 | 2,000.00 | 493.15 | 493.15 | |
01/04/06 - | 3,005.46 | 1,667.00 | (2) 333.50 | 826.65 | (-500.41) | |
01/07/06 - | 3,505.46 | 1,667.00 | 420.17 | 1,246.82 | (-500.41) | |
01/10/06 - | 3,505.46 | 1,667.00 | 420.18 | 1,667.00 | (-500.41) | |
01/01/07 - | 01/01/07 - | (3) 4,172.05 | 1,667.00 | 411.04 | 411.04 | |
01/04/07 - | 4,172.0 | 1,667.00 | 415.61 | 826.65 | ||
01/07/07 - | 4,172.05 | 1,667.00 | 420.17 | 1,246.82 | ||
01/10/07 - | 4,172.0 | 1,667.00 | 420.18 | 1,667.00 | ||
01/01/08 - | 5,839.0 | 1,667.00 | ||||
01/01/09 - | 7,506.05 | 1,667.00 | ||||
01/01/10 - | 9,173.05 | 826.95 | ||||
01/01/11 - | 10,000.00 |
(1) The variance between the new total on FY-1 and the previous one: 2,505.05 - 3,005.46 = -500.41 must be posted as Exceptional charge for the F fiscal year, this exceptional charge must be distributed on the current period and the following ones.
For the period [01/04/06 - 30/06/06]: -500.41 x (181 / 365) = -248.15
For the period [01/07/06 - 30/09/06]: -500.41 x (273 / 365) - (-248.5) = -126.13
For the period [01/10/06 - 30/12/06]: -500.41 - -374.28 = -126.13
(2) The charge of the fiscal year is recalculated using the new duration, the charge of the P period contains the depreciation total variance of the closed periods of the F fiscal year:
(10,000.00 x 16,67 %) = 1,667.00 x (181 days / 365 days) = 826.65 - 493.15 = 333.50
(3) At the closing of 2006 fiscal year, the total at the end of the year is calculated as follows:
Total at the end of 2005 + Exceptional charge of 2006
Let us consider: 3,005.46 + 1,667.00 - 500.41 = 4,172.05
Depreciation start date less than Current fiscal year FY
- Example 3
Effectiveness: Depreciation start date
Chosen terms: Variance on total at the end of F-1 in Exceptional charge of the period
- Depreciation start date: 01/07/2004 (i.e. 184 holding days)
- Asset value: 10,000
- Method: linear
- Duration: 5 years
- Current fiscal year: 01/01/2006 - 31/12/2006
- Current period: 01/04/2006 - 30/06/2006
- Depreciation total on FY-1 end: 3,005.46
- Duration change (extended to 6 years)
Fiscal year | Period | Fiscal year start total | Fiscal year charge | Period charge | Period end total | Fiscal |
01/01/04 - | (1,005.46) | |||||
01/01/05 - | (2,000.00) | |||||
01/01/06 - | 01/01/06 - 31/03/06 | 3,005.46 | 2,000.00 | 493.15 | 493.15 | |
01/04/06 - | 3,005.46 | 1,667.00 | (2) 333.50 | 826.65 | (-500.41) | |
01/07/06 - | 3,505.46 | 1,667.00 | 420.17 | 1,246.82 | ||
01/10/06 - | 3,505.46 | 1,667.00 | 420.18 | 1,667.00 | ||
01/01/07 - | 01/01/07 - | (3) 4,172.05 | 1,667.00 | 411.04 | 411.04 | |
01/04/07 - | 4,172.05 | 1,667.00 | 415.61 | 826.65 | ||
01/07/07 - | 4,172.05 | 1,667.00 | 420.17 | 1,246.82 | ||
01/10/07 - | 4,172.05 | 1,667.00 | 420.18 | 1,667.00 | ||
01/01/08 - | 5,839.05 | 1,667.00 | ||||
01/01/09 - | 7,506.05 | 1,667.00 | ||||
01/01/10 - | 9,173.05 | 826.95 | ||||
01/01/11 - | 10,000.00 |
(1) The variance between the new total on FY-1 and the previous one: 2,505.05 - 3,005.46 = -500.41 must be posted as Exceptional charge for the P period, when the change of method was carried out.
(2) The charge of the fiscal year is recalculated using the new duration, the charge of the P period contains the depreciation total variance of the closed periods of the F fiscal year:
(10,000.00 x 16,67 %) = 1,667.00 x (181 days / 365 days) = 826.65 - 493.15 = 333.50
(3) At the closing of 2006 fiscal year, the total at the end of the year is calculated as follows:
Total at the end of 2005 + Exceptional charge of 2006
Let us consider: 3,005.46 + 1,667.00 - 500.41 = 4,172.05
Depreciation start date less than Current fiscal year FY
- Example 4
Effectiveness: Depreciation start date
Chosen terms: Variance on total at the end of F-1 integrated to the charge of the fiscal year
- Depreciation start date: 01/07/2004 (i.e. 184 holding days)
- Asset value: 10,000
- Method: linear
- Duration: 5 years
- Current fiscal year: 01/01/2006 - 31/12/2006
- Current period: 01/04/2006 - 30/06/2006
- Depreciation total on FY-1 end: 3,005.46
- Duration change (extended to 6 years)
Fiscal year | Period | Total | Fiscal | Fiscal | Total |
01/01/04 - | (1,005.46) | ||||
01/01/05 - | (2,000.00) | ||||
01/01/06 - | 01/01/06 - | 3,005.46 | 2,000.00 | 493.15 | 493.15 |
01/04/06 - | 3,005.46 | (1) 1,166.59 | (2) 85.35 | 578.50 | |
01/07/06 - | 3,005.46 | 1,166.59 | 294.05 | 872.55 | |
01/10/06 - | 3,005.46 | 1,666.59 | 294.04 | 1,166.59 | |
01/01/07 - | 01/01/07 - | (3) 4,172.05 | 1,667.00 | 411.04 | 411.04 |
01/04/07 - | 4,172.05 | 1,667.00 | 415.61 | 826.65 | |
01/07/07 - | 4,172.05 | 1,667.00 | 420.17 | 1,246.82 | |
01/10/07 - | 4,172.05 | 1,667.00 | 420.18 | 1,667.00 | |
01/01/08 - | 5,839.05 | 1,667.00 | |||
01/01/09 - | 7,506.05 | 1,667.00 | |||
01/01/10 - | 9,173.05 | 826.95 | |||
01/01/11 - | 10,000.00 |
(1) The variance between the new total on FY-1 and the previous one: 2,505.05 - 3,005.46 = -500.41 must be integrated to the charge of the fiscal year. Let us consider 1,667.00 - 500.41 = 1,169.59
(2) The charge of the fiscal year is recalculated using the new duration, which contains the variance on the total at the end of F-1. The charge of the P period contains the depreciation total variance of the closed periods of the F fiscal year:
1,166.59 X (181 days / 365 days) = 578.50 - 493.15 = 85.35
(3) At the closing of 2006 fiscal year, the total at the end of the year is calculated as follows:
total at the end of 2005 + Charge of 2006
Let us consider: 3,005.46 / 1,166.59 = 4,172.05
Depreciation start date less than Current fiscal year FY
- Example 5
Effectiveness: Depreciation start date
Chosen terms: Variance on total at the end of F-1 integrated to the charge of the period
- Depreciation start date: 01/07/2004 (i.e. 184 holding days)
- Asset value: 10,000
- Method: linear
- Duration: 5 years
- Current fiscal year: 01/01/2006 - 31/12/2006
- Current period: 01/04/2006 - 30/06/2006
- Depreciation total on FY-1 end: 3,005.46
- Duration change (extended to 6 years)
Fiscal year | Period | Total | Fiscal | Fiscal | Total |
01/01/04 - | (1,005.46) | ||||
01/01/05 - | (2,000.00) | ||||
01/01/06 - | 01/01/06 - | 3,005.46 | 2,000.00 | 493.15 | 493.15 |
01/04/06 - | 3,005.46 | 1,166.59 | (1) -166.91 | 326.24 | |
01/07/06 - | 3,005.46 | 1,166.59 | (2) 420.17 | 746.41 | |
01/10/06 - | 3,005.46 | 1,666.59 | 420.18 | 1,166.59 | |
01/01/07 - | 01/01/07 - | (3) 4,172.05 | 1,667.00 | 411.04 | 411.04 |
01/04/07 - | 4,172.05 | 1,667.00 | 415.61 | 826.65 | |
01/07/07 - | 4,172.05 | 1,667.00 | 420.17 | 1,246.82 | |
01/10/07 - | 4,172.05 | 1,667.00 | 420.18 | 1,667.00 | |
01/01/08 - | 5,839.05 | 1,667.00 | |||
01/01/09 - | 7,506.05 | 1,667.00 | |||
01/01/10 - | 9,173.05 | 826.95 | |||
01/01/11 - | 10,000.00 |
(1) The variance between the new total on FY-1 and the previous one: 2,505.05 - 3,005.46 = -500.41 must be integrated to the charge of the fiscal year (1,667.00 - 500.41 = 1,169.59) and posted in the charge of the P period.
Let us consider [1,667.00 x (181 / 365) - 493.15] + (-500.41) = -166.91
(2) The charge of each following period does not contain any variance on the total at the end of F-1. The calculation is as follows:
1,667.00 x (273 / 365) - 326.24 + (500.41 ) = 420.17 --> total at the end of 3rd period = 746.41
1,667.00 c (365 / 365) - 746.41 + (500.41 ) = 420.18 --> total at the end of 4th period = 1,166.59
(3) At the closing of 2006 fiscal year, the total at the end of the year is calculated as follows:
total at the end of 2005 + Charge of 2006
Let us consider: 3,005.46 / 1,166.59 = 4,172.05
Depreciation start date less than Current fiscal year FY
- Example 6
Effectiveness: F Fiscal year start date
Imposed terms: Recalculation of the FY fiscal year using the new method based on a residual mode. The charge of the P period contains the regulation of the charges of the closed periods.
- Depreciation start date: 01/07/2004 (i.e. 184 holding days)
- Asset value: 10,000
- Method: linear
- Duration: 5 years
- Current fiscal year: 01/01/2006 - 31/12/2006
- Current period: 01/04/2006 - 30/06/2006
- Depreciation total on FY-1 end: 3,005.46
- Duration change (extended to 6 years)
Fiscal year | Period | Total | Fiscal | Fiscal | Total |
01/01/04 - | 1,005.46 | ||||
01/01/05 - | 2,000.00 | ||||
01/01/06 - | 01/01/06 - | 3,005.46 | 2,000.00 | 493.15 | 493.15 |
01/04/06 - | 3,005.46 | (1) 1,554.82 | 277.87 | 771.02 | |
01/07/06 - | 3,005.46 | 1,554.82 | 391.90 | 1,162.92 | |
01/10/06 - | 3,005.46 | 1,554.82 | 391.30 | 1,554.82 | |
01/01/07 - | 01/01/07 - | 4,560.28 | 1,554.81 | 383.38 | 383.38 |
01/04/07 - | 4,560.28 | 1,554.81 | 387.64 | 771.02 | |
01/07/07 - | 4,560.28 | 1,554.81 | 391.89 | 1,162.91 | |
01/10/07 - | 4,560.28 | 1,554.81 | 391.90 | 1,554.81 | |
01/01/08 - | 6,115.09 | 1,559.08 | |||
01/01/09 - | 7,674.17 | 1,554.81 | |||
01/01/10 - | 9,228.98 | 771.02 | |||
01/01/11 - | 10,000.00 |
(1) The new charge of 2006 fiscal year equals to: Net value start of 2006 x (number of days in 2006 / number of days between 01/01/2006 and the depreciation end date: 30/06/2010).
Let us consider: (10,000 - 3005.46) x (365 / 1,642 days) = 1,554.82
The duration change is performed in the current period [01/04/2006 - 30/06/2006]; the charge of this period is equal to: Charge of fiscal year x (number of days until 30/06/2006 / number of days in 2006) - Depreciation total of P-1.
Let us consider: [1,554.82 x (181 / 365)] - 493.15 = 277.87
Depreciation start date less than Current fiscal year FY
- Example 7
Effectiveness: P Period start date.
Imposed terms: Recalculation of the "residual" fiscal year charge using the new method based on a residual mode. This charge of the "residual" fiscal year is distributed on the P period and the following of the F fiscal year.
- Depreciation start date: 01/07/2004 (i.e. 184 holding days)
- Asset value: 10,000
- Method: linear
- Duration: 5 years
- Current fiscal year: 01/01/2006 - 31/12/2006
- Current period: 01/04/2006 - 30/06/2006
- Depreciation total on FY-1 end: 3,005.46
- Duration change (extended to 6 years)
Fiscal year | Period | Total | Fiscal | Fiscal | Total |
01/01/04 - | 1,005.46 | ||||
01/01/05 - | 2,000.00 | ||||
01/01/06 - | 01/01/06 - | 3,005.46 | 2,000.00 | 493.15 | 493.15 |
01/04/06 - | 3,005.46 | (2) 1,645.14 | (1) 381.20 | 874.35 | |
01/07/06 - | 3,005.46 | 1,645.14 | 385.40 | 1,259.75 | |
01/10/06 - | 3,005.46 | 1,645.14 | 385.39 | 1,645.14 | |
01/01/07 - | 01/01/07 - | 4,650.60 | 1,529.00 | 377.01 | 377.01 |
01/04/07 - | 4,650.60 | 1,529.00 | 381.21 | 758.22 | |
01/07/07 - | 4,650.60 | 1,529.00 | 385.39 | 1,143.61 | |
01/10/07 - | 4,650.60 | 1,529.00 | 385.39 | 1,529.00 | |
01/01/08 - | 6,179.60 | 1,533.19 | |||
01/01/09 - | 7,712.79 | 1,529.00 | |||
01/01/10 - | 9,241.79 | 758.21 | |||
01/01/11 - | 10,000.00 |
(1) The charge of the method change period is calculated as follows:
(10,000 - 3,005.46 - 493.15 ) x (275 days / 1,552 days) x (91 days / 275 days) = 381.20
1,552 days = depreciation residual duration, corresponding to the period [01/04/2006 - 30/06/2010]
275 days = residual duration in the fiscal year, equal to the period [01/04/2006 - 31/12/2006]
91 days = period duration [01/04/2006 - 30/06/2006]
(2) The new charge of 2006 fiscal year equals to:
493.15 + [(10,000 - 3,005.46) x (275 days / 1,552 days)] = 1,645.14
Depreciation start date greater than or equal to the current FY fiscal year start and less than the current period P start
- Example 8
Effectiveness: Depreciation start date
Imposed terms: Recalculation od the charge of F fiscal year using the new method
The charge of the P period contains the regulation of the charges of the closed periods.
- Depreciation start date: 01/02/06 (i.e. 334 holding days)
- Asset value: 10,000
- Method: linear
- Duration: 5 years
- Current fiscal year: 01/01/2006 - 31/12/2006
- Current period: 01/04/2006 - 30/06/2006
- Duration change (extended to 4 years)
Fiscal year | Period | Total | Fiscal | Fiscal | Total |
01/01/06 - | 01/01/06 - | 1,830.14 | 323.29 | 323.29 | |
01/04/06 - | 2,287.67 | (1) 704.11 | 1,027.40 | ||
01/07/06 - | 2,287.67 | 630.13 | 1,657.53 | ||
01/10/06 - | 2,287.67 | 630.14 | 2,287.67 | ||
01/01/07 - | 01/01/07 - | 2,287.67 | 2,500.00 | 616.44 | 616.44 |
01/04/07 - | 2,287.67 | 2,500.00 | 623.29 | 1,239.73 | |
01/07/07 - | 2,287.67 | 2,500.00 | 630.13 | 1,869.86 | |
01/10/07 - | 2,287.67 | 2,500.00 | 630.14 | 2,500.00 | |
01/01/08 - | 4,787.67 | 2,500.00 | |||
01/01/09 - | 7,287.67 | 2,500.00 | |||
01/01/10 - | 9,787.67 | 212.33 | |||
01/01/11 - | 10,000.00 |
(1) The charge of the fiscal year is recalculated using the new duration. The charge of the P period contains the depreciation total variance of the closed periods of the F fiscal year:
2,287.67 X (150 days / 334 days) = 1,027.40 - 323.29 = 704.11
Depreciation start date greater than or equal to the current FY fiscal year start and less than the current period P start
- Example 9
Effectiveness: P Period start date.
Imposed terms: Recalculation of the "residual" fiscal year charge using the new method based on a residual mode. This charge of the "residual" fiscal year is distributed on the P period and the following of the F fiscal year.
- Depreciation start date: 01/02/06 (i.e. 334 holding days)
- Asset value: 10,000
- Method: linear
- Duration: 5 years
- Current fiscal year: 01/01/2006 - 31/12/2006
- Current period: 01/04/2006 - 30/06/2006
- Duration change (extended to 4 years)
Fiscal year | Period | Total | Fiscal | Fiscal | Total |
01/01/06 - | 01/01/06 - | 1,830.14 | 323.29 | 323.29 | |
01/04/06 - | (2) 2,221.36 | (1) 628.09 | 951.38 | ||
01/07/06 - | 2,221.36 | 634.99 | 1,586.37 | ||
01/10/06 - | 2,221.36 | 634.99 | 2,221.36 | ||
01/01/07 - | 01/01/07 - | 2,221.36 | 2,519.26 | 621.19 | 621.19 |
01/04/07 - | 2,221.36 | 2,519.26 | 628.09 | 1,249.28 | |
01/07/07 - | 2,221.36 | 2,519.26 | 634.99 | 1,884.27 | |
01/10/07 - | 2,221.36 | 2,519.26 | 634.99 | 2,519.26 | |
01/01/08 - | 4,740.62 | 2,526.16 | |||
01/01/09 - | 7,266.78 | 2,519.26 | |||
01/01/10 - | 9,786.04 | 213.96 | |||
01/01/11 - | 10,000.00 |
(1) The charge of the method change period is calculated as follows:
(10,000 - 323.29 ) x (275 days / 1,402 days) x (91 days / 275 days) = 628.09
1,402 days = depreciation residual duration, corresponding to the period [01/04/2006 - 31/10/2006]
275 days = residual duration in the fiscal year corresponding to the period [01/04/2006 - 31/12/2006]
91 days = period duration [01/04/2006 - 30/06/2006]
(2) The new charge of 2006 fiscal year equals to:
323.29 + [ (10,000 - 323.29 ) x (275 days / 1,402 days)] = 2,221.36
Tab Extended selection
This tab is used to enter the assets selection criteria.
It contains five lines, each of them used to enter a criterion, with each criterion being linked to the next one by one of the following logical operators: And, Or.
The entry of a selection criterion is performed as follows:
1/ Enter a field or use the Lookup tool to select one from the FXDASSETS - assets table.
2/ Select the operator: All, Equal, Not equal to, Greater than or equal to, Less than, Less than or equal to, Like.
The Like operator is valid only for numeric fields and you can use wild card characters.
3/ Enter a value. Use the Lookup tool for a list of possible values in the related local menu or in a table (miscellaneous table, common table, accounting table, etc.).
You can:
- Enter the criteria in the form of an expression. The formulas of this type can be entered by right-clicking the fields in the FXDASSETS - asset table.
- Enter a selection formula using the formula editor.
Block number 1
Batch task
This function can be run in batch mode. The standard task FASTRFC is provided for that purpose.
Specific Buttons
Error messages
In addition to the generic error messages, the following messages can appear during the entry :
If the specific rule no longer applies at the purchase date, make sure you have the rights to apply it.This message relates to the 40% deduction [15/04/15-14/04/17] Specific rule for a French company.
It displays when the asset purchase date is after 14/04/17, either changed or entered on creation. You can select Yes or No to dismiss the message.
Yes: Applies the rule even if the purchase date is past 14/04/17.
No: Creation or updates are not applied and you need to change the Specific rule to None or cancel the action.