asg-blue-600w

FishBiz Project

Financial and business tools for Alaska commercial seafood harvesters brought to you by the Alaska Sea Grant Marine Advisory Program

Fish Ticket Manager

Herring catch. Photo credit Alaska Sea Grant.

Fish tickets are a primary source of financial and management data for your operation. Transferring ticket information to a spreadsheet helps track relative poundage of different species, sets the stage for other data such as crew shares, and serves as a crosscheck for processor year-end statements.

The Excel spreadsheet below from Alaska Sea Grant is a basic fish ticket tracking template for a hypthetical salmon operation.

Files:
Fish Ticket Manager HOT

The goals of this spreadsheet are to track and summarize species poundage recorded on fish tickets, add company/tender information and fish temperatures, note crew changes, and track tender fuel and supplies purchases. Fishermen have shared with us other ideas for spreadsheet uses: setting up formulas that automatically account for post-season price adjustments, taxes and crew percentages, tracking setnet operations with multiple permits and direct market sales. 

Download this template and customize it to your needs. Maybe you want to use a spreadsheet just to check delivery poundage against processor year-end statements or maybe summarizing income and crewshare information for your tax preparer is your priority. If you can utilize a spreadsheet while fishing, try adding columns and formulas for other items such as weather and tides, crew changes and direct market sales.

Author This email address is being protected from spambots. You need JavaScript enabled to view it. File Size 39.07 KB Download

Excel is a marvelous calculation and tracking tool, allowing you to save and review production figures in one place (on the computer or printed). With Excel, you can easily change your data tracking for the following year. If you're not familiar with Excel, consider taking a basic Excel course, locally or online. Learning how to format cells, add cells and columns, and use simple formulas for totaling, averaging, and percentages will come in handy.