Financial analysis

Financial analysis uses Microsoft Power BI to bring together financial key performance indicators (KPIs), charts, and financial statements. Power BI is embedded in the application. The focus of Financial analysis is analytical reporting. Personas across an organization can view, research, understand, and act.

Financial analysis combines data from the general ledger and subledgers to give a more complete picture of the financial health of an organization.

Note

This document uses the following Power BI terminology:

  • Report – A single .pbix file that all the visuals on all tabs are saved to.
  • Page – A tab in a single .pbix file. Each page can contain one or more visuals.
  • Visual – A single source of data, such as a card, KPI, chart, graph, matrix, or financial statement. A page that has a financial statement as a visual can have no other visuals, because of the size of the data that is being reported on.

The Financial analysis workspace is focused on letting you view and filter the data on existing reports. You are able to add new visuals to the Financial analysis workspace. The Financial analysis workspace is available for the current company as well as all companies to show data for all legal entities, regardless of the legal entities that the role has access to.

Dynamics 365 Finance setup

General ledger

The main account type and the main account categories are used to fill in appropriate default main accounts on the Balance sheet financial statement and the various Income statement financial statements in Financial analysis.

On the Main accounts page, you must define your main account so that one of the following types is assigned to it:

  • Revenue
  • Expense
  • Assets
  • Liabilities
  • Equity

Do not assign any other main account type, such as Balance sheet or Profit and Loss, to your main accounts. Reporting can't determine the type of main account when other main account types are assigned, because they aren't granular enough. The type of main account must be determined to show liabilities and revenue as positive amounts on financial reports.

To appear on the financial statements and to be included in various other visuals, such as KPIs, each main account must be assigned a main account category. The main account categories have been enhanced so that they include a display order. The display order is used specifically on financial statements in Financial analysis. After you edit or add a new main account category, you can change the Display order value to define the order that the main account categories should be shown in on a financial statement. If you must change the display order for many main account categories, you can use the Open in Excel feature to quickly edit and publish the changes back to the application.

Entity store

The data for Financial analysis is pulled from the Entity store (System administration > Setup > Entity store). If you open the CFO overview or Financial analysis workspace, and the following warning message appears in the visuals, you must update the entities.

Warning.

You must update the following entities to see data in the Financial analysis workspace:

  • Financial reporting transaction data version 3
  • Credit and collections V2
  • LedgerCovLiquidityMeasurement
  • Purchase cube
  • Sales cube

You can define a recurring batch to regularly update the data in the entities. Because each entity is completely rebuilt during an update, select the time and frequency of entity updates carefully. The primary entity that is used for financial statements is the FinancialReportingTransactionData entity. Therefore, you might decide to update that entity more often.

Security

Currently, the data on embedded Power BI reports can't be limited to the legal entities that the user has access to. Therefore, the embedded Power BI reports are controlled through duties in the security setup. The duties that are defined allow access to data for either all legal entities or only the active company. The following table shows the duties that exist and the roles that they are assigned to. The duties can be removed or assigned to different roles, based on your organization's requirements.

Duty Roles Description
View financial analysis current company
  • Accountant
  • Accounting manager
  • Accounting supervisor
  • Auditor
  • Budget manager
  • Chief executive officer
  • Chief financial officer
  • Financial controller
This duty provides access to Financial analysis. By default, the active company is used as a filter. You can't add other legal entities.
View financial analysis all company In Microsoft Dynamics 365 Finance, Enterprise edition 7.3, this duty isn't assigned to a role. In the next release, this duty will be assigned to the Chief financial officer role. This duty provides access to the menu item for the CFO overview workspace. By default, the active company is used as a filter. However, you can add all legal entities, regardless of whether the user has access to the other legal entities.

Financial reporting vs. Financial analysis

Although Financial analysis contains financial statements, it isn't a replacement for Financial reporting in the application. The default financial statements in Financial analysis are limited in scope and don't include all types of financial statements. Financial reporting is still the primary tool for designing, creating, and generating statutory financial statements.

The following comparison chart will help differentiate the two options:

