Over/Under Billings Report

The Over/Under Billings report provides a breakdown of your costs versus billings by contract or by contract and project, depending on the options you choose for the report.

Print the report to determine the progress of your billings before and after generating billing worksheets.

Features

The report includes columns that show, for each contract and (if you printed the report by contract and project) for each project listed on the report:

  • The contract code and project code.
  • The estimated revenue and estimated cost.
  • The amount billed to date and the actual costs.
  • The estimated cost to complete each project, and the percentage complete for each project.
  • The current estimated overall profit or loss (the estimated revenue less the estimated costs).
  • The profit or loss earned to date (the actual costs less the amount billed to date).

  • The amount over-billed or under-billed for each project.

    Over (under) billed amounts are calculated as follows:

    Billed To Date - (Total Gross Profit Earned to Date + Direct Costs to Date)

  • Any unearned profit or loss.
  • In a multicurrency system, if you print the report in customer currency, all the projects for a contract are grouped and subtotaled by currency.

To print the Over/Under Billings report:

  1. Choose the Over/Under Billings icon from the PJC Analytical Reports folder.

  2. Specify report options using the following fields:

    • Print By

      Select the level of detail you want to include on the report. You can choose:

      • Contract, to restrict the report to amounts for each contract in a selected range.
      • Contract And Project, to print amounts for contracts and the projects assigned to those contracts, for the specified ranges of contracts and projects.
    • Contract From/ToClosed Specify the range of contract numbers to include on the report.
    • Project From/ToClosed These fields appear only if you selected Contract And Project in the Print By field. Specify the range of project numbers to include on the report.
    • Customer Number From/ToClosed Specify a range if you want to restrict the report to a range of customers. If you do not specify a range, the program includes contracts for all customers for the specified range of contract numbers.
    • Contract Start Date/ToClosed Select a range of contract start dates, if you want to restrict the report to contracts that began within the specified range of dates. (If you do not specify a range, the program prints the report regardless of the contract start dates.)
    • Project Start Date/ToClosed These fields appear only if you selected Contract And Project in the Print By field. Select a range of project start dates, if you want to restrict the report to project that began within the specified range of dates. (If you do not specify a range, the program prints the report regardless of the project start dates.)
    • Contract StatusClosed If you want to restrict the report to contracts with a certain status, specify the status in this field.
    • Project StatusClosed This field appears if you selected Contract And Project in the Print By field. If you want to restrict the report to projects with a certain status, specify the status in this field.
    • Include Labor AmountsClosed Select this option to include labor burden amounts in the report cost totals. If you do not select this option, the report will exclude labor burden from the cost totals.
    • Include Overhead AmountsClosed Select this option to include overhead amounts and the amounts from overhead categories in the report cost totals. If you do not select the option, the report will exclude all overhead amounts from the costs totals.

    • Use

      Your selection for this field determines whether the program calculates the over- or under-billings based on the direct costs and gross profit for the current percentage complete or for the percentage complete used in the last billing.

    • Print Amounts InClosed This field appears only if you have a multicurrency system. Specify whether to print the report in your customer's currency or in your functional currency.
  3. Click Print.