How can we help you today?

Follow

Adding financial information with import templates

You can import data to the Financial info tab using two spreadsheets, PnL 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

How to get the template(s)?

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

Na_ytto_kuva_2022-6-2_kello_14.47.54.png

PnL template

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 centre is an identifier to link PnL 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 (best case, worst case etc.).

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

Username > Import > Start new import

Na_ytto_kuva_2022-6-10_kello_13.05.08.png

Financial information template

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

  • Portfolio company ID and name are optional but recommended.
  • Property cost center is an identifier to link financial info to the property.
  • Property name is an identifier to link financial data to the property.
  • 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.

Upload the file to Assetti with Import functionality. Select the file type as Financial information.

Username > Import > Start new import

Na_ytto_kuva_2022-6-10_kello_12.25.57.png

Related articles

How to import data

Budgeting

Financial information in Assetti

Account maps

Adding financial information in the user interface

Financial information at a portfolio level

Financial information at a property level

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.