Step 1
Set up vessels and categories
Replace the sample vessel, supplier, ice maker, staff, species, and destination names with the names used in your operation.
Fishery Excel template
Fishery Ice Usage Log Template
Keep produced and purchased ice separate from ice issued for use. Record the vessel or destination for each issue so the stock movement has a clear purpose.
Free download
What the five-sheet workbook includes
The workbook contains a guide, settings, an ice inventory and purchases sheet, an ice usage and stock-out sheet, and a dashboard. Use the settings sheet to keep vessel names, suppliers, staff, and usage categories consistent.
File
Fishery Ice Usage Log Template.xlsx
File name: fishery_ice_usage_log_template_en.xlsx
Sheets
5 sheets
Purpose
fishery ice stock levels, purchases, usage, and costs
Record each incoming quantity with its date, stock-in ID, production or purchase type, unit price, supplier or ice maker, and responsible staff member.
Record each outgoing quantity with its usage date, purpose, vessel or destination, and responsible staff member.
Keep landing dates, fish species, catch weights, ice-to-fish ratios, and evaluation notes with the relevant usage records.
Quantity fields are labeled in kilograms, and the sample price fields use JPY per kilogram. Check the unit and currency labels before entering your own figures. Calculate amounts and balances separately, then update the dashboard manually.
How to use the workbook
Follow the ice from stock-in to use
Set up your reference lists before entering stock movements. Use separate stock-in and stock-out IDs so production, purchases, and usage remain distinguishable.
Step 2
Record ice received
Enter produced or purchased ice on the inventory and purchases sheet. Keep the quantity, unit price, and amount with the same stock-in record.
Step 3
Record ice issued
Enter the issued quantity and its purpose on the usage and stock-out sheet. Add the vessel or destination and catch details where relevant.
Step 4
Review stock movements
Compare monthly stock-in and stock-out quantities using the dashboard fields. Check the recorded balance and cumulative balance against the underlying stock records.