PANTHEON™ Help

 Toc
 PANTHEON Help - Welcome
[Collapse]PANTHEON
 [Collapse]Guides for PANTHEON
  [Collapse]Guide for PANTHEON
   [Expand]Settings
   [Expand]Orders
   [Expand]Goods
   [Expand]Manufacturing
   [Expand]POS
   [Expand]Service
   [Collapse]Financials
    [Expand]Accounting Basics
    [Expand]Posting
    [Expand]Automatic Posting
    [Expand]Accounting Dashboard
    [Expand]Overview
    [Expand]Close
    [Expand]Accruals and Deferrals
    [Expand]Credits and Leases
    [Expand]Reports
    [Expand]Special Reports
     Consolidated Financials Statements
    [Collapse]Fixed Assets
     [Collapse]Fixed Assets Register
      [Collapse]Import/Export Data
       [Expand]Import of Fixed Assets from Excel file
        Export to Excel
      [Expand]Wizards in Fixed Assets Register
      [Expand]Fixed Assets - Header
      [Expand]Fixed Assets - Accounting
      [Expand]Fixed Assets - Value
      [Expand]Fixed Assets - Movement
       Tax Depreciation
       Fixed Assets - Notes
       Fixed Assets - Regular Inspections
       Fixed -assets - Documentation
       Fixed Assets - Posts
       Fixed Asset Structure
       Resources
       Loan/Lease
       Custom Fields
       From FA in Acq.
       Links
     [Expand]Settings and Fixed Asset Registers
     [Expand]Register - Fixed Assets in Acquisition
     [Expand]Small Tools
     [Expand]Depreciation Calculation
     [Expand]Inventory Count
     [Expand]Error Messages Occurring in Fixed Assets
      Fixed Asset Card
    [Expand]Transactions
    [Expand]Debt Collection
    [Expand]Reminders
    [Expand]Year-end
    [Expand]Interest
    [Expand]Cash
    [Expand]Archive
     ZEUS Planning
   [Expand]Personnel
   [Expand]Analytics
   [Expand]Desktop
   [Expand]Help
   [Expand]Messages and Warnings
   [Expand]Additional programs
   [Expand]Old products
  [Expand]Guide for PANTHEON Retail
  [Expand]Guide for PANTHEON Vet
  [Expand]Guide for PANTHEON Farming
 [Collapse]User Manuals for PANTHEON
  [Expand]User Manual for PANTHEON
  [Expand]User Manual for PANTHEON Retail
  [Expand]User manual for PANTHEON Vet
  [Expand]User Manual for PANTHEON Farming
[Collapse]PANTHEON Web
 [Collapse]Guides for PANTHEON Web
  [Expand]Guide for PANTHEON Web Light
  [Expand]Guide for PANTHEON Web Terminal
  [Expand]Guide for PANTHEON Web Legal
  [Expand]Old products Archive
 [Collapse]User Manuals for PANTHEON Web
  [Expand]Getting started PANTHEON Web
  [Expand]User Manual for PANTHEON Web Light
  [Expand]User Manual for PANTHEON Web Terminal
  [Expand]User Manual for PANTHEON Web Legal
  [Expand]Old products Archive
[Collapse]PANTHEON Granules
 [Collapse]Guides for PANTHEON Granules
  [Expand]Personnel Granule
  [Expand]Travel Orders Granule
  [Expand]Documents and Tasks Granule
  [Expand]Dashboard Granule
  [Expand]B2B Orders Granule
  [Expand]Field Service Granule
  [Expand]Fixed Assets Inventory Granule
  [Expand]Warehouse Inventory Granule
 [Collapse]User Manuals for PANTHEON Granules
  [Expand]Getting started
  [Expand]Personnel Granule
  [Expand]Travel Orders Granule
  [Expand]Documents and Tasks Granule
  [Expand]B2B Orders Granule
  [Expand]Dashboard Granule
  [Expand]Field Service Granule
  [Expand]Fixed Assets Inventory Granule
  [Expand]Warehouse Inventory Granule
  [Expand]Archive
[Expand]User Site

Load Time: 375.0019 ms
"
   1002434 | 209301 | 343669 | Updated
Label

Import of Fixed Assets from Excel file

Import of Fixed Assets from Excel File

010381.gif010411.gif010382.gif010383.gif

 

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.

 

Related videos:

  FINANCIALS - Import/Export data- Export to Excel

 

Related topics:

  Import/Export Data

  Export to Excel

 


 

Rate this topic
Was this topic usefull?
Comments
Comment will also bo visible in forum!