Adding financial information with import templates

You can import data to the Financial info tab using two spreadsheets, General Ledger or Financial information.

Must have for adding financial info

An account map added in Assetti. Depending on your subscription, you can have 1-4 account maps.
Linkage between account map and properties
- Username > Account maps > select the map > Link properties tab

Username > Import > click on the link of the template to download

Open the template in your computer's downloads, fill in the data and save. Mandatory columns are bolded.

Portfolio company ID, name and cost center are optional.
Property name is an identifier to link financial data to the property.
Property cost center is an identifier to link the general ledger to the property.
Month is the date of the transaction in format MM/YYYY or DD/MM/YYYY. There can be several transactions per month, but they are shown as a total in the table and they are net values.
Account map is the name of the account map.
Account code is the code of the account this transaction is going to.
Account name is the name of the account this transaction is going to.
Value is the monetary transaction, entered in the corresponding currency.
- Do not add costs as negative value as this will be calculated as income.
  - Example: -10500 is incorrect, add it as 10500
Type is either ACTUAL, BUDGET (operating budget) or other budget types that you have created (best case, worst case etc.).

Upload the file to Assetti with Import functionality. Select the file type as General Ledger.

Username > Import > Start new import

Na_ytto_kuva_2022-6-10_kello_13.05.08.png

Open the template in your computer's downloads, fill in the data and save. Mandatory columns are bolded.

Portfolio company ID is optional but recommended. Cell B1
Portfolio name is optional but recommended. Cell B2
Property cost center is an identifier to link financial info to the property. Cell B3
Property name is an identifier to link financial data to the property. Cell B4
Account map is the name of the account map.
Account group is the name of the group.
Account code is the code of the account this transaction is going to.
Account name is the name of the account this transaction is going to.
Type is either ACTUAL, BUDGET (operating budget) or other budget types (best case, worst case, etc.).
Months and year in the template are from current year.
- Value is the monetary transaction, entered in the corresponding currency.
  - Do not add costs as negative values as this will be calculated as income.
- If you want to change month and year, keep the original styling (JANUARY-2022). Do not remove (delete) the columns from the template.