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
Download the Asset Master Template
| 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 |
NOTE: DO NOT rename the sheet name.
1. FA.GROUP.OPF (Maintain Asset Group)
| Column | Length | Remark |
|---|---|---|
| Code | 20 | Eg. Motor Vehicle (Asset Group Code : FA-MV) |
| Description | 160 | Example |
| DeprMethod | 1 (Integer) | Example |
| AssetAcc | 10 | Example |
| AccumDeprAcc | 10 | Example |
| DeprAcc | 10 | Example |
| DisposalGainAcc | 10 | Example |
| DisposalLossAcc | 10 | Example |