MilkFlow — Dairy Distribution ERP

Good morning, Admin 👋

Dairy operations at a glance —

Today's Collection

2,840 L

4 suppliers

Distributed

2,100 L

9 retailers

Stock Balance

4,820 L

Above reorder

Overdue AR

₹1.2L

7 retailers

Quick Actions

🪣

Collect

Record intake

🚚

Distribute

Deliver milk

📋

Orders

Retailer orders

🧾

Invoice

Generate bill

💳

Payments

AR / AP

📈

Rate Chart

Milk prices

Today's Collections

Supplier	Qty (L)	Shift	Status
Sunrise Farm	1,200	Morning	Collected
GreenPastures	800	Morning	Collected
Nandini Dairy	500	Morning	Collected
Village Co-op	340	Morning	Pending

Today's Distributions

Retailer	Qty (L)	Time	POD
Sharma Dairy	400	06:45	Signed
Fresh Mart	620	07:10	Signed
City Milk Hub	750	07:30	In Transit
Patel Store	330	08:00	Pending

Overdue Invoices

Invoice	Retailer	Days Overdue	Amount
INV-1043	Fresh Mart	1	₹31,248
INV-1038	Ravi Dairy	3	₹18,400
INV-1035	Metro Milk	5	₹24,960

Batches Expiring Soon

Batch ID	Balance	Expiry	Status
B-2024-195	420 L	Tomorrow	Critical
B-2024-196	800 L	Tomorrow	Expiring
B-2024-197	1,500 L	3 days	Good

Milk Collection

Record incoming milk from suppliers / farms

GRN and Purchase Invoice are auto-generated on save.

Milk Collection Entry 🐄 Cow Milk

Collection Details

Collection No.

Auto-generated

Date *

Shift *

Supplier

Supplier / Farm *

Vehicle / Transport No.

Milk Details

Cow Grade *

Rate auto-fills from Rate Chart

Quantity (L) *

Rate / L (₹) *

Batch ID

Fat %

SNF %

Temp at Arrival (°C) *

Expiry Date *

Cold Zone *

Collected By *

Supplier Challan #

Financial Summary

Gross Amount (₹)

Deductions (₹)

Net Payable to Supplier (₹)

Remarks

Col #	Date	Supplier	Shift	Qty (L)	Rate	Net Amt	Zone
COL-0309	09 Jul	Sunrise Farm	Morning	1,200	₹46	₹55,200	Zone A
COL-0310	09 Jul	GreenPastures	Morning	800	₹40	₹32,000	Zone B
COL-0311	09 Jul	Nandini Dairy	Evening	500	₹52	₹26,000	Zone C
COL-0312	10 Jul	Village Co-op	Morning	340	₹38	₹12,920	Zone A

Milk Distribution

Record outgoing deliveries to retailers

Sales invoice auto-generates on POD confirmation.

Distribution / Dispatch Entry 🐄 Cow Milk

Dispatch Details

Dispatch No.

Date *

Dispatch Time *

Retailer & Order

Retailer *

Order Reference

Milk Details

Cow Grade *

Sale rate auto-fills from Rate Chart

Batch Allocation *

Qty (L) *

Rate / L (₹) *

Temp at Dispatch (°C) *

Route

Priority

Driver & Vehicle

Driver Name *

Vehicle No. *

Invoice Preview

Taxable Amount (₹)

GST 5% (₹)

Invoice Total (₹)

Proof of Delivery (POD)

POD Status

Received By (Retailer)

Delivery Time

Remarks

Dis #	Retailer	Date & Time	Qty (L)	Driver	Total	POD
DIS-0215	Sharma Dairy	06 Jul 06:45	400	Raju K.	₹20,160	Confirmed
DIS-0216	Fresh Mart	07 Jul 07:10	620	Suresh M.	₹31,248	Partial
DIS-0217	City Milk Hub	08 Jul 06:30	750	Raju K.	₹37,800	In Transit
DIS-0218	Patel Store	09 Jul 07:00	280	Suresh M.	₹14,112	Pending

Suppliers

Manage milk suppliers and farms

Supplier Registration

Basic Information

Supplier Code

Farm / Supplier Name *

Contact Person *

Mobile Number *

Email Address

GSTIN

Address *

Supply Terms

Milk Type *

Rate per Litre (₹) *

Payment Terms

Supply Frequency

Min. Order Qty (L)

Status

Notes

Code	Name	Milk Type	Rate/L	Terms	Status
SUP-001	Sunrise Farm	Full Cream	₹46	Net 15	Active
SUP-002	GreenPastures	Toned	₹40	Net 30	Active
SUP-003	Nandini Dairy	Buffalo	₹52	Net 15	Inactive

