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
Your company needs an active balance sheet analysis template. You create templates under Settings > Risk > Balance Sheet Analysis Templates. Only once a template is active does the menu item Risk > Balance Sheet Analyses appear.
Viewing requires read access to balance sheet analyses, entering and editing requires write access. With Options > Manage Access on a customer's Balance Sheet Analyses page you control who may see that customer's balance sheet analyses.
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:
Template and Year.
Period: the whole year, a quarter or a month. Quarters and months are those of your customer's fiscal year. If the fiscal year starts in April, the first quarter ends on 30.06.
Key Date: the date the figures refer to. It is required for quarters and months and optional for years. Bilendo suggests it: from this customer's latest balance sheet of the same kind (year, quarter or month), moved to the new period, otherwise the end of the period. A fiscal year that differs from the calendar year only has to be entered once.
Period Covered (quarters and months only): This quarter only or This month only, or cumulative since the start of the fiscal year. For cumulative figures the number of months follows from the period, "Cumulative, 6 months" for the 2nd quarter. Annual balance sheets always cover the whole year. Below the field, Shown as previews how the balance sheet will be labelled.
Input Currency and Input Unit, if the figures are in a currency or unit (for example thousands) other than the template's.
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.
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:
Previous Period: the previous quarter or month, for the development from period to period.
Same Period Previous Year: the same period one year earlier, for a seasonally adjusted comparison.
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.