Reports

Olaya Roastery only — every figure read back from the orders and payments this brand took. A manager here can never widen it to another business.

to

Sun 20 Sep – Sat 26 Sep · every branch · compared with Sun 13 Sep – Sat 19 Sep

Net sales25,051 SAR19%was 21,069 SAR
VAT collected3,758 SAR15% · gross 28,809 SAR
Orders96315%1,654 items
Average ticket26.01 SAR4%was 25.11 SAR
Refunds650.44 SARlevel21 orders given back
Discounts267.10 SAR1.1% off the menu price
Cash taken4,970.00 SAR13 shifts · 3 still open
Gross margin75.1%cost of sales 6,249.38 SAR

Sales by day

net of VAT · this week
3k
Sun 20 Sep
3.5k
Mon 21 Sep
3.2k
Tue 22 Sep
3.2k
Wed 23 Sep
5.1k
Thu 24 Sep
3.7k
Fri 25 Sep
3.4k
Sat 26 Sep

By channel

Where the order came from

  • POS12,389.40 SAR
    49.5% of the total468 orders
  • Drive-thru5,982.30 SAR
    23.9% of the total229 orders
  • Pickup3,358.40 SAR
    13.4% of the total139 orders
  • QR table3,320.80 SAR
    13.3% of the total127 orders

By payment method

What the customer handed over, VAT included

  • Mada13,120.45 SAR
    45.5% of the total445 payments
  • Cash7,753.40 SAR
    26.9% of the total255 payments
  • Visa / Mastercard5,100.81 SAR
    17.7% of the total169 payments
  • Apple Pay2,833.83 SAR
    9.8% of the total96 payments

By category

Cost and margin from the S10 recipes

  • Hot Coffee9,945.09 SAR
    39.7% of the total572 orders658 unitscost 1,979.69 SAR · margin 80%
  • Iced6,615.93 SAR
    26.4% of the total285 orders337 unitscost 1,516.02 SAR · margin 77%
  • Bakery4,916.08 SAR
    19.6% of the total338 orders384 unitscost 1,744.80 SAR · margin 65%
  • Other Drinks3,573.80 SAR
    14.3% of the total231 orders275 unitscost 1,008.86 SAR · margin 72%

By item

Every line the till rang up

  • Iced Latte2,767.18 SAR
    11.0% of the total125 orders147 unitscost 519.80 SAR · margin 81%
  • Flat White2,285.78 SAR
    9.1% of the total125 orders144 unitscost 483.26 SAR · margin 79%
  • V60 Filter2,030.00 SAR
    8.1% of the total77 orders93 unitscost 262.65 SAR · margin 87%
  • Cold Brew1,964.22 SAR
    7.8% of the total83 orders99 unitscost 643.50 SAR · margin 67%
  • Iced Spanish1,884.54 SAR
    7.5% of the total77 orders91 unitscost 352.70 SAR · margin 81%
  • Hot Chocolate1,677.37 SAR
    6.7% of the total81 orders94 unitscost 323.36 SAR · margin 81%
  • Fresh Orange1,640.60 SAR
    6.5% of the total75 orders92 unitscost 552.00 SAR · margin 66%
  • Latte1,522.78 SAR
    6.1% of the total84 orders90 unitscost 329.03 SAR · margin 78%

By staff

Who rang it up

  • Majed Al-Dossary11,769.80 SAR
    47.0% of the total452 orders
  • Noura Al-Qahtani6,535.50 SAR
    26.1% of the total243 orders
  • Faisal Al-Harbi5,848.80 SAR
    23.3% of the total231 orders
  • Dana Al-Zahrani896.80 SAR
    3.6% of the total37 orders

By hour of day

When the money comes in

  • 9am2,541.20 SAR
    10.1% of the total101 orders
  • 5pm2,535.10 SAR
    10.1% of the total95 orders
  • 6pm2,421.00 SAR
    9.7% of the total102 orders
  • 11am2,385.20 SAR
    9.5% of the total90 orders
  • 4pm2,331.40 SAR
    9.3% of the total96 orders
  • 3pm2,291.10 SAR
    9.1% of the total86 orders
  • 10am2,214.40 SAR
    8.8% of the total84 orders
  • 8am2,204.50 SAR
    8.8% of the total85 orders
  • 12pm2,120.90 SAR
    8.5% of the total84 orders
  • 2pm1,790.10 SAR
    7.1% of the total62 orders
  • 1pm1,542.10 SAR
    6.2% of the total57 orders
  • 7am599.90 SAR
    2.4% of the total19 orders
  • 8pm50.00 SAR
    0.2% of the total1 orders
  • 7pm24.00 SAR
    0.1% of the total1 orders

VAT summary

Standard rate 15% · the shape a ZATCA return asks for

Standard rated salesnet of VAT25,050.90 SAR
Output VAT at 15%3,757.61 SAR
Zero rated / exemptnothing on this brand's menu is exempt0.00 SAR
Gross sales28,808.51 SAR
Refunds given backgross, already out of the figures above650.44 SAR
VAT on refundsdeductible against output VAT84.84 SAR

Settled with

Mada445 payments13,120.45 SAR
Cash255 payments7,753.40 SAR
Visa / Mastercard169 payments5,100.81 SAR
Apple Pay96 payments2,833.83 SAR

Receipts OLY-003193 to OLY-004181 — 963 sequential numbers, one book per brand. The e-invoice XML and the QR that ZATCA asks for are posted in S15; the numbering they will carry is already this one.

Cost of sales

What the period's orders took off the shelf

Net sales25,050.90 SAR
Cost of goods soldrecipe where there is one, trade ratio where not6,249.38 SAR
Written offwaste, breakage and staff samples in this period82.80 SAR
Gross margin75.1%

Off the shelf — top items

  • Espresso beans (Ethiopia) (kg)14.28 · 1,315.16 SAR
  • Full fat milk (litre)107.09 · 642.54 SAR
  • Paper cups 12oz (pcs)914 · 548.40 SAR
  • Cheesecake slice (pcs)78 · 546.00 SAR
  • Butter croissant (frozen) (pcs)124 · 520.80 SAR
  • Cup lids 12oz (pcs)914 · 182.80 SAR

Written off

  • Full fat milk · several reasons7.5 litre · 45.00 SAR
  • Cheesecake slice · expired3 pcs · 21.00 SAR
  • Butter croissant (frozen) · quality below standard4 pcs · 16.80 SAR

A recipe accounts for 73% of what was sold; the rest is costed at the trade's usual ratio until its recipe is written. Of the 6,249.38 SAR above, 3,938.38 SAR can be traced item by item through the store room.

Cash against the drawers

The payment rows on one side, the shift counts on the other

Cash the payment rows say was taken13 shifts in this period, 3 still open4,970.00 SAR
…of that, on shifts already counted10 closed shifts4,060.00 SAR
Expected in those drawersopening float + cash in − paid out6,090.00 SAR
Counted at close6,035.00 SAR
Short bycounted − expected55.00 SAR

4 of the 10 counted drawers came up short. A shift is opened on the Shifts screen, where the variance is broken down per person.