This guide will cover:

• Information

• Location of IDT Template Form

• Saving the IDT Form

• Overview of the IDT Journal Form

  • Revenue Department Steps

  • Expense Department Steps

• Reviewing and Submitting the IDT Form

• Looking up the IDT in the WyoCloud Financial Management System

• Correcting an IDT

• Appendix

  • Pilot Program  -- Fall 2019

  • Workflow Diagrams

 

Information

Interdepartmental Transfers (IDTs) provide a way for UW departments to purchase goods and/or services from other departments on campus.  This process initiates a journal entry transaction that transfers funds between budget account strings within the WyoCloud Financial Management System.  The funds do not leave the university and IDTs do not process through an approval workflow.  Departments should ensure proper internal controls for processing and tracking IDTs are observed.

The transfers may be made between units within one college/division or between separate colleges/divisions. Examples of IDTs include departments paying Fleet Services for the rental of vehicles; departments paying UW Operations for services; or departments paying for food services from catering. IDTs can not be completed to credit a Foundation Fund Source.

IDTs are budgeted and processed within Natural Account Codes 76001-76601 (Interdepartmental charges and credits) based on the nature of the transaction.  The Expense Class should always be 001 (default) for funding that is not associated with sponsored program funds on IDTs.

The IDT process begins with the department providing the good/service (i.e., the revenue-receiving department). The revenue-receiving department should initiate the IDT and email the IDT with any appropriate invoices to the Expense department.

 

Step One  

Locating and Downloading the IDT Template Form

• The IDT Form is found on the Financial Affairs Website under Forms and within the Accounting Office section.

• Choose from two options:

  • IDT Form (8 lines for General Ledger and 8 lines for Sponsored Projects)

  • IDT Long Form (10 lines for General Ledger and 15 lines for Sponsored Projects)

 

• Click on the IDT Form to download the form for use.

  • Depending on your browser, the file will either open in an Excel pop-up window where you can select to open immediately or save the file based on your preference, or the file will appear in the downloads section of your browser

 

• The file will open in protective view. In the yellow ribbon at the top of the excel workbook, click Enable Editing.

 

Step Two

Saving the IDT Form

• The revenue-receiving department will begin by saving the file using the naming convention outlined below: MMYYDEPT#####IDT

  • MM - based on the calendar year with January beginning at 01, February 02, etc.

    • The month is based on the date the IDT is being completed by the revenue department. For example 0923DEPTXXXXIDT is for an IDT being completed in September 2023.

  • YY - based on the calendar year with January 2023 through December 2023 equal to “23”

  • DEPT – the abbreviated department name providing the good/service (e.g., Copy for Copier Services, USTORE for University Store, etc.)

  • ##### - four digits using a numbering sequence that begins with 1 each month and increases in increments (e.g., 0001, 0002, 0003, etc.)

  • IDT – the term IDT should conclude the name to keep these journal entries easily distinguished from any others.

• Complete examples of names include: 0520COPY0001IDT, 0520COPY0002IDT, 0520COPY0003IDT, etc.

 

It is recommended not to save the IDT Template on a computer’s hard drive for repeated use because changes may occur to its design.

 

Step Three

Overview of the IDT Form

The IDT spreadsheet provides general department/submitter information as well as budget funding information to complete the transaction.  All sections must be completed as follows:

Revenue Department Steps

• The revenue department begins the process of creating the IDT Journal Spreadsheet.

• Enter the IDT number in the red box using MMYYDEPT#####IDT. The red box will turn yellow once the IDT number is entered.

• Complete the revenue department portion of the IDT journal header information – all fields are required

• Date – current Date

• Department – name of the department

• Submitter – name of the person completing the form

• Submitter Email – email of the person completing the form

• Submitter Phone – phone number of the person completing the form

• Description of Transaction – The reason for the IDT transaction. This description may be brief, but should also provide enough detail for individuals to understand the IDT’s purpose. Details such as number(s) are also appropriate to include here.

• Complete the Journal Lines for the Revenue-Receiving department – if using GL Funding (Unrestricted, Designated, etc.) all fields are required except Notes:

• Entity – Chart of accounts segment for entity. This is a drop-down list with the avaliable options.

