LFL: like-for-like store sales
One row per store and period: comparability status, sales this and last year, trading days and LFL.
What the template is for
Calculating like-for-like growth for the chain and selecting stores for the comparison base.
- What one row is
- one row = store × period
Columns
| Column | Code | Type | Required | Validation rule |
|---|---|---|---|---|
| Store code | store | Text | yes | a value from the customer and point reference |
| Opening date | opened | Date | yes | date YYYY-MM-DD |
| Status | status | List value | yes | comparable, new, relocated or closed |
| Period (month) | month | Text | yes | month as YYYY-MM |
| Sales this year excl. VAT | ty | Number | yes | a number not below 0 |
| Sales last year excl. VAT | ly | Number | yes | a number not below 0 |
| Trading days, this year | daysTy | Integer | yes | an integer not below 0 |
| Trading days, last year | daysLy | Integer | yes | an integer not below 0 |
| LFL, % | lfl | Number | yes | calculated: for status comparable with equal days: (this year ÷ last year − 1) × 100; otherwise 0 |
Example rows
| Store code | Opening date | Status | Period (month) | Sales this year excl. VAT | Sales last year excl. VAT | Trading days, this year | Trading days, last year | LFL, % |
|---|---|---|---|---|---|---|---|---|
| ST01 | 2024-03-01 | comparable | 2027-02 | 6,350,000 | 5,980,000 | 28 | 28 | 6.2 |
| ST02 | 2025-09-15 | comparable | 2027-02 | 5,800,000 | 5,420,000 | 28 | 28 | 7 |
| ST03 | 2026-10-01 | new | 2027-02 | 3,100,000 | 0 | 28 | 0 | 0 |
| ST04 | 2025-11-20 | relocated | 2027-02 | 2,900,000 | 2,750,000 | 28 | 28 | 0 |
The example data is illustrative: an exercise, replace it with your own.
Note
Set the comparability rule (for example, open at least 13 months) in the accounting policy and apply it the same way. Exclude stores with a moved area, a refit or a different number of days, or bring them to equal days. The example data is illustrative: an exercise, not a norm or an industry benchmark.
How to open the file
The file is UTF-8 with a BOM, comma separated, with a decimal point. Set the text format for code columns (SKU, article, GTIN) so that long numbers and leading zeros are not distorted. The validation rules are suggested defaults, not norms: your systems and contracts may require something else.
Calculations that use these fields
- Store indicators: ticket, conversion, space, staff
- Store payback: ramp-up and rent holiday by month
- Display: productivity of a linear meter and of facings by zone
- Sales plan by store
- Store comparison across the chain
- Categories: contribution to growth and margin, this year versus last
- Close the store or keep it
- Payroll and the full cost of a store employee
Documents that need this data
- LFL and comparable sales (4-5-4 calendar)
- Store KPI pack: traffic, conversion, ticket, revenue per m², payroll and shrinkage
- Store, channel and marketplace P&L
- FSBU 25, 6 and 26: lease, fixed assets and capital investments in the accounts of a retailer and a brand
- Price and volume indices: Laspeyres, Paasche, Fisher, chain indices, deflator and the 4-5-4 calendar
- Management report pack