50.30 Student Financials Processes

2024-08-05

While many aspects of ctcLink student financials activity is automated based upon the configuration (as described in 50.20), other aspects require additional steps either completed through customizations or user actions.

 Due to state laws and governmental accounting guidance, colleges are required to separate tuition charges into multiple funds and classes:

  1. Operating Fees (Tuition) – Split three (3) ways:
    1.  Institutional Financial Assistance (3.5%) locally retained in Fund 860 - Class 279.
    2.  Technology Innovation funds recorded in Fund 561 - Appropriation Index Z61 - Class 288 and remitted to the State Treasurer.  By state law the maximum portion is 3% of the Operating Fee. Currently, the State Board approved amount is 2%.
    3. Balance of Operating Fees locally retained must be recorded in Fund 149 - Class 509.
  2. Building Fees (Tuition) - Split two (2) ways:
    1. Institutional Financial Assistance (3.5%) locally retained in Fund 860 - Class 279.
    2. Balance of Building Fee (96.5%) funds should be recorded in Fund 060 - Appropriation Index Z60 - Class 289 and remitted to the State Treasurer.  Building fee amount is established by the legislature.
  3. Services and Activities (Tuition) - Split two (2) ways:
    1. Institutional Financial Assistance (3.5%) locally retained in Fund 860 - Class 279.
    2. Services and Activities (S&A) Fee (96.5%) funds retained locally and recorded in Fund 522 – Class 264.  Maximum amount is established by the legislature.

In addition, student fee charges (both mandatory and miscellaneous) are generally recorded in Fund 148 and 528 and may be split in several chartstrings.

State and GASB accounting rules require the payment to be recorded in the same chartstring as the original charge. In ctcLink, this is accomplished through several processes.

  1. Tuition and Fee charges are split into multiple item types (operating, building and S&A) for each type of student (resident, non-resident, international, non-resident with operating differential, baccalaureate resident, baccalaureate non-resident, etc.) as described above.
  2. Payment, financial aid and waiver item types have a design function to pick up the receivable chartstring from the original charge to the student account (See section 50.30.20 below).
  3. This functionality does not allow the payment itself to pick up the chartstring from the original charge for the cash entry.  Therefore, a custom Fund Balancing process has been developed to ensure cash is recorded in the same chartstring as the receivable. (See section 50.30.30 below).

As noted in the Item Types section (CLAM 50.20), certain item types have the Pick Up Receivable From Charge (PURC) box checked.  Each payment/financial aid/waiver item type should have the PURC box checked. When the box is checked, the item type does not use the chartstring in the item type configuration. Instead it uses the full chartstring from the original charge (receivable) and reduces the receivable account associated with the original charge.

Pick up receivable from charge

Peoplesoft is not designed to split payments (cash payments/financial aid/waivers) into multiple chartstrings. A customization unique to ctcLink was created which:

a.    Reverses the single line “WAxxx*LOCAL*7xxx*1000070 or 1000199*790**285*98009****N****”
or for waivers
“WAxxx*LOCAL*7xxx*40001xx*846**275*98299****N****” debit line with an equal credit amount.

b.    Creates new cash/waiver debit lines using the original account and the remaining chartstring from the receivable line created by PURC.

Fund balancing lines can be identified in the SF Accounting Line table begin with “10” inserted before the original line number. For example, if the original payment line number is ‘37385’ the related fund balancing line will be ‘10037385’.

Due to the use of PURC and Fund Balancing payment item types should be configured as shown below.

All cash/credit payment item types (7*) (cash/check/eCheck/credit card/EFT/wire) should be configured:

Dr/Cr Bus Unit Ledger Oper Unit Account Fund Class Code Dept State Purpose
Dr WAxxx LOCAL 7xxx 1000070 790 285 98009 N
Cr WAxxx LOCAL 7xxx 2000030 790 285 98009 N

Where the debit account is determined by the bank account (1000070-1000160) used for deposit.

All financial aid item types (9*) should be configured:

Dr/Cr Bus Unit Ledger Oper Unit Account Fund Class Code Dept State Purpose
Dr WAxxx LOCAL 7xxx 1000199 790 285 98009 N
Cr WAxxx LOCAL 7xxx 2000030 790 285 98009 N

All waiver item types (60*) should be configured:

Dr/Cr Bus Unit Ledger Oper Unit Account Fund Class Code Dept State Purpose
Dr WAxxx LOCAL 7xxx 40001xx 846 275 98299 N
Cr WAxxx LOCAL 7xxx 4000199 790 285 98299 N

Where the debit account (4000100-4000190) is determined by the waiver type.

All payment plan item types (68*) be configured:

Dr/Cr Bus Unit Ledger Oper Unit Account Fund Class Code Dept State Purpose
Dr WAxxx LOCAL 7xxx 1000199 790 285 98009 N
Cr WAxxx LOCAL 7xxx 1011105 790 285 98009 N

All third-party payment item types (62*) should be configured:

Dr/Cr Bus Unit Ledger Oper Unit Account Fund Class Code Dept State Purpose
Dr WAxxx LOCAL 7xxx 1000199 790 285 98009 N
Cr WAxxx LOCAL 7xxx 1010220 790 285 98009 N

This example demonstrates the entire process from charges to payments including PURC and Fund Balancing.

Accounting Steps

  1. Operating Fees (Tuition) – Fund 149 with additional split into funds 860 (Institutional Financial Aid) and 561 (Innovation).
  2. Building Fees (Tuition) – Fund 060 with additional split into fund 860 (Institutional Financial Aid).
  3. Services and Activities Fees (Tuition) – Fund 522 with additional split into fund 860 (Institutional Financial Aid).
  4. Mandatory (Dedicated Fees) – Fund 148 with possible splits between class codes and departments depending on the type of course.  It is also likely colleges may charge additional fees based on student usage (parking, etc.) which likely require splitting between additional class codes and departments.
  5. Cash Payment – In this example a simple cash payment for the full amount due is used. The payment debit (cash) is always recorded in Fund 790-285-98009. The payment item type must have the Pick Up Receivable from Charge box checked, therefore the credit (relieving the receivable) will always use the chartstring from the original charges in steps 1, 2, 3 and 4.
    Since government accounting requires each fund to be balanced, recording the cash in Fund 790 and the relief of the receivable in other funds, this transaction will cause an error when sent to the general ledger. Therefore, the next step:
  6. Fund Balancing – The cash entry to 790-285-98009 is reversed and distributed based upon the receivables being relieved.  For additional discussion see section 50.30.30.

 

Event Step Action Account Dr Cr Chartstring Fund Chartstring AI Chartstring Class Chartstring Dept
Charge 1 Receivable 1011010   1,099.33   149   509 ddddd
1xxxxxxxxxxx (Operating) 1 Receivable 1011010   41.151   860   279 ddddd
1 Receivable 1011010   35.27   561 Z61 288 ddddd
1 Revenue   4000020    (1,099.33) 149   509 ddddd
1 Revenue   4000020       (41.15) 860   279 ddddd
1 Revenue   4000020     (35.27) 561 Z61 288 ddddd
1xxxxxxxxxxx (Building) 2 Receivable 1011010    146.87   060 Z60 289 ddddd
2 Receivable 1011010    5.331   860   279 ddddd
2 Revenue   4000020    (146.87) 060 Z60 289 ddddd
2 Revenue   4000020        (5.33) 860   279 ddddd
1xxxxxxxxxxx (S&A) 3 Receivable 1011010   152.52   522   264 ddddd
3 Receivable 1011010       5.531   860   279 ddddd
3 Revenue   4000020    (152.52) 522   264 ddddd
3 Revenue   4000020      (5.53) 860   279 ddddd
2xxxxxxxxxxx (Fees) 4 Receivable 1011010   150.00   148   011 ddddd
4 Revenue   4000020    (150.00) 148   011 ddddd
    Total     1,636.00 (1,636.00)        

