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.
|
File Path
|
Path to excel file for import fixed assets data.
|
|
Open
|
Use Open button to transfer data from excel file in Pantheon grid.
|
| Transfer |
Use Transfer button to enter data in fixed assets register. |
| Register Overview |
USe Register Overview button to review prepared data and their match with register in Pantheon. |
| Fill In Missing Registers on Transfer |
Some of missing data in registers can be completed with this option marked. These registers are (subjects, chart of account, cost centers. |
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.