Bad Debt (Write Off)
- Robert Lenk
- Chris Barrett
- Sarah Marciniak
About bad debt (write off)
Your institution may not collect all the charges it bills students because the student simply never pays, defaults on a payment plan or dies. When you no longer expect to receive payment, you’ll “write off” the amount as expected revenue.
Campus Cafe provides two ways to account for bad debt. Consult with an accountant on the option that aligns with your institution’s accounting practices.
The offset transaction option removes the accounts receivable from the student’s ledger and charges the debt to a bad debit general ledger account.
The old account code notation keeps the accounts receivable on the student’s ledger but tells Campus Cafe not to expect it to be paid.
Prerequisites
If using the offset transaction option, create a transaction code for bad debit that ties to your general bad debt ledger account.
Required permissions
Module | Number | Description |
|---|---|---|
Student Financials | 48, 51 | Use an offset transaction to write off debt |
Student Financials | 48 | Use an account code notation to write off debt (or remove code) |
System Admin | 113 | Create old account codes |
Offset transaction
An offset transaction zeros the student's balance and is typically charged to the bad debt general ledger account. If this method is used, the student's balance will be zero, Campus Cafe reports will show the student with a zero balance and the bad debt amount will not appear as an accounts receivable. Reports that sum by transaction code may be utilized to identify write off totals.
If a student with bad debt recorded using this method later makes a payment, the offset transaction will need to be reversed to apply the payment. If not, the student will appear to have a negative balance and be due a refund.
Go to the student’s profile.
Go to Person Selected > A/R-Ledger Card.
Click Add Bill Batch.
In Transaction Code select that code corresponding to bad debt.
In Billing Amount enter the non-collectable balance as a negative number.
In Billing Semester optionally choose a semester.
Optionally enter a Billing Description. For example, noncollectable due to student bankruptcy
Campus Cafe automatically fills the Batch Member with your username. This transaction will be placed in this batch for posting. To place the transaction in an alternative batch, enter the batch name.
In this example, we write off $500 for the Spring 2024 semester. The bad debt will associate with the Bad Debt transaction code and be placed in the CBARRETT bill batch member for posting.Click Save.
The transaction appears in bill batch for posting.
Old account code notation
An Old Account Code notation indicates to Campus Cafe the balance isn’t expected to be collected but preserves the student's balance. Select Campus Cafe reports, including the Accounts and Receivable Trial Balance and the AR Trial Balance - Summary report, will allow the exclusion of students with an old account notation and/or segregate students with the code.
If a student with an Old Account Code notation makes a payment, the student's outstanding balance will decrease by that amount. The school's business processes will determine whether the Old Account Code notation remains or is removed.
Create old account code
Once you create an old account code, you can apply it to multiple students.
You can create multiple old account codes (e.g. collections firm A, collections firm B, write off day program, write off evening program, etc.) to match your institution’s business processes.
Go to Admin > STParm.
In Parameter Code enter SMODCD.
In Parameter Value enter a letter or number as a short description of the code. For example a C for sent to collections.
Click Add.
In Description enter a short name for the notation. For example Collections.
In Long Description enter a long name for the notation. For example Sent to Collections.
Click Save.
Go to Admin > Refresh Data Cache.
Apply old account code to student
Go to the student’s profile.
Go to Person Selected > A/R-Ledger Card.
In Old Account Code select the code.
In Date Acct Became Old select the date the account became non-collectable. The date you select will depend on your institution’s accounting practices. It may be so many days after the original bill, the end of a fiscal year or other defined date.
In this example, we are applying the Collections notation effective June 30, 2024.Click Update Old Code.
Remove old account code from student
If a student pays their outstanding debt, you may wish to remove the old account notation.
Go to the student’s profile.
Go to Person Selected > A/R-Ledger Card.
In Old Account Code select --choose one--.
In Date Acct Became Old delete the date.
Click Update Old Code.
