Marine finfish aquaculture reporting template:
Appendix 1B inventory accounting

Instructions for using this Excel template

1. Go to "step 1 - general info" worksheet.
2. Select licence holder name from drop-down list
3. Then select "Facility reference No" from the drop-down list
4. Complete the remaining columns (if applicable)
5. Go to "Step 2 - Report Details" worksheet
6. Enter data and complete the remaining columns (if applicable)

Colour meaning

Red - Mandatory field (data missing)

Grey - Do not enter

White - Enterable field

*N.B. in order to maintain data integrity, data from external sources should not be copied directly into greyed-out cells. Please input the data directly into this spreadsheet.

Step 1 - General info

Step 2 - Report details

Starting inventory = Number of fish entered into harvest facility plus total losses from smolt entry and interim marine facilities.

Note: only include mortalities, escapes and transfers of groups of fish that were harvested from to the harvest facility.

Guidance - Appendix 1B - inventory accounting template

Months fallow prior to re-entry - The number of months that the harvest facility was fallow prior to restocking of this production cycle.

Area management considerations - If applicable, describe any area management production considerations, such as single year class stocking, that the harvest facility was part of.

Facility type

• Smolt entry: A facility in which fish were entered directly into from a freshwater landbased hatchery, prior to transfer to another marine facility.
• Interim marine: a facility other than a smolt entry facility that is utilized for part of the production cycle, but not the facility that the fish were harvested from.
• Harvest: the final marine facility used to grow fish during the production cycle from which the fish were harvested from.

Number of fish transferred in - The total number of fish entered into the facility during the production cycle, from landbased hatcheries or marine facilities. Include data only for those groups of fish that were harvested from the harvest facility.

Number of fish transferred out - The total number of fish transferred out of the facility during the production cycle, to other marine facilities or to landbased hatcheries. For smolt entry or interim marine facilities, include only transfers of fish that were destined for the harvest facility. For harvest facilities, include all live fish that were removed from the facility for reasons other than harvest.

Number of fish escaped - The total number of fish confirmed or suspected to have escaped from the facility during the production cycle. Include data only for those groups of fish that were harvested from the harvest facility.

Number of fish harvested - The total number of fish that were harvested from the facility during the production cycle.

Mortalities by category - In columns I to P, Enter only the mortalities pertaining to the fish that were harvested from the harvest facility, using the categories identified in the mortalities by category appendix. Example: At a smolt entry facility, if half of the pens are transferred to the harvest facility, report only the mortalities from the pens that were transferred to the harvest facility. Do not include mortalities of fish that stayed at the smolt entry facility or were transferred to another location.

Mortality total - Do not enter, the sum of columns I to P will be calculated automatically.

Mortality % - Do not enter. mortality % = mortality total / number of fish transferred in.

Description of exceptional mortality - If mortalities are higher than expected, provide an explanation of the exceptional mortality, including reasons and justification for major mortality events.

Inventory discrepency - Do not enter. Calculates the number of fish unaccounted for at the facility, or during the production cycle. Inventory discrepency = number of fish transferred in - (mortality total + number of fish escaped + number of fish harvested + number of fish transferred out).

% Discrepency - Do not enter. % discrepency per facility = inventory discrepency / number of fish transferred in % discrepency for the production cycle aummary = inventory discrepency / starting inventory.

Explanation of inventory discrepency - If the inventory discrepency is higher than expected, provide an explanation for the missing or extra fish.

Starting inventory - Do not enter. The starting inventory is used to calculate the summary mortality and inventory discrepency for the entire production cycle. Starting inventory = number of fish transferred in to the harvest facility + total losses from mortality and escapes at pre-harvest facilities.