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

What are the common types of analysis you can do with the tRS GL Module

This article outlines some popular reports or use cases for the tRS GL Module

About the GL Module

The General Ledger Module allows Finance teams to build automated Profit and Loss Statements, Balance Sheets and Trial Balances by importing your Accounts, Cost centres and movements from your ERP or Accounting Platform.

  • Standard Measures include Opening Balance, Movements, Closing Balance or Credit Amount, Debit Amount, Transaction Amount and Budgets
  • Standard Attributes include Cost Centre and Accounts
  • Linked to your Calendars

Pre requisites

Optional components of the GL Module include:

  • GL Mapping Files (Account & Cost Centre Masters)
  • GL Calculations
  • GL Report Views
  • Linked Cost Centre and Location Codes

With these components set up and maintained, additional value can be unlocked.

Key Benefits:

  • Mapping master files allow you to set up your reporting hierarchies 
  • Automate your time consuming Finance Reporting
  • Making it easy to interact with your financial data in a structured way
  • Empower your finance team to spend more time for analysis
  • Create integrated scorecards with finance and retail KPI's together

Common use cases

  • Retailers use the Account Master file to map or attribute up to 16 columns against their Account Codes to support
    • Custom hierarchies so they can drill through the data as they need
    • Custom GL Calculations so they can easily select financial KPI's as facts
    • Custom Report Views so popular reports can be automated
  • Retailers use the Cost Centre Master file to map or attribute up to 16 columns against their Cost Centre Codes to support
    • Custom Hierarchies and valuable Totals such as "Stores" or "Concession" or even by area manager 
    • Slice and filter their P&L reporting by Cost Centre attributes eg Store or Channel P&L report. 
  • Retailers use the insights portal and Report Views to set up automated and interactive P&L and Balance Sheet reporting that can be easily downloaded in Excel
    • Handy to provide management with a simple preformatted and automated popular finance reporting
    • Thus returning more hours in the week back to finance team members so they can spend more time analysing the results and looking for opportunities.
  • Retailers use the PL Calculations and the linked Cost Centre Codes to Location Codes to build out balanced scorecards that blend traditional finance KPI's with retail KPI's for more holistic analysis of stores, channels, areas, brands or subsidiaries.
More information

If you have the GL Module and want to see if you can drive more value from it or if you are considering subscribing to the GL Module as an add on to your tRS service then please reach out to us via email to support@theretailscore.com