Modifying Paid Expense Report Journals

Purpose: Use this document as a reference to modify a paid expense report journal or adjust paid expenses in ctcLink.

Audience:  Finance and Business Office staff

You must have at least one of these local college managed security roles:

  • ZZ Expenses Processing

If you need assistance with the above security roles, please contact your local college supervisor or IT Admin to request role access.

If you have to correct a Grant/Project related paid expense, please see QRG Correcting Grant/Project Accounting Entries in T & E (Travel and Expense - Journal Expense Report).

Modifying Paid Expense Report Journals or Adjusting Paid Expenses

Navigation: Travel and Expenses > Manage Accounting > View/Adjust Accounting Entries > Adjust Paid Expenses

  1. The Journal Expense Report search page displays.
  2. Enter or lookup the Empl ID.
  3. Select the Add button.
  4. The Modify Journal Entries for An Expense Report page displays.  Use these journal entries to correct errors and make adjustments to expense report payments, which will synchronize the expense system with the general ledger.
  5. Select the magnifying glass to the right of Journal Report ID, to search for and select the Expense Report you want to modify.
  6. Enter a Report Description.
  7. Select the checkbox for your expense line.
  8. Select the Expense Type link for your expense line(s) you want to modify.
Select expense type link
  1. The Accounting Detail page displaying accounting distribution details.
  2. Select the Add button to add a row for additional adjusting entries.
  3. Select the Add button again, so that you now have 2 new rows (there will be a total of 3 blank rows, including the 1 row that the system auto generates)
Select the Add button to add new rows

Note: Every Journal Expense Report requires a total of at least 4 distribution lines. Journal Expense Reports are not “paid”, but journal entries will be generated. The Cash Lines need to be added in order to move the cash with the expense.

For example:

  1. Expense Line (Reversal of Original Entry and auto generated by system).
  2. Expense Line (New Entry, correcting original Entry)
  3. Cash Line (Off-set of Reversal of Original Entry line, coded to 1000199).
  4. Cash Line (Off-set of New Entry, coded to 1000199).
  1. Enter valid ChartFields values on all lines, making sure to add Cash Lines as instructed in Note above.
  2. Enter appropriate Amounts, so that the sum of all lines equals 0.00.
  3. Select the OK button.
Enter valid chartfield values and select ok

Note: Be cautious when entering the new chartfield values (it’s recommended to double check your chartstring), as currently there is no way to update the values, if entered incorrectly and Submit for Posting is selected.

If the Journal Expense Report fails budget checking due to an incorrect ChartString, you must submit a SD ticket to have the ChartField values updated by our technical team. We are working on an alternative solution with Oracle, but we do not have a time frame on when an alternative solution will be offered.

  1. The Accounting Detail page disappears. Optional to add comments in the Notes section.
  2. Select Submit for Posting.
add a note and select submit for posting
  1. Budget check will run, stay on this page until you see that it has completed successfully.
  2. If a Pop Up message appears, indicating that Budget Checking Errors Exist, close the pop up window to return to the Modify Journal Entries for an Expense Report Page.
  3. You are not able to correct the chartstring if an error exists. Record the new Report ID, close out the page and submit a Service Desk Ticket requesting a manual update to the Chartfield values for the new Report ID.
Budget Checking errors example
  1. If Budget checking is successful, now you are ready to Post Liabilities for the new Journal Expense Report.
  2. Navigation: Travel and Expenses > Process Expenses > Expense Processing
  3. The Expense Transactions run control ID search page displays.
  4. If you have run this process or report in the past, select the Find an Existing Value tab to enter an existing Run Control ID and select the Search button. If this is the first time running this process or report, select the Add a New Value tab to create a new Run Control ID and select the Add button. 
    • NOTE: It is important to note that Run Control IDs cannot be deleted. Do not include spaces in your Run Control. We encourage the Run Control ID to have the same process naming convention but unique to the step; because of this, including your institution code and a short process description in the Run Control ID is recommended--e.g., WA020_POST_LIAB (College, Process).
  5. The Expense Processes tab displays. Select the Selected Business Units tab.
  6. On the Selected Business Units tab page, enter the Business Unit.
  7. Select the Expense Processes tab.
Add business unit and select expense processes tab
  1. The Expense Processes tab displays. Select the Save button.
  2. Select the Refresh button.
  3. Select the Post Liabilities checkbox.
  4. Select the Run button.  Please refer to the QRG Process Scheduling/Process Monitor for further instructions.
Expense processing main page

When you process the journal expense reports, the system rolls back the original accounting entries and posts the new entries. This corrects the general ledger to reflect the same entries that exist in the expense system.  If you use Commitment Control, you must run budget checking to reverse the entries in the Commitment Control ledgers.

  1. Process complete.

Video Tutorial

The video below demonstrates the process actions described in the steps listed above. There is no audio included with this video. Select the play button to start the video.

Video Tutorial Via Panopto

View the external link to Modifying Paid Expense Report Journals. This link will open in a new tab/window.

0 Comments

Add your comment

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.