User Guide

1. About anuboXBRL

anuboXBRL analytics add ins bring company disclosure data directly into Microsoft Excel. Our add ins support iXBRL (inline XBRL) filings for US‑GAAP (United States Generally Accepted Accounting Principles) and IFRS (International Financial Reporting Standards) with ESEF (European Single Electronic Format).

What is XBRL?

XBRL (eXtensible Business Reporting Language) is the open international standard for digital business reporting. Being used in more than 50 countries worldwide it is today's key technology for global capital markets and the key technology of tomorrow, considering sustainability data. XBRL replaces older reports based on paper, PDF and HTML with digital versions that are more accurate, clearly defined, platform-independent and testable.

Key Benefits of anuboXBRL Analyzer

• Enabling Microsoft Excel to eliminate the conceptual weakness of being designed for unstructured data only
• Enabling Microsoft Excel to use structured data, thereby enabling the full, unrestricted, power of Artificial Intelligence and Machine Learning (in development)
• Enabling Microsoft Excel to use the world standard XBRL
• Extending the usage scenarios of Microsoft Excel
• Fundamentally reducing the organizational risk of using Microsoft Excel in professional finance

anuboXBRL Add ins

• What they do: read iXBRL (inline XBRL) reports and insert their content in Microsoft Excel sheets.
• Two editions with different approaches:
  • anuboXBRL Reader = directly inserts report's content in the sheet
  • anuboXBRL Analyzer = inserts ANUBO custom functions (which insert report's content)
  The Analyzer's approach assigns semantic meaning and context information to inserted values, which extends usage scenarios for analyzing and AI. ANUBO custom functions are Microsoft Excel formulas that automatically retrieve and calculate data from iXBRL reports.
• User Guide scope: This User Guide covers both anuboXBRL Reader and anuboXBRL Analyzer. Sections that apply to Analyzer only are marked with the Premium tag.
• Who it's for: investment, finance and sustainability professionals; no prior XBRL knowledge required.
• Where can I get iXBRL reports for US GAAP and IFRS/ESEF?: see Chapter 4
• Terminology:
  • Concept (the reported item, e.g., Revenue)
  • Period (date or date range for the reported item)
  • Link role (defines how financial statements are organized into tables, like Balance Sheet or Income Statement)
  • Axis / member (categories for breaking down data, like 'Geographic Region: North America' or 'Product Line: Software')

2. Installation Scenarios

Scenario 1 – Individual User (Single Microsoft 365 Account)

1. Open Microsoft Excel → Insert → Get Add-ins.
2. Search for anuboXBRL Reader and click Add.
3. The task pane opens automatically and guides you to the registration page: https://azan92.anubo.eu/license-api/web/public-register/.
4. On the registration page, enter your email address to create your anubo account. We also recommend adding your Microsoft 365 sign-in address. This enables convenient single sign-on (SSO) in the add-in when you open Microsoft Excel while signed in with that Microsoft 365 account.
5. After confirming the email, reload the add-in (or Microsoft Excel) and start using the anuboXBRL Reader.

Scenario 2 – Company or Organization (Microsoft 365 Domain)

1. Microsoft 365 admin: Go to Microsoft 365 Admin Center.
2. Go to Settings → Integrated Apps → Upload custom apps.
3. Select Office Add-in and provide the manifest URL: https://prod.azan82.anubo.com/app/v1/manifests/anubo-addin-stable.xml.
4. In Microsoft Entra ID → Enterprise applications → anuboXBRL → Permissions, click Grant admin consent for: User.Read, Files.Read.All, email, openid, profile, offline_access.
5. Ensure Integrated Apps and user consent policies allow add-ins.
6. Users then find anuboXBRL Reader available in Microsoft Excel automatically.

3. Installation and Setup

Supported Microsoft Excel platforms

• Microsoft Excel for Windows (Microsoft 365) – Full functionality
• Microsoft Excel for Mac (Microsoft 365) – Full functionality
• Microsoft Excel for the web – Full functionality
• Microsoft Excel for Windows (Office LTSC 2024 / LTSC 2021) – Full functionality
• Microsoft Excel for Windows (Office 2019, perpetual) – Supported via Credential Login. Office 2019 update must be up to date.

Sign in and licensing

• Microsoft 365 / Office LTSC 2024 / Office LTSC 2021
  If your organization allows it, you are signed in automatically via Microsoft SSO (Single Sign-On) when the task pane opens. SSO allows you to sign in automatically using your Microsoft work account.
  If you see a consent prompt, approve it (if your organization allows user consent), or ask your company administrator to grant tenant-wide consent for the add-in.
• Single-user license policy
  The anubo Add-in license is a single-user license. If you log in again while logged in—for example, on a different device—the original login will be automatically logged out. This allows you to switch between devices and use the add-in, but it is not possible to use a single license on multiple devices simultaneously.
• Office 2019 (perpetual)
  SSO is not available. The add-in uses Credential Login instead. Credential Login requires entering your ANUBO account email and password manually.
  1. Open the task pane (Microsoft Excel ribbon → anuboXBRL).
  2. Enter the email and password you registered with.
  3. After successful login, your license is validated exactly as it is with SSO on other platforms.

Company/Microsoft 365 Administrators

Some features—such as automatic SSO sign-in—depend on your Microsoft 365 tenant configuration. A Microsoft 365 tenant is your organization's Microsoft cloud environment. Please review the following:

A) Microsoft 365 Admin Center (For organizational deployment)

