Create Partially Depreciated Fixed Assets

Hi, 

An external template is available for the loading of fixed assets.   This includes the Acquistion value, date and any accumulated depreciation. 

The downside is the template has multiple record types.  

Given only 100 (more or less objects) it may be easier to create the objects via a file load, and use the import process (asset by asset) to load the values. The values can’t really be loaded via manual journal entry. That can set GL but the object will not be correct. 

To test, manually create an object. Then on the object select import where you define the true acquisition date and value. Also note any accumulated depreciation as of a date (for example 1000 acum dep as of August 2024. 

See the external file templates to locate the standard template for loading the FA objects.   

I am attaching a sample file, The file is not overly easy to work with. For that reason, like I wrote it may be easier to manually load the values.  If you can easily get your data in that format, it should be an easy process to load. 

The file is a standard IFS external file template (I simply changed the date format and separator). Columns / attributes should ne same / nearly the same as you will see in your system. In external file templates, locate the one for fixed assets, and use the IFS option to copy the file template (use the actual option copy file template) not a copy record type option.  This option is only available in the templates screen, not the template screen. 

Hi,

Additionally you may need to consider where you will account the Credit when you bring in the Acquisition Value for the Asset (Normally it is the Stat Account) and also the Debit when you bring in the Accumulated Deprecistion for the Asset (Normally it is the Stat Account). This Accounting has to be accurate and Your Trial Balance as at Transfer Date should Tally and your Stat Account Balance has to be 0. Other wise You will have challenges in Year End Closing

Thank You