What is an Item Type?
Item types are the basic work unit of the Student Financials application.
Each item type defines and describes a unique action. The item type
setup differentiates between charges and credits and defines how and where
each can be applied. It also groups them by classification and determines
how the system uses them to transfer student account information to the
general ledger.
How can I get a list of
my department��s item types?
Login to PeopleSoft Student System and run query UHS_GA_SF_ITEM_TYPE_LIST.
What is FIXIT process?
Departments will see differences in revenues and expenses reported for the
Fall semester. The student system does not recognize fiscal periods –
transactions post on the date they occur (once tuition/fee calculation
begins for a term). In the student system, tuition and fee
calculations for a Fall semester begin earlier than September 1 (the
beginning of a new fiscal year).
Rather than have those Fall transactions post in the old fiscal year, the
PS Finance system runs a process called FIXIT that identifies all Student
System-feed transactions with the new fiscal year budget period and posts
Net Tuition & Fee Revenues (Tuition & Fee Revenues less Waiver
Expenses) as Deferred Revenues and posts Expenses (mostly Scholarships
& Grants) as Prepaid Expenses. The FIXIT process reverses the Deferred
Revenues and Prepaid Expenses on September 1 (the first day of the new
fiscal year), moving the Deferred Revenue back to Revenue and Prepaid
Expenses back to Expense.
How can I get detailed
transactions for FIXIT Journals?
• Login to PeopleSoft Student Financials and run
query UHS_GA_FIXIT_SF_JRNL_DETAIL
What queries or reports
are available in PS Finance to help me understand the impact of student
system transactions on my cost center?
• Student Financial Accounting report
Navigation: Custom Reports> Student Financials> Student Financial
Accounting.
Results are available in .PDF or .CSV
format.
• UHS_PSSA_DETAIL_DEPARTMENT – Public query which
lists PS student system detail
by DeptID/EmplID
• UHS_PSSA_SUMM_DEPARTMENT – Public Query which
lists PS student system summary transactions
by DeptID
What is Bad Debt?
A bad debt is an accounts receivable which will likely remain uncollectable
and will be written off. The University of Houston makes an estimate
of bad debt that might be incurred in the current time period based on past
records as part of estimating a bad debt allocation rate. This
historical average (bad debt allocation rate) is used in the monthly bad
debt allocation process which debits departmental revenue and credits the
bad debt reserve account, thereby spreading the cost of anticipated bad
debt equitably.
When student receivables are written off, the receivable is credited and
the bad debt reserve account is debited. As part of the
write-off process, service indicators are placed on student accounts.
The impacts of the bad debt service indicator (B13) are to block:
- Transcripts
- Enrollment
Verifications
- Adding of
classes
- Refunds
A student, who wishes to clear their bad debt and have the B13
service indicator removed, should contact Student Business Services.
What are bad debt
allocation journals and what is bad debt allocation rate?
The monthly bad
debt allocation processes run during month-end closing in PeopleSoft Finance. Bad debt entries from the monthly
bad debt allocation process are not found in PS Student Financial
Accounting Entries (SF_ACCTG_LNs).
The monthly bad debt allocation
process creates journals beginning with BDEBT:
��
Debit revenue and credit the bad debt
reserve account
��
Up to 9
journals , for different types of Student revenues (tuition, designated
tuition, student service fees, other fees, and for various revenues earned
by auxiliary departments)

Monthly Bad
Debt Journals
��
SA Bad Debt – Designated Tuition
o
Based on 00730 revenue in GL
Accounts 40300-40499
o
Creates GL entries:
��
40302 (debit) - BAD DEBTS-DESIGNATED
TUIT-REV
��
12502 (credit) - A/R BAD DEBT RESERVE
��
SA Bad Debt – Loan Collect Fee
o
Based on 00730 revenue GL Accounts 40980 - 40999
o
Creates GL entries:
��
40980 (debit) - BAD DEBTS - OTHER LN/COLL
FEES
��
12502 (credit) - A/R BAD DEBT RESERVE
��
SA Bad Debt – Other Fees
o
Based
on 00730 revenue in GL Accounts
40700-40979, 41001-41099, 40789, 55500-57999
o
Creates GL entries:
��
40754 (debit) - BAD DEBTS-OTHER FEES-REV
��
12502 (credit) - A/R BAD DEBT RESERVE
��
SA Bad Debt – Tickets
o
Based on 00730 revenue in GL Account 44263
o
Creates entries GL Accounts:
��
44260 (debit) - PARKING BAD DEBT EXPENSE
��
12502 (credit) - A/R BAD DEBT RESERVE
��
SA Bad Debt – Student Permit
o
Based on 00730 revenue in GL Accounts 44264
o
Creates entries GL Accounts:
��
44260 (debit) - PARKING BAD DEBT EXPENSE
��
12502 (credit) - A/R BAD DEBT RESERVE
��
SA Bad Debt – Towing
o
Based on 00730 revenue in GL Account 44265
o
Creates entries GL Accounts:
��
44260 (debit) - PARKING BAD DEBT EXPENSE
��
12502 (credit) - A/R BAD DEBT RESERVE
��
SA Bad Debt – RLH Billed
o
Based on 00730 revenue in GL Accounts 44180-44199
o
Creates entries GL Accounts:
��
44180 (debit) - HOUSING BAD DEBT
��
12502 (credit) - A/R BAD DEBT RESERVE
��
SA Bad Debt – Stu Service Fees
o
Based on 00730 revenue in GL Accounts 40500 - 40699
o
Creates entries GL Accounts:
��
40501 (debit) - BAD DEBTS-STU SERV FEE-REV
��
12502 (credit) - A/R BAD DEBT RESERVE
��
SA Bad Debt – Tuition
o
Based on revenue in GL Accounts in
40100-40299
o
Creates entries GL Accounts:
��
40107
(debit) BAD
DEBTS-TUITION-REV
��
12502
(credit) - A/R BAD DEBT RESERVE
Current fiscal
year bad debt rate for tuition, designated tuition, other fees and student
services fees is 1.2%.
Transfer of
Revenue between Cost Centers (tuition, fee , waivers/exemptions and
associated bad debt)
When tuition, fee and waiver/exemption transactions are
moved from one cost center to another, the associated bad debt is
automatically moved when the scheduled month-end bad debt allocation
processes run.
When moving revenue in the GL Accounts (listed above) on
which bad debt is calculated by the month-end bad debt allocation
processes, do not move bad debt manually.
If bad debt has a rounding error (usually a penny or
two) after it reverses itself, please submit the cost center��s 1074 to
Karin Livingston. Request that
Accounting Services correct the rounding error during the next month��s
close.
When a cost center is to be closed, leave the cost
center open through month-end closing , so that the bad debt allocation
journals created by the bad debt allocation process (due to movement of
tuition and fees) can
successfully post to the General Ledger.
When can I write-off an
accounts receivable?
Accounts receivable is eligible for write-off when 2 years old.
|