---
title: How do I set up my daily location budgets?
description: Use this article to understand how to format your daily 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-daily-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 daily location budgets?

## Use this article to understand how to format your daily 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 if you set your location budgets by day.

Please note that tRS also supports weekly budgets and a daily splits file to convert that number to a day budget.

Click [here to read the article on weekly budgets with daily splits.](https://fundamentals.theretailscore.com/knowledge/how-do-i-set-up-my-weekly-location-budgets?hsLang=en)

### Daily Location Budget Template

Your daily 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-58-38-82-AM.png)

And will have the following column headings.

![](https://fundamentals.theretailscore.com/hubfs/image-png-Sep-12-2021-03-01-13-06-AM.png)

In summary, location code by DATE and budget type are in the rows containing the daily budget number.

As the daily budget is already at the date level, a daily splits or trading profile template is not required.

 

- [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