Items table

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.

Columns

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.

• Group
  If a value is present it means that the row is a group.
  Items and groups values are added up in this row.
• Id
  The Item Id
• Description
  The item description.
• In Group
  The group the row belongs to. This must be a value present in the Group column.
• Account
  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.