Help & Support ↗ Lucanet Learning Space ↗
Getting Started
Global Functions
Lucanet Lume
Data Hub
Administration
Extended Planning & Analysis (xP&A)
Consolidation & Financial Planning
ESG Reporting
Disclosure Management
XBRL Tagger
Lease Accounting
Banking & Cash Management
User Interface in Banking & Cash Management
General Functions in Banking & Cash Management
Creating and Designing Dashboards
Signature Folder
Payments
Account Information
Cash Management
Displaying Account Balances
Disposition (Cash Pooling)
Creating and Configuring Cash Forecasts
Managing Interest
Jobs
Channels
Master Data
System
Data Collection
Tax Compliance & Reporting
Glossary

Displaying Account Balances

Overview

The Account balances workspace provides you with a central pivot view of the posting and valuta balances as well as the credit limits and liquidity of all accounts in Lucanet Banking & Cash Management (BCM). The overview also serves as the data basis for automatic dispositions, cash forecasts, and interest calculations.

The account balances combine imported bank data with forecast data and display both current and future liquidity positions — as the basis for disposition decisions and interest management.

The Account balances workspace can be found under Banking & Cash Management | Cash management | Account balances and is displayed as follows, for example:

The Account balances workspace is displayed.
Workspace 'Account balances'

Functions in the Toolbar

In addition to the general functions, the following functions are available in the toolbar of the workspace:

FunctionDescription
Standard FilterFilters the account balances by period — 7, 30, 90, 180, or 360 days into the past or into the future. Periods in the future take the forecast data into account.
Pivot SettingsEnables you to adjust the display in the pivot table:
- Show amounts in thousands: Displays amounts in units of thousands.
- Exclude Saturdays: Hides all data rows whose date falls on a Saturday.
- Exclude Sundays: Hides all data rows whose date falls on a Sunday.

Fields in the Pivot Table

The four standard data fields Balance, Balance with advices, Liquidity with advices, and Valuta balance with advices are reported in the Account currency of the respective account. All fields with the suffix (EUR), in contrast, display the value converted into euros. You add the EUR variants via the context menu (see Inserting, Moving, or Hiding Columns).

The pivot table displays the following fields by default:

FieldDescription
BalancePosting balance of the account on the respective date, without advice transactions. The basis is the closing balance of the associated account statement.
Balance with advicesMost recent available balance of the account, calculated as Balance + advice transactions.
Liquidity with advicesAvailable liquidity, calculated as Balance with advices + credit limit

Note: For accounts that are flagged as not relevant for liquidity in the master data — for example, certain blocked or escrow accounts — the liquidity is always reported as 0.
Valuta balance with advicesBalance based on the valuta date — the value date — instead of the posting date, including the advice transactions. Serves as the basis for interest calculations.
DateDate for which the account balances are reported in the respective column. The basis is the date of the closing balance from the account statement.
Account HolderName of the company or legal entity that holds the account
IBANInternational bank account number for the unique identification of the account
Account DescriptionInternal name or description of the account for easier identification
Grand TotalThe pivot table displays a Grand Total for each of the four standard data fields on the far right of the table. BCM calculates the grand total automatically — there is no separate, configurable field for it.

Inserting, Moving, or Hiding Columns

You can customize the column structure of the pivot table. To do so, right-click a column header, for example Account Holder, IBAN, Account Description, or Date. The following options are available in the context menu:

OptionDescription
TitleDisplays the name of the field that you right-clicked as the first entry of the context menu.
Move columnMoves the field within its area — row, column, or data area — by one position. The sub-entries are deactivated if no further position is available.
Insert columnInserts an additional field before the field that you right-clicked. The submenu displays only fields that are not yet contained in the pivot table — see the two tables at the end of this section. If all fields are already displayed, the entry is not displayed. In the data area, only measures are available for selection; in the row and column areas, only text and date fields.
Hide columnRemoves the field from the pivot table. The action is deactivated as long as only a single field is present in the respective area.
Reset view settingsResets the pivot table to the default layout. The Pivot Settings from the toolbar — amounts in thousands, hidden Saturdays and Sundays — are also reset. A confirmation dialog is displayed before resetting.

BCM saves your customizations automatically. The next time you open the Account balances workspace, the pivot table is displayed in exactly the configuration in which you last left the table.

The following fields are available via Insert column:

Row fields

FieldDescription
National bank codeNational bank code of the account-holding institution
AccountSuperordinate company or organizational unit of the account holder
Account typeType of the account, for example current account, fixed-term deposit account, or loan account
Account categoryName of the assigned account category
Account numberNational account number
Account currencyISO currency code of the account, for example EUR, USD, or CHF

Data fields

FieldDescription
ForecastForecast balances and liquidity based on forecast transactions, each in account currency and EUR: Forecast balance, Forecast balance with advices, Forecast liquidity, Forecast liquidity with advices, as well as Forecast transactions sum and Forecast transactions accumulated.
Credit limitCredit limit and Credit limit (EUR) as well as the negative variants Credit limit (negative) and Credit limit (negative, EUR) for charts and debit displays.
LiquidityLiquidity and Liquidity (EUR) — calculated as balance + credit limit — as well as Liquidity with advices (EUR). The Liquidity with advices variant in account currency is part of the default view.
BalanceBalance (EUR) and Balance with advices (EUR). The variants in account currency are part of the default view.
Valuta liquidityLiquidity based on the valuta date: Valuta liquidity, Valuta liquidity (EUR), Valuta liquidity with advices, and Valuta liquidity with advices (EUR).
Valuta balanceValuta balance, Valuta balance (EUR), and Valuta balance with advices (EUR). The Valuta balance with advices variant in account currency is part of the default view.
Deposit rate limitDeposit rate limit and Negative interest limit (EUR) — threshold above which a custody fee is charged on credit balances. You maintain the threshold with a validity date in the master data of the account on the Deposit rates tab; for each date, the pivot table displays the threshold valid on that day. If no custody fee is stored for the account, the field displays 0.
Advices byIntraday or not yet posted movements, each as daily sum and accumulated, in account currency and EUR: Advices by transaction date sum, Advices by transaction date accumulated, Advices by valuta date sum, Advices by valuta date accumulated.

Last updated on Aug 27, 2026

Table of Contents
OverviewNavigationFunctions in the ToolbarFields in the Pivot TableInserting, Moving, or Hiding Columns
Related Articles

Company

Legal Notice

© Copyright 2026 - Lucanet AG