Maritime ferry cost Excel - Free Template

1. Open the Voyage Costs sheet and start at row 3. Enter one sailing per row, beginning with a unique Voyage ID such as VC-2026-004.
2. Enter the voyage date as YYYY-MM-DD, then select the vessel, route, departure port, arrival port, province and operator from the dropdown lists.
3. Enter passenger count, vehicle count, sailing hours and fuel litres. The prepared validation accepts passenger and vehicle counts from 0 to 5,000, sailing hours from 0 to 100 and fuel litres from 0 to 1,000,000.
4. Enter the six cost inputs: Fuel Cost, Labour Cost, Maintenance Cost, Port Fees, Catering Cost and Other Cost. Enter the voyage Budget and add Notes where supporting detail is useful.
5. Check the calculated columns. SUM adds the cost categories to Subtotal, VLOOKUP retrieves the provincial tax rate, and the workbook calculates Tax Amount, Total Cost, unit costs and Variance.
6. Review the Dashboard after entering several voyages. It summarizes all populated Voyage ID rows, including provincial totals, route totals, cost composition and the total-cost trend.
7. Before using the file for a new operating period, update the editable values on Reference Lists and read the Instructions sheet. Leave unused rows blank so the formulas remain visually empty.

A ferry operations manager can use this workbook during each sailing cycle to record the costs behind a route instead of waiting for month-end totals. The Voyage Costs sheet is suited to municipal transit, regional ferry operators and private services that need to compare vessels, crossings and provincial operations in Canadian dollars.

One row for one sailing

Image 1 shows the table from Voyage ID through Notes. A short Halifax–Dartmouth trip might record 310 passengers, 55 vehicles, 0.3 sailing hours and 1,450 litres of fuel. A longer Saint John–Digby sailing can be entered on the next row with 420 passengers, 128 vehicles, 3.2 hours and 4,200 litres.

Those rows are not forecasts: the workbook includes them as populated sample data. The remaining prepared rows are available for your own voyages, and formulas stay blank until you enter a Voyage ID.

Use the dashboard for operating reviews

Image 2 shows KPI values and summary tables rather than an entry form. The Dashboard uses COUNTA, COUNTIF, SUMIF and SUM to group populated rows by province, route and cost category.

For example, if four employees support a sailing and labour costs total $3,500, you can compare that amount with fuel and port charges without combining separate worksheets. The dashboard also reports average cost per voyage, so a $12,000 short crossing and a $29,000 overnight crossing are not treated as though they have the same operating profile.

The workbook's Reference Lists sheet contains sample rates of 15% for Nova Scotia, New Brunswick, Newfoundland and Labrador and Prince Edward Island, and 13% for Ontario. These are the HST rates shown in the file; update the table when the tax treatment for your operating context changes.

How the lookup works

When you select a province in column G, the Tax Rate column uses VLOOKUP against Reference Lists. If a row has a $10,000 subtotal and a 15% rate, Tax Amount is $1,500 and Total Cost is $11,500. At 13%, the same subtotal produces $1,300 tax and $11,300 total.

The workbook does not decide whether a particular ferry charge is taxable, whether an input tax credit is available, or whether an operator should use the regular GST/HST method or the Quick Method. Those are tax-reporting decisions, and the rate table should be reviewed before a filing.

Keep source records with the row

A registered operator should retain invoices, fuel receipts, payroll support, port statements and maintenance records with the voyage data. The CRA generally expects business records to be retained for six years. A business operating across provinces should also distinguish GST 5%, HST 13% in Ontario and HST 15% in the Atlantic provinces from provincial charges such as PST or QST.

For a registered business, the tax account is normally linked to the BN through an RT program account. This tracker is an operating-cost analysis tool, not a GST/HST return: reconcile its tax totals to the actual invoices and accounting records before filing.

The most expensive errors usually begin with inconsistent voyage rows. One supervisor enters MV Atlantic Star, another enters Atlantic Star, and a third leaves the vessel blank. The dropdowns in Image 1 reduce that problem, but only if the lists on Reference Lists are maintained instead of typing over the controlled choices.

Tax and budget errors

A wrong province can change a $20,000 subtotal by $400: 15% HST is $3,000, while 13% HST is $2,600. The workbook retrieves the rate from the province selection, so a wrong province creates a calculated answer that looks precise but is still wrong.

Budget errors are equally practical. If actual voyage cost is $18,750 and the budget is $17,000, Variance is $1,750 and Status becomes Over Budget. Entering the budget as $170,000 hides the issue by a factor of ten, while leaving it blank makes the variance comparison unhelpful.

Unit-cost traps

Passenger and vehicle counts must describe the same sailing as the costs. A $24,000 voyage divided by 600 passengers gives $40 per passenger; dividing by a copied count of 300 gives $80. The formulas return zero when the denominator is zero, but they cannot detect a plausible count copied from the wrong departure.

Another common failure is overwriting a blue-white calculated cell with a hard-coded number. That breaks the chain from cost inputs to Total Cost and Dashboard summaries. Keep editable inputs in the pale-yellow cells described on Instructions, and test a completed row against the supporting invoices before using it in a management report.

The easiest routine is to complete the row shortly after each sailing, while the fuel ticket, labour record and port invoice are still available. A ferry operator running 10 voyages a week can spend five minutes per row on the same day rather than reconstructing 40 rows at month-end.

A simple weekly review

• Assign the Voyage ID before the sailing or when the dispatch record is closed.
• Enter passenger, vehicle, hours and fuel figures from the operating log.
• Add invoices and labour costs when the accounting record is available.
• Check any red Over Budget result before the weekly operations meeting.
• Review the Dashboard after the last sailing of the week.

Use the Reference Lists sheet as the control point for new vessels, operators, routes and ports. If a route name changes, update the list before entering new rows; otherwise the Dashboard route summary can split one service across two spellings.

When this workbook is no longer enough

This file has 100 prepared Voyage Costs rows, not an unlimited database. At 25 sailings per week, that is roughly four weeks of entries before you need to archive or extend the workbook. For a fleet with multiple dispatchers, live fuel feeds, purchase-order matching or several thousand voyages, move to an accounting or fleet system and preserve this workbook as an analysis export.

Keep a locked monthly copy after review. A practical file name is FerryCosts-2026-03.xlsx, followed by a reconciliation note showing the Dashboard total and the accounting-system total. If the two figures differ by $2,000 on $100,000 of monthly costs, investigate before approving the report rather than carrying the difference forward.