Case Studies / Funeral Operations DX — Excel and Paper to Centralized System
Business Systems · DX · Professional Services

Funeral Operations DX — Excel and Paper to Centralized System

A funeral services operator managed every stage — intake, scheduling, supplier coordination, billing — through Excel and paper. Information was siloed to individuals.

Tech Stack
ruby-on-rails react-2 postgre line-api google-drive aws
Project Info
Platform Web + LINE integration
User Type Internal (operations, admin, field staff)
Client Type SME
Engagement Fixed Price
Region Japan
Funeral Operations DX — Excel and Paper to Centralized System

The Challenge

The business ran on individual knowledge. Every stage of a funeral case — intake, scheduling, supplier coordination, billing — lived in a spreadsheet or a paper document on someone's desk. When that person was unavailable, the information was effectively inaccessible.

This created fragility that showed up in predictable ways: scheduling conflicts discovered too late, supplier orders placed on assumptions rather than confirmed data, billing assembled by hand from multiple files. The operation worked because experienced staff carried the process in their heads — not because the process was documented anywhere.

What We Built

AMCOLAB replaced the paper-and-spreadsheet operation with a single system covering the full case lifecycle. Any authorized team member can open a case and see exactly where it stands — without asking someone who happens to know.

Case Management
01

Case Management

Every funeral case is a digital record: client details, ceremony preferences, scheduling, staff assignments, and supplier coordination — all in one place, accessible to the whole team.

Digital Intake via LINE
02

Digital Intake via LINE

Families submit initial information via LINE, the communication channel they already use. Submitted data flows directly into the case record — no re-entry, no paper forms to transfer.

Scheduling with Conflict Detection
03

Scheduling with Conflict Detection

A calendar-based interface manages ceremony bookings, facility usage, and staff assignments. Conflicts surface automatically before they affect operations. Changes notify affected team members in real time.

Supplier Coordination
04

Supplier Coordination

Supplier orders are tracked per case within the system. Order status, delivery confirmation, and supplier contacts sit alongside the case record — replacing fragmented email chains and phone notes.

Billing Generation
05

Billing Generation

Invoice line items are assembled from case data automatically. Billing documents are produced without manual data consolidation across multiple files.

Operations Knowledge Base
06

Operations Knowledge Base

Standard operating procedures, supplier contacts, and pricing schedules are stored in the system and accessible to any team member — not locked in individual spreadsheets.

Key Outcomes

Case information accessible to any authorized team member — no longer dependent on who is in the office

Scheduling conflicts identified before they become operational problems

New staff contribute effectively from earlier in their tenure — documented processes replace institutional memory held by individuals

Billing preparation time reduced — manual assembly from multiple spreadsheets replaced by system-generated documents

Management visibility into all active cases in real time — no longer dependent on status updates from individuals

Delivery Scope

Requirement Definition Architecture Development Integration QA Deployment Maintenance

Why AMCOLAB

Process mapping first

before writing code, AMCOLAB mapped the existing paper workflow with the operations team to understand what to digitize and in what order

LINE integration

familiar with LINE as the primary client communication channel in Japan's service industries

SME context

built for a small operations team, not an enterprise with a dedicated IT department

Full-cycle delivery

requirements through staff training support and post-launch maintenance

RELATED WORK

More projects

Start A Project

Still running your operations on spreadsheets?

Let's map your workflow and build something your whole team can use.

Schedule a Meeting Now
Hotline
Email