The Job Costing module can be used to keep track of expenditure that has gone into performing a job for a customer.
Expenditure can be both inventory and service in nature, and include your own services/inventory and those of suppliers. The Job Costing module can be used to accumulate this expenditure and produce an invoice for the customer adding a margin if required.
- Familiarity with Processing a Purchase (necessary)
- Familiarity with Processing a Sale (necessary)
- Set up Accounts – including an expense account for Jobs performed (necessary)
Table of Contents
- Create a new Job
- Add Expenses to a Job
- Invoicing a Job
Creating a New Job
New Jobs are created from the production module. You will need to add an expense account for jobs performed to your Chart of Accounts before creating a new job.
Fill in the job details
The first step is to create a new job entry and enter the job details into the document header.
- Navigate to Production → New → Job.
- Enter a Job Description and a Customer. The customer details will be filled in automatically from their record but can be edited here if required.
- Choose the jobs performed Account and select a Tax Rule.
- NOTE: Once an expense account is selected, a sub-account for this job will be automatically created.
- Enter a Start Date and Completed Date (optional).
- Select the Job Status. Available options are Prospect, In Progress, Completed and Cancelled. NOTE: If the job is kept in Prospect, you will not be able to accumulate any expenses against the sub-account.
- Enter the Estimated Value of the job (optional) and the Budgeted Margin % to be added onto the expenses when invoicing your customer.
Set job milestones
Once you've completed the job header, you can move on to creating milestones, which will be used to invoice the client.
In the selected job, go to the Milestones tab.
Use + or Add more items to add milestones to the job.
For each milestone, add a Description, Comments (optional), Estimated Date and Actual Date (optional), and Status.
Save the job to begin assigning expenses to it.
Assign Expenses to a Job
Once a job and job milestones have been created, expenses can be assigned to it. Expenses can include those ordered from your own suppliers or those directly from your inventory. The margin specified in the document header will be added to these expenses when invoicing the client.
Expenses ordered from suppliers
To assign inventory and labour expenses outsourced from a supplier to a job, the purchase module is used.
To assign supplier expenses to a job:
- On the job screen, click New expense → Purchase. Alternatively, navigate to Purchase → New → Purchase.
- Fill in the purchase order document header as usual (see Processing a Purchase for more info).
- IMPORTANT: In the Inventory Account dropdown field, make sure to pick the inventory sub-account related to the specific job. If the expense has been created from the job screen, the inventory sub-account will be automatically assigned.
- Add products and services to the Purchase order as usual (see Processing a Purchase for more info).
- Authorise the purchase order as usual. Once the stock has been received, the customer can be invoiced (see below.
Expenses ordered from your own inventory
The Inventory Write-off function can be used to assign product and service expenses from your own inventory. To invoice the client directly for labour/services without adding a margin to expenses, see Create a direct invoice for labour/services.
To assign expenses ordered from your own inventory:
- Click New Expense → Inventory write-off or navigate to Production → New → Inventory write-off.
- Enter the Location of the Products and make sure to select the Expense Account associated with the job (debit account).
- Use + or Add more items to add product or service expenses related to the job, including the credit account.
- Click Complete to finish and enable invoicing the customer.
- Debit and credit transactions for the write-off can be viewed from the Transactions tab.
Assembly cost expenses can be added from the job screen or via the Production module.
To assign expenses from assembly costs:
- Click New Expense → Assembly or navigate to Production → New → Assembly.
- Enter the Location of the Products and make sure to select the Expense Account associated with the job.
- Fill out assembly details as usual. See Finished Goods Assembly for more information if required.
- Click Complete to finish and enable invoicing the customer.
Invoicing a customer
You can generate invoices for a Job from the expenses that have been assigned to it, or invoice the client directly for labour and services.
Before invoicing a customer:
- Expenses must be assigned to the correct job sub-account.
- Purchase orders must be authorised with stock received.
- Inventory write-offs must be completed.
Generate a new invoice from expenses
All expenses that have been already assigned to the job will be visible on the Job Details screen.
To generate job invoices for a customer:
- Navigate to Production → Jobs → View All.
- Select the job to invoice.
- Go to the Generate a new invoice for expenses tab.
- Select the Milestone you wish to invoice for from the dropdown menu.
- Check the boxes next to all the invoices you wish to generate for that milestone and click Generate. You can generate partial invoices for each milestone, or one invoice that incorporates all the expenses.
- You will be notified that a sale invoice has been created for this job.
An invoice will have been generated with all of the expenses for the job, plus the margin specified in the job document header. Authorise the invoice and process the sale as usual (see Processing a Sale for more information). Generated invoices can be viewed from the Invoiced tab.
Create a direct invoice for labour/services
You may wish to invoice your client manually for labour/services, without having the final total be calculated from expenses and specified margin. This is done using a service sale initiated from the Job Details screen.
Invoice labour/services directly:
- Click New Quote or navigate to Sale → New → Service Sale.
- Enter the job client details into the document header. If the quote was triggered form the job details screen, these details will be automatically filled in.
- Add labour/service items to the sale. See Service Sale for more information.
- Authorise the service sale invoice. It will then be visible on the Invoiced tab of the Job.
Link expenses to an existing invoice
You may have expenses assigned to a job which are already covered by a previous invoice. These can be linked to an existing invoice generated for the job.
NOTE: This function merely creates a logical link to ensure accounting transactions are correct. Linking expenses to an existing invoice does not add lines to the invoice.
Link expenses to an existing invoice:
- On the Job Details screen, go to the Link expenses to an existing invoice tab.
- Select a Milestone, and choose the Sales Invoice you wish to link the expenses to from the dropdown list.
- Check the box next to the relevant expenses and click Link.
- The linked expenses vanish from the job details screen, and the logical link is created.
Rather than manually invoicing every expense, DEAR also gives you the option to automatically generate invoices for a job at regular intervals. Automatically generated invoices will still have to be authorised as usual.
To set up auto-invoicing:
Select the job you wish to set up auto-invoicing for.
In the document header, check the Auto Invoice box. This allows you to also pick an Invoice Date and Invoice Frequency.
Save the Job to finish.