Sample Data

Please avoid entering personal information or confidential information that you do not have permission to use.

LetsFix · Whole team view

Harbour Roast Coffee, visually

Bristol, United Kingdom

The most relevant pricing, performance and cash information on one easy-to-follow sheet.

Sales

£184,810

Gross profit

£17,220

Product margin

51.8%

Closing cash

£13,051

Overdue

£12,600

Sales trend

+16.7%

Product value map

Bubble size shows revenue. Further right means a higher margin; higher means more gross profit.

Lower marginHigher margin
Signature Blend
Cold Brew
Gift Set
Signature Blend£12,480 · 60.4%
Cold Brew£7,740 · 38.9%
Gift Set£13,050 · 51.1%

Sales and cash received

Monthly sales compared with money received.

SalesCash received
£28.5K
£26.5K
Jan
£29.2K
£27.4K
Feb
£29.8K
£26.8K
Mar
£31.5K
£29K
Apr
£32.6K
£29K
May
£33.3K
£30.3K
Jun
Cash received equals 91.4% of recorded sales for the period.

Profit and cash direction

Monthly operating profit alongside the closing cash balance.

Jan
£3,210
£20,515
Feb
£3,275
£20,240
Mar
£3,231
£17,889
Apr
£4,079
£17,050
May
£4,459
£14,825
Jun
£4,120
£13,051
Profit after overheadsClosing cash

Product mix

Share of revenue compared with share of gross profit.

Signature Blend37.5% / 43.8%
Revenue
Profit
Cold Brew23.3% / 17.5%
Revenue
Profit
Gift Set39.2% / 38.7%
Revenue
Profit

What the team sees

1. Latest monthly sales are £33,270, with a 51.8% gross margin.

2. Signature Blend provides 43.8% of product gross profit.

3. Cold Brew has the lowest product margin at 38.9%.

4. 91.4% of recorded sales has been received as cash across the period; £12,600 is overdue.

Latest closing cash: £13,051. Figures reflect the information currently saved in LetsFix.