Skip to content
Request a demo
EN

GControl team · Infonet Consultores5 min read

Person working on a laptop at a wooden table next to a mobile phone and a notebook with a pen

In many technical service companies, two worlds coexist without talking to each other. In the workshop and the technical office there are work reports, delivery notes for materials and quotes. In administration there is the accounting, with its invoices, its ledgers and its year-end close. Each gives its own version of how the company is doing, and they do not always agree. This article explains what is worth connecting between work reports and accounting, in what order, and what checks to carry out so that the management figures and the accounting figures look alike.

Why management and accounting figures do not match

Accounting records what has been invoiced and what has been paid or is owed. Job management records what has been done and what it has cost. They are two different views of the same thing, and they drift apart for well-known reasons:

  • Jobs that are finished but have not yet been invoiced.
  • Invoices issued without the job code, so nobody knows which order they belong to.
  • Materials purchased that go into accounting as an expense but have not been allocated to any job or recorded in stock.
  • Hours that appear in payroll but not in the work reports, or the other way round.
  • Invoices and delivery notes that are keyed in twice, once in each program, with mistakes in one of them.

None of these problems is solved simply by having better accounting software. They are solved with a workflow in which each piece of data is entered once and travels with its code.

The workflow worth setting up

A sensible workflow for a company that works on a job-by-job basis follows this order:

  1. Quote with a code. The quote carries its job code from the start.
  2. Open job. Once the customer approves it, the job is opened to receive hours and materials.
  3. Work reports. Hours are allocated to the job and valued by professional category.
  4. Materials. Purchases are assigned to the job or to stock; stock issues and adjustments are allocated to jobs.
  5. Delivery notes and invoices for the job. They are issued from the same system that knows about the job, with its code.
  6. Accounting. Invoices pass to the accounting system through a link, without being keyed in again.

The key point is the fifth: if the invoice comes from the same place where the hours and materials are held, you already know which job it belongs to and can calculate its margin without cross-referencing data by hand.

What each part of the company gains

WhoWhat they gain from the connected workflow
OperativesA single report that serves both their payroll and the job
Technical officeThe real cost of each job while it is under way
AdministrationInvoices that are not keyed in twice and that arrive with their job identified
ManagementA result per job that can be reconciled with the accounts

Work reports also feed payroll

The connection is not only with invoices. The hours in the work reports are the basis for two different things: the cost of each job and each employee's payroll. If they are recorded only once, with the start and end of the working day and the split of hours between jobs, the same data serves both. Payroll picks up the normal, overtime, public holiday and night-shift hours, and the job cost picks up those same hours valued by category.

When payroll and work reports go their separate ways, differences appear that nobody can explain: overtime paid that does not appear in any job, or jobs with more hours than were paid. In the first case, the job looks cheaper than it really was; in the second, something is being recorded wrongly. Connecting work reports with payroll and accounting closes the loop: what is paid, what is allocated and what is invoiced all come from the same source.

Month-end checks

Even when the workflow is connected, it is worth reviewing a few points every month. They are quick and avoid surprises at the year-end close:

  • Finished jobs not invoiced. List the jobs with hours or materials in the month and no invoice. Each one should have an explanation.
  • Invoices without a job. If any sales invoice is not linked to a job, find out why.
  • Purchases with no destination. Material purchases should be allocated to a job or have gone into stock.
  • Payroll hours versus work report hours. If the working time record and the work reports come from the same data, the differences should be small and explainable.
  • Stock valuation. The value of the warehouse according to the management system should be consistent with the one your accountant or accounting system uses for inventory.

An example of what gets detected

Suppose, by way of example, that the quarter's accounts show more material purchases than the sum of the material allocated to jobs plus the increase in stock. That difference is material that was bought and nobody knows where it is: either it was used on jobs without being allocated, or it is wastage that has not been adjusted, or there are delivery notes that have not been entered. Without connecting the two sides, that difference is invisible.

Common mistakes when connecting

  • Trying to connect everything at once. Start with sales invoices carrying their job code; purchases come next.
  • Keeping invoicing "manual" for some customers. Exceptions are what later fail to add up.
  • Not agreeing with your accountant which data is passed across and when.
  • Thinking the link replaces review. It automates the transfer, but someone still has to look at the month-end checks.

How GControl solves it

In GControl, quotes and jobs are coded by year, customer and type of activity, and each job has allocated to it the work reports, valued using the price list by professional category, and the materials, by direct purchase, from the warehouse or by apportionment. Its invoices and delivery notes are issued from each job, and GControl has a link with ContaSOL. The work reports serve at the same time for the working time record, for automating payroll, and for cost analysis.

You can see it on the page on cost per job, on the one on work reports and in the frequently asked questions.

More articles from the blog

See all

Contact

We'll show you GControl with your own jobs

Fill in the form and we'll call you to set up a free, no-obligation demo.