Skip to main content

Job Costing stock write off and Gain and Loss balance

Stock Write-Off & GL Allocation

When closing a job and writing off stock, the associated cost must be correctly allocated in the General Ledger (GL).

To ensure accurate financial reporting, the write-off should be posted to the Cost of Sales account using the GL code:
“Job Costing Stock Write Off.”

This ensures that any unrecovered stock used on the job is properly accounted for as a cost to the business.

  

Setup a new GL link and GL Link setup

To correctly account for stock written off during job closure, a dedicated GL link must be configured.

This link should be assigned to the appropriate Cost of Sales account in the General Ledger.

Setting this up ensures that any stock written off is accurately recorded as a cost to the business, maintaining correct financial reporting and audit tracking.

 

  • Document Type: Job Close Stock Write Off
  • Code: JOBWRITEOFF
  • Description: Job Costing Stock Write Off

This setup ensures that when stock is written off during job closure, the transaction is correctly recorded and linked to the appropriate GL account for accurate costing and reporting.

 

 

Create Link under SCM

 

 

Job Close & Stock Write-Off Process

When closing a job and processing the final invoice, any stock write-offs must be recorded using the newly created GL link.

  • Continue to use the Stock Journal Adjustment process
  • However, ensure the GL link JOBSTKWRITEOFF (Job Costing Stock Write Off) is selected

This ensures that any unrecovered stock from the job is correctly posted to the Cost of Sales, maintaining accurate financial reporting and job costing.

 

  

Percentage Invoice – WIP Correction

This process applies specifically to final percentage-based job invoices.

It is used to correct any variance between the Work in Progress (WIP) Ledger account and the stock write-off value when completing a job. These differences can occur due to timing, usage, or costing variations throughout the job lifecycle.

To support this correction, a new GL account must be set up and used during the final invoicing stage. This ensures that:

  • WIP balances are cleared correctly
  • Stock write-offs are accurately reflected
  • Financial reporting remains balanced and accurate

 

 

GL Link Setup – Job Gain / Loss

To manage any differences identified during final job invoicing, a new GL link must be created.

This helps maintain clean financial reporting and proper reconciliation when closing jobs.

GL Link Group – Job WIP Correction

A new Document Type must be created to support WIP corrections during job finalisation.

  • Document Type: Job WIP Correction

This document type is used to group and process adjustments required to correct differences between Work in Progress (WIP) and actual job costs when completing percentage-based jobs.

It ensures all WIP correction entries are clearly recorded, tracked, and linked to the appropriate GL accounts for accurate financial reporting.

 

   

 

 

GL Link SCM Setup – Job WIP Correction
  • GL Link: Job WIP Correction

It ensures that any corrections are accurately recorded and aligned with the correct GL accounts, supporting proper reconciliation and financial reporting.

 

 Example
  • Quote Created

 

  •  Do first invoice – half

 

  •   Invoice posting

 

  •  T-Accounts

 

  •   Lines are managed, but more costs are added

 

 This means that the job has exceeded by R160-03

 

Second Invoice

A second invoice was processed without managing the remaining lines, resulting in increased profit.

  • The WIP Account now reflects R800.00
  • The Stock Write-Off totals R560.04
  • This creates a difference of R239.96, representing the variance remaining in the WIP account

 

 

  • WIP Balance Correction

The balance in the WIP account must be adjusted when there is a difference between WIP and actual job costs. This typically occurs when the WIP value is higher than the actual costs recorded.

If WIP is Higher (Adjust Down):
  • Debit: WIP – R239.96
  • Credit: Cost of Sales – Job Gain/Loss – R239.96
If Actual Costs are Higher (Adjust Up – Default GL Behaviour):
  • Debit: Cost of Sales – Job Gain/Loss – R239.96
  • Credit: WIP – R239.96
Explanation

To determine the correct adjustment:

  • Calculate all estimated values posted to the WIP account for the job
  • Compare these to the actual costs posted to Cost of Sales (COS)
  • Identify the difference and process the adjustment accordingly

This ensures the WIP account is accurately balanced and reflects the true cost of the job compared to the original estimates.

 

No Comments
Back to top