How do I set up LFL or Like for Like in tRS?

tRS supports multiple methodologies for the calculating like-for-like or comp stores.  However this article focuses on setting up the template to be filled in that supports the most popular LFL methodology using a simple "Is Open" Flag of '1' or '0' to indicate if the location was open that week. 

• A location week for the current year is marked as "1" if the location was trading or to be used in LFL calculations
• Additionally, the location and week of the previous year is marked as "1" if the location was trading or to be used in LFL calculations
• When both weeks across the current and previous year are both "1", this location and week will be used in LFL calculations

Like for Like Template

Your location like for like data must be formatted and maintained in a specific structure to be uploaded into your tRS service and this is best done in MS Excel.

When preparing your budget template, the final template with look like this

And will have the following column headings.

In summary, location code by THIS YEAR and PREVIOUS YEAR and weeks 1 - 53 are in the rows containing the is open flag (is open = 1 or not open or used = 0).