How Admin fees are calculated

Types of Admin fees

There are two types of admin fees:

• fees payable: Fees owed to another ledger. (e.g. admin grant) Table a_fees_payable
• fees receivable: Charges to collect from other ledgers. (e.g. office admin fee) Table a_fees_receivable

Calculating the fees during posting a gift batch

Analysis of Progress code

When posting a gift batch (gr1210.p), the fees are processed for each gift and gift detail.

1. "Process each part of the gift.": this goes through all gift details, and the call to Find_Account_Info is important to us.
   • this returns the list of admin fees that apply to this gift detail, based on the recipient and the motivation detail
   • see "Return a list of the fee codes to be charged." which goes through table a_motivation_detail_fee
2. "Calculate any fees on the gift.": this loop goes through all the fees that apply to this gift detail, and calculate the admin fee depending on the gift detail amount. the calculation is done in gl4391.p.
   • Add_To_Fee_Totals is called to add up the fees in table a_processed_fee
     • for each gift detail, the amount for each fee is stored in this table. a_processed_date_d is not set yet. Processing is done during ICH stewardship.

Generating a admin fee batch during ICH Stewardship processing

• all records from a_processed_fee are processed, summed up, and posted in the Admin Fee GLBatch.