Versions Compared

Old Version 10

changes.mady.by.user Laura Packard

Saved on

compared with

New Version Current

changes.mady.by.user Melanie Whitelock

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Home > Pooling > Pooling Distribution

...

This pooling distribution workflow is based on the most commonly used and recommended configuration, using configuration flag CFGUsePostedInPooling. Pooling results are calculated from the latest Accrual Snapshot, rather than the posted P&L.

...

Note: If there are unexpected results in the voyages, and the Monthly Accruals form is used a subsequent time, the Pooling Distribution must also be re-created basis the updated Accrual Snapshot.

...

Pooling Distribution Workflow

To run Pooling Distribution:

  1. Make sure that Monthly Accruals have been run for all vessels in the pool.

  2. On the Operations menu , under Pooling, click Pooling Distribution.


    Note: The form title is Pooling Distribution (New) if the distribution does not yet exist and is calculated. It changes to Pooling Distribution (Existing) if the distribution is previously saved and loaded in the form.

  3. Enter the Pool, Year, and Month.

    • In the Pooling Information section, the Pooling Distribution Calculation Details appear:

      • Income BP (Before Pooling) and Income AP (After Pooling)

      • Admin BP (Before Pooling and Admin AP (After Pooling)

      • Mgt Fee (Management Fee)

    • In the Pooling Result Distribution section, each line item contains the distribution details for one particular Participant.

    • To view the calculation itemized details for each distribution, right-click a line and then click View Payment Details.

    • To change the distribution period, which will change the distribution amount, click 

      Deleteto clear any unsaved records of payment amounts generated for the pool payment. After clearing the distribution, close the form. If you want to run Pooling Distribution for a new period, reopen the form.

  4. To create distribution invoices, click  to save the Pooling Distribution results. Invoice Status defaults to A, which means that the invoice is ready for approval/posting.

Pooling Distribution Reporting

On the Pooling Distribution form, to run reports, do any of the following:

...

Expand
titleRelated Configuration Flags


Name/Flag

Description

Use Posted in Pooling
CFGUsePostedInPooling

The Pooling results are calculated from the latest Accrual snapshot, instead of the Actual P&L, and the Pooling Distribution form issues a warning detailing all the relevant voyages that do not have Monthly Accruals run.

Itemize Billdet by Vessel
CFGItemizeBilldetByVsl

Creates Pool Payment detail lines associated with each vessel, rather than just grouped by owner. This should always be enabled.

Mirror Invoice as Unposted
CFGActMirrorInvoiceAsUnposted

When enabled, auto-created mirror transactions will not be posted by default.

Pool Management Fee Use Income BP
CFGPoolMgtFeeUseIncomeBP

Calculates Pooling Management Fee based on gross income before pooling instead of income after pooling. This flag takes precedence over CFGDistributePoolComm.



CFGPoolMgtFeeUseIncomeBP = Y
CFGPoolMgtFeeUseIncomeBP = N
CFGDistributePoolComm = YMgt Fee = Gross Income BP * Mgt Fee %
Gross Income BP = sum of freight, demurrage, despatch, and TCI/TCO hire after deduction of commissions
  • Mgt Fee = Mgt Fee Weight * Gross Income
  • Mgt Fee Weight = Mgt Fee Contribution/Sum (Mgt Fee Contribution)
  • Mgt Fee Contribution = Pool Days * Mgt Fee %
  • Pool Days = Days * Points
CFGDistributePoolComm = NMgt Fee = Gross Income BP * Mgt Fee %
Gross Income BP = sum of freight, demurrage, despatch, and TCI/TCO hire after deduction of commissions		Mgt Fee = Income AP * Mgt Fee %


Distribute Pool Comm
CFGDistributePoolComm

When enabled, the pool management fee is calculated as a percentage of gross revenues and distributed in the same way as the pool result. When disabled, the pool management fee is calculated as a percentage of the vessel's net income after pooling.

Use Itemized Commission Rate
CFGUseItemizedCommissionRate

Enables setting multiple Commission rates for different Pool Vessels and adds Mgt Fee % and Mgt Fee/Day columns to the Pools and Pool Assignment forms.

Pool Use Default P&L Calc Options
CFGPoolUseDefaultPnlCalcOptions

When enabled, the default P&L calculation options are used when calculating pool distributions.

Pool Calc Options Effective Date
CFGPoolCalcOptionsEffectiveDate

When set, only voyages that complete on or after the date will use the default P&L calculation options (provided CFGPoolUseDefaultPnlCalcOptions is also enabled).


Configuring Invoices

In Pooling, invoices can be configured to meet your business needs.

Name/FlagDescription
To change the descriptions of the distribution items:
Pool Result Distrib Desc
CFGPoolResultDistribDesc

The default description of result distribution lines in the pooling distribution invoices.

Pool Management Fee Desc
CFGPoolMgtFeeDesc

The default description of management fee distribution lines in the pooling distribution invoices.

To set the amount of time to go back when calculating adjustments for Pooling distributions:
Pool Adjustment Year
CFGPoolAdjYear		Specifies the number of previous years for which Pooling Adjustments should be calculated. If the value is -1 (default), the number of adjustments calculated is defined by CFGPoolAdjMonth. If CFGPoolAdjMonth is also set, CFGPoolAdjYear takes precedence.
Pool Adjustment Month
CFGPoolAdjMonth		Specifies the number of monthly adjustments to calculate if the value of CFGPoolAdjYear is -1. If CFGPoolAdjYear is also set, it takes precedence.
To control the level of details in Pooling Distribution invoices:
Pool Invoice Break Out Periods
CFGPoolInvBreakOutPeriods

Controls the level of detail in Pooling Distribution invoices:

  • 0 = No breakdown
  • 1 = Breakdown by month (default)
  • 2 = Breakdown by month for the current year and by year for the previous years



...