Overview of Voyage P&L Concepts
To learn more about snapshot types, columns in the P&L grid, or snapshot and period comparisons, see the VIP - P&L - Voyage article.
Store Voyage P&L snapshots
Current P&L snapshots are stored when you do one of the following:
Save the voyage with the configuration flag CFGCacheVoyPnl enabled.
To allow auditing changes to the current snapshot, enable the configuration flag CFGEnablePnlSnapshotAudit.
Run a scheduled task through a message service that takes nightly snapshots.
When the configuration flag CFGAutoPnlSnapshot is enabled, VIP will take a snapshot when the financials of the voyage change, for example, when new invoices are added or if there are interface imports of port expenses.
Create a Voyage P&L report in the Report Designer
There are several ways to report on voyage P&L in Report Designer. You can do one of the following:
Create a standard P&L report
To create a standard P&L report, you can use the built-in Voyage P&L report in the Report Designer.
To access Analytics, in the top navigation, click Analytics. The Reports workspace appears.
Select Voyage P&L from the report list
3. Select the snapshot date, the comparison basis to Actual values, the variances to include, and any additional information.
Create a report using the Voyage PNL Summary dataset (one-to-many join from the Voyage table).
This report shows you Actual, Posted, and Estimated values in one with full line descriptions. This will show the same data you see in the Voyage Manager’s P&L grid with Accounts View selected.
Set the Is Accounts Mode filter to True to enable the aggregation of the data by ledger code.
Set the Force Calculation filter to True to allow force-recalculation of the report numbers to give you the most up-to-date P&L numbers for the voyage. Otherwise, the report will use either the current Voyage P&L snapshot or any snapshot uniquely identified by Snapshot Type and Snapshot Date filters. If there are multiple P&L snapshots of the same type on the same date, VIP will use the most current snapshot for that date.
Set the Include Details filter to True to see line items under each account group; otherwise, VIP will display only the account groups.
Set the Is Monthly filter to True to get data for each snapshot by the month
To get more granular data for the voyage PNL report, you can optionally join the following tables:
Voyage Pnl Detail
Voyage Pnl Drilldown
Proration in P&L
The P&L can be prorated which means calculations will be divided in a proportional way based on the ranges you set.
The following are parameters for proration:
PeriodRangeGmt - a specified range that voyage overlaps
Portion % - shows how much of the voyage (commence-complete dates) overlaps the specified range;
Is Monthly - will break down each snapshot by months
Month - shows a specific month in that breakdown (it is recommended to format it as: MMM-YY)
PeriodOpsBallastDays, PeriodOpsPortDays and all other the portion-related columns
VIP will use all related configs when pro-rating values (non-accrual snapshots - CFGDefaultPnlCalcApplyTcHire, CFGDefaultPnlCalcAdjustForOffHire, CFGDefaultPnlCalcApplyOffHire etc). The flags that PNL snapshot was taken with (except the accruals configuration flag) are not stored.
Legacy P&L Summary report
We do not recommend using the legacy Voyage P&L Summary report in Operations as it requires more manual inputs and provides very limited reporting capabilities.
