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.| Info |
|---|
This report is available for Folios and Portfolios. |
 Image Removed Image Added
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. |
|---|
| Frequency | This allows you to group your expenses Daily, Weekly, 2 weeks, 4 weeks, Monthly 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. |
|---|
| Categories | Expenses or Revenues Categories to be included in the report |
|---|
| Roles | Salary or Consulting service titles to be included in the report |
|---|
| Types | Expense or Revenue types to be included in the report |
|---|
| Printable | Display a printable version of the report
Note that you can also use the shortcut "p" |
|---|
| Export to Excel | Export report to Excel |
|---|
| More Reports | Bring you back to Reporting List
Note that you can also use the shortcut "x" |
|---|
| Anchor |
|---|
| ExportToExcel |
|---|
| ExportToExcel |
|---|
|
Export to ExcelThe 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 
| Info |
|---|
| title | Expense custom fields |
|---|
| | In the above example Invoice # and P.O. # are custom fields defined by the user through the Folio Configuration. |
|