Selling Fixed Assets
This document describes how to create a customer invoice for the sale of a fixed asset and how financial gains and losses per depreciation type are calculated at the sale in M3 Business Engine.
Outcome
The fixed asset sold has status 9='Sold or disposed fixed asset' in 'Fixed Asset. Open' (FAS001). The following documents are printed: a customer invoice, a depreciation report (FAS102PF), depreciation account entries (FAS103PF), and an accounting journal (GLS041PF).
You can send the invoice to the customer. Store the other documents as internal documentation of the sale.
Before you start
- The Fixed Asset module must be set up to manage depreciations, as described in Defining Components for Fixed Asset Management and Configuring Depreciation of Fixed Assets.
- Accounting rules for accounting event FA50 must be defined in 'Accounting Rule. Set' (CRS395). To separate sales revenue from financial loss or gain, accounting rules FA50-540 and FA50-545 must be defined. To separate gain and loss per depreciation type connected to the fixed asset, FA50-560 (for the debit transaction) and FA50-565 (for the credit transaction) must be defined. For an example illustrating how these account entries are used, see below.
- The fixed asset must be recorded and have status 1 in 'Fixed Asset. Open' (FAS001).
- Basic settings for sale of fixed assets must be defined in 'Settings - Fixed Asset Sales' (FAS925) and its sub-program 'Settings - Fixed Asset Sales' (FAS926). The first parameter defines which value type to use to store the sales amount. After the sale, the sales amount is displayed for this value type for the fixed asset in 'Fixed Asset. Connect Value Types' (FAS003). The parameters in (FAS926) determine the depreciation type or types to be used to calculate the depreciation at the sale. For each depreciation type selected, you must select the value types to be used for any capital gain and capital loss respectively. The second parameter is used to manage the custom statistical number and item description. It depends on the setting in (FAS925) which determines how these fields are displayed, and how it will be completed during the selling of fixed assets in 'Fixed Asset. Sell' (FAS130) on panel H.
- The customer must be registered in 'Customer. Open' (CRS610).
- FAM function FA50 (Sales) must be defined in 'FAM Function. Open' (CRS405).
- If 'Additional payment references' are to be used, rules must be set up for this in 'Additional Payment Reference. Open' (CMS090). The only available reference number type is 1='Parallel invoice number'. The parallel invoice number is only added to the XML when the invoice is created.
Activity description
-
Create invoice for sale of asset
Record the sale of one or several fixed assets in (FAS130). For each invoice line, enter the ID of the asset on the H panel, the quantity to be sold and the sales price, the latter in the 'Line amount' field. If you are selling only a part of the fixed asset by entering a quantity lower than the one registered for the asset, the 'New FA' field is displayed where you enter a new fixed asset ID for the part to sell.
The new asset is automatically registered with the specified quantity and status 9='Sold or disposed fixed asset' in 'Fixed Asset. Open' (FAS001). After the invoice is created, the asset with the original ID remains in status 1='Normal FA' but the sold quantity is deducted from the original quantity.
-
Calculate financial gain or loss
Any financial gain or loss at the sale are automatically calculated using the following formula: sales price minus the acquisition cost retrieved from the value type on the depreciation type, provided that the value type is not the same as is selected in 'Settings – Fixed Asset Acquisition' (FAS900), minus the accumulated depreciation. If the sales value is higher than the result of the formula, then it is a financial gain, otherwise a loss.
About the calculation
Depreciation types in M3 Business Engine represent different depreciation methods. Every depreciation type defines a value type that stores the acquisition cost of the asset, based on which a depreciation plan is created. Several depreciation types can be connected to the same asset. Some depreciation types do not update the general ledger with the calculated depreciations, but are used for taxation purposes instead.
The standard value type for acquisition costs is selected in 'Settings – Fixed Asset Acquisition' (FAS900). Often the same value type is selected for the individual depreciation types. However, depreciation types used for taxation purposes may need a different acquisition cost and therefore use a different value type for the acquisition cost than was selected in (FAS900), resulting in different acquisition costs for the same asset. For depreciation types for derogatory depreciation the acquisition cost is always zero, since the acquisition cost is managed by the associated depreciation type.
Any financial gain or loss is automatically calculated at the sale of an asset by using the following formula: sales price minus the acquisition cost retrieved from the value type on the depreciation type, provided that the value type is not the same as is selected in 'Settings – Fixed Asset Acquisition' (FAS900), minus all depreciations made. If the sales value is higher than the result of the formula, then it is a financial gain, otherwise a loss. Gains and losses are calculated per depreciation type and recorded based on accounting rules. The gains and losses recorded are displayed for the asset in 'Fixed Asset. Connect Value Types' (FAS003) in the value types selected for each depreciation type in 'Settings – Fixed Asset Sales' (FAS926).
At the sale, the acquisition cost or costs are reversed. Since the acquisition cost for the same value type should only be reversed once, it is checked whether the value type of the depreciation type is selected in (FAS900). If it is, then the acquisition cost is only reversed for the first depreciation type with this value type for the asset.
Calculation Example
A fixed asset will be sold for EUR 50,000. The actual acquisition cost was 100,000, stored in value type 01, which is also the one selected in (FAS900). Another acquisition cost of 160,000 is stored for taxation purposes in value type 02. This table shows the depreciation types that are connected to the asset:
Depr. Type | Value Tp for Acq. Cost | Acc. Depr. |
---|---|---|
10 (Economic) | 01 | 40,000 |
20 (US GAAP) | 01 | 50,000 |
30 (IFRS) | 02 | 80,000 |
90 (Derogatory) | 01 | 11,000 |
A gain and loss will be calculated per depreciation type at sales. Since the value type of depreciation types 10, 20 and 90 is the same as in (FAS900), only the acquisition cost for depreciation type 10 is reversed.
Line | Acc. Tp | Account entry | Debit | Credit | Account | Depr. Tp |
---|---|---|---|---|---|---|
1 | 100 | Customer | 52,000 | A | ||
2 | 120 | Revenues (1) | 50,000 | B | ||
3 | 111 | VAT (1) | 2,000 | C | ||
4 | Acquisition cost reversed (2) | 100,000 | D | |||
5 | 560 | Offsetting debit transaction (5) | 100,000 | E | ||
6 | 500 | Depreciation reversed (3) | 40,000 | F | 10 | |
7 | 545 | Financial loss (4) | 10,000 | E | 10 | |
8 | 565 | Offsetting credit transaction (5) | 50,000 | B | 10 | |
9 | 500 | Depreciation reversed (3) | 50,000 | G | 20 | |
10 | 540 | Financial gain (4) | 0 | H | 20 | |
11 | 565 | Offsetting credit transaction (5) | 50,000 | I | 20 | |
12 | Acquisition cost reversed (6) | 160,000 | J | |||
13 | 500 | Depreciation reversed (3) | 80,000 | K | 30 | |
14 | 545 | Financial loss (4) | 30,000 | L | 30 | |
15 | 560 | Offsetting debit transaction (5) | 50,000 | M | 30 | |
16 | 500 | Depreciation reversed (3) | 11,000 | N | 90 | |
17 | 540 | Financial gain (7) | 11,000 | B | 90 |
Comments on calculation example
- Lines 2 and 3 are always created when you exit (FAS130).
- Reversal based on the value type for acquisition cost selected in (FAS900).
- The acquisition cost for this depreciation type is not reversed since it is based on the same value type selected in (FAS900) and already has been reversed.
- Gain or loss is calculated in the following way: sales price – acquisition value minus accumulated depreciations previous years – accumulated year-to-date depreciation – extraordinary depreciation. In this case: 50,000–(100,000–40,000) = –10,000.
- Since all account entries for a depreciation type must balance, any difference is recorded to account entry FA50-560 if it is greater than zero (debit), otherwise to FA50-565 if it is less than zero (credit).
- Since the value type for acquisition cost for depreciation type 30 is not the same as selected in (FAS900), the acquisition cost is reversed.
- Since depreciation type 90 is used for derogatory depreciation, it has no acquisition cost.
Selling Fixed Assets with Corporate Accounting and Reporting Activated
Multiple vouchers are created when a fixed asset is sold.
The book of account defined in 'FAM Function. Open Details' (CRS406) for FAM function FA50 is now used for the revenue voucher, and this must be connected to a voucher series that is 0-'Common'.
Acquisition reversal is written in a separate voucher set up in the FA51 FAM function and must be connected to a 0-'Common' voucher type.
Depreciation-specific transactions such as adjustments, depreciations, impairments, gains, or losses are written on vouchers according to the accounting ledger updated by the depreciation type.
With corporate accounting and reporting additional features for fixed assets, impairment or extraordinary depreciation now creates a different accounting line.
The voucher number and journal number that are to be retrieved are dependent on the period type used in the division. Additional information 40 is also created for the generated vouchers.
Example:
A fixed asset was purchased and activated on 20230801, addition and adjustment on the respective accounting ledger has been posted on the fixed asset. Then, a year-to-date depreciation was posted until the end of the current year for local and period 9 for the depreciation type that is updating the corporate accounting ledger.
Extraordinary depreciation was posted on the 12th period for the depreciation type updating the local accounting ledger.
FA transaction | Period | Ser | Vouch no | Name |
---|---|---|---|---|
AP100000050 | 202308 | P07 | 217181 | AP10510 |
AP100000050 | 202308 | P07 | 217181 | AP10510 |
AP100000050 | 202308 | P07 | 217181 | AP10510 |
AP100000050 | 202308 | P07 | 217182 | UPDATE |
AP100000050 | 202308 | P07 | 217182 | UPDATE |
GL010000050 | 202308 | P11 | 11032 | UPDATE |
GL010000050 | 202405 | P20 | 222037 | UPDATE |
FA100000050 | 202312 | P10 | 231036 | FA10L1 |
FA100000100 | 202409 | PD2 | 232014 | FA10C1 |
FA300000050 | 202312 | P10 | 231037 | EOLOC |
(Continuation of Table 1)
Vtp | Name | Rcd | Voucher type |
---|---|---|---|
1 | Purchase Cost | 0 | 0 |
3 | Residual Value | 0 | 0 |
10 | Total Acq Cost | 0 | 0 |
10 | Total Acq Cost | 0 | 0 |
4 | Additional Cost | 0 | 0 |
19 | Adj Local | 0 | 1 |
29 | Adj Corp | 0 | 2 |
12 | 10-YTD | 0 | 1 |
22 | 20-YTD | 0 | 2 |
16 | 10-EO | 1 | 1 |
The fixed asset was later sold on 20231231 for 24000.
Program | FAM function | Book of account | Voucher type |
---|---|---|---|
(CRS406) | FA30 | P10 | 1-Loc |
(CRS406) | FA50 | F50 | 0-Common |
(CRS405) | FA51 | F51 | 0-Common |
(GLS085) | FA50 | P10 | 1-Local |
(GLS085) | FA50 | P20 | 2-Corporate |
FA transaction | Period | Ser | Vouch no | Name |
---|---|---|---|---|
FA500000050 | 202312 | F51 | 512043 | FA51 |
FA500000050 | 202312 | P10 | 231038 | FA50L1 |
FA500000050 | 202312 | P10 | 231038 | FA50L1 |
FA500000050 | 202312 | P10 | 231038 | FA50L1 |
FA500000050 | 202312 | P10 | 231038 | FA50L1 |
FA500000050 | 202409 | P20 | 222038 | FA50C1 |
FA500000050 | 202409 | P20 | 222038 | FA50C1 |
FA500000050 | 202409 | P20 | 222038 | FA50C1 |
FA500000050 | 202312 | F50 | 50136 | FA50 |
(Continuation of Table 2)
Vtp | Name | Rcd | Voucher type |
---|---|---|---|
10 | Total Acq Cost | 0 | 0 |
12 | 10-YTD | 0 | 1 |
16 | 10-EO | 1 | 1 |
14 | 10-Gain | 0 | 1 |
19 | Adj Local | 0 | 1 |
22 | 20-YTD | 0 | 2 |
24 | 20-Gain | 0 | 2 |
29 | Adj Corp | 0 | 2 |
50 | Sale | 0 | 0 |
FHSEQ7 | FHFATR | FHVONO | FHAIT1 | FHAIT2 |
---|---|---|---|---|
20230927000000650 | FA500000050 | 512043 | P21541 | P1020 |
20230927000000700 | FA500000050 | 231038 | P28110 | P1020 |
20230927000000750 | FA500000050 | 231038 | P28110 | 10 |
20230927000000800 | FA500000050 | 231038 | P77521 | P1020 |
20230927000000850 | FA500000050 | 231038 | P21541 | P1020 |
20230927000000900 | FA500000050 | 222038 | P28120 | P1020 |
20230927000000950 | FA500000050 | 222038 | P77521 | P1020 |
20230927000001000 | FA500000050 | 222038 | P21541 | P1020 |
20230927000001050 | FA500000050 | 50136 | P41300 |
(Continuation of Table 3)
FHAIT7 | FHVSER | FHVPER | FHFAVA | FHVOTP | FHALDG | FHACDT |
---|---|---|---|---|---|---|
FA70550 | F51 | 202312 | -13000 | 0 | 0 | 20231231 |
FA50500 | P10 | 202312 | -562.5 | 1 | 1 | 20231231 |
FA50520 | P10 | 202312 | -100 | 1 | 1 | 20231231 |
FA50540 | P10 | 202312 | 10662.5 | 1 | 1 | 20231231 |
FA70550 | P10 | 202312 | -1000 | 1 | 1 | 20231231 |
FA50500 | P20 | 202409 | -604.15 | 2 | 2 | 20231231 |
FA50540 | P20 | 202409 | 9604.15 | 2 | 2 | 20231231 |
FAFA70550 | P20 | 202409 | -2000 | 2 | 2 | 20231231 |
FA50120 | F50 | 202312 | 24000 | 0 | 0 | 20231231 |
EGJRNO | EGJSNO | EGVONO | EGFEID | EGACAM |
---|---|---|---|---|
230415 | 1 | 50136 | FA50 | 26400 |
230415 | 2 | 50136 | FA50 | -24000 |
230415 | 3 | 50136 | FA50 | -2400 |
230415 | 4 | 512043 | FA50 | -13000 |
230415 | 5 | 512043 | FA50 | 13000 |
230415 | 6 | 231038 | FA50 | 562.5 |
230415 | 7 | 231038 | FA50 | 100 |
230415 | 8 | 231038 | FA50 | -10662.5 |
230415 | 9 | 231038 | FA50 | 10000 |
230415 | 10 | 231038 | FA50 | -1000 |
230415 | 11 | 231038 | FA50 | 1000 |
230415 | 12 | 222038 | FA50 | 604.15 |
230415 | 13 | 222038 | FA50 | -9604.15 |
230415 | 14 | 222038 | FA50 | 9000 |
230415 | 15 | 222038 | FA50 | -2000 |
230415 | 16 | 222038 | FA50 | 2000 |