1. Open Microsoft 365 Admin Center (https://admin.microsoft.com)
2. Go to Settings → Integrated Apps
3. Click Upload custom apps
4. Select app type Office Add-in
5. Provide the manifest URL: https://prod.azan82.anubo.com/app/v1/manifests/anubo-addin-stable.xml
6. Follow the prompts to complete the installation

B) App permissions & consent (Microsoft Entra ID / Azure AD)

1. Open Entra ID (formerly Azure AD) → Enterprise applications and locate anuboXBRL (or search by the Application (client) ID from the add-in manifest). Entra ID is Microsoft's identity and access management service.
2. Open Permissions (or Permissions and consent).
3. Click Grant admin consent for the required scopes: User.Read, Files.Read.All, email, openid, profile, and offline_access.
4. Confirm the status shows Granted for [Organization].
5. If your organization disables user consent, admin consent is required before first use.

C) Policies that can block SSO

• Integrated Apps / Office Add-ins must be allowed.
• User consent policy determines whether end users can accept the consent prompt themselves.
• Conditional Access (MFA / device rules) can block token issuance.
• End users must be signed into Office with their Microsoft 365 work/school account.

D) Firewall configuration requirements

To ensure reliable connectivity, allow outbound HTTPS to these domains (no inbound rules needed):

• https://azan92.anubo.eu – Main backend API server
• https://prod.azan82.anubo.com – Production application server
• https://anubo.com – Company website and support
• https://appsforoffice.microsoft.com – Office.js and add-in platform resources (Microsoft)

Ports

• HTTPS (443) required
• HTTP (80) optional, only for non-sensitive fallback requests if used by your environment (HTTPS is recommended)

Proxy / content filtering

• Ensure no proxy rule or content filter blocks the domains above.
• Allow long-running HTTPS requests (data processing and downloads may be larger).

Firewall Rules

Your IT administrator should configure the firewall to:

1. Allow outbound HTTPS (443) traffic to the domains listed above
2. Allow outbound HTTP (80) traffic to the domains listed above
3. Ensure no proxy or content filtering blocks these domains

4. Quick Start

4.1 Open the task pane

Microsoft Excel ribbon → Add‑ins → anuboXBRL. The task pane appears on the right.

[Screenshot placeholder: Task pane collapsed with section headers]

4.2 Load a report

1. In Company & Reports, choose a company and report date (closing date).
2. Click Load.

[Screenshot placeholder: Company & Reports selection]

4.3 Insert a label and a value

1. Go to Report Data – Items.
2. Select a concept (e.g., Revenue) and a period (instant = single date; duration = date range).
3. Select a cell in the sheet and click Insert Label or Insert Value.

Reader: inserts the final number. Analyzer: inserts a dynamic formula that recalculates.

[Screenshot placeholder: Insert Label/Value]

4.4 Create a table

1. Open Report Data – Tables.
2. Pick a link role (the layout of a table inside the report).
3. Optionally choose axes/members (breakdowns like region/product) and period pairs (e.g., Q vs PY).
4. Click Insert Table.

Reader: writes static, properly scaled values. Analyzer: writes dynamic formulas for labels and values.

