Child pages
  • Tracking the profitability of profit centres using Jobs

 

 

ANSWER ID:9075

A profit centre is a subset of your business for which you want to track income and expenses. This page explains how to use Jobs in AccountEdge to group transactions belonging to your various profit centres. You can then track the performance of each profit centre and generate reports on them.

The purpose of Job functions within AccountEdge is to group specific transactions into a reportable item. This is accomplished by first setting up a Job for each of the profit centres. Every transaction is then allocated a job that is specific to its profit centre. Job reports are then used for reporting the activity of each of the jobs, which are a representative of your profit centres.

Sub-jobs can also be set up to further breakdown a job into separate components. This is facilitated through the use of Header Jobs under which sit Detail Jobs.

You can also use Categories to manage departments within your business. For more information see the AccountEdge help (Australia | New Zealand).

1. Select appropriate Job Names and Job Numbers
When wanting to setup Jobs, it is important to use Job Numbers and Job Names that clearly distinguish your profit centres. For instance, if you have profit centres in Southern, Eastern, and Western regions (or towns, suburbs, or buildings, etc.) you could use SOUTH, EAST, and WEST for your Job Numbers, in other words the code which will be used for the Job. The Job Name is the actual name of the job, such as Southern Region, Eastern Region, or Western Region.

When considering Job Names and Job Numbers, keep in mind:

  • Job Numbers can have a maximum of 5 alphanumeric characters.
  • Job Names can have a maximum of 25 alphanumeric characters.

Also determine if your jobs will be broken down into smaller sub-jobs. For example, a job could be set up to cover 'Manufacturing' and sub-jobs could be set up which might include 'Components' and 'Finished Goods'.

2. Set up Jobs and Sub-jobs

Once you have determined your Job Numbers and Job Names, complete the following:

  1. Go to the Lists menu and choose Jobs. The Jobs List window is displayed.
  2. Click New. The New Job window is displayed.
  3. Select the Detail Job option. Note that only Detail Jobs can be applied to transactions. A Header Job would typically be set up if sub-jobs were going to be set up to sit under it. Only Header Jobs can have sub-jobs.
  4. Enter the Job Number and Job Name.
  5. [Optional] Enter a Job Description for additional information.
  6. [Optional] Enter a Start Date for the Job.
  7. (Optional) Specify a Sub-job Of if there is a Header Job under which the new job will sit. Note that sub-jobs will need to be set up first to be available for selection at this field.
  8. Click OK.
  9. Repeat steps 2 - 8 for each new job. Refer to the image below for an example job setup.
Job Opening Balances can be entered if you are setting up your jobs mid-financial year. To enter Job Opening Balances, go to the Setup menu, choose Opening Balances then choose Job Opening Balances. Select a Job Number then enter the Opening Balance for each ledger account. 
3. Apply a job to a transaction

Each transaction window, with the exception of Receive Payments and Pay Bills, has a Job field in which a Job Number can be specified. To allocate a Job to a transaction, simply create the transaction as normal then click or tab into the Job field and select the Job representing the particular profit centre.

The window below shows a job being allocated to a sale. Note that only jobs which have been set up as Detail Jobs can be allocated to a transaction. This is not the case in BusinessBasics where all jobs can be allocated to transactions.

  • The expense of inventoried items is realised when the items are sold, and not when purchased, so applying a Job to an item sale where inventoried items are sold, will allocate both the expense and income of the items to the Job.
  • As shown below, there is a software preference (go to the Setup menu and choose Preferences) which will ensure a warning is displayed for all transactions if a Job has not been specified.
4. Report on profit centres

At the end of the reporting period, a Profit and Loss report can be generated for all jobs. Note that in BusinessBasics the report customisation window and associated fields will be slightly different.

  1. Go to the Reports menu and choose Index to Reports.
  2. Click the Accounts tab.
  3. Under the Jobs sub-heading, click to highlight the Profit and Loss report.
  4. Click Customise. The Report Customisation - Profit & Loss window is displayed.
  5. In the Jobs field, ensure All is specified.
  6. Select the report date range.
  7. [Optional] If you want to view the combined profit and loss for the selected jobs, select the Consolidated option on the Finishing tab.
  8. Click Display.
To view details of Header Jobs and related Detail (sub) Jobs, use the Jobs List report then customise it to show only the desired Jobs.
5. Report on a single profit centre

By default, the Profit and Loss report described above includes all the Jobs in your company file. To select a specific Job, click the dropdown arrow next to the Job field (highlighted in the image above), then select only the Job you want to report on. You can also choose a selection of non-consecutive Job Numbers using this method.

 

6. Check that each transaction is allocated a Job
There are two reports designed to readily identify transactions that have not been allocated a job. These are the Job Exception [Invoice Transactions] and Job Exception [Cash Transactions] reports.

These are found in the Accounts tab of the Index to Reports under the Jobs sub-heading. Click Customise to specify the date range of the transactions you want to check for missing job numbers.

To delete a job

Deleting a header job will delete its sub (detail) jobs. Also, if a job is allocated to a transaction, the allocation will be removed if the job is deleted. 

  1. Go to the Lists menu and choose Jobs.
  2. Click to highlight the job to be deleted.
  3. Go to the Edit menu and choose Delete Job.
  4. If a warning message is displayed, read what it says so you understand the consequences of deleting the job then click OK.