Import-Asset Master List: Difference between revisions

From eStream Software
Line 124: Line 124:


====Monthly====
====Monthly====
'''MV-001 TOYOTA VIOS 1.5 / RED'''
 
{| class="wikitable"
{| class="wikitable"
! Field Name !! Data
! Field Name !! Data
|-
| Asset Code || MV-001
|-
| Asset Description || '''TOYOTA VIOS 1.5 / RED'''
|-
|-
| Cost || 88,000.00
| Cost || 88,000.00
Line 138: Line 142:


  Workout
  Workout
  Monthly Depreciation = (88,000 - 20,000) / 5 years = 11,600
  Monthly Depreciation = (88,000 - 30,000) / 5 years = 11,600


{| class="wikitable"
{| class="wikitable"

Revision as of 04:49, 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 10,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

Monthly

Field Name Data
Asset Code MV-001
Asset Description TOYOTA VIOS 1.5 / RED
Cost 88,000.00
Acquire Date 17/03/2020
UsefuiLife 5 years
Residual 30,000.00
Workout
Monthly Depreciation = (88,000 - 30,000) / 5 years = 11,600
DeprFrequency : Monthly
Code ScheDate Description Amount
MV-001 17/03/2020 (Acquire Date) Depreciation 11,600
MV-001 17/04/2020 Depreciation 11,600
MV-001 17/05/2020 Depreciation 11,600
MV-001 17/06/2020 Depreciation 11,600
MV-001 17/07/2020 Depreciation 11,600
MV-001 17/03/2020 Depreciation 11,600
MV-001 17/03/2020 (Acquire Date) Depreciation 11,600
MV-001 17/03/2020 (Acquire Date) Depreciation 11,600
MV-001 17/03/2020 (Acquire Date) Depreciation 11,600
MV-001 17/03/2020 (Acquire Date) Depreciation 11,600
MV-001 17/03/2020 (Acquire Date) Depreciation 11,600
MV-001 17/03/2020 (Acquire Date) Depreciation 11,600
MV-001 17/03/2020 (Acquire Date) Depreciation 11,600
MV-001 17/03/2020 (Acquire Date) Depreciation 11,600
MV-001 17/03/2020 (Acquire Date) Depreciation 11,600
MV-001 17/03/2020 (Acquire Date) Depreciation 11,600
MV-001 17/03/2020 (Acquire Date) Depreciation 11,600
MV-001 17/03/2020 (Acquire Date) Depreciation 11,600
MV-001 17/03/2020 (Acquire Date) Depreciation 11,600
MV-001 17/03/2020 (Acquire Date) Depreciation 11,600
MV-001 17/03/2020 (Acquire Date) Depreciation 11,600
MV-001 17/03/2020 (Acquire Date) Depreciation 11,600
MV-001 17/03/2020 (Acquire Date) Depreciation 11,600
MV-001 17/03/2020 (Acquire Date) Depreciation 11,600
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
Example Example Example Example
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