Import-Asset Master List: Difference between revisions

From eStream Software
Line 121: Line 121:
|-
|-
| Amount || Currency || Depreciation amount base on the depreciation frequency
| Amount || Currency || Depreciation amount base on the depreciation frequency
|}
Lets assume the asset are
{| class="wikitable"
|+ TOYOTA VIOS 1.5 / RED
|-
! Field !! Header text
|-
| Cost || 88,000.00
|-
| Acquire Date ||
|-
| UsefuiLife || 5 years
|-
| Residual || Example
|}
{| class="wikitable"
|+ Depreciation Frequency : Monthly
|-
! Header text !! Header text !! Header text !! Header text
|-
| Example || Example || Example || Example
|-
| Example || Example || Example || Example
|-
| Example || Example || Example || Example
|-
| Example || Example || Example || Example
|-
| Example || Example || Example || Example
|-
| Example || Example || Example || Example
|-
| Example || Example || Example || Example
|-
| Example || Example || Example || Example
|-
| Example || Example || Example || Example
|-
| Example || Example || Example || Example
|-
| Example || Example || Example || Example
|-
| Example || Example || Example || Example
|-
| Example || Example || Example || Example
|-
| Example || Example || Example || Example
|-
| Example || Example || Example || Example
|-
| Example || Example || Example || Example
|-
| Example || Example || Example || Example
|-
| Example || Example || Example || Example
|-
| Example || Example || Example || Example
|-
| Example || Example || Example || Example
|-
| Example || Example || Example || Example
|-
| Example || Example || Example || Example
|-
| Example || Example || Example || Example
|-
| Example || Example || Example || Example
|-
| Example || Example || Example || Example
|-
| Example || Example || Example || Example
|-
| Example || Example || Example || Example
|-
| Example || Example || Example || Example
|-
| Example || Example || Example || Example
|-
| Example || Example || Example || Example
|-
| Example || Example || Example || Example
|-
| Example || Example || Example || Example
|-
| Example || Example || Example || Example
|-
| Example || Example || Example || Example
|-
| Example || Example || Example || Example
|-
| Example || Example || Example || Example
|-
| Example || Example || Example || Example
|-
| Example || Example || Example || Example
|-
| Example || Example || Example || Example
|-
| Example || Example || Example || Example
|-
| Example || Example || Example || Example
|-
| Example || Example || Example || Example
|-
| Example || Example || Example || Example
|-
| Example || Example || Example || Example
|-
| Example || Example || Example || Example
|-
| Example || Example || Example || Example
|-
| Example || Example || Example || Example
|-
| Example || Example || Example || Example
|-
| Example || Example || Example || Example
|-
| Example || Example || Example || Example
|-
| Example || Example || Example || Example
|-
| Example || Example || Example || Example
|-
| Example || Example || Example || Example
|-
| Example || Example || Example || Example
|-
| Example || Example || Example || Example
|-
| Example || Example || Example || Example
|-
| Example || Example || Example || Example
|-
| Example || Example || Example || Example
|-
| Example || Example || Example || Example
|-
| Example || Example || Example || Example
|}
|}


Revision as of 04:33, 20 September 2023

Quick Import Asset List

Menu: File | Import | Excel Files...

1. Download the Asset Master Template
2. Click Open folder button.
Asset Master-Import 01.jpg


3. Select the Asset Template excel file...


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


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)

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

Lets assume the asset are

TOYOTA VIOS 1.5 / RED
Field Header text
Cost 88,000.00
Acquire Date
UsefuiLife 5 years
Residual Example


Depreciation Frequency : Monthly
Header text Header text Header text Header text
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example

See also

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