Lobster Trap Tracker Excel - Free Template

1. Open the Haul Log sheet and review the headings before entering your own records. The template includes fields from Haul ID through Notes, with sample rows showing the intended format.
2. Assign a unique Haul ID, such as H-001, and enter the haul date in YYYY-MM-DD format. Use a consistent ID sequence so you can locate a trip quickly during a season review.
3. Enter the vessel name, captain, LFA zone and port exactly as they appear in your operating records. For example, record LFA 34 and Yarmouth NS rather than shortening the location differently on every row.
4. Record the number of traps hauled, legal lobsters, undersized released and berried released. Enter total catch weight in kilograms and the average price in dollars per kilogram.
5. Add bait, fuel and other costs for that haul. Check that the currency fields use dollars and that weight is entered in kilograms, not pounds.
6. Review total value, net profit, catch per trap and legal rate after entering the row. Investigate an unusual result before moving on, such as 300 traps producing much less catch than the previous trip.
7. Save a dated copy after each fishing week or landing cycle. At month-end, filter or sort the log by LFA, vessel or port and compare results with landing and expense records.

A lobster fisher in Nova Scotia may sit down after landing to record a trip before the next set of traps goes out. An owner-operator with one vessel can use the log to compare ports and fishing areas, while a bookkeeper for an incorporated fishing company can use it to match catch activity with fuel and bait invoices. The same record is useful for a seasonal crew that needs a consistent handover between captain and shore office.

Record the trip while the details are fresh

Enter the Haul ID, date, vessel and captain immediately after weighing the catch. A row such as H-001 on 2026-01-12 for Atlantic Pride in LFA 34 at Yarmouth NS tells you far more than a notebook entry saying 312.5 kg. The template also records 280 traps, 195 legal lobsters, 42 undersized releases and 18 berried releases, keeping effort and release information together.

This timing matters during a busy opening or when several boats land at the same wharf. If you wait until month-end, a fuel charge of $220 may be assigned to the wrong haul and a price of $12.50 per kilogram may be copied into the next row. I prefer one row immediately after each landing, even if the cost fields are completed after the receipt is available.

Use the numbers to compare effort and return

Catch weight alone does not measure performance. A 312.5 kg haul over 280 traps gives a different operating picture from a 250.0 kg haul over 240 traps, especially when bait and fuel costs are different. The Legal Rate (%) and Catch per Trap columns help you examine the catch mix and effort rather than looking only at the cheque from the buyer.

A vessel manager with four boats can compare LFA 33, LFA 34 and LFA 35 by filtering the LFA Zone column. A treasurer or business owner can then use the haul records as supporting detail when reviewing seasonal revenue, costs and cash flow with the bookkeeper.

A haul spreadsheet supports your records; it does not replace the requirements attached to your licence. Lobster fishing in Canada is managed by Fisheries and Oceans Canada through licence conditions and LFA-specific rules. Seasons, trap limits, legal size, release requirements, tagging and reporting can differ between areas such as LFA 33, LFA 34 and LFA 35, so use the current conditions for your licence when deciding whether a lobster is legal.

Keep the log aligned with the licence

The columns for LFA Zone, Traps Hauled, Legal Lobsters, Undersized Released and Berried Released are deliberate. They let you preserve the area and release detail instead of recording only saleable kilograms. For example, a 300-trap haul with 210 legal lobsters and 45 undersized releases should not be reduced to a single number called catch. Confirm the required reporting format and deadlines with the applicable DFO fishery office or licence documents before treating this workbook as an official submission.

Do not use a province-wide assumption for minimum size or season dates. A rule that applies in one LFA may not apply in another, and a buyer's weight ticket is not a substitute for your own operational record. Water Temp (°C) and Notes can preserve context such as weather, gear issues or an unusual release count, but they do not change the legal classification of the catch.

Connect catch records to Canadian tax records

For a sole proprietor, fishing revenue and deductible operating expenses are generally reported through the business section of the personal return, commonly using T2125. An incorporated operation records the activity in its corporate books and ultimately reports through a T2. The Haul Log's bait, fuel and other cost columns should be supported by receipts and matched to the business use of the expense.

