Skip to main content

FAQ

How to process Asset Opening and tally with the GL Maintain Opening Balance​

Process Opening Depreciation​

Menu: Asset | Process Depreciation...

You are allowed to process Asset Opening Depreciation BEFORE System Conversion Date.

asset-depr

Tips:

A - FIRST acquire date of the asset B - System Conversion Date -1 day

I have posted the depreciation until December 2021. How do I record my new asset?​

Method 1 : Use the Last Asset Net Book Value from Balance Sheet​

Maintain the Asset Item as below:

asset-item

  1. Key in the Cost as Net Book Value (as at 31/12/2021).
  2. Acquire Date, eg. 01/01/2022
  3. Useful life = Balance of useful life to be depreciate
  4. Start Process Depreciation from 01/01/2022

Method 2: Follow Original Cost and Acquire Date​

Maintain the Asset as below :

asset-item1

  1. Key in the Cost as Original Cost

  2. Acquire Date set as Original Purchase Date

  3. Useful life = Full useful life

  4. Process Depreciation until 31/12/2021.

  5. Tick Cancelled to the Journal posted from Step 4 je-cancellled

If the depreciation value differs from my previous Journal, can I edit the depreciation value calculated in Maintain Asset Item?​

Yes, you can change the depreciation value in Maintain Asset Item (Depreciation Schedule).

asset-amount

depr-value

Can the amortization of Intangible Assets such as licenses, be managed in the Asset Module?​

Yes, it can. Maintain it as you would a Tangible Asset (Fixed Asset).

For Intangible Asset (eg. goodwill, license), the amortization calculation uses the straight line method , which can be selected in the Asset Group. The calculation involves subtracting the asset's anticipated salvage or book value from its cost and dividing the result by the total number of years it will be used.

Can I import the asset list using Excel instead of manually key-in?​

Yes, you can. The asset import function is available in SQL Account version 5.2022.948.826

Refer to Import-Asset Master List

How do I handle additional cost for the Fixed Asset?​

Create new asset code to handle additional cost, eg.:

Asset CodeDescriptionRemark
MV-0001TOYOTA VIOS - BZZ 999Initial Purchase
MV-0001ATOYOTA VIOS - BZZ 999Additional Cost
info

Do not mix the depreciation value of the original asset and the additional cost.

Quick Steps​

  1. Copy the existing asset code.

    copy-asset

  2. Create new asset.

  3. Click on More | Paste Asset Item.

    paste-asset

  4. Change the asset code by inserting any characters to differentiate it

    • Acquire date = Date the additional cost was incurred.
    • Cost = Additional Cost

    depr-rate

Should the cost in Maintain Asset Item be key-in in local currency or the original currency (eg. purchase in USD)?​

The cost should be key-in as the Local value. The depreciation value will then be calculated and posted in the local currency.