[Screenshot placeholder: Tables setup and result]

5. Where to get US-GAAP/IFRS/ESEF iXBRL reports?

The anuboXBRL Reader & Analyzer Add-in comes with several demo reports (IFRS and US-GAAP) so you can explore its features right away.

If you prefer to analyze your own company reports, you can upload XBRL or iXBRL files directly into the Add-in.

anuboXBRL Reader and anuboXBRL Analyzer Basic require the add-in user to manually download iXBRL reports from public filing portals or company websites. Future editions of the Add-in (anuboXBRL Analyzer Classic and Professional) will include integrated data retrieval, allowing direct access to public disclosures without manual downloads.

Below you'll find the most reliable sources and short step-by-step instructions for both US-GAAP and IFRS/ESEF disclosures.

US-GAAP Filings (SEC.gov)

Source: SEC.gov | Search Filings

How to Download a Report

1. Visit SEC's Company Search and enter the company name or ticker symbol.
2. Choose a report (for example *10-K* or *10-Q*).
   If "Interactive Data" appears, XBRL data are available — click Interactive Data. Interactive Data is the machine-readable version of company disclosures. The US SEC uses this term.
3. In the displayed report, select the yellow button labeled *10-Q* or *10-K* in the top-left corner.
4. Open the Menu (top-left) and choose "Save XBRL ZIP file."
5. In the anuboXBRL Analyzer, upload the downloaded iXBRL ZIP file to start your analysis. The iXBRL ZIP file contains the structured financial/non-financial data that can be analyzed with anuboXBRL.

IFRS / ESEF Filings (European Issuers)

Source: filings.xbrl.org | Filing Index

How to Download a Report

1. Open filings.xbrl.org.
2. Search for the company you wish to analyze.
3. Click the Download button next to the desired filing to obtain the iXBRL ZIP file.
4. Upload this iXBRL ZIP file in the anuboXBRL Analyzer.

Notes

• Future editions of the Add-in (anuboXBRL Analyzer Classic and Professional) will include integrated data retrieval, allowing direct access to public disclosures without manual downloads.

6. Task Pane Tour

6.1 Company & Reports

Manage which XBRL report (the structured financial/non-financial data file) you work with in Microsoft Excel.

• Demo reports: Two demo datasets are available out of the box:
  • US‑GAAP (United States GAAP)
  • ESEF/IFRS (European Single Electronic Format / IFRS)
• Upload (ZIP file):
  • Click Upload to add your own report as a single .zip file.
  • After uploading, the report appears in the Company dropdown list.
  • Uploaded reports are stored in your personal cloud space (only you can access them). Personal cloud is your private online storage space for uploaded reports.
  • Storage limits (per user):
    • anuboXBRL Reader: up to 10 reports
    • anuboXBRL Analyzer basic: up to 100 reports
• Select a report:
  • Choose a company/report and Closing Date from the dropdowns.
  • Selection automatically triggers either:
    • Processing of the XBRL report (first time) - Processing converts the raw XBRL data into a format that Microsoft Excel can work with
    • Or retrieval of the already processed dataset from your personal cloud
• Rename:
  • You can rename a report (e.g., to a clear, short Company Abbreviation).
  • The Company Abbreviation is what appears in ANUBO custom functions (e.g., =ANUBO.XBRLValue("DEMO_MICROSOFT", ...)).
• Delete:
  • Remove an uploaded report from your personal cloud when it's no longer needed.
  • This action removes it from the Company dropdown and frees personal storage.

Tip: After uploading, allow processing to complete before inserting items or tables. Processing status is shown in the task pane.

6.2 Report Data – Items

• Search/select a concept (reported item).
• Choose period (instant/duration).
• Actions:
  • Insert Label (name of the concept)
  • Insert Value (number, scaled based on decimals)
  • Insert All (batch for the current selection)

6.3 Report Data – Tables

• Pick a link role (table layout in the report).
• Choose axes and members (breakdowns like region/product).
• Select period pairs for columns (e.g., current vs prior).
• Insert tables:
  • Reader: static, scaled values; labels resolved.
  • Analyzer: dynamic formulas for labels and values.

6.4 Report Data – Sections

• Insert curated sections (groups of items) in one step.
• Behavior mirrors Items (Reader static / Analyzer dynamic).

