LISTING

General Ledger :
1. Advances to Staff and Workers – Receipts and Payments – Employee wise
2. Labels and Packing – Product wise
3. ERE Related Accounts viz...
i) Leave Travel Allowance – Employee wise
ii) Reimbursement of Medical – Employee wise
iii) Leave Salary and Wages - Employee wise
iv) Awards for Completion of 20 / 25 years - Employee wise
v) Labour Welfare I A/c – Nature of Expenses (Sub Ledger wise)
vi) Labour Welfare II A/c – Nature of Expenses (Sub Ledger wise)

4. General Expenses – Nature of Expenses (Sub Ledger wise)
5. Safety Expenses – Nature of Expenses (Sub Ledger wise)
6. R & D Expenses – Nature of Expenses (Sub Ledger wise)
7. Effluent Expenses – Nature of Expenses (Sub Ledger wise)
8. Legal and Professional Expenses – Service Provider wise
9. Telephone and Telex Expenses – Telephone Number wise
10. License fees – Nature of Expenses (Sub Ledger wise)
11. Processing Charges – Product wise
12. Repairs to Machinery – End Use department wise
13. Repairs to Machinery – Nature of Expenses (Sub Ledger wise)
14. Repair to Others – Cost Centre wise and Nature of Expenses (Sub Ledger wise)
15. Commission and Discounts – Product wise
16. Commission and Discounts – Customer wise
17. Traveling Expenses – Employee wise
18. Freight Inward – Raw Material wise
19. Freight on Export – Product wise
20. Freight out ward – Product wise
21. Freight on Stock Transfer – Product wise
22. Unit Reconciliation should be through system, without manual intervention.

Cash Book & Bank Book
a) Screen should display the balance after recording of each Voucher / Receipts.
b) Separate space to be provided for: - Name of Payee, Reason of Payments.

Bank Reconciliations
Bank Reconciliation to be computerized, we entered only cheques cleared at Bank with
Amount as well as of receipts and other charges. Reconciliation Payments, Reconciliation
Receipts should be generated and get printed from system.

Addition to Fixed Assets & Depreciation.
At Present we are using separate package in FoxPro for addition to fixed assets and
Depreciation Working. At present we are recording Purchase bills twice i.e. once in
Our F A system and secondly into our FoxPro System.

To avoid double entry it should be linked with our Depreciation system up to Fixed
Assets Schedule and following reports are to be required through systems.

a) Fixed Assets Schedule as per Companies Act and Income Tax.
b) Addition during the year with Above Rs. 5000 and Below Rs.5000 format
c) Depreciation with below Rs.5000 format.
d) Addition during the year with above 180 day and below 180 days.
e) Depreciation Calculation as per Companies Act and as per Income Tax Act.
f) Details of other charges debited to fixed assets.
g) Working of Profit or Loss on sale of Assets.
h) Year wise computation of depreciation on Fixed Assets.
(At present we are preparing the above reports manually in XLS format)

Following Additional reports are require to be generated through systems

a) Relocation Report - Details of transfer assets from one location to another location.
b) Assets transaction Report - Details of Assets Code, Assets names, date of capitalization, date of sale, cost of Purchase and Sales value, for Transfer of assets will generate report
With detail as date of transfer, Assets from & Assets to.
c) Fixed assets Register - Details information with their component details. Date of capitalization, Vendor name, location, rate of depreciation, total cost of assets, Profit/Loss on assets, total depreciation on assets and net cost of all assets. Etc.
d) AMC Expiry Report - AMC Expiry report for a particular asset for a particular period.
e) Insurance Expiry Report - Insurance Expiry report for a particular asset for a particular period.
f) Assets Service Due Report – Assets for which the service is due from a particular date.
g) Physical Verification Report – Details of Location, Assets Code, Assets description, Component
Code and description and quantity of assets.
h) Warranty Expiry Report - Warranty expiry for a particular assets for a particular period.
Others details reports.

Service Tax on GTA and other than GTA:
At present we have separate package for Service tax on GTA and other than GTA, it
Should be linked with our FA system and report to be generated in our existing format.
i) Service Tax Register for taking Cenvat Credit – Other than GTA
ii) Service Tax Register for taking Cenvat Credit – other than GTA - Account wise
iii) Service Tax Register for taking Cenvat Credit – of GTA
iv) Service Tax Register for taking Cenvat Credit – of GTA – Account wise for taking Credit


Statutory Audit Statements:
At present we are preparing audit statement manually in worksheet as per requirement of Audit, it is nothing but coping the FA data in worksheet. If audit statement generated through system it is useful for avoid the duplicate working. The list pf reports are attached separately.

Tax Audit Statements:
It should be linked with our systems. The list pf reports are attached separately.

Sales Tax related:
The purchase and sales summery required for filling the monthly returns of VAT and CST should be generated from the system as per formats given in As Is process.

TDS on Contractors and Legal Professional fees , Commission
The above should be linked to FA system and generate the reports as per existing system.

Unit Control Account
All inter unit transactions should be computerized and there should be no manual intervention.

TDS under works contract
The TDS under works contract should be linked to FA system and generate the reports
As per existing system.