Fixed Assets Journal Import
You can use the fixed asset journal import functionality to conveniently import your opening balances per asset into Sparkrock 365. The import process involves you populating your data in an Excel file.
Fixed assets journal import template file
To download the fixed assets journal import template file, select the following link:
Import Fixed Asset Journals from Excel Template
This file can be used for importing data for both pooled and non-pooled assets. There are no limitations when you use the file to import the values for non-pooled assets. The following list includes some considerations regarding importing data for pooled assets:
To indicate to Sparkrock 365 that the depreciation is linked to an acquisition, you must have an acquisition line before the depreciation line.
Importing depreciation for pooled assets only is not supported.
To import data into a fixed asset journal
Choose
, enter fixed assets journals, and then choose the related link.The Fixed Asset Journals page opens.
In Batch Name, specify the batch that you want to use.
On the action bar, choose Actions > Functions > Import.
The Import FA Journal page opens.
In Workbook File Name, select the import file that you want to use.
To populate the dimension values for the imported data with the default values that appear on the applicable Fixed Asset Card page, turn on Use Default Dimensions.
When Use Default Dimensions is turned off, the dimension values are populated as entered in the import file.
Choose Ok.
Feedback
To send feedback about this page, select the following link: