|
Item in shareholders' equity and liabilities
|
Most probable target in Excel model
|
Note
|
|
Accounts and notes payable
|
Non-interest bearing current liabilities
|
|
|
Accounts payable
|
Non-interest bearing current liabilities
|
|
|
Accrual liabilities
|
Non-interest bearing current liabilities
|
|
|
Accrued expenses
|
Non-interest bearing current liabilities
|
|
|
Accrued liabilities
|
Non-interest bearing current liabilities
|
|
|
Accrued taxes payable
|
Non-interest bearing current liabilities
|
Do not confuse this with deferred tax liabilities.
|
|
Accumulated deficit
|
Retained earnings
|
|
|
Accumulated other comprehensive income
|
Retained earnings
|
|
|
Additional paid in capital
|
Other equity
|
|
|
Advances received
|
Non-interest bearing current liabilities (Advances
received)
|
In Excel there is an own row for advances received
outside of balance sheet so that we can calculate
equity ratio. However, in balance sheet you should
include this in Non-interest bearing current liabilities.
|
|
Borrowings
|
Long-term / Short-term debt
|
|
|
Capital lease obligations
|
Other long-term (current) liabilities
|
|
|
Capital reserves
|
Other equity
|
|
|
Capital stock
|
Share capital
|
|
|
Common Stock
|
Share capital
|
|
|
Cumulative translation adjustment
|
Other equity
|
|
|
Currency translation adjustments
|
Other equity
|
|
|
Current liabilities
|
-
|
Either this is a sum item that is not imputted
to Excel or you have to allocate it to different
current liabilities.
|
|
Current portion of long-term debt
|
Short-term debt
|
|
|
Deferred income
|
Non-interest bearing current liabilities
|
|
|
Deferred income taxes
|
Deferred tax liabilities
|
|
|
Deferred tax liabilities
|
Deferred tax liabilities
|
|
|
Deferred tax liability
|
Deferred tax liabilities
|
|
|
Deferred taxes
|
Deferred tax liabilities
|
|
|
Employee related liabilities
|
Other long-term / current liabilities
|
|
|
Financial lease commitments
|
Other long-term / short-term liabilities
|
|
|
Financial liabilities
|
Long-term / Short-term debt
|
|
|
Group equity
|
-
|
This is most probably a sum item that is not imputted
to Excel.
|
|
Income tax payable
|
Deferred tax liabilities
|
|
|
Issued and paid-in share capital
|
Share capital
|
|
|
Legal and statutory reserves
|
Other equity
|
|
|
Liabilities
|
-
|
Either this is a sum item that is not imputted
to Excel or you have to allocate it to different
liabilities.
|
|
Loans
|
Long-term / Short-term debt
|
|
|
Loans payable
|
Long-term / Short-term debt
|
|
|
Long-term debt
|
Long-term debt
|
|
|
Long-term financial liabilities
|
Long-term debt
|
|
|
Long-term interest-bearing liabilities
|
Long-term debt
|
|
|
Long-term liabilities
|
-
|
Either this is a sum item that is not imputted
to Excel or you have to allocate it to different
long-term liabilities.
|
|
Long-term provisions
|
Provisions
|
|
|
Minority interest
|
Minority interest
|
|
|
Minority interests
|
Minority interest
|
|
|
Minority interests in consolidated companies
|
Minority interest
|
|
|
Minority stockholder's interest
|
Minority interest
|
|
|
Miscellaneous long-term liabilities
|
Other long-term liabilities
|
|
|
Miscellaneous short-term liabilities
|
Other current liabilities
|
|
|
Negative goodwill
|
Other equity
|
|
|
Net income
|
Retained earnings
|
|
|
Net income (loss)
|
Retained earnings
|
|
|
Net income for the year
|
Retained earnings
|
|
|
Non-current liabilities
|
-
|
Either this is a sum item that is not imputted
to Excel or you have to allocate it to different
short-term liabilities.
|
|
Notes and loans
|
Long-term / Short-term debt
|
|
|
Notes and loans, current portion
|
Short-term debt
|
|
|
Other accounts payable
|
Non-interest bearing current liabilities
|
|
|
Other accumulated comprehensive income
|
Retained earnings
|
|
|
Other comprehensive income
|
Retained earnings
|
|
|
Other current liabilities
|
Other current liabilities
|
|
|
Other debt
|
Other long-term / current liabilities
|
|
|
Other liabilities
|
Other long-term / current liabilities
|
|
|
Other long-term liabilities
|
Other long-term liabilities
|
|
|
Other long-term provisions
|
Provisions
|
|
|
Other non-current liabilities
|
Other long-term liabilities
|
|
|
Other provisions
|
Provisions
|
|
|
Other reserves
|
Other equity
|
|
|
Other reserves of the parent company
|
Other equity
|
|
|
Paid-in surplus
|
Other equity
|
|
|
Payroll taxes, social security and VAT
|
Non-interest bearing current liabilities
|
|
|
Pensions and other retirement benefits
|
Other long-term / current liabilities
|
Usually long-term
|
|
Pensions costs
|
Other long-term / current liabilities
|
Usually long-term
|
|
Preferred stock
|
Share capital
|
|
|
Provisions
|
Provisions
|
|
|
Provisions for contingencies and long-term liabilities
|
Provisions
|
|
|
Provisions for pensions and other post-employment
benefits
|
Provisions
|
|
|
Refundable deposits
|
Long-term / Short-term debt
|
|
|
Reserves of consolidated companies
|
Other equity
|
|
|
Restatement reserves
|
Other equity
|
|
|
Restructuring provisions
|
Provisions
|
|
|
Retained earnings
|
Retained earnings
|
|
|
Salaries
|
Non-interest bearing current liabilities
|
|
|
Share capital
|
Share capital
|
|
|
Share issue premium
|
Other equity
|
|
|
Shareholders' equity
|
Share capital
|
|
|
Shareholders’ equity, group share
|
Share capital
|
|
|
Shares authorized
|
Share capital
|
|
|
Shares issued
|
Share capital
|
|
|
Shares outstanding
|
Share capital
|
|
|
Shares repurchased
|
Shares repurchased
|
|
|
Short-term borrowings
|
Short-term debt
|
|
|
Short-term debt
|
Short-term debt
|
|
|
Short-term financial liabilities
|
Short-term debt
|
Or sum item that is not directly imputted to Excel.
|
|
Short-term liabilities
|
Short-term debt
|
Or sum item that is not directly imputted to Excel.
|
|
Short-term provisions
|
Provisions
|
|
|
Stockholders equity
|
Share capital
|
|
|
Subsidies and deferred revenues
|
Non-interest bearing current liabilities
|
|
|
Total current liabilities
|
-
|
Either this is a sum item that is not imputted
to Excel or you have to allocate it to different
short-term liabilities.
|
|
Total debt
|
-
|
Either this is a sum item that is not imputted
to Excel or you have to allocate it to different
liabilities.
|
|
Total group equity
|
-
|
This is most probably a sum item that is not imputted
to Excel.
|
|
Total liabilities
|
Balance sheet total
|
Not imputted in Excel (calculated automatically).
|
|
Total liabilities and group equity
|
Balance sheet total
|
Not imputted in Excel (calculated automatically).
|
|
Total liabilities and stockholders’ equity
|
Balance sheet total
|
Not imputted in Excel (calculated automatically).
|
|
Total long-term debt
|
Long-term debt
|
Or sum item that is not directly imputted to Excel.
|
|
Total long-term liabilities
|
Long-term debt
|
Either this is a sum item that is not imputted
to Excel or you have to allocate it to different
long-term liabilities.
|
|
Total non-current liabilities
|
-
|
Either this is a sum item that is not imputted
to Excel or you have to allocate it to different
long-term liabilities.
|
|
Total provisions
|
Provisions
|
|
|
Total shareholders' equity
|
|
This is most probably a sum item that is not imputted
to Excel.
|
|
Total shareholders' equity and liabilities
|
Balance sheet total
|
Not imputted in Excel (calculated automatically).
|
|
Trade accounts payable
|
Non-interest bearing current liabilities
|
|
|
Trade liabilities
|
Non-interest bearing current liabilities
|
|
|
Trade payables
|
Non-interest bearing current liabilities
|
|
|
Translation differences
|
Other equity
|
|
|
Treasury shares
|
Share capital
|
|
|
Treasury stock
|
Share capital
|
|
