Import-Asset Master List

Quick Import Asset List

Menu: File | Import | Excel Files...

1. Download the Asset Master Template

2. Click Open folder button.

3. Select the Asset Template excel file...

4. Click Execute (Direct Import). Click Verify if you wish to verify the excel data before import.

NOTE: 
Asset import function available in SQL Account version 5.2022.948.826 and above.

Preparation-Asset Master Import Excel Template

1. Download the Asset Master Template

Asset Master Template (xlsx)

Sheet Name	Refer to
FA.GROUP.OPF	Maintain Asset Group
FA.ITEM.OPF	Maintain Asset Item
FA.ITEM.OPF.DeprSche	Maintain Asset Item - Depreciation Schedule tab
FA.ITEM.OPF.Project	Maintain Asset Item - Project tab

See also

• Maintain Asset Group
• Maintain Asset Item
• Process Depreciation
• Open Depreciation
• Asset Disposal
• Print Yearly Depreciation
• Print Asset Disposal Listing
• Maintain Opening Balance