Starting point
At 8 pm, delivery hours end at BeeBee in Ilmenau, 7 days a week. After that, there used to be about 60 more minutes that no guest ever sees: the end of day close.
About 3,700 orders come in each month, about 120 on a normal day: at the till, in the online shop and through delivery platforms. Every order was recorded, but in 3 systems that knew nothing about each other. Only when someone laid orders, revenue, cancellations and payouts side by side was the day complete.
3 systems, 3 formats
The till supplies the sales on site and the day’s cancellations. The online shop lists direct orders with the payment method. Each delivery platform keeps its own order lists and pays out later, minus commission and often bundled for several days. The values did not arrive in the same format or under the same labels.
Before: about 60 minutes after closing
Someone from the team opened all 3 views, copied the daily totals into a spreadsheet and checked whether order count, revenue and payout matched. Cancellations needed a reason. If one was missing, the search went back to the shift, often not until the next day, when nobody remembered exactly.
If a delivery platform payout was lower than the orders behind it, someone had to find out whether a fee, a delayed payment or a mistake was the cause. After a busy day there was often no time left for that. At the end of the month, someone then laid the delivery platform payouts against the orders once more, about 8 hours of work, and small differences still slipped through.
About 60 minutes on about 30 evenings is 30 hours a month. With the month end close it came to almost 40, as much as 1 full working week. The Federal Statistical Office puts labour costs in hospitality for 2025 at €27.40 per hour worked. So the reconciliation cost BeeBee a good €1,000 a month, for copying figures and doing the sums again.
Implementation
What we built in Pharen Hub
We set up the end of day close as one workflow. It takes the day’s data from the till, the online shop and the delivery platforms, maps it to the same fields and writes orders, revenue and cancellations per source into one shared overview.
Then the workflow checks fixed rules. Does a delivery platform’s payout match its orders? Fees the platform lists do not count as a discrepancy. Does every cancellation have a reason? If something stays unresolved, it appears as an open item with source and amount. A day without discrepancies is closed without the team adding up every total again by hand.
How the end of day close runs today
- After closing, the daily totals from the till, online shop and delivery platforms go into the workflow.
- The workflow maps the different fields to one shared schema.
- Orders, revenue and cancellations are added up per source and saved as the daily total.
- Delivery platform payouts and cancellation reasons run through the fixed check rules.
- Without a discrepancy, the day gets the status “Closed”. With a discrepancy, only the affected item stays open.
- The team checks the receipt or the shift note, adds the reason and closes the item. For an uneventful day a glance at the overview is enough, with 2 open items it takes about 5 minutes.
The workflow does not change any payout and books nothing in the accounts. It prepares the reconciliation and shows where a decision is needed. Resolving the issues stays with BeeBee.
Result
One day, 2 open items
The daily overview below shows 7 sample days with anonymised figures. On 26 September there were 75 till orders with €2,520.00 in revenue, 30 online shop orders with €945.00 and 19 delivery platform orders with €655.00. Together that is 124 orders and €4,120.00.
3 orders were cancelled. That left 2 items for the team: one delivery platform payout was €43.10 below the order total, and 2 till cancellations had no reason. For the €43.10 the team looks at the delivery platform’s statement, and for the cancellations it asks the shift that was on the till that evening. Everything else was already reconciled.
About 35 hours less reconciliation a month
Today the evening check takes about 5 minutes instead of 60. The month end close needs about 1 hour instead of 8, because the days are already checked. Almost 40 hours a month have become about 3.5, so about 35 hours less. At €27.40 labour cost per hour in hospitality, that is about €950 a month.
Gaps in delivery platform payouts show up the same evening
A gap like the €43.10 on the sample day now shows up the same evening, while it can still be documented and disputed with the delivery platform. At about 10 such gaps a month, that is about €430 that used to get lost in the monthly statement.
Together with the saved working time, that makes about €1,400 a month.
What has changed
The end of day close no longer starts with 3 views and an empty spreadsheet. The team opens the daily overview and sees right away whether anything needs resolving. It resolves missing cancellation reasons the same evening, while the shift still remembers. For the month end close, the days are already checked.
BeeBee now cashes up faster. And clocks off sooner. 🍣
Published on , updated on .




