The following is an overview of grain profit and loss by store receipts.
Setup
Beginning Inventory Column – Preliminary and Final Profit and Loss
Dollars
Beginning of Year Inventory value found under Grain Ledger Accounts / Grain Units tab for the commodity
Units
Beginning of Year Inventory units found under under Grain Ledger Accounts / Grain Units tab for the commodity.
Storage Liability Column – Preliminary and Final Profit and Loss
Dollars
Beginning of year units found on the Grain Ledger Accounts / Grain Units tab plus YTD units on the issued accounts minus YTD units on the bought accounts times the current price for each contract type found at Grain Ledger Accounts/Grain Units or Grain Inventory Report – Current Price page minus Unpriced Assembly value found at Grain Ledger Accounts / Grain Units or Grain Inventory Report – Current Price page minus Priced Assembly value found at Grain Ledger Accounts / Grain Units or Grain Inventory Report – Current Price page.
Units
Beginning of year units found on the Grain Ledger Accounts / Grain Units tab plus YTD units on the issued accounts minus YTD units on the bought accounts for each contract type. It can also be found on the Grain Inventory Report – Current Price page as a total of all the contracts’ value.
Closing Inventory Column – Preliminary and Final Profit and Loss
Dollars
Beginning Inventory plus Received Units minus Sales minus Redelivered minus In-Transit multiplied by the current price found on the Grain Ledger Account / Grain Units tab. It can also be found on the Grain Inventory Report – Current Inventory page. If the DPR has been overridden, the DPR number entered on the Grain Ledger Account / Grain Units tab multiplied by the current price will be used.
Units
Beginning Inventory plus Received Units minus Sales minus Redelivered minus In-Transit. It can also be found on the Grain Inventory Report – Current Inventory page. If the DPR has been overridden, the DPR number entered on the Grain Ledger Account / Grain Units tab will be used.
Receipts Column – Preliminary Profit and Loss
Dollars
Purchase account plus Bought account plus Change in Company Owned Inventory (Calculations for the Change in Company Owned Inventory are from the Grain Inventory Report to generate the JE.)
Change in Company Owned Inventory equals Beginning Company Owned Inventory minus Current Company Owned Inventory
Beginning Company Owned Inventory equals Beginning Inventory
- minus Beginning Storage
- minus Beginning Priced Later
- minus Beginning Grain Bank
- minus Beginning Basis Fixed
- minus Beginning Future Fixed
- minus Beginning Minimum Priced
- minus Beginning Hedge-to-Arrive.
All the information can be found at Setup/Grain Ledger Accounts / Grain Units tab or the Grain Inventory Report / Beginning of Year Inventory Pricing page.
Current Company Owned Inventory equals Current Inventory (found on the Grain Inventory Report / Current Inventory Pricing page)
- minus Current Storage (Grain Inventory Report / Current Inventory Pricing page)
- minus Current Priced Later (Grain Inventory Report / Current Pricing page)
- minus Current Grain Bank (Grain Inventory Report / Current Pricing page)
- minus Current Basis Fixed (Grain Inventory Report / Current Pricing page)
- minus Current Future Fixed (Grain Inventory Report / Current Pricing page)
- minus Current Minimum Priced (Grain Inventory Report / Current Pricing page)
- minus Current Hedged-to-Arrive (Grain Inventory Report / Current Pricing page)
- minus Open Assembly value (Grain Inventory Report / Assembly & Intransit page)
- minus Priced Assembly value (Grain Inventory Report / Assembly & Intransit page)
- plus In-Transit Inventory Value
- plus In-Transit Adjustment
In-Transit Inventory Value equals
- In-transit Sold current units plus In-transit Priced Later current units times current price.
- All of this information can be found at Setup / Grain Ledger Accounts / Grain Units tab.
In-Transit Adjustment equals the difference between the In-Transit Inventory Value3 and the Value of In-Transit
Value of In-Transit equals In-transit Sold current units times In-transit Sold price plus In-transit Priced Later current units times In-transit Priced Later price. All of this information can be found at Setup / Grain Ledger Accounts / Grain Units tab.
Units
YTD Purchase Account units plus YTD issued account for each contract type plus Unpriced Assembly units found at Grain Ledger Accounts / Grain Units tab plus Priced Assembly units found at Grain Ledger Accounts / Grain Units tab.
Receipts Column – Final Profit and Loss
Dollars
Purchase Account dollars plus YTD Bought Account dollars for each contract type.
Units
YTD Purchase Account units plus YTD issued account for each contract type plus Unpriced Assembly units found at Grain Ledger Accounts / Grain Units tab plus Priced Assembly units found at Grain Ledger Accounts / Grain Units tab.
Sales Column – Preliminary and Final Profit and Loss
Dollars
Sales Account balance
Units
YTD Sales Account units
Gross Profit Column – Preliminary Profit and Loss
Dollars
Sales column minus Receipts column. Calculated as Sales account balance minus Purchase account balance minus bought account balances for each contract type minus charge in company owned inventory (calculation is found with the Receipts column).
Units
Sales column minus Receipts column. Calculated as Sales account balance minus Purchase account balance minus bought account balances for each contract type minus change in company owned inventory (calculation is found with the receipts column).
Gross Profit Column – Final Profit and Loss
Dollars
Sales column minus Receipts column. Calculated as Sales account balance minus Purchase account balance minus bought account balances for each contract type.
Units
Sales column minus Receipts column.
Calculated as Sales account balance minus Purchase account balance minus bought account balances for each contract type.
Sales Units Column – Preliminary and Final Profit and Loss
Dollars
YTD Sales Account Units
Units
YTD Sales Account Units
Margin column – Preliminary and Final Profit and Loss
Dollars
Gross Profit column divided by Sales Units column. If the Margin is by % then it is calculated as follows: Gross Profit divided by Sales Amount multiplied by 100.
Units
Gross Profit column divided by Sales Units column. If the Margin is by % then it is calculated as follows: Gross Profit divided by Sales Amount multiplied by 100.
