Import-Asset Master List: Difference between revisions

Latest revision as of 03:32, 29 September 2023

Preparation-Asset Master Import Excel 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)

FA.GROUP.OPF
Column	Length	Note
Code	20	Asset Group Code, eg. Furniture)
Description	160	Asset Group Description, eg. Furniture & Fittings
DeprMethod	1 (Integer)	Depreciation Method, eg. 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

2. FA.ITEM.OPF (Maintain Asset Item)

FA.ITEM.OPF
Column	Length	Note
Code	20	Asset Code, eg. FF-0001
Description	160	Asset Description, eg. Chairs, Table
Asset Group	20	Asset Group, eg. Furniture
Agent	10	Assigned an agent if any
Area	10	Assigne an area if any
AcquireDate	Date	Purchase date
Cost	Currency	Purchase cost
UsefulLife	Float	Useful life in year, eg. 5 years, 3.3 years
DeprFrequency	1 (Integer)	1 : Monthly 2 : Quarterly 3 : Half Yearly 4 : Yearly
Residual	Float	Resellable value

Example
Code	Description	Asset Group	Agent	Area	AcquireDate	Cost	UsefulLife	DeprFrequency	Residual
FF-001	Chairs	Furniture	----	KL	13/10/2022	12,000.00	10	1	100.00
FF-002	Meeting Table	Furniture	----	KL	23/01/20021	15,000.00	10	2	0.01
MV-001	TOYOTA VIOS 1.5 / RED	MV	YUKI	SEL	17/03/2020	88,000.00	5	4	30,000.00

3. FA.ITEM.OPF.DeprSche (Maintain Asset item-Depreciation Schedule)

FA.ITEM.OPF.DeprSche
Column	Length	Note
Code	20	Asset Code, eg. FF-0001
ScheDate	Date	Schedule depreciation posting date
Description	160	Depreciation description
Amount	Currency	Depreciation amount base on the depreciation frequency

Depreciation Frequency

Monthly
No of Row	Useful life X 12 months 5 years x 12 months	60
Amount	(Cost - Residual)/No of Rows (88,000 - 30,000) / 60	966.67

Quarterly
No of Row	Useful life X 4 Quarters 5 years x 4 quarters	20
Amount	(Cost - Residual)/No of Rows (88,000 - 30,000) / 20	2,900

Half Yearly
No of Row	Useful life X 2 half/year 5 years x 2 half/year	10
Amount	(Cost - Residual)/No of Rows (88,000 - 30,000) / 10	5,800

Yearly
No of Row	Useful life (year) 5 years	5
Amount	(Cost - Residual)/No of Rows (88,000 - 30,000) / 5	11,600

Example

4.FA.ITEM.OPF.Project(Maintain Asset Item-Project)

FA.ITEM.OPF.Project
Column	Length	Note
Code	20	Asset Code, eg. FF-0001
Project	20	Project Code
Rate	Float	%

Example
Code	Project	Rate
FF-001	Project-A	30
FF-001	Project-B	70
MV-001	Project-A	100

Quick Import Asset List

Menu: File | Import | Excel Files...

1. Click Open folder button.

2. Select the Asset Template excel file...

3. 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.

@@ Line 1: / Line 1: @@
-==Quick Import Asset List==
-''Menu: File | Import | Excel Files...''
-:1. Download the [https://download.sql.com.my/customer/Asset/Asset_Master_Import.xlsx Asset Master Template]
-:2. Click '''Open folder''' button.
-::[[File:Asset Master-Import 01.jpg |400px]]
-<br />
-:3. Select the Asset Template excel file...
-<br />
-:4. Click '''Execute''' (Direct Import). Click '''Verify''' if you wish to verify the excel data before import.
-::[[File:Asset Master-Import 02.jpg |600px]]
-<br />
- '''NOTE:'''
- Asset import function available in '''SQL Account version 5.2022.948.826''' and above.
 ==Preparation-Asset Master Import Excel Template==
 Download the [https://download.sql.com.my/customer/Asset/Asset_Master_Import.xlsx Asset Master Template]
+::[[File:Asset Master-Import Template 01.jpg |800px]]
 :{| class="wikitable"
 |+ Asset Master Template (xlsx)
@@ Line 123: / Line 108: @@
 |}
-====Monthly====
+'''Depreciation Frequency'''
+::{| class="wikitable"
+|+ Monthly
+|-
+|-
+| No of Row ||  Useful life X 12 months<br>5 years  x 12 months || 60
+|-
+| Amount || (Cost - Residual)/No of Rows<br>(88,000 - 30,000) / 60 || 966.67
+|}
+::{| class="wikitable"
+|+ Quarterly
+|-
+|-
+| No of Row ||  Useful life X 4 Quarters<br>5 years  x 4 quarters || 20
+|-
+| Amount || (Cost - Residual)/No of Rows<br>(88,000 - 30,000) / 20  || 2,900
+|}
+::{| class="wikitable"
+|+ Half Yearly
+|-
+|-
+| No of Row || Useful life X 2 half/year<br>5 years x 2 half/year || 10
+|-
+| Amount || (Cost - Residual)/No of Rows<br>(88,000 - 30,000) / 10  || 5,800
+|}
+::{| class="wikitable"
+|+ Yearly
+|-
+|-
+| No of Row || Useful life (year) <br>5 years || 5
+|-
+| Amount || (Cost - Residual)/No of Rows<br>(88,000 - 30,000) / 5  || 11,600
+|}
+'''Example'''
+::[[File:Asset Master-Import Template 02.jpg |800px]]
+===4.FA.ITEM.OPF.Project(Maintain Asset Item-Project)===
 {| class="wikitable"
-! Field Name !! Data
+|+ FA.ITEM.OPF.Project
+|-
+! Column !! Length !! Note
 |-
-| Asset Code || MV-001
+| Code || 20 || Asset Code, eg. FF-0001
 |-
-| Asset Description || '''TOYOTA VIOS 1.5 / RED'''
+| Project || 20 || Project Code
 |-
-| DeprFrequency || 1 : Monthly
+| Rate || Float || %
+|}
+{| class="wikitable"
+|+ Example
 |-
-| Cost || 88,000.00
+! Code !! Project !! Rate
 |-
-| Acquire Date || 17/03/2020
+| FF-001 || Project-A || 30
 |-
-| UsefuiLife || 5 years
+| FF-001 || Project-B || 70
 |-
-| Residual || 30,000.00
+| MV-001 || Project-A || 100
 |}
- Workout:
+==Quick Import Asset List==
- Excel row = 5 years x 12 months = '''60 Rows'''
+''Menu: File | Import | Excel Files...''
- Monthly Depreciation = (88,000 - 30,000) / 5 years = '''11,600'''
+:1. Click '''Open folder''' button.
+::[[File:Asset Master-Import 01.jpg |400px]]
+<br />
+:2. Select the Asset Template excel file...
+<br />
+:3. Click '''Execute''' (Direct Import). Click '''Verify''' if you wish to verify the excel data before import.
+::[[File:Asset Master-Import 02.jpg |600px]]
+<br />
+ '''NOTE:'''
+ Asset import function available in '''SQL Account version 5.2022.948.826''' and above.
 ==See also==