Import-Asset Master List: Difference between revisions

Revision as of 02:01, 20 September 2023

Menu: File | Import | Excel Files...

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.

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.

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)

@@ Line 42: / Line 42: @@
 ! Column !! Length !! Remark
 |-
-| Code || 20 || Eg. Motor Vehicle (Asset Group Code : FA-MV)
+| Code || 20 || Eg. Furniture)
 |-
-| Description || 160  || Example
+| Description || 160  || Eg. Furniture & Fittings
 |-
-| DeprMethod || 1 (Integer)   || Example
+| DeprMethod || 1 (Integer)   || 1 : Straight Line Method
 |-
-| AssetAcc || 10 || Example
+| AssetAcc || 10 ||  Eg. Furniture & Fittings under Non-Current Assets (B/S)
 |-
-| AccumDeprAcc || 10 || Example
+| AccumDeprAcc || 10 || Eg. Accumulated Depreciation - Furniture & Fittings under Non-Current Assets (B/S)
 |-
-| DeprAcc || 10 || Example
+| DeprAcc || 10 || Eg. Depreciation account under Expenses (P&L)
 |-
-| DisposalGainAcc || 10 || Example
+| DisposalGainAcc || 10 || Eg. Disposal Gain account under Other Income / Expenses (P&L)
 |-
-| DisposalLossAcc || 10 || Example
+| DisposalLossAcc || 10 || Eg. Disposal Loss account under Expenses (P&L)
 |}