Crimson 3: Fund Code Settings - Debt Retirement

Campaigns transitioning between election cycles, may need to report debt retirement funds for the past cycle for a period of time. To make that process easier, be sure to try the Crimson Debt Retirement settings found in Fund Code Fundraising Settings.

Enable Debt Retirement Setting By Fund Code

  1. Select Fundraising from the left side Main Menu of Crimson.
  2. Click on the Money Setting option found on the Fundraising Dashboard Navigation Bar.

 

  1. Select the Fund tab from the top of the new screen.

 

  1. Click on the  button to open the Fund Code that needs the debt setting to be applied to.
  2. Check the Debt Retirement box.
  3. Fill in, or use the calendar selector to select, the Debt Retirement Start On date.

 

  1. Click  when done.

How Debt Retirement Reports in CrimsonFiler/FEC Export

If you have enabled the debt retirement feature, donor aggregates will pull differently for your FEC report data based on how you import/pull your fund codes.  See below for options:

- New Cycle Transactions – Debt enabled fund codes should be imported into CrimsonFiler (or exported via the FEC Export) together with current cycle fund codes. The aggregate will then reflect the total amount donated by each donor for the past cycle on or after the debt retirement date with the total amount raised for the new cycle fund codes.

  1. Create your FEC report
  2. Click Import From Crimson
  3. Select the debt retirement fund code AND the current cycle Fund Codes first (Ex: G2018, P2020, G2020), then import.
  4. Recalculate your report and review your data like normal

Example Result:

  • Campaign enabled debt retirement for the G2018 fund code on 11/7/2018
  • John Smith Donated:
    • 09/21/2018 | G2018 | $2,200
    • 01/13/2019 | G2018 | $500
    • 02/10/2019 | P2020 | $2,700
  • Campaign Imported G2018, P2020, and G2020 together for their Q1 2019 report
  • John Smith Aggregate for Q1 report = $3,200
  • Automated Memo Text: “DEBT RETIREMENT”
    • NOTE: You do not need to add memo text during data entry. The FEC pull will automatically include this for you.

Post General Reports – Since Post General reports crossover two cycle periods (ie. 2018 and 2020), you will want to be sure your aggregates are separated by cycle during the import/pull. To do so, you should do the following:

  1. Create your FEC report
  2. Click Import From Crimson
  3. Select the first cycle’s Fund Codes first (Ex: P2018, G2018), then import as a “Replace
  4. Once that import is done, click Import From Crimson again
  5. Select the second cycle’s Fund Codes (Ex: P2020, G2020), then import as an “Append
  6. Recalculate your report and review your data like normal

- Yearend Report Special Case – Clients who receive chargebacks during the Year End reporting period, and who are not reporting debt retirement, will want to be sure to pull the old and new cycles separately for Year End reports as well.

Have more questions? Submit a request

Comments

Powered by Zendesk