Preparing CSV Files for Import
When importing CSV files into FraudFindr, you’ll most likely want to do a little clean up in the CSV file to make the process easier.
First, be sure to remove any personally identifying information from the top of the file such as bank routing or account numbers or the account owners information. Then remove any starting or ending balance transactions of $0.00, as these will be treated as transactions in FraudFindr and cause the Summary and Analysis data to be incorrect.
When you upload a CSV file, we’ll automatically detect all the columns in your file and use the first row of data as the field labels. Then, you’ll be asked to map each column in your file to a field in FraudFindr.
The far left "Map This Column" lists the columns we detected in your CSV file. The "To This Field" column lists the available columns in FraudFindr.
For example, if we detect a column named “Amount” in your CSV file, you can map that field to the “Amount” field in FraudFindr. If you have two columns in your file called “Debit” and “Credit” which contain dollar amounts, you can map both of those fields to the “Amount” field in FraudFindr.
When you select fields to map in the “Map Transaction Data'' screen in FraudFindr, you’ll be able to instantly see sample data on the right. If the data isn’t correct, select a different field. You can clear the data by selecting “None” in the dropdown list.
Note: Not all fields in your CSV file need to be mapped to fields in FraudFindr, but we strongly encourage you to map the Amount, Date, Type, and Description fields to minimize your effort after importing the transaction data.
If you aren’t able to map the fields correctly, click “Cancel” and modify your CSV file data as needed. For example, merge two “Debit” and “Credit” columns into one “Amount” column, being careful not to change the Amount values.
The available fields in FraudFindr are:
Date
Payee/Payor (Whole Foods, Home Depot, Sunoco, etc)
Type (Debit or Credit)
Method (Check, ATM, EFT, ACH, etc)
Description
Category (Automotive, Bank Fees, Food & Beverage, etc)
Amount
Attribution (Victim, Suspect, Unknown)
Related Articles
Exporting to CSV
To export transactions to a csv spreadsheet, simply navigate to the transactions tab and click on the ellipsis in the right-hand corner, then select "Export transactions to csv".Adding Bank Accounts & Transactions
To add bank accounts and transactions to a case, click “Manage Cases” and select the case you’d like to manage by clicking “Manage Case”. From there, click the “Accounts” tab. Here, you’ll find all the bank accounts that have been added to the case. ...Adding More Transactions to Existing Bank Accounts
If you need to add more transactions to an existing bank account in FraudFindr, select the account and click the import button from within the “Transactions” tab. This is the “upload” icon directly to the right of the “Filters” button. From here, you ...Export Transactions to Excel
Exporting transactions to a CSV to import into Excel is very easy on our software. Below is a quick video tutorial and steps on how to do it. Click the “Manage Cases” Tab Click “Manage Case” For Your Desired Case Click the “Accounts” Tab Click “View ...Merging Bank Accounts
Sometimes the OCR reader will separate one account into two or more accounts do to a misreading of the bank statement headers. To merge the duplicate accounts into one, determine which account you will keep as the primary account. Then, download the ...