Digitising Seafarer Welfare Data for Mission to Seafarers
Mission to Seafarers relied on stacks of paper forms to record the thousands of welfare interactions it delivers across Sydney's working ports each year — a manual process that consumed staff time, introduced errors, and limited the organisation's ability to demonstrate its impact.
Friendlyware Partners digitised the charity's entire data-collection workflow on Microsoft Forms and SharePoint, replacing paper with structured digital capture and automated, board-ready reporting. The organisation can now record activity at the point of service and tell the story of how it supports seafarers with accurate, real-time data.
Mission to Seafarers is a maritime welfare charity that supports visiting crews arriving at Sydney's commercial ports.
Client Spotlight
The Problem
Every interaction was captured on paper across several different forms — bus passenger sign-ins, money-exchange records, chaplain impact logs, and bus driver trip sheets — amounting to well over 12,000 individual entries a year, with the bus passenger sign-in sheet alone accounting for 8,000 to 10,000. Every sheet then had to be manually re-keyed into spreadsheets. The result was a heavy administrative load, a high rate of transcription errors, and slow, limited reporting that made it difficult for the organisation to analyse its work or show supporters the difference it was making.
The Challenge
Digitising the data was not simply a matter of recreating forms on screen. Friendlyware had to solve several specific obstacles:
• Data was captured in the field — on buses and at the port — often by seafarers themselves, many of whom do not speak English as a first language.
• Free-text entry of ship and country names produced inconsistent, hard-to-analyse data that needed to be standardised.
• The foreign-exchange process carried compliance requirements, including passport verification, transaction limits, and a record of which staff member validated each entry.
• Each form had distinct fields, owners, and workflows, yet the data needed to be consolidated for unified reporting.
• Requirements evolved throughout the engagement as real-world use surfaced new needs, demanding a flexible, iterative approach.
The Solution
Friendlyware delivered a complete digital data-capture and reporting platform built entirely on the organisation's existing Microsoft 365 environment. Key deliverables included:
• Self-service passenger sign-in: A QR code on each bus opens a mobile form on seafarers' own phones over onboard wifi, with instructions in English and Chinese, so crews sign themselves in at the point of service.
• Validated, structured data: Dropdown fields for ship, country and agent replaced free text, with SharePoint lookups automatically filling missing details such as agent name based on date and vessel.
• Integrated foreign-exchange capture: Both an in-line and a dedicated FX form capture passport details with built-in validation and a record of the staff member who verified each transaction.
• Redesigned operational forms: A rebuilt chaplain impact log capturing deeper welfare measures, and a per-trip bus driver form supporting multiple vessels and terminal dropdowns, plus a daily passenger counter per ship.
• Consolidated reporting: All form data is aggregated into a single source, with monthly pivot-table summaries, year-on-year (YTD vs LYTD) comparison, and a clean export ready to paste straight into A4 board reports.
Outcome
Mission to Seafarers has eliminated the manual re-keying of more than 12,000 forms a year. Data is now captured accurately and consistently at the moment of service — eliminating transcription errors. Standardised dropdowns and automated lookups mean the data is clean and analysis-ready the moment it is entered.
Just as importantly, reporting that once took hours of manual collation is now produced at the click of a button, complete with year-on-year comparisons and board-ready formatting. Staff and volunteers have been freed from administrative overhead to focus on supporting seafarers, and the organisation can finally evidence its impact with confidence — all on familiar Microsoft tooling that scales with its work and requires no specialist IT skills to maintain.
Real Businesses, Real Challenges, Real IT Solutions
Get in touch..
Complete the form below, and the Friendlyware team will connect with you to explore how our tailored IT solutions can empower your business, streamline operations, and ensure resilient network performance.