Feature Financial Reporting Financial analysis
Edit default reports Yes No
Create new reports Yes No
Print reports Yes No
Export to Excel Yes Limited Exports raw data to Excel, not a formatted report
Support reporting hierarchy/Organization hierarchy Yes No
Report on subledger data Yes. Limited to only vendor, customer. Yes. Vendor, customer, vendor/customer groups, vendor/customer addresses, etc.
Reporting Currency Yes. Accounting currency and translate to reporting currency. No. Accounting currency only.
Security Yes. Adheres to Finance reporting tree security. Limited View reports for all companies (regardless of finance and operations security) or only active company
Support different Chart of accounts and fiscal years Yes No
report on external data No No
Support consolidations Yes Limited Can report on multiple companies but use accounting currency only

The following financial statements are available:

  • Trial balance
  • Balance sheet
  • Income statement by region
  • Income statement actual vs. budget
  • Income statement with variances
  • 12-month trend income statement
  • Expenses three-year trend
  • Expenses by vendor
  • Sales by customer

Edit visuals

In previous releases of Financial analysis, none of the visuals could be edited. In future releases, users who have the appropriate security will be able to create new visuals, copy existing visuals, and edit visuals. Although the .pbix files that contain the reports are available as resources, we don't recommend that you edit the default reports. Additional changes will be made to the data model, default reports, and custom financial statement visual that are used to create the financial statements. Therefore, to take advantage of new features and changes to the data model in the next release, you will have to redo any changes that you made to the default reports through Microsoft Power BI Desktop.

Filtering

Users can filter the report by using the Filter pane on the left. This pane is the same pane that is available through Power BI Desktop. There are various levels of filtering, some of which might not be available, depending on what you've selected on a page (tab) or whether you're using the drill-through capabilities:

  • Report-level filters – These filters are applied to all visuals on all pages (tabs).
  • Page-level filters – These filters are applied to all visuals on the active tab. These filters are applied on top of the report-level filters.
  • Visual-level filters – These filters are applied only to the selected visual. These filters are applied on top of the page level filters.
  • Drill-through filter – This filter filters from a "source" visual that is applied to the current visual when you drill through from the source visual to the current visual.

To remove a specific filter value, select the eraser symbol next to it. Don't remove a filter by selecting the X. If you select the X, the field that you're filtering on is removed as a filter option. If you accidentally remove a field from the filter, close the workspace, and then reopen it. The default filter settings will be reapplied.

By default, when you first open workspaces, the active legal entity is used as the report-level filter. Depending on their security, users might be able to add other legal entities or change the default legal entity that is selected in the filter.

The Fiscal calendar filter is required so that the correct calendar is used for the visual. By default, the report-level filter is set to the active legal entity's fiscal calendar. If you change the filter to a fiscal calendar that has a different start or end date, the beginning balances won't be included. Therefore, your Balance sheet financial statements won't show the correct balances. If you select an additional fiscal calendar in the filter, you will have an additional set of columns. Each additional set of columns shows the amounts for a different fiscal calendar.

The Posting layer filter is also required. By default, the filter is set to Current. You can select additional posting layers in the filter to show the aggregated amounts.

Filters are also available for the Date and Fiscal year fields. Typically, these filters are applied at the page level. By default, the Date filter uses a relational date that you can change. You can also remove the relational date filter and use the Fiscal year filter instead.

Currency

All visuals that report on general ledger data show amounts in the accounting currency. Therefore, when you filter on the legal entity, you must be careful to include only legal entities that have the same accounting currency. Otherwise, you will aggregate data in different currencies.

All visuals that report on subledger data, such as the Cash flow forecast and Top 10 visuals, show amounts in the system currency. The system currency and system exchange rate type are defined on the System parameters page.

The Balance by bank account visual uses amounts in the bank accounts' currency.

Dimensions

The default financial statements don't include any financial dimensions but are focused only on the main account. Support for financial dimensions will be available in future releases, when the reports become editable. Organizations will then be able to filter on financial dimension values.

