Import-Asset Master List: Difference between revisions

From eStream Software
 
(20 intermediate revisions by the same user not shown)
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==
==Preparation-Asset Master Import Excel Template==
Download the [https://download.sql.com.my/customer/Asset/Asset_Master_Import.xlsx Asset Master 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"
:{| class="wikitable"
|+ Asset Master Template (xlsx)
|+ 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"
{| 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==
==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