You want the figures of a customer, a competitor or an acquisition target in Excel, to do your own calculations, make a chart or add them to a file. Or you want the same figures for twenty companies at once. There is no need to retype them from a PDF.
The short answer
- Needed
- Pro
- Format
- Excel (.xlsx)
- Cost
- 1 credit per row, 10,000 per month
When you take figures into Excel
- A credit file. You assess a new customer, for example Bouwwerken Peeters in Geel, and want five years of equity, profit and solvency side by side in your own model.
- An acquisition or investment. You work further with EBITDA, cash flow and working capital yourself, without retyping everything from a PDF.
- A competitor analysis. You put twenty companies from your sector in one table and sort by margin or growth.
- A customer portfolio. Your accounts department wants the latest figures of every customer with an outstanding balance each quarter.
Jaarrekening.be takes the figures from every set of annual accounts filed with the National Bank of Belgium (NBB) and calculates the ratios for you. In Excel you get them per financial year, ready to filter, chart or add to a file.
Read also How to find a company's annual accounts in Belgium, and what they showExporting the figures of one company
-
Look up the company
Type the name or the enterprise number in the company search and open the company page. -
Open Data exports
Click the small downward arrow next to the company name. It is called Data exports when you hover over it. -
Download the key figures
Next to Financial ratios export, click Download. On a computer you can also do it from the Financials tab, under Ratios: the export icon sits in the table header. -
Open the file
You get an .xlsx file with one row per indicator and one column per financial year. Where a figure is missing, it says N/A.
The file contains the basic figures (turnover, gross margin, profit or loss, equity, employees), profitability (EBITDA, EBIT, net profit, margins), liquidity (cash, cash flow, working capital, current and quick ratio), solvency and debt ratio, and customer and supplier credit in days. That is about 40 rows, so about 40 credits.
The same page also offers the Full company report. That is a PDF, not a spreadsheet, and costs 100 credits.
Exporting the figures of a whole list
-
Put the companies in a list
In the sidebar under Lists, click Create new list. Add companies with Save to list on each company page, or upload a file in the Import tab: CSV, XLSX or XLS with enterprise numbers or company names in the first column. Importing is part of Pro. -
Open the figures per company
Go to the Analysis tab and choose Figures at the top. You see the Figures per company table. -
Choose the year and the columns
In the dropdown next to the title, choose All years or one financial year. Under Columns you switch on basic fields (profit, equity, gross margin, turnover, employees) and calculated ratios such as EBITDA, solvency, current ratio or customer credit. -
Export
Click Export, choose the number of rows and confirm. Each row in the file is one company in one financial year.
The same table is in the Watchlist, under Analysis, for the companies you follow. If you do not want to export an existing list but a new selection by sector, region or size, use Advanced search.
Read also Build a company list by sector and region, and download it to ExcelTips and pitfalls
- Empty turnover is normal. Only large companies have to publish their turnover. Compare small companies on gross margin, profit and equity.
- Watch the financial year. Not every financial year ends on 31 December, and a first financial year can be longer than twelve months. Do not compare an eighteen-month year with a normal year without knowing it.
- Choose "All years" deliberately. A list of 200 companies with five sets of annual accounts each comes to 1,000 rows, so 1,000 credits. If you only want the latest position, choose one financial year.
- The list export has English column headers (Enterprise Number, Turnover, Equity ...). The table starts on row 4, below the logo.
- Your balance is topped up on the first of every month. If it runs out, the export is refused rather than producing an incomplete file. With Pro you can buy extra credits, which do not expire.
- No export during a trial. Exporting works with a paid Pro subscription.
- With a free account you see the three most recent years under Ratios and download the original PDF of every filing in the Financial statements tab.