Some financial statements contain dimensions that are based on subledger transactions. The goal of the new financial statements is to enable filtering on dimensions that aren't set up as financial dimensions. For example, the default Expenses by vendor report lets you expand down beyond the main account, so that you can see the balances broken down by vendor. The vendor isn't set up as a financial dimension. Instead, the system returns to the originating subledger transaction to find the vendor.

The following dimensions are used on the default reports. None of these dimensions are financial dimensions.

  • Vendor
  • Vendor group
  • Customer
  • Customer group
  • Country/region
  • State/province
  • City

Important

If you summarize transactions for multiple vendors or customers in a single voucher by using the financial journals, the data will be incorrect. The reporting process can't determine which vendor or customer is related to a specific ledger account in a journal entry, because that information isn't maintained anywhere. Therefore, we do not recommend that you enter multiple vendors, customers, fixed assets, or projects in a single voucher.

Drill on data

Various levels of drilling are available through Power BI. Each level has a different name and different functionality. You can also drill on rows and columns. This section discusses the various options by using the Trial balance financial statement as an example and showing how you can drill on the rows. The same functionality exists for columns. You just have to change the Drill on setting.

In the following illustration, the Trial balance statement is collapsed to the highest level of the row hierarchy, the main account type.

Trial balance statement.

To view the next level of the hierarchy, the main account categories, you can set the Drill on field to Rows and then select the Expand button (the third button after the Drill on field). You now see all the main account categories expanded. Currently, Power BI doesn't let you expand only one row or column but still see all the other rows or columns.

Trial balance drill down on rows.

To expand to the main accounts for all rows, you can again use the Expand button. However, to drill down to the main accounts for only one row, first select the Drill down button (the single downward-pointing arrow on the right side of the window), and then select the row to drill down on. The following illustration shows the result when the Sales row is selected after the Drill down button is selected.

Trial balance expand button.

After you drill down on a single row, multiple clicks are required to return to the full trial balance. The Drill up button (the first button after the Drill on field) drills up only in the context of the Sales category, as shown in the following illustration.

Trial balance drill up button.

You can continue to use the Drill up button to return to the highest level of summarization for the rows.

Power BI also has a button that lets you go to the next level in the hierarchy (the second button after the Drill on field). The effect of this button differs from the effect of the Expand button (the third button after the Drill on field), which is used to expand the hierarchy. When you expand the hierarchy, the hierarchy is maintained on the report. For example, as was shown earlier, if you expand on the main account type, you still see the main account type on the report. However, when you go to the next level in the hierarchy, the report no longer shows the parent in the hierarchy, as shown in the following illustration.

Trial balance drill back button.

To see the transaction details behind the summarized balances, you can select some amounts to drill back into Financial and Operations.

The drill-back from the financial statements takes you to the Accounting source explorer (ASE), not to the voucher transactions. The ASE doesn't show just the accounting entries in the general ledger. Instead, it shows the details of the subledger transaction. Therefore, you get much more detail about the originating transaction and can use it for analysis. For example, you can see who the vendor or customer was, what the customer bought or the vendor sold, and even what project was on the transaction.

The following filters from the financial statements are sent to the ASE, so that the ASE shows the transactions that are aggregated:

Required fields for filtering:

  • Legal entity
  • Fiscal calendar
  • Year
  • Main account ID

Optional fields for filtering:

  • Quarter
  • Month
  • Period

If you don't expand down far enough on a row, the drill-down doesn't work. For example, if you expand down only to the main account category, you can't drill down into the ASE on the balance, because the main account is a required field for filtering in the ASE.

If you expand down too far on a row, the additional filters on the financial statements aren't sent to the ASE. Therefore, you might see a difference in your numbers. For example, if you expand down to the country or region on the rows of the Income statement by region financial statement, the country or region isn't included as a filter in the ASE.

Note

You can drill further down on the financial statement rows or columns than the ASE currently supports for filtering. Therefore, in some situations, the sum of detailed transactions in the ASE won't match the balance that you're drilling back on. This functionality will continue to be enhanced in the future.

Hierarchies

The default financial statements use two hierarchies to drill and expand on the data. One hierarchy is for the rows, and the other hierarchy is for the columns. Both hierarchies are predefined in the design of the financial statement. For most financial statements, the row hierarchy is Main account type > Main account categories > Main account. However, some reports have additional fields, such as Country and Region. The additional nodes of the hierarchy are based on subledger data for each transaction.

