Skip to main content
Skip table of contents

Planned Costs/Revenues Import

Below are some helpful tips when importing data from your CSV file into a specific folio planned costs:


FOLIO Field

Import Notes

Category

Defines the category of the expense.
Possible values are

  • OPEX - to define an operating expense
  • SALARY - to define a position
  • CAPEX - to define a capital expenditure
  • FINEX - to define a financial expenditure

(info) Default value if none specified : OPEX

Type

Defines the type of an expense or the title of a position

(info) Default value if none specified : *With no type

Name

The name of the expense/position

(red star)(star) Mandatory - must be specified

Description

You can specify a description for the expense/position

(info) Optional

Reporter

You can specify a reporter for the expense/position.

(info) Default value if none specified : The importer

Start date

 You must specify the date on which the expense occurred or if recurring or a position the starting date.

(red star)(star) Mandatory - must be specified

End date

 You can specify the date on which the expense/position stops.

(info) Default value if none specified : Folio end date

Account

Define the associated Tempo Account  associated to this expense/position.
The value is the Account key

(info) Optional

Labels

Define the list of JIRA Issues Labels associate to this expense/position
If you need more than one label for an expense list them with a space as delimiter (ex:"lbl_1 lbl_2 lbl_3 lbl_4")

(info) Optional

EXPENSE (red star)SPECIFIC

Amount

The amount of the expense

(red star) Mandatory - must be specified if row is an expense

Amortized

You can specify if the expense is amortized or not.
Possible values are

  • TRUE - if amortized
  • FALSE - if not amortized

(info) Default value if none specified : FALSE

Frequency

You can specify the frequency of the recurring expense.
Possible values are

  • ONCE
  • WEEKLY
  • MONTHLY
  • YEARLY

(info) Default value if none specified : ONCE

Repeat every

You can specify a "repeat frequency" for the recurring expenses

e.g. Repeat every 2 weeks

(info) Default value if none specified : 1

Occurrences

You can specify a maximum number of occurrences for the recurring expenses.

(info) Optional

Repeat on

You can specify which days of the week the recurring expense occurred
Possible values are

  • SU - for Sunday
  • MO - for Monday
  • TU - for Tuesday
  • WE - for Wednesday
  • TH - for Thursday
  • FR - for Friday
  • SA - for Saturday

(warning) Is mandatory if the frequency is set to WEEKLY

Repeat byYou can specify when the monthly recurring expenses occurred - Available only if the frequency is MONTHLY
Possible values are
  • DAY OF MONTH - for the recurrence to be based on the day of the month
    e.g. Monthly on day 31
  • DAY OF WEEK - for the recurrence to be based on the week day
    e.g. Monthly on the first Tuesday
(info) Default value if none specified : DAY OF MONTH
POSITION (star)SPECIFIC

Effort

You can specify the effort planned for the position (in hours)

(info) Optional

Wage

You must specify a wage for each position (hourly rate).

(star) Mandatory - must be specified if row is a position

Availability

You can specify the availability planned for the position (%)

(info) Default value if none specified : 100%

You must have the edit rights on the folio to be able to import data.

Each row of the csv file will systematically result in a new expense or position entry.

