ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
To create your own, please follow these directions:
2
1. Create a copy of this workbook
3
2. Copy and paste your general ledger data into the TEMPLATE General Ledger sheet of this workbook
4
3. Make sure all expenses are identified with a NOVA project (using the ID is preferred) and NOVA Activity
5
4. Find your reports in the Object Code Report and Activity Report sheets of this workbook
6
7
8
Key
9
Required Column
10
Strongly recommended
11
12
13
Useful Formulas:
14
mid(H2,2,1)*1000
Used to get the object code category
15
if(ROUNDUP(MONTH(B2)/3,0)>2,ROUNDUP(MONTH(B2)/3,0)-2,ROUNDUP(MONTH(B2)/3,0)+2)
Used to get the fiscal quarter from the date. Replace B2 with the date cell.
16
17
18
19
20
21
22
23
24
25
26
27
28
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