Witify Logo Witify Logo

A list in Excel. Today’s list, in one click.

The application Witify designed and built for the Centre de jour de Saint-Jérôme. It prepares the day’s basket list, tracks what each person owes and produces the organization’s statistics.

Client
Centre de jour de Saint-Jérôme
Sector
Food aid
Technologies
Laravel, Vue, Sprintify, MySQL

01 Numbers

Five numbers, and where they come from

First, the rules the application enforces. None of these numbers measures the centre’s activity.

  • 1

    button to prepare the day’s basket list One confirmation, and each expected person appears once.

  • 2

    unjustified absences in a row, and the application flags it The day’s line also counts absences since the last basket handed over.

  • 1

    paid basket per person per month Later ones in the same month are offered at no charge.

  • 11

    reports for the organization’s statistics For one day or for the chosen period.

  • 8

    kinds of records, each change logged Who changed what, and when.

Rules and counts read in the application’s code on 13 November 2026.

02 Before

An Excel workbook, one row per person

Before the application, the list of beneficiaries lived in an Excel file: one row per person, with their balance and the date of the last update. Those records were carried over into the application, each person’s balance included.

Fig. 01 The list of beneficiaries, in Excel

03 A morning

From the day’s list to the basket in hand

A distribution morning comes down to four steps: prepare the list, see who is expected, record what is handed over, export the delivery list. At each step, the person’s balance stays right.

01 Generate

The day’s list, in one click.

The “Generate daily basket distribution” button asks for a confirmation, then prepares a basket for each person expected today: active record, usual day and time, no planned absence. Pressing it twice adds nothing.
Fig. 02 Generate the daily list

02 Welcome

Who is expected, and what they owe.

Each line shows the person, their balance in red or green, their unjustified absences since their last basket, the basket size and the cost. The tabs count what is left to process, at the centre and for delivery.
Fig. 03 The baskets to hand over at the centre

03 Hand over

Collected or absent, in one step.

On site, the basket is marked collected and the amount received is entered, or the absence is marked with its reason. The payment is created, or undone, at the same moment.
Fig. 04 Mark a basket collected

04 Deliver

The delivery list, in Excel.

Pick a date and a route. The application produces an Excel workbook sorted by address, with the balance to collect and an empty column to write down the amount received.
Fig. 05 Delivery list

04 Balance

A balance that stays right, with no sums done by hand

Each person’s balance comes from the cost of their baskets and their payments, never from typing. Every payment leaves a receipt, and a correction stays visible as one.

Fig. 06 The morning’s payments, and the form to record one

05 Records

One record per person, entered once

Identity, contact details, usual pickup day, basket size, household: everything is entered once. The day’s list and the statistics read those same fields.

The list

Every record, at a glance

Status, usual basket, balance, last basket. Two columns tell whether the aid is temporary and whether the record is complete: an emergency is served first, the record is completed afterwards.

The record

Everything about one person

Identity, contact details and usual basket, in one place.

The entry

One form, filled in once

Registration fills in the record. Nothing to retype afterwards.

06 Reports

The statistics come from the same records

Eleven reports are calculated for the chosen day or period. The statistics start from the baskets actually handed over, one record per household.

Fig. 07 Household composition, over the chosen period

07 Choices

Three choices so distribution stays simple

Three decisions mattered more than the others. For each one: the risk avoided, our choice, and what the centre gains.

  1. The balance is calculated, not typed.

    The risk
    A balance typed by hand ends up drifting from reality.
    Our choice
    The balance is the cost of the baskets minus the payments, recalculated every time it is shown. An employee cannot edit a saved payment; only an administrator corrects it, and the correction stays marked.
    The gain
    The balance shown always matches the recorded entries, and every dollar can be traced.

  2. The day’s list is derived, never rebuilt by hand.

    The risk
    Forgetting someone, listing the same person twice, or counting a person with a planned absence.
    Our choice
    The list is built from each person’s usual day, time and status, leaving out planned absences. The delivery list follows the same rules.
    The gain
    Preparation takes one click, with no duplicates.

  3. An emergency comes before the record.

    The risk
    Making someone who needs a basket wait in front of a form.
    Our choice
    An emergency basket is added by hand, at no charge. The record is marked “temporary aid”, then an administrator declares it complete.
    The gain
    The person is served first; the record and the statistics are completed afterwards.

08 Under the hood

What the application is made of

Built on Sprintify, Witify’s web foundation, then adjusted to the centre’s rules.

Foundation
Sprintify, Witify’s web foundation
Application
Laravel, Vue, TypeScript, Tailwind, Sprintify UI components
Data
MySQL, backup copy every night
Exports
Excel and PDF, one export per list, receipts as PDF
Monitoring
Sentry, error alerts
Quality
Automated tests, run on every code change

Key milestones

  1. March 2024 Go-live The records carried over from Excel, the day’s list, collection, payments and PDF receipts.
  2. April 2024 Reports The organization’s statistics, over the chosen period.
  3. April 2024 Suggested price The application suggests the basket price; the team can adjust it.
  4. May 2024 Delivery list The delivery list shows the balance to collect.

Do you still prepare your distribution list by hand?

Thirty minutes to follow one of your baskets, from the day’s list to the balance.

Or write to us
Next case study Distribution MA Read the case study

Names and figures shown in the interfaces are examples.