xbrl manual-for-cost-audit-final

Manual for Step by Step filling up of Cost Audit Report in

Convert2xbrl ‘EXCEL’ file

Preamble

2

Preamble

3

The Cost Audit Report and Compliance Report as approved by the Boardshould be used as source for creation of the XBRL instances

Though the XBRL instances of Cost Audit Report / Compliance Report areprepared on the basis of the Cost Statement of the company approved bythe Board, they are not the exact replication of the statements. Theprocess of conversion of approved cost statements into XBRL instancesrequires application of judgment, including, in matters of mapping thecost statement items to the appropriate tags in the costing taxonomy

For every fact, where some detailed information or bifurcation needs to begiven; a footnote can be attached to it. Every footnote element must belinked to at least one fact [to insert footnote, please right click at desiredcell]

As per the business rules, all mandatory items shall have values [to knowwhether the given element is mandatory or not, please right click at desiredcell]

Preamble

4

Creation of the Cost Audit Report in XBRL format, as approved by the Boardand certified by the Cost Auditor, is the responsibility of the company.However, filing the Cost Audit Report in XBRL format with the CentralGovernment is the responsibility of the Cost Auditor, who has to ensure thecorrectness of data and other information contained in the XBRL InstanceDocument

For the current year, the MCA-21 system would allow re-filing of the revisedCost Audit Report/ Compliance Report of the company only in case of anerror in the original fillings

Hindi Taxonomy is also available on right click in element properties

- Source : Exposure Draft - XBRL-Training – Guidance Manual by ICAI

Preamble

5

The attached Excel file is a code file containing macros. Hence, your MS Excelshould be macro enabled

In case of data of company and cost auditor(s), MCA is going to validate fromits own database. Hence, name and address of the company shall be as perMCA database and name and address shall be as per ICAI database

It is recommended that copy, at any given cell, should not be made byinserting links from another file. Since the excel file is coded file and isportable, while opening again link may not activate the data as source mighthave changed.

The First Step : Enable Macros in EXCEL file

6

Steps :How to Enable Macro in Office 2007

7

Do the following Steps to Enable Macro

Press Office Button

Press Excel Option


8

Enable : Developer Tab


9

Press DeveloperPress Macro

Security


10

Enable all Macros then press OK

The First Step : Enable Macros in EXCEL file

11


12

Press “Trust Center”

Press “Trust Center Settings”


13

Press Macro Security

Enable all macros and also put TICK mark on Trust

access to the VBA project object model

Press Ok to complete the procedure. Now Save the file and reopen

General Guidelines

14

General Guidelines

15

User shall create a new file by using “SAVE AS” and keep the original fileintact for future use

To know business Rule, use right click at the desired cell

CIN No. must be 21 Digits only

Pre fill button is provided for adding correct name and address of thecompany with help of online database of MCA

PAN No. must be 10 Digits only

Reporting Currency of entity is fixed as ‘INR’

Footnote can be added at any filled in cell where data exist by right clickand entering data into Insert Comment Box

Copy and paste will paste ‘Values’ only

General Guidelines

16

Para 4 to 6 are hidden, it will generate only after filling up data in Para 3

Para 4 to 6 will be generated for each product group which is added atPara 3

Wherever “Text Block” is available simply click on button “Text Block” toadd details by copy and paste or add text

At Para – 5 value of product will automatically derived after filling up ofQty and Rate. User can remove the same and put value as per theirrequirement

At Para – 6 Operating Ratios will automatically derived from Para – 5; Usercan remove the same and put % as per their requirement

Copy and Pate from Word and Excel files is available for Text Block

Important Tips

17

To copy and paste from another file(s), use Paste Special Value function –Alt - E + S + V (from excel Files) or Alt – E + S + Text (from Doc. Files)

While moving from one file to another file, if Alt + Tab is not working thentry Ctrl + Tab

