Expenses Report

The Expenses report shows detailed and accurate expenses or revenues for a given time frame. The report can be generated for both planned or actual expenses as well as revenues in a variety of ways by setting any or all of the many parameters it offers. You can obtain a printable version using the report's action menu (...) or by hitting p while consulting it.

This report is available for Folios and Portfolios.

 

Report Parameters

For

Determines which financial data source to use.

Actual Cost displays Folio actual expenses within the selected Start and End date (Start and End date included).
Planned Cost displays planned costs expenses.
Actual Revenue displays actual revenues entries.
Planned Revenue displays planned revenues entries.

Start Date

Report Start Date.

Clicking on the Folio start link sets the report start date to be the Folio's start date. If the report start date is before the Folio's start date, only expenses with a incurred date later than the Folio's start date is displayed. 

End Date

Report End Date. 

Clicking on the Folio end link sets the report end date to be the Folio's end date. There is no end date limitation like it is the case for the report's start date, therefore expenses incurred after today are future known cost. Unassigned positions in team are not included in the expenses report.

FrequencyThis allows you to group your expenses Daily, Weekly, 2 weeks, 4 weeks, Monthly, Quarterly or Yearly
Note that report start date "day" will be the periods starting day. This means if your report start date is a Tuesday and the frequency is Weekly the report will displays weekly expenses from Tuesday to next Monday 
Label

This allows you to display amounts for the selected Jira Issue Label. (not available at the portfolio level)
Note : see Using Labels for more info on.

CategoriesExpenses or Revenues Categories to be included in the report
RolesSalary or Consulting service titles to be included in the report
TypesExpense or Revenue types to be included in the report

Menu Options

PrintableDisplay a printable version of the report
Note that you can also use the shortcut "p"
Export to ExcelExport report to Excel
More Reports

Bring you back to Reporting List
Note that you can also use the shortcut "x" 

Printable Version

Export to Excel

The Expenses report can be exported to Excel format. It will give you all the latitude you need to further digest, analyze or graph the data. Do it by selecting the "Export to Excel" item in the report's action menu found on the top right of the report's parameters panel. The parameters that were used to generate the report can be found on the second tab of the generated spreadsheet

Expense custom fields

In the above example Invoice # and P.O. # are custom fields defined by the user through the Folio Configuration.

 

 

 

Related pages: