Balance sheet analyses

Introduction

With the balance sheet analysis you assess your customers' financial situation from their annual, quarterly or monthly figures. You enter the balance sheet values following a template of your company; Bilendo calculates KPIs and scores from them and shows how they develop over time. The results feed into your credit decisions and appear in the credit limit decision document.

Every balance sheet carries a key date and the time span its figures cover. Every column therefore makes clear whether quarterly figures cover three months only or are cumulative since the start of the fiscal year, and trends only compare periods of the same length.

Steps

Step 1: Before you start

Step 2: Enter the general data

Open the customer and choose Options > Balance Sheet Analysis. This opens the customer's Balance Sheet Analyses page, with one tab per template. There, choose Options > Create New Balance Sheet Analysis. In Step 1: General Data you set:

For the same quarter or month you can enter two balance sheets when their period covered differs, for example the figures of the 2nd quarter only and the cumulative figures to 30.06. Bilendo does not allow a second balance sheet with the same period covered and names the existing one.

Step 3: Enter values and manual KPIs

In Step 2: Balance Sheet you enter the template's balance sheet values. In Step 3: Manual KPIs you add the KPIs your template does not calculate itself.

How to check that everything works

After saving, the balance sheet appears as a new column in the customer's balance sheet analysis. Its header names the period and, below it, the exact time span, for example "2026 Quarter 2" with "3 months to 30.06.2026" or "Cumulative, 6 months to 30.06.2026". If the time span is not what you expected, correct the key date or period covered via Options > Edit Previous Balance Sheet Analysis. The values you entered stay unchanged.

Day to day

Reading a customer's balance sheet analysis

For each template, the balance sheet analysis shows the sections Balance Sheet, KPIs and Scores, with one column per balance sheet and a Trend column.

Balance sheets of the same length share a group: Years, Quarters, Months and separate groups for cumulative figures, such as Quarters · Cumulative since start of fiscal year. Next to each group heading you see the time span of its newest balance sheet ("latest: 3 months to 30.06.2026"). Within a group the newest balance sheet is on the left. Each group can be collapsed and expanded from its heading. With only one group, no heading is shown.

A customer's balance sheet analysis with years, quarters and cumulative quarters

Comparing with the previous period or the previous year

The Trend column compares a group's newest balance sheet with an earlier one, and its heading names the balance sheet it compares with, for example "vs 2026 Quarter 1". For quarters and months you choose per group under Compare With:

The first comparison that has an earlier balance sheet is preselected, usually the previous period. Your choice applies while you stay on the page; the next time you open it, the preselection applies again.

Bilendo always compares cumulative figures with the same period of the previous year, because the previous period covers fewer months; Previous Period is greyed out there. Years are always compared with the previous year. If no matching earlier balance sheet exists, the trend cell shows a dash ("-").

Switching the currency

If the values were entered in a currency other than the template's, switch between Input currency and Template currency.

Balance sheet analyses in the decision document

The credit limit decision document shows the balance sheet analysis with the same groups and time spans, with up to three columns per group. Decision documents created before this change stay as they are.

All balance sheet analyses at a glance

Under Risk > Balance Sheet Analyses you see the balance sheet analyses of all customers in one list, also with period and time span. You can filter by template and year and search the list.

Frequently asked questions

What about balance sheets I entered earlier?
They received the end of their period as key date and count as "This quarter only" or "This month only". If you entered cumulative figures or figures to a different key date, adjust key date and period covered once via Options > Edit Previous Balance Sheet Analysis. The balance sheet then moves into the matching group.

My customer's fiscal year does not start in January. What should I keep in mind?
Choose the quarter or month of the fiscal year and enter the actual key date. Bilendo carries it over to the next balance sheet of the same kind. There is no separate fiscal-year setting.

Why can't I compare cumulative figures with the previous period?
Cumulative figures to 30.06 cover six months, those to 31.03 only three. A comparison would show a change that comes only from the different length.

Can I enter quarterly figures and cumulative figures for the same quarter?
Yes. Each appears in its own group.

Are KPIs annualised?
No. KPIs are calculated from the figures as entered.