Cash Payment

**Pick Up Receivable From Charge (PURC) Box Checked

Item Type DR/CR Fund Class Dept Account Amount
700000000000 DR 790 285 98009 1000070 $1,636.00
  CR 790 285 98009 2000030  

Cash Payment

Event Step Action Account Dr Cr Chartstring Fund Chartstring AI Chartstring Class Chartstring Dept
Payment 5 Cash 1000070    1,636.00   790   285 98009
700000000000 (Cash)
Line="nnnnn"Eg "37385"
5 Receivable   1011010    (1,099.33) 149   509 ddddd
5 Receivable   1011010    (52.01)1 860   279 ddddd
5 Receivable   1011010    (35.27) 561 Z61 288 ddddd
5 Receivable   1011010    (146.87) 060 Z60 289 ddddd
5 Receivable   1011010    (152.52) 522   264 ddddd
5 Receivable   1011010    (150.00) 148   011 ddddd
  Total     1,636.00 (1,636.00)        

1 Credit receivable amount is the combined amount from the operating, building and S&A dedicated to Institutional Financial Aid.

Cash Fund Balance

Event Step Action Account Dr Cr Chartstring Fund Chartstring AI Chartstring Class Chartstring Dept
Fund Bal 6 Cash 1000070    1,099.33   149   509 ddddd
CEMLI E-214Line="100nnnnn"Eg "10037385" 6 Cash 1000070    52.01   860   279 ddddd
6 Cash 1000070    35.27   561 Z61 288 ddddd
6 Cash 1000070    146.87   060 Z60 289 ddddd
6 Cash 1000070    152.52   522   264 ddddd
6 Cash 1000070    150.00   148   011 ddddd
6 Cash   1000070    (1,636.00) 790   285 98009
  Total     1,636.00 (1,636.00)        


50.30.50 Financial Aid Second Journal Set (CEMLI E-218)

When financial aid is applied to a student account to pay off charges the item type uses Pick Up Receivable from Charge and Fund Balancing to ensure the receivables are relieved and cash is recorded in the same chartstring as the original charges (receivable/revenue). The item type uses Internal Cash (1000199) because the transaction will not result in a change to the college’s bank cash.

Since the college internally paid the student charges on behalf of the student, the college must record the expense in an appropriate fund. And because the financial aid item type uses the internal cash account an offset of an equal amount of internal cash must be recorded in the accounting records (since internal cash must always net to zero).

To record this entry, a customized process was created to record the expense and internal cash.  The college must create a 2nd Journal Set (SJS) for each financial aid item type to record the expense and internal cash.  See 50.30.50.2 below.

The process identifies all payments made using each 2nd Journal Set item type to create a debit expense (account determined by funding source and type) and credit internal cash (always 1000199) transactions.

Overnight a job is run to create an SJS journal (separate from the SF Accounting Line table) with all the detailed financial aid applied to student accounts including Item Type and Student ID.  These transactions are summarized and posted to the General Ledger using Source and Journal ID prefix ‘SJS’.

For example, the SJS journal in SF consisted of 394 lines but the summarized version of this journal in FIN is only 10 lines.

To access the setup screen: Menu > Set Up SACR > Product Related > Student Financials > GL 2nd Journal Set Setup.  However, the ability to create or modify SJS is limited to State Board staff therefore a ticket must be submitted to add or make changes to a SJS Item Type.  See also the ctcLink Reference Center.

Below is an example of SJS setup using Pell Grants. 

FA second journal set

The credit account is ALWAYS 1000199 (Internal Cash) and the debit must be an expenditure account from the Second Journal Set Financial Aid Expenditure Accounts list.

The following queries should be helpful in ensuring all required financial aid item types have a Second Journal Set and to review SJS transactions:

Query Name Description
QCS_SF_2ND_JOURNAL_SET GL 2nd Journal Set Setup
QCS_SF_ITEM_SJS_VAL SJS Item Type Validation
QCS_SF_ITEM_1ST_2ND_ACCTS Item Type GL 1st & 2nd

Returns Item Types (with and without an SJS). Option to look up specific Item Type or description.

Query Name Description
QCS_SF_ACCTNG_LN_W_PROMPTS_SJS Student Financials SJS
QCS_SF_ACCTNG_LN_SJS Stdnt Financials Trans SJS

50.30.50.3.a Second Journal Set List

To generate a list of all SJS Item Types (active and inactive) by college run the query ‘QCS_SF_2ND_JOURNAL_SET’.  The query returns the following fields and values (the table has been transposed to allow easier display):

  Item Type Debit Item Type Credit Item Type Debit Item Type Credit
SetID WAxxx WAxxx WAxxx WAxxx
Item Type 911000000000 911000000000 912000000400 912000000400
Descr Federal Pell Grant Federal Pell Grant BFET Tuition BFET Tuition
Eff Date 7/1/2019 7/1/2019 7/1/2023 7/1/2023
Status A A A A
DB/CR D C D C
Unit WAxxx WAxxx WAxxx WAxxx
Ledger LOCAL LOCAL LOCAL LOCAL
Acct 5020030 1000199 5020080 1000199
DeptID ddddd ddddd ddddd ddddd
Proj/Grt     0000009526 0000009526
ActivityID     TUIT TUIT
Fund 846 846 146 146
Approp Index        
Class 271 271 161 161
Operating Unit 7xxx 7xxx 7xxx 7xxx
Chartfield2 N N N N

50.30.50.3.b Second Journal Set Item Type Validation

To determine if any Item Types that should have a SJS do, run the QCS_SF_ITEM_SJS_VAL query. This query returns the original Item Type with chartfields and the SJS Item Type with chartfields in the same row (if a SJS exists).

'First' Journal Set Debit Line Credit Line
SetID WAxxx WAxxx
Item Type 911000000000 911000000000
Descr Federal Pell Grant Federal Pell Grant
DB/CR D C
Unit WAxxx WAxxx
Ledger LOCAL LOCAL
Acct 1000199 2000030
DeptID 98009 98009
Alloc    
Fund 790 790
Class 285 285
Operating Unit 7xxx 7xxx
Chartfield1    
Chartfield2 N N
GL Pct 100.00000000 100.00000000
'Second' Journal Set    
Item Type 911000000000 911000000000
2nd Jrnl DB/CR D C
2nd Jrnl Unit WAxxx WAxxx
2nd Jrnl Ledger LOCAL LOCAL
2nd Jrnl Acct 5020030 1000199
2nd Jrnl DeptID ddddd ddddd
2nd Jrnl Prod    
2nd Jrnl Fund 846 846
2nd Jrnl Class 271 271
2nd Jrnl Operating Unit 7xxx 7xxx
2nd Jrnl Chartfield1    
2nd Jrnl Chartfield2 N N
2nd Jrnl GL Pct 100.00000000 100.00000000

50.30.50.3.c All Item Types with 1st and 2nd Journal Sets

The QCS_SF_ITEM_1ST_2ND_ACCOUNTS query is similar to the QCS_SF_ITEM_SJS_VAL query but returns ALL item types displaying the SJS (the SJS fields are blank if a SJS has not been set up for this item type).

50.30.50.3.d SJS SF Accounting Line

The QCS_SF_ACCTNG_LN_W_PROMPTS_SJS query provides multiple options in selecting the records desired with only GL Unit (District - WAxxx) and Business Unit (College – WAxxx for multi-college districts) required.

