How many fishing records can the template hold?

The Catch Log has prepared rows 2 to 101, giving you 100 operational entry rows. If you need more, save an archive or extend the formulas and validation ranges carefully; the workbook does not include an Excel table or unlimited automatic expansion.

Does the template show whether my catch is legal?

No. It compares Number Caught with the bag limit listed on Lists & Instructions and returns Yes or Review. Australian rules differ by state, territory, species, location, season and size, so confirm the current official requirements before keeping fish.

What does Estimated Value (AUD) calculate?

For a kept fish, it multiplies Weight (kg) by the species' indicative value per kilogram. For example, 1.2 kg of bream at $28.00 per kilogram produces $33.60. Released fish receive a zero calculated value.

Why is a GST Component included in a fishing log?

The workbook calculates 10% of Estimated Value as a reference figure. It is not automatically a GST liability, sale or BAS amount. A business must apply the GST rules to its actual activities, and recreational catch records should not be treated as tax invoices.

Can I add another species or change a bag limit?

Lists & Instructions contains the species, indicative values and bag limits used by the formulas and drop-down list. You can update those reference entries when appropriate, but verify the current local rule first and understand that changing a value affects later lookups.

What is shown on the Summary sheet?

Summary calculates total fish recorded, retained weight, average retained weight, estimated value, GST component, released catch percentage and compliance alerts. It also breaks results down by species, catch status and fishing location, with three charts.

Projects & Planning

Fishing Catch Excel - Free Template

Record Australian fishing trips, species, weights, bag-limit checks and catch summaries with this practical Excel template.

2026-10-11

526 Downloads

4.8/5 Average rating

Download template

Screenshot 1: Catch Log tab - Excel template fishing catch log excel template australia

This fishing catch Excel template records Australian fishing trips, anglers, locations, species, catch status, quantities, weights and lengths. It includes a Catch Log for up to 100 prepared entries, automatic bag-limit checks and estimated values, plus a Summary sheet with species, status and location analysis.

Use it after each session to keep a consistent record for recreational fishing, club activities, family trips or small fishing operations. The workbook includes three sheets: Catch Log, Summary, and Lists & Instructions, with sample records from NSW, VIC and QLD already shown.

The key benefits of this Excel template

Records 100 catch entries across dates, anglers, locations and fishing methods.
Checks each entered catch against the species bag limit and displays Yes or Review.
Separates kept and released fish so you can monitor retained catch and release rates.
Calculates estimated retained value from weight and the indicative value per kilogram.
Shows the calculated GST component at 10% of estimated value.
Summarises species counts, retained weight, average length and location results.
Uses drop-down lists and input limits to reduce inconsistent catch records.

Step-by-step guide

Open the workbook and read the guidance on Lists & Instructions before changing any reference values.
Go to Catch Log and enter a Catch ID, date, angler, location and state or territory for each fishing session.
Select the fishing method, species and Kept or Released status from the available drop-down lists.
Enter Number Caught, Weight (kg), Length (cm) and any useful notes. The prepared rows run from row 2 to row 101.
Review Bag Limit and Within Bag Limit? after entering the species and quantity. A Review result means the entry needs checking against the applicable local rules.
Check the calculated Estimated Value (AUD) and GST Component for retained fish, then open Summary to review totals and charts.
Update reference values only when you have confirmed the current state or territory requirements; the workbook’s indicative limits are not a substitute for official fishing rules.

Screenshot 2: Summary tab - Excel template fishing catch log excel template australia — Figure 2: Worksheet "Summary"

What is included

Catch Log columns cover Catch ID, Date, Angler, Location, State/Territory, Fishing Method, Species and Kept/Released.

Measurement fields capture Number Caught, Weight (kg) and Length (cm), with numeric validation from 0 to 999 or 500 as configured.

VLOOKUP formulas bring the indicative species value and bag limit from Lists & Instructions.

IF formulas identify whether the recorded number is within the listed bag limit.

Estimated value is calculated only for kept fish, using weight multiplied by the indicative value per kilogram.

Summary uses SUM, SUMIF, COUNTIF, COUNTIFS and AVERAGE-based calculations.

Three Summary charts compare species catch count, kept versus released status and retained weight by location.

Who uses a fishing catch log across Australia

A recreational angler can use this fishing catch Excel template straight after a session, while a fishing club secretary can consolidate records from several members. It suits a Saturday boat trip, a school or community fishing program, or a regular survey where the same species and locations are recorded repeatedly.

Records for different fishing situations

The Catch Log has fields for the angler, location, state or territory and method, so a club can distinguish a boat trip in Moreton Bay from a land-based session on the Hawkesbury River. Image 1 shows the 16-column entry layout, including species, status, measurements, bag-limit results and notes.

For example, the populated sample records three bream caught at the Hawkesbury River, one released flathead at Port Phillip Bay and six kept snapper at Moreton Bay. Those examples show the intended level of detail, but they are sample data rather than a complete legal catch history.

Useful for clubs and repeat trips

A club running 12 monthly outings with 15 members could create 180 observations over a year, exceeding the 100 prepared rows in this workbook. For that volume, save separate workbooks or extend the formulas carefully rather than assuming unused rows are unlimited.

The Summary sheet, shown in image 2, turns the entries into species performance, catch-status and location views. That gives a volunteer treasurer or committee member a quick count without manually adding every paper record.

