---
title: Depreciation Extension Package
slug: equipmenttrack/depreciation-extension-package
description: Calculate and track equipment depreciation with the Unaric Equipment Track extension package. Automate financial reporting and asset valuation directly inside Salesforce.
icon: {"faIcon":"fa-solid fa-hourglass-end"}
docTags: 
createdAt: 2024-09-06T15:34:30.719Z
---

The **Depreciation Extension Package **is an add-on for managing equipment depreciation calculations within a Salesforce-based system.

## Installation

Installation of this extension package must be done by Unaric personnel. Licensing for the Extension package is for your org on an annual basis. To use this extension you will be granted a license key and grant Unaric access to your org to install the extension package and the license key. 

We recommend controlling access to the fields and objects by using Field/Object Level Security. 

## Page Layouts 

This extension adds several fields to the **Equipment** object and adds some new objects to store the resulting depreciation records. If you need to see the **Equipment** fields, you will need to add them to **Page Layouts** or perhaps even create new page layouts if desired. 

It is recommended to create a new section on the page and place all related fields in this section. See the image below for an appropriate layout example. 

![](https://lh7-rt.googleusercontent.com/docsz/AD_4nXeUQ8MT4L2ABg2CBwbCt0JQWcTofcXW4dKRUcpQFus3J4zp32Nle9qSOqgL3FHaNld91bWxpbjI9vFeeO_D3okqaMtDX2UqvEyDr06M67saHo39oXH3YJkelxcIkWZXl5-npNsucGwS-ODGjTQ9sQbENfQ?key=vG7pEpqBPxv3ngHPQ7fCnA "Note that GL Segment 1-4 are optional fields that may assist with preparing Journal entries. They can be used to represent portions of GL records like Cost Centers, etc. You may re-label any field using the Override function in Setup. ")

### Related List 

Depreciation calculations are stored in the **Depreciation Calculation** object. This object should be added as a related list to the** Equipment** object. Use the page layout editor to add the related list and choose the fields you wish to display on the related list. Sort by **Depreciation Calculation Name** (descending) to see the most recent calculations at the top of the related list.

![](https://lh7-rt.googleusercontent.com/docsz/AD_4nXdprAd1bw5ugnGRq-hVLK6kVc0MD-isFE7nrXWHi8QqOJ2eZ364KZYsZ5m_UpNUbNPRFmLL7uahI-Harc1HnFfTq-3f7DUrn27b2g3yVbHt7UpgK_sEnzSnEHyM3yE44bvgjqTZMpwzh0AZY6v24Ll3OrAH?key=vG7pEpqBPxv3ngHPQ7fCnA "Recommended layout ")

## Companies 

Each **Equipment** record can be associated with a single **Company **record. You will need at least one **Company** record to generate and report on **Depreciation** values on a company basis.

1. Use the **App Launcher** icon and search for **Companies**.
2. Add a record as required.
3. Associate Equipment to the Company they belong to. You can use record edits or mass updates using** List Views** to update the** Company** field on** Equipment**. This data could also be loaded as an update to **Equipment** using the** Data Import Wizard**. 

## Field Reference 

- **Company:** sed to control which company owns the equipment. Generation of **Depreciation** is done independently for each **Company**. 
- **Calculate Depreciation:** Set this to *TRUE* to allow the module to calculate depreciation for this **Equipment r**ecord. 
- **Credit GL Account:** Enter a reference for the account to be credited. *This is not a lookup just a text field. *
- **Debit GL Account.** Enter a reference for the account to be debited. *This is not a lookup just a text field. *
- **GL Segment 1-4:** These 4 fields allow you to add additional information regarding the posting of **Journal Entries**. They can be used for **Cost/Profit** centers or any other qualifier on your GL codes. 
- **Original Cost:** Enter the original** Cost** of this item for** Depreciation** purposes.
- ** Salvage Value:** Enter a salvage value if desired. If the salvage value is left blank it will be set to 0. The system will depreciate the asset over its life to reach a salvage of 0. 
- **Life in Months:** Enter the life of this** Equipment** for depreciation purposes.
- **Monthly Depreciation:** This is a formula field that displays the monthly amount of depreciation for this** Equipment** record. 
- **Last Depreciation Date:** This is a roll-up summary field that shows you the last date that depreciation was calculated for this** Equipment** record. 
- **Total Depreciation:** This is a roll-up summary field that shows you the total of all depreciation calculations to date for this** Equipment** record. 
- **Current Book Value:** This is a formula field that shows you the current book value for this **Equipment** record. 
- **Remaining Life in Months:** This is a formula field that shows you the remaining life in months for this piece of equipment. 
- **Dep Calc last Message:** This can be used to assist with any issues during depreciation calculation. Any message from the last calculation is stored in this field. 

## Load Previous Depreciation Data 

In most cases, there will be previous depreciation for a piece of equipment. You can either enter a **Depreciation Calculation** record manually or load** Depreciation Calculation** records for all equipment. Create a single record that summarizes all deprecation to date and is dated prior to your first desired calculation date. 

If you click the** New** button on the** Depreciation Calculation** object, you will see the following form:

::Image[]{src="https://lh7-rt.googleusercontent.com/docsz/AD_4nXcy3_qtZf9b7fPLHAWzhaziMjLyK-OxZHmwzHQfb-31nd39ffTtuf7xzFTw9BshyDTtOtC4QuWHREr8Yu2BTID7mE4i2KabvOk3CvwnpVKbjhA8tKaLk5uHdlw3SYsT-ygM7-kgLTBiEiXHrsqZoPGq19Du?key=vG7pEpqBPxv3ngHPQ7fCnA" size="60" width="314" height="277" position="center" showCaption="false"}

- **Equipment**: This will be populated  automatically. If you are building a spreadsheet for loading you will need to export a list of Equipment and have the EQ#  in a column. 
- **Depreciation Date**: Enter a date prior to your first desired calculation date. Use the first or last day of the month as the date. Note that  date formats are specific to your locale. 
- **Depreciated Amount**: Enter the total depreciation amount to date for this equipment. 
- **Remaining Book Value**: Enter the remaining book value for this piece of equipment after the **Depreciation Amount **has been considered. 
- **Remaining Life in Months**: Enter the remaining life in months for this piece of equipment after the Depreciation has been considered. 

These records can also be loaded using **Salesforce Import Wizard**. Your spreadsheet will look something like the following; 

![](https://lh7-rt.googleusercontent.com/docsz/AD_4nXfg3cqOJFugpE_qc20ZAqjF4IRaus5o4_hc0W-FanieoRJdHhphr7nH1cbWtmZcgtK0b1OkVZtlhOTxYR0ob6xTALz_n-jKmfXzcjtHYdSVrSXv_qxYFyPfkXr8JEgXZCTNP_g__JVXbp53_VzuUUQyCt6O?key=vG7pEpqBPxv3ngHPQ7fCnA)

Use the import wizard to load these records into the Depreciation Calculation object. To confirm your values you can use the formula fields on the Equipment object to confirm that you have the correct values loaded. These values will be used as the life-to-date values for the next depreciation calculation. 

::Image[]{src="https://lh7-rt.googleusercontent.com/docsz/AD_4nXcLhDyPQ5C0pfrhCEAk_yGKPj7fae_sYSnBXzZ4h4LYlU7f5qG2cheIPJ2Yyj4lvSYyO101efgePUH4YcoPw1zK_yQKgJwnIkj26IXZfWSguii7w_5pzGMi3UUWQqA9sT91-0OJIsquR3_--BqsL1T95QOL?key=vG7pEpqBPxv3ngHPQ7fCnA" size="32" width="225" height="317" position="center" showCaption="false"}

### Run Depreciation Calculations 

Each month for each Company you will run the Depreciation Calculation function. Navigate to the Companies object and select a company record. Click the Depreciation Calculation button. 

::Image[]{src="https://lh7-rt.googleusercontent.com/docsz/AD_4nXehEE0DBuCI9Xy6pVVHHVKofP5tCF9rv4ClygeBLLTK-GDhrQjL6BZFHvDiVBthRs4PVAkuoeKKWeNTnTbpAoJE_-xQn30l-hbJ8je5XsITnddi574l56LxKmJ7A_9HCXB1BG3nxukEqwp6Ad2DlehtJQ7A?key=vG7pEpqBPxv3ngHPQ7fCnA" size="86" width="457" height="258" position="center" showCaption="false"}

The screen contains the necessary information. Enter the date you wish to calculate depreciation for. The system will set the date to the last day of whichever month you enter. **Batch Size **for most users will work with the default of 200. If you have** Process Builders** or other APEX triggers you may need to reduce this number. 

Read and understand the **Information Section. **When you press the **Start Depreciation** button, the APEX job information will be added to the page and refresh periodically. Once the job has been completed you will be able to exit the screen or run another month. To exit the screen, use the X in the top right corner. 

As mentioned on the page if there is an existing record in the month you chose to run that equipment record will be skipped. This allows you to add records in the past and run depreciation for those records only that have not had depreciation run previously. 

::Image[]{src="https://lh7-rt.googleusercontent.com/docsz/AD_4nXfbjL5NKHVzhpnz2DImvvVXjCYZNTSGHiYlMPMVoSdzVW6lwSAu_hwgjl_nEbxg-ATKMnxC6gdlHerCgerZGPYqS8L8zzBME-KmnNyMiZ_h2pba2X9gyIeV71_906A3fw_ghLEFDAnLUr8-xsjWgBn5MvNn?key=vG7pEpqBPxv3ngHPQ7fCnA" size="42" width="153" height="141" position="center" showCaption="false"}

After a Depreciation Calculation is run we store the **Last Depreciation Date** in the **Company** record. You can use this to confirm which date was last used for depreciation. 

In the last month that depreciation gets run any remaining book value will be added to that last month. If the monthly calculation would leave behind a value due to rounding, this value will appear in the last depreciation calculation record. You will also receive an email when the job has completed with a summary of the job statistics. 

## Equipment Depreciation Report 

We have included a Report Folder called **ELTON Depreciation **and a sample report called **Equipment with Current Depr Values. **You can use this report to see the current values of any equipment. You can use the Salesforce report system to build new reports as desired. The objects used for this module are the Equipment object where you find summary information including current values and the Depreciation Calculation object where each depreciation is separately stored. You should be able to obtain any required information from these two objects. 

## Depreciation Journal Entry 

::Image[]{src="https://lh7-rt.googleusercontent.com/docsz/AD_4nXda2LEtitVjBVK6HF5_3Ex8lVFMObsg1oVAnZG-8Z0qPPD-OLwe36RVNyx8Q143lFg3R3B00S1TLnIfBNmMjs83TnTHKnfOvSY7OMz1bnGKuie5qGF-pCtXdeU8zo7jehVy5RY9zn0xq6MVdI-Zu-5Nfv1F?key=vG7pEpqBPxv3ngHPQ7fCnA" size="54" width="208" height="205" position="center" showCaption="false"}

If you want to summarize all your **Depreciation Calculations** into a** Journal Entry** for the month:

1. Navigate to** Companies**.
2. Select the **Generate Journal Entry** action. 
3. When the Journal Entry has been generated **use the X in the top right corner to exit this page.**
4. After the **Journal Entry** has been generated you can see the resulting entry by navigating to the** Related** list tab on the** Companies** page. 

The **Journal Entry** will display the summary of the **Journal Entry:** **Calendar Year** -** Period**, **Date**, **Number of Lines.** and **Amount**. Change the **Posted Flag** or** Interface Status** to indicate when the** Journal** entry has been entered into your **General Ledger** System. 

Access the GL Accounts and GL segment line-by-line records by using the **Related **tab on the **Journal Entry**. All of this data can be put onto a report and exported. 



::Image[]{src="https://lh7-rt.googleusercontent.com/docsz/AD_4nXfdrLvKRwfpGgjurF8kWldhPDJd7nHyM_Ymd7Mdqx7JTFbkH4_7ISSvVjEATU_nacHwqg3aUA2RQLfmCxTFcZbI2P5NCwWCq_F4fz5OJO7uTCNRv8X9zkZtILzOhtoMvWwqlTJQct1P4LI5QM5MpZ_Mt00?key=vG7pEpqBPxv3ngHPQ7fCnA" size="44" width="222" height="369" position="center" showCaption="false"}