· 6 min read
Cafe and restaurant P&L: a template and key metrics
A P&L template for cafes and restaurants: food cost, prime cost, theoretical vs actual COGS, delivery app commissions, with a line-by-line worked example.
Blog
· 6 min read
A P&L template for cafes and restaurants: food cost, prime cost, theoretical vs actual COGS, delivery app commissions, with a line-by-line worked example.
· 5 min read
A monthly management report for service companies: recognised revenue, gross profit by project, utilization, receivables and cash on one page, with an example.
· 7 min read
How to calculate cost of goods sold for an online shop: weighted average, FIFO, by batch and by effective date, with a worked example and a cost table in Excel.
· 5 min read
Send sales numbers to Google Sheets for your accountant on a schedule: pick metrics, overwrite or append, set up a service account, keep formulas intact.
· 7 min read
How returned goods put back in stock change COGS, inventory and profit: three return scenarios, costing returned sales and a worked example.
· 5 min read
Power BI for small businesses: how Free, Pro and PPU licenses differ, who has to pay, and why the real cost includes the hours to build and maintain reports.