review of fap

8/2/2019 Review of Fap

1/5

FOOD CORPORATION OF INDIA

REGIONAL OFFICE, CHENNAI 6 .

Dt. 13.03.2012

REVIEW OF FAP FOR THE YEAR 2011-12 IN R/O DO VELLORE

FINANCIAL ACCOUNTING PACKAGE:-

A. ) 100% transaction entry in FAP and certification thereof.

1. Transactions in accounts payables module - Done on daily basis.

2. Accounts Receivable module - Done on daily basis.

3. Transactions in GL module

i.) IOR transactions -

MONTH BRANCH NAME DATE

APRIL 2011 DO VELLORE 09-04-2011

ARAKKONAM 30-04-2011,12-04-2011,15-04-2011

JUNE 2011 VELLORE FROM 13 ONWARDS THEY HAVE TO FED

ARAKKONAM FROM 11TH

ONWARDS THEY HAVE TO FED

JULY 2011 VELLORE,ARAKKONAM WHOLE MONTH NOT FED

AUG 2011 VELLORE ONLY 27,29,30 ENTRIES FED REST ALL ENTRIES NOT FEDARAKKONAM WHOLE MONTH NOT FED

SEP 2011 VELLORE,ARAKKONAM WHOLE MONTH NOT FED

OCT 2011 DO VELLORE OCT-WHOLE MONTH NOT FED

ARAKKONAM OCT-WHOLE MONTH NOT FED

NOV 2011 DO VELLORE NOV-WHOLE MONTH NOT FED

ARAKKONAM NOV-WHOLE MONTH NOT FED

DEC 2011 VELLORE,ARAKKONAM WHOLE MONTH NOT FED

Jan 2012 VELLORE,ARAKKONAM WHOLE MONTH NOT FED

Feb 2012 VELLORE,ARAKKONAM WHOLE MONTH NOT FED

AM COMMENTS:

ii) IOM transactions

Transfer-in & Transfer -Out - Not Done.

AM COMMENTS:


2/5

iii) IOCPF transactions - Done upto October 2012 (not reassigned).

AM COMMENTS:

iv) Other GL transaction - IOGs and other journals. Fed but 0.931 was operated

need to be fed freshly) list of Super User ID s of corresponding unit needed in order toreassign the IOGA invoices.

AM COMMENTS:

4. Fixed Assets transactions - Require Training.

5. Uploading of Bank statement - Require Training.

B.) Printing of daily reports and verification thereof for correctness.

1. Cash Book - Pending reconciliation.

2. Purchase Day book Purchase Day Book Not Applicable.

3. Sales Day book Report taken upto Feb 2012 (reconciliation pending) (not applied

with BEI Receipts)

AM COMMENTS:

4. Transfer In register - Reports not generated.

5. Transfer Out register - Reports not generated.

6. Journal Day Book - IOR report Reports not generated since IOR not reassigned.

7.Stock Ledger Summary - Report not generating properly (parameters needs to be

changed)

8. Fixed Assets Addition report - Require Training.

9. Fixed Assets Retirement report - Require Training.

C.) Status of incomplete transactions Please refer D O letter no dt 19.10.11 from DGM (F&A)

1. Unaccounted transactions report 57

2. Incomplete transactions report 7

3. Unpaid Invoices - 365 (out of which 345 dps salary invoices- remittance is pending

for the month of feb12)

AM COMMENTS (1,2&3):


3/5

D.) Bank Reconcilation report - Unable to upload, require training.

E. )Printing and verification of following subsidiary ledger on quarterly basis:

1. FCI creditors ledger - Report not generating properly (parameters needs to be

changed)

2. FCI debtors ledger - Report not generating properly (parameters needs to be

Changed)

3. General Ledger - Report generated reconciliation pending.

4. Trial Balance Detail- Report generated reconciliation pending.

AM COMMENTS (3&4):

5. Fixed Assets register Not functioning.

F.) Implementation of Payroll module

1. Status of implementation of DPS Labour - Done upto Feb 2012.

2.Status of implementation of Departmental Labour module - Not Applicable.

3. Status of rollout of employee payroll module Done upto Feb 2012.

4. Salaries to be paid through invoices generated through

payroll module - Feb 12 DPS salary invoices pending.

AM COMMENTS (4):

5. Payment of Salaries through ECS in FAP - Require Training.

6. CPF payment through invoice created by Z O only - Please refer D O letter no dt19.10.11 from DGM (F&A) Done.

G.) Completion of master data of employees EPS/CPFNO/DOB etc please referletter no Accts / FAP/2011-12 dt 25.10.11 Completed.

