Skip to main content

00. Overview of Costs and Expenses on a Job

Job Costing>Reports>Reports List

This report can be run by selecting a Job Number range, a Debtor range or a Date range as the selection criteria working in conjunction with the Job Status options available in the Job Status drop down.
Please Note : When a Job Number range is selected the Date range is disabled.

image.png

  1. Include Branch – display branch as a column on the report
  2.  Include Internal Jobs – This is a flag on the job, by default we exclude internal jobs on report.  Put tick on to include them in report
  3. Show WIP – Future Managed Costs on Job – This displays areas in the system that has a job linked to it that has not yet been added to job.  
    a.It looks at documents that are in process or in preparation
  4. Show Financial – Shows columns related to sales figures on the job
  5. Show Excluded QT – This is a flag on the quotes which flags that the quote values for sell and cost should not be part of the calculation for budget.
    a.If ticked it means you want to include these quotes as part of your report
  6. Show % Est Cost – Shows the percentage cost figures from percentage invoices as columns on the report
  7. Show invoiced cost – displays new columns on the report to show invoiced costs
  8. Division, region and assembly have options to filter by these cost centres.
    a.There is a P next to each with a tick box which stands for Print – Show as a column on the report to display the relevant cost centre
  9. Start date – the start date of the job
    2. Est Start Date – Estimated start date which is used to work out the task activities
    3. Comp Date – Completion date – the date you want the job to finish – lets say Friday because on Monday to delivery
    4. Del Date – Delivery date – the date you want to the job to be delivered
    5. Days – the outstanding days from today to completion date
    6. Project Manager – the project manager assigned to the job
    7. Debtor code – the customer code
    8. Debtor name – the customer name
    9.Job No – The job number – click on this number to open up the manage job screen
    10. Description – the short description of the job
    11. Job status – the status of the job – Non Started, Started, Completed, cancelled or closed
    13. % Complete – the percentage of completion of the job – Budget versus managed
    14. Order No – The customer order number
    15. Quote No – The original quote number
  10. Order value - This is the quote sell value of all quotes (excluding quotes flagged as excluded)
    2. Planned cost - This is the quote cost value of all quotes (excluding quotes flagged as excluded)
    3. Planned Profit - This is the profit of the quote = Order value - Planned cost
    4. Managed – Total managed on job – actual managed items
    5. Total – The total managed WIP = Future WIP + Total managed
    6. Incurred Costs – Displays values of cashbooks and creditors journals linked to the job
    7. Job del note – the value of cost in Job delivery note before Job invoice
    a.once the delivery note is processed to invoice, value is taken out of this column
    8. Job Invoice – the cost of job invoices via Usage job invoice or Percentage job invoice
    a.If job is usage – total usage value on invoices processed
        b. If job is percentage – the estimated percentage cost value entered by the user
    9. Debtor invoice – the cost of the customer invoice done linked to the job
    10. Credit note – the cost value of the credit note linked to the job.
1. Job Invoice – the sell value of job invoices via Usage job invoice or Percentage job invoice
a.If job is usage – total usage value on invoices processed
b. If job is percentage – the estimated percentage cost value entered by the user
2. Debtor invoice – the sell value of the customer invoice done linked to the job
3. Credit note – the sell value of the credit note linked to the job
4. Total Sales = Job Invoice sell + Debtors Invoice sell - Credit Note sell
5. Outstanding T/O = Order sell Value - Invoiced sell value (if negative will not show)
6. Future Costs = Quote cost - WIP (if positive will not show) 
a.If negative, shows as a positive figure to indicate that you are creating more costs than estimated - warning
b. If positive, this indicates that your estimated cost has not exceeded actual cost
7. Future profit = Quote cost - WIP (if negative will not show)
a.If positive, shows as a positive figure to indicate that you are under your estimated cost to actual managed and therefore will see more profit
b. If negative, this indicates that your estimated cost has exceeded actual cost (will not show here but in Future costs)
8.Invoiced Cost = Job Invoice cost + Debtor Invoice cost - Credit Note cost
9. Invoiced Profit = Total invoiced sales sell – Total invoiced cost
10. Closed job costs – shows the value of costs of the closed job items
11. Job Profit = Invoiced cost - Planned quote cost – Total managed
12. Profit variance = Job Profit – Planned quote cost
13. Last memo note on job

AOrder ValueSelling Value of the quote.
BPlanned CostCosts as per the quote.
CProfitDifference between the Order Value and the Planned Cost.
DStock RequestsAll cost values of Stock Requests with the status Requested or Authorised.
EOutstanding Purchase OrdersAll cost values of Purchase Orders with the status Created or Authorised.
FGRV To JobAll cost values of GRVs with the status Preparation or Posted.
GDel. Note To JobAll cost values of Delivery Notes with the status Created.
HBOMAll cost values of a BOM item with the status Created, Pending or Active.
IPicking SlipsAll cost values of items on Picking Slips that have not been managed.
JTime Sheet WIPAll cost values of items on Job Capture that have not been processed.
KManagedAll cost values of items on a Job that have been managed.
LTOTALSum of A, B, C, D, E, F, G, H, I, J and K
MIncurred CostsAll GL Cash Books and Creditor Journals that have been posted linked to the job.
NJob Delivery NoteAll cost values of items on a Job Delivery Note.
OJob InvoiceAll cost values of items on a Job Invoice.
PDebtor InvoiceAll cost values of items on a Debtor Invoice with the status Posted.
QCredit NoteAll cost values of items on a Debtor Credit Note with the status Posted
ROutstanding Turn OverA - (O + P - Q)
SFuture CostsB – L
TFuture ProfitB – K
Back to top