• Account – This is a drop-down list with Natural Account Codes (Internal Allocation & Sales) related to IDTs such as:

  • 76001 - Internal Service Allocation: Plant Operations (UW Operations Dept Only.)

  • 76002 - Internal Service Allocation:  Info Tech (IT Only)

  • 76003 -  Internal Service Allocation:  Other

  • 76601 -  Internal Sales Auxiliaries (e.g., Fleet Services, Residence Life and Dining Services & University Store)

• Fund Class – Chart of accounts segment for fund class

• Fund Source – Chart of accounts segment for fund source

• Organization – Chart of accounts segment for organization

• Exp. Class – 001 will autofill once Organization has been entered.

• Program – Chart of accounts segment for program if used by your department. Must be 4 digits.

• Activity – Chart of accounts segment for activity if used by your department. Must be 4 digits.

• Future – Chart of accounts segment for future. This will autofill once Organization has been entered.

• Currency – USD will autofill once Organization has been entered.

• Revenue – Complete credit amount for each GL account.

• Notes - This field is not required. You may enter any information to help identify the goods or services.

• **Make sure the IDT Credit Total matches the support invoice(s) total.

• **If a project is receiving the revenue, enter the applicable fields within the Sponsored Projects Journal Line entries section. **

 

Multiple journal lines can be entered if the expense department is the same for each journal line

 

• Once the revenue portion of the IDT is complete, email the file along with the supporting invoice(s) to the expense department.

 

Expense Department Steps

• The expense department receives the email from the revenue department with the IDT Journal Spreadsheet and supporting invoice(s). The expense department completes the same header information as the revenue department (purple section).

 

If the expense is being charged to a non-grant account, the expense department completes the journal lines for non-project expenses using the Internal Service or Internal Sales account.

 

For General Ledger (GL) Funding:

• Required fields to complete if using GL Funding (Unrestricted, Designated, etc.)

• • Entity – chart of accounts segment for entity. This is a drop-down list with the available options.

  • Account – replicate the Revenue Department’s 76xxx Natural Account Code

  • Fund Class – chart of accounts segment for fund class

  • Fund Source – chart of accounts segment for fund source

  • Organization – chart of accounts segment for organization

  • Exp. Class – 001 will autofill (once Organization has been entered) as IDT’s represent an internal transfer of funds

  • Program – chart of accounts segment for program if used by your department. Must be 4 digits.

  • Activity – chart of accounts segment for activity if used by your department. Must be 4 digits.

  • Future – chart of accounts segment for future. This will autofill 0 once Organization has been entered.

  • Currency – USD will autofill once Organization has been entered.

  • Expense – complete Debit amount for each GL account string entered.

  • Notes- this field is not required. You may enter any information to help identify the goods or services.

 

For Sponsored Project Funding

• If the expense is being charged to a sponsored project, the expense department will complete the POET information at the bottom of the form.  

• Required fields to complete include:

  • PPM Reference - This will automatically fill from the IDT number entered above.

  • Project # - The unique number assigned to the sponsored project.

  • Organization Name – Project Organization name of the UW department assigned to the specific project (from PPM).

  • Expenditure Type Description – This is a drop-down list. Refer to the grant expenditures crosswalk to look up Expenditure Type using a Natural Account or Category.

  • Task Number – always 1

  • Expenditure Item Date – Date the goods or services were recieved. If this was a span of dates, use the last date of the period.

  • Debit – The amount to charge to the project

• The expense department reviews General Ledger and POET Balancing Control section of the Journal Lines General Ledger Accounts to ensure the revenue and expense accounting lines balance. If the IDT balances, the totals will turn green and the word "Balances" will appear. If the IDT does not balance, the toals will turn red and the phrase "TOTALS DO NOT MATCH" appears. Make corrections until the IDT balances.

Step Four

Reviewing and Submitting (Emailing) the IDT Form

• Review to ensure all information has been entered on the form.

• Next, check to make sure the IDT Debit and Credit totals match each other.

• General Ledger and POET Balancing Control sums the subtotals from the General Ledger section and the Sponsored Project section. These debit and credit fields MUST match each other (example from above 50.00 Debit & 50.00 Credit).
• Once the Balancing Control fields are reviewed, the expense department will email the completed Spreadsheet and supporting documentation to IDT-Accounting@uwyo.edu.
  • The expense department should Carbon Copy (Cc) the Revenue Dept/individual that emailed the IDT to you so that they know it has been completed.
