Split buckets

  • Release version: Xanadu
  • Updated August 1, 2024
  • 1 minute to read

    • Buckets contain groomed general ledger expenses. These expenses can be associated with items like a cost center, vendor, department, or location.

    Before you begin

    Role required: cost_transparency_admin or cost_transparency_analyst

    You can only split buckets that are not yet assigned to accounts.

    About this task

    You can split the expenses in a bucket by any of the attributes such as cost center, vendor, department, or location. Starting with Istanbul release, you can use any custom attributes to split buckets. Use Financial Data Source Field Map for bringing additional attributes to split a bucket by enabling the Used for Bucket split option.

    For example, if a bucket includes expenses for two different vendors, you can split the bucket into two smaller buckets, one for each vendor. Each split bucket contains the groomed general ledger expense associated with that vendor.

    Procedure

    1. Open the Allocation Setup stage in the workbench.
    2. In the Allocation Setup pane, click the split bucket icon (The bucket tree icon) for the bucket you want to split.
      The split bucket window appears, showing you the amount of money in the bucket.
    3. From the Split by list, either select an attribute that is associated with the groomed general ledger expense or select Percentage.
      • If you select an attribute, the new buckets appear in the window with default names in the format [original bucket name] > [attribute name].
      • If you select Percentage, enter the percentages for the new buckets and give each bucket a name.
      • If you select Weighted split method, you have the choice to split the bucket amount to any segment in the hierarchy based on the available metric.
        Note:

        If the metric is Total weight configured, then you cannot split a bucket using that weighted metric.

        After you split a bucket based on the Weighted method, you cannot split it further.

      A preview of the split buckets appears in the window along with the expense amounts for each bucket.

    4. Click Split Bucket.
    5. The application creates new buckets and splits the expenses among them according to your settings.

      Buckets that are split appear with a folder icon.

      Figure 1. Split bucket
      A split bucket
    6. To view a newly split bucket with the other buckets that were split along with it, click the folder icon.
    7. To revert the bucket split, click Unsplit Bucket.
      Figure 2. Splitting the hardware bucket
      Splitting the hardware bucket