Financial reports

Financial reports provide comprehensive visibility into your billing operations, payment tracking, and revenue management. These reports help streamline your financial processes and provide insights into business performance.

Billing periods management

The comprehensive billing dashboards summarize billing data in one place so it's easy to find the detail your team needs. Track and manage billing periods across all your projects with detailed status monitoring and financial summaries. These dashboards offer real-time financial summaries that help project managers and finance teams quickly assess billing status across their entire project portfolio.

Billing periods report example

Billing periods report

Purpose: View and manage billing periods across all projects with comprehensive status tracking and financial analysis.

The billing periods report is your central hub for managing all billing activities, providing detailed visibility into billing status, payment tracking, and financial performance across your entire project portfolio.

Key features:

  • Comprehensive status tracking: Monitor billed/paid, unbilled/billable, and other billing statuses

  • Financial summaries: Get aggregate views of billing amounts and payment status

  • Inline status management: Update billing and payment status directly from the report

  • Advanced filtering: Filter by customers, projects, products, and billing status

  • Date range analysis: Analyze billing activity over any time period

  • Export functionality: Download billing data for external analysis and accounting

  • Real-time updates: See immediate updates when billing status changes

Billing status categories

Billed and paid

Purpose: Track billing periods that have been billed and payment has been received.

This view shows you completed billing cycles where invoices have been sent and payments have been received, providing visibility into your successful revenue collection.

Key insights:

  • Revenue recognition: Confirmed revenue from completed billing cycles

  • Payment timing: Understand how quickly customers pay after billing

  • Customer payment patterns: See which customers pay promptly

  • Cash flow analysis: Track actual cash received from billing periods

How to use:

  1. Navigate to ReportsBilling periods report

  2. Filter by "Billed and paid" status

  3. Review completed billing cycles and payment timing

  4. Analyze customer payment patterns

  5. Export data for revenue recognition and cash flow analysis

Billed but unpaid

Purpose: Track billing periods that have been billed but payment has not yet been received.

This view helps you monitor outstanding invoices and manage accounts receivable, identifying customers who may need payment follow-up.

Key insights:

  • Accounts receivable: Outstanding invoices awaiting payment

  • Payment follow-up: Identify customers who need payment reminders

  • Cash flow planning: Understand expected incoming payments

  • Customer payment behavior: Monitor payment timing patterns

How to use:

  1. Filter billing periods by "Billed but unpaid" status

  2. Review outstanding invoices and aging

  3. Identify customers requiring payment follow-up

  4. Plan cash flow based on expected payments

  5. Export data for accounts receivable management

Unbilled but billable

Purpose: Track billing periods that are ready for billing but haven't been billed yet.

This view shows you billing opportunities that are ready to be processed, helping you stay on top of your billing workflow and maximize cash flow.

Key insights:

  • Billing opportunities: Revenue ready to be invoiced

  • Workflow management: Billing periods ready for processing

  • Revenue acceleration: Opportunities to speed up cash flow

  • Billing efficiency: Monitor how quickly you process billable periods

How to use:

  1. Filter by "Unbilled but billable" status

  2. Review billing periods ready for invoicing

  3. Process billing for ready periods

  4. Monitor billing workflow efficiency

  5. Plan billing activities and cash flow acceleration

Unbilled not yet billable

Purpose: Track billing periods that are not yet ready for billing.

This view shows you future billing periods that haven't reached their billing date yet, helping you plan future billing activities and cash flow.

Key insights:

  • Future billing pipeline: Upcoming billing opportunities

  • Cash flow forecasting: Understand future revenue timing

  • Billing planning: Plan future billing activities and resources

  • Revenue visibility: See your future revenue pipeline

How to use:

  1. Filter by "Unbilled not yet billable" status

  2. Review upcoming billing periods and timing

  3. Plan future billing activities and resources

  4. Forecast cash flow from future billing periods

  5. Monitor your revenue pipeline

Time-based billing analysis

Past billing periods

Purpose: Analyze billing activity for the last 90 days.

The past billing periods view helps you understand recent billing performance, identify trends, and analyze historical billing patterns.

Key features:

  • 90-day historical view: Comprehensive look at recent billing activity

  • Trend analysis: Understand billing patterns and performance

  • Performance measurement: Compare actual vs. expected billing

  • Issue identification: Spot billing delays or problems

  • Customer analysis: See which customers had billing activity

