Inventory Costing Recalculations
Inventory costing recalculations are an adjustment. The adjustment corrects inventory costing values when transactions are inserted into or removed from an existing series of transactions.
When you enter a series of purchases, sales or adjustments for a particular item over time, you have a specific costing history for that item. The inventory costing values need to be recalculated each time there is a change to the costing history of a particular item.
For example, you receive an order of widgets into inventory. The cost of each widget in that shipment affects the costs that show when you sell widgets after the receipt date. You might encounter this scenario:
-
January: Receive 100 widgets at a cost of $10.00.
-
January: Sell 10 of those widgets.
You now have 90 of the $10 cost items remaining in stock.
-
March: Receive 100 more of the same widget, now priced at $12.
The average cost of the widgets is calculated from the date of receipt forward. If you insert a sales transaction dated prior to the March receipt, the item on that transaction uses the $10 average cost. Any sales entered with a date after the March receipt uses the $12 average cost.
Item records can show the status of cost accounting calculations. For more information, see Cost Accounting Status on Item Records.
Inventory Costing Recalculation Examples
The following examples use Average Costing.
The first table shows purchase and sale transactions existing for an item on 7-1-2021:
|
Date |
Transaction Type |
Quantity |
Cost |
Total |
On hand Quantity |
On hand Value |
Average Cost |
|---|---|---|---|---|---|---|---|
|
6-1-2008 |
Purchase |
10 |
$5.00 |
$50.00 |
10 |
$50.00 |
$5.00 |
|
6-15-2008 |
Buy |
10 |
$6.00 |
$60.00 |
20 |
$120.00 |
$6.00 |
|
6-30-2008 |
Sell |
1 |
$5.50 |
$5.50 |
19 |
$104.50 |
$5.50 |
The second table shows a sales transaction dated 6-10-2021 that is entered on 7-1-2021:
|
Date |
Transaction Type |
Quantity |
Cost |
Total |
On hand Quantity |
On hand Value |
Average Cost |
|---|---|---|---|---|---|---|---|
|
6-1-2008 |
Purchase |
10 |
$5.00 |
$50.00 |
10 |
$50.00 |
$5.00 |
|
Insert a transaction here that sells 1 item on 6-10-2015. |
|||||||
|
6-15-2008 |
Buy |
10 |
$6.00 |
$60.00 |
20 |
$120.00 |
$6.00 |
|
6-30-2008 |
Sell |
1 |
$5.50 |
$5.50 |
19 |
$104.50 |
$5.50 |
The final table shows how the inserted sales transaction affects the cost recorded for the item:
|
Date |
Transaction Type |
Quantity |
Cost |
Total |
On hand Quantity |
On hand Value |
Average Cost |
|---|---|---|---|---|---|---|---|
|
6-1-2008 |
Purchase |
10 |
$5.00 |
$50.00 |
10 |
$50.00 |
$5.00 |
|
6-10-2008 |
Sell |
1 |
$5.00000 |
$5.00 |
9 |
$45.00 |
$5.00 |
|
6-15-2008 |
Buy |
10 |
$6.00000 |
$60.00 |
19 |
$114.00 |
$6.00 |
|
6-30-2008 |
Sell |
1 |
$5.52632 |
$5.53 |
18 |
$99.54 |
$5.52632 |
Related Topics
- Inventory Costing Recalculations on Inventory Adjustments
- Setting Inventory Costing Preferences
- Costing Methods
- Selecting a Default Cost of Goods Sold (COGS) Account
- Inventory Costing and Assembly Items
- LIFO/FIFO Inventory Costing and Advanced Receiving
- System Cost of Goods Sold Adjustments
- Viewing Inventory Reports
- Inventory Costing Recalculations
- Troubleshoot Inventory Costing
- Item Return Costing
- Group Average Costing
- Standard Costing
- Item Costing