Table of Contents
CyberSource
Cybersource is our online credit card payment processor. Cybersource handles all of our credit card processing. Each morning we must pull the report detailing all of the credit card transactions from the day before. (Note that we are always one day behind on Cybersource data entry, i.e. You will pull Monday’s report on Tuesday and Tuesday’s report on Wednesday). After this report is pulled, the donations on it need to be data entered in Donor Perfect.Downloading the Report
Where: https://ebc.cybersource.com/ebc/login/Login.doYou should have your own login
How To:
- Select the “Reports” option on the left hand side bar
- Select “Available Reports” within that drop down list
- Select the "Classic Reports" header
- Find the date you need the report for, click CSV, then your file will begin downloading.
- Save the downloaded report in the drive as the date the report covers (usually it’s yesterday’s date) save in:
- \\POPROCKS\membership\Accounting\Cybersource Reports\20XX CS Reports
- Once you’ve saved the original, you should clean the report so you only have the information you need for data entry in Donor Perfect
- To clean the report: See the next section below.
- Highlight all rejected “r” transactions with a highlighter so they are not accidently data entered.
- Once you finish data entry, file the report with all other Cybersource Reports for that month/year
Cleaning the Report
Do not save the file after making any edits in this process, as we will have the physical copy of the edited version. We only want a digital record of the raw file since it contains more information than the physical document.How To:
Change the name of the tab to the day of the report.
Delete all columns, except for the following:
- Source
- customer_firstName
- customer_lastName
- bill_address1
- bill_address2(If this is empty, delete it. If it's not empty, copy over the info to address 1. It is usually information like Apartment #'s)
- bill_city
- bill_state
- bill_zip
- customer_email
- ecp_account_type
- ics_rmsg
- amount
- merchant_defined_data1
- merchant_defined_data2
- merchant_defined_data3
Perform the following find/replace functions:
- "Recurring Billing Engine" > "Recc"
- "Secure Acceptance Web/Mobile" > "Web"
- "UBC Virtual Terminal" > "Tmnl"
- "customer_" > ((leave field blank))
- "bill_" > ((leave field blank))
- "Request was processed successfully" > "A"
- "We encountered an FDC problem" > "r" ((sometimes this is a different error message. If it is anything other than "processed successfully" change to "r").
Retitle columns in the following way:
- source > Src
- State > St
- postalCode > Zip
- ecp_account_type > Crd
- ics_rmsg > D ((for decision))
- amount > $
- merchant_defined_data2 > API
How to Data Enter Cybersource
Before you begin data entry:The Decision column (D) describes whether the donation was processed successfully. An "A" means accept, and the donation should be entered into DonorPerfect. An "r" means reject. A rejected donation should NOT be entered in DonorPerfect; the user should have received a notification upon trying to donate that the transaction did not go through UNLESS it is a recurring donation. If the rejected payment is for a recurring donation, contact the member, inform them that their card did not process, and offer to update their payment information. If we don't contact them, they may never notice a change in their credit card bill, and we may never receive another donation from that person.
- Recc: Recurring donations. Enter these into DonorPerfect. These donations should have the solicitation code "Recurring Web Donation 20XX", appropriate to the year of the donation. The TY code is typically DT, but not always. For a monthly donation, yes, it should be DT. But if it's a donation that occurs less often, say once annually, then the donor should receive a thank you as normal.
- You may notice that a donor might appear twice on two consecutive days with two contributions of the same amount. The first donation will have a Web source, the second Rec.
- The first transaction is a confirmation that we will be able to run their card on a recurring basis; no money is transferred here. This is the donation that needs to be data entered in DonorPerfect.
- The second transaction is the actual first payment; mark the second day's transaction with "New Recc" on the report.
- Web: Web donations. These are online donations that users have entered themselves.
- Web Member Donation 20XX: These are online donations made by current members of Vote Smart. Use the traditional TY process of giving them either an 01 or 17 thank you, with the “web member donation 20XX” solicitation code.
- New Member via web 20XX: a web donation given by a non-member. They should receive the “new member via the web” solicitation code, and the 08 new member TY letter.
- API Subscription 20XX: Look at Merchant Defined Data field 2: If the term “LIVE” is in the field, then the person has a live API key via the online API Registration system. They should be data entered in DonorPerfect, given the API flag, and entered under the solicitation code of “API Subscriptions 20XX” with the “API Subscription TY letter.”
- As of 11/16/16, every person who subscribes to the API should be given expiration date of December 31, 2018 in the “expiration date” field in DonorPerfect. This field is located in the Donor’s main page under “Membership information. ”If there are people whose expiration date is different than this, it will be communicated to DevComm by the API subscription administrator.
- Tmnl: Terminal. These are donations that were entered by a staff member in CyberSource's virtual terminal. These should already have been entered into DonorPerfect. Hotline and credit card donations from data entry fall underneath this category.
- UBC: Edits within Cybersource done by a staff member. Should not be listed as a gift in DonorPerfect.
- Any transaction with a negative amount represents a credit. Typically, it's a user who contributed in error and who wants their money back. Go in to DonorPerfect and remove the donation. Make a contact note of this error.
Note: On the physical report, mark "New" for new members next to their entry on the report. For API users, mark "API." For a new recurring donation, write “new recc.”
Contacting Members whose Recurring Donations Failed
If a recurring donation on the report is rejected, add the member and their contact information to the Failed Recurring Web Donations spreadsheet. It's best practice to update the sheet on a weekly basis.Once a month, send the donors whose donations failed a generic email about the situation. The email itself can be found in /Membership/Letters/Common Responses/Unable to Process Donation/Recurring Online Donation. Their email address can be found in their DonorPerfect profile - if they have multiple emails on file, go with the one that immediately pops up on their profile.
If they call in to update their information, add a contact note to their DonorPerfect profile - make sure to include the date they called.
Occasionally, these emails will bounce. If that happens, mail them a physical copy of the letter as soon as possible. The letter is found in the same folder as the email. Add a contact note to their profile saying that the email bounced and a physical mailing was sent out.
How To Process a Credit Card
- Log into Cybersource https://ebc.cybersource.com/ebc/login/Login.do;jsessionid=893FC185C8A41CBAC4F0A5439EE4FA2F
- Put in Merchant ID, user name and password. (Merchant ID can be found in the membership drive/general info/membership info doc)
- Click on Virtual Terminal/One Time Payment
- Fill in:
- Enter the Amount Order Value
- Transaction Type: Sale ((this is the default))
- Currency: United States: Dollar ((this is the default))
- Click "Payment Information"
- Transaction Source: Mail/Phone Order ((this is the default))
- Credit Card Type: Visa/MC/AMC or DI (remember to input the correct card type, otherwise the transaction will not be processed)
- Credit Card Number:
- CVV: ((this is not necessary. leave blank))
- Expiration Date:
- Click "Customer Information"
- First Name/Last Name:
- Street Address 1:
- Street Address 2: ((this is not necessary. leave blank))
- City,St Zip: (you do not need the full zip code - 5 digits will do)
- Click "Advanced Fields"
- Merchant Field 1: ((this is not necessary. leave blank.))
- Click "Order Review" (If the transaction is declined then check the credit card # or card type)
- Check page/receipt to be sure amount and person is correct.
- Print receipt (single-page)
- Put receipt in donation envelope from donor or if via phone print and put in 3rd check box. f you are processing credit card donations from a remit envelope, then remember to black out the credit card #.
- ENTER INTO DP
When Processing Credit Cards that came in via the mail:
- Often donors will write an incorrect card number, and when this happens, we send them a hard copy letter with a photocopy of their remit envelope included. A copy of this letter can be found in the membership drive> "letters folder"> "common responses" sub-folder.
- On occasion, the credit card may be declined - this can happen for a number of reasons, and the code that CyberSource gives you should give you a clue as to why. In cases like this, let the donor know why their card has been declined and give them the opportunity to rectify it. This can be done via email or by hard-copy letter if no email address is on file. Please see the membership drive> "letters folder"> "common responses" sub-folder for this generic letter.
Searching for Transactions in Cybersource
You can search for transactions in CyberSource. Most often, you'll want to search for people by their last name. To do so, you will follow this process:- In the sidebar, select Transaction Management > Transactions
- Set the Date Range to "Last Six Months"
- Click "+ Add a Filter"
- Set the field dropdown to Last Name.
- Enter the entire last name. Unlike DonorPerfect, CyberSource requires the last name to be an exact match. So if you're looking for Ms. Smithenbabcock, and you enter "Smith" in the last name field, it will not return Smithenbabcock.
- Click search.
Only the last six months of transactions are searchable in CS. For anything older than that, you will have to look through archived reports.
Adding a Recurring Donation
- Log into Cybersource with your id and password.
- Click on Virtual Terminal -> Recurring Billing.
- Click on New Subscription.
- Enter the relevant information for the new recurring donor:
- Customer ID (This will be their member ID#)
- Name and Address
- Email (Enter their email if one is provided or entered into their membership record, if one is not provided then simply enter 'membership@votesmart.org)
- For shipping information use billing address
- Order/Merchant Reference Number (This also will be their member ID#)
- Accept the Terms for Usage
- Subscription Type (This will usually be 'recurring', but if they want to set an end date for the recurring donation then it will be 'installment')
- Title is left blank
- Default Amount (Amount of recurring donation)
- Setup Fee is left blank
- Payment Type (Credit Card, of course) :)
- Card Type (Whatever type of Credit Card used)
- Card Number
- Card Expiration Date
- Do not check 'Ignore Fraud Checks'
- Click Submit
Yet another NOTE: The process described above is for people who call in or contact us via email requesting that we set up the recurring donation. Many of our recurring donors set up the donation online. Those recurring donations that have been pre-set can be identify on the 'purchase confirmation' sheet of any online donation form. It will indicate the recurring donation's amount and frequency.
Searching for a Recurring Donation
- In the Sidebar, Virtual Terminal -> Recurring Billing
- In the Scope dropdown box, select 'Field and Value'
- Search as you would for other CS transactions.