Shrimp farm record keeping template
A shrimp farm record keeping template is a workbook with one row per pond per day: feeding as planned and as given, water parameters, mortality, and separate sheets for stocking, sampling, and harvest. Download it below, no sign-up, and adapt it to your ponds.
- Daily pond log, one row per pond per day
- Stocking, sampling and harvest sheets
- Excel format, English and Spanish
- Direct download, no sign-up
Download the template
Excel workbook, five sheets, with one worked example row per sheet that you delete before use.
Download (English, .xlsx)Also available in Spanish: Planilla en español (.xlsx)
No cost and no registration. The file is yours to adapt.
What is inside
- Daily pond log
- One row per pond per day: planned and actual feeding for both rations, dissolved oxygen, temperature, pH, salinity, mortality, and observations.
- Stocking
- One row per stocking event: origin, PL count and stage, pond area, and density.
- Sampling
- One row per weekly sampling: sample size, average weight, estimated survival and biomass.
- Harvest
- One row per partial or final harvest: weight out, average weight, and destination.
Why these columns
The template records feeding twice on purpose, and a few of its other choices are the difference between a record and a diary.
| Column | Why it is there |
|---|---|
| Feed planned and feed given, separately | A feed conversion ratio computed from the plan measures the plan. The gap between the two columns is where cut rations and full feed trays become data. |
| Mortality, daily | Every unrecorded mortality leaves the count high and inflates every ration calculated from it. |
| Estimated survival and biomass at each sampling | Writing the estimate down each week is what makes the harvest reconciliation an arithmetic check instead of a memory exercise. |
| Observations, free text | The note about feed trays coming back full is often the earliest signal in the whole workbook. |
What a template fixes, and what it cannot
A template fixes the layout: everyone records the same things in the same columns, and the daily discipline has somewhere to land. That is genuinely worth having, and it costs nothing.
What no template fixes is the model. The workbook still cannot roll ponds up into a farm view on its own, still cannot enforce that a transfer updates both ponds, and still lives on one laptop. Those are the structural failures covered in shrimp farm production control: where Excel breaks.
Use the template for as long as it holds. When the reconciliation starts costing real hours, that is the signal.
Frequently asked questions
What records should a shrimp farm keep daily?
Per pond, per day: the feeding as planned and as actually given, dissolved oxygen and temperature at minimum among water parameters, observed mortality, and any observation worth remembering. Stocking, sampling, and harvest events are recorded as they happen. That set is enough to compute survival, feed conversion, and growth for every pond without reconstruction at harvest.
Is the template really free to use?
Yes. Download it, adapt the columns to your ponds, and share it inside your operation. It is published by AquaOS as a working tool, and the only thing in it beyond the sheets is a link back to this site.
When does a farm outgrow the workbook?
The usual signals are dozens of ponds, more than one person entering data, transfers and partial harvests that no longer reconcile, and a farm view that has to be rebuilt by hand each week. At that point the fix is a production record that keeps pond history and rollups live, not a bigger spreadsheet.
See AquaOS on your operation
Bring a real production scenario. AquaOS is walked through on your operation, not a canned dataset.