Allows the insertion of depreciable assets, related groups and parameters for calculating amortisation.
For the calculation of the amortisation, if the parameters Amrt. Type, Percentage, Account or Contra account are not entered for a single item, the software will use the group or subgroup parameters.
Creation of the assets's list
When you buy an asset, you must register the purchase in your accounting file and, at the same time, insert a new row in the Items table with information about the new asset.
- Each item must have an identifier and a description.
- The purchase date, the purchase value, the amortization type code and the amortization percentage are then indicated.
You can also create group row and indicate a code for the group. Groups can correspond to you accounting file's accounts. In this case, the account number can be used as a group. The group is then assigned to the articles via the In Group column.
Multiple group levels can be created.
For amortisation calculation, if the parameters (account, counterpart, type and percentage depreciation, etc.) are not specified for each article, the parameters of the sub-group or group are used.
This table contains the following columns; The ones marked with an asterisk (*) are protected and calculated by the program.
You can find more information about adding new columns in the Colums setup page.
If a value is present it means that the row is a group.
Items and groups values are added up in this row.
The Item Id
The item description.
- In Group
The group the row belongs to. This must be a value present in the Group column.
The account to which the item is being attributed in the accounting.
This account can also be a group.
- Contra Account
The account where the amortisation should be registered
The contra account can also be indicated for the group.
- Date Begin
The item purchase date (or at which the item was entered in the accounting file)
- Document Date
The date of the item purchase document, if available
- Initial value
The purchase value.
- Purchase Variation*
The total purchase value, positive or negative, indicated in the transactions.
- Purchase Value*
The initial value plus the purchase variation.
- Historical Variation*
The positive or negative value of the historical variation (revaluations or write-downs) indicated in the transactions.
- Historical Value*
The purchase value plus historical variation.
- Book variation*
The positive or negative accounting value (amortisations or inverse amortisation entries) indicated in the transactions.
- Book value*
Historical value plus book variations.
- Fiscal Variation*
The positive or negative value of the fiscal adjustments indicated in the transactions.
- Fiscal Value*
The Book Value plus the fiscal adjustments.
- Residual Value
A possible minimal residual value to be indicated.
If the residual value is equal or bigger than the book value, no more amortisation rows are created.
- Estimate value
An item's probable estimated value
- Amortisation Id Type
The amortisation type applied to this item
The amortisation type can also be indicated for the group.
- Amortisation Percentage
The amortisation percentage.
The amortisation percentage can also be indicated for the group.
- Amortisation amount
A possible amortisation amount if the amortisation is not specified as a percentage.
- Amortisation Percentage 2
The additional amortisation percentage to be applied to this item.
The "Create amortisation rows" command creates an extra amortisation row, the calculation method is the same.
The extra amortisation percentage can also be indicated for a group.
- Amortisation Months First Year
The number of months the item needs to be depreciated in the first year.
- Serial Number
The item's serial number
- Warranty Date
The warranty expiration date.
- Insurance Value
The value this item or group is insured for.
- Insurance name
The insurance company's name.
- Insurance number
The insurance policy number.
- Insurance expiration
The insurance policy's expiry date.
- Insurance cancellation
The date by which legal notice needs to be given to the insurance company if automatic renewal is not desired.
- Archive Date and Archive notes
Columns you might use if you need to archive the item.
Amortisation in the year of purchase of the asset
There are an infinite number of methods for establishing how the amortisation value for the first year is to be calculated.
The program offers these possibilities:
- It normally calculates amortisation for the whole year.
- In the Amortisation month first year (Month 1.Year) column , you can indicate for how many months the amortisation is to be calculated.
- If in the first year you desire to calculate only 50% of the normal amortisation, you should indicate 6 months.
- Amortisation percentage 2 Column
Used for an extra amortisation. An extra amortisation row is being created.
- For other situations, let the program create the amortisation row and then adjust the automatically created amortisation transaction.