Check Account Fraud - Excel

Document Sample
Check Account Fraud - Excel Powered By Docstoc
					         Card Fraud Presentation

                          Workshop Handout

MIS Worksheet                  Management Information System (MIS)
Loss Analysis Worksheet        Loss Analysis Charts




Barry Smith                                                                Allan Trosclair
4546 E la Mirada Way                                                       804-334-6095
Phoenix, AZ 85044
480-598-9740
602-791-5651
                                BFS Consulting Inc.   www.fraudsolutions.us




                                                                                             Page 1
                 Suggested Minimum Data MIS File for Issuer

1. Create and maintain a file of all of your fraud cases including the following information




                 Fraud MIS File                                                                                                                                                                                      Debit

                                                                                                                                                                 Last                      Detected by                         Lookup on
                                                                                           Recovery                                       First Transaction   Transaction    Days         FALCON Y or      Fraud     Sig or   CAMS/CANS
Account Number    Customer ID     Fraud Type           Gross Fraud        Net Fraud        Amount        Recovery %     Date Of Report           Date            Date        Active             N         Location    PIN         file
        1237     65-47200          Counterfeit     $         200.00   $       200.00   $           -               0%          11/25/06            11/23/06       11/25/06            3        N         Spain                CAMS -01-16
        1378                          Lost         $         300.00   $       100.00   $        200.00            67%          12/15/06            12/13/06       12/13/06            1        Y         FL                       #N/A
        1247                       Counterfeit     $         400.00   $       200.00   $        200.00            50%          11/25/06            11/23/06       11/25/06            3        Y         NY                   CAMS -01-17
        4123                    Card Not Present   $         560.00   $        25.00   $        535.00            96%          11/25/06            11/23/06       11/25/06            3        N         CA                       #N/A




Total                                              $       1,460.00   $       525.00   $        935.00            64%




                 MIS Analysis to Watch:
                          Detection Rate
                          Recovery Rate
                          Compliance eligibility and Recovery Rate



                 CAMS/CANS File                                                                                                                                                           CAMS/CANS Alert File
2. Copy your CAMS/CANS alert data into an Excel worksheet like this one.
              Account # field must be defined as a text file to accommodate the 16 digit number                                                                                             Acct #        CAMS #
              The CAMS/CANS # must be duplicated in the second column                                                                                                                        1234        CAMS -01-14
              Create a column or file and enter formula to "lookup" account numbers in the CAMS/CANS alert file                                                                              1236        CAMS -01-15
Example of "Vlookup Command" Formula ===> =vlookup(A12,B32:C36,2,false)                                                                                                                      1237        CAMS -01-16
              A12 - is the location account number from Fraud MIS File                                                                                                                       1247        CAMS -01-17
              B32:C36 - is the table/file containing CAMS/CANS data                                                                                                                          1278        CAMS -01-18
              2 - is the number of columns to move over to obtain the data from




                                                                                        BFS Consulting Inc.                 www.fraudsolutions.us

                                                                                                                                                                                                                         Page 2
                                      Loss Analysis

                                  Total Accounts All Portfolios

                                                                 Loss Per
                       Accounts           Number of Accounts     Account         Total      Total

              Total


                                  Fraud Loss by Portfolio type
                                                                 Loss Per
                       Accounts           Number of Accounts     Account         Total
              Debit
              Credit
              Total

              Loss Per Account Target is $2.00 per account or less
              If Losses for a Portfolio Exceeds $2.00 per Account

                 Number of Accounts        Loss Per Account      US Fraud    Non-US Fraud   Total
Credit

Total

                 Number of Accounts        Loss Per Account         PIN        Signature    Total
Debit

Total


                 Number of Accounts        Loss Per Account      US Fraud    Non-US Fraud   Total
Debit Sig
Debit - PIN
Total

                                       BFS Consulting Inc.    www.fraudsolutions.us
                                                Fraud Control Check List

1. CVV/CVC for all transactions - Let Operators Restrict Accounts
2. Falcon/Advanced Authorization restrict accounts 7X24 - Measure Effectivness
3. AVS
4. Letters confirming Account take Over
5. Card Activation
6. Chargeback and Compliance Recoveries


                                                 BFS Consulting Inc.            www.fraudsolutions.us

				
DOCUMENT INFO
Description: Check Account Fraud document sample