Dx5+QBO: Operations Batch Actions - Part I

Please Note: All gallons refer to physical (wine) gallons

1.     Start New Batch (with Recipe Application)

• DISTILL x 5
  
  • Quantity of raw materials added are multiplied by their respective average unit costs, and the total value of raw materials added are applied to the batch, thus creating the batch cost.
  • The consumed inventory is depleted from totals. Average unit cost remains static and total inventory value decreased by the value applied to the batch.
• Quickbooks
  • The value of inventory consumed by the new batch is moved from Inventory:Ingredients to Inventory:WIP. It will stay here until it is lost, bottled, or sold.
  • Journal entries for these transactions will indicate batch name.
  • For more details on how Dx5 gives inventory values to Quickbooks, please see Inventory Transactions.

2.     Add Material

This is the same process as a New Mash/Cook with Recipe Application, for Recipe, Formula, or Single Material.

3.     Batch-to-Batch Transfer

• DISTILL x 5
  
  • The batch cost is divided proportionately by the transferred wine volume; for example, if a batch has a total cost of $500 and a volume of 100 gallons, a transfer of 60 gallons will have a batch cost of $300.
  • If the batch size shrinks in transfer (the remainder is marked as lost) the entire batch value will be divided among the remaining volume.
• Quickbooks: No action

4.     Dump

• DISTILL x 5
  
  • Action: Partial Dump: No change to batch value.
  • Action: Full Dump The entire batch value stays with the batch.
• Quickbooks
  • Action: Partial Dump No action
  • Action: Full Dump The entire batch value is moved from Inventory:WIP to COGS:WIP Loss as a Cost of Goods Sold value.

5.     Add Spirit: See Transfer

6.     Withdraw Spirit

• Action: Withdraw Entire Contents
  • Withdrawal Type: Withdraw Spirit
    • Reason: Withdrawal for Research or Destroyed
      • DISTILL x 5: The entire batch value stays with the batch
      • Quickbooks
        • No sale log is created
        • The entire batch value moves from Inventory:WIP to COGS:WIP Loss
    • Reason: Withdrawal for any other reason
      • DISTILL x 5: The entire batch value stays with the batch
      • Quickbooks
        • If Bulk Spirit Income is recorded, the batch value moves from Inventory:WIP to COGS:Bulk Spirit COGS account and a customer invoice is generated with the recorded sale price
        • If Bulk Spirit Income is not recorded, the batch value moves from Inventory:WIP to COGS:WIP Loss
  • Withdrawal Type: Transfer Out in Bond
    • DISTILL x 5: The entire batch value stays with the batch
    • Quickbooks
      • The batch value moves from Inventory:WIP to COGS:Bulk Spirit COGS account
      • A customer invoice is generated with the recorded sale price
• Action: Partial Withdrawal
  • Withdrawal Type: Withdraw Spirit
    • Reason: Withdrawal for Research or Destroyed
      • DISTILL x 5: The value attached to the withdrawn volume is lost. The remaining volume retains the remaining value.
      • Quickbooks
        • No sale log is created.
        • The value of the partial withdrawal moves from Inventory:WIP to COGS:WIP Loss.
    • Reason: Withdrawal for any other reason
      • DISTILL x 5: The value attached to the withdrawn volume is lost. The remaining volume retains the remaining value.
      • Quickbooks
        • If Bulk Spirit Income is recorded, the withdrawn batch value moves from Inventory:WIP to COGS:Bulk Spirit COGS account and a customer invoice is generated with the recorded sale price.
        • If Bulk Spirit Income is not recorded, the withdrawn batch value moves from Inventory:WIP to COGS:WIP Loss.
  • Withdrawal Type: Transfer Out in Bond
    • DISTILL x 5: The value attached to the withdrawn volume is lost. The remaining volume retains the remaining value.
    • Quickbooks
      • The transferred batch value moves from Inventory:WIP to COGS:Bulk Spirit COGS account
      • A customer invoice is generated with the recorded sale price