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
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
NOTE: DO NOT rename the sheet name.
1. FA.GROUP.OPF (Maintain Asset Group)
- Classify your asset base on types.
FA.GROUP.OPF Column Length Remark Code 20 Eg. Furniture) Description 160 Eg. Furniture & Fittings DeprMethod 1 (Integer) 1 : Straight Line Method AssetAcc 10 Eg. Furniture & Fittings under Non-Current Assets (B/S) AccumDeprAcc 10 Eg. Accumulated Depreciation - Furniture & Fittings under Non-Current Assets (B/S) DeprAcc 10 Eg. Depreciation account under Expenses (P&L) DisposalGainAcc 10 Eg. Disposal Gain account under Other Income / Expenses (P&L) DisposalLossAcc 10 Eg. Disposal Loss account under Expenses (P&L)
Example :
| Code | Description | DeprMethod | AssetAcc | AccumDeprAcc | DeprAcc | DisposalGainAcc | DisposalLossAcc |
|---|---|---|---|---|---|---|---|
| Furniture | Furniture & Fittings | 1 | 200-200 | 200-205 | 923-000 | 530-999 | 980-999 |
| MV | Motor Vehicle | 1 | 200-400 | 200-405 | 923-000 | 530-999 | 980-999 |