Characteristics of the Fixed Assets Register

Documentation •
In this article

The Fixed Assets Register is a Banana Accounting Plus application to manage your amortisable assets quickly and easily and instantly know their initial value, history, and year-end amortisation.

It is a very flexible, intuitive and powerful tool for calculations.

  • You work in tables like with Excel, very intuitive and with all values always visible and updated.
  • You have functionalities that automate the calculations, obtaining constantly updated values and balances:
    • Initial purchase value.
    • Book value.
    • Quota and percentage of amortisation.
    • Columns for the date of purchase and the duration of the warranty.
    • Journal
    • Items Report.
  • Instant search for amortisable assets
  • In case of errors, you can modify and correct, so as to always have order and precision.
  • Application usable in any country.

Substitute for Excel tables for amortisation

The Fixed Assets register is a very precise, but also malleable tool that can be adapted perfectly to your requirements. It allows you to automate the calculation of amortisation, but also offers you the possibility to enter amortisation manually, so that, when there are special cases or exceptions, you are not obliged to change formulas and totals.

The application can be used in conjunction with other accounting programs, you are much more flexible and also save on license costs. For each period (month, quarter, semester or year) you can produce a printout of the summary of the amortisation to be recorded in your accounting program. You can export the data as well, if you wish.

Based on tables

Fixed Assets Register management focuses on three main tables, which are used in a similar way to those of Excel, but that are already fully set up and programmed with everything needed to manage your inventory in a fast and safe way. 

  • Items table
    This is the table where you set up all the assets subject to amortisation. Each item (or amortisable asset) has an identification ID, a description, a group and an account to which it belongs, the counterpart entry and all the calculation parameters for the amortisation. You can freely create groups of items, without any limits. When viewing this table, you immediately have a complete and updated view of all your amortisable assets.
  • Transactions table
    This table records all the operations that modify the historical, book or fiscal value of an asset. It is a table with automatic columns: by selecting the type of amortisation, the description of the operation is automatically entered (sale, write-down, revaluation, amortisation ...); via the selection of the article ID the description of the article is automatically inserted. When scrolling the table, you have a complete view of all the events during the year. If you realize that you have made a mistake, you can modify to always have perfect accounting. 
  • Amortisation type
    This table where amortisation codes are to be entered so that, when you buy a new asset you can decide which type of amortisation to attribute: on historical value, book value, on a specific amount, full amortisation and no amortisation. Once the codes have been established, they must not be changed to ensure consistency and correctness in the calculations. The column of codes is visible both in the Items table and in that of the Journal, so as to always be in control of which amortisation has been calculated.  
  • Transaction type
    This table defines the types of operations to be resumed in the Journal table. Each operation has an identification ID that must not be changed, so that the same description is always used in the journal table. This facilitates and speeds up the insertion of data in the Journal table.

Accounting setup

Fixed Assets Register headers and basic data set up in a single, easy-to-view dialog.

  • Company headings and address with free texts.
  • Language settings.
  • Link to extensions for customizations.
  • Password to secure your Amortisation Register file.
  • You can have multiple files in different languages.

Easy and precise management thanks to the accounting logic

Unlike Excel spreadsheets, changes in value (amortisation, new purchases, write-downs) are not entered in columns, but in a table of transactions.

  • The Items table lists the individual assets, with the date, purchase value, type and percentage of amortisation and other elements.
  • The amortisation, revaluations or write-downs for each individual asset are indicated in the Transactions table.
    • It is the history of all the changes in the value of the asset, from purchase to disposal.
    • The Create amortisation rows command calculates the amortisation based on the settings in the Items table and generates transaction rows.
    • Amortisation can be calculated monthly, quarterly, half-yearly or annually.
    • Transaction values can be entered and edited manually. You can thus easily resolve any exception or special case.
    • You can enter transactions for increases in value, special amortisation, tax value adjustments or other.
  • Amortisation operations are resumed in the accounting file via the Import into accounting command.

Each item has different values

In contrast to accounting, where only the current book value is generally kept, different values are kept for each item in the Fixed assets register.

  • Start from the initial purchase value, which is entered manually in the items table.
  • All other values ​​are calculated by the program by adding the variations entered in the transactions table.
  • For each type of variation there is a special column In the Transactions table where to enter values.
    • Increases are entered as a positive.
    • The decreases (such as amortisation) are entered as a negative.
  • For each value there is the total and the variation in the items table.
  Initial value (manually entered in the Items table)
+ Purchases. Own production of modernization- Sales
- Sales
= Purchase value of the asset (The total outlay for the purchase).
+ Revaluations (for example following inflation)
- Write downs (the historical value changes, other than amortisation which only changes the accounting value).
= Historical value (calculation basis for linear amortisation)
+ Historical value (calculation basis for linear amortisation)
- Amortisations
= Book value (basis for calculating amortisation on residual value)
+ Increase in tax value (amortisation not recognized for tax purposes)
- Decrease in tax value
= Tax value (value recognized by the tax authorities)

This way the program has all the elements to calculate amortisation automatically.

File and data saving

Item handling

Error reporting and control

Reports and prints

Data export and archiving

Other features

Added functionalities.

Extensions

Comprehensive documentation

The fixed assets register is an application included in Banana Accounting Plus. It allows easy management of your amortisable assets and quickly obtains all the values you need, as well as the automatic posting of amortisation at the end of the year.

 

Tell us how we can help you better
If the information on this page is not what you're looking for, is not clear enough, or is not up-to-date, let us know.

Share this article: Twitter | Facebook | LinkedIn | Email