Reports > Module Fixed Assets > Report DEPRECTWIN (Reconciliation of 2 schedules) 

This report reproduces the situation of two given depreciation plans in order to underline the gaps between both plans.

The assets are presented, sorted by company, financial site and accounting code with a sub-aggregation to each shortage on one of these criteria.

It is also possible to obtain a synthetic report showing only the sub-aggregations by accounting code, financial site and company.

A global total is displayed in the case of a multi-company print.

Prerequisite

Access to the report

This report can be accessed from the report menu of the group Fixed Assets - Fixed assets.

List of criteria

Parameter

Parameter title

Type

cpydeb

Company limit

CPY

fcydeb

Financial site range

FCY

ccptdeb

Accounting code range

CAC

accdeb

General account ranges

GAC

accifrsdeb

IFRS" account range

GAC

typdetdeb

Holding type (Local menu Owned, Rented, Leased, Provisional, Concession...)

M3171

acggrpdeb

Family range

FAM

refdeb

Asset range

AAS

situation

FY or period (Local menu Financial year, Period, Period total)

M3186

datdeb

Date range

D4

plan1

Depreciation plan 1 (Local menu Accounts, Finance, Minimum, Source, Reevaluation 76...)

M3101

plan2

Depreciation plan 2 (Local menu Accounts, Finance, Minimum, Source, Reevaluation 76...)

M3101

detail

Detailed status by asset (Local menu No, Yes)

M1

impselections

Print selections (Local menu No, Yes)

M1

Comments

The data is filtered by site according to the rights granted to the user on the function GESFAS (Assets).

Miscellaneous

Entering values for the selection setups is not mandatory. The default values displayed are those entered in the Report dictionary.
When values are entered, any existence control is carried out. In the case where they are inexistent or inconsistent, any print is carried out.

Description of the report

Implicit Selection:

Are automatically excluded, the fixed assets:
 
-  issued in the previous fiscal years
- which depreciation start date is higher than the fiscal year or the selected period end date (according to the value entered for the selection criteria: Fiscal year situation or Period).

Selection of plans

The choice of the mode is submitted to the following restrictions:
 
- If the required report concerns a Fiscal year situation, both selected depreciation plans must have the same fiscal year division.
 - If the required report concerns a Period situation, both selected depreciation plans must have the same periodic division.
 - The management currency of both selected plans must be identical.

The assets are presented, grouped and sorted in ascending order according to the following criteria:

Grouping/sorting criteria and aggregation

- Company                                  Aggregation by company with page break
- Financial site                      Aggregation by financial site with page break
- Accounting code                 Aggregation by accounting code without page break
- Asset reference

Restored information

The content of the report varies according to the value entered for the setup: Report detailed by asset (or synthesis report).

  • Header
     
    The header recalls the following information:

     - Company reference
    - Selected depreciation plans, fiscal year start and end date.
     - Selected period start and end date of the selected depreciation plans (displayed only if it is a periodic situation).
     
  • Detailed report
     
    This report displays 3 lines by selected fixed asset.

     On the 1st line: identification of the asset and gaps between the two selected depreciation plans.

Information

Loaded from the fields

Table

Reference

AASREF

FAS

Description 1

AASDES1

FAS

Acquisition date:

PURDAT

FAS

Asset issue date

ISSDAT

FAS

Gap between the depreciation basis of the 2 plans

DPRBAS Plan 1 – DPRBAS Plan 2

DEP

Gap between the residual value of the two plans

DPRBAS Plan 1 – DPRBAS Plan 2

DEP

Gap between depreciation total of both plans at the beginning of the fiscal year
or at the beginning of the period

Depreciation total Plan 1 – depreciation total Plan 2
= (1) – (3)

 

Gap between impairment loss balance of both plans at the beginning of the fiscal year
or at the beginning of the period

IMLBLC Plan 1 – IMLBLC Plan 2

DEP

Gap between (Normal depreciation expense + Extraordinary depreciation expense) both plans for the fiscal year
or for the period

