Sheets
5
Separated workflows
Fishery Excel Template
Download the Catch Log & Landing Record Template for free. Record fishing trips, landings, catch weights, and sales in one workbook.
Consultation
We can help you decide which catch logs, landing records, sales summaries, and master lists to keep in Excel and which to move to the web. We can also adjust the columns to match your current registers.
We can adjust the columns to match your current ledger format.
A free Excel template for recording fishing trips and landings, maintaining vessel and species lists, and reviewing catch weights and sales on a dashboard.
Catch Log
Landing Record
Sales Analysis
Master Lists
Workflow
Traceable
Visualize status
Entry
Easy to share
Easy for daily use
Input Example
Align the baselines first
Aligning core fields first keeps daily reviews stable.
Landing Time
2026-04-18 05:20
Species
Mackerel
Vessel
Vessel A
Status
Landed
Free Download
Check what is inside the Excel version first
This five-sheet workbook includes instructions, a dashboard, catch logs, landing records, and settings with a species master. Start by registering your vessels, species, and landing markets.
File
Catch Log & Landing Record Template.xlsx
File name: fishery_catch_log_landing_record_template_en.xlsx
Sheets
5 sheets
Use Case
Catch logs, landing records, sales analysis, and master lists
Link catch logs and landing records to make it easier to check each trip’s catch and sales.
Keep fishing conditions, estimated catch, actual landing weight, and notes in the same workbook for later review.
Review catch weight, sales, average unit price, and species shares on the dashboard.
Start by registering vessels, species, standard prices, and landing markets on the settings sheet.
How to use the Excel sheet
How to operate in Excel
Set up the master lists, record fishing trips and landings, then review the dashboard. Using the same sequence helps keep records consistent.
Step 1
Set Up Master Lists
Register vessel names, species, standard prices, and landing markets before recording trips.
Step 2
Record Fishing Trips
Enter the fishing date, vessel, method, area, weather, tide, and estimated catch for each trip.
Step 3
Record Landings
Enter actual landing weights, unit prices, and slip numbers by species, then review the calculated sales amounts.
Step 4
Review Results
Review catch weights, sales, average unit prices, and species and monthly trends on the dashboard.
Excel-to-Screen Mapping
Which Excel elements map to which screens?
Mapping the data structure directly to screen designs makes the operational workflow much easier to understand.
Excel Element
System Element
Notes
Excel Element
Catch Log
System Element
Fishing Trip List
Notes
Keeps each trip’s vessel, fishing method, area, and estimated catch together.
Excel Element
Landing Records
System Element
Landing List
Notes
Records species, actual weight, unit price, sales, and slip numbers for each landing.
Excel Element
Settings and Species Master
System Element
Master Data Settings
Notes
Maintains vessels, species, standard prices, and landing markets used in dropdowns.
Excel Element
Dashboard
System Element
Sales Analysis
Notes
Summarizes catch weights, sales, average prices, and species shares.