Monthly MIS
This query is : Resolved
03 October 2010
Hi
Can anyone tell me how to prepare monthly MIS - monthly P&L and Balance sheet.
How to give effect to prepaid expenses, proposed tax, provision, depreciation etc on a monthly basis. & which entries are to be reversed in the following month.
regards
sweta
Can anyone tell me how to prepare monthly MIS - monthly P&L and Balance sheet.
How to give effect to prepaid expenses, proposed tax, provision, depreciation etc on a monthly basis. & which entries are to be reversed in the following month.
regards
sweta
05 October 2010
Normally any FA package will generate monthly PL & BS.However proper schedule wise BS can be prepared every month.Schedules like,
1.Fixed Assets
2.Cash & Bank
3.Accounts Receivables
4.Other Receivables
5.Advance to Employees
6.Provision for Bad Debts
7.Inventories-RM & FG
8.Provision for Inventory obsolescence
9.Advance to Suppliers
10.Prepaid Expenses
11.Other Current Assets(Rental deposits,supplier deposits,Deposits to sales tax ,electricity,telephone)
12.Accounts Payable
13.Accrued Expense
14.Taxes payable(TDS,Itax,PF ,Ptax,Sales Tax,VAT,Service tax,Excise)
15.Other Current Liabilities(Security deposit from dealers)
16.Short term borrowings(OD,Term loan)
1.Fixed Assets
2.Cash & Bank
3.Accounts Receivables
4.Other Receivables
5.Advance to Employees
6.Provision for Bad Debts
7.Inventories-RM & FG
8.Provision for Inventory obsolescence
9.Advance to Suppliers
10.Prepaid Expenses
11.Other Current Assets(Rental deposits,supplier deposits,Deposits to sales tax ,electricity,telephone)
12.Accounts Payable
13.Accrued Expense
14.Taxes payable(TDS,Itax,PF ,Ptax,Sales Tax,VAT,Service tax,Excise)
15.Other Current Liabilities(Security deposit from dealers)
16.Short term borrowings(OD,Term loan)
Message likes :
1 times
05 October 2010
For each month end several activities are to be followed religiously(and of course proper analysis must be done )
1.Depreciation of Fixed assets
2.Prepaid schedule at the month end and write off
3.Accrual of expenditure (e.g. certain expenses incurred but invoice towards the same is not received,these can be reversed at the beginning of the next month and new accrual can be done on the basis of new information/analysis)
4.Revaluation of foreign currency balances
5.Provision for bad debts/return provision
6.Income accrual(again can be reversed next month)
7.Provision for obsolesence
8.Provision for Income tax
9.TDS payable checking
10.Checking of VAT/Central Excise/Service tax payable
1.Depreciation of Fixed assets
2.Prepaid schedule at the month end and write off
3.Accrual of expenditure (e.g. certain expenses incurred but invoice towards the same is not received,these can be reversed at the beginning of the next month and new accrual can be done on the basis of new information/analysis)
4.Revaluation of foreign currency balances
5.Provision for bad debts/return provision
6.Income accrual(again can be reversed next month)
7.Provision for obsolesence
8.Provision for Income tax
9.TDS payable checking
10.Checking of VAT/Central Excise/Service tax payable
Message likes :
1 times
You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now
Click here to login now
Similar Resolved Queries
Unanswered Queries
- Depreciation Chart Companies Act
- GST Audit whether Govt Companies are exempt?
- PTRC Show Cause Notice on Email
- Accounting treatment of AMC alongwith the purchase of Laptop
- Unable to File TDS Q2 Return – New TRACES Portal Error
- Capital Gail Exemption Certificate
- Taxation of crypto futures in India Fy 2026- 2027
- EPF ECR NEW RULES Sep 17th 2026
- Not ordinarily resident having partnership income in India and salary in USA is any form to filed be
- Issuing of delivery challan by seller of goods
- GST Treatment of Purchases with GST Paid where Outward Supplies of Manufactured CattleFeed Exempt
- Expert Help Required for TDS Refund 100000 Through TRACES – AY 2022–23
- IMPORT PURCHASE ENTRY PASSED IN BOOKS OF ACCOUNT
- FAST DS 26 Undisclosed Foreign Asset Disclosure Scheme 2026
- Regime change
- Goods sold but invoice not issued
- Tally: Imported bank entries do not show up in manual reconciliation
- Sales of goods of amount Rs97 lakhs to a party
- Confused About My Career After 12th — Cyber Security, AI or Finance? Need Guidance
- FAST-DS 2026 Under Tax Law - No recourse or support for person declaring via this scheme?
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
Subscribe to Pro
Join an elite circle of professionals
CAclubindia
