A. Nezar
All case studies

Case study 04 of 05

One report for waste and hospitality

Waste and free items lived in two systems that never met. One self-checking workbook brought them together, and found a loss nobody recorded.

checks against the raw data
476
systems that never met
2
loss channel nobody recorded
1

01

The problem

Management could not see waste and free items in one report.

02

What I found

  • They are recorded in two systems that never meet: the till and the waste sheets.
  • The two use different items for the same bread; the link between them is the recipe.
  • A third loss channel, count adjustments, appeared in neither.

03

What I did

  • Built a workbook that recalculates itself.
  • Checked it cell by cell against the raw data (476 checks) and against a second path through the database.

Result

One report, and a recording gap the business didn’t know about.

  • Excel modelling
  • SQL
  • Odoo 18
  • Data reconciliation

Contact

Hiring, or need finance systems built?

I’m open to roles where finance and technology meet, and to projects for businesses that need Odoo, reporting or operations software done properly.

Email meLinkedIn GitHub