Syntha Lab RU

LFL: like-for-like store sales

One row per store and period: comparability status, sales this and last year, trading days and LFL.

Layouts for documents 9 columns 4 example rows

Download CSV ↓

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

ColumnCodeTypeRequiredValidation rule
Store codestoreTextyesa value from the customer and point reference
Opening dateopenedDateyesdate YYYY-MM-DD
StatusstatusList valueyescomparable, new, relocated or closed
Period (month)monthTextyesmonth as YYYY-MM
Sales this year excl. VATtyNumberyesa number not below 0
Sales last year excl. VATlyNumberyesa number not below 0
Trading days, this yeardaysTyIntegeryesan integer not below 0
Trading days, last yeardaysLyIntegeryesan integer not below 0
LFL, %lflNumberyescalculated: for status comparable with equal days: (this year ÷ last year − 1) × 100; otherwise 0

Example rows

Store codeOpening dateStatusPeriod (month)Sales this year excl. VATSales last year excl. VATTrading days, this yearTrading days, last yearLFL, %
ST012024-03-01comparable2027-026,350,0005,980,00028286.2
ST022025-09-15comparable2027-025,800,0005,420,00028287
ST032026-10-01new2027-023,100,00002800
ST042025-11-20relocated2027-022,900,0002,750,00028280

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

Documents that need this data

Download CSV ↓ Open interactively →