FEC Process (and Earmark Check Cutting)

Payment Accounts

All passwords are in the “dirtynaughtlist.txt” file

w67rcs – DirectMail Account

demccc2 – !eneral "lection #ictory

$howe%er in Arcos se%eral accounts point to different accounts to somewhat

separate what a contri&ution goes to e%en if it gets rolled up in the &an' account(.

Account )* – deprecated +ampson #ictory

Account ), – Directmail

Account )6 – !eneral "lection #ictory – -ed 2 lue pages

Account )7 – deprecated – /hristine 0ennings

Account )1 – !eneral "lection #ictory – rontline pages

Account )3 – inance Accounts – feeds into the Directmail account

Bank Accounts #s

4he other num&ers are directmail.

Mastercard5#isa – ,2,11* $these also say D///89nternet(.

Amex – 122

Disco%er 8 6*6672

The Steps

Documentation on how to run all of the scripts is in "/ -eporting :cripts.doc.

+og into the Directmail Account $w67rcs( and download all of the transactions for

the month.

+og into winscp and copy them to 5tmp on dd&.

;n dd&<

export KRANG_ROOT=/usr/local/krang

/usr/local/arcos/misc/dccc_import/authorize_net_import.pl 

pa!ment_account_id " stor!_id #$#%

/tmp/

thefileyouuploaded.csv

+og into the -ed 2 lue Account $demccc2( and download all of the %oids for

the month.

+og into winscp and copy them to 5tmp on dd&.

;n dd&<

export KRANG_ROOT=/usr/local/krang

/usr/local/arcos/misc/dccc_import/

authorize_net_import_r%&.pl pa!ment_account_id ' 

stor!_id #$#% /tmp/

thefileyouuploaded.csv

+og into Arcos= go to Add inance /ontri&utions= and type in the necessary

information a&out contri&utions that were intended for the finance department &ut

gi%en on a regular page $usually the left na% or top na%(.

4hen enter any of the information a&out the refunds5charge&ac's that ha%e come

in that month.

>>2341463

/on%ert the &an' statements that 0ac'ie gi%es you to spreadsheets. :a%e the

DM one in the directmail dri%e under "/ Memos5&an'>statements. :end

0ac'ie hers.

4a'e ?ic'@s ;nline &y /ard 4ype spreadsheet and match the daily credit card

totals to the &an' statement. ou should loo' at the totals on the far right since

all finance contri&utions will show up in the &an' totals e%en though they aren@t

ours. As you find the daily deposits and charge&ac's in the ;nline &y /ard 4ype

sheet highlight them. :ometimes the &an' rolls up two deposits into one $so you

may &e loo'ing for a deposit of B2* and find that one day we got in B, and

the next B2, – that is o'(. ou can determine which withdrawals and deposits

are our &y loo'ing for the account num&ers listed a&o%e. Also you can ignore

anything that mentions “ees.”

9f that all chec's out run 5shared5dccc>conf5scripts5get>npg.pl Cinstructions are in

another document ou need to run &oth a positi%e and a negati%e file for the

month. "ach time you run it you also get a file for American and 9nternational

/ontri&utions. :o you could ha%e up to * files to deal with.

/hec' that the total of these four files match the monthly total from the ;nline &y

/ard 4ype spreadsheet. 9f they don@t figure out what@s wrong. /ould &e a

mis'eyed entry in the spread sheet. /ould &e something didn@t get %oided.

/ould &e a refund that wasn@t entered.

ou should also run 5shared5dccc>conf5scripts5get>ngp>r2&.pl Cinstructions in

another document in the same fashion= &ut you don@t ha%e to reconcile them.

:omeone else does that.

4al' to the Directmail people to ma'e sure they ha%e reconciled things as well.

9f they ha%e send the sets of ngp files to Eimmel for processing.

The Steps for Earmark Check Processing

!o into the F< Dri%e and open the -ed2lue "armar' Grocessing folder. ;pen

the appropriate data&ase $rontline 1= -ed2lue 1(.

/lic' to /reate5Manage atches.

Add a new &atch for the dates in Huestion.

;n dd&< -un 5shared5dccc>conf5scripts5r2&>dump Cinstructions in another

document.

4his will email you two files. ou should ha%e two files in your :a%e these files in

the F<Dri%e in one of the su& folders in the "armar' Grocessing folder.

9n the Access D run the import macros $its in the Marcos section(. Ihen you

run through the import data portion for the cont$ri&ution( file import it into

temp>Donation. Ihen you run through the import data portion for the

demo$graphic( file import it into temp>Donor. 9f you ha%e the de&ugging

preference set and it prompts you a lot= agree to e%erything.