Management Information System (MIS) Excise Audit Formats
Compiled by: Spandane
Compiled by Spandane
Management Information System
Name of the Company Inspection Period List of Documents to be obtained Sr. No. A 1 2 3 4 5 6 7 8
Year / Period Audited Accounts Audit Report Tax Audit Report Directors Report Cost Audit Report IT Return Service Tax return Stock Statement given to bank as on
Statements to be obtained: Production & Capacity Utilization (%) Bill of Material List of main suppliers & their addresses, terms etc. List of main customers & their addresses, terms etc. Price list of FG Prices of RM over last 12 / 24 / months Prices of FG over last 12 / 24 / months Stock as per books & as submitted to Bank List of Bank Accounts & Limits enjoyed. Sales & UPR FG Qty. Reconciliation. RM Qty. Reconciliation. RM Consumption—standard & actual variation Comparative Profit & Loss A/C Comparative Balance sheet Manufacturing Process Chart
www.spandane.com
Compiled by Spandane
1
Management Information System
Name of the Company
Inspection Period
01-Capacity, Production & Capacity Utilization (%)
Sr. No.
Product
Licensed
Year Installed Production Per shift/ Total
1 2 3 4 5 6 7 8 9 10
Capacity Utilization: Production divided by Installed Capacity x 100
www.spandane.com
%
Licensed
Year Installed Production
%
Compiled by Spandane
2
Management Information System
Name of the Company
Inspection Period
02-Bill of Material Products Sold Product: RM
Product: Unit
Cost Rs.
RM
Product: Unit
Cost Rs.
www.spandane.com
RM
Unit
Cost Rs.
Compiled by Spandane
3
Management Information System
Name of the Company
Inspection Period
03-List of main suppliers & their addresses, terms etc. Sr. No.
Name, Address & Telephone
1
2
3
4
5
6
www.spandane.com
Item
Supply contract
Compiled by Spandane
4
Management Information System
Name of the Company
Inspection Period
04-List of main customers & their addresses, terms etc. Sr. No.