For the columns, the hierarchy is focused on the legal entities and the fiscal periods. For most financial statements, the column hierarchy is Legal entity > Fiscal calendar > Fiscal year > Quarter > Period.

Currently, the financial statements don't support the organizational hierarchies, which let you aggregate data.

Data limitations

The financial statement visuals have a limit on the number of rows that can be shown. Currently, the limit is set to 30,000. If you exceed this limit, the visual will have a warning symbol to notify you about this situation.

Data limitations.

If the maximum is exceeded, the totals that appear on the financial statement will be incorrect, because not all the rows were loaded into the visual.

Empty rows

Power BI doesn't provide an option to hide and show empty rows. If a row doesn't have any data, the row won't appear in the visual.

Additional resources for Power BI

The information in the following resources isn't required in order to enable the embedded reports for the Financial analysis workspace in a production environment. Instead, they are helpful for dev boxes and if you want to embed your own Power BI reports.

Breakdown of account categories by page and visual

Account categories used by page and visual

Page or tab Visual title Account type filters Account category filters
Financial overview Current ratio DIVIDE('Transaction detail'[Current assets], 'Transaction detail'[Current liabilities])
Working capital 'Transaction detail'[Current assets] – 'Transaction detail'[Current liabilities]
Gross margin 'Transaction detail'[Total revenue] – 'Transaction detail'[Cost of goods sold]
Debt to total assets DIVIDE('Transaction detail'[Current liabilities], 'Transaction detail'[Total assets])
Cost of goods sold 'Transaction detail'[Cost of goods sold]
EBIT 'Transaction detail'[Total revenue] – 'Transaction detail'[Total operating expenses] + 'Transaction detail'[Additional earnings]
Revenue 'Transaction detail'[Total revenue]
Trial balance Revenue, expense, asset, liability, or equity None
Cashflow Requires LedgerCovLiquidityMeasurement
Expenses 'Transaction detail'[Total expenses] and Budget expenses = CALCULATE(SUM('Budget'[Accounting currency amount]), 'Budget'[Amount type] = "Expense")
Revenue and expense insights Revenue 'Transaction detail'[Total revenue]
Expenses 'Transaction detail'[Total expenses]
Gross margin 'Transaction detail'[Total revenue] – 'Transaction detail'[Cost of goods sold]
Gross margin % DIVIDE('Transaction detail'[Gross margin], 'Transaction detail'[Total revenue])
Net income 'Transaction detail'[Total revenue] – 'Transaction detail'[Total expenses]
EBIT 'Transaction detail'[Total revenue] – 'Transaction detail'[Total operating expenses] + 'Transaction detail'[Additional earnings]
Revenue by region None 'Transaction detail'[Subledger Total revenue]
Revenue and expenses None 'Transaction detail'[Total expenses] for previous year and 'Transaction detail'[Total revenue]
Expenses by category None 'Transaction detail'[Total expenses]
Expenses by region None 'Transaction detail'[Subledger Total expenses]
Subledger insights Multiple None None
Trial balance None None
Balance sheet Revenue, expense, asset, liability, or equity None
Income statement by region Revenue or expense None
Income statement actuals vs budget Revenue or expense None
Income statement with variances Revenue or expense None
12-month trend income statement Revenue or expense None
Expenses three year trend Expenses three year trend Expense

None after Dynamics 365 Finance version 10.0.37. The following list is for earlier versions:

  • COGS – Cost of goods sold
  • SELLEXP – Selling expense
  • ADMINEXP – Administrative expense
  • MANUEXP – Manufacturing expense
  • TANDEEXP – Travel and entertainment expense
  • PROJEXP – Project operation expense
  • SALARYEXP – Salaries expense
  • OTHEREMPEXP – Other employee expense
  • INTEXP – Interest expense
  • TAXEXP – Tax expense
  • DEPREXP – Depreciation expense
  • INCTAXEXP – Income tax expense
  • OTHEREXP – Other expense
