Vinsight | Action | Operation | Reports | Data Sources | Xero Action |
Purchase Dry Goods
| Purchase Order ‘Receive’ - Adds product to Inventory Purchase Order ‘Post’ - Sends data to Accounts | Purchases by Product Cost of Goods Purchased Stock on Hand | Purchase Order/ Sub Totals Dr Dry Goods = SubTotal Dr Sales Tax = Sales tax Cr Accounts Payable = Total | Post Purchase Order | |
Grower Operations | Addition (Type - Grower)
| Grower Operation Additives (Journal) Operation Additions History Operation Quantities and Costs report | Cr - Grower Additives Dr - Fruit WIP | Post Journal from report | |
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 on Hand | Purchase Order/ Sub Totals Dr Bulk WIP = SubTotal Dr Sales Tax = Sales tax Cr Accounts Payable = Total | Post Purchase Order |
Purchase Fruit
| Purchase Order of non-inventory item “fruit” linked to Operation to Process | Operation to Process fruit into vessel | Harvest Histories | Purchase Order/ Sub Totals 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 | Create Manual Journal Manually | |
Additions
| Addition (Type - Bulk Operation)
| Bulk Operation Additives (Journal) Vessel Composition Bulk on Hand Cost Summary | Cr - Dry Goods Dr - Bulk WIP | Post Journal from report | |
Overheads
| Create Component Allocation | Component Allocation/ How Much Cr Holding Account = Total Dr Bulk WIP = Total | Post Journal from Component Allocation | ||
Sale of Bulk WIP | 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/Sub Totals Cr Revenue = Sub Total Cr Sales Tax = SalesTax / GST Dr Accounts Receivable = Total | Post Sales Order |
Packaging - Bulk WIP to Finished Goods
| - Complete Packaging Operation in real time - Review and post Bottling Journal for the period at the end of the period | Packaging
| Packaging Additions History Bottling Journals (Journal) | Stock Item/ Finished Item Components/View Composition/ Cost Summary- Cr Bulk WIP = Total Cost - Packaging Cost. Cr Dry Goods = Packaging Total Cost Dr Finished Goods = Total Cost Or Packaging Operation | Post Journal from report |
Packaging - Pack to Pack
| - Complete Packaging Operation in real time - Review and post Bottling Journal for the period at the end of the period | Packaging
| Packaging Additions History Bottling Journals (Journal) | Once operation updated can find total packaging costs for stock item by doing following: Stock Item/ Finished Item Components/Composition/ Cost Summary- Cr Unfinished Goods = Total Cost - Packaging Cost. Cr Dry Goods = Packaging Total Cost Dr Finished Goods = Total Cost | Post Journal from report |
Sale of Inventory Items | Despatch Sales Order - Depletes finished goods inventory | Sales by Product Stock on Hand | Sales Order/Sub Totals Cr Revenue = Sub Total Cr Sales Tax = SalesTax / GST Dr Accounts Receivable = Total | Post Sales Order | |
Cost of Sales Journals | Review and post Cost of Goods Sold/Delivered (COGS) journal at the end of the period | Cost of Goods Delivered or Sold (Journal) | Cr - Finished Items Dr - Cost of Sales Expense | Post Journal from report |