How To Create A Journal Entry*
*for users who do not have a Finance UWinsite License
DEFINITIONS:
JOURNAL ENTRY – A journal entry is a record of a financial transaction in the general ledger, made up of balanced debits and credits. It may affect revenue, expense, asset, liability or fund balance accounts, and is used for internal transactions between departments, reimbursements or transfers, corrections, and accruals. Each entry should be supported by appropriate backup documentation.
ACCRUAL – An accrual is an estimate of an expense or revenue that has been incurred in an accounting period but not yet recorded, because the invoice has not been processed through Accounts Payable or the revenue has not been invoiced or received in cash before the period closes. An accrual reverses once the actual invoice is recorded or the cash is received.
INTERNAL ENTRY – An internal entry is a journal entry recording a transaction that has occurred between two departments within the University. This includes between funds, such as operating providing funding to a research grant (fund 01 - Operating giving to fund 08 – Research Grants). For more information on Funds, please review the Chart of Accounts documentation. Internal journal entry natural accounts must comply with the Matching Natural Account grid shown in Appendix A. Entries must have a revenue natural account starting with 6 and an expense natural account starting with 7.
STEPS TO CREATING A JOURNAL ENTRY FOR SUBMISSION
- In your internet browser, navigate to the University of Windsor, Finance Department webpage (www.uwindsor.ca/finance), click on Glossary of Policies, Procedures & Forms – from the button on the front page or in the left hand column


- In the Forms, Policies & Reference Guides page, scroll down until you reach the Forms
section. Click General Accounting

- Click GA01 – Journal Entry Template (Finance & Campus Users) to download
- Fill in all necessary fields
- Journal Description
- Ledger – always UW CAD
- Accounting Date
- If an accrual and entry is to be reversing, Reversal Period should be put in along with the date
- Fund – 2 numbers
- Department – 4 numbers
- Program – 5 numbers
- Project – 6 numbers
- Natural Account – 5 numbers
- Classification – 3 numbers
- Interfund – 2 numbers
- Future Use – 3 numbers
- Currency – CAD mainly; if doing USD, you must choose an exchange rate which in most cases should be Corporate
- Debit/Credit – enter these numbers as a positive figure. NOTE: at the top of the page you will see whether the entry is balanced. You cannot submit an unbalanced entry (debits must equal credits)
- Not mandatory Journal Entry Description – this field is helpful when running account analysis reports as it gives a description of what the entry is. If nothing is input you will simply see “Journal entry Import” which is unhelpful from an analysis perspective
NOTE: Projects and programs are mutually exclusive, if you have one, you cannot the other
|
NOTE: All fields marked with * must be filled in - zero’s are significant and need to be input
|

5. Once completed, save spreadsheet in a folder where you will be saving your backup. They must be in the same folder in order to upload properly into the TDX ticket. Please see Appendix B for examples of proper backup.
6. Once all backup is prepared, navigate to
7. Click on Open Ticket – NOTE: you may need to first sign-in with your uwinid and password in the top right corner of the page

8. Here you will follow the form and fill out the necessary information. Requestor information should be auto populated. Required fields are marked with a red *. Scroll down to Request Type. In the Drop-down, choose Request New Journal Entry (Post My JE)

9. A new set of criteria will show in the ticket to fill out based on this request type. The first section is a link to the journal entry spreadsheet. This is the same spreadsheet you may have already filled out in Step 2. This link is simply there for convenience if you have not already filled the spreadsheet out. If you already have the journal template and your backup saved and ready, please ignore this link. NOTE: if you click on the link, it does not automatically save or populate into the ticket. You would still need to save in a folder to upload later.

