Expenses correspond to amounts spent to attain the objectives of the folio. They can belong to any of the three categories described in the budget section Categories: OPEX, CAPEX or FINEX. Expenses can be single occurrence, or they can be recurrent. Recurrent expenses can also be amortized; in which case the amount associated with the payment will be evenly split on the payment period. Expenses should represent all money that you plan to be spent during the folio's time frame, such as rents, maintenance contracts, software license purchases, loan financing costs or mortgages.
Below are some helpful tips when importing data from your CSV file into a specific folio budget:
Export Field
Export Notes
Category
The category of the expense. May contains either
OPEX - operating expense
SALARY - position
CAPEX - capital expenditure
FINEX - financial expenditure
Type
The type of an expense or the title of a position
Name
Contains The name of the expense/position
Reporter
The reporter for the expense/position.
Start date
The date on which the expense occurred or if recurring or a position the starting date.
End date
The date on which the expense/position stops.
EXPENSE
SPECIFIC
Amount
The amount of the expense
Amortized
Indicate if the expense is amortized or not. May contains either
TRUE - if amortized
Nothing - if not amortized
Frequency
The frequency of the recurring expense. May contains either
WEEKLY
MONTHLY
YEARLY
Nothing if ONCE
Default value if none specified : ONCE
Repeat every
The "repeat frequency" for the recurring expenses
Occurrences
The maximum number of occurrences for the recurring expenses.
Repeat on
Days of the week the recurring expense occurred (when re May contains combinaison of the following valuse
SU - for Sunday
MO - for Monday
TU - for Tuesday
WE - for Wednesday
TH - for Thursday
FR - for Friday
SA - for Saturday
Is mandatory if the frequency is set to WEEKLY
Repeat by
You 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
Default value if none specified : DAY OF MONTH
POSITION
SPECIFIC
Effort
You can specify the effort planned for the position (in hours)
Optional
Wage
You must specify a wage for each position (hourly rate).
Mandatory - must be specified if row is a position
Allocation
You can specify the allocation planned for the position (%)
Default value if none specified : 100%
Icon
You must have the edit rights on the folio to be able to import data.
Icon
Each row of the csv file will systematically result in a new expense or position entry.
