Unbilled Charges Report

Overview

The Unbilled Charges report will provide high-level visibility into Billable Charges that has been earned but has or has not been invoiced as of a given date at a summary (by month) and detailed (by period end date) level by status. This report includes:

  • Billable revenue that has been earned but has not been invoiced or that has been invoiced as of a given date.
  • Amounts that have been invoiced but where the associated revenue has not yet been earned and/or recorded as of a given date.
  • A summary (by month) view and detailed (by period end date) view.
  • All revenue that is either unbilled or unearned
    • Including permanent placements and other revenue not from temporary placements.

This report will be useful to the General Ledger team to reconcile to their unbilled/billed accounts.

Bullhorn Support is able to assist you with navigating the sample reports but are unable to build customizations on the reports for you. You'll need a Business Intelligence specialist who is familiar with writing database queries.

Running the Report

When you run the Unbilled Charges report, you are prompted to select a period end date range, along with the option to add additional criteria to return a more specified list.

Report Criteria

The following options are available as criteria:

  • Client Corp
  • Billing Specialist
  • Bill-to Client
  • Show Detail?

Fields

The report then displays information on the following data within your system:

Field Label Notes
Billable Charges - Billing Header
Period Reporting Period month and year
Not Ready to Bill Summary and detailed amount for Billable Charges that are in status of Not Ready to Bill
Ready to Bill Summary and detailed amountfor Billable Charges that are in status of Ready to Bill
Processing Summary and detailed amountfor Billable Charges that are in status of Not Ready to Bill
Invoicing Summary and detailed amount for Billable Charges that are in status of Invoicing
Invoiced Summary and detailed amount for Billable Charges that are in status of Invoiced
Needs Review Summary and detailed amount for Billable Charges that are in status of Needs Review
Other Billing Statuses Summary and detailed amount for Billable Charges that are in other statuses not covered above
Invoice Statement - Billing Header
Period Month Year Reporting Period month and year
New Summary and detailed amount for Invoice Statements that are in status of New
In Progress Summary and detailed amount for Invoice Statements that are in status of In Progress
Ready Summary and detailed amount for Invoice Statements that are in status of Ready
On Hold Summary and detailed amount for Invoice Statements that are in status of On Hold
Error Summary and detailed amount for Invoice Statements that are in status of Error
Finalized Summary and detailed amount for Invoice Statements that are in status of Finalized
Other Billing Statuses Summary and detailed amount for Invoice Statements that are inother statuses not covered above

Tip: To download both the Summary and Detailed sections into Excel, use the 'Excel 2007 Format' option

If You Want to Change the Calculations

Bullhorn recommends making a copy of the sample report before editing so you can retain the original report. If you accidentally delete or overwrite the report, Bullhorn can restore the stock sample report for you.

For this specific report, the Billable Charges Summary and Billable Charges - Detailed sections are drawn from two separate joined Invoice Statement and Client and Bill-to Client packages:

  • Join Invoice Statement by Month to Client and Bill-to Client for the Billable Charges Summary section.
  • Join Invoice Statement by Period End Date to Client and Bill-to Client for Billable Charges - Detailed section.

If you want to add any data items to these sections, they must come from their respective joined packages under the Data Items tab.

When this report is modified, you are greeted with a prompt for a date range. This prompt is a validation check, the dates can stay the same and you can click OK to continue.