How To Create A Journal Entry

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

 

  1.   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

 

Uploaded image

Uploaded image

  1. In the Forms, Policies & Reference Guides page, scroll down until you reach the Forms

section. Click General Accounting

Uploaded image

 

  1. Click GA01 – Journal Entry Template (Finance & Campus Users) to download
  1. 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

 
   

Uploaded image

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

Uploaded image

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)

Uploaded image

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.

Uploaded image

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. 

Uploaded image

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.    

Uploaded image

 

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