ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Middlebury/MIIS
2
Journal Entry Upload Template Instructions
3
4
The upload REQUIRES the data fields below and that they be in the order shown.
5
6
Column ADatexx/xx/xx
7
Column BE =Entity3 char long
8
Column CD =Department4 char long
9
Column DO =Object5 char long
10
Column ER =Restriction2 char long
11
Column FD =Designation6 char long
12
Column GA =Activity5 char long
13
Column HDebit
Include decimal, Example: 12345.25
14
Column ICredit
Include decimal, Example: 12345.25
15
Column J
Line Description
200+ characters
16
Column K
Submitter Name
200+ characters
17
18
EDORDA values are replacing FOAPAL values and can be found at:
19
www.middlebury.edu/office/project-ensemble/resources-oracle-finance
20
21
Do not add columns.
22
23
Debit and Credit numbers should be on separate rows - always positive numbers.
24
25
When the journal is complete, and debits equal credits, send a copy of the spreadsheet
26
to the Controller's Office, using address:
cojg@middlebury.edu
27
28
For questions contact Jean Gross at 802-443-5353 or gross@middlebury.edu.
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100