6.5 Attributes Premium

• Analyzer only: Insert a professional report header; change parameters in ANUBO Custom Functions.
• In Reader, this section is visible but disabled with an upgrade prompt.

6.6 Settings and Status

• Edition badge (Reader/Analyzer), session status, diagnostics.
• Links to learn more and support.

7. Reader vs Analyzer

7.1 At a glance

7.2 When to use which edition

• Reader: final numbers for static reporting packs and speed.
• Analyzer: dynamic workbooks that should refresh/recalculate.

You can upgrade from Reader to Analyzer from within the task pane wherever premium actions are shown.

Upgrade to anuboXBRL Analyzer

8. ANUBO Custom Functions Premium

ANUBO custom functions are Microsoft Excel formulas that retrieve XBRL data directly. They're available in the Analyzer edition and provide dynamic, recalculating data.

8.1 Core Data Functions Premium

These functions retrieve the main financial/non-financial data from XBRL reports:

8.2 Metadata Functions Premium

These functions provide additional information about the XBRL report and its data, useful for headers, footnotes, and data validation:

8.3 Function Syntax Premium

Core Data Functions Premium

ANUBO.XBRLLabel

=ANUBO.XBRLLabel(company, closingDate, dimension, startDate, endDate, concept)

• company: Company abbreviation (e.g., "DEMO_MICROSOFT")
• closingDate: Report closing date in YYYY-MM-DD format
• dimension: Dimension string (usually empty "")
• startDate: Period start (YYYY-MM-DD) or empty for instant
• endDate: Period end (YYYY-MM-DD) or empty for instant
• concept: XBRL concept ID (e.g., "us-gaap:Revenue") - A unique identifier for each financial item

ANUBO.XBRLValue

=ANUBO.XBRLValue(company, closingDate, dimension, startDate, endDate, concept)

Same parameters as XBRLLabel, but returns the value (number or text). Numeric values are properly scaled.

ANUBO.XBRLTABLELABEL & ANUBO.XBRLTABLEVALUE

=ANUBO.XBRLTABLELABEL(company, closingDate, dimension, startDate, endDate, linkRole, concept, member, labelRole)

• linkRole: Table layout URL - Defines which financial statement the data comes from
• concept: XBRL concept ID - A unique identifier for each financial item
• member: Dimension member (e.g., "srt:ProductOrServiceAxis:us-gaap:ProductMember") - Specifies the category breakdown
• labelRole: Label type ("rowConcept", "columnConcept", etc.) - Determines what type of label to retrieve

Metadata Functions

ANUBO.XBRLReportCompany

=ANUBO.XBRLReportCompany(company, closingDate)

• company: Company abbreviation
• closingDate: Report closing date

ANUBO.XBRLReportDate

=ANUBO.XBRLReportDate(company, closingDate)

Returns the report closing date.

ANUBO.XBRLDATASETPERIOD

=ANUBO.XBRLDATASETPERIOD(company, closingDate, startDate, endDate)

• startDate: Period start date
• endDate: Period end date

XBRL reports typically contain data for multiple periods (for example, the current year and the previous year, or multiple quarters). When working with values for a concept, this function provides the resolved dataset period so you can verify exactly which period is being used. For duration facts, it returns a range like YYYY-MM-DD – YYYY-MM-DD; for instant facts (balance sheet items), it returns a single date YYYY-MM-DD. If a concept exists for several period starts with the same period end, provide a startDate to remove ambiguity.

ANUBO.XBRLUNIT

=ANUBO.XBRLUNIT(company, closingDate, dimension, startDate, endDate, concept)

Same parameters as XBRLValue, but returns the unit information. Examples: US Dollar (USD), Euro (EUR), shares.

ANUBO.XBRLDEC

=ANUBO.XBRLDEC(company, closingDate, dimension, startDate, endDate, concept)

Returns decimal precision information for the concept. Example: a decimals value of -6 means the reported numbers are in millions.

ANUBO.XBRLCONTEXTPERIOD

=ANUBO.XBRLCONTEXTPERIOD(company, closingDate, dimension, startDate, endDate, concept)

Returns context period details for the concept.

ANUBO.XBRLDimension

=ANUBO.XBRLDimension(company, closingDate, concept, dimensionName)

