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
- Add your file(you are here)
- Check the result(next)
- Download(next)
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.
| SHEET | COLUMNS | WHAT IT HOLDS |
|---|---|---|
| Summary | Company, CIN, PAN, Period, Standalone or consolidated, Taxonomy, Amounts in, Source file, Facts read, Warning | The header facts of the filing, one per row |
| Balance sheet | Particulars, Line (for member rows), current period, previous period, Element | The balance sheet in Schedule III order |
| Profit and loss | Particulars, Line (for member rows), current period, previous period, Element | The profit and loss statement |
| Cash flow | Particulars, Line (for member rows), current period, previous period, Element | The cash flow statement, when the file has one |
| Company information | Item, Value, Element | General details tagged in the filing |
| Notes | Note, Period, Member, Text, Element | The notes to accounts as plain text |
| All facts | Element, Label, Context, Period, Dimensions, Value, Unit, Decimals | Every 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.
| TAXONOMY | BALANCE SHEET LINES | PROFIT AND LOSS LINES | CASH FLOW LINES | BALANCE SHEET HEADINGS |
|---|---|---|---|---|
| AS taxonomy | 39 | 28 | 13 | Shareholders' funds; Non-current liabilities; Current liabilities; Non-current assets; Current assets |
| Ind AS taxonomy | 45 | 11 | 1 | Non-current assets; Current assets; Equity; Non-current liabilities; Current liabilities |
STEP BY STEP
How it works
- Get the .xml instance from the preparer or your filing records. If it came as a .zip, unzip it first.
- Drop it here. The company, CIN, period and taxonomy show at the top; choose lakhs, crores or rupees to read the figures in.
- 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.