Import-Asset Master List: Difference between revisions

From eStream Software
 
(55 intermediate revisions by the same user not shown)
Line 1: Line 1:
==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)
|-
! 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)===
:{| class="wikitable"
|+ 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)
|}
{| class="wikitable"
|+ 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)===
{| class="wikitable"
|+ 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<br>2 : Quarterly<br>3 : Half Yearly<br>4 : Yearly
|-
| Residual || Float || Resellable value
|}
{| class="wikitable"
|+ 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)===
{| class="wikitable"
|+ 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'''
::{| 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"
|+ FA.ITEM.OPF.Project
|-
! Column !! Length !! Note
|-
| Code || 20 || Asset Code, eg. FF-0001
|-
| Project || 20 || Project Code
|-
| Rate || Float || %
|}
{| class="wikitable"
|+ Example
|-
! Code !! Project !! Rate
|-
| FF-001 || Project-A || 30
|-
| FF-001 || Project-B || 70
|-
| MV-001 || Project-A || 100
|}
==Quick Import Asset List==
==Quick Import Asset List==
''Menu: File | Import | Excel Files...''
''Menu: File | Import | Excel Files...''
:1. Download the [https://download.sql.com.my/customer/Asset/Asset_Master_Import.xlsx Asset Master Template]
:1. Click '''Open folder''' button.
 
:2. Click '''Open folder''' button.
::[[File:Asset Master-Import 01.jpg |400px]]
::[[File:Asset Master-Import 01.jpg |400px]]
<br />
<br />
:3. Select the Asset Template excel file...
: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]]
::[[File:Asset Master-Import 02.jpg |600px]]
<br />
<br />


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


==See also==
==See also==

Latest revision as of 03:32, 29 September 2023

Preparation-Asset Master Import Excel Template

Download the Asset Master Template

Asset Master-Import Template 01.jpg
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

Asset Master-Import Template 02.jpg

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.
Asset Master-Import 01.jpg


2. Select the Asset Template excel file...


3. Click Execute (Direct Import). Click Verify if you wish to verify the excel data before import.
Asset Master-Import 02.jpg


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

See also

Retrieved from "https://wiki.sql.com.my/index.php?title=Import-Asset_Master_List&oldid=12743"
Last modified
This page was last edited on 29 September 2023, at 03:32.