SF accounting line

The query returns the following fields and values:

Field Name Field Value Internal Cash Field Value Expenditure Description
Run Date 4/8/2024 4/8/2024 Date journal generator run.
SeqNum 316 316 System Assigned
Line 1 2 Line number
ID 2xxxxxxxx 2xxxxxxxx Student ID
Item Type 911000000000 911000000000 Item Type Number
Item Term 2243 2243 Fin Aid Term
Student Line Amt             (2,465.00)                 2,465.00 Fin Aid Amount  Dr(Cr) By Account
GL Amount  (duplicated)          (27,865.00)              27,865.00 Total amount by Journal, Item Type and Account
In Process N N  
GL Unit WAxxx WAxxx District Business Unit
Journal SJS0442572 SJS0442572 Journal ID. Equals Journal ID in GL.
Date 4/8/2024 4/8/2024 Date journal created
Line # 1 2 Line number
Acct 1000199 5020030 Account.  For Financial Aid only internal cash (1000199) and expense (502xxx) should be used.
Fund 846 846 Fund
Program     College specific value
DeptID 81200 81200 College specific value
AnlysType DNC GLE Analysis Type used if project set up for financial aid.
ActivityID     Used when financial aid tracked using a project.
PC Bus Unit     Used when financial aid tracked using a project.
Proj/Grt     Used when financial aid tracked using a project.
Stat     N/A
Stat Amt 0.00 0.00 N/A
Reference     N/A
Status     N/A
Line Descr 911000000000 911000000000 Item Type Number transferred to GL Journal.  Allows for easy identification of financial aid source in GL.
Status     N/A
Line Date     N/A
Unit WAxxx WAxxx College Business Unit. This value equals the GL Unit except for multi-college districts.
Template CTCSASFDFN CTCSASFDFN Used by system to create correct journal detail
Acctg Date 4/8/2024 4/8/2024 Date journal posted to FIN GL
Status D D D=Distributed
Instance 156758486 156758486 System Identifier
Currency     N/A
Period 10 10 Accounting Period
Year 2024 2024 Fiscal Year
Amount 0.00 0.00 Net amount.  This should always be 0.00 since debits and credits must be equal.
Currency     N/A
Ledger LOCAL LOCAL Ledger journal to be posted
Ledger Grp     N/A
Ext Chart     N/A
ID     N/A
Org ID     N/A
Item Nbr     N/A
Bgt Pd.     N/A
Class 271 271 Class Code as defined in SJS setup.
Affl     N/A
Budget Ref     N/A
Chartfield1     N/A
Chartfield2 N N State Purpose IT -  Always 'N' for Fin Aid
Chartfield3     N/A
Alt. Account     N/A
Operating Unit 7xxx 7xxx Operating Unit (should be associated with Unit)
Prod     Appropriation Index if state funds.
Fund Affil     N/A
Oper Unit Affil     N/A
Deposit     N/A
Rate Type     N/A
Divisor 0.00000000 0.00000000 N/A
Multiplier 0.00000000 0.00000000 N/A
Instance 0 0 N/A
Action C C N/A
ID     N/A
ID Type     N/A
GL Transac ID     N/A
GL Trans Ln Seq 0 0 N/A
Item Term     N/A
Item Type     N/A
Ref Nbr     N/A
Receipt Num 0 0 N/A
Created By     N/A
Created     N/A
By     N/A
Updated     N/A

 

Colleges should reconcile the SF, GL and SJS transactions frequently - daily if possible but no less than weekly.

Ways Internal Cash (1000199) can get out of balance:

  • Manual journals with unbalanced internal cash amounts (1000199 credits <> debits).
  • 32* and 62* - Third-Party Payments (recording the 32* Item Type but not recording the 62* Item Type)
  • 38* and 68* - Payment Plans (recording the 38* Item Type but not recording the 68* Item Type)
  • FARC/FARP – 496100000000 and 709610000000 (recording the 4961* Item Type but not recording the 70961* Item Type)
  • Conversion item types (e.g. Conv: FA Refund, Conv: FA Adjust). Not all conversion item types were configured to balance internal cash.
  • Missing or incorrect chart strings from SF item types
  • Missing or incorrect chart stings from SJS item types

Colleges should use one of the E214 queries to compare with the results of one the daily SJS journal queries:

Recommended E214 Queries Recommended SJS Queries
QCS_SF_E214_ACCTG_LN QCS_SF_ACCTNG_LN_W_PROMPTS_SJS
QCS_SF_E214_ACCTG_LN_CF_DTL QCS_SF_ACCTNG_LN_SJS
QCS_SF_E214_ACCTG__CF_SUMM  
CTC_SF_ACCTNG_LN_WITH_PROMPTS  

For additional information see Internal Cash Reconciliation Tips PowerPoint presentation.

 

50.30.60 Student Financial Process Scenarios

Self-payment is relatively straightforward and includes fund balancing to ensure payment (cash) is recorded in the same chartstring as the charges/receivables since this item type Picks Up Receivable from Charge.

In the example below, the student’s payment did not exceed the amount owed so ‘Unapplied Student Liability’ (2000030) is not recorded.  If the student’s payment had exceeded the amount owed, the liability would be recorded and an unapplied amount would remain on the student account until a refund was issued.

  1. Original tuition charges
  2. Pay off original charges with cash/credit using cash in bank (1000070)
  3. Cash payment fund balanced to original receivable chartstring

Charge

Event Step Action Account Account2 Dr Cr Chartstring Fund Chartstring AI Chartstring Class Chartstring Dept
Charge 1 Receivable 1011010   $93.50   149   509 ddddd
1xxxxxxxxxxx 1 Receivable 1011010   3.50   860   279 ddddd
2xxxxxxxxxxx 1 Receivable 1011010   3.00   561 261 288 ddddd
3xxxxxxxxxxx 1 Chrg-Rev   4000020   $(93.50) 149   509 ddddd
  1 Chrg-Rev   4000020   (3.50) 860   279 ddddd
  1 Chrg-Rev   4000020   (3.00) 561 261 288 ddddd

Payment

Event Step Action Account Account 2 Dr Cr Chartstring Fund Chartstring AI Chartstring Class Chartstring Dept
Payment 2 Payment 1000070   $100.00   790   285 98009
Line no = 2 Pmt-Rec   1011010   $(93.50) 149   509 ddddd
"nnnnn" 2 Pmt-Rec   1011010   (3.50) 860   279 ddddd
Eg. "37385" 2 Pmt-Rec   1011010   (3.00) 561 261 288 ddddd

Fund Balancing

Event Step Action Account Account 2 Dr Cr Chartstring Fund Chartstring AI Chartstring Class Chartstring Dept
CEMLI E-214 3 Fund Bal 1000070   $93.50   149   509 ddddd
Line no = 3 Fund Bal 1000070   3.50   860   279 ddddd
“10nnnnn” 3 Fund Bal 1000070   3.00   561 Z61 288 ddddd
Eg:”1037385” 3 Fund Bal   1000070   $(100.00) 790   285 98009

Both financial aid and internal aid item types require a Second Journal Set.

The application of financial aid is recorded as a payment and includes fund balancing to ensure payment (internal cash) is recorded in the same chartstring as the charges/receivables since this item type Picks Up Receivable from Charge (PURC).

In the example below, the financial aid payment exceeds the amount owed so ‘Unapplied Student Liability’ (2000030) is recorded.  

  1. Original tuition charges.
  2. Pay off original charges with financial aid and internal cash (1000199).  Unapplied amount is recorded as Student Liability. This is refunded to the student either via BankMobile or a check issued to the student (see Section 50.30.60.3 below)
  3. Internal cash payment fund balanced to original receivable chartstring.
  4. 2nd Journal Set is used to record the expenditure and internal cash in Fund 846, Class 271 and department based on source and type of financial aid.

