In this chapter, we will look at a specific example of importing fixed assets from Excel. For general principles of Excel imports, we recommend reading the first chapter - Introduction. Excel imports are available from the Business edition and above.
The Excel import for fixed assets can be found at Tools -> Import -> Import from Excel -> Fixed Assets.
Tip: If you already have existing invoices in Flexi that are similar to the one you intend to import, you can use the exported Excel file of an existing invoice as a template.
Now let's proceed to importing a specific fixed asset. We will be importing the following file: majetek_vzor.xlsx
Since the Excel file contains column headers, check the option "Ignore first row (column headers)" when selecting columns.
Warning: The order of columns selected for import must exactly match the order of columns in the Excel file.
Type - The type of the given asset. References the asset type register (enter the code of the type).
Inv. No. - The inventory number of the given asset (code/abbreviation).
Name - The name of the asset. Text string (max. 255 characters).
Category - The category of the given asset. A special value must be provided.
Possible values:
Tangible long-term - druhMaj.hmDl
Intangible long-term - druhMaj.nehmDl
Minor - druhMaj.drobny
Non-depreciable (record only) - druhMaj.neodepis
Classified - Date of classification. Enter in the format DD.MM.YYYY (e.g. 01.01.2018).
Disposed - Date of disposal. Enter in the format DD.MM.YYYY (e.g. 01.01.2018).
Price - The price of the given asset. Decimal number (max. 15 digits). Minimum value 0.0.
Deprec. method - The depreciation method for the given asset. Special value.
Possible values:
100 % - zpusobOdp.zar100
50 % / 50 % - zpusobOdp.zar5050
% Annually - zpusobOdp.rocne
Straight-line - typOdp.rovn
Accelerated - typOdp.zrych
Monthly - typOdp.mesic
Deprec. group - The depreciation group of the given asset. References the Fixed Assets -> Depreciation Groups register. Enter its code.
Tax deprec. start - The start date of tax depreciation. Enter in the format DD.MM.YYYY (e.g. 01.01.2018).
Accounting deprec.? - Does the given asset have accounting depreciation? Special value.Possible values:
No - nahrUcet.ne
Yes - nahrUcet.aPocMes
Accounting deprec. start - The start date of accounting depreciation. Enter in the format DD.MM.YYYY (e.g. 01.01.2018).
Accounting deprec. period - The accounting depreciation period. Decimal number (e.g. 36).
Supplier - The supplier of the given asset. References the code/abbreviation of the relevant record in the company address book.
Purchased - The purchase date of the given asset. Enter in the format DD.MM.YYYY (e.g. 01.01.2018).
Tax residual value - Tax residual balance. Decimal number (max. 15 digits). Minimum value 0.0.
Accounting residual value - Accounting residual balance. Decimal number (max. 15 digits). Minimum value 0.0.
Primary account - The primary account of the given asset. References the Chart of Accounts. Enter the number of the relevant account.
Classification offset account - The offset account for classifying the given asset. References the Chart of Accounts. Enter the number of the relevant account.
Depreciation account - The depreciation account of the given asset. References the Chart of Accounts. Enter the number of the relevant account.
Accumulated depreciation account - The accumulated depreciation account of the given asset. References the Chart of Accounts. Enter the number of the relevant account.
Cost center - The cost center of the given asset. References the cost center register. Enter the code of the relevant cost center.
All properties of the fixed assets register can be found at:https://demo.flexibee.eu/c/demo/majetek/properties
After selecting the relevant columns, click the "Ok" button and a table will appear showing the data types and properties of the selected columns.
After clicking the "OK" button, select the file to import and confirm your consent to import the records.
If the import fails and the Excel file needs to be corrected, a window should appear displaying the specific errors, or optionally an option to send an error report to Flexi support.
If the import completes successfully, the newly imported assets will appear in the fixed assets register.