Retailer Orders

Create and manage purchase orders

Retailer Order Entry

Order No.

Order Date *

Delivery Date *

Retailer *

Route

Order Line

Milk Type *

Qty (L) *

Rate / L (₹) *

Batch

Totals

Gross (₹)

GST 5% (₹)

Net Payable (₹)

Instructions

Order #	Retailer	Date	Qty (L)	Net Amt	Status
ORD-0308	Sharma Dairy	07 Jul	400	₹20,160	Delivered
ORD-0309	Patel Store	08 Jul	280	₹14,112	On Hold
ORD-0310	City Milk Hub	09 Jul	750	₹37,800	Dispatched

Sales Invoice

Generate retailer invoices with CGST + SGST split

Sales Invoice Entry

Invoice No.

Invoice Date *

Due Date

Retailer *

Dispatch Reference

Line Items

Batch ID

Milk Type

Qty (L) *

Rate / L (₹) *

Tax & Total

Taxable (₹)

CGST 2.5% (₹)

SGST 2.5% (₹)

Invoice Total (₹)

Credit Terms

Invoice #	Retailer	Date	Amount	Due	Status
INV-1041	Sharma Dairy	06 Jul	₹20,160	13 Jul	Paid
INV-1042	Patel Store	08 Jul	₹14,112	15 Jul	Pending
INV-1043	Fresh Mart	07 Jul	₹31,248	09 Jul	Overdue
INV-1044	City Milk Hub	09 Jul	₹37,800	16 Jul	Dispatched

Payments

Retailer receipts (AR) and supplier settlements (AP)

3 retailer invoices are overdue. Collect and reconcile promptly.

Record Retailer Payment (Inbound AR)

Receipt No.

Receipt Date *

Retailer *

Invoice Reference *

Payment Mode *

Amount Received (₹) *

UTR / Transaction No.

Late Penalty (₹)

2% after 3 days overdue

Remarks

Ref #	Party	Flow	Mode	Amount	Date	Status
REC-0498	Sharma Dairy	Inbound	UPI	₹20,160	13 Jul	Settled
PV-0122	Sunrise Farm	Outbound	NEFT	₹52,000	10 Jul	Settled
REC-0499	Gupta Grocers	Inbound	Cash	₹9,072	14 Jul	Settled
REC-0500	Patel Store	Inbound	Cheque	₹14,112	—	Pending

Ledger & Reports

AR / AP aging and payment cycle summary

AR Outstanding

₹2.3L

7 retailers

AP Outstanding

₹2.1L

3 suppliers

Collected (Jul)

₹6.1L

From retailers

Paid to Suppliers

₹4.8L

NEFT settlements

AR Aging — Retailer Balances

Retailer	0–7 Days	8–15 Days	16–30 Days	Total Due	Risk
Sharma Dairy	—	—	—	₹0	Clear
Patel Store	₹14,112	—	—	₹14,112	Watch
Fresh Mart	—	₹31,248	—	₹31,248	Overdue
City Milk Hub	₹37,800	—	—	₹37,800	New

AP Summary — Supplier Balances

Supplier	GRN Ref	Due Date	Amount	Status
Sunrise Farm	GRN-0195	23 Jul	₹55,200	Pending
GreenPastures	GRN-0196	23 Jul	₹32,000	Pending
Nandini Dairy	GRN-0197	24 Jul	₹26,000	Pending

Rate Chart

Master purchase & sale rates — Cow and Buffalo milk

Full Cream

₹52/L

Buy ₹46 · +₹6

Toned

₹46/L

Buy ₹40 · +₹6

Double Toned

₹40/L

Buy ₹34 · +₹6

Skimmed

₹34/L

Buy ₹28 · +₹6

🐄 CowActive

Full Cream

Fat 3.5% · SNF 8.5%

Purchase

₹46

Sale

₹52

Margin₹6 (13.0%)

From 01 Jul 2024

🐄 CowActive

Toned

Fat 3.0% · SNF 8.5%

Purchase

₹40

Sale

₹46

Margin₹6 (15.0%)

From 01 Jul 2024

🐄 CowActive

Double Toned

Fat 1.5% · SNF 9.0%

Purchase

₹34

Sale

₹40

Margin₹6 (17.6%)

From 01 Jul 2024

🐄 CowActive

Skimmed

Fat 0.1% · SNF 9.0%

Purchase

₹28

Sale

₹34

Margin₹6 (21.4%)

From 01 Jul 2024

🐄 Cow Milk — Rate History

Rate ID	Grade	Fat%	SNF%	Purchase ₹/L	Sale ₹/L	Margin	From	Status