Timesheet Entries Reports

The Timesheet Entries report shows all time and cost for the chosen criteria.

There are quite a few variations on the ‘basic’ timesheet entries report with options for lots of different filters, groups and sub-groupings.

It is often used in conjunction with the Manage WIP Screen, or the Unbilled Work Quick Summary to determine what can be billed each month.

Timesheet Entries Report

Continue reading

Subconsultant Reports By Job

The Subconsultant Reports By Job report option gives a selection of summaries of all subconsultant work for a selected job.

From one menu choice in the reports screen three types of reports can be produced – Subconsultant Fees and Costs by Job, Subconsultant Fees and Costs by Job Detail and the Subconsultant Invoice Supplement.

Subconsultants Fees and Costs by Job Report
Subconsultant Fees and Costs by Job Detail Report
Subconsultant Invoice Supplement Report
Continue reading

Unbilled Work Quick Summary Report

As the name suggests, Unbilled Work Quick Summary Report will give you a summarised report that you can run against one or all jobs, to see quickly what is outstanding out of all your billable time.

It’s a static printable report of unbilled time as of a given date. For live WIP management we recommend using Manage WIP from the Invoicing screens.

Unbilled Work Quick Summary Report
Continue reading

Sub-Consultant Invoice Listing Report

The Sub-Consultant Invoice Listing report option can be used to get a summary of sub consultant claims and invoices for all or selected subconsultants, between two dates.

You can choose to view all sub consultant invoices, just those that have been fully processed, or only those still waiting to be fully processed.

Subconsultants Invoice Listing Report
Continue reading

Clients and Jobs Reports

Reports are an important feature of Abtrac wherein the information within can be extracted and presented in a meaningful way. Reports also help list useful items and/or assess your company’s performance.

In this article, we will have a look at the ‘Clients and Jobs’ Reports, which comes first in the reports’ list. From Reports >> Performance Reports >> go to ‘Clients and Jobs’ to get a list of reports for clients and jobs.

Clients and Jobs Report Types
Continue reading

Actual vs Budget Reports

Once you have started using Tasks for your jobs/projects and timesheets, you can learn from them over time.

Tasks (also known as Stages, Phases or Matters) can be used to see how good staff are in getting through work allotted to them, as well as how good you are in your estimates.

You can analyse data entered against tasks either as hours worked or a budget amount.

Even if you don’t have a budget or estimate for a task (be it a variation, or something that you are charging at an hourly rate) it is a good idea to assign the item of work as a task to your job/project. You can leave the hours and fee value equal to zero.

Later on you can look at the actual time and cost assigned to the task and get a better idea of budgeting for the next job of the same type. Or you can use the tasks to simply know approximately how much time these variations to jobs typically take (and how they can affect staffing and scheduling of other jobs).

After using Abtrac for about 18 months, one of our clients, told us “I work out the budget very scientifically and then I add on 30%”.

He had learnt after using Abtrac for that period of time that he was under-quoting and thus writing off to that extent on nearly every job/project.

We would recommend reading this article about Actual vs Budget reports in conjunction with our Creating and Managing Tasks article, and also this one here which includes a glossary of the data within the Actual vs Budget reports.

Continue reading

Bulk Edit Timesheets

This screen is useful when you need to update timesheet details in bulk, it eliminates the need to open and edit the individual users’ timesheets.

This timesheet maintenance screen is most typically used in the following situations:

  • Updating Employee rates
  • Editing Stage/Task or Activities that have been incorrectly assigned
  • Changing the job code an employee is assigning time to
  • To check if/when timesheets have been billed and
  • To check which invoice the WIP has been assigned to
  • To obtain data not available in performance reports for specific employees, in particular, to view timesheet data for employees who are no longer current.

Continue reading

Job/Project Forecast

This feature enables you to forecast fees and resources (hours) for a period estimated in the Tasks/Stages/Phases screen.

When you provide the estimated Start date and End date of a Task, Job Forecast will disperse the estimated fees and hours within the given period on a monthly basis.

You can then edit them and forecast the resources in a way that suits your cash flow.  You can even forecast the Subtask resources for each Task.

Continue reading

Simple reports to get started with invoicing

Getting started with your invoicing normally starts with a few reports to see who you are invoicing and for how much. This can then be checked with job (project) managers to confirm they are ready to invoice the clients and if they are happy with the amounts.

There are two basic reports that can get you going. Unbilled Work Quick Summary and Timesheet Entries.

Continue reading

Actual vs Budget Reports: Data Glossary

Before you start using Actual vs Budget reports it’s useful to understand where the data they display comes from. We’ve included a definition for the relevant columns, (including an example calculation where applicable) in this article, to be read side by side with Creating and managing tasks, and Actual vs Budget Reports.

Continue reading

Invoice Listing Report

The Invoice Listing report is one of the staple reports of Abtrac, used throughout billing and in month end reporting.

Unlike a basic sales or invoice report from your accounting software, it shows time and cost assigned – giving you a more accurate representation of whether you need to worry about profit leakage.

Of course its limitation is that it only shows time and cost that has been assigned and/or recovered to the invoices listed. If your office also creates write off invoices, it will show a more complete picture.

And for true revenue analysis after the fact, it is often handy to look at the Invoice Listing Report in conjunction with unbilled work and write offs to get a complete picture.

Invoice Listing report
Continue reading

How many billable hours do you write off?

A new survey came out last month – the Trends & Challenges in Architecture and Engineering International Report 2014* and it had some most interesting (but perhaps not surprising) statistics.

Architecture and Engineering firms throughout Australia and New Zealand are missing out on invoicing up to 30 percent of billable hours. According to the survey, almost three quarters of businesses indicated they recovered only 61-80 % of billable hours.

Loss of billable hours is a common challenge for all time based billing professionals, regardless of whether you bill on the basis of time engaged or a fixed price contract. It’s a challenge that needs to be constantly managed.

Continue reading