With more and more fundraising coming through Joint Fundraising Committees, you may find an increasing amount of your time spent vetting JFC lists. Crimson provides a new tool designed to speed up the process by using our import matching logic to determine if a donor exists in your database and how much they have given to a specified fund code.
Accessing the JFC Vetting Tool
The JFC Vetting Tool can be found on the Compliance Dashboard at the top right corner of the page from the Navigation Bar.
- In Step 1: Upload File, click within the white box to choose a file from your computer or click and drag the file into the white box. Then, select the worksheet to be used for import from the file and click Nextor Step 2: Import Type.
- In Step 2: Import Type, select the FundCode from the drop-down. If you select more than one fund code, it will combine the totals into one column, so it is recommended you do separate imports for Primary and General. You also need to select either CTD or YTD for a donation total option. Primary and General fund codes should select CTD while PAC or PARTY fund codes should use YTD.
- In Step 3: Mapping, the fields in the first column are the headers from the selected file. The drop-down fields in the second column are fields available in your Crimson database. Use these drop-down options to map fields between the file and Crimson. Make sure to map all the required fields and then click Nextor Step 4: Validate and Import. Since you aren’t importing any gift data, you do not need to map amount or date.
- Use AutoMapping and Crimson will attempt to auto map the columns in the file to the columns in the database. If any fields are not auto mapped or are auto mapped incorrectly, you can manually update the mapped fields.
- Save the mapping for future use by clicking Save. Choose Save to Selected Mapping(to select a previously saved mapping to overwrite) or Save to New Mapping (to create a brand-new saved mapping). Load Mapping loads previously saved mapping and Delete Mapping deletes any saved mapping. Click Reset to wipe out all mapped fields and start over.
- In Step 4: Validate and Import, click . This step validates that all required fields are included and that the file’s format is correct.
- If the import fails, a message will appear saying why the file was not validated and imported. Fix the listed errors, and then attempt the import again.
- If successful, a confirmation message will appear saying whether the import was successful with a preview of the output results.
- Click to see the import’s results which you can save.
- The output file will be identical to the file you imported with columns appended on the right that indicate the matched PID, the CTD or YTD total, and the date the load was run. For rows where PID is blank, this signifies no record was found in the database and a manual search should be done to confirm the donor doesn’t exist.
NOTE: This tool is designed to supplement, not replace manual vetting of JFC donations. It uses our import matching logic and is dependent on your database being clean and deduped. If a donor exists in your database with different information than provided in the JFC file, we will not find a match and you may inadvertently accept an excessive donation. We recommend you still manually vet your lists, especially for records where no match is found.