Records Reports
The following Record Reports are available in Costing:-
Project Provides a List of all the Project Records held on file.
Project WIP Provides a landscape format report that details the current Work in Progress.
Cost Centre Prints a listing of all the Cost Centres in use within the System.
Groups Provides a report that totals Cost Centres by Group levels.
Resource List Prints a list of all Resources that have been entered.
Difference Offers a wide variety of Budget comparisons including or excluding Cost Centre information.
Scheduling Calculates and displays the latest start time for Projects and Cost Centres based on the Required By Dates and Duration you have entered.
Cashflow Tabulates all of the key financial information for each Project including cash actually expended and received for each Project (and Cost Centres).
The main buttons like Print and Ignore Search etc. are described under the Project option only.
The Project, Cost Centre, Groups and Resource List options all display a window that allows selection of various report options that change the format of the basic Report.
General Options
General options available on these reports:
Full Details | Adds general information about each Record, such as the Date each Record was first entered and last changed etc. |
Notes | Adds any entries that have been made in the Notes window. |
New Page for each Record | Ensures that the System puts just one Record on each page. |
Project and Cost Centre reports
Values | Displays a series of additional options that allow financial values to be included on the Report: |
Estimate Costs | Adds a line for each Record, detailing any Original and Revised Estimate Costs, plus a breakdown between Resource and Cost Centre Uplift. |
Estimate Sales | Adds a line for each Record detailing any Original and Revised Estimate Sales. |
Estimate Difference | Adds further line for each Record detailing the difference between any Original and Revised Estimate Sales and Costs. |
Actual Costs | Adds a line detailing any Actual Costs, plus a breakdown between Resource and Cost Centre Uplift. |
Actual Sales | Adds a line detailing Sales Transactions. |
Actual Difference | Adds another line of information detailing the difference between Actual Sales and Costs. |
You can also print the list of projects and cost centres based on their status such as Estimate, Active, Suspended etc. This can be done by clicking the Simple Search button and selecting the statuses.
Project List only
Other Options available on the Project List only :
User Keys | Adds the description and contents of the six User Key fields. |
Turnover Costs | Adds Turnover information for all thirteen periods of this, last and previous years. |
Cost Centre only
Other Options available on the Cost Centre List only :
Show Full Names | Prints the full Cost Centre and relevant Project Record Names. |
Project Full Details | Prints the Project details for each Cost Centre. This option will only be active when the Subtotal option for the Project Code is selected and a Sort Order number has been entered. |
Values | Available only on the Cost Centre List: |
Time Quantity | This option prints the total Time Sheet Transaction quantities for both Actual and Budgets that have been entered against the Cost Centre. |
Project WIP
This report printed in Landscape mode, gives the following details for each Project:
Project Code
Project Name
Actual Costs
Actual + Committed Costs
Actual Sales
Actual + Committed Sales
Difference
WIP
Groups List
Other Options available on the Groups List only :
Show Names | Will display the full name for each Cost Centre and associated Project. |
Suppress Cost Centre Detail | Will print subtotals only. This allows you to print subtotals in a summarised format without printing all the individual Cost Centres that are included within the total. |
Values | Displays additional options that can be selected: |
Estimate Costs | Will add the fields for Estimated Costs. |
Actual Costs | Will add the fields for Actual Costs. |
Time Sheet Quantity | Will add the fields for Time Sheet Hours. |
Compare Est/Act | Will add a field that shows the difference between the Estimated Costs and Actual Costs. |
Resource List
Other Options available on the Resource List only :
Base Price | Displays the Base Price on the report. |
Costs/Qtys | Displays the quantity and value of hours entered for the Resource for every period in the Current, Last and Previous Years. |
All Prices | Displays all ten charge out prices and their uplifts. If the Multi Currency Module is installed there is the option of printing the Home only or Home and Currency Prices. |
Difference Report
The Difference Report can be printed at either Project or Cost Centre level.
The format and options for both reports are very similar; although the Cost Centre Report has the added facility of sorting and subtotalling by Project, (in which case Project information can be printed in the Subtotal section of the report). It also displays a window that allows selection of options that change the format of the Differences report. If none of the options are selected the system will print a report that shows the Cost Centre Code and the Project Code.
Show Report With:
Full Names - Adds two extra lines to show the full Cost Centre and Project Name for each record printed in the report.
Full Details - Adds the Description, Customer Name and Date fields.
User Keys - Adds the description and contents of the User Key fields.
New Page for each Record - Ensures that the system starts a new page for each Record.
Initial Comparisons:
Costs/Original Budget - Adds a line for each Record comparing any Original Budget Costs plus Uplift to any Actual Costs plus Uplift.
Costs/Revised Budget - Adds a line for each Record comparing any Revised Budget Costs plus Uplift to any Actual Costs plus Uplift.
Sales/Original Budget - Adds a line for each Record comparing any Original Budget Sales to any Actual Sales.
Sales/Revised Budget - Adds a line for each Record comparing any Revised Budget Sales to any Actual Sales.
Un-recoverable - Adds a line showing the total of Cost Transactions that have been allocated as Un-recoverable.
Extra Work - Adds a line showing the total of Transactions that have been allocated as Extra Work.
More Comparisons:
Original Budget Costs/Sales - Original Budget Costs, (detailing Cost and Uplift separately), to any Actual Sales.
Revised Budget Costs/Sales - Revised Budget Costs, (detailing Cost and Uplift separately), to any Actual Sales.
Committed Costs/Sales - Committed Costs, (there is no uplift calculated or displayed for Committed figures), to any Committed Sales.
Actual Costs/Sales - Actual Costs, (detailing Cost and Uplift separately), to any Actual Sales.
Total Costs/Sales - Total Costs, (calculated as Actual + Committed Costs), to any Total Sales, (calculated as Actual + Committed Sales).
Scheduling report
This report calculates and displays the latest Start Time for Projects and Cost Centres, based on the Required By dates and the Duration that you have entered. The format of both reports is very similar; although the Cost Centre report can show the Project Name and the Notes field, and has the added facility of Sorting and Sub-totalling the Cost Centres by Project (in which case Project information can be printed in the Sub-total section of the report).
A selection window for changing the report is displayed. If none of these options are selected, then the report will show the Cost Centre Code, and the Project Code (only at Project level), and the Date Required, the Duration (in days / weeks / months etc.), and the Last Start Date. The options for searching and sorting are similar to the Project and Cost Centres reports.
Cashflow report
This report tabulates all the key financial information for each Project, including cash actually expended and received for each Project.
The Cashflow report displays a selection window for changing the report. If none of these options are selected, then the report will show the Project Name, the values of Sales, Costs, and Differences, calculated as: (Sales - Costs). The options for searching and sorting are similar to the Project and Cost Centres reports, with the exception that if Cost Centre is selected, Cost Centre information will be printed in addition to Project information.