Asset statement

Disclaimer

All screenshots in the article were taken in the Dutch version of Yuki.

Within Yuki, an asset statement is available that summarises all fixed assets. In this asset statement, it is possible to see what the depreciation on your fixed assets should be.

If the assets were acquired before the start date of the administration in Yuki, a detailed asset statement needs to be entered into Yuki, this can be done via an opening balance sheet entry or via the historical/interim import.

For a detailed description, see article Asset statement and opening balance sheet.

From the asset statement, a user with the 'Back office' role in the domain or the 'Management', 'Financial administration' or 'External accountant' role can':

• view the depreciation of an asset account
• export the asset statement as a (detailed) PDF file
• export the asset statement as a CSV file
• export an asset account as a PDF file.

From the asset statement, a user with the 'Back office' role in the domain or the 'External accountant' role can':

• define asset group settings
  (see article Define and/or change asset group settings)
• define and/or change asset settings
  (see article Define and/or change asset settings)
• create depreciations for all asset accounts at once
  (see article Create depreciation at once for all asset accounts)
• create depreciations for a specific asset account
  (see article Create depreciation for specific asset account)
• record an asset as sold/traded-in
  (see article Post asset sale/trade-in)
• record an asset as outage/lost
  (see article Post asset failure/loss).

ATTENTION!

Before recording depreciation, a number of settings need to be defined and/or checked.

Hover your mouse over the Financials icon in the navigation bar, then click on Assets.

TIP!

You can also open the asset statement from an asset account.

The following screen is opened:

The Create depreciation entries button is only available to a user with the 'Back office' role in the domain or the 'External accountant' role

If you select a specific period at the top of your screen, you will see the status of the depreciation per asset account:

• Not depreciated: for the selected period, no depreciation has yet been recorded.
• Partially depreciated: depreciation has already been recorded for the selected period, but not yet for the entire period. You will see the date until which the depreciation has been recorded in the 'Until' column.
• Fully depreciated: for the selected period, depreciation as of date is complete.

Yuki looks at the date of recording the depreciation.

View asset account depreciation

Open an asset account by clicking on the name of the respective asset account. The following screen is opened:

The asset statement considers each entry in the fixed asset account as a separate asset. So this could be an invoice or an entry on an opening balance sheet.

ATTENTION!

When not all required settings of an asset are defined, the asset will not be approved by Yuki. In this case, the icon below appears above the asset in question.

For a detailed description, see article Define and/or change asset settings.

Export asset statement or asset account as PDF file

In Yuki, it is possible to export the asset statement or an asset account as a PDF file. If required, the PDF file can be printed directly.

ATTENTION!

If asset group settings are missing, it is not possible to export the asset statement or an asset account as a PDF file.

For a detailed description see the article Export asset statement or asset account as PDF file.

Export asset statement as a CSV file

It is possible to export the asset statement as a CSV file by clicking on the Export as... button.

ATTENTION!

When asset group settings are missing, it is not possible to download the asset statement as a CSV file.

The file 'yuki_assetstatement.csv' contains the following columns:

• Code grootboekrekening (General ledger account code)
• Omschrijving grootboekrekening (General ledger account description)
• Omschrijving activum (Description of asset)
• Referentie (Reference)
• Aanschafdatum (Purchase date)
• Startdatum afschrijving (Start date of depreciation)
• Afschrijvingsmethode (Depreciation method)
• Afschrijving % (Depreciation %)
• Aantal afschrijvingsjaren (Number of depreciation years)
• Restwaarde % (Residual value %)
• Restwaarde € (Residual value €)
• Aankoopbedrag (Purchase amount)
• Nieuwe investeringen (New investments)
• Desinvesteringen (Divestments)
• Totaal investering (Total investment)
• Vorige afschrijvingen (Previous depreciations)
• Afschrijvingen dit jaar (Depreciation this year)
• Terugname afschrijvingen (Write-back of depreciation)
• Totaal afschrijvingen (Total depreciation)
• Datum verkoop of uitval (Date of sale or failure)
• Verkoopprijs (Selling price)
• Resultaat verkoop of uitval (Result of sale or failure)
• Boekwaarde begin boekjaar (Net book value at beginning of financial year)
• Boekwaarde einde boekjaar (Net book value at end of financial year).