Depreciable assets register

Available for now only in the Experimental version. This feature is under development.

This feature allows you to manage the depreciable assets, and, at the end of the period, automatically creates the depreciation transactions. It has the following tables:

  • Items table
    Where you list the depreciable assets and the depreciation parameters
  • Transactions table
    Where you enter the depreciation transactions, as well as purchases assessments
  • Depr. Type table
    Indicates the various depreciation types.
  • Trans. Type table
    Indicates the various transaction types


Logic of the Software

The software allows you to track the value of your Assets in your Accounting.

All depreciable assets are entered in the Items table with all the parameters required for the effective calculation of depreciation. The following values figure in the Items table program:

The program uses the following values:

  • Asset at purchase value
  • Historic value (purchase value +/- assessment of appreciation or depreciation)
  • Accounting value (historic value +/- corrections due to depreciations)
  • Fiscal value (Accounting value +/- correction of fiscal value).

Variations of value for a specific item are entered in the Transactions table:

  • A function for automatic calculation of periodical amortisation of predefined basic values, is integrated. Transaction values can be adjusted manually (as, for instance, in a varying calculation for a first accounting year).
  • Transactions can be added manually for appreciation, extraordinary amortization, adjustment of fiscal value and so on.


Items Table

Where you enter assets subject to depreciation and their groups.

This table contains the following columns; The ones marked with an asterisk (*) are protected and calculated by the program:

  • 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.
  • 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 (depreciations or reverse depreciation 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 depreciation rows are created.
  • Estimate value
    An item's probable estimated value
  • Depreciation Id Type
    The depreciation type applied to this item
    The depreciation type can also be indicated for the group.
  • Depreciation Percentage
    The depreciation percentage.
    The depreciation percentage can also be indicated for the group.
  • Depreciation amount
    A possible depreciation amount if the depreciation is not specified as a percentage.
  • Depreciation Percentage 2
    The additional depreciation percentage to be applied to this item.The depreciation type can also be indicated for the group.
  • Depreciation Months First Year
    The number of months the item needs to be depreciated in the first year.
  • Contra Account
    The account where the depreciation should be registered
    The contra account can also be indicated for the group.
  • 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.


Transactions table

This is the table where you enter the items variations. It has several columns:

  • Date
    The transaction date
  • Transaction Type Id
    The transactions type, identical to the one in the Transaction table.
  • Transaction Type Description*
    The description from the Items table is displayed.
  • Item Id
    The Item Id.
  • Items Description*
    The items description from the Items table is displayed.
  • Notes
    An additional note concerning the transaction.
  • Purchase Variation
    The item (+/-) variation compared to the purchase or sale.
  • Historical Variation
    The Item (+/-) variation compared to a item revaluation or write-down.
  • Book Variation
    The item (+/-) variation value compared to the book variation.
    This is particularly used for negative depreciations
  • Fiscal Variation
    This is the fiscal variation amount.
  • Depreciation Type Id
    The Depreciation type code as shown in the Items table.
  • Depreciation Type Description
    The depreciation code descriptions as per the Items table.
  • Depreciation Percentage
    The depreciation percentage applied.
  • Account
    The Assets account where the operation must be registered
  • Contra Account
    Contra account (for example the depreciation account) where the operation must be registered.
  • Archive Date and Archive notes
    Columns you might use if you need to archive the item.


Depreciation type table

  • Id
    The depreciation code.
    These codes are fixed and must not be modified.
    If you change the Id number the program will not operate correctly anymore.
    • 00 No depreciation. No depreciation will be created.
    • 01 Complete depreciation of the item. The item is depreciated all at once.
    • 02 Indicated amount. The depreciation is calculated, based on the entered amount.
    • 10 On the historical value. The depreciation is calculated as a percentage of the historical value.
    • 11 On the book value. The depreciation is calculated on the book value.
  • Description
    The code explanation
     

Transactions type table

  • Id
    The transaction type code
    These codes are fixed and must not be modified.
    If you change the Id number the program will not operate correctly anymore.
    • 01    Initial value. Used to enter an initial value, instead of entering the initial value in the Items table
    • 11    Purchase or production
    • 15    Sale or value reduction.
    • 21    Revaluation
    • 25    Devaluation
    • 31    Reverse depreciation
    • 35    Depreciation
    • 36    Additional depreciation
    • 41    Fiscal value increase
    • 45    Fiscal value reduction
  • Description
    The code explanation

Utilities1 menu

Create depreciation rows

It requires a date.
If you launch this command, the program automatically creates the monthly or yearly depreciation transactions based on the item parameters previously entered in the Items table.

  • If the parameters Depr. Type, Percentage, Account or Contra account for the item are not entered, but have been entered for the group the item belongs to, the software will use the group parameters to create the depreciation transactions.

Show Journal

Will display all operations with the variation of values and the cumulative value.

Show items report

Will display the variations for each item and item groups for the selected period.

Planned developments to the software

 

Transfer of accounting

Under preparation, currently unavailable.

To resume amortization in accounting.

Printing

It is planned to develop printing modules within BananaApps, that will go beyond existing available printing templates, allowing for more flexibility and tailor made solutions.

Do not hesitate to report your needs and requirements to our programmers, possibly by sending an example of the type of report  you wish to use, as an Excel table, with columns, totals, header data, and formatting. 

Different types of amortization

It is equally planned to develop modules within BananaApps for this feature, to include different types of amortization, aiming to deliver a tailor made solution to you.

Do not hesitate to report your needs and requirements to our programmers.

 

 

Help us improve the documentation

We welcome feedback on how to improve this page.

Tell us what theme needs a better explanation or how to clarify a topic.

Share this article: Twitter | Facebook | Email