Skip to main content

Step 1: GL Segmentation

Zuora

Step 1: GL Segmentation

The GL Segments Configuration screen in Zuora is where you define and manage General Ledger (GL) Segments, which are critical for creating GL account mappings and ensuring your accounting data aligns with your financial systems. This topic provides a detailed walkthrough of the features and configurations available on this page.

Overview of GL Segments configuration

GL Segments allow you to break down your financial data into meaningful categories for accurate reporting and integration with external accounting systems. Each segment represents a component of a GL account string, for example, department, product, and transaction type. The following are the main sections:

  • Segments: Define and manage individual GL segments.

  • Additional Configurations: Specify global settings such as delimiters and default blank segment values.

  • GL Mapping Table: Links segments to GL accounts and provides their respective system identifiers.

Understanding the interface

This section helps you to understand the interface.

Segments table

The table in the Segments section lists all the configured GL segments along with their attributes:

  • Segment Order: Indicates the order in which the segment appears in the GL string.

  • Segment Name: The name of the segment, for example, Invoice Transaction Type, and Product SKU.

  • Segment Source: Specifies the type of source for the segment:

    • Object: Derived from a Zuora object, for example, Invoice, Account, and Product Rate Plan.

    • Constant: A fixed value used for all transactions.

    • Dynamic: Distinct object and field selection for each transaction type.

  • Object: Displays the Zuora object associated with the segment, if the source is "Object".

  • Dynamic: Using the dynamic segment source, you can select the object and field for each transaction type such as invoice item, taxation item, Payment application etc. 

  • Constant Value: Displays the constant value, if the source is "Constant".

  • Source Field: Indicates the specific field in the Zuora object used for the segment, for example, TransactionType_c.

  • GL Mapping: Links to the GL account mappings for the segment.

  • Actions: Options to edit or reorder segments.

  • Version: the current version of the segment. Version history records all edits/reordering or removal of segments. 

How to add or edit a segment

  1. Click Add New Segment to create a new segment or Edit to modify an existing segment.

  2. Configure the following fields:

    • Segment Name: Enter a descriptive name for the segment.

    • Source: Choose between Object, Constant, or Dynamic.

    • Object/Field: Select the related object and field if the source is Object.

    • Constant Value: Specify the constant value if applicable.

    • Map possible values of segment object and field to specific GL accounts using ‘GL Mapping’. 

  3. Save your changes.

Reordering segments

Click Reorder to adjust the order of segments. The order determines the sequence in the GL string.

Additional configurations

This section allows you to fine-tune how segments behave in specific scenarios:

Setting

Description

Discount Segment Value

Defines the value for discounts based on a product’s discount field.

Invoice Owner Segment Value

Uses the invoice owner’s segment values for GL entries.

Revenue Owner Segment Value

Uses the revenue owner’s segment values for GL entries.

Segment Delimiter

Specifies the character that separates segments in the GL string, for example, "/".

Default Value for Blank GL Segments

Sets a placeholder value, for example Blank, for segments without data.

 

How to edit additional configurations

  1. Click Edit in the Additional Configurations section.

  2. Update the settings as needed and click Save.

GL Mapping table

The GL Mapping table links the segments to specific GL accounts. This ensures the data aligns correctly with your financial systems or ERPs. 

If the source field value is of type ‘Picklist’ in Zuora, the source field value will be automatically populated, and you can input the corresponding GL codes. 

If the source field value is a free form field in Zuora, you can input the source field value and GL codes. 

How to view or edit GL Mappings

  1. Locate the relevant GL mapping in the table.

  2. Click Edit to adjust the mapping configuration.

 

 

Example segments

The following table provides example segments:

Segment Order

Segment Name

Segment Source

Object

Constant Value

Source Field

1

Invoice Transaction Type

Object

Invoice

--

TransactionType_c

2

Product Rate Plan Name

Object

Product Rate Plan

--

Name

3

Product SKU

Constant

--

GL-99792393

--

4

Account Auto Pay

Object

Account

--

Auto Pay

5

Payment Gateway

Object

Payment

--

Gateway

Version History of GL Segment Configuration

The Version History feature in the GL Segments Configuration module allows you to track changes made to individual segments, including edits, reorder actions, or deactivations. This ensures transparency and provides a historical record for auditing and troubleshooting.

Accessing Version History

  1. Navigate to Finance Settings > Chart of Accounts > GL Segments Configuration in Zuora.

  2. Identify the segment you wish to review from the Segments list.

  3. Click the version number, for example, v2, under the Version column of the desired segment.

  4. A Version History panel will open, displaying detailed information about changes made to the segment.


Note: If a segment value is blank, the system will use the default value specified in the Additional Configurations section.

You can update the delimiter in the Additional Configurations section. However, the change in Delimiter will only be effective for new transactions generated in Zuora. 

Check the source field and object for the segment to ensure correct mappings. Validate that GL mappings are active and properly configured.

Next, go to Step 2: Accounting Code Setup.