ctcLink Reference Center9.2 Finance9.2 FIN - ExpensesExpense Processing9.2 Correcting Grant/Project Accounting Entries in T & E (Travel and Expenses - Journal Expense Report)

9.2 Correcting Grant/Project Accounting Entries in T & E (Travel and Expenses - Journal Expense Report)

Purpose:  Journal Expense Reports are used to adjust accounting entries for expense that have been posted and paid, and whose payments have been posted.  Journal expense reports are not associated with changes to monetary amounts, nor do they create any payments. You process journal expense reports to correct accounting entries that have already been recorded in General Ledger.

Audience:  EX Administrator.

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.

Scenario: A Expense report has been created using an incorrect Chartfield string, and is posted and paid. To avoid making a manual General Ledger entry, we simply enter a Journal expense report in Travel and Expense module. On the journal expense report, we reverse the amount to the incorrect Chartfields and add the amount to the correct Chartfields. This will keep the General Ledger and T&E in sync.

Example: Expense report 0000003297 (BU WA220, Employee 101007416) has been entered incorrectly with project ID 0000001589, and is posted, paid and GL distributed. The project id should be 0000001783. Therefore, to correct the project ID we will create Journal expense report in T&E module.

Correct Grant/Project Accounting Entries in T & E

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

In order to create a Journal expense report, you must first know the Employee ID associated with that expense report and original Expense Report ID that requires an adjustment.

Step 1:  Create Journal Expense Report
  1. The Journal Expense Report search page displays.  You can search for an Empl ID by selecting the Look Up button next to the field.  (For this example, 101007416)
  2. Select Add.
Journal Expense Report Add a New Value tab
Step 2:  Select Original Expense Report to Correct
  1. The Journal Expense Report page displays.  In the Journal Report ID field, enter the original expense ID that requires an adjustment. (Available expense IDs are those that are associated with employee IDs.  For this example,  0000003297 was used).
  2. Enter valid value in the Report Description field.
  3. Select the Select check box so that it contains a checkmark.
  4. Select the entry in the Expense Type column to view and/or modify the the ChartField for the expense.
Modify Journal Entries for An Expense Report page
Step 3:  Enter Correct Accounting (ChartFields) Detail

This page displays the selected journal expense report line item and its associated ChartFields. A row displays a reversing entry that the system automatically created. You can modify the entry and create additional entries if necessary.

Modify the ChartFields to reflect the correct expense charges. If you charge the line to more than one set of ChartFields, adjust the amount to reflect the appropriate portion for these accounts.

All of the distribution amounts added together must equal zero for the expense line.

Accounting Detail page
  1. Select OK.
Step 4:  Submit for Posting
  1. The Modify Journal Entries for An Expense Report page displays.  
  2. Select the Select check box so that it contains a checkmark.
  3. Select Submit For Posting.
Modify Journal Entries for An Expense Report page

The system may take several moments to process your request. If you have budget checking Warnings or Errors, you will receive a message.  Remember that you can still proceed with posting if a warning message is received, but Error messages must be resolved before posting.

  1. The updated Modify Journal Entries for An Expense Report page displays.  Note that the Submit for Posting button is grayed-out and unavailable.  Note that the Report ID has been populated.
Modify Journal Entries for An Expense Report page
Step 5:  Post Liabilities

Navigation: Travel and Expenses > Process Expenses > Expense Processing

  1. The Expense Transactions run control ID search page displays.  Open existing Run Control ID or create new. (If you are creating new run control page then select your BU in “Selected Business Units” tab).
Expense Transactions run control ID search page
  1. The Expense Processes page displays.
  2. You will see count in Post Liabilities.
  3. Select “Post Liabilities” check box.
  4. Select Run.
  5. The process will run in background and after it has run successfully, you can see the accounting entries in Travel and Expense module. The Journal generator process must be run in order to move the accounting entries in GL.
Expense Processes tab
  1. Process complete.

Video Tutorial

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

Video Tutorial via Panopto

View the link to Correcting Grant/Project Accounting Entries in T & E (Travel and Expenses - Journal Expense Report). 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.