Web TimeSheet's raw data exports allow you to export raw timesheet, project, and expense data to spreadsheets using a CSV file. You can create your own customized raw data export using the raw data export template, or use (and modify, if desired) the pre-configured raw data exports. You can also add custom columns when editing raw data exports.

The following raw data exports are available:

  • Expense Raw Data Export: Lists expenses in the system and associated information (such as department, date, description, user, and amount).
     
  • Project Raw Data Export: Lists projects in the system and associated information (such as project leaders, client reps/approvers, billing methods, estimates, and start and end dates). Because this export provides estimated cost values in a single currency (base currency), it is important to understand how the estimated cost is converted.

    • Roll up Project/Task Estimates: If your organization uses the option to roll up project/task estimates, the total estimated cost is calculated as the sum of all estimates converted to the base currency using the exchange rate specified for the date the last cost estimate was entered (for each currency type).
      For example:The base currency is USD. For Project A, there are two tasks for which estimates are entered in CDN – Task 1 and Task 2. The estimate for Task 1 was entered on February 1. The estimate for Task 2 was entered on February 11. When the values are rolled up, both estimates will be converted to base currency at the exchange rate for February 11. When the report is run, the total estimated cost for Project A will be based on the last calculated rolled up value – using the exchange rate for February 11.
       
    • Do Not Roll up Project/Task Estimates:If you are not using the option to roll up project/task estimates, the total estimated cost is calculated as the sum of all estimates (including the project) converted to the base currency using the exchange rate at the time the report is run.
  • Timesheet Raw Data Export: Lists time entered in the system and the associated information (such as users, billing methods, projects, hours).