How to use:

  1. Navigate to past billing periods (last 90 days)

  2. Review recent billing activity and trends

  3. Identify any billing delays or issues

  4. Analyze customer billing patterns

  5. Use insights to improve billing processes

Upcoming billing periods

Purpose: View and plan billing activity for the next 90 days.

The upcoming billing periods view helps you plan future billing activities, prepare for upcoming invoicing, and forecast cash flow.

Key features:

  • 90-day forward view: See upcoming billing opportunities

  • Billing planning: Plan resources and activities for upcoming billing

  • Cash flow forecasting: Understand expected revenue timing

  • Customer preparation: Prepare customers for upcoming billing

  • Workflow planning: Organize billing activities and deadlines

How to use:

  1. Navigate to upcoming billing periods (next 90 days)

  2. Review upcoming billing deadlines and opportunities

  3. Plan billing activities and resource allocation

  4. Prepare customer communications for upcoming billing

  5. Forecast cash flow from upcoming billing periods

Using the billing periods report effectively

Filtering and analysis

  • Combine filters: Use multiple filters (customer, project, product, status) to focus your analysis

  • Date range selection: Adjust date ranges to analyze specific time periods

  • Status combinations: Compare different billing statuses to understand workflow efficiency

Workflow management

  • Daily monitoring: Check unbilled but billable periods daily to maintain billing efficiency

  • Payment follow-up: Review billed but unpaid periods weekly for accounts receivable management

  • Planning activities: Use upcoming periods for resource planning and cash flow forecasting

Export and integration

  • Accounting integration: Export data for integration with accounting systems

  • Financial reporting: Use exported data for financial statements and analysis

  • Customer communications: Export customer-specific data for billing communications

Inline status updates

  • Mark as billed: Update billing status directly from the report when invoices are sent

  • Mark as paid: Update payment status when payments are received

  • Bulk operations: Efficiently update multiple billing periods at once

  • Real-time tracking: See immediate updates to financial summaries when status changes

Asset rollforwards

Asset rollforward reports show the flow of assets over a specific date range, providing waterfall visualizations that track how asset quantities change from start to end balances. These reports help you understand asset movements, additions, and dispositions across different accounting categories.

Inventory rollforward report

The inventory rollforward report shows the flow of inventory over a date range, tracking start and end balances with all movements in between. This report provides a comprehensive view of inventory changes including new deployments, sales, and scrap activities.

Inventory rollforward report visuals

Key rollforward components

  • Start - Inventory at the beginning of the period

  • Additions - New assets added to inventory during the period

  • Deployed - Inventory assets deployed during the period

  • Sales - Assets sold out of inventory during the period

  • Scrap - Assets scrapped out of inventory during the period

  • End - Inventory assets remaining at the end of the period

Visual elements

  • Summary data - Key metrics including total additions, dispositions, and net change

  • Waterfall chart - Visual representation of asset flow with color-coded movements

  • Detailed breakdown - Asset-level detail supporting the rollforward calculations

How to use

  1. Navigate to ReportsInventory rollforward report

  2. Select your analysis date range to define the transition period

  3. Choose between unit quantity ("units") or dollar value ("dollars") analysis

  4. Use summaries to get quick insights into overall inventory changes

  5. Review the waterfall chart to understand inventory flow patterns

  6. Export data for financial reporting and inventory planning

Fixed-asset rollforward report

The fixed asset rollforward report shows the flow of fixed assets over a date range, tracking start and end balances with all movements in between. This report provides a comprehensive view of fixed asset changes including new deployments, depreciation, sales, and scrap activities.

Fixed-asset rollforward report visuals

Key rollforward components

  • Start - Fixed assets at the beginning of the period

  • Additions - New assets deployed to fixed status during the period

  • Depreciation - Accumulated depreciation over the period

  • Sales - Assets sold during the period (shown in yellow)

  • Scrap - Assets scrapped during the period (shown in red)

  • End - Fixed assets remaining at the end of the period

Visual elements

  • Summary data - Key metrics including total additions, dispositions, and net change

  • Waterfall chart - Visual representation of asset flow with color-coded movements

  • Detailed breakdown - Asset-level detail supporting the rollforward calculations

How to use

  1. Navigate to ReportsFixed-asset rollforward report

  2. Select your analysis date range to define the transition period

  3. Choose between unit quantity ("units") or dollar value ("dollars") analysis

  4. Use summaries to get quick insights into overall inventory changes

  5. Review the waterfall chart to understand inventory flow patterns

  6. Export data for financial reporting and depreciation calculcations

Last updated