General Ledger example
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAAAB
1
General ledger example
2
3
General ledger example codes
4
Budget Line Codes
Project Codes
5
Grants Disbursment
0
Organizational Management
1
6
Staff10
Editing Workshop
2
7
Food20
Education Programs
3
8
Equipment30GLAM4
9
Travel40
Communications
5
10
External Contract50
11
Contract Labor51
12
Contract Services52
13
14
What you see in the general ledger
15
DateAccount
Payee or Payor
MemoAmountBudgetProject
16
11/5/2014Checking
Wikimedia Foundation
Grant for November workshop
$150.0002
17
11/10/2014CheckingSmith Library
Snacks for November 2014 workshop
-$25.00202
18
11/10/2014CheckingSmith Library
Projector rental for November 2014 workshop
-$10.00302
19
11/11/2014Checking
Beatrice Rodriguez
Bookkeeping contractor
-$109.41521
20
11/12/2014Checking
Chen Repair Services
Fix damaged screen
-$62.25301
21
11/14/2014CheckingIgor Flintrov
Salary for November 2014 workshop
-$113.18511
22
11/14/2014CheckingIgor Flintrov
Salary for education programs support
-$540.73513
23
11/17/2014Checking
Wikimedia Foundation
Return excess grant funds
-$1.8202
24
25
Calculating the total costs for November 2014 workshop
26
Salary-$113.18
27
Snacks-$25.00
28
Projector rental-$10.00
29
Total-$148.18
The formula for this "Total" cell is =SUM(D26,D28)
30
31
Cost-effectiveness measures for the November 2014 workshop
32
Number
Cost per each
33
New editors15-$9.88
The formula for this "Cost per each" cell is =IFERROR($D$29/E33, "Not applicable")
34
New articles4-$37.05
The formula for this "Cost per each" cell is =IFERROR($D$29/E34, "Not applicable")
35
Files created36-$4.12
The formula for this "Cost per each" cell is =IFERROR($D$29/E35, "Not applicable")
36
Edits made207-$0.72
The formula for this "Cost per each" cell is =IFERROR($D$29/E36, "Not applicable")
37
Quality images included in new files
2-$74.09
The formula for this "Cost per each" cell is =IFERROR($D$29/E37, "Not applicable")
38
Valued images included in new files
0Not applicable
The formula for this "Cost per each" cell is =IFERROR($D$29/E38, "Not applicable")
39
Featured pictures included in new files
0Not applicable
The formula for this "Cost per each" cell is =IFERROR($D$29/E39, "Not applicable")
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
Loading...