Expenses by vendor Expenses by vendor Expense

None after Dynamics 365 Finance version 10.0.37. The following list is for earlier versions. Uses 'Transaction detail'[Subledger Actual operating].

  • COGS – Cost of goods sold
  • SELLEXP – Selling expense
  • ADMINEXP – Administrative expense
  • MANUEXP – Manufacturing expense
  • TANDEEXP – Travel and entertainment expense
  • PROJEXP – Project operation expense
  • SALARYEXP – Salaries expense
  • OTHEREMPEXP – Other employee expenses
  • INTEXP – Interest expense
  • TAXEXP – Tax expense
  • DEPREXP – Depreciation expense
  • INCTAXEXP – Income tax expense
  • OTHEREXP – Other expenses
Sales by customer Sales by customer Revenue Sales (Uses 'Transaction detail'[Subledger Actuals credits positive])

Measures used in the previous table

'Transaction detail'[Current assets]

Current assets = 
CALCULATE (
    'Transaction detail'[Actuals credits positive], (changed in 10.0.26)
    'Account category'[Account category name]
        IN {
            "CASH",
            "CASHEQUIV",
            "SHORTTERMINVEST",
            "AR",
            "INV",
            "NOTESREC",
            "WIP",
            "PREPAIDEXP",
            "CURASS", (added in 10.0.26)
            "OTHERCA" }
)

'Transaction detail'[Current liabilities]

Current liabilities = 
CALCULATE(
    'Transaction detail'[Actuals credits positive], (changed in 10.0.26)
    'Account category'[Account category name] 
        IN { 
            "AP",
            "NOTESPAY",
            "CURRENTMATLTD",
            "TAXPAY",
            "INTPAY",
            "DIVPAY",
            "LEASEPAY",
            "SINKPAY",
            "CURLIAB", (added in 10.0.26)
            "OTHERCURLIA",
            "LONGTERMDEBT" }
)

'Transaction detail'[Cost of goods sold]

Cost of goods sold = 
CALCULATE
(
    'Transaction detail'[Actual operating],
    'Account category'[Account category name] = "COGS"
)

'Transaction detail'[Total assets]

// After version 10.0.37:
Total assets =
CALCULATE (
    'Transaction detail'[Actual operating],
    'Account'[Account type] = "Asset"
)

// Before version 10.0.37:
Total assets = 
CALCULATE
(
    'Transaction detail'[Actual operating],
    'Account category'[Account category name] 
        IN { 
            "CASH", 
            "CASHEQUIV", 
            "SHORTTERMINVEST", 
            "AR", 
            "INV", 
            "NOTESREC",
            "WIP",
            "PREPAIDEXP",
            "OTHERCA",
            "LONGTERMINVEST",
            "PPE",
            "ACCUDEP",
            "INTANASSET",
            "OTHERASSET" }
)

'Transaction detail'[Total operating expenses]

Total operating expenses = 
CALCULATE
(
    'Transaction detail'[Actual operating],
    'Account category'[Account category name] 
        IN { 
            "COGS",
            "SELLEXP",
            "ADMINEXP",
            "MANUEXP",
            "TANDEEXP",
            "PROJEXP",
            "SALARYEXP",
            "OTHEREMPEXP",
            "INTEXP",
            "TAXEXP",
            "DEPREXP",
            "OTHEREXP",
            "CHRNOTUSEWORKCAP" }
)

'Transaction detail'[Total expenses]

// After version 10.0.37:
Total expenses =
CALCULATE (
    'Transaction detail'[Actual operating],
    'Account'[Account type] = "Expense"
)

// Before version 10.0.37:
Total expenses = 
'Transaction detail'[Total operating expenses] +
CALCULATE
(   
    'Transaction detail'[Actual operating],
    'Account category'[Account category name] IN 
    { 
        "INCTAXEXP",
        "GAINLOSSASSET",
        "AMORTINTAGASSET"
    }
)

'Transaction detail'[Total revenue]

// After version 10.0.37:
Total Revenue =
CALCULATE (
    'Transaction detail'[Actual operating],
    'Account'[Account type] = "Revenue"
)

