Filingo
toolsxbrl-reader

AOC-4 XBRL viewer: read an MCA XBRL file and export it to Excel

Open an AOC-4 XBRL .xml as a readable balance sheet, P&L and notes. Export to Excel or PDF.

YOU BRING
The AOC-4 XBRL instance file as .xml (unzip it first if it came as a .zip)
YOU GET
The balance sheet, P&L, cash flow and notes to read, export to Excel or print
YOUR DATA
Read in your browser. The file is never uploaded.

Use the tool

  1. Add your file(you are here)
  2. Check the result(next)
  3. Download(next)
Did this help?

IN SHORT

What the MCA XBRL reader does

This free XBRL reader opens the instance document filed with AOC-4 XBRL and shows it as financial statements: balance sheet, profit and loss and cash flow with the previous year alongside, the notes as text, and every fact in a searchable table. It reads files under both the AS and the Ind AS taxonomy, exports to Excel and prints to PDF. The file is read in the browser and never uploaded.

Updated

XBRL to Excel: the sheets in the workbook

The Excel download is made in your browser from the .xml instance filed with AOC-4 XBRL. The statements show the current period next to the previous one, in the unit you pick: rupees, thousands, lakhs, millions, crores.

Sheets and columns in the XBRL reader Excel download
SHEETCOLUMNSWHAT IT HOLDS
SummaryCompany, CIN, PAN, Period, Standalone or consolidated, Taxonomy, Amounts in, Source file, Facts read, WarningThe header facts of the filing, one per row
Balance sheetParticulars, Line (for member rows), current period, previous period, ElementThe balance sheet in Schedule III order
Profit and lossParticulars, Line (for member rows), current period, previous period, ElementThe profit and loss statement
Cash flowParticulars, Line (for member rows), current period, previous period, ElementThe cash flow statement, when the file has one
Company informationItem, Value, ElementGeneral details tagged in the filing
NotesNote, Period, Member, Text, ElementThe notes to accounts as plain text
All factsElement, Label, Context, Period, Dimensions, Value, Unit, DecimalsEvery fact in the file, nothing left out

AOC-4 XBRL viewer: which taxonomies it reads

It reads files under the AS and the Ind AS taxonomy. The statements place the line items whose element names it knows. Every other amount is listed below them, so nothing is left out.

Statement lines laid out for each taxonomy
TAXONOMYBALANCE SHEET LINESPROFIT AND LOSS LINESCASH FLOW LINESBALANCE SHEET HEADINGS
AS taxonomy392813Shareholders' funds; Non-current liabilities; Current liabilities; Non-current assets; Current assets
Ind AS taxonomy45111Non-current assets; Current assets; Equity; Non-current liabilities; Current liabilities
A line shows only when the file has a figure for it. Counts are the line items the reader is set up to place.

STEP BY STEP

How it works

  1. Get the .xml instance from the preparer or your filing records. If it came as a .zip, unzip it first.
  2. Drop it here. The company, CIN, period and taxonomy show at the top; choose lakhs, crores or rupees to read the figures in.
  3. Read the statements and notes, search all facts for any element, then download the Excel or print to PDF.

GOOD TO KNOW

Common questions

Do I need the MCA XBRL validation tool or Java?
No. It reads the instance file directly in your browser. It does not check the file against MCA's business rules; use the MCA tool for that before filing.
Why are some figures under 'Other amounts reported'?
The statements place line items whose element names are known, in Schedule III order. Every other amount in the file is listed below them in file order, so nothing is left out. Ind AS files have more of these, because fewer Ind AS element names could be checked.
Can it open a .zip?
Not yet. Unzip it first and drop the .xml inside.
Is the PDF the same as the signed financial statements?
No. It is a readable copy of what was tagged in XBRL, with labels taken from the element names. Check any figure you rely on against the signed statements.

Related tools