To handle many sheets and move around , it recommended to use Homebutton or Ctrl +H at any sheet to go to home screen. A window lists allvisible sheets in the file. By clicking on desired sheet name user can reachto the said sheet.

Basic Information : Use of Buttons

18

Use of Buttons

19

To go to home screen, Press ‘Home Screen’ Button or PressCTRL+H

By using this button user can validate sheet; user will get redcolored cell(s) where data is missing or improper

By using this button user can add numbers of product/activitygroup at Quantitative Information

User can remove Product/activity Group one by one by usingthis button at Quantitative Information

By using this button user can add information or dataincluding Table

By using this button user can get the Name and Address ofthe company from MCA website (keep internet on)


20

This button is at PARA – 4, 5 & 6. It will take user back toPARA 3

By using this button user can add numbers of Auditors

By using this button user can add number of lines at Profitreconciliation for Income/Expenses not considered in costAccounts

By using this button user can delete number of lines at Profitreconciliation for Income/Expenses not considered in costAccounts

By using this button user can add related party transaction

By using this button user can delete related party transaction


21

This button is at PARA – 4, 5 & 6. It will unlock allthe freeze formulae

This button is at PARA – 4, 5 & 6. It will lock all thecell where formulae available

This button is at Home Screen, it generates reportand user will see it in Internet Browser. It isrecommended to use ‘Google Chrome’ browser as itprovided PDF conversion facility also.

This button is at Home Screen. It validates all sheets.It is recommended that this process be carried outprior to Generating XBRL Instance document

This button is at Home Screen, it will Generate XBRLInstance file in xml

Home Page

22

To Reach to Home Screen, Press ‘Home’ Button or CTR + H at any place in the workbook.

Twelve Sheets to Complete XBRL

23

i. General Information Statementii. Form of Cost Audit Reportiii. Cost Accounting Policyiv. Product Group Detailsv. Quantitative Informationvi. Abridge Cost Sheet

i. Material Costsii. Utilities Costsiii. Industry Specific Cost Elements

vii. Operating Ratiosviii. Profit Reconciliationix. Value Addition x. Financial Position of Companyxi. Related Party Transactionxii. Form of Compliance Report

General Information

24

General Information

25

By using ‘Prefill’ Button, User will get Name and Registeredoffice Address automatically from internet

General Information

26

Fill the date in “DD-MM-YYYY” format only If there is no details of previous year then do not fill the data in First

previous financial year. When user have data of P.Y.; then after filling up date as required

above, then when user validate sheet it will showing error; but whenuser fill the product group at PARA 3 with selecting “Yes” at previousyear figures has reported; then revalidate this sheet it will not showingerror afterwards.

Hint is available wherever date is required

General Information

27

Select level of rounding in (E)(i) by using drill down arrow Actual Thousand Lakhs Millions Crores Billions

Reporting Currency of Entity is fixed as ‘INR’

General Information

28

If Option sleeted as “Yes” at qualification or anyreservation or adverse remarks; Tex Block is mandatory forthe Comment s

Text Block for Consolidated observations and suggestionsare mandatory

User have to select “Yes” or “No” whether company hasRelated Party Transactions or not. If user select no it willnot allow to fill data at PARA – 10 Related PartyTransactions

Form of Cost Audit Report

29

Details of Cost Auditor

30

This is new concept. Numbers of Auditor can be added Where there is only one Cost Auditor no need to click on button ‘Add Cost

Auditor’ Options for ‘’Whether cost auditor is Lead Auditor are ‘Yes’ or ‘No’ Options for ‘Category of Cost account’ are ‘Firm’ or ‘Sole Proprietor’

Details of Cost Auditor

31

User can add only certain number of auditors which already mentionedat “General Information E(iii).

By using button “Add or Delete Cost Auditor” user can Add or deleteauditor(s)

Lead auditor for the company is only one. Only single auditor can beselected as Lead Auditor.

PARA – 3 : Product Group Details

32


33

