Features Below Available To: ✅ Grow Plan ✅ Track Plan ❌ Free Plan
Monograph solves the problem of cross-platform data exchange by allowing you to export all of your team's timesheet data from Monograph into a CSV (Comma Separated Value) file using the Organization Timesheet export. You can then import this CSV file from Monograph into your favorite platform.
Pro Tips: Importing a CSV file after manipulating it in Microsoft® Office Excel can potentially cause issues. For more information, please refer to the following links:
Additionally, this export is a great resource to use if you want to know the total number of hours/fees spent across all of your team's projects and overhead (or a specific individual) within a specified duration of time. Simply follow the steps below and apply filters as necessary after you've downloaded the CSV file.
🎓 For more information about logging time to Timesheets in general, please check out this article.
Exporting the Organization Timesheet
To export the Organization Timesheet, navigate to Time > Timesheets (under Staff Time)
From there, select the desired Time range from the calendar on the left and then click on the Export button in the upper-right corner of the screen.
A new pop-up will appear. Select the criteria for exporting the report. See below for more detailed information on each of the options.
Begin Date - The date from which the CSV file should begin the timesheet data.
End Date - The date to which the CSV file should end the timesheet data.
Format - Format of the data in CSV output:
Dates as columns will distribute the date range into columns and produce a row per hour entered in timesheets.
Dates as rows will produce one row per timesheet entry.
Include Notes - Select the box to include timesheet notes in the CSV file.
Finally, click on Email CSV.
After clicking on Email CSV, you'll receive an automated email from our Support Team that will include a link to download the CSV to your device.
💡 If any timesheet entries need to be edited, use the Edit Time Entries button in the upper right corner of the page to quickly batch edit timesheets.
CSV Examples
Example of Organization Timesheet exported with "dates as columns"
To note: if a user has multiple billable rates for a project's phase/role used on the same date, the rates will appear in separate rows.
Example of Organization Timesheet exported with "dates as rows"
Note: Monograph provides timesheet exports in CSV format, supporting project management needs with flexible customization options that allow users to adapt and integrate data for specific reporting purposes before creating a printable format. Unlike PDF, this approach offers greater control over data presentation and analysis.
📚 If you haven't already checked out the Organization Time Log for viewing timesheet information for your team across all projects, click here to learn more!