Скачать или смотреть SQL Accounting Software Fixed Asset

Timecodes
0:00 - Intro
Easy compute multiple assets’ depreciation, auto post to GL account precisely. On top of that, SQL has Asset Disposal Gain/Loss calculation too.


0:15 - Set up Fixed Asset Master File
All you need to do is create the asset group link to the GL code,
proceed to the asset item details, create all the assets, fill up code, description, assign the asset group, agent, area. insert the acquire date, cost, useful life as well as residual value. choose the depreciation frequency by yearly, monthly, half yearly or quarterly. click on save, SQL will generate all the deprecations.

0:52 - Routine Asset Depreciation Process
Go to asset | process depreciation, choose the process period for example 01/01/2021 to 31/12/2021, you can choose to post the depreciation by asset group, asset item, or even by agent or area.

In this example, I will post by asset group. All asset depreciation will be calculated with a simple click on the process button. A Journal Voucher created automatically, system will calculate all the depreciation entries by asset group. For instance, the depreciation posting total for motor vehicle, furniture, and fitting, office equipment.

1:29 - Fixed Asset Depreciation Reports
SQL also packed with comprehensive assets report. Let’s look at asset analysis, which can view by yearly, monthly, half yearly or quarterly. In this case, we will look at 5 years analysis.

All historical depreciation, year-to-date depreciation, accumulated depreciation, and net book value will be displayed for better analysis by asset group. If the assets have been sold, the system will also help you to calculate the gain or loss on asset disposal, if you wish to view detail by individual asset, you can also change the grouping to asset item & apply.

2:08 - Fixed Asset Disposal Gain/Loss Calculation
Go to asset, asset disposal, new, select the asset. System will show out all the information's including cost, accumulated depreciation, net book value, what you need to do is insert the disposal amount, choose the payment method. The disposal gain or loss will be calculated automatically, and the GL Journal entry will also be auto-taken up too.

Let's go through the asset process again. This time, I'll show you posting by asset item. Click on process. Let's take a look at the journal. The system will break down by each individual asset. A disposal journal will also be taken into account.

3:00 - Opening Balance for Fixed Asset
What if I have acquired some assets before using SQL? Let's say you start using SQL on 01/01/2018, acquire 1 asset on 01/01/2017, what you need to do is as follows:

1) insert the opening balance
2) insert the acquire date, cost, and generate
3) process asset from 01/01/2017 to 31/12/2017

Journal posting will not be required for past depreciation process

In addition, you can check the asset report to see if the opening balance matches the asset cost and depreciation for the past year.

Contact your services agent today for fixed assets trial.

#sqlaccount
#assetsoftware