If the business is registered for GST or HST, taxable revenue is tracked separately from tax collected. Mandatory registration generally begins when worldwide taxable supplies pass $30,000 over four consecutive calendar quarters, or in a single quarter. GST is 5%; HST is 13% in Ontario and 15% in New Brunswick, Nova Scotia, Prince Edward Island, and Newfoundland and Labrador. Keep supporting records for six years under the CRA retention rule, and retain the workbook with landing documents, invoices and bank evidence.

The most expensive failures I see are not usually dramatic spreadsheet errors. They are small omissions repeated across a season: one fuel receipt never entered, one landing weight typed in pounds, or several release counts left blank. By the time a boat has completed 40 hauls, a missing $180 fuel charge on 10 trips has understated costs by $1,800 and overstated apparent profit by the same amount.

Mixed units and copied figures distort performance

Total Catch Weight (kg) must contain kilograms consistently. If a buyer's ticket shows 1,000 lb and you enter 1,000 as kilograms, the log overstates the catch by about 453.6 kg. That error then affects the apparent price per kilogram, catch comparisons and any later report prepared for management.

Copying the previous row is another practical risk. A captain may change the date and weight but leave the prior vessel, LFA Zone or Avg Price ($/kg) in place. A 2026-01-19 entry for Bay Runner in Digby NS should not inherit Atlantic Pride, Yarmouth NS or the prior haul's 280 traps. Check the identifying columns before reviewing the financial result.

Release and cost information gets lost first

Some crews record legal lobsters but ignore Undersized Released and Berried Released because those animals are not sold. That removes useful evidence about catch composition and makes a 195-legal-lobster haul look similar to a 195-legal-lobster haul with a very different release count. The omission also prevents you from spotting a change in an area or gear pattern.

Fuel is often entered from memory rather than the receipt. A $12.50 per kilogram average price applied to 312.5 kg suggests $3,906.25 of value, while an entered total of $3,200 tells you that a different price, deduction or sale arrangement may be involved. Reconcile the Total Value ($) field to the settlement or buyer document instead of assuming weight multiplied by price is always the amount received.

Profit can look healthy while cash is short

Net Profit ($) is not the same as money in the bank. A buyer may pay 30 days after landing, while bait and fuel are paid immediately. If three hauls each show $3,200 of value but $225 of direct costs, the log may show $8,925 before other operating expenses even though the cash has not arrived. Review unpaid settlements separately and never use an attractive haul margin as permission to ignore licence, insurance, repairs or crew obligations.

That same split between recorded profit and cash collected is why a herd record becomes the next practical ledger for tracking settlements, weights, and unpaid balances.

A tracker works when entering it takes less time than looking for the information later. Set a fixed rule: the captain or shore contact completes the operational columns after every landing, and the bookkeeper adds bait, fuel and other costs when the receipt is posted. For a 20-haul month, spending five minutes per haul creates a complete record in under two hours instead of a rushed reconstruction at month-end.

Use a repeatable landing-to-log process

• Keep the workbook in one shared folder and name saved copies by season and date, such as LobsterHaulLog-2026-02-02.
• Enter Haul ID, Date, Vessel Name, LFA Zone and Port before recording weights or prices. This prevents an otherwise complete row from becoming impossible to identify.
• Photograph or file the weight ticket and fuel receipt with the same Haul ID. For example, H-004 should appear in the file name or note for the corresponding documents.
• At the end of each week, compare the number of log rows with the number of landing records. Five landings should produce five haul rows, not four.

Check exceptions instead of rereading every cell

Use Excel filters to isolate one LFA or vessel, then review unusually high or low Catch per Trap and Legal Rate (%). A 300-trap haul beside a 240-trap haul should not be judged only on total kilograms; compare the effort, release counts and costs together. Conditional formatting can be added to a working copy to flag blank IDs, negative costs or unusually low catch, but do not overwrite the original log without keeping a backup.

Copying a blank row format for a new haul is safer than copying a completed row containing last week's vessel and price. My preference is to enter the row at the wharf, reconcile money every Friday, and perform a full review before the monthly GST/HST bookkeeping is closed. Move to a fisheries management or accounting system when several users edit the file simultaneously, you exceed 10,000 rows, or you need formal DFO submissions, permissions and an audit trail.