Screenshot 3: Lists & Instructions tab - Excel template fishing catch log excel template australia — Figure 3: Worksheet "Lists & Instructions"

Australian fishing rules and the limits in this workbook

Fishing rules in Australia are administered by state and territory authorities, and bag, size, seasonal and possession limits can change by species and location. A number in this spreadsheet is therefore an operational prompt, not a licence to keep fish. Check the current authority rules for the waterway before relying on a result.

What the reference sheet contains

Lists & Instructions includes eight species, indicative values per kilogram and example bag limits. For instance, it lists bream at $28.00 per kilogram with a bag limit of 10, snapper at $36.00 with a limit of 5, and dusky flathead at $26.00 with a limit of 5. These are workbook reference values, not universal Australian limits.

The Catch Log retrieves the listed limit with VLOOKUP. If six snapper are entered against a listed limit of five, the Within Bag Limit? formula returns Review. That flag is useful because it tells you to verify the local rule, but it does not determine whether the catch is lawful.

Value and GST are separate questions

The estimated value is a notional calculation: 4.8 kg of kept snapper at $36.00 per kilogram produces $172.80, and the workbook calculates a $17.28 GST component at 10%. This does not make a recreational catch a taxable sale or establish that GST is payable.

For a registered business, GST registration generally applies at $75,000 annual turnover, or $150,000 for a not-for-profit. Keep this workbook’s value field separate from a BAS record, invoice or tax invoice, and retain business records for 5 years where the ATO rules require it.

Where catch records go wrong and what it costs

The most damaging error is treating a spreadsheet flag as the current fishing rule. A sample limit of five snapper may be outdated, area-specific or different during a closure. If a crew records six fish and does not investigate the Review result, the problem can become a compliance issue rather than a simple data error.

Mixed units distort the result

Estimated value uses Weight (kg), not grams. Entering 1,200 instead of 1.2 turns a $33.60 bream estimate into $33,600 at the workbook’s $28.00 per kilogram reference value. The decimal validation allows values up to 500, so a careless unit entry can still be accepted.

Length has the same practical risk. The workbook records centimetres, but it does not calculate a minimum legal length or identify a species-specific size rule. A 34 cm bream and a 34 cm snapper are not interchangeable records, even though both are numbers in the Length (cm) column.

Kept and released status matters

If a released flathead is marked Kept, its weight feeds the retained-weight and estimated-value calculations. If a kept fish is marked Released, the Summary understates retained catch. One incorrectly marked 2.5 kg fish at $36.00 per kilogram changes estimated value by $90.00 and affects the GST Component by $9.00.

Another common failure is overwriting formulas in columns L to O. Those columns calculate bag limits, review status, estimated value and GST for rows 2 to 101. Paste values only into the input columns, and keep a backup before making structural changes.

Turning the catch log into a reliable routine

The easiest routine is to enter the record before you put the fishing gear away. A two-minute entry after each trip is more reliable than trying to reconstruct 10 sessions at the end of the month from memory, especially when several anglers fished different locations.

Use a fixed post-trip checklist

Enter the date, angler, location and state or territory first.
Choose species and Kept or Released from the lists rather than typing variations such as kept, retained and K.
Check weight in kilograms and length in centimetres before leaving the row.
Resolve every Review result against the current local authority information.

Image 1 shows freeze panes at the header and an auto-filter across the Catch Log, which makes it easier to find a species, location or status. Image 2 shows the Summary formulas and three charts; check it after a club outing or at month-end rather than waiting until the end of the financial year.

Know when the workbook has reached its limit

The file has 100 prepared operational rows and no Excel table. If you regularly record 25 entries a week, you will use those rows in about four weeks. At that point, save an archive and extend the formulas carefully, or move to software such as Xero or MYOB only if the records are part of a broader business bookkeeping process.

Keep Lists & Instructions controlled by one person. Changing an indicative value from $28.00 to $32.00 changes every later lookup that uses that species, so note the date and reason for any reference update.

For boat-based trips, pair the catch entry with a separate boat fuel log when you need to track fuel purchases, engine hours and receipts.

Frequently asked questions about this template

The Catch Log has prepared rows 2 to 101, giving you 100 operational entry rows. If you need more, save an archive or extend the formulas and validation ranges carefully; the workbook does not include an Excel table or unlimited automatic expansion.
No. It compares Number Caught with the bag limit listed on Lists & Instructions and returns Yes or Review. Australian rules differ by state, territory, species, location, season and size, so confirm the current official requirements before keeping fish.
For a kept fish, it multiplies Weight (kg) by the species' indicative value per kilogram. For example, 1.2 kg of bream at $28.00 per kilogram produces $33.60. Released fish receive a zero calculated value.
The workbook calculates 10% of Estimated Value as a reference figure. It is not automatically a GST liability, sale or BAS amount. A business must apply the GST rules to its actual activities, and recreational catch records should not be treated as tax invoices.
Lists & Instructions contains the species, indicative values and bag limits used by the formulas and drop-down list. You can update those reference entries when appropriate, but verify the current local rule first and understand that changing a value affects later lookups.
Summary calculates total fish recorded, retained weight, average retained weight, estimated value, GST component, released catch percentage and compliance alerts. It also breaks results down by species, catch status and fishing location, with three charts.