MIS Financials Format

Download as xls, pdf, or txt
Download as xls, pdf, or txt
You are on page 1of 23

Logo here

Company Name

MIS-REPORT [JUNE-2008]
1] Profit & Loss A/c 2] Contribution Statement 3] Reason for Variance 4] Cash Flow Statement 5] Fund Flow Statement 6] Balance Sheet 7] Debtors Flow Statement 8] Finished Goods Flow 9] Debtors Aging report 10] Creditors Aging report 11] B R S - Statement

MIS-1
Particulars Sales : Finished Goods - CST Sales

Page 2 of 23
Actual May'08 Budget June'08 Actual June'08

May 2008

Profit & Loss a/c for the month of May'2008


0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

F G - CST Sales (From godown 12 to Parties)

Finished Goods - TNGST Sales Job Work- CST Job Work- TNGST IST Sales(and Export thro Ho) Job Work- Mending Sampling Charges & others Less : Sales Return Finished Goods - CST Sales
Finished Goods - CST Sales (at godown 12)

Finished Goods - TNGST Sales Job Work- CST Job Work- TNGST Inter Stock Transfer - FG Job Work- Mending Sampling Charges Net Sales Increase / (Decrease) in Stock Opening Stock Finished goods Semi Finished Goods Work- In - Process Hakoba factory outlet stocks Closing Stock Finished goods Semi Finished Goods Work- In - Process Hakoba factory outlet stocks Raw Material Consumption Yarn Fabric Others (incl. Trading of Goods) Job Work & Proc. Charges Exps Gross Profit Less: Manufacturing Expenses Labour Charges On Rolls Welfare Expenses ESI & P.F Provision for Bonus etc. Shearing Charges Mending Charges Cutting & Packing charges Cutting Charges Packing Charges

Company Name

MIS-1
Particulars Power & Fuel Stores & Spares Repair & Maintenanace Machines Building Electrical Others Personnel Expenses Salaries Bonus, Gratuity etc. ESI & P.F and Dues Staff Welfare Administrative Exp. Insurance Exp. Travelling & Conveyance Exp. Boarding & Lodging Expenses Security Charges Legal & Professional Fees Printing & Stationary Communication Exp. Financial Charges Rent,Rates & Taxes Rent to Employees

Page 3 of 23
Actual May'08 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Budget June'08 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Actual June'08

May 2008

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Internal Audit Fees / (Provision reversed)

Festival Exps/ Puja


General Exp - ( including other Admn Exp)

Vehical Running Exp.


Provision written back

Interest SIDBI Selling Expenses Freight & Cartage Packing Material Repair & Maintenance , Fuel -Tempo Turnover Discounts & Commission Advertisement Expenses/knit Show Allocated Expenses-HO Profit / (Loss) before Interest & Dep. Interest on fixed assets & W.C. (HO)
Profit/ (Loss)After Interest but before Depreciation

Depreciation

Net Profit / (Loss)

Company Name

MIS-1

Page 4 of 23
Actual Up to June'08 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

May 2008

oss a/c for the month of May'2008

Company Name

MIS-1

Page 5 of 23
Actual Up to June'08 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

May 2008

Company Name

MIS-2

Page 6 of 23

May 2008

Contribution Statement
No. of shifts Particulars CONTRIBUTION 1-JUNE-2008 to 31-JUNE-2008 0 0 Actual for P.Month Budgeted for Month Total Per shift Total Per shift 0 0 #DIV/0! #DIV/0! 0 0 #DIV/0! 0 0 0 0 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 0 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 0 0 0 0 #DIV/0! 0 0 0 0 0 #DIV/0! 0 0 0 0 0 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 0 0 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 0 0 0 #DIV/0! 0 0 0 0 Actual for Month Total Per shift 0 #DIV/0! 0 0 #DIV/0! 0 0 0 0 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 0 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 0 0 0 #DIV/0! 0 0 0 0 Actual upto Month Total Per shift 0 #DIV/0! 0 0 #DIV/0! 0 0 0 0 0 0 #DIV/0! 0 #DIV/0! 0 0 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 0 0 0 #DIV/0! 0 0 0

Manufacturing Charges Direct Welfare Bonus etc. to Direct Labour Incentive to Labour

Labour Charges

Shearing Charges Mending Charges


Cutting Charges Packing Charges

Cutting & Packing Charges

Power & Fuel Stores & Spares


Machines Building Electrical / Others

Repair & Maintainance

Salaries Bonus, Gratuity etc. Staff Welfare

Personnel Expenses

Company Name

MIS-2

Page 7 of 23

May 2008