Charge

Event Step Action Account Account 2 Dr Cr Chartstring Fund Chartstring AI Chartstring Class Chartstring Dept
Charge 1 Rec 1011010   $93.50   149   509 ddddd
1xxxxxxxxxxx 1 Rec 1011010   3.50   860   279 ddddd
2xxxxxxxxxxx 1 Rec 1011010   3.00   561 Z61 288 ddddd
3xxxxxxxxxxx 1 Revenue   4000020   $(93.50) 149   509 ddddd
  1 Revenue   4000020   (3.50) 860   279 ddddd
  1 Revenue   4000020   (3.00) 561 Z61 288 ddddd

FA Applied

Event Step Action Account Account 2 Dr Cr Chartstring Fund Chartstring AI Chartstring Class Chartstring Dept
FA Applied 2 Pmt-Cash 1000199   $200.00   790   285 98009
9xxxxxxxxxxx 2 Pmt-Rec   1011010   $(93.50) 149   509 ddddd
Line no = 2 Pmt-Rec   1011010   (3.50) 860   279 ddddd
“nnnnn” 2 Pmt-Rec   1011010   (3.00) 561 Z61 288 ddddd
Eg:”37385” 2 Pmt-Liab   1011010   (100.00) 790   285 98009

CEMLI E214 - Cash Fund Balancing

Event Step Action Account Account 2 Dr Cr Chartstring Fund Chartstring AI Chartstring Class Chartstring Dept
CEMLI E214 3 Fund Bal 1000199   $93.50   149   509 ddddd
Line no = 3 Fund Bal 1000199   3.50   860   279 ddddd
“10nnnnn” 3 Fund Bal 1000199   3.00   561 Z61 288 ddddd
Eg:”1037385” 3 Fund Bal 1000199   100.00   790   285 98009
  3 Fund Bal   1000199   $(200.00) 790   285 98009

Custom Second Journal Set

Event Step Action Account Account 2 Dr Cr Chartstring Fund Chartstring AI Chartstring Class Chartstring Dept
SJS Journal 4 2nd Jrnl Set 5020xxx   $200.00   846   271 ddddd
SJS Journal 4 2nd Jrnl Set   1000199   $(200.00) 846   271 ddddd

Much like financial aid, departmental/internal payment (and may be financial aid, depending on the funding source) is recorded as a payment and includes fund balancing to ensure payment (internal cash) is recorded in the same chartstring as the charges/receivables since this item type Picks Up Receivable from Charge (PURC).

In most circumstances, departmental/internal payments (IP) do not exceed the amount owed so ‘Unapplied Student Liability’ (2000030) is normally not recorded. 

  • Original charges.
  • Pay off original charges with departmental/internal aid and internal cash (1000199). Excess payment amounts are recorded as Unapplied Student Liability. If the internal payment Item Type is configured as being refundable, then the unapplied amount is refunded to the student either via BankMobile or a check issued to the student (see Section 50.30.60.3 below)
  • Departmental/Internal cash payment fund balanced to original receivable chartstring.
  • 2nd Journal Set Journal is used to record the expenditure and internal cash in Fund ‘fff’, Class ‘ccc’ and Dept ‘ddddd’ based on source and type of funding used.

Charge

Event Step Action Account Account 2 Dr Cr Chartstring Fund Chartstring AI Chartstring Class Chartstring Dept
1xxxxxxxxxxx 1 Receivable 1011020   $75.00   148   042 ddddd
2xxxxxxxxxxx 1 Receivable 1011020   $25.00   148   041 ddddd
3xxxxxxxxxxx 1 Revenue   4000050   $(75.00) 148   042 ddddd
  1 Revenue   4000060   $(25.00) 148   041 ddddd

Department/Internal Payment Applied

Event Step Action Account Account 2 Dr Cr Chartstring Fund Chartstring AI Chartstring Class Chartstring Dept
IP Applied 2 Payment 1000199   $100.00   790   285 98009
75xxxxxxxxxx 2 Pmt-Rec   1011020   $(75.00) 148   042 ddddd
Line no = 2 Pmt-Rec   1011020   (25.00) 148   041 ddddd
“nnnnn”                    
Eg:”37385”                    

CEMLI E214 - Cash Fund Balancing

Event Step Action Account Account 2 Dr Cr Chartstring Fund Chartstring AI Chartstring Class Chartstring Dept
CEMLI E-214 3 FundBal 1000199   $75.00       042 ddddd
Line no = 3 FundBal   1000199 25.00       041 ddddd
“10nnnnn” 3 FundBal   1000199   $(100.00)     285 98009
Eg:”1037385”                    

Custom Second Journal Set

Event Step Action Account Account 2 Dr Cr Chartstring Fund Chartstring AI Chartstring Class Chartstring Dept
SJS Journal 4 2nd Jrnl Set 5020xxx   $100.00   fff   ccc ddddd
  4     1000199   $(100.00) fff   ccc ddddd

Student refunds are nearly identical for student self-pay or financial aid. Cash payments are usually refunded with a check, credit card payments may be refunded either by check or returned to the credit card. 

To initiate the student refund check, student financials staff must apply a check refund item type (5900000000xx) to the student account. This will send the liability to Accounts Payable using account 2000015.

For an electronic refund, student services should apply either a credit card or BankMobile refund item.  Then, either cashiering or finance staff must process the refund to the student credit card or submit an EFT to Bank Mobile, depending on the fund type See Step 5d below).

In the example below, the financial aid payment exceeds the amount owed so ‘Unapplied Student Liability’ (2000030) is recorded.  

  • 5a – When a refund item type is applied to the student account, ctcLink will credit the Unapplied Student Liability (2000030) and debit the liability account (2000015) recorded in the AP Chartfield portion of the Refund Item Type configuration (The use of 2000015 enables the college to determine which AP entries originated in Student Financials vs Finance).
  • 5b – The AP Chartfield is sent to Accounts Payable in Finance to create a voucher for payment. This process converts the SF liability account to an AP liability account (2000010).
  • 5c – When the check is issued AP relieves the AP liability account and credits cash.
  • 5d – Electronic payments using Bank Mobile, credit card, EFT or wire funds are initiated when student services applies an EFT Item Type (590000000xxx) to the student account.  Different Item Types are used to initiate the refund allowing colleges to track each refund type.

Since these refunds are processed directly with the bank, they are not sent to Accounts Payable.  Instead the Unapplied Student Liability account is debited and cash in bank is credited.

Student Check Refund

Send to GL

Step Action Account Account 2 Dr Cr Chartstring Fund Chartstring AI Chartstring Class Chartstring Dept
5a Refund 2000030   $100.00   790   285 ddddd
5a Refund   2000015   $(100.00) 790   285 ddddd

Voucher Created

Step 5b and 5c occur in the Accounts Payable module in Finance.

Step Action Account Account 2 Dr Cr Chartstring Fund Chartstring AI Chartstring Class Chartstring Dept
5b Voucher 2000015   $100.00   790   285 ddddd
5b Voucher   2000010   $(100.00) 790   285 ddddd

Student Electronic Fund

Check Issued

Step Action Account Account 2 Dr Cr Chartstring Fund Chartstring AI Chartstring Class Chartstring Dept
5c Payment 2000010   $100.00   790   285 ddddd
5c Payment   1000070   $(100.00) 790   285 ddddd

Or 

EFT-Initiated Event

