Reportance allows you to bulk import assets from another assets system via Excel. You can also use this tool as a means of quickly creating multiple new assets from a client ledger export.
Import Template
To access the excel template for importing, go to the Assets screen, and from the Options button select Import from Excel.
This will open a ready made Excel template, you can copy and paste data into this worksheet to supply the data for import.
Review the previous training section for details on the meaning of each field. There are two things to note with the import template:
Asset Group
If an asset group does not exist within Reportance by the provided name, a new one will be created automatically during the import process (noting that this is case sensitive).
Accounting
The accounting fields are optional, as the import process allows you to copy all Taxation values into the corresponding Accounting values.
Running the Import
To run the import, open the Excel import template in Excel, then go to the Reportance tab and select Import Assets
Here, first select the relevant Reportance .rep file into which you will import the assets.
Next, set the following fields:
Entity
Select the entity into which you wish to import assets
Year
Select the year in which the opening written down value is provided for. Note, if the acquisition date for the asset occurs in this year, the OWDV field will be ignored, and the asset will be treated as having been bought at cost during that year on the specified date.
Provide Taxation Figures Only
Tick this if you wish to copy all Taxation figures into the equivalent Accounting fields.
With the settings ready, you can now start the import by clicking Run Import.
After running the import process, the Import Log will show the status of every asset and whether or not it was successfully imported. The log will provide details on the reason behind any failed imports. If you wish to store this data for later use, click Copy Log which will copy the contents of the log to the clipboard, from where you can paste it into your preferred program.
Once you are finished with the import, select the Close button to close out of the Import Assets window.
Note, if you have Reportance open while running the import, navigate to Client Info and back again to Assets to see the newly imported assets.