Post Revaluations and New Valuations 

Use

You can use the Post Revaluation and New Valuation report to post individual and mass revaluations for depreciable assets.

To access the report from the SAP Easy Access menu, choose Accounting ® Financial Accounting ® Fixed Assets ®Periodic Processing ® Revaluation for the Balance Sheet ® Post Revaluation and New Valuation.

Features

The Post Revaluation and New Valuation report determines the posted depreciation, writes it back, and posts the required adjustment to the net book value (NBV) for both individual and mass revaluations.

You can also use this report to update a nominated evaluation group/user field with a specified characteristic, such as revaluation year, for reporting purposes.

Activities

Customizing

Make all the settings in the relevant IMG activities in Customizing for Financial Accounting (FI) by choosing Asset Accounting ® Special Valuation ® Revaluation of Fixed Assets ®Revaluation for the Balance Sheet.

For more information, see Configuring Revaluation Transaction Types and Configuring Depreciation Keys for Revalued Assets.

Master Data

Create a revaluation offsetting account for each asset class (see Determination of Offsetting Account for New Valuation Posting). Also create the characteristic to be updated on the asset, if this is required (see User Fields).

Periodic Processing

After depreciation has been run and posted for the period of revaluation, specify the new asset value and the system then makes the following postings for individual revaluations:

       1.      For increment postings

Line	PK	Account	Amount
0001	75	Asset APC	Total posted depreciation write-back
0002	70	Accumulated Depreciation	Total posted depreciation write-back
0003	70	Asset APC	Revaluation adjustment
0004	50	Revaluation clearing account for class	Revaluation adjustment

       2.      For decrement postings

Line	PK	Account	Amount
0001	75	Asset APC	Total posted depreciation write-back
0002	70	Accumulated Depreciation	Total posted depreciation write-back
0003	75	Asset APC	Revaluation adjustment
0004	40	Revaluation clearing account for class	Revaluation adjustment

 

In the case of mass revaluations, the same postings are made but you have the additional option of importing the actual asset values to the system from a spreadsheet or text file (either Microsoft Excel or comma delimited text file ‘.csv’) or applying an index to the existing values of the asset. If you use a spreadsheet for bulk upload, a maximum of 5000 assets can be processed in one run and the spreadsheet must have the following format:

No.	Length	Type	Status	Description
1	4	CHAR	M	Company code
2	12	CHAR	M	Asset number
3	4	CHAR	O	Asset subnumber. If no subnumber, enter ‘0’.
4	12	CURR	M	Asset value (new). Decimal places are included, if specified, otherwise amounts are assumed to be whole currency.
5	8	CHAR	M	Revaluation offsetting account. If a G/L account other than that defined in the account determination of the class of asset being revalued is to be updated, specify it here.
6	4	CHAR	O	Contents to be updated to the evaluation group/user field specified on the input screen.

 

After the revaluation has been processed, you can display the values of the revalued asset in the Asset Explorer. The effect of the revaluation posting is shown in the Change column as follows:

Item	Change
Asset Valuation Trans.	- Total posted depreciation
Revaluation APC	+/- Revaluation amount (difference between new value and old NBV)
Ordinary Depreciation	- Current year posted depreciation
Value Adjustment	- Total posted depreciation