Home » Financial Processes

Financial Processes

Inventory & Financial Flows
[Not supported by viewer]
Harvest
[Not supported by viewer]
Bulk Receival
[Not supported by viewer]
Additions
[Not supported by viewer]
WIP Inventory
[Not supported by viewer]
Packaging
[Not supported by viewer]
Bulk Sales
[Not supported by viewer]
Finished Item
[Not supported by viewer]
Purchase Order
[Not supported by viewer]
Overheads
[Not supported by viewer]
Sales Order
[Not supported by viewer]
Item Inventory
[Not supported by viewer]
?
[Not supported by viewer]
?
[Not supported by viewer]
?
[Not supported by viewer]
?
[Not supported by viewer]
?
[Not supported by viewer]
?
[Not supported by viewer]
?
[Not supported by viewer]
Product comes into Vinsight as either, Item Inventory (additives, packaging materials etc.) through a Purchase Order, or Work-in-Progress Inventory (fruit or bulk product) through an operation with an optional attached purchase order.

 'Operations' process and move product either within its inventory group (e.g. from one tank to another) or from one inventory group to another (e.g. from work-in-progress to finished items, or from dry inventory to work-in-progress.)

In these cases it may be journals that will be keeping the financial flows in sync with the product flows.
[Not supported by viewer]
?
[Not supported by viewer]
Text
[Not supported by viewer]

Vinsight

Action

Operation

 Reports

Data Sources

Xero

Purchase Dry Goods

   

 

Purchase Order ‘Receive’ - Adds product to Inventory

Purchases by Product

Cost of Goods Purchased

Stock on Hand

Purchase Order/ Subtotals

Dr Bulk Inventory = SubTotal

Dr Sales Tax = Sales tax

Cr Accounts Payable = Total

Post Purchase Order

Dr - Bulk Inventory

Dr - Sales Tax

Cr - Accounts Payable

Grower Operations    

Addition (Type - Grower)

  • Depletes Inventory
  • Tracks expenses by subblock

Operation Additions History

Cr - Dry Goods

Dr - Fruit WIP

Purchase Bulk Wine

 

Purchase Order of non-inventory item “bulk wine” linked to Bulk Receival

Bulk Receival linked to Operation to Receive bulk into vessel

Bulk Receivals By Wine

Bulk Wine on Hand

Purchase Order/ Subtotals

Dr Bulk WIP = SubTotal

Dr Sales Tax = Sales tax

Cr Accounts Payable = Total

Post Purchase Order

Dr - Bulk WIP

Dr - Sales Tax

Cr - Accounts Payable

Purchase Fruit

   

Purchase Order of non-inventory item “fruit” linked to Operation to Process

Operation to Process fruit into vessel

Harvest Histories

Purchase Order/ Subtotals

Dr Bulk WIP = SubTotal

Dr Sales Tax = Sales tax

Cr Accounts Payable = Total

Post Purchase Order

Dr - Bulk WIP

Dr - Sales Tax

Cr - Accounts Payable

Harvest Fruit

   

Operation to Process fruit into vessel

Harvest Histories

Harvest Entry/ Cost Information

Dr Bulk WIP - Total Cost

Cr Fruit WIP - Total Cost

Dr - Bulk WIP

Cr - Fruit WIP

Additions

   

Addition (Type - Winery)

  • Deplete dry goods inventory
  • Applies items to bulk WIP

Operation Additions History

Vessel Composition

Bulk Wine on Hand Cost Summary

Cr - Dry Goods

Dr - Bulk WIP

Overheads

   

Create Component Allocation

Component Allocation/ How Much

Cr Holding Account = Total

Dr Bulk WIP = Total

Not currently posted to Xero

Cr - Holding Account

Dr - Bulk WIP

Sale of Bulk Wine

Sales Order linked to non-inventory item “bulk wine” linked to Bulk Despatch

Bulk Despatch linked to Operation to Despatch bulk from vessel

Sales by Product

Despatch Movements

Sales Order/Subtotals

Cr Revenue = Sub Total

Cr Sales Tax = Sales Tax / GST

Dr Accounts Receivable = Total

Post Sales Order

Cr - Revenue

Cr - Sales Tax

Dr - Accounts Receivable

Packaging - Bulk WIP to Finished Goods

       

Packaging

  • Depletes dry goods inventory
  • Depletes bulk WIP
  • Adds to stock of finished goods

Packaging Additions History

Stock Item/ Finished Wine Components/View Composition/ Cost Summary-

Cr Bulk Wine = Total Cost - Packaging Cost.

Cr Dry Goods = Packaging Total Cost

Dr Finished Goods = Total Cost

Or

Packaging Operation

Cr - Bulk WIP

Cr - Dry Goods

Dr - Finished Goods

Packaging - Pack to Pack

       

Packaging

  • Depletes unfinished items
  • Depletes dry goods inventory
  • Adds to stock of finished goods

Packaging Additions History

Once operation updated  can find total packaging costs for stock item by doing following:

Stock Item/ Finished Wine Components/Composition/ Cost Summary-

Cr Unfinished Goods = Total Cost - Packaging Cost.

Cr Dry Goods = Packaging Total Cost

Dr Finished Goods = Total Cost

Cr - Unfinished Goods

Cr - Dry Goods

Dr - Finished Goods

Sale of Inventory  Items

Sales Order - Despatch

  • Depletes finished goods inventory

Sales by Product

Stock on Hand

Sales Order/Subtotals

Cr Revenue = Sub Total

Cr Sales Tax = Sales Tax / GST

Dr Accounts Receivable = Total

Post Sales Order to Xero

Cr - Revenue

Cr - Sales Tax

Dr - Accounts Receivable