B Other Administration Charges

Insurance Expenses Travelling,Conveyance & Boarding & Lod Security Charges General Exp.(other admin exp) Printing & Stationery Communication Expenses Financial Charges Rent, Rates & Taxes Legal and Professional Charges Rent to Employees Internal Audit Fees Festival Exps Repair & Maintanence Exp. (Others) Vehicle Running Expenses Sundry Dr/Cr writeoff/writeback A/c Interest SIDBI

0 #DIV/0! 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! 0 0 0 0 0 0 #DIV/0!

0 #DIV/0! 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! 0 0 0 0 0 0 #DIV/0!

0 #DIV/0! 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! 0 0 0 0 0 0 #DIV/0!

0 #DIV/0! 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! 0 0 0 0 0 0 #DIV/0!

C Selling Expenses

Freight & Cartage Packing Material Repair & Maintenance Vehicle Turnover Discount & Commission Advertisement Expenses/knit Show

D Allocated Expenses
Manufacturing Exps before Interest & Depreceiation

0 #DIV/0! 0 #DIV/0! 0 #DIV/0!

0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0!

0 #DIV/0! 0 #DIV/0! 0 #DIV/0!

0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0!

E Interest (On Fixed Assets & W.C.)


Manufacturing Exps before Dep.

F Depreciation
Total Manufacturing Expenses Profit/(Loss) after all expenses

0 #DIV/0! 0 #DIV/0! 0 #DIV/0!

0 #DIV/0! 0 #DIV/0! 0 #DIV/0!

Company Name

MIS-3
Reason for variances 1. Contribution:B 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 37 38 Electrical & Mechanical Break down No operator Program change Others Total Total loss due to other Factor Net Loss due to Rate Diff Rs Rs Rs Rs Rs Rs Rs 509936 102914 229335 2827120 3,669,306 8,720,501 =D27+D35 Breakup of Loss due to Lower Efficiency Budgeted Stiches Actual Stiches Difference Loss due to lower efficiency Nos Nos Nos Rs 61,325,720 27,438,730 33,886,990 =D24-D25 Gain / (Loss) in Contribution due to Rate:Budgeted Rate Actual Rate Difference Loss Gross Loss due to Rate Diff Rs Rs Rs Rs 10.28 =D14 6.49 =D15 (3.79) =D20-D19 Target Stiches Budgeted Stiches Actual Stiches Budgeted Efficiency Actual Efficiency Budgeted Contribution Actual Contribution Budgeted Rate / 1000 stitches Rate per 1000 Stiches C Nos Nos Nos % % Rs Rs Rs Rs D Total 52,068,076 61,325,720 27,438,730 117.78 =D8/D7*100 52.70 =D9/D7*100 8,892,000 2,581,336 10.28 6.49 E MAY '08

May 2008

6,310,664 =D12-D13 4,090,017.09 =D9*14.5/1000*D14 1,508,681.09 =E14-D13

(1,508,681) =D9*14.5/1000*D21

5,051,195 =(D26 x 14.5 / 1000) x 10.28

(10,229,182) =D22-D37

* Saleable mtrs = 14.5 Mtrs. (Average of 16 machines @ 14mtrs, 2machines @ 19mtrs)

Company Name

MIS-4

May 2008

Cash Flow Statement for the month of June-2008 Particulars


CASH INFLOWS Opening Balance Collection from Parties Collection From Branch Branc A Branc B Branc C Branc D Received from HO Other Recovery \ Adjustment Total CASH OUTFLOWS Salary, Wages and other Allowances Electricity Chgs Communication Exp Statutory Liabilities Sundry Creditors Sundry Debtors Expenses Advance Advances agst Salary \ Wages Loan to workers \ Staff Secured Loans Head Office Branch \ Division Financial Charges SIDBI Payments Cash Expenses ( Routine) Closing Balance Total Amount (Rs)

Breakup for Closing Balance Cash in hand Cash at Bank (BRS enclosed) Total Company Name -

MIS-5
Funds Flow Statement for the month of May'08 Amount (Rs) -

May 2008

Sources of Funds Net Profit as per Profit & Loss Account decrease in Working Capital

Application of Funds Vehicle Loan 6 Fixed Assets Ho allocation expenses Allocated Interest Allocated Depreciation Branch and Division

Amount (Rs) 1 1 1 1 1 1

Total

Total

Company Name here

MIS-6

May 2008

Company Name Balance Sheet as on 31.5.2008


Figures in Rupees ASSETS LIABILITIES

