Please please please help me....if you can..

Please please please help me....if you can..

Post by dalipsingh » Sun, 19 Mar 2006 15:11:29



Hi,

I am looking for a method of Receipts Books Auditing So Please giv
your sugesstion as I am in a very big difficulty. This process takin
much time. I need your help So friends I need you help. Please Pleas
Please Help meI am waiting for your reply.following are the proces
of Auditing



Process of Audit of Receipts Books

1) Physical delivery of receipt book from Company.

2) Receipt of Payment File & Reconciliation file from Company through
email.

3) Matching of contents of above files with receipt books.

4) Checking of receipts in receipt book one by one with date in
reconciliation file.

5) Creation of 6 extra columns in reconciliation file:-

a. Date of Payment
b. Amount
c. Name
d. Account No. as per receipt
e. Remarks
f. TAT

6) Checking account number one by one from the reconciliation file to

match availability in payment file.

7) Recording of amount, account number and name according to
receipt and date of payment from payment file (If accoun
number
matches with payment file).

8) Calculation of TAT, i.e. Date of payment Date of Collection.

9) To give remark codes according to the following table:-

Remarks
Codes Short Forms Queries
A AMsg Missing any Reciept
B ANMch Amount Not Matching
C ANMnd Amount Not Mentioned
D AOWrt Amount Over Written
E DNMch Date Not Matching
F DNMnd Date Not Mentioned
G DOWrt Date Overwritten
H NcoIS No Collector Sign
I NcstS No Customer Sign
J NNMch Name Not Matching
K NNMnd Name Not Mentioned
L NOWrt Name Over Written
M NPN No Pan Number
N OTH Others
O RCBIIT Receipt Cancelled But Entry In Tracker
P Ref. NMch Ref.no. Not Matching
Q Ref.NMnd Ref.no. Not Mentioned
R Ref.Owrt. Ref. No. Over Eritten
S WR is B Whole Receipt is Blank
T WRNMch Whole Receipt Not Matching
U WROWrt Whole Receipt Over Written
V CBNT Cash Payment But No Entry In Tracker
W 2AMT Two amount Mentioned in receipt
X SEQUENCES Receipts issued Not Serially Wise.
Y TAT If Turn-Around Time is Greater Than 2Days


10) Creation of Reports of the whole process data. Two type of report

are generated:-

i) Detailed Report
ii) Summary

Formats of the same are attached herewith.

11) Mailing of above reports to Company.
12) Handover of audited receipts book to Company.


The following link contains each sample of Payment File
Reconciliation file, Detailed Report & Summary Report for your help.
Link

http://www.yqcomputer.com/

Now I want to know how to simplify this work. Any Formula and any tip
and Trick. I am in very difficulty. Please please please help me......


Thanks in Advanc
 
 
 

Please please please help me....if you can..

Post by stargu » Sun, 19 Mar 2006 16:56:31


i'll see the method send me your file at:
also mention your question in that workbook


dalipsinghbisht Wrote:
> Please Help meI am waiting for your reply.following are the proces> > of Auditing> > > > > > > > Process of Audit of Receipts Books > > > > 1) Physical delivery of receipt book from Company.> > > > 2) Receipt of Payment File & Reconciliation file from Company through > > email.> > > > 3) Matching of contents of above files with receipt books.> > > > 4) Checking of receipts in receipt book one by one with date in > > reconciliation file.> > > > 5) Creation of 6 extra columns in reconciliation file:- > > > > a. Date of Payment> > b. Amount> > c. Name> > d. Account No. as per receipt> > e. Remarks > > f. TAT> > > > 6) Checking account number one by one from the reconciliation file to> > > > match availability in payment file.> > > > 7) Recording of amount, account number and name according to > > receipt and date of payment from payment file (If accoun> > number > > matches with payment file).> > > > 8) Calculation of TAT, i.e. Date of payment Date of Collection>
>>
> 9) To give remark codes according to the following table:>
>>
> Remarks >
> Codes Short Forms Querie>
> A AMsg Missing any Reciept>
> B ANMch Amount Not Matching>
> C ANMnd Amount Not Mentione>
> D AOWrt Amount Over Writte>
> E DNMch Date Not Matchin>
> F DNMnd Date Not Mentione>
> G DOWrt Date Overwritte>
> H NcoIS No Collector Sig>
> I NcstS No Customer Sig>
> J NNMch Name Not Matchin>
> K NNMnd Name Not Mentione>
> L NOWrt Name Over Writte>
> M NPN No Pan Numbe>
> N OTH Other>
> O RCBIIT Receipt Cancelled But Entry In Tracke>
> P Ref. NMch Ref.no. Not Matchin>
> Q Ref.NMnd Ref.no. Not Mentione>
> R Ref.Owrt. Ref. No. Over Eritte>
> S WR is B Whole Receipt is Blan>
> T WRNMch Whole Receipt Not Matchin>
> U WROWrt Whole Receipt Over Writte>
> V CBNT Cash Payment But No Entry In Tracke>
> W 2AMT Two amount Mentioned in receipt>
> X SEQUENCES Receipts issued Not Serially Wise>
> Y TAT If Turn-Around Time is Greater Than 2Day>
>>
>>
> 10) Creation of Reports of the whole process data. Two type of repor>
>>
> are generated:->
>>
> i) Detailed Repor>
> ii) Summar>
>>
> Formats of the same are attached herewith>
>>
> 11) Mailing of above reports to Company>
> 12) Handover of audited receipts book to Company>
>>
>>
> The following link contains each sample of Payment File>
> Reconciliation file, Detailed Report & Summary Report for your help>
> Lin>
>>
> http://www.yqcomputer.com/ ;
>>
> Now I want to know how to simplify this work. Any Formula and any ti>
> and Trick. I am in very difficulty. Please please please help me.....>
>>
>>
> Thanks in Advanc