Step Action Account Account 2 Dr Cr Chartstring Fund Chartstring AI Chartstring Class Chartstring Dept
5d Refund 2000030   $100.00   790   285 ddddd
5d Refund   1000070   $(100.00) 790   285 ddddd

 

Financial Aid staff adjust award based on student’s discontinuation of attendance based on federal, state and college rules for refunding.

When the adjustment is applied, it generates an entry on the student account using the item type associated with the financial aid source.  For example, Pell:

Award Adjustment is applied (i.e. negative payment) using the original item type (9xxxxxxxxxxx):

  • Cr Internal Cash (1000199)
  • Dr Receivable (Pick Up Receivable from Charge is used)

Second Journal reverses the original financial aid expense:

  • Cr Expense (5020xxx)
  • Dr Internal Cash (1000199)

Financial Aid Refund Adjust (payment) is applied using item type 709610000000

  • Cr Receivable (Pick Up Receivable from Charge is used)
  • Dr Internal Cash (1000199)

Financial Aid Adjustment Due (charge) is applied using item type 496100000000

  • Cr Internal Cash (1000199)
  • Dr Student R2T4 Loan Receivable (1011120)

 College returns funds to the Department of Education (ED).  This reverses the original revenue and cash received from ED.

The application of financial aid is recorded as a payment and includes fund balancing to ensure payment (internal cash) is recorded in the same chartstring as the charges/receivables since this item type Picks Up Receivable from Charge (PURC).

In the example below, the financial aid payment exceeds the amount owed so an ‘Unapplied Student Liability’ (2000030) is recorded.  

  1. Original tuition charges.
  2. Pay off original charges with financial aid and internal cash (1000199).  Unapplied amount is recorded as a Student Liability. This is refunded to the student either via BankMobile or a check issued to the student (see Section 50.30.60.3 above).
  3.  Internal cash payment fund balanced to original receivable chartstring.
  4.  2nd Journal Set is used to record the expenditure and internal cash in Fund 846, Class 271 and department based on source and type of financial aid.
  5. When the adjustment to financial aid is applied to the student account by financial aid staff, an entry is generated in which the original award item type transaction is reversed in the amount of the adjustment. Assuming the student had not earned any of the refund and was not eligible for tuition reimbursement.
  6.  2nd Journal Set is used to record the reversal of expenditure and internal cash in Fund 846, Class 271 and department based on source and type of financial aid.
  7.  Charges are removed (paid) using the payment Item Type 70961xxxxxxx.  This item should only be used in conjunction with Item Type 49610xxxxxxx.
  8.  New charges are applied recording a Student Loan Receivable and Internal Cash with Item Type 49610xxxxxxx.
  9. Student repayment is recorded reducing the receivable and increasing Cash In Bank.
  10. Although not required since it is a single chartstring, ctcLink will run the fund balancing process since fund balancing is triggered by any payment or waiver item type.

Charge

Event Step Action Account Account 2 Dr Cr Chartstring Fund Chartstring AI Chartstring Class Chartstring Dept
Charge 1 Receivable 1011010   $93.50   149   509 ddddd
1xxxxxxxxxxx 1 Receivable 1011010   3.50   860   279 ddddd
2xxxxxxxxxxx 1 Receivable 1011010   3.00   561 Z61 288 ddddd
3xxxxxxxxxxx 1 Revenue   4000020   $(93.50) 149   509 ddddd
  1 Revenue   4000020   (3.50) 860   279 ddddd
  1 Revenue   4000020   (3.00) 561 Z61 288 ddddd

FA Applied

Event Step Action Account Account 2 Dr Cr Chartstring Fund Chartstring AI Chartstring Class Chartstring Dept
FA Applied 2 Pmt-Cash 1000199   $200.00   790   285 98009
9xxxxxxxxxxx 2 Pmt-Rec   1011010   $(93.50) 149   509 ddddd
Line no = 2 Pmt-Rec   1011010   (3.50) 860   279 ddddd
“nnnnn” 2 Pmt-Rec   1011010   (3.00) 561 Z61 288 ddddd
Eg:”37385” 2 Pmt-Liab   2000030   (100.00) 790   285 98009

CEMLI E214 - Cash Fund Balancing

Event Step Action Account Account 2 Dr Cr Chartstring Fund Chartstring AI Chartstring Class Chartstring Dept
CEMLI E-214 3 Int Cash 1000199   $93.50   149   509 ddddd
Line no = 3 Int Cash 1000199   3.50   860   279 ddddd
“10nnnnn” 3 Int Cash 1000199   3.00   561 Z61 288 ddddd
Eg:”1037385” 3 Int Cash 1000199   100.00   790   285 98009
  3 Int Cash   1000199   $(200.00) 790   285 98009

Custom Second Journal Set

Event Step Action Account Account 2 Dr Cr Chartstring Fund Chartstring AI Chartstring Class Chartstring Dept
SJS Journal 4 FA Exp 5020xxx   $200.00   846   271 ddddd
SJS Journal 4 Int Cash   1000199   $(200.00) 846   271 ddddd

FA Adjusted

Event Step Action Account Account 2 Dr Cr Chartstring Fund Chartstring AI Chartstring Class Chartstring Dept
FA Adjusted 5 Pmt-Rec 1011010   $93.50   149   509 ddddd
9xxxxxxxxxxx 5 Pmt-Rec 1011010   3.50   860   279 ddddd
Line no = 5 Pmt-Rec 1011010   3.00   561 Z61 288 ddddd
“nnnnn” 5 Pmt-Liab 2000030   100.00   790   285 98009
Eg:”37385” 5 Pmt-Cash   1000199   $(200.00) 790   285 98009

Custom Second Journal Set

Event Step Action Account Account 2 Dr Cr Chartstring Fund Chartstring AI Chartstring Class Chartstring Dept
SJS Journal  6  Int Cash 1000199   $200.00   846   271 ddddd
SJS Journal  6  FA Exp   5020xxx   $(200.00) 846   271 ddddd

FA Refund Adjustment

 Event Step  Action  Account Account 2 Dr Cr Cashstring Fund Cashstring AI Cashstring Class Cashstring Dept
FA Rfnd Adj  7 Pmt-Cash 1000199   $200.00   790   285 98009
70961xxxxxxx  7 Pmt-Rec   1011010   $(93.50) 149   509 ddddd
Line no =  7 Pmt-Rec   1011010   (3.50) 860   279 ddddd
“nnnnn” 7 Pmt-Rec   1011010   (3.00) 561 Z61 288 ddddd
Eg:”37385” 7 Pmt-Liab   2000030   (100.00) 790   285 98009

FA Adjustment Due

 Event Step  Action  Account Account 2 Dr Cr Chartstring Fund Chartstring AI Chartstring Class Chartstring Dept
FA Adj Due  8 Rec 1011120   $200.00   846   271 ddddd
49610000xxxx  8  Int Cash   1000199   $(200.00) 846   271 ddddd

Student Repay

 Event Step  Action  Account Account 2 Dr Cr Chartstring Fund Chartstring AI Chartstring Class Chartstring Dept
Stdt Repay  9 Bnk Cash 1000070   $200.00   846   271 ddddd
7000xxxxxxxx  9 Rec   1011120   $(200.00) 846   271 ddddd

CEMLI E-214 - Cash Fund Balancing

Event Step Action Account Account 2 Dr Cr Chartstring Fund Chartstring AI Chartstring  Chartstring Dept
CEMLI E-214 10 Bnk Cash 1000070   $200.00   846   271 ddddd
(Fund Bal) 10 Bnk Cash   1000070   $(200.00) 846   271 ddddd

