| Table of Contents | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
About the
...
student A/R
...
ledger
The student A student’s A/R (accounts receivable) ledger shows financial transactions associated with a student. You’ll see transactions for items like tuition, housing, payments, financial aid and refunds.
You can also see transactions associated with the student 's account. Transactions may be read only depending on the source of the batch (Financial Aid) or the general ledger last posting date setting (Accounting > GL Control).
Access Student A/R Ledger
Navigate to the student
Click Financial
Click Ledger Card
...
that don’t appear as an accounts receivable for the student. For example, a credit card convenience fee that’s collected from the student but isn’t credited to the student’s account.
Prerequisites
Transaction codes created.
Required permissions
Module | Number | Description |
|---|---|---|
Student Financials | 48 | View student ledger |
Student Financials | 1167 | Edit or delete a ledger transaction |
Student Financials | 51 | Add billing charge and go to bill batch from ledger (grants access to bill batch) |
Student Financials | 52 | Add payment and go to cash batch from ledger (grants access to cash batch) |
Student Financials | 48 | Use an account code notation to write off debt (or remove code) |
View ledger
Go to the student’s profile.
Go to person selected > A/R-Ledger Card.
Select a view.
Show A/R Only:
...
Campus Cafe selects this by default to show all transactions related to the student that impact the
...
student’s accounts receivable balance and appear on the
...
student statement.
Show Non-A/R Only:
...
Select this to show only transactions that
...
don’t impact the student's accounts receivable.
...
For example, an application fee or credit card
...
convenience fee. Campus Cafe displays both sides of the transaction. If a payment
...
includes both an AR transaction and Non-AR transaction, the amount shown as Non-AR is the portion of the payment not applied to AR. For example in the case of a credit card payment
...
with a the convenience fee, the payment
...
Go to Overall Billing Batch: Opens the global bill batch screen
Add Bill Batch: Add a new transaction for the student that will then appear in bill batch for posting
Go to Overall Cash Batch: Opens the global cash batch screen
Add to Cash Batch: Add a new payment transaction for the student that will then appear in cash batch for posting
Update Old Code: Use in conjunction with the Old Account Code and Date Acct Became Old box to indicate a delinquent account
...
itself would show as AR and the convenience fee as Non-AR.
Ledger actions
You can quickly bill, add payments or write off student accounts directly from the ledger. You can also jump to other parts of Campus Cafe to complete additional actions.
The actions appear at the top of the page.
...
Unposted Bill Batch Total: Shows the total amount billed to the student not yet posted through bill batch. These charges won’t appear on the ledger or student statement until you run bill batch. Clicking the number shown brings you to the bill batch function so you can post the transactions. In the example above the student has $75 in charges to be posted.
Add Bill Batch: Click to add a charge for the student. The charge enters bill batch for posting.
Unposted Cash Batch Total: Shows the total payments collected from the student not yet posted through cash batch. These charges won’t appear on the ledger or student statement until you run cash batch. Clicking the number shown brings you to the cash batch function so you can post the transactions. In the example above the student has $25 in payments to be posted.
Add Cash Batch: Click to add a payment from the student. The payment enters cash batch for posting.
Old Account Code and Date Acct Became Old: Campus Cafe provides two ways to record noncollectable debt. If you’re using the old account code notation, select the old account code and select the date the debt was written off. Click Update Code to apply the code. This doesn’t create a ledger entry. If you need a ledger entry, use an offset transaction instead.
Balance Forward Date: Campus Cafe shows only transactions dated after this date and updates the running balance to include only transactions from this date forward. After selecting a date, click Update Balance Forward Date. The default date is set using AR Control.
Go to Fin/Aid Page: Opens Click to see the student's financial aid transactions screen
Ledger Card
A list of transactions related to the student's account appears. Information shown includes the transaction date, A/R code, transaction source, description, amount and semester among other information. For accounting purposes, the system creates two entries in the database such as Title IV awards and scholarships.
Export Ledger Table: As with all grids in Campus Cafe, the option to Copy (copy csv grid to the clipboard), Export to Excel, Export to PDF, and Print (generate a printer-friendly version of the page) is included. For the Ledger table grid, the PDF and Print versions include the student’s name and ID number at the top of the first page; and the default file name for Excel, PDF, and Print include the student’s name and ID Number.
Ledger details
The ledger includes a table of individual transactions associated with the student. For accounting purposes, Campus Cafe creates two entries for each transaction, however, only one is visible to the userwhen Show A/R Only is selected. If this a transaction is editedchanged, its partner transaction is automatically updated.
Row Color: Transactions in orange represent are payments. Transactions in blue are non A/R transactions.
Transaction Date: The date associated with the transaction that appears on the student's billing statement.
A/R Code: A code that identifies the accounts receivable transaction type. May not be changed. See below for detail.
Transaction Source: A code that indicates how the transaction was generated.
1 = Group
...
billing charge
blank = manual billing transaction
F = financial aid module
R =
...
cash receipt
Invoice#: A system Campus Cafe-generated number distinct to the specific transaction. May not be changed.
Transaction Code: This code is used to identify Identifies the type of transaction and also indicates the general ledger account associated with the transaction. See transaction code documentation.
Description: Text that details the transaction, by default the text that describes the transaction code.
Amount: The amount of the specific transaction.
Running Balance: The sum of all prior transactions and the current transaction.
Semester: The academic period associated with the transaction.
Sub-Sem: Not in use.
Course: The specific course associated with the transaction (e.g. the course associated with the course fee).
Check Number/CC: A check number associated with the transaction. For institutions using the Campus Cafe accounting module to generate student refund (credit balance) checks, the check number will automatically populate.
PET#: The project expense tracking number to associate the entry with a specific initiative initiative.
Sponsored: This field either contains the organization associated with the entry or in the case of a Sponsor, the student The organization associated with the entry. For example, the organization that plans to pay the billing entry charge or the organization that made a the payment. (On the A/R Detail page click Lookup Sponsor to locate a sponsor.)
Additional Description: Text that further details the transaction.
Award Year: For financial aid transactions, the aid year.
Award Code: For financial aid transactions, the code associated with the financial aid transaction. See create award codes.
Award Disb. Seq#: For financial aid transactions, a number to identify the specific disbursement.
System Batch #: The number generated by the system Campus Cafe when the transaction was posted through bill batch.
A/R
...
codes
The A/R codes that appear on the student ledger and are automatically generated by the system and may not be edited.
Balance Forward
...
shown are delivered by Campus Cafe and can’t be changed.
A/R Code | Usage | Description | |
|---|---|---|---|
BF | Balance forward | Sum of all transactions prior to the Balance Forward Date specified at the top of the page. | |
CH | Charge | Billing |
...
A credit in the transaction amount column and the general ledger account would be a revenue account |
...
. |
IN |
...
Invoice | Billing | A debit in the accounts receivable credit amount column and the general ledger account would always be the Accounts Receivable account specified in GL Funds (e.g. 11000). |
...
Note entries could be the opposite if you were reversing a charge such as tuition. This is done by changing the sign on the transaction.
Payment codes
...
CR | Credit | Payments | A debit in the transaction amount column and the general ledger account would be the cash account (e.g. 10000). |
...
These are not visible on the Show A/R portion of the ledger card. The Show Non A/R |
...
shows this side of the transaction. |
PM |
...
Payment | Payments | A credit in the accounts receivable credit amount column and the general ledger account would always be the Accounts Receivable account specified in the GL Funds. (e.g. 11000). | |
OA |
...
Other amount | Payments | Optional debit or credit to another general ledger account. These amounts will never appear on the A/R portion of the ledger card. They will appear under the Show Non-A/R section. | |
MI | Miscellaneous | Miscellaneous |
...
A debit in the transaction amount column and the general ledger account would be a the cash account. |
...
This doesn’t appear on the A/R portion of the ledger card. |
OA |
...
Other amount | Miscellaneous | A credit in the transaction amount column and the GL account would always be what is entered in the offset. |
...
This doesn’t appear on the A/R portion of the ledger card. |
Edit Transaction
...
Change transaction
If a transaction needs to be changed, reversing the transaction and then creating a new transaction is typically the recommended accounting method to preserve your financial history and audit ability.
However, you can change certain non-monetary elements of a transaction. For example, you can change the semester associated with a payment but not the amount of the payment. This restriction helps prevent fraud and reconciliation errors.
Date limitation
Transactions posted after July 1, 2021
...
can’t have their dates changed to a date prior to July 1, 2021.
Transactions posted prior to July 1, 2021
...
can’t have their dates changed to a date after July 1, 2021.
Next to the transaction to edit, click the pencil.
Once transactions are posted or the general ledger close date has passed, certain elements of transactions may not be edited or the transaction deleted. The close date is determined by the last posting date in GL Control.
Delete Transaction
Permission #1167 is required to access this function.
...
| Note |
|---|
Use caution when changing transactions as they may have been previously reconciled or otherwise included on reports. |
Go to the student’s profile.
Go to person selected > A/R-Ledger Card.
Next to the transaction to
...
change, click the
...
pencil.
Make your changes and click Save.
Reverse
...
transaction
Rather than delete If a transaction , there may be a need to reverse a previously posted transactionwas posted in error, you can reverse it. This preserves the history of the transaction while offsetting the monetary amount. the For example, if a posted check is later returned for insufficient funds.
Reverse a Payment
While on the student's A/R ledger screen click Go to the student’s profile.
Go to person selected > A/R-Ledger Card.
Click Add Bill Batch.
Choose a transaction code (this Select a Transaction Code. This may be the same transaction code as the original payment or a different transaction code.
In Billing Amount enter a negative amount. (e.g. -100 for a $100 transaction)
Optionally enter a Billing Description. (e.g. Payment reversed for insufficient funds)
In the Billing Amount enter a negative amount (e.g. -100 for a $100 transaction)
Click Save
Post the Bill Batch
Click Save.
The transaction is transferred to bill batch for posting.
Delete transaction
If the transaction was posted in error, reversing the transaction and then creating a new transaction is typically the recommended accounting method to preserve your financial history and audit ability. Deleting a transaction removes it entirely from Campus Cafe and can make future reconciliation difficult.
To delete a transaction, the transaction date must be after the general ledger Last Post Date. (Accounting > GL Control).
| Note |
|---|
Use caution when deleting transactions as they may have been previously reconciled or otherwise included on reports. |
Go to the student’s profile.
Go to person selected > A/R-Ledger Card.
Next to the transaction to delete, click the X.
