List of Documents to be obtained

Section IV Management Information System (MIS) Excise Audit Formats Compiled by: Spandane Compiled by Spandane Management Information System Nam...
Author: Darrell Mathews
29 downloads 0 Views 2MB Size
Section IV

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

9 10 11 12 13 14 B 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16

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.

Name, Address & Telephone

1

2

3

4

5

6

www.spandane.com

Item

Supply contract

Compiled by Spandane

5

Management Information System

Name of the Company

Inspection Period

05-Price list of Finished Goods Sr. No.

Item

Unit

Rate

1 2 3 4 5 6 7 8 9 10

www.spandane.com

Terms (Advance, Delivery period, taxes, forwarding etc.)

Compiled by Spandane

6

Management Information System

Name of the Company

Inspection Period

06-Prices of RM over last 12 / 24 / Sr. No.

Raw Material

months

Unit

Dates Rs.

Rs.

1 2 3 4 5 6 7 8 9 10

www.spandane.com

Rs.

Rs.

Rs.

Rs.

Compiled by Spandane

7

Management Information System

Name of the Company Inspection Period 07-Prices of FG over last 12 / 24 / Sr. No.

Finished Goods

months

Unit

Dates Rs.

Rs.

1 2 3 4 5 6 7 8 9 10

www.spandane.com

Rs.

Rs.

Rs.

Rs.

Compiled by Spandane

8

Management Information System

Name of the Company

Inspection Period

08-Stock as per books & as submitted to Bank (Rs / Rs’000)

Month

Stock As per Books RM

WIP

FG

Stock as per Stock Statement given to bank. Total

www.spandane.com

RM

WIP

FG

Total

Compiled by Spandane

9

Management Information System

Name of the Company

Inspection Period

09-List of Bank Accounts & Limits enjoyed.

Sr. No. 1

A/C No.

Name, Address, Tel, BM

2

3

4

5

6

www.spandane.com

Limits enjoyed

Compiled by Spandane

Management Information System

Compiled by Spandane

10

Management Information System

Name of the Company

Inspection Period

10-Sales (Excl. Excise, Sales Tax) & UPR

Year / Period Sr. No.

Product Qty

UPR

Rs’000

Qty

1 2 3 4 5 6 7 8 9

www.spandane.com

UPR

Rs’000

Qty

UPR

Rs’000

Compiled by Spandane

Management Information System

11

Name of the Company

Inspection Period

11-Finished Goods Qty. Reconciliation.

Period Sr. No. 1 Unit

Product

Total

Opening Stock Add; Production Add: Returns Less: Sales Closing Stock

Sr. No. 2

Unit

Product

Total

Opening Stock Add; Production Add: Returns Less: Sales Closing Stock

www.spandane.com

Compiled by Spandane

Sr. No. 3 Unit

12

Product

Management Information System

Total

Opening Stock Add; Production Add: Returns Less: Sales Closing Stock

Sr. No. 4 Unit

Product

Total

Opening Stock Add; Production Add: Returns Less: Sales Closing Stock

Sr. No. 5 Unit

Product

Total

Opening Stock Add; Production Add: Returns Less: Sales Closing Stock

www.spandane.com

Compiled by Spandane

Management Information System

13

Name of the Company

Inspection Period

12-Raw Material Qty. Reconciliation.

Period Sr. No. 1 Unit

Raw Material

Total

Opening Stock Add: Purchases Less: Returns Less: Consumption Closing Stock

Sr. No. 2 Unit

Raw Material

Total

Opening Stock Add: Purchases Less: Returns Less: Consumption Closing Stock

www.spandane.com

Compiled by Spandane

Sr. No. 3 Unit

14

Raw Material

Management Information System

Total

Opening Stock Add: Purchases Less: Returns Less: Consumption Closing Stock

Sr. No. 4 Unit

Raw Material

Total

Opening Stock Add: Purchases Less: Returns Less: Consumption Closing Stock

Sr. No. 5 Unit

Raw Material

Total

Opening Stock Add: Purchases Less: Returns Less: Consumption Closing Stock www.spandane.com

Compiled by Spandane

15

Management Information System

Name of the Company

Inspection Period

13-RM Consumption in Qty.—Standard & Actual variation

Product Æ Production Æ Raw Material

Product Æ Production Æ Raw Material

Product Æ Production Æ Raw Material

Standard (Bill of material) Per unit Total

Actual (St.12)

Variation

Standard (Bill of material) Per unit Total

Actual (St.12)

Variation

Standard (Bill of material) Per unit Total

Actual (St.12)

Variation

www.spandane.com

16

Compiled by Spandane

Management Information System

14-Profit & Loss A/C Sr. No. 1.1 1.2 1.3 1.4 1.5

% Sales

1.6 1.0

Sub-total (1.1 to 1.3) Increase (decrease) in stock Other income Total

2.1 2.2 2.3 2.4 2.5 2.6

Material Power & Fuel Personnel cost. Admn, Marketing cost Interest Depreciation

2.0 3.0

%

Total Loss (1-2) Gross Profit PBIT PBITD Internal Generation Fixed Expenses Variable Expenses

www.spandane.com

Rs’000 %

%

%

Compiled by Spandane

17

Management Information System 15-Balance Sheet

Sr. No. 1.1 1.2 1.3 1.0 2.0 2.1 2.2 2.3 2.0 3.0 3.1 3.2 3.0 4.1 4.2 4.0 5.0

Liabilities

31-03-200

Share Capital Share application money Reserves & Surplus Net Worth Secured Loans: Term Loan Cash Credit Sub-Total Unsecured Loans: Directors loans Others Sub-Total Current Liabilities: Current Liabilities Others Sub-Total

6.0 6.1 6.2 6.0

TOTAL (1to4) Assets Fixed Assets: Gross Block Less: Cum. Depreciation Fixed Assets-WDV

7.0 8.0 8.1 8.2 8.3 8.4 8.0 9.0

Investment Current Assets: Stock Debtors Cash & Bank balances Loans & Advances Sub-Total Deferred Tax Assets

10.1 10.2 10.3 10.0

Preliminary expenses Debit bal. Of Profit & Loss a/c Deferred Revenue Expenditure Sub-Total

11.0

31-03-200

TOTAL (6to10) Capital Employed (11-4) Current Liabs. Incl. CC Net Worth less Loss www.spandane.com

Rs’000

31-03-200

Compiled by Spandane

18

Management Information System

Name of the Company

Inspection Period

16- Manufacturing Process Chart

Product:

Sr. No.

Process

Raw Material / Input from Process-

Output

Process

Raw Material / Input from Process-

Output

Process

Raw Material / Input from Process-

Output

Process

Raw Material / Input from Process-

Output

1

Sr. No. 2

Sr. No. 3

Sr. No. 4

www.spandane.com

Compiled by Spandane

Sr. No.

19

Management Information System

Process

Raw Material / Input from Process-

Output

Process

Raw Material / Input from Process-

Output

Process

Raw Material / Input from Process-

Output

Process

Raw Material / Input from Process-

Output

5

Sr. No. 6

Sr. No. 7

Sr. No. 8

www.spandane.com

Suggest Documents