Waivers behave in a manner similar to payments in that the receivable is relieved but a debit to a contra-revenue is recorded instead of cash. Below is the list of waiver accounts:

 Account Waiver Account Title 
4000100 Tuition & Fee Waiver
4000105 Tuition & Fee Waiver-Need
4000110 Tuition & Fee Waiver-Non-Need
4000115 Tuition & Fee Waiver-Athletic
4000118 Tuition & Fee Waiver-Athletic Gender Equity

The account used is determined by the Waiver Item Type configuration.

The fund balancing process records the contra-revenue into the chartstring where the original revenue is recorded.

Although the Item Type is configured using Fund 846 Class 275m the waiver is recorded in the chartstring of the original charges (receivable/revenue) due to PURC and Fund Balancing.

  1. Original tuition charges.
  2. Waiver reduces the receivable for waiver allowed amounts and records a contra-revenue.
  3. Waiver fund balanced to original receivable chartstring.

Charge

Event Step Action Account Account 2 Dr Cr Chartstring Fund Chartstring AI Chartstring Class Chartstring Dept
Charge 1 Receivable 1011010   $93.50   149   509 ddddd
1xxxxxxxxxxx 1 Receivable 1011010   3.50   860   279 ddddd
2xxxxxxxxxxx 1 Receivable 1011010   3.00   561 Z61 288 ddddd
3xxxxxxxxxxx 1 Revenue   4000020   $(93.50) 149   509 ddddd
  1 Revenue   4000020   (3.50) 860   279 ddddd
  1 Revenue   4000020   (3.00) 561 Z61 288 ddddd

Payment

Event Step Action Account Account 2 Dr Cr Chartstring Fund Chartstring AI Chartstring Class Chartstring Dept
Payment 2 Waiver 40001xx   $100.00   790   285 98009
Line no = 2 Receivable   1011010   ($93.50) 149   509 ddddd
“nnnnn” 2 Receivable   1011010   (3.50) 860   279 ddddd
Eg:”37385” 2 Receivable   1011010   (3.00) 561 Z61 288 ddddd

CEMLI E-214 - Cash Fund Balancing

Event Step Action Account Account 2 Dr Cr Chartstring Fund Chartstring AI Chartstring Class Chartstring Dept
CEMLI E-214 3 Fund Bal 40001xx   $93.50   149   509 ddddd
Line no = 3 Fund Bal 40001xx   3.50   860   279 ddddd
“10nnnnn” 3 Fund Bal 40001xx   3.00   561 Z61 288 ddddd
Eg:”1037385” 3 Fund Bal 1000199     $(100.00) 790   285 98809

 

Some colleges have elected to offer payment plans to students. The payment plans could be managed by the college or Nelnet. This allows students to make weekly/monthly payments instead of paying the entire amount at the beginning of the term.

Moving students to a payment plan is a 2-step process in which all the charges (operating, building, S&A and fees) are ‘paid off’ and a new single payment plan charge is applied.

  1. Original tuition charges.
  2. Pay off original charges with payment plan item type (680000000xxx) using internal cash (1000199). Since this is a payment item type, it should use 2000030 Student Liability ST as the credit (for any unapplied amounts, which is rare).
  3. Payment Plan payment fund balanced to original receivable chartstring.
  4. Payment plan charges applied (380000000xxx) to student account with payment plan receivable (1011100) and internal cash (1000199).
  5. Payment made by student relieving receivable (directly for college payment plans or a Nelnet payment) for 1/3 of the outstanding balance.
  6. Cash payment is fund balanced to receivable chartstring.

Charge

Event Step Action Account Account 2 Dr Cr Chartstring Fund Chartstring AI Chartstring Class Chartstring Dept
Charge 1 Receivable 1011010   $93.50   149   509 ddddd
1xxxxxxxxxxx 1 Receivable 1011010   3.50   860   279 ddddd
2xxxxxxxxxxx 1 Receivable 1011010   3.00   561 Z61 288 ddddd
3xxxxxxxxxxx 1 Revenue   4000020   $(93.50) 149   509 ddddd
  1 Revenue   4000020   3.50 860   279 ddddd
  1 Revenue   4000020   3.00 561 Z61 288 ddddd

Payment

Event Step Action Account Account 2 Dr Cr Chartstring Fund Chartstring AI Chartstring Class Chartstring Dept
Payment 2 Int Cash 1000199   $100.00   790   285 98009
Item type =  2 Receivable   1011010   $(93.50) 149   509 ddddd
680000000xxx 2 Receivable   1011010   (3.50) 860   279 ddddd
2 Receivable   1011010   (3.00) 561 Z61 288 ddddd

CEMLI E-214 - Cash Fund Balancing

Event Step Action Account Account 2 Dr Cr Chartstring Fund Chartstring AI Chartstring Class Chartstring Dept
CEMLI E-214 3 Fund Bal 1000199   $93.50   149   509 ddddd
Line no =  3 Fund Bal 1000199   3.50   860   279 ddddd
“10nnnnn” 3 Fund Bal 1000199   3.00   561 Z61 288 ddddd
Eg:”1037385” 3 Fund Bal   1000199   $(100.00) 790   285 98009

Recharge

Event Step Action Account Account 2 Dr Cr Chartstring Fund Chartstring AI Chartstring Class Chartstring Dept
Recharge 4 Receivable 1011100   $100.00   849   272 ddddd
380000000xxx 4 Int Cash   1000199   $(100.00) 849   272 ddddd

Payment

Event Step Action Account Account 2 Dr Cr Chartstring Fund Chartstring AI Chartstring Class Chartstring Dept
Payment 5 Pmt Cash 1000070   $33.34   790   285 98009
7000000xxxxx 5 Receivable   1011100   $(33.34) 849   272 ddddd

CEMLI E-214 - Cash Fund Balancing

Event Step Action Account Account 2 Dr Cr Chartstring Fund Chartstring AI Chartstring Class Chartstring Dept
CEMLI E-214 6 Fund Bal 1000070   $33.34   849   272 ddddd
See above 6 Fund Bal   1000070   $(33.34) 790   285 98009

Collection agreements work in a manner similar to payment plans.

Moving students to collections is a 2-step process in which all the charges (operating, building, S&A and fees) are ‘paid off’ and a new single collections charge is applied.

  1. Original tuition charges with fund balancing
  2. Pay off original charges with collection agreement item type (690000000xxx) using internal cash (1000199). Since this is a payment item type, it should use 2000030 Student Liability ST as the credit (for any unapplied amounts, which is rare).
  3.  Collection agreement payment fund balanced to original receivable chartstring.
  4. Collection agreement charges applied (390000000xxx) to student account with collections receivable (1010070) and internal cash (1000199).
  5. Payment made by collection agency relieving receivable.
  6. Cash payment is fund balanced to receivable chartstring.

Charge

 Event Step  Action  Account Account 2 Dr Cr Chartstring Fund Chartstring AI Chartstring Class Chartstring Dept
 Charge 1 Receivable 1011010   $93.50   149   509 ddddd
1xxxxxxxxxxx 1 Receivable 1011010   3.50   860   279 ddddd
2xxxxxxxxxxx 1 Receivable 1011010   3.00   561 Z61 288 ddddd
3xxxxxxxxxxx 1 Revenue   4000020   $(93.50) 149   509 ddddd
  1 Revenue   4000020   (3.50) 860   279 ddddd
  1 Revenue   4000020   (3.00) 561 Z61 288 ddddd

Payment

 Event Step  Action  Account Account 2 Dr Cr Chartstring Fund Chartstring AI Chartstring Class Chartstring Dept