• Upon receipt of the completed IDT Spreadsheet and invoice(s), the files are reviewed for accuracy and uploaded into the WyoCloud Financial Management system by the Accounting Office.

Step Five

Looking up an IDT in the WyoCloud Financial Management System

An IDT cannot be accessed or displayed in the WyoCloud Financial Management System until it has been processed and posted by the Accounting Office. If the IDT you are looking up does not appear, reach out to the appropriate department (expense department or accounting office) to confirm receipt of the IDT.

• Upon logging into WyoCloud, click on the Navigator in the upper left corner of the homepage.

• First, click on General Accounting to expand (you may have to scroll within the Navigator), then select Journals.

• The Journals page is displayed. Click on the Task Menu on the right of the screen, then Manage Journals.

• In the Manage Journals page, search for the desired IDT (*indicates the preferred field). You must complete at least one of the following search fields:

• *Journal – this field contains the name assigned when the IDT form was saved. You can select from the dropdown how you wish to search (e.g., Starts With, Contains, etc.). This entry can be shortened, e.g., 1120Auto will display ALL IDT’s for Auto Shop and you can select the one with the proper extension, e.g., 1120Auto004IDT.

• Journal Batch – for IDT’s, this field is the same as the journal. This field can be left blank.

• Accounting Period – because IDT’s may be posted in months other than their name, leaving this field blank works well. If this field is used by itself, ALL journal batch information will be displayed and includes IDT’s, integrations, assets, etc., and is a lengthy list.

• Batch Status – if this field is used by itself or with a date, the list is lengthy and includes IDT’s integrations, assets, etc.  This field can be left blank.

• Click Search when finished.

 

• Locate your desired IDT from the search results and click on the blue Journal name to open details of the IDT.

 

• On this screen, you can review all the details of the IDT including account information (Journal Lines), Accounting Period, Status, etc.

• Clicking on Attachments will display the actual IDT form and any supporting documentation. You can open any of the attachments up to view.

 

• The status fields refer to where the IDT is within the Accounting Office. When reviewing the Approval and Batch Status fields, keep the following status definitions in mind:

 

• To review more details of where your IDT is in the Accounting approval process, click Show More next to the Journal Batch.

• Select the Action Log tab.

  • This tab shows completed approvals.

    • In this example, the IDT has been created (uploaded) and sent for approvals but does not have any approvals completed.

  • If you would like additional details about the approvals workflow, contact the Accounting Office at accounting-office@uwyo.edu.

 

 

Step Six

Making Corrections to an IDT

If a correction on an IDT is needed, either the Expense Department or the Revenue Department can complete a correction for their budget strings.

• IDT Corrections are done via the Expenditure Correction Form. The Expenditure Correction Form is located on the Financial Affairs website under Forms and within the Accounting Office area.

 

---

APPENDIX

 

IDT Pilot Program

Effective fall 2019, a pilot program to streamline the IDT process was initiated. The program provides transparency and improves the posting frequency of IDT’s to the General Ledger.  The following revenue departments currently participate in the program:

 

 

Business Process:

• Employee requests goods/service from the revenue department and the revenue department requests the expense account information at that time to expedite processing of transactions.

  • Default account strings are on file in many cases and will be used if account information is not provided. The default account strings can be updated at any time by contacting the revenue department directly.

• After the goods or service have been delivered, the revenue department will email a copy of the invoice denoting the default account information to the expense department’s employee and/or billing coordinator, as well as the Cost Center Approver (found here at the bottom of the page) for each department.

  • The email requests the expense department to review the account coding and send a reply that verifies or changes the account information by a specified deadline. If a response is not received by the deadline, the IDT will be submitted to Accounting with the account string indicated on the invoice.

  • Departments are generally not copied on the final submission of the IDT to Accounting, but the IDT number format follows general protocol and is provided in the initial email correspondence for future retrieval in WyoCloud, e.g. of 1120UWOPS003XXIDT.  See Step Five for how to lookup an IDT in the financial management system.

 

 

This completes all of the steps for processing an Interdepartmental Transfer (IDT).