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

D

dalipsinghbisht

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 me… I 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.geocities.com/dalipsinghbisht/Auditing_Sample.zip

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
 
S

starguy

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top