Import-Asset Master List: Difference between revisions

From eStream Software
Line 56: Line 56:
|-
|-
| DisposalLossAcc || 10 || Eg. Disposal Loss account under Expenses (P&L)
| DisposalLossAcc || 10 || Eg. Disposal Loss account under Expenses (P&L)
|}
Example :
{| class="wikitable"
|+
|-
! 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
|}
|}



Revision as of 02:07, 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 Remark
Code 20 Eg. Furniture)
Description 160 Eg. Furniture & Fittings
DeprMethod 1 (Integer) 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

See also