Depreciation expense Plan 1– Depreciation expense Plan 2
= (2) – (4)

 

Gap between (Reversal - Impairment loss) both plans, of the fiscal year
 or the period

IMLRVE – IML Plan 1
-
IMLRVE – IML Plan 2

 

Gap between the two plans net value by the end of the fiscal year
or by the end of the period

NBV Plan 1 – NBV Plan 2

 

On the 2nd line: situation of the 1st selected depreciation plan

Information

Loaded from the fields

Table

Plan 1

 

 

GCA Account
or IAS according to the selected plan

GAC
Or IASACC

FAS

Depreciation start date

STRDPRDAT

DEP

Depreciation method

DPM

DEP

Depreciation duration

DPRDUR

DEP

Depreciation rate

DPRRAT

DEP

Depreciation basis

DPRBAS

DEP

Residual value

RSDVAL

DEP

- Depreciation total beginning of fiscal year
or period start

DPRCUM
Or                                    (1)
DPRCUM + PERCLOCUM  

 
DEP

Fiscal year
or period start impairment loss balance


IMLBLC

DEP

Normal depreciation expense + extraordinary depreciation expense, fiscal year
or period

ENDDPE + EXCDPR
Or                                   (2)
PERENDDPE 

 
DEP

Reversal - impairment loss, fiscal year
 or period


IMLRVE – IML


DEP

Fiscal year or
period end net value

NBV

DEP

On the 3rd line: situation of the 2nd selected depreciation plan

Information

Loaded from the fields

Table

Plan 2

 

 

GCA Account
or IAS according to the selected plan

GAC
Or IASACC


FAS

Depreciation start date

STRDPRDAT

DEP

Depreciation method

DPM

DEP

Depreciation duration

DPRDUR

DEP

Depreciation rate

DPRRAT

DEP

Depreciation basis

DPRBAS

DEP

Residual value

RSDVAL

DEP

Depreciation total beginning of fiscal year
or period start

DPRCUM
Or                                    (3)
DPRCUM + PERCLOCUM  

 
DEP

Fiscal year
or period start impairment loss balance

IMLBLC


DEP

Normal depreciation expense + extraordinary depreciation expense, fiscal year
or period

ENDDPE + EXCDPR
Or                                   (4)
PERENDDPE 

 
DEP

Reversal - impairment loss, fiscal year
 or period

IMLRVE – IML


DEP

Fiscal year or
period end net value

NBV

DEP

Then, are displayed the aggregation lines identical to those displayed below for a synthesis report.

  • Synthesis report
     
    This report displays:
     
    - 3 aggregation lines by shortage on Accounting code, Financial site and Company.
    - 3 lines of general total are also displayed in the last page, if the report concerns several companies.
     
    On the 1st line:

     - Total gap between the depreciation basis of the 2 plans
    - Total gap between the residual value of the two plans
    - Total gap between the depreciation total of the 2 plans
    - Total gap between the impairment loss balance of the two plans
    - Total gap between (Normal depreciation expense + Extraordinary depreciation expense) of the 2 plans
    - Total gap between (Reversal - Impairment loss) of the two plans
    - Total gap between the Net value of the two plans

    On the 2nd line (Plan 1) and the 3rd line (Plan 2):
     
    - Total depreciation basis
    - Total residual value
    - Total depreciation
    - Total depreciation balance
    - Total (Normal depreciation expense + Extraordinary depreciation expense)
    - Total (Reversal – Impairment loss)
    - Total net value

Tables concerned

The data extracted from the following tables are processed by the report DEPRECTWIN :

Table

Table description

AFCTFCY [AFF]

Site profile function

COMPANY [CPY]

Company

CONTEXT [CNX]

Contexts

DEPREC [DEP]

Charge

FACILITY [FCY]

Sites

FISCYEAR [FIS]

Fiscal year

FXDASSETS [FAS]

Assets

GACCCODE [CAC]

Accounting codes