Name of Company
Division:
Month:
Statement of Financial Position
Equity & Liabilities Sch Amount (NPR) Assets
Current Month Previous Month
Share Capital Fixed Assets
Gross Block
Less : Depreciation
Investments
Other Non Current Assets
Group Companies Group Companies
Sundry Creditors: Sundry Debtors
More than 6 months More than 6 months
Others Others
Loans Loan & advances
More than 6 months
Others
Other Payables Cash & Bank Balances
Cash
Bank
Other Current Assets
Profit & Loss Stocks
Misc. Expenditure
Total - - Total
Sch Amount (NPR)
Current Month Previous Month
- -
Name of Com
Division:
Month:
Monthly Satement of P
Previous Month
Previous Month
Particular
Sch Amount In %
Sales : - #DIV/0!
Sand - #DIV/0!
Roda - #DIV/0!
Chips - #DIV/0!
Others, If any - #DIV/0!
Other Income - #DIV/0!
Less : Stores & Spares Consumption - #DIV/0!
Opening Stock - #DIV/0!
Add: Purchases - #DIV/0!
Less: Closing Stock - #DIV/0!
Less: Manufacturing Expenses -
Wages : - #DIV/0!
On Rolls - #DIV/0!
Contractors - #DIV/0!
Others - #DIV/0!
Salaries of Technicals & Others -
Staff Welfare -
Cutting & Packing charges (incl. IST) - #DIV/0!
Provision for Gratuity, Bonus etc. - #DIV/0!
Other staff related direct expenses - #DIV/0!
Power & Fuel - #DIV/0!
Electricity #DIV/0!
Other Fule #DIV/0!
Repair & Maintenanace - #DIV/0!
Machines #DIV/0!
Building #DIV/0!
Others #DIV/0!
Gross Profit -
Less: Administrative Exp. - #DIV/0!
Salaries - #DIV/0!
Staff Wealfare - #DIV/0!
Communication Exp. - #DIV/0!
Rent,Rates & Taxes - #DIV/0!
Legal & Professional Charges - #DIV/0!
General Expenses - #DIV/0!
Printing & Stationary - #DIV/0!
Vehical Running Exp. - #DIV/0!
Insurance Exp. - #DIV/0!
Travelling & Conveyance Exp. - #DIV/0!
Security Charges - #DIV/0!
Others, If any - #DIV/0!
Allocated Expenses (if any) - #DIV/0!
Less: Selling and Marketing Expenses - #DIV/0!
Freight & Cartage - #DIV/0!
Excise Duty - #DIV/0!
Others, If any - #DIV/0!
Rate differnece & Contingencies Provisions - #DIV/0!
Claims - #DIV/0!
Discounts - #DIV/0!
Profit / (Loss) before Interest & Depreciation - #DIV/0!
Less: Interest and Financial Charges -
Interest on long term loan - #DIV/0!
Interest on short term loans (W.C, OD, STL, TRL etc.) -
Other Interest - #DIV/0!
Other financial charges - #DIV/0!
Profit/ (Loss) After Interest but before Depreciation - #DIV/0!
Depreciation - #DIV/0!
Net Profit / (Loss) - #DIV/0!
Name of Company
nthly Satement of Profit or Loss
Previous Month Current Month Budgeted
Till Date For the Month Till Date For the Month
Amount In % Amount In % Amount In % Amount In %
- #DIV/0! - #DIV/0! - #DIV/0! - #DIV/0!
- #DIV/0! - #DIV/0! - #DIV/0! - #DIV/0!
- #DIV/0! - #DIV/0! - #DIV/0! - #DIV/0!
- #DIV/0! - #DIV/0! - #DIV/0! - #DIV/0!
- #DIV/0! - #DIV/0! - #DIV/0! - #DIV/0!
- #DIV/0! - #DIV/0! - #DIV/0! - #DIV/0!
- #DIV/0! - #DIV/0! - #DIV/0! - #DIV/0!
- #DIV/0! - #DIV/0! - #DIV/0! - #DIV/0!
- #DIV/0! - #DIV/0! - #DIV/0! - #DIV/0!
- #DIV/0! - #DIV/0! - #DIV/0! - #DIV/0!
- - - -
- #DIV/0! - #DIV/0! - #DIV/0! - #DIV/0!
- #DIV/0! - #DIV/0! - #DIV/0! - #DIV/0!
- #DIV/0! - #DIV/0! - #DIV/0! - #DIV/0!
- #DIV/0! - #DIV/0! - #DIV/0! - #DIV/0!
- - - -
- - - -
- #DIV/0! - #DIV/0! - #DIV/0! - #DIV/0!
- #DIV/0! - #DIV/0! - #DIV/0! - #DIV/0!
- #DIV/0! - #DIV/0! - #DIV/0! - #DIV/0!
- #DIV/0! - #DIV/0! - #DIV/0! - #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0!
- #DIV/0! - #DIV/0! - #DIV/0! - #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0!
- - - -
- #DIV/0! - #DIV/0! - #DIV/0! - #DIV/0!
- #DIV/0! - #DIV/0! - #DIV/0! - #DIV/0!
- #DIV/0! - #DIV/0! - #DIV/0! - #DIV/0!
- #DIV/0! - #DIV/0! - #DIV/0! - #DIV/0!
- #DIV/0! - #DIV/0! - #DIV/0! - #DIV/0!
- #DIV/0! - #DIV/0! - #DIV/0! - #DIV/0!
- #DIV/0! - #DIV/0! - #DIV/0! - #DIV/0!
- #DIV/0! - #DIV/0! - #DIV/0! - #DIV/0!
- #DIV/0! - #DIV/0! - #DIV/0! - #DIV/0!
- #DIV/0! - #DIV/0! - #DIV/0! - #DIV/0!
- #DIV/0! - #DIV/0! - #DIV/0! - #DIV/0!
- #DIV/0! - #DIV/0! - #DIV/0! - #DIV/0!
- #DIV/0! - #DIV/0! - #DIV/0! - #DIV/0!
- #DIV/0! - #DIV/0! - #DIV/0! - #DIV/0!
- #DIV/0! - #DIV/0! - #DIV/0! - #DIV/0!
- #DIV/0! - #DIV/0! - #DIV/0! - #DIV/0!
- #DIV/0! - #DIV/0! - #DIV/0! - #DIV/0!
- #DIV/0! - #DIV/0! - #DIV/0! - #DIV/0!
- #DIV/0! - #DIV/0! - #DIV/0! - #DIV/0!
- #DIV/0! - #DIV/0! - #DIV/0! - #DIV/0!
- #DIV/0! - #DIV/0! - #DIV/0! - #DIV/0!
- #DIV/0! - #DIV/0! - #DIV/0! - #DIV/0!
- - - -
- #DIV/0! - #DIV/0! - #DIV/0! - #DIV/0!
- - - -
- #DIV/0! - #DIV/0! - #DIV/0! - #DIV/0!
- #DIV/0! - #DIV/0! - #DIV/0! - #DIV/0!
- #DIV/0! - #DIV/0! - #DIV/0! - #DIV/0!
- #DIV/0! - #DIV/0! - #DIV/0! - #DIV/0!
- #DIV/0! - #DIV/0! - #DIV/0! - #DIV/0!
Amount (NPR)
Budgeted
Till Date
Amount In %
- #DIV/0!
- #DIV/0!
- #DIV/0!
- #DIV/0!
- #DIV/0!
- #DIV/0!
- #DIV/0!
- #DIV/0!
- #DIV/0!
- #DIV/0!
- #DIV/0!
- #DIV/0!
- #DIV/0!
- #DIV/0!
-
-
- #DIV/0!
- #DIV/0!
- #DIV/0!
- #DIV/0!
#DIV/0!
#DIV/0!
- #DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
-
- #DIV/0!
- #DIV/0!
- #DIV/0!
- #DIV/0!
- #DIV/0!
- #DIV/0!
- #DIV/0!
- #DIV/0!
- #DIV/0!
- #DIV/0!
- #DIV/0!
- #DIV/0!
- #DIV/0!
- #DIV/0!
- #DIV/0!
- #DIV/0!
- #DIV/0!
- #DIV/0!
- #DIV/0!
- #DIV/0!
- #DIV/0!
- #DIV/0!
-
- #DIV/0!
-
- #DIV/0!
- #DIV/0!
- #DIV/0!
- #DIV/0!
- #DIV/0!
Explanation for major variance in various expenditures:-
Sr. Description Variance Remarks
No Increase/
(Decrease)
10
11
Note:
MIS-9 May 2008
Company Name here
Debtors Aging as on
Pending Agewise Due
S.N Particulars Amount Up to 30 31 to 60 Days 61 - 90 Days 91-180 Days 181-365 Days above 1 Year
1 Debtors-Region A
1
2
3
4
5
6
7
Company Name here
MIS-10 Page 11 of 32 May 2008
Company Name
Creditors Ageing as on
Sr. No Particulars TOTAL
AMOUNT UPTO30 Days 31 - 60 Days 61 - 90 Days 91-180 Days
A Creditors-AMC
1
- -
B Creditors - Fuel, Stores & Consu.,
1
2
3
4
5
6
Total - - - - -
C Creditors - Job Work
1
2
3
4
5
6
7
8
9
Company Name Here
MIS-10 Page 12 of 32 May 2008
Total - - - - -
D Creditors - legal & Consultancy
1
Total - - - - -
E Creditors - Miscellaneous
1
2
3
4
5
6
Total - - - - -
F Creditors-Courier, Printg & Stationery
1
2
3
Total - - - - -
G Creditors - Raw Materials
1
2
3
4
5
6
7
Total - - - - -
H Creditors - Transports & Clearing
Company Name Here
MIS-10 Page 13 of 32 May 2008
1
2
3
Total - - -
GTotal - - - - -
Company Name Here
MIS-10 Page 14 of 32 May 2008
181-365 Days above 1 Year
- -
Company Name Here
MIS-10 Page 15 of 32 May 2008
- -
- -
- -
Company Name Here
MIS-10 Page 16 of 32 May 2008
- -
- -
Company Name Here
MIS-11 May 2008
Company Name here
BRS as on …. [Bank Name and Branch Place]
(Reconciliation)
Date Particulars Vch Type Bank Date Debit Credit
Balance as per Company Books :
Amounts not reflected in Bank :
Balance as per Bank :
Company Name
Pioneer Embroideries Ltd.
Division Lasser
Month July 2004
5. Budgeted Vs Actuals For the Month
Amount Variation
Particular
Actual Budgeted Amount %
Contribution
Manufacturing Expenses
Jobwork expenses
Mending charges
dyeing charges
punching charges
freight & octori inwards
coolie & cartage inwards
Wages :
On Rolls
Contractors
Others
Salaries of Technicals & Others
Staff Wealfare
Cutting & Packing charges
Power & Fuel
Electricity
Other Fule
Repair & Maintenanace
Machines
Building
Others
Administrative Exp.
Salaries
Staff Wealfare
Communication Exp.
Rent,Rates & Taxes
Legal & Professional Charges
General Expenses
Printing & Stationary
Vehical Running Exp.
Insurance Exp.
Travelling & Conveyance Exp.
Others, If any
Selling Expenses
Freight & Cartage Outward
Excise Duty
Others, If any (coolie & cartage exp)
Claims
Pioneer Embroideries Ltd.
Division-----------
Month------------
1 PERFORMENCE REPORT
Production For the Month Till Date
Rated Capacity (in Stiches)
Actual
Plant Efficiency
Production Breakdown
Machine
Want of yarn
Want of Job
Other Reasons
Sales
Less Expenses
Profit & Loss
Funds
In Flow
Out Flow
Balance in Bank
Outstanding
Debtors
Creditors
Others
Stocks
Yarn
Fabric
Finished Goods
Stores
Others
MONTHLY SALES FORECAST Data Entry Sales Report
TODAY'S DATE: DEC 30, 2017 12/30/2017
THIS MONTH ACTUAL PLAN VARIANCE % YTD ACTUA YTD PLAN YTD VARIANCE YTD %
Quantity 0 19
Sales NPR - NPR - NPR - - NPR - NPR - NPR -
Revenues NPR - NPR - NPR - - NPR - NPR - NPR -
Margin - - -
Number of Orders 0 0
Average Order Value - -
FORECAST NEXT MONTH NEXT QUARTER NEXT YEAR
Sales #VALUE! #VALUE! #VALUE!
SALES HISTORY
Column D Column E Column F Column G
1
0.9
0.8
0.7
0.6
0.5
0.4
0.3
0.2
0.1
0
MONTH FORECAST QUARTER FORECAST
1 1
0.8 0.8
0.6 0.6
0.4 0.4
0.2 0.2
0 0
YEAR FORECAST REVENUE STREAM
1 1
0.8 0.8
0.6 0.6
0.4 0.4
0.2 0.2
0 0
DAILY SALES REGISTER
DATE (mm/dd/yy)DESCRIPTION TYPE OF SALES VATABLE S SALES AMOUNT VAT % VAT Amount TOTAL SALES
Sand Cash Yes NPR - 13% NPR - NPR -
Roda Cash Yes NPR - 13% NPR - NPR -
Chips Cash Yes NPR - 13% NPR - NPR -
Sand Cash No NPR - 0% NPR - NPR -
Roda Cash No NPR - 0% NPR - NPR -
Chips Cash No NPR - 0% NPR - NPR -
Sand Credit Yes NPR - 13% NPR - NPR -
Roda Credit Yes NPR - 13% NPR - NPR -
Chips Credit Yes NPR - 13% NPR - NPR -
Sand Credit No NPR - 0% NPR - NPR -
Roda Credit No NPR - 0% NPR - NPR -
Chips Credit No NPR - 0% NPR - NPR -
NPR - 0% NPR - NPR -
NPR - 0% NPR - NPR -
NPR - 0% NPR - NPR -
NPR - 0% NPR - NPR -
NPR - 0% NPR - NPR -
NPR - 0% NPR - NPR -
NPR - 0% NPR - NPR -
NPR - 0% NPR - NPR -
NPR - 0% NPR - NPR -
NPR - 0% NPR - NPR -
NPR - 0% NPR - NPR -
NPR - 0% NPR - NPR -
NPR - 0% NPR - NPR -
NPR - 0% NPR - NPR -
NPR - 0% NPR - NPR -
NPR - 0% NPR - NPR -
NPR - 0% NPR - NPR -
DATE (mm/dd/yy)DESCRIPTION TYPE OF SALES VATABLE S SALES AMOUNT VAT % VAT Amount TOTAL SALES
NPR - 0% NPR - NPR -
NPR - 0% NPR - NPR -
NPR - 0% NPR - NPR -
NPR - 0% NPR - NPR -
NPR - 0% NPR - NPR -
NPR - 0% NPR - NPR -
NPR - 0% NPR - NPR -
NPR - 0% NPR - NPR -
NPR - 0% NPR - NPR -
NPR - 0% NPR - NPR -
NPR - 0% NPR - NPR -
NPR - 0% NPR - NPR -
NPR - 0% NPR - NPR -
NPR - 0% NPR - NPR -
NPR - 0% NPR - NPR -
NPR - 0% NPR - NPR -
NPR - NPR - NPR -
Remarks
No. of tips sold Sand Sales Roda Sales Chips Sales
Tipper
Bharat benz
Eicher 909
Eicher 709
Nissan
Four Wheel
Tractor
Remarks on other and vehicle rental income
No. of invoices issued
DATE (mm/dd/yy)DESCRIPTION TYPE OF SALES VATABLE S SALES AMOUNT VAT % VAT Amount TOTAL SALES
Bill nos. used
Void bills if any
MIS-4 May 2008
DAILY CASH AND BANK FLOW STATEMENT
Date:
PARTICULARS
OPENING BALANCES
Cash in Hand
Cash at Bank 1
Cash at Bank 2
Cash at Bank 3
Petty Cash
CASH INFLOWS FOR THE DAY
Total Cash Sales For the Day
Cash Collection From Parties
Other Cash Receipts
Director A
Director B
Received from Other Group Company
Other Recovery \ Adjustment
TOTAL CASH INFLOWS FOR THE DAY
CASH OUTFLOWS DURING THE DAY
Salary, Wages and other Allowances
Electricity Chgs
Communication Exp
Statutory Liabilities (VAT, TAX etc.)
Sundry Creditors
Sundry Debtors
Advance to Staffs for Expenses
Advances agst Salary \ Wages
Advance to Directors
Payment of Loan
Company Name
MIS-4 May 2008
Paid to another group company
Financial Charges (Bank Charges, Interest etc.)
Other Cash Expenses ( Routine petty cash expenses )
TOTAL CASH OUTFLOWS FOR THE DAY
NET CASH FLOW DURING THE DAY
CLOSING BALANCE
BREAKUP FOR CLOSING BALANCE
Cash in Hand
Cash at Bank 1
Cash at Bank 2
Cash at Bank 3
Petty Cash
For Cash at Bank (BRS enclosed)
Total
Company Name
MIS-4 May 2008
EMENT
Amount (Rs)
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
Company Name
MIS-4 May 2008
-
-
-
-
-
-
-
-
-
-
-
Company Name
MIS-7 May 2008
Summarised Details Of Daily Debtors
Particulars Amount Amount
Opening Balance of Debtors -
Less:- Credit balance adjusting with debtors -
Net opening balance of debtors -
Add:- Net Credit sales during the day -
Credit Sales -
Credit stock sales -
Vehicle Rental Income -
Other miscellaneous income
Adjustment on Sales if any -
Rate Diff /reco/other adj -
Cheque payment returned -
Less:- Collection from debtors during the day -
Total Collections -
Cash/Cheques received -
Collected by Head office -
Adjustments on Collection -
Goods returns and all -
Expenses Debited reversed/Rate Diff -
Sampling Charges reversed/refunded -
Advance Tax (TDS adjustments) -
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-7 May 2008
Summarised Details Of Daily Debtors
Particulars Amount Amount
Opening Balance of Creditors -
Less:- Credit balance adjusting with creditors -
Net opening balance of creditors -
Add:- Net Credit purchases during the day -
Credit Purchases -
Credit stock purchases -
Creditors for expenses -
Other payables if any
Adjustment on purchases if any -
Rate Diff /reco/other adj -
Other adj -
Less:- Paid to creditors during the day -
Total Payments -
Paid by cash -
Paid by cheque
Paid by group co -
Adjustments on Payment -
Goods returns and all -
Expenses reversed/Rate Diff -
Sampling Charges reversed/refunded -
Tax adjustments if any -
CLOSING BALANCE OF Creditors -
AS PER TALLY ACCOUNTS -
DIFF-(Debit balance adjusting with creditors) -
AS PER CREDITORS AGING SCHEDULE -
DIFF-(Credit balance adjusting with creditors-M/s If any customer having) -
Company Name
Summary
Raw Materials Sand Roda
Opening Stock - -
Add : Extracted/Produced - -
Less : Units Sold/Issued - -
Closing Stock - -
4,946,412 5,020,979
3,175,671 -
-
Chips
-
-
-
5,020,979
-
-