Features Below Available To: ✅ Grow Plan ✅ Track Plan ❌ Free Plan
What is the Retrospective Report?
The Retrospective Report (formerly known as the Revenue Report) allows firms to look back at completed work periods and compare financial goals with actual results. It pulls insights from the project budgets, hour allocations, logged hours, and issued invoices to provide a historical view of your revenue.
To access the Retrospective Report, navigate to Analytics in the Menu Bar on the left-hand side of the screen and then click on Retrospective below Projects.
🚨 Note: The Retrospective Report was formerly referred to as the Revenue Report.
Different Parts of the Retrospective Report
Date selector and Filters
The date selector is limited to past timeframes. The smallest time bucket available for selection is one Month. Daily and weekly views are not supported to maintain a focus on broader trends. Users can also select by Quarters or Years.
You can filter the report by Project, Status, Category, Client, and Size.
Summary Statistics
The large numbers at the top of the page indicate key summary statistics based on the applied filters.
Projects - Shows the total number of Projects in the selected date range.
Revenue (Budgeted) - This represents the projected revenue for each project or phase, based on the number of hours allocated to each project.
Revenue (Logged) - Shows the total fees logged over the selected timeframe. Underneath, you'll see how many hours have been logged and the percentage of those hours that are billable. Note: This percentage is rounded up or down from the value displayed in the Organization Time Log.
Revenue (Issued) - Shows the total of Services (Fixed or Hourly) across Open, Paid, and Past Due Invoices. Draft invoices are not included. Underneath, you'll see how many invoices were issued during the selected timeframe.
Bar Line Graph
The colorful bar line graph visually represents your work over the selected timeframe. This will be grouped by month, quarter, or year based on your selected timeframe. This is what they represent:
Planned amounts: come from the Project Budget, shown in a lighter opacity.
Logged amounts: come from time logged in Timesheets, shown as a diagonal hatch.
Issued amounts: come from Invoices, shown in a darker opacity.
Single Project Highlight
Hovering over a colored segment of a project will highlight it and show the total of its fee and hours for that period.
Hovering over the date displays the total planned, logged, and invoiced hours and fees for that month, quarter, or year.
Per Project Breakdown
Underneath the bar line graph, you'll see a by-project breakdown based on your selected timeframe and filtering criteria. Clicking a Project Name opens that project's Overview Page.
For each project, we highlight the following: status (proposed, active, paused, canceled, completed, draft), whether it's billable or not, the Revenue (Budgeted), the Revenue (Logged), Revenue (Issued), Hours (Planned), and Hours (Logged).
Additional columns for Square Footage and Construction Costs can be added by clicking the icon in the upper-right corner of the chart, then selecting the columns to show in the report.
Planned fees and planned hours are derived from the hours entered in the Project Budget. Logged fees and logged hours are derived from the hours logged in Timesheets.
🚨 If a project has a planned fee but no planned hours, it means that no hours were allocated to your team for that project or phase, despite it having a budget. To fix this, you'll need to go back into that project and edit the allocations.
Where Does the Information Come From?
All of the Project information you see on the screen comes directly from the Project Budget. If the information in the Project Budget is incomplete or inaccurate, then your report will be inaccurate.
For Project information to be included in this report, it must have the following:
Start & End Date
At Least One Phase
Phase Budgets (Budget if Fixed Phase or Max Cap if Hourly Phase) or Hours Allocated
For Invoice information to be included in this report, invoices must be issued (ie. Open, Paid, or Past Due).
🚨 Amounts reflected in this report do not include Consultants, Expenses, Retainers, or Other Items.
Permissions
Admins will have access to this report. To allow other users access, make sure the 'View Financial Reports' permission is enabled.
If you do not see the Analytics page, it means your current permission level does not allow you to see Financial Reports. Please reach out to your Admin for assistance.
FAQs
How much billable work will I have in this time period?
Select a date range and filter the status to active and fee type to billable.
How many of my upcoming projects have been paused or cancelled?
Select date range and filter status to paused and cancelled.
How much of my project revenue is coming from a category(ies)?
Select date range and filter by categories such as 'Commercial' or 'Residential'. You can select one or several.
If I only worked on these projects would I have enough revenue?
Select a date range and filter projects to include only one or several.
What does my future workload look like? Which months in the next 12 months have the most/least work?
Select a date range and filter the status to active and proposed.
How much time and money was consumed across all completed, billable projects last year compared to what was originally planned?
Select a date range, filter the status to completed, and add the 'billable' filter.