Skip to content
English
Customer portal Sign in
Go to theretailscore.com
  • There are no suggestions because the search field is empty.

How do I work with the Cost Centre Master in the GL Module?

This article outlines what the Cost Centre Master is, why it is important and how should it be maintained in the tRS GL Module.

What is the Cost Centre Master File?

The Cost Centre Master File is an excel spreadsheet that lists out the Cost Centre Codes with additional columns to add attributes that support reporting, mapping and financial calculations.

  • It contains the Cost Centre Code,Cost Centre Name and Account Type
    (typically Profit and Loss or PL vs Balance Sheet or BS)
  • And upto 16 columns for additional attribution
  • It is loaded into your data warehouse via the Admin Console
  • And appears in your data warehouse under GL Accounts Folder
  • Is located in your tRS Admin Console and is maintained by the retailers finance team

See the list of columns below:

Why is the Cost Centre Master File important?

The Cost Centre File is incredibly important to the accuracy and usability of the GL Module.

  • Is used to define the drill path or hierarchies used in reporting
  • Is used to filter on GL reports 
    eg/ Store Level Profit and Loss or PL report by channel.
  • Is used to define the inclusion into a specific report and the sort order it should appear.

Please note
Changes to your Account Master will impact your Financial Calculations and Report Views.

How can the Cost Centre Master File be maintained?

When new cost centre are created, an email will be generated to the notification email set up for the Retail Score service alerting them that new accounts have been added and need to be mapped.

Follow these steps to keep your Cost Centre Master File upto date

1. Log into your portal and click on the spanner icon on the top ribbon

2. Navigate to the Upload Files and General Ledger Area

3. Click on the vertical three dots and download the last successful upload

4. Save the file for back up just in case you need to refer to it again

5. Add new Cost Centre Codes and fill in the required fields

Tip: It might be quicker to filter on the table to show "like" cost centre codes that share the same attributes and copy and paste their attributes for the new account codes.

6. Save As a new name

7. Go back to the Admin portal and click on the three vertical dots and select upload file

8. Browse and upload the new file and wait for a success notification.

9,. Follow the steps if an error during upload occurs or contact support@theretailscore.com