Fish Ticket Manager
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. 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.
Fish Ticket Manager
This email address is being protected from spambots. You need JavaScript enabled to view it. 
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.