Hi,

I am looking for a method of Receipts Books Auditing So Please give
your sugesstion as I am in a very big difficulty. This process taking
much time. I need your help So friends I need you help. Please Please
Please Help me… I am waiting for your reply…..following are the process
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 account
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 reports

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.geocities.com/dalipsinghb...ing_Sample.zip

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


Thanks in Advance


--
dalipsinghbisht
------------------------------------------------------------------------
dalipsinghbisht's Profile: http://www.excelforum.com/member.php...o&userid=32557
View this thread: http://www.excelforum.com/showthread...hreadid=523848