Trade Notice No.08/CE/SHG/2011

Dated Shillong the 6th June, 2011


            Subject: Computer Assisted Audit Programme (CAAP) – Auditing in an Electronic Environment-Regarding.

                    Attention of the members of  Trade, Industry and all concerned are drawn to the Trade Notice No.21/CE/SHG/2010 dated 26th of August, 2010 issued from C.No.IV-16/29/TN/TECH/2010/12186-260 dated 30th August, 2010 on the subject issue and are being informed that the said Trade Notice is superseded in this Trade Notice with amendment in para (vii) accordingly and read as under:-

                     Now, therefore, it is informed that Computer Assisted Audit Programme (CAAP for the sake of brevity) Centre has been set up in the Head Quarters Audit Section for the Purpose of conduct of Audit in respect of those Assessees who use a computer to record their business transactions / activities and keep such data in electronic form. The following information is provided to the Trade for creating awareness and facilitating working of CAAP: 

(i)                 The Departmental Audit under CAAP will involve examination and analysis of business (private) records that are maintained electronically. Under CAAP, all or a part of audit could be completed using electronic records. Trained in auditing of electronic records, the Central Excise Officers, who shall conduct Computer Assisted Audit, shall use commercial and custom software on secure Departmental Computers for this purpose.

(ii)               Computer Assisted Audit saves time both for the Assessee and Department as it takes much shorter time than Manual Audits as most of the records are made available to the Auditor in an electronic format which are examined using a secure Departmental Computer. It also saves paper as an electronic audit reduces the amount of paper normally needed, produced or photocopied during an Audit. The Auditors spend less time at Assessee’s premises.

(iii)             The procedure followed in the Computer Assisted Audit is that Computer Assisted Audit starts with a meeting between the CAAP Auditor and Assessee’s accounting/systems staff. During the meeting, the CAAP Auditor would request several  information to determine the feasibility of a Computer Assisted Audit. The Questions are a part of a Computer Assisted Audit feasibility Survey and include information about-

(a)    Hardware and peripherals

(b)    Operating System used by the assessee’s computer system

(c)    Accounting Software used by the assessee

(d)    Accounting Information –like chart of accounts

(e)    Details of information in the assessee’s electronic records

(f)      Back-up and Data retention methods used by assessee

(g)    Data export options supported by the assessee’s system

(h)    Conversion of the assessee’s data to a format readable by departmental computers

(iv)             The CAAP Auditor would identify specific computer files and records he/she requires for the audit and ask the assessee to provide a copy of those records on a disk or a Compact Disk (CD). He/she might also have to ask the assessee to convert the data to a format that is not proprietary and readable by departmental computers. The assessee can make a second copy of the same records provided to the CAAP Auditors.

(v)                The Auditor would next copy these records to a secure departmental Computer and analyze/verify them using a combination of commercial and custom software. The assessee’s data is not altered during the examination. Rather, the auditor reviews these, validates that all of the records are included in the data, summarizes them, and extracts a copy of the selected records of interest to a number of reports.

(vi)              The assessee’s records are handled with extreme care and are encrypted during transfer and storage. Such records obtained from the assessee are accessible to only the authorized Central Excise Officers. Upon completion of an audit or upon conclusion of any appeal or judicial review, the records provided are securely erased and CDs are destroyed. The assessee may advise the CAAP auditors in case he (the assessee) wishes to have his CD returned back. The Computer Assisted Audit in no way causes any risk to the assessee’s computer or electronic records. The CAAP auditor would only ask the assessee to make a copy of the assessee records.

(vii)   In short, Computer Assisted Audit works by analyzing a copy of assessee’s electronically stored records that are provided to the CAAP auditor on a disk or Compact Disk (CD). The original records of the assessee are not “touched” or altered in any ways. The assessee’s original records are not altered in any manner during the Computer Assisted Audit process. In fact, the commercial software used by the CAAP auditor is designed specifically to never alter any audit records. ). As informed by the vendor of the Win Idea Audit Software “HTML was not build as a Document format type. It is a language and because it is a language it is not really controlled in any way like a Format would be. Essentially what the Central Excise/Service Tax CAAP Team is receiving from their assessee are web pages and are expected to pull out the pertinent data around an ever evolving language. The CAAP Auditors may locate the data source and ask the assessee to save it in a different format out of the source database. The format could be MS-Excel, Print, Delimited, PDF, Advanced record definition editor, AS-400.dBase, Lotus, Microsoft Access, Microsoft Excel, ODBC, Print Report and Adobe PDF, SAP/AIS, Text (Delimited) and XML. If there is a web interface (Where this reporting is coming from) then there is also a data base back end which can save data in a different ways like MS-Excel, Print, Delimited, PDF, Advanced record definition editor, AS-400.dBase, Lotus, Microsoft Access, Microsoft Excel, ODBC, Print Report and Adobe PDF, SAP/AIS, Text (Delimited) and XML.  In short, as a conclusion – given the nature of HTML files as indicated above, a direct import facility into IDEA Software will not be possible in  IDEA. Workaround in terms of an IDEA Script Converter (HTML to Print Reports) could be tried but this is once again not comprehensive and fool-proof with large HTML files. The assessee are requested to provide data in MS Excel, Print, Delimited, PDF formats as available to the CAAP Auditors”.

(2) In this regard, the Trade is also advised to refer to Part-III of Chapter-VI of Central Board of Excise & Customs (CBEC’s) Central Excise Manual detailing Supplementary Instructions on Computer Assisted Audit Programme. 

(3) For any further details/information on Computer Assisted Audit Programme, inquiries can be made at the below given address where CAAP Laboratory of your jurisdictional Central Excise Commissionerate is stationed.  

Office of the Deputy Commissioner of Central Excise,(Audit)

Morellow Compound,

 M.G. Road, Shillong-793001,

(Phone No.2503161)


        2.          Hindi version will follow.

(Anil Kumar Gupta)