IMOS - Account Analysis

Home > Financials > Account Analysis


Accounts Analysis Report

The Accounts Analysis Report is a built-in Financials report formatted by Veson Nautical. It is only available if your company posts IMOS invoices to the financial ledger — if you do not post transactions, this report is not usable. Need something more flexible? Use the Report Designer to build a custom report instead.

What it Shows

The report summarizes financial transactions for a specified range of accounts and dates, with optional filters for vessel, voyage, and vendor name. For each account, it displays:

  • The starting balance on the selected start date

  • Each transaction's debit, credit, and running balance

  • Retained earnings carried forward

You can group transactions by account, vessel, or vendor.

For example: If an account starts the period with a balance of $10,000, and a $2,000 debit transaction is posted, the running balance updates to $12,000. The next transaction — say, a $500 credit — brings the running balance to $11,500, and so on through the date range.

Accounting Convention

Because this report is a view into the General Ledger, balances follow standard accounting sign conventions. Accounts increase as follows:

Account Type

Increases With

Assets

+ (debit)

Liabilities

− (credit)

Revenues

− (credit)

Expenses

+ (debit)

So in the example above, a debit increasing the balance tells you this is likely an Asset or Expense account; if it were a Liability or Revenue account, that same debit instead decreases the running balance.

Report Options

image-20260707-043221.png

Field Name

Mandatory / Optional

Description

Use When?

Major Company

Mandatory

A Type W company from the Address Book; this field determines which transactions are included in the report.

Always

Vessel

Optional

A selection list of specific Vessels to include.

When you want to filter for a specific vessel.

Account From/Account To

Optional

A selection list of specific GL Account Codes to include.

When you want to filter for specific GL account codes. All the account codes between Account From and Account To is included in the report.

Dept

Optional

The Department name, as defined in Financials.

When you want to filter for a specific Department.

Date From / Date To

Mandatory

The Date Range for the Transactions to include based on the transaction Accounting Date.

When you want to run reports against specific time periods.

Voyage From / VoyageTo

Optional

The Voyage Number range for the transaction to include.

When you want to filter for specific Voyage Numbers.

Vendor Name

Optional

The Vendors of the transactions to include in the report.

When you want to see the transactions of a certain Vendor.

Group By...

Mandatory

Select one way to group the data. Options are Account, Vessel, Vessel/Voyage, Vendor, Dept, and Transaction.

When you want the transactions to be grouped in a different way: by Account, Vessel, Vessel/Voyage, Vendor, Department, or Transaction.

Show Rate / Quantity

Optional

  • Selected: The report shows an additional column: Rate (per unit)/Quantity.

  • Cleared: The report does not show the additional column.

When you want to see the breakdown of Unit Price and Quantity for some transactions.

Show Vendor

Optional

  • Selected: The report shows an additional column: Vendor.

  • Cleared: The report does not show the additional column.

When you want to see the Vendors of the transactions.

Show Transaction Type

Optional

  • Selected: The report shows an additional column: Transaction Type.

  • Cleared: The report does not show the additional column.

When you want to see the Transaction Type (AR/AR) of the transactions.

Show LOB

Optional

  • Selected: The report shows an additional column: LOB.

  • Cleared: The report does not show the additional column.

When you want to see the LOB of the transactions.

Show Tax Code / Rate

Optional

  • Selected: The report shows additional columns: Tax Code and Tax Rate.

  • Cleared: The report does not show the additional columns.

When you want to see the tax information for the transactions.

Show Bill Src / Subcode

Optional

  • Selected: The report shows additional columns: Bill Source and Bill Subcode.

  • Cleared: The report does not show the additional columns.

When you want to see the Bill source and code as defined in the Business Rule of the Account Codes.

Hide groups with no balance changes

Optional

  • Selected: The report does not show groups with no balance changes in the selected period.

  • Cleared: The report shows all groups in the period.

When you want to hide groups with no balance changes.

When extracting a large volume of data (for example, extracting a large range of data), the built-in Account Analysis report may fail with an out-of-memory error. In those cases, use the Account Analysis table in Report Designer to build the same extract. For smaller, targeted queries, the built-in report is sufficient.

Common Mistakes for Discrepancies in the Account Analysis Report


Account Analysis Report Parameters
Account Analysis.png

If discrepancies appear in the report, navigate to the transaction in question and confirm the following:

  1. Ensure that Company is set to the correct instance.

  2. Confirm that the dates range aligns with the voyage dates and the account period you want to review.

  3. Confirm that the accounts selected for the report include the accounts associated with transaction.