H.) Mandatory Payment through Electronic mode Yes.

Comment from Area Manager:-

AG II (D) MANAGER (A/CS) AREA MANAGER DGM (F&A)


4/5

FOOD CORPORATION OF INDIA

REGIONAL OFFICE, CHENNAI 6 .

POINTS FOR REVIEW OF ACCOUNTS FOR THE YEAR 2011-12

DO: : VELLORE

SLNO ORIGINAL BOOKS

OF ENTRIES

POSTINGS

MADE UPTO

POSTING

SHEET

DRAWN UPTO

POSTED TO

GENERAL

LEDGER

1 BE1- Recipt Cash BookJAN 12 DEC 11 DEC 11

2 BE2- Payment Cash

Book FEB 12 DEC 11 DEC 11

3 BE3 Petty Cash Book

JAN 12 DEC 11 DEC 11

4 BE4- Purchase day

Book NA NA NA

5. BE4- Purchase day book

- H & T JAN 12 JAN 12 DEC 11

6. BE5 Sales Day BookJAN 12 DEC 11 DEC 11

7. BE6- Transfer in

register DEC 11 DEC 11 DEC 11

8 BE7- Transfer out

register DEC 11 DEC 11 DEC 11

9 BE8- FCN RegisterJAN 12 JAN 12 DEC 11

10 BE9- Claims RegisterNA NA NA

11 BE10- Journal Register

a. IOGA DEC 11 DEC 11 DEC 11

b. Pay Journal DEC 11 DEC 11 DEC 11

c. Imprest Journal JAN 12 DEC 11 DEC 11

d. Misc Bills JAN 12 DEC 11 DEC 11

e. T A Bill FEB 12 DEC 11 DEC 11

f. Medical Bill JAN 12 - -

Comments from Area Manager :- Trial balance upto Dec11 is completed and pending issues will

complete shortly.


5/5

POSTING OF SUB LEDGER:-

SLNO

HEAD OF ACCOUNTS POSTINGS

MADE UPTO

RECONCILIATIO

N MADE UPTO

1 5.111 A/B /C Sy. Crs Central/StateGovt /pvt. parties Goods & Services

NOT COMPLETED NOT COMPLETED

2 5.112 SY CRS PAY &

ALLOWANCESNOT COMPLETED NOT COMPLETED

3 5.113 A / B /C Sy. Crs Central/

State Govt /pvt. parties O/s liabilities.NOT COMPLETED NOT COMPLETED

4 5.120 A/B /C Sy. Crs Central/

State Govt /pvt. parties Est. liability.NOT COMPLETED NOT COMPLETED

5 5.121 A/B/C Sy. Crs Central/ State

Govt /pvt. parties Pending disbursmentNOT COMPLETED NOT COMPLETED

6 5.127 X/Y CPF. NOT COMPLETED NOT COMPLETED

7. 5.151 - EMD NOT COMPLETED NOT COMPLETED8 5.152 Security Deposit. NOT COMPLETED NOT COMPLETED

9 8.222 Vehicle Advance PROCESS PROCESS

10 8.223 Tour Advance JAN 12 JAN 12

11 8.224 Festival Advance. JAN 12 PROCESS

12 8.225 Flood Advance. PROCESS PROCESS

13 8.227 Pay Advance NOT COMPLETED NOT COMPLETED

14 8.227A Wage Revision Adv. NOT COMPLETED NOT COMPLETED

15 8.227 E/F/G PLI Advance. NOT COMPLETED NOT COMPLETED

16 8.228 HBA. PROCESS PROCESS

17 8.229 Medical Advance. JAN 12 JAN 12

18 8.230 Computer Advance. NOT COMPLETED NOT COMPLETED

19 8.231 Other Advances. NOT COMPLETED NOT COMPLETED

20 10 series Journals. DEC 11 DEC 11

Comments from Area Manager :-

BANK RECONCILIATION MADE UPTO : DEC 11

IOG A/ IOM/ IOR / IOCPF SENT UPTO : JAN 12

IOG A/ IOM/ IOR / IOCPF RECEIVED UPTO : DEC 11

RECONCILIATION OF STOCK LEDGER WITH MONTHLY STOCK ACCOUNT : DEC 11MAINTANCE OF ASSET REGISTER : WILL BE UPDATED SHORTLY

MDM STATUS Pending amount for Fab12 is Rs 1.01 Crore only.

-COMMENTS FROM AREA MANAGER --

AG-II (DEPO) MANAGER A/C AREA MANAGER DGM (F&A)

review of fap

Documents