journal entry transfer (jet) training april 25, 2012 ...ci finance team . ci finance team -...
TRANSCRIPT
![Page 1: Journal Entry Transfer (JET) Training April 25, 2012 ...CI Finance Team . CI Finance Team - Presenters Jennifer Schweisinger Accounting Supervisor Leo Cervantes Financial Analyst –](https://reader034.vdocuments.us/reader034/viewer/2022051919/600bfa5860592d4d2732c1dd/html5/thumbnails/1.jpg)
Journal Entry Transfer (JET) Training
April 25, 2012
Presented by:
CI Finance Team
![Page 2: Journal Entry Transfer (JET) Training April 25, 2012 ...CI Finance Team . CI Finance Team - Presenters Jennifer Schweisinger Accounting Supervisor Leo Cervantes Financial Analyst –](https://reader034.vdocuments.us/reader034/viewer/2022051919/600bfa5860592d4d2732c1dd/html5/thumbnails/2.jpg)
CI Finance Team - Presenters Jennifer Schweisinger
Accounting Supervisor
Leo Cervantes Financial Analyst – Grants and Contracts
![Page 3: Journal Entry Transfer (JET) Training April 25, 2012 ...CI Finance Team . CI Finance Team - Presenters Jennifer Schweisinger Accounting Supervisor Leo Cervantes Financial Analyst –](https://reader034.vdocuments.us/reader034/viewer/2022051919/600bfa5860592d4d2732c1dd/html5/thumbnails/3.jpg)
What is a JET? Form that takes the place of the “Chartfield
Change Form”
Corrects GL (general ledger) entries
Corrects A/P (accounts payable) entries
Used to change an account, fund, department, program, class, or project
![Page 4: Journal Entry Transfer (JET) Training April 25, 2012 ...CI Finance Team . CI Finance Team - Presenters Jennifer Schweisinger Accounting Supervisor Leo Cervantes Financial Analyst –](https://reader034.vdocuments.us/reader034/viewer/2022051919/600bfa5860592d4d2732c1dd/html5/thumbnails/4.jpg)
Why the switch to the JET? Easier for the end-user to complete
Saves time for CI Finance staff
Saves paper…process is electronic
![Page 5: Journal Entry Transfer (JET) Training April 25, 2012 ...CI Finance Team . CI Finance Team - Presenters Jennifer Schweisinger Accounting Supervisor Leo Cervantes Financial Analyst –](https://reader034.vdocuments.us/reader034/viewer/2022051919/600bfa5860592d4d2732c1dd/html5/thumbnails/5.jpg)
OLD – Chartfield Change Form
![Page 6: Journal Entry Transfer (JET) Training April 25, 2012 ...CI Finance Team . CI Finance Team - Presenters Jennifer Schweisinger Accounting Supervisor Leo Cervantes Financial Analyst –](https://reader034.vdocuments.us/reader034/viewer/2022051919/600bfa5860592d4d2732c1dd/html5/thumbnails/6.jpg)
NEW - JET Form
![Page 7: Journal Entry Transfer (JET) Training April 25, 2012 ...CI Finance Team . CI Finance Team - Presenters Jennifer Schweisinger Accounting Supervisor Leo Cervantes Financial Analyst –](https://reader034.vdocuments.us/reader034/viewer/2022051919/600bfa5860592d4d2732c1dd/html5/thumbnails/7.jpg)
Examples of Use Correct errors from the Data Warehouse
Correct errors on ProCard statements
Submit Chargeback requests between campus departments: Phone, postage, TPS events, OPC work
orders, OPC utilities, fuel, Pharos
![Page 8: Journal Entry Transfer (JET) Training April 25, 2012 ...CI Finance Team . CI Finance Team - Presenters Jennifer Schweisinger Accounting Supervisor Leo Cervantes Financial Analyst –](https://reader034.vdocuments.us/reader034/viewer/2022051919/600bfa5860592d4d2732c1dd/html5/thumbnails/8.jpg)
Accounting 101 Normal ending balances:
Expense accounts = debits (+) Revenue accounts = credits (-)
Debit (+) Credit (-) Expense X Revenue X
![Page 9: Journal Entry Transfer (JET) Training April 25, 2012 ...CI Finance Team . CI Finance Team - Presenters Jennifer Schweisinger Accounting Supervisor Leo Cervantes Financial Analyst –](https://reader034.vdocuments.us/reader034/viewer/2022051919/600bfa5860592d4d2732c1dd/html5/thumbnails/9.jpg)
Accounting 101 Equate this to your own ‘bank statement’
Money spent shown as a debit (+) • i.e. your ‘debit card’
Deposits shown as a credit (-)
![Page 10: Journal Entry Transfer (JET) Training April 25, 2012 ...CI Finance Team . CI Finance Team - Presenters Jennifer Schweisinger Accounting Supervisor Leo Cervantes Financial Analyst –](https://reader034.vdocuments.us/reader034/viewer/2022051919/600bfa5860592d4d2732c1dd/html5/thumbnails/10.jpg)
Accounting 101 If there is a debit (+), there must be an
offsetting credit (-)
Balance must equal zero!
Account Name Debit (+) Credit (-) Supplies + $100.00 Cash in Bank - $100.00
+ $100.00 - $100.00
$0.00
![Page 11: Journal Entry Transfer (JET) Training April 25, 2012 ...CI Finance Team . CI Finance Team - Presenters Jennifer Schweisinger Accounting Supervisor Leo Cervantes Financial Analyst –](https://reader034.vdocuments.us/reader034/viewer/2022051919/600bfa5860592d4d2732c1dd/html5/thumbnails/11.jpg)
Accounting 101 Example from the Data Warehouse
Debit (+)
Account Fund Dept Amount 660003 GD901 220 + $175.00
Original Entry Debit (+) = Expense
![Page 12: Journal Entry Transfer (JET) Training April 25, 2012 ...CI Finance Team . CI Finance Team - Presenters Jennifer Schweisinger Accounting Supervisor Leo Cervantes Financial Analyst –](https://reader034.vdocuments.us/reader034/viewer/2022051919/600bfa5860592d4d2732c1dd/html5/thumbnails/12.jpg)
Accounting 101 Example from the Data Warehouse
Account Fund Dept Amount 660003 GD901 220 + $175.00
Original Entry
Account Fund Dept Amount 660003 GD901 220 - $175.00
To Correct Original Entry
+ $175.00 - $175.00
$0.00
Debit (+)
Credit (-)
![Page 13: Journal Entry Transfer (JET) Training April 25, 2012 ...CI Finance Team . CI Finance Team - Presenters Jennifer Schweisinger Accounting Supervisor Leo Cervantes Financial Analyst –](https://reader034.vdocuments.us/reader034/viewer/2022051919/600bfa5860592d4d2732c1dd/html5/thumbnails/13.jpg)
Accounting 101 Example from the Data Warehouse
Account Fund Dept Amount 660003 GD901 220 - $175.00 660003 GD901 225 + $175.00
Final Entry
+ $175.00 - $175.00
$0.00
Move expense to correct Dept
![Page 14: Journal Entry Transfer (JET) Training April 25, 2012 ...CI Finance Team . CI Finance Team - Presenters Jennifer Schweisinger Accounting Supervisor Leo Cervantes Financial Analyst –](https://reader034.vdocuments.us/reader034/viewer/2022051919/600bfa5860592d4d2732c1dd/html5/thumbnails/14.jpg)
Accounting 101 Example from a ProCard Statement
Debit (+)
Account Fund Dept Amount 660003 GD901 745 + $375.00
Original Entry Debit (+) = Expense
![Page 15: Journal Entry Transfer (JET) Training April 25, 2012 ...CI Finance Team . CI Finance Team - Presenters Jennifer Schweisinger Accounting Supervisor Leo Cervantes Financial Analyst –](https://reader034.vdocuments.us/reader034/viewer/2022051919/600bfa5860592d4d2732c1dd/html5/thumbnails/15.jpg)
Accounting 101 Example from a ProCard Statement
Account Fund Dept Amount 660003 GD901 745 + $375.00
Original Entry
Account Fund Dept Amount 660003 GD901 745 - $375.00
To Correct Original Entry
+ $375.00 - $375.00
$0.00
Debit (+)
Credit (-)
![Page 16: Journal Entry Transfer (JET) Training April 25, 2012 ...CI Finance Team . CI Finance Team - Presenters Jennifer Schweisinger Accounting Supervisor Leo Cervantes Financial Analyst –](https://reader034.vdocuments.us/reader034/viewer/2022051919/600bfa5860592d4d2732c1dd/html5/thumbnails/16.jpg)
Accounting 101 Example from a ProCard Statement
Account Fund Dept Amount 660003 GD901 745 - $375.00 660890 GD901 745 + $375.00
Final Entry
+ $375.00 - $375.00
$0.00
Move expense to correct Account
![Page 17: Journal Entry Transfer (JET) Training April 25, 2012 ...CI Finance Team . CI Finance Team - Presenters Jennifer Schweisinger Accounting Supervisor Leo Cervantes Financial Analyst –](https://reader034.vdocuments.us/reader034/viewer/2022051919/600bfa5860592d4d2732c1dd/html5/thumbnails/17.jpg)
How to fill out the JET Form
Must “Enable Macros”
![Page 18: Journal Entry Transfer (JET) Training April 25, 2012 ...CI Finance Team . CI Finance Team - Presenters Jennifer Schweisinger Accounting Supervisor Leo Cervantes Financial Analyst –](https://reader034.vdocuments.us/reader034/viewer/2022051919/600bfa5860592d4d2732c1dd/html5/thumbnails/18.jpg)
How to fill out the JET Form
Click for instructions
![Page 19: Journal Entry Transfer (JET) Training April 25, 2012 ...CI Finance Team . CI Finance Team - Presenters Jennifer Schweisinger Accounting Supervisor Leo Cervantes Financial Analyst –](https://reader034.vdocuments.us/reader034/viewer/2022051919/600bfa5860592d4d2732c1dd/html5/thumbnails/19.jpg)
How to fill out the JET Form Date defaults to today’s date
Change if necessary
![Page 20: Journal Entry Transfer (JET) Training April 25, 2012 ...CI Finance Team . CI Finance Team - Presenters Jennifer Schweisinger Accounting Supervisor Leo Cervantes Financial Analyst –](https://reader034.vdocuments.us/reader034/viewer/2022051919/600bfa5860592d4d2732c1dd/html5/thumbnails/20.jpg)
How to fill out the JET Form
"Transfer From" and "Transfer To" entity should always be the same business unit
![Page 21: Journal Entry Transfer (JET) Training April 25, 2012 ...CI Finance Team . CI Finance Team - Presenters Jennifer Schweisinger Accounting Supervisor Leo Cervantes Financial Analyst –](https://reader034.vdocuments.us/reader034/viewer/2022051919/600bfa5860592d4d2732c1dd/html5/thumbnails/21.jpg)
How to fill out the JET Form
Enter your contact information
![Page 22: Journal Entry Transfer (JET) Training April 25, 2012 ...CI Finance Team . CI Finance Team - Presenters Jennifer Schweisinger Accounting Supervisor Leo Cervantes Financial Analyst –](https://reader034.vdocuments.us/reader034/viewer/2022051919/600bfa5860592d4d2732c1dd/html5/thumbnails/22.jpg)
How to fill out the JET Form
Enter the subject -- will appear on Data Warehouse Reports
![Page 23: Journal Entry Transfer (JET) Training April 25, 2012 ...CI Finance Team . CI Finance Team - Presenters Jennifer Schweisinger Accounting Supervisor Leo Cervantes Financial Analyst –](https://reader034.vdocuments.us/reader034/viewer/2022051919/600bfa5860592d4d2732c1dd/html5/thumbnails/23.jpg)
How to fill out the JET Form
For internal use only
![Page 24: Journal Entry Transfer (JET) Training April 25, 2012 ...CI Finance Team . CI Finance Team - Presenters Jennifer Schweisinger Accounting Supervisor Leo Cervantes Financial Analyst –](https://reader034.vdocuments.us/reader034/viewer/2022051919/600bfa5860592d4d2732c1dd/html5/thumbnails/24.jpg)
How to fill out the JET Form If a “Construction
Fund” click check box
Email will be sent to A/P for processing
![Page 25: Journal Entry Transfer (JET) Training April 25, 2012 ...CI Finance Team . CI Finance Team - Presenters Jennifer Schweisinger Accounting Supervisor Leo Cervantes Financial Analyst –](https://reader034.vdocuments.us/reader034/viewer/2022051919/600bfa5860592d4d2732c1dd/html5/thumbnails/25.jpg)
How to fill out the JET Form
Enter your changes here!
Remember Accounting 101?
![Page 26: Journal Entry Transfer (JET) Training April 25, 2012 ...CI Finance Team . CI Finance Team - Presenters Jennifer Schweisinger Accounting Supervisor Leo Cervantes Financial Analyst –](https://reader034.vdocuments.us/reader034/viewer/2022051919/600bfa5860592d4d2732c1dd/html5/thumbnails/26.jpg)
How to fill out the JET Form
Total must equal zero
![Page 27: Journal Entry Transfer (JET) Training April 25, 2012 ...CI Finance Team . CI Finance Team - Presenters Jennifer Schweisinger Accounting Supervisor Leo Cervantes Financial Analyst –](https://reader034.vdocuments.us/reader034/viewer/2022051919/600bfa5860592d4d2732c1dd/html5/thumbnails/27.jpg)
How to fill out the JET Form
Maximum 30 characters -- will appear on Data Warehouse Reports
![Page 28: Journal Entry Transfer (JET) Training April 25, 2012 ...CI Finance Team . CI Finance Team - Presenters Jennifer Schweisinger Accounting Supervisor Leo Cervantes Financial Analyst –](https://reader034.vdocuments.us/reader034/viewer/2022051919/600bfa5860592d4d2732c1dd/html5/thumbnails/28.jpg)
How to fill out the JET Form
Need more than 30 lines -- click “Show/Hide Page 2”
![Page 29: Journal Entry Transfer (JET) Training April 25, 2012 ...CI Finance Team . CI Finance Team - Presenters Jennifer Schweisinger Accounting Supervisor Leo Cervantes Financial Analyst –](https://reader034.vdocuments.us/reader034/viewer/2022051919/600bfa5860592d4d2732c1dd/html5/thumbnails/29.jpg)
How to fill out the JET Form
Click “Email/Submit Form”
Does not submit JET yet, must save and then create an Outlook email
![Page 30: Journal Entry Transfer (JET) Training April 25, 2012 ...CI Finance Team . CI Finance Team - Presenters Jennifer Schweisinger Accounting Supervisor Leo Cervantes Financial Analyst –](https://reader034.vdocuments.us/reader034/viewer/2022051919/600bfa5860592d4d2732c1dd/html5/thumbnails/30.jpg)
How to fill out the JET Form
Save a copy for your files and for submission
Save as .xlsm
![Page 31: Journal Entry Transfer (JET) Training April 25, 2012 ...CI Finance Team . CI Finance Team - Presenters Jennifer Schweisinger Accounting Supervisor Leo Cervantes Financial Analyst –](https://reader034.vdocuments.us/reader034/viewer/2022051919/600bfa5860592d4d2732c1dd/html5/thumbnails/31.jpg)
How to fill out the JET Form
Click on the email on the Taskbar
Creates an email, addressed to [email protected]
![Page 32: Journal Entry Transfer (JET) Training April 25, 2012 ...CI Finance Team . CI Finance Team - Presenters Jennifer Schweisinger Accounting Supervisor Leo Cervantes Financial Analyst –](https://reader034.vdocuments.us/reader034/viewer/2022051919/600bfa5860592d4d2732c1dd/html5/thumbnails/32.jpg)
How to fill out the JET Form
Email “To” is [email protected]
JET is attached
Don’t forget to attach backup!
Hit “Send”
![Page 33: Journal Entry Transfer (JET) Training April 25, 2012 ...CI Finance Team . CI Finance Team - Presenters Jennifer Schweisinger Accounting Supervisor Leo Cervantes Financial Analyst –](https://reader034.vdocuments.us/reader034/viewer/2022051919/600bfa5860592d4d2732c1dd/html5/thumbnails/33.jpg)
The JET Form “In Action”
Leo to give an interactive
demonstration
![Page 34: Journal Entry Transfer (JET) Training April 25, 2012 ...CI Finance Team . CI Finance Team - Presenters Jennifer Schweisinger Accounting Supervisor Leo Cervantes Financial Analyst –](https://reader034.vdocuments.us/reader034/viewer/2022051919/600bfa5860592d4d2732c1dd/html5/thumbnails/34.jpg)
JET vs. RET
JET is a transfer between the same entity
![Page 35: Journal Entry Transfer (JET) Training April 25, 2012 ...CI Finance Team . CI Finance Team - Presenters Jennifer Schweisinger Accounting Supervisor Leo Cervantes Financial Analyst –](https://reader034.vdocuments.us/reader034/viewer/2022051919/600bfa5860592d4d2732c1dd/html5/thumbnails/35.jpg)
JET vs. RET
RET is a transfer between different entities
![Page 36: Journal Entry Transfer (JET) Training April 25, 2012 ...CI Finance Team . CI Finance Team - Presenters Jennifer Schweisinger Accounting Supervisor Leo Cervantes Financial Analyst –](https://reader034.vdocuments.us/reader034/viewer/2022051919/600bfa5860592d4d2732c1dd/html5/thumbnails/36.jpg)
Acceptable Types of Back-Up Copy of report from the Data Warehouse
![Page 37: Journal Entry Transfer (JET) Training April 25, 2012 ...CI Finance Team . CI Finance Team - Presenters Jennifer Schweisinger Accounting Supervisor Leo Cervantes Financial Analyst –](https://reader034.vdocuments.us/reader034/viewer/2022051919/600bfa5860592d4d2732c1dd/html5/thumbnails/37.jpg)
Acceptable Types of Back-Up Copy of ProCard Statement
![Page 38: Journal Entry Transfer (JET) Training April 25, 2012 ...CI Finance Team . CI Finance Team - Presenters Jennifer Schweisinger Accounting Supervisor Leo Cervantes Financial Analyst –](https://reader034.vdocuments.us/reader034/viewer/2022051919/600bfa5860592d4d2732c1dd/html5/thumbnails/38.jpg)
Where can we find the JET form?
CI Accounting website Under “Forms”
![Page 39: Journal Entry Transfer (JET) Training April 25, 2012 ...CI Finance Team . CI Finance Team - Presenters Jennifer Schweisinger Accounting Supervisor Leo Cervantes Financial Analyst –](https://reader034.vdocuments.us/reader034/viewer/2022051919/600bfa5860592d4d2732c1dd/html5/thumbnails/39.jpg)
When can we start using the JET? Start using now!
Ask questions of CI Finance Staff
Mandatory use starting May 1, 2012
The old “Chartfield Change Form” will not be accepted after this date
![Page 40: Journal Entry Transfer (JET) Training April 25, 2012 ...CI Finance Team . CI Finance Team - Presenters Jennifer Schweisinger Accounting Supervisor Leo Cervantes Financial Analyst –](https://reader034.vdocuments.us/reader034/viewer/2022051919/600bfa5860592d4d2732c1dd/html5/thumbnails/40.jpg)
Important Information Approval signature(s) not needed
If moving expenses that are older than 90- days, please attach a scanned copy of the “Expense Transfer Adjustment Form”
JET Form functionality will not work on Apple computers If you access email through Webmail Contact Jennifer Schweisinger (x3510) for a work-
around
![Page 41: Journal Entry Transfer (JET) Training April 25, 2012 ...CI Finance Team . CI Finance Team - Presenters Jennifer Schweisinger Accounting Supervisor Leo Cervantes Financial Analyst –](https://reader034.vdocuments.us/reader034/viewer/2022051919/600bfa5860592d4d2732c1dd/html5/thumbnails/41.jpg)
Submission Information Jet Form is due the 25th of each month
Changes will appear in the following months financial statements (Data Warehouse)
JET Form and back-up must be submitted electronically…no paper copies
JET Form and back-up must be submitted to the following email address: [email protected]
![Page 42: Journal Entry Transfer (JET) Training April 25, 2012 ...CI Finance Team . CI Finance Team - Presenters Jennifer Schweisinger Accounting Supervisor Leo Cervantes Financial Analyst –](https://reader034.vdocuments.us/reader034/viewer/2022051919/600bfa5860592d4d2732c1dd/html5/thumbnails/42.jpg)
Questions? Phyllis Vicker
Senior Accountant – Treasury [email protected] X 8578
Jennifer Schweisinger
Accounting Supervisor [email protected] X 3510
![Page 43: Journal Entry Transfer (JET) Training April 25, 2012 ...CI Finance Team . CI Finance Team - Presenters Jennifer Schweisinger Accounting Supervisor Leo Cervantes Financial Analyst –](https://reader034.vdocuments.us/reader034/viewer/2022051919/600bfa5860592d4d2732c1dd/html5/thumbnails/43.jpg)
Example #1 – From Data Warehouse
Need to correct this entry
![Page 44: Journal Entry Transfer (JET) Training April 25, 2012 ...CI Finance Team . CI Finance Team - Presenters Jennifer Schweisinger Accounting Supervisor Leo Cervantes Financial Analyst –](https://reader034.vdocuments.us/reader034/viewer/2022051919/600bfa5860592d4d2732c1dd/html5/thumbnails/44.jpg)
Example #2 – From ProCard Statement
Need to correct this entry