internal audit report finance sales processing q1-2014-15 · 2014-10-30 · internal audit...
TRANSCRIPT
Internal Audit Department ,Duliajan Page 1
Internal Audit Report – DULIAJAN SPHERE (Finance- Sales Processing)
Report No. IA/DS/FY-2014-15/Q1
Period Covered – April’ 2014 to June’ 2014
Report date: 30.10.2014
Internal Audit Department ,Duliajan Page 2
Resident Chief Executive
Sub: Internal Audit Report for the period April’14 to June ’14 (Q1) of Duliajan Sphere – Finance(Sales Processing)
1.0 The Internal Audit Department has conducted the audit of Duliajan Sphere-Finance (Sales Processing) for the period from April ’14
to June’14. The audit areas, which have been covered during the audit, have been enclosed herewith . The audit has been conducted on
the basis of generally accepted audit standards in India.
2.0 The audit observations, based on the documents produced and the explanations received, are shown in Detailed Audit Observations
with the Management‘s views duly incorporated against thereon.
3.0 Implementations of the recommendations of the audit should be completed as early as possible but not beyond the implementation
timeline specified therein.
4.0 The Internal Audit Team is pleased to acknowledge the cooperation received from the concerned departmental Head & their
representatives in conducting the Internal Audit.
Bontu Hari Shankar
Chief Manager (IA)
For GM (Audit) Date: 30.10.2014
CC: CMD / D (E&D) /D (HR&BD) / D (O) / D (F) / GM (F&A)/GM (Audit)/ Head -Accounts
Internal Audit Department ,Duliajan Page 3
Introduction
1. Brief Scope of Work
Department Scope of Work
Finance-Sales Processing • Review of MOU/COSA
• Verification of Bills
• Reconciliation of Outstanding Balances
• Payment of Statutory Taxes & Duties
• Sales Tax Assessment
• Review of Handling Charges, MGQ
• Review of Sticky Debtors
1. Background of conducting Internal Audit:
The Audit for Q1 has been completed by the team comprising Shri Sanjay Khatri (Manager –IA ) , Smt Pompy Bora (Sr Internal Auditor) & Shri
B.K Borsaikia (Internal Audit Officer) during 20.08.2014 to 28.08.2014. Management Comments to the audit observations have been received
from Finance Department on 21.10.2014.
The Audit Report includes observations of Internal Audit Team, related risk matrix, recommendations of audit team and the corresponding
management’s feedback received there against .
Internal Audit Department ,Duliajan Page 4
Detailed Audit Observations of Sales Processing for QTR-1 of 2014-15
Sl.
No.
Observations Risk Recommendations Management Comments /Implementation Timeline &Responsibility
1 Verification of Bills on the basis of Provisional/Final Invoices,Price
Rates maintained in the System, COSA/MOU, Joint Measurement
Certificates .
Crude Oil : Audit observed that Billing for Crude Oil was done based on
the MOU with IOCL & NRL , the validity of which was expired in the year
2004.MOU was signed pending execution of COSA. Though several
correspondence regarding COSA were made & represented by Higher
Management but till date nothing is materialised.
Natural Gas(NG) : Audit observed that Billing for NG are being done
based on prices published by MOP&NG on intervals & found the same in
order.
LPG : LPG’s are sold exclusively to IOCL based on agreement signed in
1985 which needs revision in entirety due to change in Business
dynamics e.g existing agreement is more than 25 years old ,LPG filling
cost has been increased manifold ,current filling rate realised by some
other oil companies are much higher then the rate as per existing
agreement .Though several communications have been exchanged in this
regard but till date the revised agreement is pending.
Audit further noticed that there are two separate Price rate of LPG for
Industrial & Domestic use. Domestic LPG rate is lower than Industrial LPG
rate .Till now Oil India is selling LPG to IOCL at domestic rate .But there is
no mention in the MOU/agreement whether the billing to IOCL will be
made at Domestic/Industrial rate.
Financial
/
Complia
nce
COSA should be made
immediately with all the
refineries .
Similarly, Agreement
with IOCL for LPG
including Transportation
& Other agreements
which are going to be
expired in short term
should be amended
/revised/extended at
the earliest.
A confirmation is
required for the use of
LPG by IOCL for
Domestic purposes only.
Efforts should be made
a) Management comment-
Planning Department to
provide the detailed status.
Our LPG bottling plant is only for
domestic bottling. So far as the
bulk supply is concerned, that
supply is for Digboi bottling plant
of IOCL which is stated by them
as being used for domestic
bottling only.
For fixing of Crude Oil
Transportation Charges, a
Internal Audit Department ,Duliajan Page 5
Sl.
No.
Observations Risk Recommendations Management Comments /Implementation Timeline &Responsibility
Transportation : Audit observed that bills for Crude Oil transportation
was raised as per Old MOU which is already expired & which needs to be
revised at the earliest.
A list of MOU/Agreement (provided by Auditee ) & their Validity is
furnished below:-
Customer
Agreement/
MOU date Validity Upto
IOCL(LPG) 28.05.1985 Till IOC is authorised
by GOI to market LPG
IOCL (Crude) & its
subsidiary 07.04.2003 31.03.2004
NRL(Crude) 09.04.2003 31.03.2004
EPC(Condensate) 16.03.2012 15.03.2015
Sikkim Organics(Condensate ) 17.03.2012 16.03.2015
Keep Safe(Condensate) 15.03.2012 14.03.2015
NEEPCO( NG) 13.01.2005 12.01.2015
for early execution of
agreements.
committee (with representatives
from OIL, NRL & IOCL) was
constituted as per MoP&NG’s
directive on 23.08.12 & based on
their report, the transportation
invoices are being raised.
Planning Department to
provide the detailed status for
extension /signing of Contract.
b) Implementation Timeline:
As early as possible
c)Implementation responsibility:
GM(F&A)
Internal Audit Department ,Duliajan Page 6
Sl.
No.
Observations Risk Recommendations Management Comments /Implementation Timeline &Responsibility
AGCL(NG) 12.06.2014
Till finalisation &
Signing of GSPA which is
agreed to be executed
within six months.
NRL(NG ) 17.03.2005
15 years from
commencement of
supply
Tingri Gas(NG) 12.08.2011 15 years from 12.08.2011
NE Thermion Pvt.Ltd(NG) 03.06.2011 10 Years from 03.06.2011
2
Adherence to Billing Schedule & other contractual terms (e.g
Payments ,Penalty clause , Interest, BS&W) as per MOU/Sales
Agreement.
(i) Billing for Crude Oil are in line, however it was found Creation
of Sales order/raising of Bills are not done timely though
payments are received as per schedule time . Delays noticed
in making the first Provisional Bills(raised upto 7th of the
month) & final bills in respect of Crude (IOCL), LPG, Electricity.
Delay in raising the Invoice may result in delay in
collection. Separate Debit notes/Credit Notes are also raised
for Crude in addition to Final Invoicing (which is not as per
agreed MOU) in the following month (e.g for April Invoicing , in
addition to final invoicing ,Debit note/credit notes are also
raised separately in the month of May). (A list of Bills with
Financial
/Compli
ance
It is recommended that
Provisional & Final
Invoice should be raised
as per schedule timeline-
mentioned in
MOU/agreement in
respect of all products.
a) Management comment-
Crude Oil & LPG invoicing are
subject to Under-recovery
Mechanism, so final invoice can
be raised only after getting the
final discount rate declared by
MoP&NG. For the quarter under
audit, we received the
notification of final discount on
08.08.14 & accordingly we raised
the Dr. Note on Crude & LPG bills.
Moreover, as it was the 1st
quarter of the FY, we had to wait
for the Whole-sale Price Index of
last year (i.e. for FY 13-14)
without which the crude oil
transportation rates could not be
Internal Audit Department ,Duliajan Page 7
Sl.
No.
Observations Risk Recommendations Management Comments /Implementation Timeline &Responsibility
creation date attached for reference-Annexure 1).
(ii) No penalty clause/Interest for delay in payment is documented in
the MOU for sale of Crude & LPG .
(iii) In case of Natural Gas, clause for Interest/Penalty clause exists but
till the date of Audit, no supplimentary invoice for interest &
Interest & Penalty clause
should be incorporated
in all agreements for LPG
& Crude after review in
old /new agreements.
Interest should be
finalised.
Marginal delay, if any in provisional
billing happens due to delay in
creation of sales orders by user
department after quantity and/or
quality reconciliation with the
customers. In such cases proper
follow ups are made for getting
the payment within the
scheduled time.
Please note that the “posting
date” as shown in Annexure 1
should not be considered as the
billable date. It is maintained for
proper accounting and suitable
identification only. Your
recommendation in this regard
is noted for implementation to
the extent possible.
(ii)Planning Department to
provide the detailed status.
(iii)Invoices for interest /
penalty has been raised
wherever applicable on
delayed Payment on half yearly
basis as per practice but is
booked in our SAP accounting on
Internal Audit Department ,Duliajan Page 8
Sl.
No.
Observations Risk Recommendations Management Comments /Implementation Timeline &Responsibility
Penalty for delay in realisation of payment were raised though
customers have defaulted in making timely payments as per
Agreement. A list of Outstanding Invoices with customers are
attached in Annexure -2
(iv) BS&W : It is observed while verifying the invoices of the period
from 01.04.2014 to 16.05.2014 that in case of sale of crude oil to
IOCL,Bongaigaon Refinery ,BS & W % is taken higher by Production
Oil Dept. as compared to other customers like NRL,IOCL .
The Audit team has asked Auditee to submit the Lab/Joint Certification report
for further verification
charged as per
MOU/Agreement for
delay in payment in case
of Natural Gas under
intimation to audit.
Steps to be taken for
reviewing BS&W% for
avoiding more discounts
to the IOCL Bongaigaon in
comparison to other
customers.
realization of the same as per
our Accounting Policy.
Invoice-wise Comments are
embedded in the Annexure 2
itself.
(iv)Production Oil Department
to provide details and
response.
b) Implementation Timeline:
Future compliance
c)Implementation responsibility:
GM(F&A)
3 Reconciliation of Outstanding Balances /Adjustment/Periodical
Confirmation & Follow up Process.
(i) On scrutiny of Debtors ledger(As on 31.07.2014 ) , it was found
a large number of entries for debit balances & credit balances
are lying open & un cleared since long period which is giving
wrong picture of outstanding dues .(Some Clearing Entries
were passed in August for Qtr -1,during the course of Audit.)
(ii ) It was noticed the Collection entries are not passed in the
debtor’s ledger in the same month which gives wrong picture of
Outstanding statement.
Financial
Wrong
MIS
The observation
indicates non review of
the outstandings /
reconciliation and
balance confirmations.
Delay on this may lead to
loss of interest due to
delay / pending
recovery.
Comments and
confirmation on
compliances be provided
to audit for verification.
a) Management comment-
We get the information of
amount credited into our bank
account from the online bank
statement but we have to wait
for confirmation from the
concerned customers regarding
the details of the payments
made. Mainly we have to wait for
the details of amount deducted
(e.g. TDS, VAT, other
adjustments etc.) from our
invoices. So, at our A/R section,
we maintain an excel sheet to
Internal Audit Department ,Duliajan Page 9
Sl.
No.
Observations Risk Recommendations Management Comments /Implementation Timeline &Responsibility
System of Recovery
should be further
strengthened & more
follow up with customer
is required.
Collection entry should
be passed in respective
Debtor account in the
same month.
track the invoice-wise payments
for checking the timeliness of the
payments. Whenever we find any
discrepancy with the due
amount, we immediately contact
the concerned customers for the
details of the same.
Moreover, please note the below
mentioned points related to this
matter:
1. The Dr/Cr Notes against
Final Discount on Crude Oil &
LPG for the 4th Quarter of FY
2013-14 are raised in the last
part of May’14 but for proper
accounting purpose those are
booked in the 4th Quarter itself,
hence no clearing entries could
have been passed before getting
the discount figures and
resulting adjustments as
explained during the audit.
2. The Dr. Note on Final
Discount amount on LPG (taken
by IOCL-AOD) for the 4th Quarter
of FY 2013-14 are too high to be
absorbed by the pending LPG
Invoices. So, IOCL has adjusted
that portion of un-absorbed
Internal Audit Department ,Duliajan Page 10
Sl.
No.
Observations Risk Recommendations Management Comments /Implementation Timeline &Responsibility
(iii) Agewise Analysis of Debtors as on 31.07.2014 enclosed for
reference as Annexure-3.It may be observed from Annexure
that there are many uncleared Bank Receipts, Customer
Reconciliation &
confirmation of all
customers should be
discount with our Crude Oil
Invoices to IOCL thereby no
clearing entry could have been
passed before full adjustment.
As the said excel sheet is the main
tracking point, clearing the
debtors’ ledger in SAP is done on
quarterly basis only. Your
recommendation is noted in
this regard for onward
implementation to the extent it
is possible.
The said Annexure-3 is not the
right depiction of Age-wise
Analysis because of the non-
cleared items in SAP ledger as
explained above. A manual Age-
wise Analysis Report is
maintained in excel format
which has already been shown
at the time of Audit.
3. A statement showing the
reconciliation & confirmation
status or the concerned
comment on the balance is
enclosed herewith. This has
Internal Audit Department ,Duliajan Page 11
Sl.
No.
Observations Risk Recommendations Management Comments /Implementation Timeline &Responsibility
Credit Memo, Customer Invoice, Cash Journal in customer
a/cs.
In many of the cases reconciliation & confirmation of balances
are not taken periodically which may lead to possibility of
disputes & financial loss at later stage.(Annexure-3). It is
found that the Balance Confirmation in respect of IOCL ,NRL are
taken on Quarterly basis. However, in few cases which are high
value customers like Assam Gas Co., GAIL, NRL Golaghat
,BVFCL, Assam Petrochemicals etc. , reconciliation & balance
confirmation are not takenfor more than 1 year. Difference
noted in IOCL statement on 31.03.2014 for 1.63 Crore.
Audit also found that without clearing the old & over due outstanding,
sales invoice are raised with the same customer which may raise
questions on the possibility of recovery of earlier overdue oustandings in
absence of Periodical Balance Confirmation &Regular & Timely
Collection Process.
(iv) LPG Outstanding status as on 31.07.2014 for IOCL – 1.05 Crore.
As per agreement”IOCL shall make payment to OIL on or before
29th of calendar month for supplies effected in first fortnight &
or 14th of following month for supplies effected during the
second fortnight . It was found that Net Due date was wrongly
made for better control
& correct picture of
outstanding balances
already been provided to audit
during audit. The reasons of
difference of 1.63 Crore (out of
which Rs.0.56 Crore has already
been settled) as on 31.03.2014
with IOCL-AOD was duly
reconciled and agreed on
26.04.2014. The copy of that
reconciliation statement has
already been submitted to audit.
As already explained in above
paragraphs, it is not always
possible to clear the entries
instantly. Accordingly, next
invoices need to be raised even
without clearance of earlier
entries as both the activities are
unrelated.
4.Due to a clerical error, the Net
Due Date got wrongly selected as
29.06.2014 instead of
14.07.2014. The issue has been
discussed with ERP Department
to do away with such errors in
Internal Audit Department ,Duliajan Page 12
Sl.
No.
Observations Risk Recommendations Management Comments /Implementation Timeline &Responsibility
entered 29.06.2014 instead of 14.07.2014 (Invoice No.
704437,704438,704439). Moreover the same was lying
outsanding as on 31.07.2014 , beyond contractual period
Year/
month Inv. ref.
Doc.
Date
Net due
dt Amt in
loc.cur. Arrear
2014/03 704437 30.06.14 29.06.14 8,773,692.09 32
2014/03 704438 30.06.14 29.06.14 364,924.59 32
2014/03 704439 30.06.14 29.06.14 1,431,076.80 32
future.
Moreover, we have duly received
that amount within the schedule
date i.e. 14.07.2014. The same
has been booked in SAP Debtors
Ledger on 14.08.2014 but it was
already updated in our manual
tracking system (i.e. the excel
sheet) and the same was
informed at the time of Audit.
So, there is no Arrear in
payment as shown in the
statement.
b) Implementation Timeline:
Future compliance
c)Implementation responsibility:
GM(F&A)
4 Recovery & Payments of Statutory Taxes & Duties , Cess , Royalties as
per Government’s directives .
Crude Khumsai : It was found that NO VAT/CST was charged from customer
(AOD) for sale of Crude from Arunachal Pradesh.
Auditee needs to apprise Audit Team for not charging VAT for sale of Crude
Financial
/
Complia
nce
Errors as pointed out by
audit may lead to
deposition of statutory
dues wrongly and
realisation of same take
a) Management comment-
As per our information, CST is not
applicable on Sale from
Arunachal Pradesh w.e.f.
01.04.2006. Relevant document
in support of the same will be
Internal Audit Department ,Duliajan Page 13
Sl.
No.
Observations Risk Recommendations Management Comments /Implementation Timeline &Responsibility
to AOD from AP – because Non Payment of VAT/CST may lead to evasion of
Statutory Liabilities & consequential litigation & Penalty.
Condensate/Crude:
Education cess @ 3% has been charged on the Cess amount on crude which
was reversed on 30.06.2014. As per Notification ,Education cess is not
applicable from Jan’2014 but still Invoice in SAP are generated with 3%
Education cess on Cess which is not correct. On further scrutiny, it is found
that for invoicing of July’2014 & August 2014, also Education cess is charged
@ 3%.
In addition to above ,value of C form Outstanding as on 30.06.2014 for sales
effected for Qtr 1 2014-2015 on account of condensate is 21 Crore . In case C
form is not collected then Liability on account of C form will be full Vat rate
i.e (5%- 2%) i.e 3% on 21 crore i.e 60 lacs(Approx.)
LPG:
In addition to above ,value of C form Outstanding as on 30.06.2014 for sales
effected for Qtr 1 2014-2015 on account of LPG is 2.5 crores .
lot of time and money.
It is advised that
separate study should be
done immediately by the
function for generation
of correct invoice with
proper taxes and duties
to avoid any wrong
Invoicing, incorrect
accounting treatment &
Non Compliance issue.
Such discrepancies if
observed along with
corrections carried out
be furnished to audit for
review. Non collection
of C forms is a loss to
corporation.
C form outstanding for
earlier years as well as
current year needs to be
collected on urgent basis
and realisation the
provided separately.
Your recommendation is
noted for immediate
implementation. The matter
has been taken up with ERP
Dept. for required correction in
the “Pricing Condition” under
SAP Billing.
As recorded by audit, Accounting
correction for the 1st Qtr. has
already been made and the same
will also be done for the 2nd Qtr.
The system implementation will
be initiated soon.
Regular follow ups are made
with concerned parties for
collection of “C” Form. Your
recommendation however is
noted.
Internal Audit Department ,Duliajan Page 14
Sl.
No.
Observations Risk Recommendations Management Comments /Implementation Timeline &Responsibility
It was also observed that LPGs are sold exclusively to IOCL and as per
agreement IOCL shall make payment of sales tax amount along with the
product value. However it was found that CST charged on invoices were not
paid by IOCL.
Crude Oil (Customer code -100000,100002,100003):
No sales Tax charged for following Invoices (Debit notes)
104712,104713,104714, Total sales Value- Rs. 4090747 , Vat Liability-
204537.
No sales Tax was charged for following Invoices for Oil despatches to
IOCL Digboi
104548,104553,104558,104562,104600,104605,104635,104610,10463
9,104644,104663
Auditee to apprise the reasons for not charging VAT on above invoices
pending be confirmed to
audit.
Please confirm currently
C forms are realised as
per the norms.
-
These invoices are against sale of
Crude Oil from Arunachal
Pradesh (Khumchai Oil Field), so
VAT is not applicable.
b) Implementation Timeline:
As early as Possible
c)Implementation responsibility:
GM(F&A)
5 Completion of Sales Tax Assessments :
It was found that Demand Order of Rs. 1325 Crore (As per Annexure 4)
has been issued on 02.07.2014 under VAT for the Financial years -2009-
2010, 2010-2011, 2011-2012, 2012-2013 on the following grounds :-
1. Disallowance of discount given to Oil Marketing companies: As per
Financial
/
Complia
nce
Chronological status and
action taken report since
02.07.2014 be furnished
a) Management comment-
Writ petition has been filed on
29.09.2014 details of which will
be provided separately.
Internal Audit Department ,Duliajan Page 15
Sl.
No.
Observations Risk Recommendations Management Comments /Implementation Timeline &Responsibility
Assessment Order ,such “Discount “ cannot be treated as “Discount “in
real terms in VAT parlance.
2. Transportation Income cannot be excluded from the Sales Price &
hence subject to VAT.
It was explained that against the above Demand , a writ petition will be
filed before Guwahati High Court for stay & consideration on merit
ground .
For earlier Financial years i.e 2005-2006 & 2006-2007 , file is pending
for revision before Commissioner of Taxes , Assam & for 2007-2008 &
2008-2009 , file is pending for final assessment .
It was also found that C form to a tune of 217.53 Cr (Net Sales value)
pending from Financial year 2010-11 to 2013-2014 on account of
Condensate sales under CST Act (annexure-5).Out of pending C form
217.53 Cr (Net Sales), Sikkim Organics has an outstanding C form liability
of 210.46 Cr from financial year 2011-2012 to 2013-2014.
to audit for review.
C form outstanding for
earlier years as well as
current year needs to be
collected on urgent
basis. Delayed / non
collection is serious in
nature.
Regular follow ups are made with
concerned parties for collection
of “C” Form. Your
recommendation however is
noted.
b) Implementation Timeline:
As early as Possible
c)Implementation responsibility:
GM(F&A)
6 Handling & Processing Charges :
i) Processing Charges are billed to IOCL in respect of LPG filling.
We have verified invoices for bottling charges with respect to
agreed rate & are found to be same in line with agreed rate.
Financial
/
Complia
nce
Steps taken to revise the
rate of Bottling charges
to avoid financial loss for
under billing/under
recovery of Bottling
a) Management comment-
Process is going on for revision of
packing charge. The Corporate
Office, New Delhi is
Internal Audit Department ,Duliajan Page 16
Sl.
No.
Observations Risk Recommendations Management Comments /Implementation Timeline &Responsibility
However, it was found that the bottling charges recovered from
IOCL are comparatively lower then Actual Bottle filling Cost. Bottle
filling cost is estimated to be about Rs 2806.07 per MT where as
the recovery is found to be Rs. 1100 per MT which is as per
agreement executed way back in 1985. In this regard a letter was
issued to Executive Director of IOCL to revise rate on 29.11.2010
.After that there is no further communication is seen.
Audit found that Total Sales for Q1 2014-2015 is 152.082 MT of LPGPKD
so loss on account of bottling charges is Rs. 2.60 lacs approximately for
Q1.
i) Bills for other Services charges like fire fighting, steam, utility
power & water and fuel gas for residential quarters etc at Moran &
Jorhat in connection with Transportation Agreement are not
raised.
The Audit team asked for clarification of not raising the Bills for other
services as per Agreement.
Charges be furnished to
audit.
Audit recommend for
immediate raising of
Bills for Other services
after review which is
already due and confirm
the same to audit for
verification.
Non-billing of other
Service charges as per
agreements is loss to
corporation.
communication on this matter.
-
b) Implementation Timeline:
As early as Possible
c)Implementation responsibility:
Internal Audit Department ,Duliajan Page 17
Sl.
No.
Observations Risk Recommendations Management Comments /Implementation Timeline &Responsibility
GM(F&A)
7 Billing of shortfall in MGQ of Condensate & Gas :
Audit observed “Condensate agreement requires Buyer to uplift 80% of
the monthly allotted quantity of the condensate, the payment of which
will have to made whether uplifted or not except under force majeure
clause & during plant maintenance of the LPG Plant.The billing in respect
of MGQ will be made on monthly basis& same will be paid by purchaser
within 15 days from the date of billing .Delay in settlement will attract
interest @1% above SBI cash credit rate .”
However on scrutiny of detailed Sales of Condensate to the Parties in the
Qtr 1 2014-2015 , it was found Condensate sales are done to following
three Customers – Custo
mer Month
Lifted
Qty(MT) MGQ (MT) Deficit (MT)
Sikkim
Org. April'14 830.2 1360 -529.8
May'14 890.57 1360 -469.43
June'14 520.07 1360 -839.93
EPC
Intn'l April'14 277.57 272 -
May'14 327.83 272 -
June'14 114.32 272 -157.68
Keep
Safe April'14 0 128 -128
May'14 0 128 -128
June'14 103.21 128 24.79
Moreover the Auditee has also not raised any supplementary Invoice for
Financial
/
Complia
nce
Audit recommend for
raising supplementary
Invoice for differential
qty ( MGQ- Actual ) &
Interest for such deficit.
a) Management comment-
It is certified from the Production
Department that there is no MGQ
billing required for the 1st Qtr.
The deficits are either because of
Force Majeure or for scheduled
shut down.
b) Implementation Timeline:
c)Implementation responsibility:
GM(F&A)
Internal Audit Department ,Duliajan Page 18
Sl.
No.
Observations Risk Recommendations Management Comments /Implementation Timeline &Responsibility
differential qty ( MGQ- Actual ) & Interest for such deficit.
In respect of Natural Gas , it was observed the Billing was done as per
agreed conditions of Agreement .
8 Review of Old Sticky Debtors.:
It is observed that M/s APGCL is not making payments towards sale of Gas
since Oct’2013 .The total combined (for APGCL & ASEB ) outstanding dues of
M/s APGCL including dues of ASEB amounts to 207 Crore upto July’2014
Agewise Anlaysis of Outstanding above 1crore is enclosed (Annexure-3)
.However summary of ageing is furnished below :
(in Cr.) Year Amount upto 2010-11 11 * 2011-12 40 2013-14 316 *Includes old uploading balance of 0.8 cr. Since 2005
Financial Vigorous follow up
should be made for
realisation of dues.
Old Outstanding beyond
2013 should be
reconciled immediately
under intimation to
audit. Outstanding
should be recovered
immediately along with
interest.
a) Management comment-
Continuous follow ups and
meeting (at Corporate level also)
are going on for recovering these
outstanding.
The shown facts & figures are not
the actual/correct , please refer
to the explanation provided
earlier in this regard. Moreover,
no balance is lying un-reconciled
for more than 3 months. There
are some old outstanding and
those are because of some
disputes. Continuous efforts are
going on for settlement of those
disputes. Settling the earlier dues
is a continuous process.
b) Implementation Timeline:
As early as Possible
c)Implementation responsibility:
GM(F&A)
Internal Audit Department ,Duliajan Page 19
List of delay in Raising Invoices Annexure-1
BusA Customer Inv. ref. Type Bill.Do Entry Date Pstng Date Doc. Date Net due dt
Amt in
loc.cur.(Rs)
AS01 100000 104548 RV 104548 21.04.2014 07.04.2014 07.04.2014 25.04.2014 2,575,253.29
AS01 100000 104549 RV 104549 21.04.2014 07.04.2014 07.04.2014 25.04.2014 246,583,149.36
AS01 100000 104562 RV 104562 13.05.2014 30.04.2014 30.04.2014 18.05.2014 5,280,667.26
AS01 100000 104563 RV 104563 13.05.2014 30.04.2014 30.04.2014 18.05.2014 228,194,237.08
AS01 100000 104567 RV 104567 19.05.2014 30.04.2014 30.04.2014 25.04.2014 -87,656.72
AS01 100000 104568 RV 104568 19.05.2014 30.04.2014 30.04.2014 30.04.2014 -192,823.21
AS01 100000 104569 RV 104569 19.05.2014 30.04.2014 30.04.2014 30.04.2014 -140,250.93
AS01 100000 104570 RV 104570 19.05.2014 30.04.2014 30.04.2014 25.04.2014 -8,393,942.28
AS01 100000 104571 RV 104571 19.05.2014 30.04.2014 30.04.2014 30.04.2014 -9,886,362.82
AS01 100000 104572 RV 104572 19.05.2014 30.04.2014 30.04.2014 30.04.2014 -7,767,796.92
AS01 100000 104635 RV 104635 20.06.2014 07.06.2014 07.06.2014 25.06.2014 1,703,615.73
AS01 100000 104636 RV 104636 20.06.2014 07.06.2014 07.06.2014 25.06.2014 234,038,767.76
AS01 100000 104669 RV 104669 19.07.2014 30.06.2014 30.06.2014 02.07.2014 149,664.77
AS01 100000 104670 RV 104670 19.07.2014 30.06.2014 30.06.2014 11.07.2014 197,233.64
AS01 100000 104671 RV 104671 19.07.2014 30.06.2014 30.06.2014 25.06.2014 14,346,331.44
AS01 100000 104672 RV 104672 19.07.2014 30.06.2014 30.06.2014 02.07.2014 15,367,986.45
AS01 100000 104673 RV 104673 19.07.2014 30.06.2014 30.06.2014 11.07.2014 15,044,701.97
AS01 100001 104550 RV 104550 21.04.2014 07.04.2014 07.04.2014 25.04.2014 520,591,300.61
AS01 100001 104555 RV 104555 26.04.2014 15.04.2014 15.04.2014 02.05.2014 992,668,999.35
AS01 100001 104564 RV 104564 13.05.2014 30.04.2014 30.04.2014 18.05.2014 1,074,761,888.77
AS01 100001 104573 RV 104573 19.05.2014 30.04.2014 30.04.2014 25.04.2014 -13,952,422.88
AS01 100001 104574 RV 104574 19.05.2014 30.04.2014 30.04.2014 30.04.2014 -26,605,040.61
AS01 100001 104575 RV 104575 19.05.2014 30.04.2014 30.04.2014 30.04.2014 -28,992,791.07
Internal Audit Department ,Duliajan Page 20
AS01 100001 104602 RV 104602 22.05.2014 07.05.2014 07.05.2014 25.05.2014 920,580,585.31
AS01 100001 104617 RV 104617 06.06.2014 31.05.2014 31.05.2014 18.06.2014 1,218,443,326.24
AS01 100001 104626 RV 104626 19.06.2014 31.05.2014 31.05.2014 25.05.2014 -4,269,289.43
AS01 100001 104627 RV 104627 19.06.2014 31.05.2014 31.05.2014 31.05.2014 -3,809,554.27
AS01 100001 104628 RV 104628 19.06.2014 31.05.2014 31.05.2014 31.05.2014 -3,770,244.25
AS01 100001 104637 RV 104637 20.06.2014 07.06.2014 07.06.2014 25.06.2014 907,648,388.01
AS01 100001 104674 RV 104674 19.07.2014 30.06.2014 30.06.2014 25.06.2014 51,025,725.86
AS01 100001 104675 RV 104675 19.07.2014 30.06.2014 30.06.2014 02.07.2014 57,990,803.48
AS01 100001 104676 RV 104676 19.07.2014 30.06.2014 30.06.2014 11.07.2014 44,258,977.99
AS01 100002 104551 RV 104551 21.04.2014 07.04.2014 07.04.2014 25.04.2014 363,377,919.04
AS01 100002 104565 RV 104565 13.05.2014 30.04.2014 30.04.2014 18.05.2014 285,699,526.03
AS01 100002 104576 RV 104576 19.05.2014 30.04.2014 30.04.2014 25.04.2014 -9,634,980.24
AS01 100002 104577 RV 104577 19.05.2014 30.04.2014 30.04.2014 30.04.2014 -10,038,764.61
AS01 100002 104578 RV 104578 19.05.2014 30.04.2014 30.04.2014 30.04.2014 -8,820,963.89
AS01 100002 104603 RV 104603 22.05.2014 07.05.2014 07.05.2014 25.05.2014 282,710,525.31
AS01 100002 104629 RV 104629 19.06.2014 31.05.2014 31.05.2014 25.05.2014 -1,296,607.45
AS01 100002 104630 RV 104630 19.06.2014 31.05.2014 31.05.2014 31.05.2014 -1,645,250.32
AS01 100002 104631 RV 104631 19.06.2014 31.05.2014 31.05.2014 31.05.2014 -1,507,137.75
AS01 100002 104677 RV 104677 19.07.2014 30.06.2014 30.06.2014 25.06.2014 15,425,858.88
AS01 100002 104678 RV 104678 19.07.2014 30.06.2014 30.06.2014 02.07.2014 19,004,443.56
AS01 100002 104679 RV 104679 19.07.2014 30.06.2014 30.06.2014 11.07.2014 18,142,645.16
PL01 100004 402400 RV 402400 21.04.2014 07.04.2014 07.04.2014 25.04.2014 4,641,867.24
PL01 100004 402416 RV 402416 22.05.2014 07.05.2014 07.05.2014 25.05.2014 4,070,951.81
PL01 100004 402445 RV 402445 20.06.2014 07.06.2014 07.06.2014 25.06.2014 3,712,982.70
AS01 100006 704437 RV 704437 09.07.2014 30.06.2014 30.06.2014 29.06.2014 8,773,692.09
AS01 100006 704438 RV 704438 09.07.2014 30.06.2014 30.06.2014 29.06.2014 364,924.59
AS01 100006 704439 RV 704439 09.07.2014 30.06.2014 30.06.2014 29.06.2014 1,431,076.80
AS01 100008 903596 RV 903596 15.07.2014 31.05.2014 31.05.2014 31.05.2014 22,217.70
AS01 100008 903627 RV 903627 23.07.2014 30.06.2014 30.06.2014 30.06.2014 26,221.35
AS01 100009 903597 RV 903597 15.07.2014 31.05.2014 31.05.2014 31.05.2014 44,826.00
Internal Audit Department ,Duliajan Page 21
AS01 100009 903628 RV 903628 23.07.2014 30.06.2014 30.06.2014 30.06.2014 60,636.00
AS01 100010 903519 RV 903519 22.04.2014 31.03.2014 31.03.2014 31.03.2014 10,583.40
AS01 100010 903598 RV 903598 15.07.2014 31.05.2014 31.05.2014 31.05.2014 13,029.30
AS01 100010 903629 RV 903629 23.07.2014 30.06.2014 30.06.2014 30.06.2014 15,786.75
AS01 100011 903548 RV 903548 30.05.2014 30.04.2014 30.04.2014 30.04.2014 6,398.40
AS01 100011 903626 RV 903626 15.07.2014 31.05.2014 31.05.2014 31.05.2014 6,119.40
AS01 100011 903657 RV 903657 24.07.2014 30.06.2014 30.06.2014 30.06.2014 4,673.25
AS01 100012 903599 RV 903599 15.07.2014 31.05.2014 31.05.2014 31.05.2014 32.55
AS01 100012 903630 RV 903630 23.07.2014 30.06.2014 30.06.2014 30.06.2014 32.55
AS01 100015 903601 RV 903601 15.07.2014 31.05.2014 31.05.2014 31.05.2014 96,906.00
AS01 100015 903632 RV 903632 23.07.2014 30.06.2014 30.06.2014 30.06.2014 102,486.00
AS01 100106 903619 RV 903619 15.07.2014 31.05.2014 31.05.2014 31.05.2014 7,757.70
AS01 100106 903650 RV 903650 23.07.2014 30.06.2014 30.06.2014 30.06.2014 7,864.65
AS01 100106 903706 RV 903706 12.08.2014 31.07.2014 31.07.2014 31.07.2014 8,743.50
AS01 100130 903620 RV 903620 15.07.2014 31.05.2014 31.05.2014 31.05.2014 7,966.95
AS01 100130 903651 RV 903651 23.07.2014 30.06.2014 30.06.2014 30.06.2014 8,278.50
AS01 100130 903707 RV 903707 12.08.2014 31.07.2014 31.07.2014 31.07.2014 9,599.10
AS01 100330 903625 RV 903625 15.07.2014 31.05.2014 31.05.2014 31.05.2014 11,625.00
AS01 100330 903656 RV 903656 23.07.2014 30.06.2014 30.06.2014 30.06.2014 11,625.00
Internal Audit Department ,Duliajan Page 22
Annexure2
List of Outstanding beyond scheduled collection due date for which Interest is not charged as on 31.07.2014
Customer Code Inv. ref. Ty Bill.Do Entry Date Postng Date Doc. Date
Net due dt(As per
Agreement/system)
Amt in
loc.cur.(Rs.)
Date of
Collection
Management
comment
BVFCL 100035 202903 RV 202903 13.06.2014 31.05.2014 31.05.2014 30.06.2014 282,229,841.68
03.07.2014 Delay is for 3 days,
which is negligible
BVFCL 100035 202933 RV 202933 14.07.2014 30.06.2014 30.06.2014 30.07.2014 273,471,392.64
01.08.2014 Delay is for 1 day,
which is negligible
Total
55.57 crores
Assam Gas
Co. 100041 202909 RV 202909 13.06.2014 31.05.2014 31.05.2014 15.06.2014 1,635,525.19 03.07.2014
The due date for
payment is 30th
of the
month and we have
received the cheque
from AGCL on the due
date itself (i.e.
30.06.14 is this case)
but deposited /
credited into our Bank
A/C on 03.07.2014.
So, it should be
ignored.
Assam Gas
Co. 100041 202910 RV 202910 13.06.2014 31.05.2014 31.05.2014 15.06.2014 534,031.58 03.07.2014
Assam Gas
Co. 100041 202911 RV 202911 13.06.2014 31.05.2014 31.05.2014 15.06.2014 226,079.47 03.07.2014
Assam Gas
Co. 100041 202912 RV 202912 13.06.2014 31.05.2014 31.05.2014 15.06.2014 1,148,751.09 03.07.2014
Assam Gas
Co. 100041 202913 RV 202913 13.06.2014 31.05.2014 31.05.2014 15.06.2014 701,667.10 03.07.2014
Assam Gas
Co. 100041 202914 RV 202914 13.06.2014 31.05.2014 31.05.2014 15.06.2014 6,625,674.83 03.07.2014
Assam Gas
Co. 100041 202915 RV 202915 13.06.2014 31.05.2014 31.05.2014 15.06.2014 7,127,366.90 03.07.2014
Assam Gas
Co. 100041 202916 RV 202916 13.06.2014 31.05.2014 31.05.2014 15.06.2014 17,378,415.09 03.07.2014
Assam Gas
Co. 100041 202917 RV 202917 13.06.2014 31.05.2014 31.05.2014 15.06.2014 8,910,620.47 03.07.2014
Assam Gas
Co. 100041 202918 RV 202918 13.06.2014 31.05.2014 31.05.2014 15.06.2014 5,281,642.12 03.07.2014
Internal Audit Department ,Duliajan Page 23
Assam Gas
Co. 100041 202919 RV 202919 13.06.2014 31.05.2014 31.05.2014 15.06.2014 9,798,549.95 03.07.2014
Assam Gas
Co.
100041 202920 RV 202920 13.06.2014 31.05.2014 31.05.2014 15.06.2014 8,924,445.82 03.07.2014
Assam Gas
Co. 100041 202936 RV 202936 14.07.2014 30.06.2014 30.06.2014 15.07.2014 1,518,132.31 31.07.2014
As stated above, the
due date should be
30.07.14
Here we received the
payment on
31.07.2014.
So, it should be
ignored.
Assam Gas
Co. 100041 202937 RV 202937 14.07.2014 30.06.2014 30.06.2014 15.07.2014 9,786,766.08 31.07.2014
Assam Gas
Co. 100041 202938 RV 202938 14.07.2014 30.06.2014 30.06.2014 15.07.2014 16,150,621.21 31.07.2014
Assam Gas
Co. 100041 202939 RV 202939 14.07.2014 30.06.2014 30.06.2014 15.07.2014 1,606,691.15 31.07.2014
Assam Gas
Co. 100041 202940 RV 202940 14.07.2014 30.06.2014 30.06.2014 15.07.2014 521,319.22 31.07.2014
Assam Gas
Co. 100041 202941 RV 202941 14.07.2014 30.06.2014 30.06.2014 15.07.2014 906,602.86 31.07.2014
Assam Gas
Co. 100041 202942 RV 202942 14.07.2014 30.06.2014 30.06.2014 15.07.2014 799,957.54 31.07.2014
Assam Gas
Co. 100041 202943 RV 202943 14.07.2014 30.06.2014 30.06.2014 15.07.2014 27,350,091.35 31.07.2014
Assam Gas
Co. 100041 202944 RV 202944 14.07.2014 30.06.2014 30.06.2014 15.07.2014 12,460,943.05 31.07.2014
Assam Gas
Co. 100041 202945 RV 202945 14.07.2014 30.06.2014 30.06.2014 15.07.2014 22,040,684.13 31.07.2014
Assam Gas
Co. 100041 202946 RV 202946 14.07.2014 30.06.2014 30.06.2014 15.07.2014 7,715,527.40 31.07.2014
Assam Gas
Co. 100041 202947 RV 202947 14.07.2014 30.06.2014 30.06.2014 15.07.2014 11,728,302.80 31.07.2014
Assam Gas
Co. 100041 V RV 202959 15.07.2014 30.06.2014 30.06.2014 15.07.2014 -1,606,691.15
Assam Gas 100041 202960 RV 202960 15.07.2014 30.06.2014 30.06.2014 15.07.2014 1,607,731.48 31.07.2014
Total
18.09 Crores
Internal Audit Department ,Duliajan Page 24
NRL -NG 100255 202929 RV 202929 13.06.2014 31.05.2014 31.05.2014 31.05.2014 199,628,425.90 12.07.2014 As per Agreement,
NRL has to pay
“within 30 days from
the date of Invoice”.
So here no interest is
chargeable.
NRL -NG 100255 202957 RV 202957 14.07.2014 30.06.2014 30.06.2014 30.06.2014 209,218,585.95 12.08.2014
Total
40.90Crores
Tingri Gas 100044 202951 RV 202951 14.07.2014 30.06.2014 30.06.2014 15.07.2014 6,625,980.53
Collection
Entry not
done in
system
The due date should
be 30.07.2014 and we
have received the
payments accordingly.
Tingri Gas 100044 202951 RV 202951 14.07.2014 30.06.2014 30.06.2014 15.07.2014 11,608,393.67
Collection
entry not
done in
system
Total
1.8 Crores
Customer Code Inv. ref. Ty Bill.Do Entry Date Pstng Date Doc. Date Net due dt Amt in loc.cur.
Date of
Collection
Management
comment
APGCL 100045 202731 RV 202731 14.11.2013 31.10.2013 31.10.2013 27.11.2013 111,288,722.99
Part
Payment on
30.05.2014
Continuous follow
ups and meeting (at
Corporate level
also) are going on
for recovering
these outstanding.
APGCL 100045 202760 RV 202760 14.12.2013 30.11.2013 30.11.2013 27.12.2013 101,538,880.14
Payment on
30.06.2014
APGCL 100045 202791 RV 202791 10.01.2014 31.12.2013 31.12.2013 27.01.2014 106,560,357.20 Not yet recd
APGCL 100045 202810 RV 202810 13.02.2014 31.01.2014 31.01.2014 27.02.2014 133,379,355.63
Not yet
recd
APGCL 100045 202832 RV 202832 14.03.2014 28.02.2014 28.02.2014 27.03.2014 113,917,256.48 Not yet recd
APGCL 100045 202859 RV 202859 11.04.2014 31.03.2014 31.03.2014 27.04.2014 119,367,684.59 Not yet recd
APGCL 100045 202892 RV 202892 12.05.2014 30.04.2014 30.04.2014 27.05.2014 128,262,968.34 Not yet recd
APGCL 100045 202925 RV 202925 13.06.2014 31.05.2014 31.05.2014 27.06.2014 122,309,472.31 Not yet recd
APGCL 100045 202953 RV 202953 14.07.2014 30.06.2014 30.06.2014 27.07.2014 101,392,794.31 Not yet recd
Total
103 Crores
ASEB(NTPS) 100046 202761 RV 202761 14.12.2013 30.11.2013 30.11.2013 27.12.2013 99,090,521.73 Not Yet Recd
Internal Audit Department ,Duliajan Page 25
ASEB(NTPS) 100046 202792 RV 202792 10.01.2014 31.12.2013 31.12.2013 27.01.2014 123,698,706.77 Not Yet Recd
ASEB(NTPS) 100046 202811 RV 202811 13.02.2014 31.01.2014 31.01.2014 27.02.2014 127,830,933.04
Part
Payment
ASEB(NTPS) 100046 202833 RV 202833 14.03.2014 28.02.2014 28.02.2014 27.03.2014 147,575,243.98
Part
Payment
ASEB(NTPS) 100046 202860 RV 202860 11.04.2014 31.03.2014 31.03.2014 27.04.2014 114,070,765.03 Not Yet Recd
ASEB(NTPS) 100046 202893 RV 202893 12.05.2014 30.04.2014 30.04.2014 27.05.2014 146,715,105.66 Not Yet Recd
ASEB(NTPS) 100046 202926 RV 202926 13.06.2014 31.05.2014 31.05.2014 27.06.2014 150,127,313.67 Not Yet Recd
ASEB(NTPS) 100046 202954 RV 202954 14.07.2014 30.06.2014 30.06.2014 27.07.2014 131,484,408.57 Not Yet Recd
Total
104 Crores
NE
Thermion 100125 202381 RV 202381 11.10.2012 30.09.2012 30.09.2012 30.09.2012 5,736,658.32
_
Continuous follow
ups and meeting (at
Corporate level
also) are going on
for recovering
these outstanding.
NE
Thermion 100125 202384 RV 202384 16.10.2012 30.09.2012 30.09.2012 30.09.2012 512,047.64
_
NE
Thermion 100125 202408 RV 202408 15.11.2012 31.10.2012 31.10.2012 31.10.2012 6,255,462.51
_
NE
Thermion 100125 202411 RV 202411 15.11.2012 31.10.2012 31.10.2012 31.10.2012 211,524.55
_
NE
Thermion 100125 202435 RV 202435 12.12.2012 30.11.2012 30.11.2012 30.11.2012 5,049,326.12
_
NE
Thermion 100125 202438 RV 202438 13.12.2012 30.11.2012 30.11.2012 30.11.2012 826,436.62
_
NE
Thermion 100125 202462 RV 202462 11.01.2013 31.12.2012 31.12.2012 31.12.2012 5,543,902.37
_
NE
Thermion 100125 202467 RV 202467 11.01.2013 31.12.2012 31.12.2012 31.12.2012 868,872.14
_
NE
Thermion 100125 202483 RV 202483 12.02.2013 31.01.2013 31.01.2013 31.01.2013 4,292,393.24
_
NE
Thermion 100125 202489 RV 202489 13.02.2013 31.01.2013 31.01.2013 31.01.2013 1,913,728.64
_
NE
Thermion 100125 202507 RV 202507 18.03.2013 28.02.2013 28.02.2013 28.02.2013 5,310,275.97
_
Internal Audit Department ,Duliajan Page 26
NE
Thermion 100125 202511 RV 202511 18.03.2013 28.02.2013 28.02.2013 28.02.2013 442,384.34
_
NE
Thermion 100125 202535 RV 202535 11.04.2013 31.03.2013 31.03.2013 31.03.2013 6,619,386.67
_
NE
Thermion 100125 202565 RV 202565 15.05.2013 30.04.2013 30.04.2013 30.04.2013 5,673,820.56
_
NE
Thermion 100125 202571 RV 202571 16.05.2013 30.04.2013 30.04.2013 30.04.2013 452,523.87
_
NE
Thermion 100125 202595 RV 202595 14.06.2013 31.05.2013 31.05.2013 31.05.2013 5,875,712.85
_
NE
Thermion 100125 202599 RV 202599 14.06.2013 31.05.2013 31.05.2013 31.05.2013 476,695.68
_
NE
Thermion 100125 202621 RV 202621 12.07.2013 30.06.2013 30.06.2013 30.06.2013 4,926,137.61
_
NE
Thermion 100125 202624 RV 202624 12.07.2013 30.06.2013 30.06.2013 30.06.2013 1,206,899.43
_
Continuous follow
ups and meeting (at
Corporate level
also) are going on
for recovering
these outstanding.
NE
Thermion 100125 202648 RV 202648 12.08.2013 31.07.2013 31.07.2013 31.07.2013 5,081,622.60
_
NE
Thermion 100125 202651 RV 202651 12.08.2013 31.07.2013 31.07.2013 31.07.2013 1,852,210.29
_
NE
Thermion 100125 202680 RV 202680 13.09.2013 31.08.2013 31.08.2013 31.08.2013 4,760,699.07
_
NE
Thermion 100125 202683 RV 202683 13.09.2013 31.08.2013 31.08.2013 31.08.2013 1,921,651.42
_
NE
Thermion 100125 202706 RV 202706 11.10.2013 30.09.2013 30.09.2013 30.09.2013 5,799,914.78
_
NE
Thermion 100125 202709 RV 202709 11.10.2013 30.09.2013 30.09.2013 30.09.2013 1,298,652.20
_
NE
Thermion 100125 202733 RV 202733 14.11.2013 31.10.2013 31.10.2013 31.10.2013 7,255,040.12
_
NE
Thermion 100125 202736 RV 202736 14.11.2013 31.10.2013 31.10.2013 31.10.2013 297,972.75
_
NE
Thermion 100125 202793 RV 202793 10.01.2014 31.12.2013 31.12.2013 31.12.2013 4,404,257.82
_
Internal Audit Department ,Duliajan Page 27
NE
Thermion 100125 202796 RV 202796 10.01.2014 31.12.2013 31.12.2013 31.12.2013 408,261.84
_
NE
Thermion 100125 202812 RV 202812 13.02.2014 31.01.2014 31.01.2014 31.01.2014 4,800,415.91
_
NE
Thermion 100125 202816 RV 202816 13.02.2014 31.01.2014 31.01.2014 31.01.2014 77,553.38
_
NE
Thermion 100125 202834 RV 202834 14.03.2014 28.02.2014 28.02.2014 28.02.2014 2,997,552.11
_
NE
Thermion 100125 202861 RV 202861 11.04.2014 31.03.2014 31.03.2014 31.03.2014 3,609,128.17
_
NE
Thermion 100125 202894 RV 202894 12.05.2014 30.04.2014 30.04.2014 30.04.2014 4,772,731.34
_
NE
Thermion 100125 202899 RV 202899 16.05.2014 30.04.2014 30.04.2014 30.04.2014 3,189.05
_
NE
Thermion 100125 202927 RV 202927 13.06.2014 31.05.2014 31.05.2014 31.05.2014 4,222,727.95
_
NE
Thermion 100125 202931 RV 202931 13.06.2014 31.05.2014 31.05.2014 31.05.2014 539,006.22
_ Continuous follow
ups and meeting (at
Corporate level
also) are going on
for recovering
these outstanding.
NE
Thermion 100125 202955 RV 202955 14.07.2014 30.06.2014 30.06.2014 30.06.2014 5,017,676.90
_
_
Total
12 Crores
Internal Audit Department ,Duliajan Page 28
Annexure-3
Statement of Agewise Analysis as on 31.07.2014
(Download 20.08.2014 )
Customer 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 Total
Outstan
ding
Amount
(in Lacs)
(rounde
d off)
Account
Confirmati
on Last
Obtained Remarks
IOCL Digboi (100000) Crude
Oil 13300 31.03.2014
Differen
ce
found
:1.63
crore
Less as
per IOCL
Books
AB(Un cleared Accounting
Document ) -3190 -3190
BR(Un cleared Bank Receipt) -1934 -33434 -35368
DR (Un cleared Customer
Invoice) 27 27
IB (Initial Upload) 81 81
RV (Sales Invoice) 4366 47386 51751
NRL(100001) Crude Oil 43600
AB(Un cleared Accounting
Document ) 1 1
Internal Audit Department ,Duliajan Page 29
BR(Un cleared Bank Receipt) -7977
-
12484
9 -132826
RV (Sales Invoice) 11097
16533
6 176433
IOCL Guwahati (100002)
Crude Oil 15400 30.06.2014
Found
OK
AB(Un cleared Accounting
Document ) 144 926 1069
BR(Un cleared Bank Receipt) -3405 -41257 -44662
RV (Sales Invoice) -445 59396 58951
IOCL Bongaigaon (100003)
Crude Oil 2970 30.06.2014
Found
OK
AB(Un cleared Accounting
Document ) -2 -2
BR(Un cleared Bank Receipt) -1999 -1999
DR (Un cleared Customer
Invoice) 1 1
RV (Sales Invoice) 4967 4967
Chief Engr(P) , I/C Tech Cell
,Nazira (100004) TPT 723
AB(Un cleared Accounting
Document ) 139 266 404
BR(Un cleared Bank Receipt) -11 -1209 -1221
DA (Un cleared Customer
Document) -103 -28 -131
DG (un cleared Customer
Credit Memo ) -51 -51
DR (Un cleared Customer
Invoice) -99 -67 -252 -62 -480
RV (Sales Invoice) 1 421 1003 777 2203
IOCL Digboi(100006) LPG 1244
BR(Un cleared Bank Receipt) -106 -106
DR (Un cleared Customer
Invoice) 1 1
RV (Sales Invoice) 1349 1349
Internal Audit Department ,Duliajan Page 30
Brahmaputra Valley Ferti.
Corp Namrup (100035) NG 5645
BR(Un cleared Bank Receipt) -10330 -10330
RV (Sales Invoice) 4587 11388 15974
Assam Petrochemicals Ltd
(Parbatpur)100036 NG 625
BR(Un cleared Bank Receipt) -911 -911
RV (Sales Invoice) 293 1244 1537
IOCL Digboi (100038) NG 166 31.03.2014
Difffern
ce
found:0.
24 Cr.
Less in
IOCL
Book
AB(Un cleared Accounting
Document ) 24 24
BR(Un cleared Bank Receipt) -3098 -3098
RV (Sales Invoice) 1534 3200 4734
NEEPCO Bakulani (100040)
NG 2894 31.03.2014
Found
OK
BR(Un cleared Bank Receipt) -11399 -11399
RV (Sales Invoice) 2776 11516 14293
Assam Gas Co. Duliajan
(100041) NG 1474 31.03.2014
No
confirm
ation
only
Sent
AB(Un cleared Accounting
Document ) 1 1
BR(Un cleared Bank Receipt) -297 -297
CJ (Un cleared Cash Journal) -2351 -2351
RV (Sales Invoice) 377 3744 4121
Assam Power Gen, Corp 11049
Internal Audit Department ,Duliajan Page 31
Ltd.Lakwah(100045) NG
BR(Un cleared Bank Receipt) -2618 -3287 -2128 -8034
CJ (Un cleared Cash Journal) -541 -541
DR (Un cleared Customer
Invoice) 84 -17 83 150
RV (Sales Invoice) 64 369 160 6699 787 6861 4534 19475
Assam State Elec. Board
Namrup(100046) NG 10411
BR(Un cleared Bank Receipt) -1166 -2446 -3612
RV (Sales Invoice) 8279 5743 14022
GAIL Ramgarh (100076) NG 911
BR(Un cleared Bank Receipt) 1 75 77
DA (Un cleared Customer
Document) 9 9
DR (Un cleared Customer
Invoice) 3 3
RV (Sales Invoice) 63 105 655 822
NRL Golaghat (100200) NG 1881
AB(Un cleared Accounting
Document ) 1198 1198
BR(Un cleared Bank Receipt) -5517 -5517
DR (Un cleared Customer
Invoice) 324 324
RV (Sales Invoice) 5876 5876
Duliajan Numaligarh Pipeline
Ltd,Duliajan (100250) NG 134
BR(Un cleared Bank Receipt) -186 -186
RV (Sales Invoice) 102 217 320
Numaligarh Refinery
Ltd(100255) NG 4079
BR(Un cleared Bank Receipt) -7126 -7126
RV (Sales Invoice) 3519 7686 11205
Tingri Gas Gri Hoogrijan 389
Internal Audit Department ,Duliajan Page 32
(100044) NG
BR(Un cleared Bank Receipt) -324 -324
RV (Sales Invoice) 56 657 713
NE Thermion Pvt Ltd
Dibrugarh (100125) NG 1277
BR(Un cleared Bank Receipt) -234 -279 -113 -627
CJ (Un cleared Cash Journal) -146 -172 -93 -411
DR (Un cleared Customer
Invoice) -22 3 -19
RV (Sales Invoice) 200 541 760 632 200 2333
Total Outstanding Yearwise
Breakup 108 75 105 148 508 222.5 4089 (1702) 31630 84449 119632 119600
Internal Audit Department ,Duliajan Page 33
Statement of VAT
Demand
(Yearwise)
Annexure-4
(Rs. In Crore)
Description 2009-2010 2010-2011 2011-2012 2012-2013 Total
Total Tax Assessed 389.96 479.71 850.34 891.44 2611.45
Tax Paid/Considered 334.70 390.40 516.50 453.60 1695.2
Tax Due 55.26 89.31 333.84 437.84 916.25
Interest Due 46.41 58.94 165.25 137.92 408.52
Total Due 101.67 148.25 499.09 575.76 1324.77
Internal Audit Department ,Duliajan Page 34
Annexure-5
Year wise C form Liability of Condensate (Net Sales)
(In Crore)
Year & Customer I II III IV Grand Total Total
2011-2012 60.79
EPC International Pvt. Ltd. (100185) 4.73 4.73
Sikkim Organics(100180) 14.10 12.03 13.87 16.05 56.06
2012-2013 88.95
KEEP SAFE TRADERS PVT. LTD (100300) 2.33 2.33
Sikkim Organics(100180) 22.71 22.80 17.48 23.64 86.62
2013-2014 67.78
KEEP SAFE TRADERS PVT. LTD (100300)
Sikkim Organics(100180) 18.38 7.69 20.67 21.04 67.78
Grand Total Till 2013-2014 55.19 44.85 56.75 60.73 217.53 217.53
2014-2015 21.02
EPC International Pvt. Ltd. (100185) 4.94 4.94
KEEP SAFE TRADERS PVT. LTD (100300) 0.71 0.71
Internal Audit Department ,Duliajan Page 35
Sikkim Organics(100180) 15.37 15.37
Grand Total 21.02 238.55