// Before version 10.0.37:
Total revenue = 
CALCULATE(
    'Transaction detail'[Actual operating],
    'Account category'[Account category name] 
        IN {
            "SALES", 
            "OTHERINC", 
            "SALESRETDIS" }
)

'Transaction detail'[Additional earnings]

Additional earnings = 
CALCULATE (
'Transaction detail'[Actual operating],
'Account category'[Account category name]
IN { 
            "REVNOTPRODWORKCAP", 
            "GAINLOSSASSET", 
            "AMORTINTAGASSET" } 
)

Note

The following measures were added or updated in version 10.0.37.

'Transaction detail'[Actuals]

Actuals = CALCULATE(-sum('General ledger attributes'[PRIMARYAMOUNT]), 'General ledger attributes'[ISCREDIT] = "Yes") + CALCULATE(sum('General ledger attributes'[PRIMARYAMOUNT]), 'General ledger attributes'[ISCREDIT] = "No")

'Transaction detail'[Subledger Total revenue]

Subledger Total revenue =
CALCULATE (
    'Transaction detail'[Subledger Actual operating],
    'Account'[Account type] = "Revenue"
)

'Transaction detail'[Subledger Total expenses]

Subledger Total expenses =
CALCULATE (
    'Transaction detail'[Subledger Actual operating],
    'Account'[Account type] = "Expense"
)

'Transaction detail'[Subledger Actual operating]

Subledger Actual operating =
CALCULATE (
    'Transaction detail'[Subledger Actuals credits positive],
    'General ledger attributes'[Transaction Type] = "RegularOperating"
)

'Transaction detail'[Subledger Actuals credits positive]

Subledger Actuals credits positive =
CALCULATE ('Transaction detail'[Subledger Actuals], Account[Account typical balance] = "Debit" )
        - CALCULATE ( 'Transaction detail'[Subledger Actuals], Account[Account typical balance] = "Credit")

'Transaction detail'[Subledger Actuals]

Subledger Actuals = SUM('Transaction detail'[ACCOUNTINGCURRENCYAMOUNT])

Account category description by name table

Use the following table to find the long form name of an account category.