By using “ADD or DELETE PRODUCT / ACTIVITY GROUP” a product/ activitygroup can be added

Insert item code at Product/ Activity group column as above selected asred round circle.

Name of Product or Activity group and CETA will appear automatically. Press F2 at CETA and modify codes as required.


34

When at the column “whether product or activity group covered undercost audit (Yes/No)” is select as “YES” then only it will generate sheets withsuffix 1,2,3…n with PARA – 4 to 6 for the said product group

When at the column “whether previous year figures reported (Yes/No)” isselected as “No” then data cells for previous year will get locked at sheetsfor PARA – 4 to 6 for the said product / activity group and Text Block willbe mandatory for details for P.Y.

Last 3 columns which links takes you to the desired PARA 4 to 6. Whereproduct / Activity does not fall under Cost Audit at said row this link willnot work.


35

If user wants to change from “Yes” to “No” at “Whether product or activitygroup covered under cost audit (Yes/No)”, then the corresponding sheets forPara – 4 to 6 will also get deleted

If user wants to delete desired product group, user can put cell on saidproduct group and by selecting “delete product group” delete it. However, if“Yes” was chosen at “whether product/activity group covered under costaudit”, then the corresponding sheets for Para – 4 to 6 will also get deleted.

Para – 4 : Quantitative Information

36

PARA – 4 : Quantitative Information

37

Name and Code of Product groups will automatically bederived from PARA – 3

Simply fill other details in relevant cells

Para – 5 : Abridge Cost Statement

38

PARA – 5 : Abridge Cost Statement

39

This portion will appear automatically as per the data of PARA – 4Quantitative Information


40

Formulae for Cost per unit data is already provided. No need to enter data.However user may remove formula and add his/her own value by usingbutton Unlock formulae.

To add Materials, Utilities and Industry Specific Operations Expenses, click onrelevant links.

It will take user to another sheet where in data for maximum of ten line itemsis made available as per taxonomy. Totals at main sheet will appearautomatically.

For other cost elements, simply fill data

Para – 5 : Abridge Cost Statement : Materials

41

Name and Code of Product groups will automatically derived from PARA – 3 User will allowed to fill up to maximum ten numbers of material Options for Nature of Material Consumed are:

Indigenous Imported Self Manufactured Material

Line wise Text Block are also available for any clarifications

Para – 5 : Abridge Cost Statement : Utilities

42

User will allowed to fill up to maximum ten numbers of Utilities Details are required to submit for two years Line wise Text Block are also available for any clarifications Link as “Back to Abridge Cost Statement” will take back to Para - 5

Para – 5 : Abridge Cost Statement : Industry Specific Cost Element

43

User will allowed to fill up to maximum ten numbers of Utilities Details are required to submit for two years Line wise Text Block are also available for any clarifications Link as “Back to Abridge Cost Statement” will take back to Para - 5


44

Cost per Unit of Increase/Decrease in FG and Self or Captive Consumption arenot available in taxonomy, so it will freeze and indicated as yellow cell

Cost per Unit of Other adjustment will derived from Cost of Production orOperation of Goods or services sold less Total cost of production andpurchases

User can remove formulae by using button on top of the sheet as “unlockformulae” and put their own value

PARA – 6 : Operating Ratios

45

PARA – 6 : Operating Ratios

46

Name and Code of Product groups will automatically derived from PARA – 3 % will automatically derived from PARA – 5

PARA – 6 : Operating Ratios : Mapping

47

Mapping of elements of Abridge cost statement and Operating ratios is asabove

To unlock Formulae press “Unlock Formulae” button. It is advisable to relockformulae after changes

Once formula is changed, it can not be undone.

Elements of Abridge Cost Sheet Elements of Operating Ratios (%)Cost of materials consumed Ratio of materials including process materials cost (%)

Cost of process materials or chemicals consumed Ratio of materials including process materials cost (%)Cost of utilities consumed Ratio of utilities cost (%)

