Import of Fixed Assets from Excel file

Import of Fixed Assets from Excel File

Function "Import from Excel File"  can be found on Import/Export button of Fixed Assets form. It enables import of Fixed assets with all detail necessary for further work, postings and evidences.

The Excel file must contain the following columns in the following order;

• Blue fields represent data in the FA (Fixed Assets)/ST (Small Tools) header,
• Red fields represent data in the position status,
• Green fields represent data in the FA/ST movement and
• Yellow fields are optional fields:
  • Inventory No.
  • Quantity
  • Name
  • Name 2
  • Acquisition Date
  • Activation Date
  • Disposal Date
  • Deactivation
  • Deprec. Category
  • Accelerated Depr. (T/F)
  • Deprec. Factor
  • Cost
  • Salvage Value
  • Supplier
  • Supplier's Invoice
  • Year of Manuf.
  • Calculation ID
  • Factory No.
  • Department (FA header
  • Cost Cenetr (FA header)
  • Person Resp.
  • Caretaker
  • Component Of
  • Group
  • Functional Status
  • Date (in position of Value panel )
  • Cost (purchase value in position of Value panel)
  • Accumulated depreciation (in position of Value panel)
  • Status
  • Location
  • Company
  • Dept.
  • Cost Center
  • Issued On
  • Expected Return Date
  • Return Date
  • Quantity
  • User
  • Acquisition Account DR
  • In Acquisition Account CR
  • Deprec. Account DR
  • Deprec. Account CR
  • Upward Reval. Acct. DR
  • Upward Reval. Acct. CR
  • Upward Reval. Acct Diff.
  • Downw. Reval. Acct. DR
  • Downw. Reval. Acct. CR
  • Downw. Reval. Acct. Diff.
  • Text Field 1
  • Text Field 2
  • Text Field 3
  • Text Field 4
  • Text Field 5
  • Text Field 6
  • Text Field 7
  • Text Field 8
  • Text Field 9
  • Text Field 10
  • Num. Field 1
  • Num. Field 2
  • Num. Field 3
  • Num. Field 4
  • Num. Field 5
  • Num. Field 6
  • Num. Field 7
  • Num. Field 8
  • Num. Field 9
  • Num. Field 10
  • Date Field 1
  • Date Field 2
  • Date Field 3
  • Date Field 4
  • Tax Deprec. Date
  • Deprec. Cost
  • Accumulated Tax Deprec.
  • Tax Deprec. Status
  • ​Date of assignment
  • ​Date of end of assignment
  • ​Assigned Quantity
  • Document

We can use template and example on sample file.