Get Valuable Insights in Seconds with WorkBook's Job Reconciliation Report

January 10, 2024
Mike McLean
Mike McLean
Product Director
Get Insights with WorkBook's Job Reconciliation Report

Monitoring project performance is an integral part of project management in an advertising agency. By tracking and reporting on project performance, project managers can ensure that the actual effort of the project aligns with the planned effort, which helps to deliver creative projects on time and within budget.

Deltek WorkBook is a rich source of valuable job and project data to help project managers understand performance and take appropriate action. Whether it's the number, cost and sales value of hours worked on a job, the cost of additional purchases related to delivering that work, or the original (perhaps long forgotten) budget project teams are working towards, all of the valuable project accounting data is held within WorkBook. However, this information can be challenging to collate from across modules. The new Job Reconciliation report solves this problem by consolidating all pertinent job details into one place.

The Job Reconciliation report, released as part of the latest version of WorkBook, is a testament to client feedback. We heard your frustration with aggregating data from multiple sources to form a complete picture. As a result, this powerful report seeks to draw all of the information and data about one job into a single report – where the account manager or project lead can have a clear overview of the job's current and future state. Now, you can easily follow a job from start to finish – from initial budget to final payment received.

For example, you might have outstanding purchase orders (POs) tied to a job in the PO module while your team members log hours against tasks in timesheets. Meanwhile, the latest change order adjusting the job budget lives in the Tasks section, and the job cost summary shows expenditures to date.

Piecing together all these disjointed pieces took considerable manual effort in the past, especially for larger jobs spanning multiple months and with many tasks and purchase records tied to them.

The Job Reconciliation report eliminates this headache by aggregating the data in a structured way tailored to job progress. The report springs to life as soon as a job is created and budgeted, capturing all subsequent costs, invoices, and revenue tied back to the job.

The Job Reconciliation report provides a clear overview of the job's current and future state in a single report. 

Key Benefits of the Job Reconciliation Report

  • A single view of the job lifecycle from budget to payment: No more hassle aggregating data from multiple pages; the reconciliation report connects the dots for you.
  • Logical flow matching job stages: Sections are structured to match how jobs naturally progress, making information intuitive.

This methodical progression from budgeting to invoicing to payment provides complete oversight into each job's lifecycle. The automation lifts significant manual reporting off your shoulders so you can get back to delivering, rather than documenting, exceptional client work.

Whether you're a project manager monitoring a job's health or a finance user analyzing costs, the new Job Reconciliation report is a game changer.


Learn more about WorkBook's Job Reconciliation Report

Q4 Customer Town Hall

Watch on Demand