Account category name Account category description
ACCUDEP Accumulated depreciation
ADDPAIDINCAPCOM Additional paid in capital - Common
ADDPAIDINCAPPREF Additional paid in capital - Preferred
ADMINEXP Administrative expense
AMORTATIVOS Amortização de ativos
AMORTINTAGASSET Amortization of intangible assets
AP Accounts payable
AR Accounts receivable
ATIVOSFIXOS Ativos fixos
ATIVOSINTANG Ativos intangiveis
ATIVOSLP Ativos a long prazo
CAIXA Caixa
CAPITAL Capital
CASH Cash
CASHEQUIV Cash equivalents
CHRNOTUSEWORKCAP Charges not using working capital
COGS Cost of goods sold
COMMONDIV Common dividends
COMMONSTOCK Common stock
CONSOLIDACAO Consolidação
CONSOLIDATIONS Consolidations
CP Contas a pagar
CPV Custo de produtos vendidos
CR Contas a receber
CREDITOSLP Creditos de longo prazo
CURASS Current assets
CURLIAB Current liabilities
CURRENTMATLTD Current maturities on long-term debt
CUSTSERV Custo de prestação de serviço
DEPACUM Depreciação acumulada
DEPREXP Depreciation expense
DESPADMIN Despesas administrativas
DESPDEPREC Despesas depreciação
DESPFIN Despesas financeiras
DESPIMP Despesas de impostos
DESPPROD Despesas de produção
DESPPROJ Despesas de projetos
DESPSAL Despesas de salários
DESPVENDAS Despesas de vendas
DIVPAY Dividends payable
ENCUMBRANCE Encumbrance
EST Estoque
ESTATISTICAS Contas estatisticas
EXIGIVELLP Exigivel longo prazo
EXP Expense
GAINLOSSASSET Gain or loss on asset disposal
IMPPAGAR Impostos a pagar
IMPRECUP Impostos a recuperar
INCTAXEXP Income Tax Expense
India COA IN COA
India COA import Import IN COA
INTANASSET Intangible assets
INTEXP Interest expense
INTPAY Interest payable
INV Inventory
INVEST Investimentos
INVESTLP Investimentos de longo prazo
Japanese Japanese import
JURPAGAR Juros a pagar
LEASEPAY Leases payable (current)
LONGTERMDEBT Long-term debt
LONGTERMINVEST Long-term investments
LUCPERD Lucros e perdas
MANUEXP Manufacturing expense
NONCURASS Non-current assets
NONCURLIAB Non-current liabilities
NOTESPAY Notes payable
NOTESREC Notes receivables
OTHERASSET Other assets
OTHERCA Other current assets
OTHERCURLIA Other current liabilities
OTHEREMPEXP Other employee expenses
OTHEREXP Other expenses
OTHERINC Other income
OUTATIVOS Outros ativos
OUTCP Outras contas a pagar
OUTDDESPEMP Outras despesas com empregados
OUTDESP Outras despesas
OUTPASSIVOS Outros passivos
OUTREC Outras receitas
PERDASDIV Perdas diversas
PERDASGANHOS Perdas e ganhos de ativos
PPE Property plant and equipment
PRE-ENCUMBRANCE Pre-encumbrance
PREFERREDDIV Preferred dividends
PREFERREDSTOCK Preferred stock
PREPAIDEXP Prepaid expenses
PROD Trabalho em progresso
PROJEXP Project operation expense
RETEARN Retained earnings
RETVENDAS Retorno de vendas e descontos
REV Revenue
REVNOTPRODWORKCAP Revenues not producing working capital
SALARYEXP Salaries expense
SALERETDIS Sales returns and discounts
SALES Sales
SALESRETDIS Sales return discount
SELLEXP Selling expense
SHAREFUND Shareholders funds
SHORTTERMINVEST Short-term investments
SINKPAY Sinking Fund payable (Current)
STATISTICAL Statistical accounts
TANDEEXP Travel and entertainment expenses
TAXEXP Tax expense
TAXPAY Taxes payable
TAXREC Tax receivable
TotalAccounts Total accounts
TREASTOCK Treasury stock
VENDAS Vendas
VIAGEM Viagem
WIP Work in process
その他の流動負債 その他の流動負債
その他の流動資産 その他の流動資産
その他の資本剰余金 その他の資本剰余金
仮払消費税 仮払消費税
任意積立金 任意積立金
出資金 出資金
前受収益 前受収益
前受金 前受金
前受金 - その他流動資産 前受金 - その他流動資産
前払費用 前払費用
受取手形 受取手形
土地 土地
売掛金 売掛金
工具器具備品 工具器具備品
建物 建物
建設仮勘定 建設仮勘定
引当金(流動性のもの) 引当金(流動性のもの)
当期未処分利益 当期未処分利益
投資固定資産 投資固定資産
投資有価証券 投資有価証券
支払手形 支払手形
新株引受権付社債 新株引受権付社債
有価証券 有価証券
未収入金 未収入金
未収収益 - その他流動資産 未収収益 - その他流動資産
未払金 未払金
棚卸資産 棚卸資産
構築物 構築物
機械および装置 機械および装置
法令上の引当金 法令上の引当金
法定準備金 法定準備金
減価償却累計額 減価償却累計額
無形固定資産 無形固定資産
特別修繕引当金 特別修繕引当金
現金および預金 現金および預金
短期借入金 短期借入金
短期貸付金 短期貸付金
社債 社債
繰延資産 繰延資産
船舶航空機 船舶航空機
買掛金 買掛金
貸倒引当金 貸倒引当金
資本 資本
車両運搬具 車両運搬具
転換社債 転換社債
退職給与引当金 退職給与引当金
長期借入金 長期借入金
長期前払費用 長期前払費用
長期未払金 長期未払金
長期貸付金 長期貸付金
長期預り金 長期預り金
預け金 預け金
預り金 預り金

Custom account categories

The CFO Overview workspace doesn't currently support custom account categories. As an alternative, you can create a Power BI report and publish it to a workspace. For more information, see Connect to the services used with Power BI.