# 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.
.png)
##### **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.
- **GL Link Code:** `JOBSTKWRITEOFF`
- **Description:** *Job Costing Stock Write-Off*
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.
.png)
##### **Group Link**
A Group Link must be created to support stock write-offs during job closure.
- **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.
.png)
##### **Link GL Links**
.png)
##### **Create Link under SCM**
.png)
##### **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.
.png)
##### **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
.png)
##### **GL Link Setup – Job Gain / Loss**
To manage any differences identified during final job invoicing, a new GL link must be created.
- **GL Link Code:** `JOBGAINLOSS`
- **Description:** *Job Costing Gain or Loss*
This link is used to account for any variance between expected and actual job costs (gain or loss), ensuring these differences are accurately recorded in the General Ledger.
This helps maintain clean financial reporting and proper reconciliation when closing jobs.
.png)
##### **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.
.png)
##### **GL Link**
.png)
##### **GL Link SCM Setup – Job WIP Correction**
A new GL link must be created within the **SCM (Supply Chain Management) setup** to support WIP corrections during job finalisation.
- **GL Link:** *Job WIP Correction*
This link is used when processing adjustments between **Work in Progress (WIP)** and actual job costs, particularly for percentage-based invoicing.
It ensures that any corrections are accurately recorded and aligned with the correct GL accounts, supporting proper reconciliation and financial reporting.
.png)
##### ** Example**
- Quote Created
.png)
- Do first invoice – half
.png)
- Invoice posting
.png)
- T-Accounts
.png)
- Lines are managed, but more costs are added
.png)
This means that the job has exceeded by R160-03
.png)
**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
.png)
.png)
- **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.