Dx5+QBO: Operations Batch Actions - Part II

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

1.     Recalibrate

• DISTILL x 5: The per gallon batch value is consolidated/diluted accordingly.
• Quickbooks: No action. 

2.     Cut Batch

• DISTILL x 5: The per gallon batch value is diluted accordingly.
• Quickbooks: No action.

3.     Receive Spirit

• Action: Receive Bulk Spirit
  • DISTILL x 5: The batch value is equal to the purchase price as specified
  • Quickbooks
    • The total purchase price is added to Inventory:WIP with the batch reference
    • A bill is created for the supplier with the purchase price specified
  • Action: Receive Full Barrels
    • DISTILL x 5: Batch Cost per barrel is determined by user at time of receipt.
    • Quickbooks
      • The total purchase price is added to Inventory:WIP with the appropriate references.
      • A bill is created for the supplier with the purchase price specified.

4.     Transfer Barrels in Bond

• DISTILL x 5: The total batch value for each barrel remains with the batch and is removed from the system as a bonded transfer.
• Quickbooks
  • The total value of the transfer as calculate from each barreled batch is moved from Inventory:WIP to the COGS:Bulk Spirit COGS account.
  • An invoice is created for the customer (in-bond recipient) specified and the defined sale price. 

5.     Bottle Spirit

In the case of two-step bottling, all actions will take place on Complete Bottling.

• DISTILL x 5
  • Bottled Batch Cost is determined as a percentage of the original batch volume; if the remainder is marked as lost, the bottled batch cost will be the entire original batch cost.
  • The average unit cost of all supplies used are used to calculate the sum Supplies cost.
  • A Total Packaging Cost (Bottled Batch Cost + Supplies Cost) is calculated for the entire run, with unit costs determined from the total cost.
  • All inventory packaged is added to on-hand inventory quantities. The value of
    the Total Packaging Cost is added to the Total Inventory Value of the finished product. The new average unit cost is recalculated by dividing the new total inventory value by the new total quantity of units on hand.
• Quickbooks
  • The Bottled Batch value is moved from Inventory:WIP to Inventory:Bottled Spirit as Packaging Cost.
  • The Bottling Supplies value is moved from Inventory:Supplies to Inventory:Bottled Spirit as Packaging Cost.
  • For Quickbooks Plus Only: The quantity of finished product units packaged are added to the appropriate bottled spirit product with a value of $0.00.