Payment 2 Int Cash 1000199   $100.00   790   285 98009
Item type =  2 Receivable   1011010   $(93.50) 149   509 ddddd
690000000xxx 2 Receivable   1011010   (3.50) 860   279 ddddd
2 Receivable   1011010   (3.00) 561 Z61 288 ddddd

CEMLI E-214 - Cash Fund Balancing

 Event Step  Action  Account Account 2 Dr Cr Chartstring Fund Chartstring AI Chartstring Class Chartstring Dept
CEMLI E-214 3 Fund Bal 1000199   $93.50   149   509 ddddd
Line no =  3 Fund Bal 1000199   3.50   860   279 ddddd
“10nnnnn” 3 Fund Bal 1000199   3.00   561 Z61 288 ddddd
Eg:”1037385” 3 Fund Bal   1000199   $(100.00) 790   285 98009

Recharge

 Event Step  Action  Account Account 2 Dr Cr Chartstring Fund Chartstring AI Chartstring Class Chartstring Dept
Recharge 4 Receivable 1011100   $100.00   849   272 ddddd
390000000xxx 4 Int Cash   1000199   $(100.00) 849   272 ddddd

Payment

 Event Step  Action  Account Account 2 Dr Cr Chartstring Fund Chartstring AI Chartstring Class Chartstring Dept
Payment 5 Pmt-Cash 1000070   $33.34   790   285 98009
7000000xxxxx 5 Receivable   1011100   $(33.34) 849   272 ddddd

CEMLI E-214 - Cash Fund Balancing

Event Step Action Account Account 2 Dr Cr Chartstring Fund Chartstring AI Chartstring Class Chartstring Dept
CEMLI E-214 6 Fund Bal 1000070   $33.34   849   272 ddddd
See above 6 Fund Bal   1000070   $(33.34) 790   285 98009

A write-off is the elimination of uncollectible accounts receivable in the college accounting records. An accounts receivable balance represents an amount due to the college. If the individual/entity is unable to fulfill the obligation, the outstanding balance should be written off after collection attempts have occurred.

This does not mean the student no longer owes the debt.  The debt is removed from the college’s account receivables, but if the individual/entity wishes to use the college services in the future, the written-off accounts receivable should be restored.

College staff must be aware of all legal limitations and/or requirements for providing or refusing to provide services to individuals/entities with uncollected receivables.

The write-off of uncollectable receivables must be subject to management review using procedures developed by the college in cooperation with the Attorney General’s Office.

50.30.60.8.a Non-Dischargeable Student Debt

Student educational debt is not dischargeable under any of the bankruptcy laws (Chapter 7, 11 or 13).  These include:

  • An educational benefit overpayment or loan made, insured, or guaranteed by a government agency or made under any program funded by a government or nonprofit agency.
  • Obligation to repay funds received as an educational benefit, scholarship, or stipend.
  • A qualified “educational loan” under the Internal Revenue Code means:
    • Debt incurred solely to pay “qualified higher education expenses” for taxpayer or taxpayer’s spouse or dependent.
    • Qualified expenses mean cost of attendance at Title IV eligible institution.
    • Covers “alternative” or “supplemental” loans, regardless of funding source.
  • Any amount overpaid, such as payment of “educational benefits” for period in which student is not enrolled (e.g. GI Bill benefits, tuition waivers, grant, work study overpayments or benefits funded by a nonprofit like a college foundation).

Educational loan definition

An educational loan is defined as an advancement of funds, credit, or financial accommodations under a contemporaneous, mutual understanding of future repayment. College must quantify and create an obligation to repay the value of the educational benefit actually received, whether or not funds are in fact advanced to the student.

  • Debt incurred solely to pay “qualified higher education expenses” for taxpayer or taxpayer’s spouse or dependent.
  • Qualified expenses mean the cost of attendance at Title IV eligible institution.
  • Covers “alternative” or “supplemental” loans, regardless of funding source.

Educational benefit definition

An educational benefit is defined as any funds received as an educational benefit, including a scholarship or stipend, regardless of funding source. Requires an obligation to repay funds actually received for an educational purpose (e.g. Obligation to refund a scholarship upon early academic withdrawal).

50.30.60.8.b Non-Dischargeable Student Debt Undue Hardship

Nondischargeable student debt can only be discharged based on “undue hardship.”

Debtor must file separate adversary proceedings (requires summons and complaint).

Parents incurring nondischargeable debt for student’s education can also claim undue hardship.

Parents filing for bankruptcy may claim “clawback” of “preferential” tuition payments.

50.30.60.8.c Dischargeable Student Debt Under Bankruptcy

The only debt dischargeable under normal bankruptcy are:

  • Unpaid tuition account
  • Housing and dining charges
  • Mandatory student fees
  • Childcare fees
  • Parking fees
  • Bookstore charge

50.30.60.8.d Legal Advice

Most of the content in this section was adapted from the 2018 presentation by the Washington State Attorney General’s office: The College as Creditor

Colleges should contact their Assistant Attorney General for additional advice.

50.30.60.8.e Accounting for Tuition/Student Account Write-Offs

Prior to writing off student accounts the college should ensure a sufficient balance exists (by fund) in the Allow-Uncollect AR ST (1010110) account as instructed in CLAM 40.50.70.6.

For student accounts a single Item Type exists for write-offs (800000007500), excluding CARES related activity.  The Item Type is configured to use Pick Up Receivable from Charge (PURC) with the allowance and write-off account distributed to the tuition charge chartstring:

This item type is configured:

  • Dr – 790-285-98009 1010110 Allow-Uncollect AR ST
  • Cr - 790-285-98009 1011199 Student Accounts Write-Off Error

When the Item Type is applied to the student account, the allowance account (1010110) is debited for the entire amount using 790-285-98009 and the various receivable accounts are credited using the chartstring of the original charge.

Write-Off with Eligible Receivable Account

 Event Step  Action  Account Dr Cr Chartstring Fund Chartstring AI Chartstring Class Chartstring Dept
 Write-Off  1 Write-Off 1010110 $1388.66   790   285 98009
800000007500   Tuition Rec 1010110   $(878.34) 149   509 ddddd
    Inst Fin Aid Rec 1010110   $(41.70) 860   279 ddddd
    Innov Rec 1010110   $(28.18) 561 Z61 288 ddddd
    Building 1010110   $(124.87) 060 Z60 289 ddddd
    Student Fees 1011020   $(84.50) 148   508 ddddd
    S&A 1010110   $(118.21) 522   264 ddddd
    Student Self Assessed Fees 1011020   $(57.50) 522   264 ddddd
    Student Parking Fee 1011020   $(30.00) 528   252 ddddd
    Student Fee Bookstore 1010060   $(25.36) 524   261 ddddd

Since this entry would result in debits and credits unbalanced at the fund level, the fund balancing CEMLI reverses the allowance entry in Step 1 and applies the allowance to each chartstring from the original chartstring.

Fund Balancing (CEMLI E-214)

 Event Step  Action  Account Dr Cr Chartstring Fund Chartstring AI Chartstring Class Chartstring Dept
 CEMLI E-214 Tuition Rec  1010110 $878.34   149   509 ddddd
    Inst Fin Aid Rec 1010110 $41.70   860   279 ddddd
    Innov Rec 1010110 $28.18   561 Z61 288 ddddd
    Building 1010110 $124.87   060 Z60 289 ddddd
    Student Fees 1010110 $84.50   148   508 ddddd
    S&A 1010110 $118.21   522   264 ddddd
    Student Self Assessed Fees 1010110 $57.50   522   264 ddddd
    Student Parking Fee 1010110 $30.00   528   252 ddddd
    Student Fee Bookstore 1010110 $25.36   524   261 ddddd
    Write-Off 1010130   $(1388.66) 790   285 98009