Current Assets
Cash in hand Bank Accounts Accounts receivable Advance Paid to creditors Inventory Loans, Advance & Deposists Cheque in transit Total Current Assets #REF! 0 0 0 #REF! 0 0 0

Current Liabilities
Payment Due to Employees Provisions & Payables Statutory Liabilities Duties & Taxes Payable Accounts Payable Advance received from debtors SIDBI Direct Payment A/c Total Current Liabilities 0 0 0 0 0 0 0 0

Fixed Assets
Land & Development Online UPS Buildings (less accumulated depreciation) Plant and Machinery (less accumulated depreciation) Furniture and fixtures (less accumulated depreciation) Motor Car (less accumulated depreciation) Computer (less accumulated depreciation) Office Equipments (less depreciation reserve) Total Net Fixed Assets 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Loan Liability
Secured Loans 0

Branch / Divisions
Head Office accounts Chennai sales Office Bobbin Lace Expansion Unit Other Branch / Divisions Total Branch / Divisions 0 0 0 0

Profit/(Loss) Opening Balance Current Period-Loss . 0 0 0

TOTAL ASSETS

#REF!

TOTAL LIABILITIES

Company Name

MIS-6

May 2008

Company Name

MIS-6

May 2008

Company Name

MIS-6

May 2008

Company Name

MIS-6

May 2008

Company Name

MIS-6

May 2008

Company Name

MIS-6

May 2008

Company Name

MIS-7

May 2008

Summarised Details Of Sales and Collection for the month of June'08 Opening Balance of Debtors Less:Particulars Amount Rs. Amount Rs. -

Credit balance adjusting with debtors

Net opening balance of debtors Add:Bills Raised during the month


By PEL-Coimbatore (Excluding IST sales)
Sales -TNGST Sales -CST Sales - TNGST -JW Sales -CST-JW Sales -Sampling Charges -

Adjustment on Sales
Rate Diff /reco/other adj Carriage outward sales /Inwards debited Cheque payment returned CST 4%

Less:-

Collection during the month


Cheques received PEL-Export Collected by Head office

Adjustments on Collection
Goods returns and all Expenses Debited reversed/Rate Diff Sampling Charges reversed/refunded TDS Certificates received Closing Balance of Debtors AS PER TALLY ACCOUNTS DIFF-(Credit balance adjusting with debtors) AS PER DEBTORS AGING SCHEDULE DIFF-(Credit balance adjusting with debtors-M/s If any customer having)

Company Name

MIS-8

May 2008

Finished Goods Flow for the month of June'2008 Particulars Opening Balance of FG (as on 1.6.2008) Add:- Inwards From SF Inventory
Description Uom Embroideries Fabric in Laces Patties PV Embroderies Mtrs Cotton Embroideries Mtrs Qty @ 7729.000 48.58 2225.900 82.00 3623.000 241.41 Total Qty 133.100 Total @ 82.00 Rs. 375,483 182,524 874,628 1,432,635 Rs. 10,914 10,914

Amount Rs.
12,956,266 1,443,549

1,432,635

From Sales Return


Description PV Embroderies Uom Mtrs

10,914

Less:-

Outward Dispatched to customer (Stock Value)


Description 4492 4611 R-5854 Pelc-1740-4 Uom Patties Patties Patties Mtrs Qty @ Rs. 65,700 196,290 1,188 532 263,710 @ 45.00 90.00 90.00 Rs. 450 720 180 1,350 2190.000 30.000 4362.000 45.000 36.000 33.000 14.000 38.000 Total

265,060

263,710

Used for Sample (Stock Value)


Description Uom 4611 Patties C-701 Skin Patties C-1568 Skin Patties Qty 10.000 8.000 2.000 Total

1,350

Closing Balance of FG Inventory as on 31.05.2008


Note :1] Sales return from Saranya Garments 2] Sales Value of Finished goods sold Rs.286892/Description Uom Qty @ 4492.000 Patties 2190.000 30.000 4611.000 Patties 4362.000 50.000 R-5854 Pelc-1740-4 Patties Mtrs 36.000 54.000 14.000 82.000 Total

14,134,755

Rs. 65,700 218,100 1,944 1,148 286,892

Company Name

MIS-9
Company Name here Debtors Aging as on 31-05-2008 Pending Amount Up to 30 31 to 60 Days 52,409 5,327 440 75,460 281,628 322 66,226 481,812 Debtors-Region B 1,688 4,270 1,876 12,936 3,451 75,460 64,766

May 2008

S.N 1 1 2 3 4 5 6 7 2 1

Particulars Debtors-Region A

Agewise Due 61 - 90 Days 91-180 Days 15,960 19,243

181-365 Days

above 1 Year

