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
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