• dimensionName: Name of the dimension to retrieve

8.4 Examples Premium

Core Data Function Examples Premium

Metadata Function Examples Premium

8.5 Error Handling Premium

• #VALUE!: Invalid parameters or concept not found
• #REF!: Company or report not loaded
• #N/A: No data available for the specified criteria

Tip: Use the task pane to insert functions automatically with correct parameters, then copy the formula to other cells.

9. Advanced Features

9.1 Working with Dimensions Premium

XBRL reports often break down data by dimensions (axes) like product lines, geographic regions, or business segments.

• Finding dimensions: Use the task pane's table view to see available axes and members
• Dimension syntax: "AxisName:MemberName" (e.g., "srt:ProductOrServiceAxis:us-gaap:ProductMember")
• Multiple dimensions: Separate with semicolons in custom functions

9.2 Period Types Premium

• Instant: Point-in-time data (balance sheet items)
  • Use empty startDate and endDate: ANUBO.XBRLValue("COMPANY", "2024-12-31", "", "", "", "concept")
• Duration: Period data (income statement items)
  • Specify both dates: ANUBO.XBRLValue("COMPANY", "2024-12-31", "", "2024-01-01", "2024-12-31", "concept")

9.3 Link Roles (Table Layouts)

Link roles are predefined table structures that organize data into standard formats. Common types include:

• Balance Sheet (Statement of Financial Position)
• Income Statement (Statement of Income / P&L)
• Statement of Cash Flows
• Notes to Financial Statements

Use the task pane's table view to browse available link roles for your selected report.

9.4 Scaling and Decimals Premium

XBRL values include decimal information for proper scaling:

• Negative decimals (e.g., -6): Divide by 1,000,000 (millions)
• Positive decimals (e.g., 2): Round to 2 decimal places
• Pure units: No scaling applied

ANUBO functions automatically apply correct scaling based on the XBRL data.

9.5 Custom Report Headers Premium

Analyzer only: Use the Attributes section to insert professional report headers with:

• Company name and logo
• Report date and period
• Currency and units
• Regulatory information

10. Troubleshooting

10.1 Common Issues

10.2 Data Quality Issues

• Missing values: Some concepts may not have data for all periods
• Inconsistent periods: Different companies may use different reporting periods
• Label variations: Same concept may have different labels across reports

10.3 Performance Tips

• Load reports once: Keep reports loaded to avoid re-processing
• Use specific periods: Narrow date ranges for faster lookups
• Limit table size: Large tables with many dimensions can be slow
• Close unused workbooks: Free up memory for better performance

10.4 Getting Help

• Task pane diagnostics: Check the Settings section for error messages
• Microsoft Excel formula auditing: Use Microsoft Excel's formula evaluation tools
• Support resources: Contact support through the task pane links

11. Glossary

11.1 XBRL Terms

Concept

A specific financial reporting item (e.g., "Revenue", "Assets", "Cash") defined in a taxonomy

Taxonomy

A dictionary of concepts and their relationships used for XBRL reporting (e.g., US-GAAP, IFRS)

Instance Document

The actual XBRL report containing company data tagged with concepts

Link Role

A URL that defines how concepts are organized into tables or presentations

Dimension

An axis for breaking down data (e.g., by product line, geographic region, business segment)

Member

A specific value along a dimension (e.g., "North America" for geographic dimension)

Period

The time period for reported data (instant for balance sheet, duration for income statement)

Unit

The measurement unit for numeric values (e.g., USD, shares, pure numbers)

Decimals

Information about how to scale numeric values (negative = divide, positive = round)

11.2 anuboXBRL Terms

Reader Edition

Free version that inserts static values and labels

Analyzer Edition

Premium version with dynamic formulas and advanced features

Company Abbreviation

Short identifier used in custom functions (e.g., "DEMO_MICROSOFT")

Closing Date

The report date (as-of date) for the financial statements

Personal Cloud

Your private storage space for uploaded reports

Processing

Converting raw XBRL data into anuboXBRL's internal format

11.3 Microsoft Excel Terms

Custom Function

User-defined Microsoft Excel formula (like ANUBO.XBRLValue)

Task Pane

The side panel in Microsoft Excel that provides the anuboXBRL interface

Add-in

A Microsoft Excel extension that adds new functionality (like anuboXBRL)