How to Import Vehicle Depreciations

Modified on Sat, 14 Jun at 9:15 AM

The vehicle depreciation import process allows you to efficiently apply bulk depreciation adjustments to vehicle stock values in your system. This is especially useful for month-end or year-end accounting, where multiple vehicles need to be written down in line with financial reporting standards.

Using the import functionality within the Vehicle Admin Toolkit reduces manual data entry, minimises the risk of errors, and ensures consistency when applying write-down values across multiple assets.

Accessing the Import Tool

To import vehicle depreciations, navigate to:

Vehicle Admin Toolkit > Import/Export > Depreciation Report

This section provides access to the CSV import function specifically designed for depreciation updates.

Import Template Requirements

An import template (CSV format) is required. This must follow a strict column header structure to be accepted by the system. Do not rename, rearrange, or delete any of the columns. The columns must be named exactly as shown below:

Header	Description
Stock No	Full stock number, including branch (e.g. `5467.1`)
Date	Depreciation date, formatted as `DD/MM/YYYY` (e.g. `30/06/2025`)
Value	The value amount to write down (enter a positive figure only)
Nominal Code	The nominal ledger code for depreciation. If left blank, the system will use the default nominal code configured in your settings.

Important Notes

File Format: Save your import file as .csv (Comma Separated Values).
Date Validation: Dates must use the UK format DD/MM/YYYY to avoid errors.
Value Direction: Only positive values should be used. The system will treat them as write-down amounts.
Nominal Codes: Check your default nominal code settings if you're unsure whether to populate the field.

Common Use Cases

Periodic depreciation adjustments (monthly, quarterly, annual).
End-of-life vehicle write-downs.

Attachments (1)

csv

DEPN Import.csv
60 Bytes