ctcLink Accounting Manual | 50 Student Financials

50 Student Financials

Sections

50.10 Student Financials Overview
- 50.10.10 Campus Solutions
- 50.10.20 Student Financials (SF) Module/Application
- 50.10.30 Item Types
50.20 Student Financials Item Types
- 50.20.10 Student Financials Item Types – Configuration
  - 50.20.10.1 Student Financials Item Types - Initial Setup
  - 50.20.10.2 Student Financials Item Types - Amount Edits
  - 50.20.10.3 Student Financials Item Types – Miscellaneous
  - 50.20.10.4 Student Financials Item Types – External Awards
  - 50.20.10.5 Student Financials Item Types – Posting Restrictions
  - 50.20.10.6 Student Financials Item Types – Account Types
  - 50.20.10.7 Student Financials Item Types – General Ledger Interface
- 50.20.20 Student Financials Item Type Configuration – Accounting
  - 50.20.20.1 SF Operating Fee (Tuition) Item Type Configuration
  - 50.20.20.2 SF S&A Fee (Tuition) Item Type Configuration
  - 50.20.20.3 SF Building Fee (Tuition) Item Type Configuration
  - 50.20.20.4 SF Mandatory Fee Item Type Configuration
  - 50.20.20.5 SF Miscellaneous Fees Item Type Configuration
  - 50.20.20.6 SF Payment Plans and Adjustments Item Type Configuration
  - 50.20.20.7 SF Miscellaneous Charges and Refund Item Type Configuration
  - 50.20.20.8 SF Clearing Student Receivables Item Type Configuration
  - 50.20.20.9 SF Payment Item Type Configuration Configuration
- 50.20.30 Financial Aid Item Types
- 50.20.40 Financial Aid Second Journal Set
50.30 Student Financials Processes
- 50.30.10 Tuition Charges
- 50.30.20 Pick Up Receivable from Charge
- 50.30.30 Fund Balancing (CEMLI E-214)
- 50.30.40 Accounting Transactions Example
- 50.30.50 Financial Aid Second Journal Set (CEMLI E-218)
- 50.30.60 Student Account Financial Activity
  - 50.30.60.1 Self-Pay
  - 50.30.60.2 Financial Aid Applied
  - 50.30.60.3 Student Refunds
  - 50.30.60.4 Financial Aid Adjustments
  - 50.30.60.5 Waivers
  - 50.30.60.6 Payment Plans
  - 50.30.60.7 Collection Agreements
  - 50.30.60.8 Write-Offs
    - 50.30.60.8.a Non-Dischargeable Student Debt
    - 50.30.60.8.b Non-Dischargeable Student Debt Undue Hardship
    - 50.30.60.8.c Dischargeable Student Debt Under Bankruptcy
    - 50.30.60.8.d Legal Advice
    - 50.30.60.8.e Accounting for Tuition/Student Account Write-Offs
  - 50.30.60.9 Third Party Payments
50.40 Student Financials Accounts
- 50.40.10 Creating Accounts
  - - 50.40.10.1 Creating Student (Customer) Accounts
    - 50.40.10.2 Creating Corporate (Third Party Contractor) Accounts
- 50.40.20 Understanding Student (Customer) Accounts
  - 50.40.20.1 Accessing Student Accounts
  - 50.40.20.2 Customer (Student) Account Main Screen
  - 50.40.20.3 Additional Information – Detail Transactions
  - 50.40.20.4 Additional Information – Due Charges
  - 50.40.20.5 Additional Information – Item Summary
  - 50.40.20.6 Additional Information – Payment Plan
  - 50.40.20.7 Additional Information – Items By Term
  - 50.40.20.8 Additional Information – Items By Date
- 50.40.30 Customer Accounts Account Details
  - 50.40.30.1 Item Details (1, 2 & 3)
  - 50.40.30.2 Payment Line Details (4, 5 & 6)
  - 50.40.30.3 Refunds
- 50.40.40 Account Term vs Item Term
50.50 Financial Aid
- 50.50.10 Types of Grants and Aid
  - 50.50.10.1 Direct Federal Grants and Aid
  - 50.50.10.2 Other Federal Grants and Aid
  - 50.50.10.3 State Grants and Aid
  - 50.50.10.4 Institutional Grants and Aid
  - 50.50.10.5 Local Grants and Scholarships
  - 50.50.10.6 Student Loans
  - 50.50.10.7 Other Funding
