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
Less:
(Total Gross Profit Earned to Date)
(Direct Costs to Date)
Over (Under) billed amount
-
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:
-
Choose the Over/Under Billings icon from the PJC Analytical Reports folder.
-
Specify report options using the following fields:
-
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.
-
-
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.
-
Click Print.
Related Topics