--- title: How do I set up my weekly location budgets? description: Use this article to understand how to format your weekly location budgets into the right format to be loaded into your tRS service. --- [Skip to content](https://fundamentals.theretailscore.com/knowledge/how-do-i-set-up-my-weekly-location-budgets#main-content) English Show submenu for translations [Customer portal](https://fundamentals.theretailscore.com/support-client-view?hsLang=en) ![mousemat.png\]](https://fundamentals.theretailscore.com/hs-fs/hubfs/mousemat.png?height=40&name=mousemat.png) Open main navigation Close main navigation - English Show submenu for translations - [Customer portal](https://fundamentals.theretailscore.com/support-client-view) - Go to theretailscore.com Go to theretailscore.com The Retail Score Fundamentals - There are no suggestions because the search field is empty. 1. [TRS Fundamentals](https://fundamentals.theretailscore.com/knowledge?hsLang=en) 2. [tRS Set Up](https://fundamentals.theretailscore.com/knowledge/trs-set-up?hsLang=en) 3. [01 Getting Started](https://fundamentals.theretailscore.com/knowledge/trs-set-up?hsLang=en#01-getting-started) # How do I set up my weekly location budgets? ## Use this article to understand how to format your weekly location budgets into the right format to be loaded into your tRS service. ### About tRS supports multiple budgets such as Board Budgets, Forecasts and Targets across multiple measures such as Sales and GP $.  This article explains how to set up your budgets using the correct template to get them loaded into you tRS Service. When setting your budgets at location and week level, we additionally need to fill in a second template called Daily Splits or also known as a trading profile that split the week budget into days 1 through to 7 where day 1 = your first day of your retail week.   See below for more details.   Weekly Location Budget Template Your weekly location budgets 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 ![](https://fundamentals.theretailscore.com/hubfs/image-png-Sep-12-2021-02-40-08-61-AM.png) And will have the following column headings. ![](https://fundamentals.theretailscore.com/hubfs/image-png-Sep-12-2021-02-38-50-47-AM.png) In summary, location code by year and budget type are in the rows with the weeks 1 to 53 as columns. ### Daily Splits Template As mentioned above, the weekly budgets will need to split to the day level using a trading profile or % contribution to the total week.   Tip: If you are budgeting at fulfilled sales and you are setting your ecom budget, your online budget might be '0' for Saturday and Sunday but a higher percentage for Monday and Tuesday as these orders are processed.  Conversely, if you are budgeting based on demand sales (when the order was received) then you would need to split your weekly budget for online across all 7 days.  When preparing your budget template, the final template with look like this ![](https://fundamentals.theretailscore.com/hubfs/image-png-Sep-12-2021-02-47-58-78-AM.png) And will have the following column headings. ![](https://fundamentals.theretailscore.com/hubfs/image-png-Sep-12-2021-02-47-26-32-AM.png) In summary, location code by year AND week number are in the rows with the days 1 to 7 as columns. **PLEASE NOTE:**   1\. The format of the cell should be decimal numbers and rounded to three decimals 2\. The 7th Day column should be a formula of 1 - sum(days 1 to 6) which will ensure each location / week combination adds exactly to "1"   - [tRS Set Up](https://fundamentals.theretailscore.com/knowledge/trs-set-up?hsLang=en#main-content) - [01 Getting Started](https://fundamentals.theretailscore.com/knowledge/trs-set-up?hsLang=en#01-getting-started) - [02 How to Guide](https://fundamentals.theretailscore.com/knowledge/trs-set-up?hsLang=en#02-how-to-guide) - [03 Get Help](https://fundamentals.theretailscore.com/knowledge/trs-set-up?hsLang=en#03-get-help) - [tRS Insights Portal](https://fundamentals.theretailscore.com/knowledge/trs-insights-portal?hsLang=en#main-content) - [01 Getting Started](https://fundamentals.theretailscore.com/knowledge/trs-insights-portal?hsLang=en#01-getting-started) - [02 How To Guides](https://fundamentals.theretailscore.com/knowledge/trs-insights-portal?hsLang=en#02-how-to-guides) - [tRS Pivot4Power Users](https://fundamentals.theretailscore.com/knowledge/trs-pivot4power-users?hsLang=en#main-content) - [02 How To Guide](https://fundamentals.theretailscore.com/knowledge/trs-pivot4power-users?hsLang=en#02-how-to-guide) - [03 Get Help](https://fundamentals.theretailscore.com/knowledge/trs-pivot4power-users?hsLang=en#03-get-help) - [tRS Modules](https://fundamentals.theretailscore.com/knowledge/trs-modules?hsLang=en#main-content) - [01 General Ledger](https://fundamentals.theretailscore.com/knowledge/trs-modules?hsLang=en#01-general-ledger) - [02 Traffic Counters](https://fundamentals.theretailscore.com/knowledge/trs-modules?hsLang=en#02-traffic-counters) - [04 Google Analytics](https://fundamentals.theretailscore.com/knowledge/trs-modules?hsLang=en#04-google-analytics) - [tRS Admin](https://fundamentals.theretailscore.com/knowledge/trs-admin?hsLang=en#main-content) - [01 Getting Started](https://fundamentals.theretailscore.com/knowledge/trs-admin?hsLang=en#01-getting-started) - [02 How To Guide](https://fundamentals.theretailscore.com/knowledge/trs-admin?hsLang=en#02-how-to-guide) - [03 Get Help](https://fundamentals.theretailscore.com/knowledge/trs-admin?hsLang=en#03-get-help) - [tRS Case Studies](https://fundamentals.theretailscore.com/knowledge/trs-case-studies?hsLang=en#main-content) - [01 Analysis](https://fundamentals.theretailscore.com/knowledge/trs-case-studies?hsLang=en#01-analysis) - [tRS Archive Library](https://fundamentals.theretailscore.com/knowledge/trs-archive-library?hsLang=en) - [tRS Development Release Notes](https://fundamentals.theretailscore.com/knowledge/trs-development-release-notes?hsLang=en#main-content) - [Releases](https://fundamentals.theretailscore.com/knowledge/trs-development-release-notes?hsLang=en#releases) - [tRS Connect](https://fundamentals.theretailscore.com/knowledge/trs-connect?hsLang=en#main-content) - [01 About](https://fundamentals.theretailscore.com/knowledge/trs-connect?hsLang=en#01-about) - [02 Set Up](https://fundamentals.theretailscore.com/knowledge/trs-connect?hsLang=en#02-set-up) - [03 Getting Started](https://fundamentals.theretailscore.com/knowledge/trs-connect?hsLang=en#03-getting-started) - [tRS Planner](https://fundamentals.theretailscore.com/knowledge/trs-planner?hsLang=en) [![Chill listening crop-3](https://fundamentals.theretailscore.com/hs-fs/hubfs/tRS1-2.png?width=102&height=55&name=tRS1-2.png "Chill listening crop-3")](http://theretailscore.com?hsLang=en) theretailscore.com Help Center Copyright © 2026, the Retail Score