440 31,134 65,722 103,002 29,580 156,148 266 175,657 322 238 1,000

156,613

45,540

0 1,688

Company Name here

MIS-10

Page 21 of 23

May 2008

Company Name Debtors Aging as on 31-06-2008

Sr. No A 1 B 1 2 3 4 5 6

Particulars Creditors-AMC Megatech Engineers Creditors - Fuel, Stores & Consu.,

TOTAL AMOUNT 12,242 12,242 105,573 25,516 31,465 2,583 260 181,239 346,636 37,991 16,433 47,350 18,977 60,925 1,144 53,715 59,596 11,012 307,142 26,904 26,904 52,216 20,215 7,480 777,827 3,672 745 1,913

UPTO30 Days 12,242 12,242 32,884 2,613 31,465 260 67,222 37,991 16,433 47,350 18,977 60,925

31 - 60 Days

61 - 90 Days

91-180 Days 181-365 Days

above 1 Year

20,350

37,674 2,501

35,015 52 2,583

Total C 1 2 3 4 5 6 7 8 9 Total D 1 Total E 1 2 3 4 5 6 7 Creditors -Ele & Miscellaneous Creditors - legal & Listing Creditors - Job Work

25,696 46,046

40,156 80,331

115,387 150,454

2,583

1,144 53,715 59,596 11,012 192,687 13,452 13,452 52,216 343 777,827 3,672 745 1,913 53,715 6,726 6,726 59,596 6,726 6,726 1,144

10,800

9,072 7,480

Company Name Here

MIS-10

Page 22 of 23

May 2008

8 9 Total F 1 2 3 Total G 1 2 3 4 5 6 7 Total H 1 2 3 Total GTotal Creditors - Transports & Clearing Creditors - Raw Materials Creditors-Courier, Printg & Stationery

27,345 12,210 903,623 6,580 1,200 3,206 10,986 41,136 93,028 667,814 2,391,567 48,327 8,095 5,377 3,255,344 63,368 69,278 2,399 135,045 4,997,922

11,433 8,988 839,374 2,450 3,206 5,656 1,913 1,060 22,233

15,912 3,222 28,206 3,070

745

11,152

1,200 1,060 3,070 1,200 41,136 93,028 26,831 32,868

533,177 2,004,277 8,095 2,545,549 33,985 60,455 94,440 3,770,622

107,806 341,736

7,774

4,912 48,327 5,377 5,377

449,542 29,383 8,823 38,206 590,482

7,774

53,239

193,863

117,064 253,429 55,184

2,399 2,399 211,141

Company Name Here

MIS-11
Company Name here Coimbatore-19 BRS as on 30th June '2008 [Bank Name and Branch Place]
Date 4/9/2008 6/21/2008 6/25/2008 6/28/2008 6/30/2008 6/30/2008 6/30/2008 6/30/2008 6/30/2008 6/30/2008 6/30/2008 6/30/2008 6/30/2008 6/30/2008 6/30/2008 6/30/2008 6/30/2008 6/30/2008 6/30/2008 6/26/2008 6/26/2008 6/26/2008 6/28/2008 6/28/2008 6/30/2008 6/26/2008 6/30/2008 6/30/2008 6/30/2008 6/30/2008 (Reconciliation) Vch Type Bank Payment Bank Receipt-UBI Bank Payment Bank Payment Bank Payment Bank Payment Bank Payment Bank Payment Bank Payment Bank Payment Bank Payment Bank Payment Bank Payment Bank Payment Bank Payment Bank Payment Bank Payment Bank Payment Bank Payment Bank Receipt-UBI Bank Payment Bank Payment Bank Receipt-UBI Bank Receipt-UBI Bank Receipt-UBI Bank Payment Bank Receipt-UBI Bank Payment Bank Receipt-UBI Bank Receipt-UBI Balance as per Company Books : Amounts not reflected in Bank : Balance as per Bank : Particulars Bank Date Debit 31152.00

May 2008

Credit 5760.00 104708.00 6500.00 224111.00 62500.00 111002.00 62917.00 43716.00 63577.00 106219.00 95057.00 215988.00 63618.00 108060.00 152951.00 63963.00 106436.00 106518.00

7/1/2008 7/1/2008 7/1/2008 7/1/2008 7/1/2008 7/1/2008 7/2/2008 7/2/2008 7/2/2008 7/2/2008 7/2/2008

44600.00 529.00 1140.00 5832.00 9547.00 3220.00 2716.00 21210.00 2247.00 16013.00 1644.00 310512.57 133218.00 1710233.00 1887527.57

Company Name

You might also like