CSV Example for Planned Costs
"Category","Type","Name","Description","Reporter","Amount","Amortized","Effort","Wage","Availability","Start date","End date","Frequency","Repeat every","Occurrences","Repeat on","Repeat by"
"SALARY","Administration","Scrum Master","A scrum master is the facilitator for a product development team that uses scrum, a rugby analogy for a development methodology that allows a team to self-organize and make changes quickly.  The scrum master manages the process for how information is exchanged.","admin","","","","40.00","100.0000","2013/08/31","2014/05/18","","","","",""
"SALARY","Developers","Java Guru","It's not simply the Java in your Cup; it's how you prepare it that makes it worth consuming. Any modern day software is developed using object oriented language especially java because of the 'Write once, Run anywhere' architecture and its number of attractive and powerful features. Javatars, apply your java skills, compete with the bests and be the next Java Guru.","admin","","","","50.00","100.0000","2013/08/31","2014/05/18","","","","",""
"SALARY","Developers","Java Senior developer","Not a Guru but close.","admin","","","400.00","50.00","100.0000","2013/08/31","","","","","",""
"OPEX","Rent & Leasing","3101 Olivette-Marjault, Montreal, Quebec","Head office rent.","admin","2,800.00","","","","","2013/08/31","","MONTHLY","1","","","DAY_OF_MONTH"
"OPEX","Representation","Agile Conference","Includes booth, passes, plane, accommodations.","admin","2,500.00","","","","","2013/10/30","","","","","",""
"OPEX","Representation","Atlassian Summit","Includes booth, passes, plane, accommodations.","admin","2,000.00","","","","","2013/10/30","","","","","",""
"OPEX","Representation","Accommodations","Various expenses related to accommodations.","admin","1,000.00","true","","","","2013/08/31","","MONTHLY","1","","","DAY_OF_MONTH"
"OPEX","Licensing","JIRA license","Product issue tracker and support tool.","admin","4,000.00","","","","","2013/08/31","","","","","",""
"OPEX","Licensing","Confluence (wiki) license","Our team wiki.","admin","4,000.00","","","","","2013/08/31","","","","","",""
"OPEX","Licensing","FOLIO for JIRA license","Simply the best EVM add-on so far!","admin","2,000.00","","","","","2013/08/31","","","","","",""
"OPEX","Advertising","Web ads","Banners, links, google adds...","admin","10,000.00","true","","","","2013/08/31","","MONTHLY","1","","","DAY_OF_WEEK"
"OPEX","Advertising","Magazine ad","To announce the product launch date.","admin","500.00","","","","","2013/08/31","","WEEKLY","1","","SU,MO,TU,WE,TH,FR,SA",""
"CAPEX","Equipment","Head office furniture","A couple of desks and some chairs.","admin","30,000.00","true","","","","2013/08/31","","MONTHLY","1","","","DAY_OF_MONTH"
"CAPEX","Equipment","Computers","About 4 computers for devs and 2 laptops for admins.","admin","40,000.00","true","","","","2013/08/31","","MONTHLY","1","","","DAY_OF_MONTH"
"CAPEX","Legal","Algorithm patent","If we need one...","admin","2,000.00","","","","","2013/08/31","","","","","",""
"CAPEX","Legal","Product copy rights and licensing","Legal stuff for the product licensing","admin","3,000.00","","","","","2013/08/31","","","","","",""
"FINEX","Loans & Credits","Bank loan","Expected loan for initial cash flow","admin","500.00","","","","","2013/08/31","","MONTHLY","1","","","DAY_OF_MONTH"
"FINEX","Loans & Credits","Credit cards","Expected interest on various credits","admin","160.00","","","","","2013/08/31","","MONTHLY","1","","","DAY_OF_MONTH"
CSV Example for Planned Revenues
"Category","Type","Name","Description","Reporter","Amount","Amortized","Effort","Wage","Availability","Start date","End date","Frequency","Repeat every","Occurrences","Repeat on","Repeat by","Labels"
"CONSULTING","Developers","Architect","Must have some experience in SOAP","admin","","","","40.00","100.0000","2013/11/20","2014/08/07","","","","",""
"OPERATING","Sales","Licenses","Revenue originating directly from the licensing sales.","admin","3,500.00","","","","","2013/11/20","2014/01/19","MONTHLY","1","","","DAY_OF_MONTH"
"OPERATING","Sales","Clothing","Because we are a T-Shirt company!!!","admin","150.00","","","","","2013/11/20","2014/01/19","MONTHLY","1","","","DAY_OF_MONTH"
"NON_OPERATING","Memberships","Parking fees","From the parking fees charged to the employees. Hide a bike!","admin","1,200.00","","","","","2014/01/20","","MONTHLY","1","","","DAY_OF_MONTH"




JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.