A coffee shop closes on a Saturday night with the till counted, the tip jar split by feel, three vendor invoices in a drawer and a quarterly bean order that landed in the slowest week of the month. The shop was busy. Whether it made money that week is a question the owner cannot answer until the bookkeeper calls, by which time the next order has already gone in. CafeDesk US answers it by Sunday.

Closing the day properly

Each day records beverage, food and merch sales, the transaction count and the card and cash tips, and the gross and the average ticket derive from those.

Read across a month, the average ticket says whether the food case and the merch shelf are pulling their weight or just taking up counter space.

Tips split by the hours worked

The day's tip pool is divided among the shifts on that day in proportion to their hours, which is the rule most shops agree on and few apply consistently.

Because the share is computed per shift, the owner can hand each barista a figure for the week that was derived, not estimated.

Invoices with a due date

Each vendor invoice carries its own due date, and the balance follows payments recorded against it, so a dairy invoice missed in the pile shows its days late.

The roaster's quarterly order can be paid in halves and the record shows Partial until the second half goes.

Prime cost, weekly

The weekly summary totals sales, labor and purchases between the week's dates and reads Healthy under sixty percent, Tight to sixty-eight and Over beyond.

A slow week that absorbed a large bean order reads Over, which is exactly right, and the next week's Healthy shows it was timing rather than a trend.

Review exceptions every week

Resolve duplicate IDs, missing links, overdue balances, negative amounts, and open operational items in CHECKS before using the dashboard for decisions.

CafeDesk US Microsoft Excel Edition is designed for Microsoft Excel 2019 or newer on Windows or macOS.

No point of sale or card terminal integration, no payroll or tip reporting to the IRS, no sales tax filing, no inventory counts by ingredient, and no online ordering or loyalty program.