Vendor Master
- Checking of Duplicate Vendors in Master File. The detection involves complicated process of matching similar sounding names, address and zip code combination etc
- Missing vital Information of vendors in the database such as PAN, Sales Tax Numbers, Addresses etc.
- Vendors are associated with certain accounts of the organisation, this check is to trace the vendors who are not associated to any accounting heads.
- Vendors have nominated payee for their payments, this check helps to identify how payee associated to multiple vendors.
- Vender marked for deletion but still have outstanding debit/ credit balances
- identify the list of duplicate invoices whether from same or multiple vendors
- PAN number associated to multiple vendor
Purchase Order
- Missing/Duplicate Purchase Order number issued.
- List the open Purchase Orders.
- Verification of issuance of split Purchase Orders for same vendor.
- Favoured Vendor analysis.
- Issuance of backdated Purchase Orders by more than 30 days.
Goods Receipt
- Missing/Duplicate Goods Receipt document.
- Goods Receipts without Purchase Order reference number.
- Verification of Purchase Order date later to Goods Receipt date.
- Open Goods Receipt list.
- Verification of vendors for delayed delivery and generating trend analysis alongwith payments made to such vendors.
- Analysis of Vendors for defect ratio and trend in defects.
- Goods Receipt quantity does not match with quantity stated in Purchase Order.
Purchase Invoice
- Missing/Duplicate Purchase Invoice document.
- Issuance of Purchase Invoice without Goods Receipt reference number.
- Purchase Invoice value does not match with Purchase Order and Goods Receipt document.
- Open PI list
Payment voucher
- Missing Payment Voucher (PV) document
- Purcahse Voucher issued without Purchase Invoice reference number.
- Purchase Voucher value does not match with Purchase Invoice document.
- Duplicate payment to the vendor with reference to the same Purchase Order, Goods Receipt and Purchase Voucher document.
- Same cheque issued to multiple vendors and duplicate payment recorded for same vendor.
- Blank cheques recorded in Payment Voucher.
- Different vendor names in case of Purchase Voucher and Purchase Invoice
- Purchase Voucher booked before due date.
- Split payments to vendors without appropriate authorization
Other
- Vendor wise summary of Purchase Orders raised, Purchase Invoice and Purchase Voucher booked.
- Analysis of Vendor / Item wise Purcahse Order raised.
- Vendor wise unit price variance for same product.
- Product wise Purcahse Orders booked and comparison of price (variance between high and low price) for various products and periods.
|
|