- 50.50.20 Financial Aid Item Types
  - 50.50.20.1 Financial Aid Item Type Keywords
  - 50.50.20.2 Financial Aid Numbering Convention
- 50.50.30 Financial Aid Item Type Configuration
  - 50.50.30.1 Initial Setup Tab
  - 50.50.30.2 Miscellaneous Tab
  - 50.50.30.3 Account Types Tab
  - 50.50.30.4 General Ledger Interface Tab
- 50.50.40 Second Journal Set (SJS)
- 50.50.50 Accounting for Financial Aid
  - 50.50.50.1 Funds, Classes and Departments for Financial Aid
  - 50.50.50.2 Financial Aid Source Accounting
  - 50.50.50.3 Financial Aid Transactions
  - 50.50.50.4 Second Journal Set Financial Aid Expenditure Accounts
  - 50.50.50.5 Funds, Classes and Departments for Financial Aid
  - 50.50.50.6 Billing for Financial Aid
- 50.50.60 Student Financials-Financial Aid Reconciliation
  - 50.50.60.1 Financial Aid Reconciliation (a college-wide responsibility)
  - 50.50.60.2 Financial Aid Reconciliation Process
    - 50.50.60.2.a Financial Aid Reconciliation Queries
    - 50.50.60.2.b Running the Financial Aid Query
    - 50.50.60.2.c Running the E214 Query
    - 50.50.60.2.d Identifying the Variances between FA Query and E214 Query
    - 50.50.60.2.e Running the General Ledger Query
- 50.50.70 Drawdown/Billing/Refund Process
  - 50.50.70.1 Department of Education G6 System
  - 50.50.70.2 Student Achievement Council
  - 50.50.70.3 State Board for Community & Technical Colleges
  - 50.50.70.4 Departmental/Internal
  - 50.50.70.5 Other Sources
- 50.50.80 Financial Aid Billing and Banking
  - 50.50.80.1 Creating a One-Time Bill
  - 50.50.80.2 Entering an Express Deposit
50.60 Understanding Third Party (Corporate) Student Financials Accounts
- 50.60.10 Accessing Corporate Accounts
- 50.60.20 Corporate (Third Party) Accounts Screens
  - 50.60.20.1 Corporate (Third Party) Accounts Main Screen
  - 50.60.20.2 Additional Information – Detail Transactions
  - 50.60.20.3 Additional Information – Item Summary
  - 50.60.20.4 Additional Information – Items by Term
  - 50.60.20.5 Additional Information – Items by Date
  - 50.60.20.6 Additional Information – Due Charges
  - 50.60.20.7 Additional Information – Third Party Contract
  - 50.60.20.8 Additional Information – Account Details
- 50.60.30 Account Analysis
50.70 Student Financials Account Analysis
- 50.70.10 Item Line SF ctcLink Query
- 50.70.20 Student Account Query QCS_SF_ITEM_LINE_LOJ_ITEM_SF - Item Line SF Recon to Item SF Example
- 50.70.30 Corporate Account QCS_SF_ITEM_LINE_LOJ_ITEM_SF Query
- 50.70.40 Item SF QCS_SF_ITEM_SF_SUMMARIZED Query
- 50.70.50 Student Account QCS_SF_ITEM_SF_SUMMARIZED Example
- 50.70.60 Corporate Account QCS_SF_ITEM_SF_SUMMARIZED Query Example
- 50.70.70 SF Accounting Line QCS_SF_ACCTG_DETAIL Query
- 50.70.80 SF Accounting Line QCS_SF_ACCTG_DETAIL Query Example
- 50.70.90 SF Accounting Line QCS_SF_ACCTG_LN_SUM_JRNL_ACCT Queries
- 50.70.100 Student Finance and Finance Journal Queries
- 50.70.110 Student Finance and Finance Journal Queries Example
- 50.70.120 Student Refunds
  - 50.70.120.1 Refund Queries
  - 50.70.120.2 Check Refunds
  - 50.70.120.3 Credit Card Refunds
  - 50.70.120.4 Bank Mobile/Electronic Refunds
  - 50.70.120.5 Student Refunds Other Queries
- 50.70.130 Student and External Org Accounts Receivable Ledger
  - 50.70.130.1 Student Accounts Receivable Ledger Query
  - 50.70.130.2 Student Accounts Receivable Ledger BI Publisher Report
- 50.70.140 Student Financials-Financial Aid Reconciliation (pending)
  - 50.70.140.1 SF_FA_Reconciliation Query