Actual Revenue CSV Export

The following table shows all actual revenues fields that are exported and the description of their contents.

The fields order may differ from the actual export file column order

Exported Fields	Description
Category	The category of the revenue. May contains either OPERATING - operating revenue CONSULTING - Consulting revenue NON_OPERATING - non-operating revenue
Type	The type of a revenue or the title of a consulting revenue
Name	The name of the revenue
Description	The description for the revenue/consulting revenue
Reporter	The reporter for the revenue/consulting revenue
Start date	The date on which the revenue occurred or if recurring or a consulting revenue the starting date.
End date	The date on which the revenue/consulting revenue ends.
Custom fields	The value for a specific custom field.
Account	The account key of the associated Tempo Account
REVENUE	SPECIFIC
Amount	The amount of the revenueThe
Amortized	The revenue 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
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 (only when frequency is set to WEEKLY) May contains a combination of the following values SU - for Sunday MO - for Monday TU - for Tuesday WE - for Wednesday TH - for Thursday FR - for Friday SA - for Saturday
Repeat by	The monthly recurring expenses occurred - (only when frequency is set to MONTHLY) May contains either 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
CONSULTING	SPECIFIC
Wage	The wage for the consulting revenue (hourly rate).
Availability	The billable ratio (%) - Portion of the worked hours that are billable.
Worked Hours	The hours worked in the period defined by the start date and end date

Exported CSV Example

"Category","Type","Name","Member","Description","Reporter","Amount","Amortized","Wage","Availability","Worked Hours","Start date","End date","Frequency","Repeat every","Occurrences","Repeat on","Repeat by"
"CONSULTING","Scrum Master","admin tempo","admin","Part time as a Scrum Master for sub team B.","admin","","","50.00","45.0000","","2013/09/03","2014/05/21","","","","",""
"CONSULTING","Development","admin tempo","admin","Part time as a senior JAVA dev on sub team A.","admin","","","55.00","55.0000","","2013/09/03","2014/05/21","","","","",""
"OPERATING","Sales","Licenses","","Revenue originating directly from the licensing sales.","admin","3,000.00","","","","","2013/09/03","2013/11/02","MONTHLY","1","","","DAY_OF_MONTH"
"OPERATING","Sales","Clothing","","Because we are a T-Shirt company!!!","admin","200.00","","","","","2013/09/03","2013/11/02","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","","","","","2013/11/03","","MONTHLY","1","","","DAY_OF_MONTH"

Related pages:

Actual Revenues