Guides 5 min read

Export annual accounts to Excel, for one company or a whole list

How to get the figures from Belgian annual accounts into Excel: all financial years and ratios of one company in one file, or the same figures for a whole list of companies.

Jaarrekening.be

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

To see all years of a company side by side, with the ratios already calculated, open the company's Data exports on Jaarrekening.be and download the Financial ratios export. For a whole list, export the Figures per company table in the Analysis tab. Both exports are part of Pro.
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 show

Exporting the figures of one company

  1. Look up the company

    Type the name or the enterprise number in the company search and open the company page.
  2. Open Data exports

    Click the small downward arrow next to the company name. It is called Data exports when you hover over it.
  3. 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.
  4. 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.
What you see under Ratios is also in the Excel file, for every financial year.

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

  1. 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.
  2. Open the figures per company

    Go to the Analysis tab and choose Figures at the top. You see the Figures per company table.
  3. 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.
  4. 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 Excel

Tips 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.
Read also How do you read a balance sheet? In four steps, with a worked example

Frequently asked questions

Is exporting annual accounts to Excel free?

No. With a free account you see the three most recent years under Ratios and download the original PDF of every filing. The export to Excel is part of Pro, and does not work during the free trial.

What does an export cost on Jaarrekening.be?

Each row costs 1 credit, and Pro includes 10,000 credits per month. The key figures of one company come to about 40 rows. A list with figures per financial year counts one row per company per year.

Which years are in the export?

For one company, every financial year for which there are annual accounts, each in its own column. For a list you choose: all years or one financial year.

Can I export to CSV instead of Excel?

Jaarrekening.be delivers an .xlsx file. Excel, Numbers and Google Sheets can save it as CSV with Save as.

Is every balance sheet item in the export?

No. The export contains the key figures and ratios: turnover, gross margin, profit, equity, employees, EBITDA, solvency, liquidity, customer and supplier credit and more. For the full annual accounts with every item, download the original PDF in the Financial statements tab.

How quickly do new annual accounts show up?

New filings are read in every day. Annual accounts published today are usually there tomorrow, and then also in your next export.

Why is turnover empty?

Because most small companies do not publish their turnover. Only the full format makes it mandatory; the abbreviated and micro formats show the gross margin.

All years of a company in one Excel file

Look up a company and view the key figures of recent years. With Pro you download them, for one company or a whole list.

All guides