10. In the Title section, it is important to change the default “UWinsite Finance Support Request” to the name of your journal batch. This is in the same format that your journal entry should be in which is “UWinid YYYY-MM-DD short description of entry” where the date is the date you are submitting the ticket. This may differ from the accounting date in the journal template. The accounting date relates to the month in which the entry should be posted. Character limit for UWinsite on the journal batch description is 252 characters.
11. Multiple Funds – This refers to the first segment of the GL account string. If an entry is going from fund 01 to fund 01, the answer here would be “No”. If the entry is going from Fund 01 to Fund 08, the answer here would be “Yes” because there are two different funds impacted from the entry. This helps Finance determine who should be responsible for the entry
12. Fund – This refers to the specific funds the entry will be charged to. This also aids us in determining where to triage the ticket.
13. Charge Fund 08 – Although this seems redundant, choosing Yes or No triggers more fields in the ticket and loop in more information. If the entry is debiting or crediting a fund 08 GL string, please choose “Yes” here.
14. Budget/Accounting Year – this is the ending of the current fiscal year. For example, if the end of the fiscal year is April 2022, the Accounting Year would be 2022.
15. Budget/Accounting Month – this is the accounting date your entry should be posted to. This does not relate to the date you are submitting the ticket as the month end does not close for roughly 10 days after the end of the month for purposes of posting relevant entries. It will relate to the same date input into the spreadsheet.
16. Total Debits/Credits – This is the total of your entry that can be found at the top of your journal entry sheet.
17. Additional Comments – this field is optional but a great way to explain what the entry is for and any other relevant details you wish for the reviewer to be aware of with regard to the entry.
18. Attachment (s) - It is important these instructions are followed as the ticketing system has a little nuance when it comes to adding multiple attachments. You will recall in Step 5 that it was asked to save your journal entry template and relevant backup in the same folder. This is the step where you will retrieve these files and the importance of saving them in one location. Click on Browse and navigate to the folder you have saved your files in (both the journal excel file and your backup). You MUST hold down the CTRL (control) key on your keyboard when you are choosing your multiple files. Click on all files and then hit Open.
19. Lastly, there are two confirmation statements that must be checked. The first relates to whether you have uploaded the journal entry spreadsheet (found in Step 2) and the second relates to whether you have uploaded your supporting backup documentation that states why you are making the entry. Check both boxes if you have done so.
20. Click SUBMIT.
You will get a confirmation of your ticket number.If at any time you want to review your tickets, you can click on Ticket Requests in the top menu and search for them.By clicking into them, you will be able to see what the current status is of the ticket you submitted.Once the entry has been posted and approved, you will get an update to the ticket marking it complete.You may also get other notifications on the ticket if the reviewer requires more information. Please ensure your response is timely to ensure we can process your requests as quickly as possible.
If you’d like to check the status visit the following website.
Appendix A: Matching Internal Accounts
The Chart of Accounts uses natural accounts starting with “6” to designate internal revenue and “7” to designate internal expenses. When performing internal transactions, using the correct combination of “6” and “7” accounts is key to ensuring that your entries are posted quickly.
|
DEPARTMENT
|
INTERNAL REVENUE NATURALS
|
INTERNAL EXPENSE NATURALS
|
|
UTILITIES
|
67540 –RECOVERY UTILITIES
|
71540 – UTILITIES
|
|
PRINT SHOP
|
63108 – COURSEWARE
|
73100 – BOOKSTORE / PRINT SHOP
|
|
63109 – PHOTOCOPYING
|
|
63110 – WORD PROCESSING
|
|
63112 – OTHER SERVICES
|
|
CATERING/FOOD
|
63300 – CATERING
|
73300 – CATERING / FOOD
|
|
63301 – THIRD PARTY SERVICES
|
|
63302 – LIQUOR
|
|
63320 – CATERING CLEARING
|
|
PARKING
|
63501 – PARKING PERMITS
|
73500 - PARKING
|
|
63502 – PARKING CASUAL
|
|
63503 – PARKING FINES
|
|
63510 – PARKING CLEARING
|
|
CARD
|
63601 – CAMPUS CARD
|
73601 – CAMPUS CARD
|
|
CHEMICAL CONTROL
|
66100 – BULK SALES
|
72221 – CHEMICAL CONTROL
|
|
66101 – CHEMICAL SALES
|
|
66102 – DEMERGE SALES
|
|
66103 – GAS SALES
|
|
66104 – NITROGEN SALES
|
|
66105 – OFFICE SALES
|
|
66106 – SHIPPING RECOVERY
|
|
66107 – SUPPLIER SALES
|
|
66110 - CLEARING
|
|
ANIMAL CARE
|
64001 – ANIMAL CARE
|
74001 – ANIMAL CARE
|
|
EVENTS
|
67100 – EVENT REVENUE
|
72310 – EVENTS/WORKSHOPS/TRAINING EXPENSE
|
|
RENTALS / LAB FEES
|
67110 – RENT REVENUE
|
72311 – RENTALS
|
|
ADVERTISING
|
67150 – RECOVERY ADVERTISING
|
72150 - ADVERTISING
|
|
WAGE & BENEFITS
|
67160 – WAGE RECOVERY
|
71100 – WAGES
|
|
67170 – BENEFITS RECOVERY
|
71160 - BENEFITS
|
|
PROFESSIONAL SERVICES
|
67180 – PROFESSIONAL SERVICES
|
72110 – SECURITY/CAMPUS POLICE
|
|
67120 – FINES/FEES REVENUE
|
72120 – IT/OTHER PROFESSIONAL SERVICES
|
|
|
72121- FINES/FEES
|
|
TECHNICAL SUPPORT CENTRE
|
67321 – TECH SUPPORT CENTRE (NOT IT)
|
72321 – TECH SUPPORT CENTRE (NOT IT)
|
|
MAINTENANCE & CUSTODIAL
|
67320 – MAINTENANCE & REPAIR RECOVERY
|
71230 – CUSTODIAL & GROUNDS
|
|
72320 – MAINTENANCE & REPAIRS
|
|
INTERNAL COST RECOVERY
|
67700 – INTERNAL COST RECOVERY
|
77700- INTERNAL MISC EXPENSE
|
|
OVERHEAD
|
67500 – RECOVERY OVERHEAD
|
71500 – OVERHEAD
|
|
ENDOWMENT
|
67999 – ENDOWMENT REVENUE
|
77999 – ENDOWMENT EXPENSE
|
Appendix B: Examples of backup to be included in journal entries
|
Emails from departments – this would be a requirement if you are charging another department’s account or transferring funds into their account. An email is normally not sufficient in and of itself as it may not substantiate the dollar amount in the entry.
Account Analysis report – this is the most commonly required backup requirement as it shows what has actually been charged to an account, in the case of moving an expense and charging another department, program or project. Further documentation on how to run this report is provided 11. Run reports in the system | Finance Department
Meeting minutes – meeting minutes from a committee or board shows that a motion may have been approved for a spending amount or transfer.
Spreadsheet calculations – this should show how numbers were derived and often have system reports included to validate where the amounts used in the calculations are coming from
Invoices/receipts – these are helpful in the calculation of accruals. Invoices in and of themselves do not constitute full backup if they are being used to move funds from one department to another. They need to be accompanied with the account analysis report as mentioned above, so that the total amount of the expense can be validate. This is due to University related HST expenses charged on account.
Internal forms – an example of this would be an application for an internal grant filled out and approved by the department providing the grant
External reports – these are reports coming from systems outside of UWinsite finance such as CBORD (UWincard software), Destiny, etc. that will substantiate the values in the calculations/entries in the journal entry
|
| |
|