Cost of direct employees Ratio of direct employees cost (%)Cost of direct expenses Ratio of direct expenses (%)

Cost of stores and spares consumed Ratio of stores and spares consumed (%)Cost of repairs and maintenance Ratio of repairs and maintenance cost (%)

Cost of quality control Ratio of production overheads (%)Cost of research and development Ratio of production overheads (%)

Cost of technical knowhow fee or royalty Ratio of production overheads (%)Cost of depreciation or amortization Ratio of depreciation and amortization cost (%)Cost of other production overheads Ratio of production overheads (%)

Cost of industry specific operating expenses Ratio of industry specific operating cost (%)Cost of increase/decrease in work-in-progress Ratio of stock adjustments (%)

Credits for recoveries Ratio of production overheads (%)Cost of primary packing Ratio of Packing cost (%)

Cost of finished goods purchased Ratio of finished goods purchased (%)Cost of increase/decrease in finished goods Ratio of stock adjustments (%)

Cost of self or captive consumption Ratio of other expenses (%)Cost of other adjustments Ratio of other expenses (%)

Cost of administrative overheads Ratio of administrative overheads (%)Cost of secondary packing Ratio of Packing cost (%)

Cost of selling and distribution overheads Ratio of selling and distribution overheads (%)Cost of interest and financing charges Ratio of Interest and financing charges (%)

PARA – 7 : Profit Reconciliation

48

Para – 7 Profit Reconciliation

49

Use Buttons to ADD or DELETE the number of items atIncomes and/or Expenses not considered in cost accounts

PARA – 8 : Value Added

50

Para – 8 Value Addition

51

Add or Remove buttons are not available at this sheet,simply fill the data as required in relevant cells

Para – 9 : Financial Ratios

52

Para – 9 : Financial Ratios

53

Add or Remove buttons are not available at this sheet,simply fill the data as required in relevant cells

Para – 10 : Related Party Transaction

54

Para – 10 : Related Party Transactions

55

Related party data is divide in two parts viz. data about the relatedparty and transaction data.

Insert CIN will automatically fill Name of the Company. Hence, do fillCIN first wherever applicable.

Drill down button is available for selecting country. By pressing Add Related Party, user is asked whether user want to add

transaction with the said party. If yes then related party data will getcopied automatically.

Para – 10 : Related Party Transactions

56

New element called ‘Product or activity eight digit code’ is required . Itis a mandatory field.

Please refer :ITC HS Code: (for products)http://www.mca.gov.in/XBRL/pdf/ITC_HS_codes.pdf

NPSC Code : (for Services) http://www.mca.gov.in/XBRL/pdf/NPCS_codes.pdf

Para – 11 : Reconciliation of Indirect Taxes

57

Para – 11 Reconciliation of Indirect Taxes

58

Simply fill the data as required in relevant cells

Generation of Report & XBRL Instance

59

Generation of Report

60

Press Button Generate Report a window will open


61

Save HTML file at desire folder


62

View of HTML Report – Preferable BrowserGoogle Chrome – Printer Friendly Version

Generation of XBRL Instance

63

Press Button Generate XBRL Instance File; a window will open

Generation of XBRL Instance

64

Save XML file at desire folder

Validation of Instance Document with MCA Tool

65

Validation of Instance Document

66

Home Screen of MCA validation tool


67

Taxonomy> Select Taxonomy> Cost Audit Report 2012


68

This message will appear when taxonomy loaded.


69

This message will appear when taxonomy loaded.


70

Now open xml file which generated from Excel base XBRLsoftware . File > Open>


71

Now Select XML from document


72

Message will appear when xml loaded


73

Select element it will show details below which filled byuser in XBRL software


74

User can validate sheet by : File > Validate


75

Final Validation Message


76

User can also get PDF from MCA Tool also by: File> Export to PFD

77

We are very close to you

Toll Free #1800 233 0445

[email protected]

xbrl manual-for-cost-audit-final

Economy & Finance