In the event an eligible write-off account does not exist, the item type will use the 1011199 Student Write-Off Error account as the credit.  When an eligible account is added to the student account, the Write-Off Error account will be reversed, and the eligible receivable account will be credited (as demonstrated above).

Write-Off without Eligible Receivable Account

 Event Step  Action  Account Dr Cr Chartstring Fund Chartstring AI Chartstring Class Chartstring Dept
 Write-Off Write-Off  1010110 $1,388.66   790   285 98009
800000007500  1 Error  1011199   $(1,388.66) 790   285 98009
 CEMLI E-214 Fund Bal  1010110 $1,388.66   790   285 98009
  2 Fund Bal 1010110   $(1,388.66) 790   285 98009

 

Some students might receive benefits through a third-party like Labor and Industries or Veteran Affairs.

Moving tuition charges to a third-party (TPC) is a 2-step process in which all the charges (operating, building, S&A and fees) are ‘paid off’ and a new single payment plan charge is applied to the third party.

  1.  Original tuition charges.
  2. Pay off original charges with payment plan item type (620000xxxxxx) using internal cash (1000199).  This clears the student account of all charges eligible to be paid by Third Party Contract.
  3.  Cash payment fund balanced to original receivable chartstring.
  4.  Third-Party Account charges applied (32000xxxxxxx) to the external organization account (third party) with a receivable (1011xxx) and internal cash (1000199).
  5. Payment made by the third party relieving receivable. If the third party denies any charges, the receivables are cleared and the charges returned to the student account.
  6. Cash payment is fund balanced to receivable chartstring.

Charge

 Event Step  Action  Account Account 2 Dr Cr Chartstring Fund Chartstring AI Chartstring Class Chartstring Dept
Charge 1 Receivable 1011010   $93.50   149   509 ddddd
1xxxxxxxxxxx 1 Receivable 1011010   3.50   860   279 ddddd
2xxxxxxxxxxx 1 Receivable 1011010   3.00   561 Z61 288 ddddd
3xxxxxxxxxxx 1 Revenue   4000020   $(93.50) 149   509 ddddd
  1 Revenue   4000020   (3.50) 860   279 ddddd
  1 Revenue   4000020   (3.00) 561 Z61 288 ddddd

Payment

 Event Step  Action  Account Account 2 Dr Cr Chartstring Fund Chartstring AI Chartstring Class Chartstring Dept
Payment 2 Int Cash 1000199   $100.00   790   285 98009
Item type =  2 Receivable   1011010   $(93.50) 149   509 ddddd
620000xxxxxx 2 Receivable   1011010   (3.50) 860   279 ddddd
2 Receivable   1011010   (3.00) 561 Z61 288 ddddd

CEMLI E-214 Cash Fund Balancing

 Event Step  Action  Account Account 2 Dr Cr Chartstring Fund Chartstring AI Chartstring Class Chartstring Dept
CEMLI E-214 3 Fund Bal 1000199   $93.50   149   509 ddddd
Line no =  3 Fund Bal 1000199   3.50   860   279 ddddd
“10nnnnn” 3 Fund Bal 1000199   3.00   561 Z61 288 ddddd
Eg:”1037385” 3 Fund Bal   1000199   $(100.00) 790   285 98009

TPC Charge

 Event Step  Action  Account Account 2 Dr Cr Chartstring Fund Chartstring AI Chartstring Class Chartstring Dept
TPC Charge 4 Receivable 1011100   $100.00   849   272 ddddd
320000xxxxxx 4 Int Cash   1000199   $(100.00) 849   272 ddddd

TPC Payment

 Event Step  Action  Account Account 2 Dr Cr Chartstring Fund Chartstring AI Chartstring Class Chartstring Dept
TPC Pmt 5 Pmt-Cash 1000070   $100.00   790   285 98009
7000000xxxxx 5 Receivable   1011100   $(100.00) 849   272 ddddd

CEMLI E-214 Cash Fund Balancing

 Event Step  Action  Account Account 2 Dr Cr Chartstring Fund Chartstring AI Chartstring Class Chartstring Dept
CEMLI E-214 6 Bal Fund 1000070   $100.00   849   272 ddddd
See above 6 Bal Fund   1000070   $(100.00) 790   285 98009

50.30.60.9.a Third-Party Payments

Some students might receive benefits through a third party like Labor & Industries or Veteran Affairs.

Moving tuition charges to a third party (TPC) is a 2-step process in which all the charges (operating, building, S&A and fees) are ‘paid off’ and a new single payment plan charge is applied to the third party.

  1. Original tuition charges.
  2. Pay off original charges with payment plan item type (620000xxxxxx) using internal cash (1000199).  This clears the student account of all charges eligible to be paid by Third Party Contract.
  3. Cash payment fund balanced to original receivable chartstring.
  4. Third-Party Account charges applied (32000xxxxxxx) to the external organization account (third party) with a receivable (1011xxx) and internal cash (1000199).
  5. Payment made by the third party relieving receivable. If the third party denies any charges, the receivables are cleared and the charges returned to the student account.
  6. Cash payment is fund balanced to receivable chartstring.

50.30.60.9.b Accounting for Third-Party Write-Offs

Although write-offs of bad debt for Third-Party Contractors are rare, one Item Type exists for write-offs.  The Item Type is configured to use Pick Up Receivable from Charge (PURC) with the allowance and write-off account distributed to the Third-Party charge chartstring:

Write-off for Third-Party Contracts

This Item Type is configured to:

  1. Dr – 1010130 Allow - Uncollectable Other ST
  2. Cr - 1011199 Write-Off Error

In the event an eligible write-off account does not exist, the item type will use the 1011199 Write-Off Error account as the credit.  When an eligible account is added to the Third-Party account, the Write-Off Error account will be reversed and the eligible receivable account will be credited.

Write-Off with Eligible Receivable Account

Write-Off

 Event Step  Action  Account Dr Cr Chartstring Fund Chartstring AI Chartstring Class Chartstring Dept
Write-Off 1 Write-Off 1010110 $100.00   790   285 ddddd
8xxxxxxxxxxx 1 Receivable 1011090   $(93.50) 149   509 ddddd
  1 Receivable 1011090   (3.50) 860   279 ddddd
  1 Receivable 1011090   (3.00) 561 Z61 288 ddddd

CEMLI E-214

 Event Step  Action  Account Dr Cr Chartstring Fund Chartstring AI Chartstring Class Chartstring Dept
CEMLI E-214 2 Fund Bal 1010110 $93.50   149   509 ddddd
  2 Fund Bal 1010110 3.50   860   279 ddddd
  2 Fund Bal 1010110 3.00   561 Z61 288 ddddd
  2 Fund Bal 1010110   $(100.00) 790   285 ddddd

Write-Off without Eligible Receivable Account

Write-Off

 Event Step  Action  Account Dr Cr Chartstring Fund Chartstring AI Chartstring Class Chartstring Dept
Write-Off 1 Write-Off 1010110 $100.00   790   285 ddddd
8xxxxxxxxxxx 1 Error 1011199   $(100.00) 790   285 ddddd

CEMLI E-214

Event Step Action Account Dr Cr Chartstring Fund Chartstring AI Chartstring Class Chartstring Dept
CEMLI E-214 2 Fund Bal 1010110 $100.00   790   285 ddddd
  2 Fund Bal 1010110   $(100.00) 790   285 ddddd

50.20 Student Financials Item Types << 50.30 >> 50.40 Student Financials Accounts