Balancete OpenKnowledge 2014-2015-2016 Gastos Aberto.xlsx
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
R$
%
123
 
 
 
 
 
 
 
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJ
1
Open Knowledge - Brasil
2
DEMONSTRATIVO DE RECEITAS E DESPESAS
3
Maio Setembro Outubro
Novembro
Dezembro
Janeiro Fevereiro Março Abril Maio Julho Agosto Setembro Outubro
Novembro
Dezembro
Janeiro Fevereiro Março Abril Maio Julho Agosto Setembro Outubro Novembro Dezembro TOTAL
4
R E C E I T A S
5
Receitas vinculadas a projetos e cursos
- 6,026.59
6
Gastos Abertos
7
Apoio Financeiro Pessoa Jurídica 243,973.41 90.00 472.20 196,037.07 45,076.21 485,648.89
8
SUBTOTAL - - 243,973.41 - - - - - - - - - 90.00 472.20 - - - - - - 196,037.07 45,076.21 - - - - - 485,648.89 100.00%
9
10
TOTAL - - 243,973.41 - - - - - - - - - 90.00 472.20 - - - - - - 196,037.07 45,076.21 - - - - - 485,648.89
11
12
D E S P E S A S
13
Gastos Abertos
14
Prestadores de Seviço 4,925.00 4,179.00 1,088.00 10,620.00 5,330.00 12,800.00 - 9,750.00 3,363.80 4,840.00 3,561.25 1,000.00 10,585.00 29,920.00 4,000.00 42,200.00 33,300.00 750.00 71,500.00 90,000.00 343,712.05
15
Coordenação Geral - Direção Executiva 2,719.00 2,390.00 4,540.00 2,270.00 2,270.00 3,405.00 17,594.00
16
Passagem Avião/Ônibus 349.56 6,376.11 6,725.67
17
Impostos e Taxas 927.10 120.00 886.52 744.94 171.29 2,849.85
18
Despesas Bancárias 45.00 45.00
19
Alimentação 139.70 136.95 150.55 427.20
20
Material Gráfico 30.00 6.10 36.10
21
Materiais Diversos 8,000.00 174.76 8,174.76
22
Despesas Diversas 155.13 155.13
23
Escola de Dados
-
24
Prestadores de Seviço 4,500.00 750.00 5,250.00
25
Passagem Avião/Ônibus 247.28 239.28 486.56
26
Alimentação 504.39 504.39
27
Material Gráfico 38.00 38.00
28
SUBTOTAL 30.00 155.13 5,897.10 7,018.00 1,088.00 13,010.00 9,870.00 15,070.00 2,270.00 9,889.70 3,363.80 5,726.52 6,966.25 1,384.23 18,824.28 35,643.36 4,750.00 42,200.00 33,300.00 750.00 72,244.94 96,547.40 - - - - - 385,998.71 100.00%
29
30
TOTAL 30.00 155.13 5,897.10 7,018.00 1,088.00 13,010.00 9,870.00 15,070.00 2,270.00 9,889.70 3,363.80 5,726.52 6,966.25 1,384.23 18,824.28 35,643.36 4,750.00 42,200.00 33,300.00 750.00 72,244.94 96,547.40 - - - - - 385,998.71
31
32
Superávit / Déficit30.00155.13238,076.317,018.001,088.0013,010.009,870.0015,070.002,270.009,889.703,363.805,726.526,876.25912.0318,824.2835,643.364,750.0042,200.0033,300.00750.00123,792.1351,471.190.000.000.000.000.0099,650.18
33
34
Over Head 10%
24,453.56
35
RubricaSaldo201420152016 Total Saldo
Over Head 17%
40,989.26
36
Development and platform maintenance (staff)
65,442.82
37
Information Architecture 10,000.00 2,719.00 14,875.00 17,594.00 - 7,594.00
38
Design 12,000.00 96,270.05 242,500.00 338,770.05 - 326,770.05 Saldo34,207.36
39
Programming - Coding 80,000.00 10,192.00 10,192.00 69,808.00
40
Data cleaning 10,000.00 - 10,000.00
41
Updating and maintenance 45,000.00 - 45,000.00
42
Hosting 15,000.00 - 15,000.00
43
Courses & Tutorials production
44
Instructor 25,000.00 - 25,000.00
45
Content development 18,000.00 - 18,000.00
46
Online courses recording 15,000.00 - 15,000.00
47
Material/Content Design & Style 3,000.00 30.00 44.10 74.10 2,925.90
48
Trips (Tickets & Lodging) 20,000.00 836.12 6,376.11 7,212.23 12,787.77
49
Educational material production 5,000.00 - 5,000.00
50
Coffee Break 3,000.00 504.39 504.39 2,495.61
51
Training facility 5,000.00 - 5,000.00
52
Fundraising
53
Strategy 20,000.00 - 20,000.00
54
Fundraiser 30,000.00 - 30,000.00
55
Communication and outreach
56
Strategy 15,000.00 - 15,000.00
57
Content production 15,000.00 - 15,000.00
58
Community coordinator 20,000.00 - 20,000.00
59
Public relations and partnerships 24,000.00 - 24,000.00
60
Outreach resources 15,000.00 - 15,000.00
61
Advertising 5,000.00 5,000.00
62
Administrative and financial management
-
63
General management 60,000.00 1,247.23 9,488.48 916.23 11,651.94 48,348.06
64
Overhead 30,000.00 - 30,000.00
65
Total 500,000.00 14,188.23 122,018.14 249,792.34 385,998.71 114,001.29
66
67
RubricaSaldo201420152016 Total Saldo
68
Staff 310,000.00 2,579.00 89,095.05 225,400.00 317,074.05 - 7,074.05
69
Communication (design, advertising, public relations, events, digital mloarketing)
94,000.00 10,332.00 22,050.00 2,100.00 34,482.00 59,518.00
70
Logistic Costs 28,000.00 1,247.23 9,897.40 11,144.63 16,855.37
71
Infrastructure for platform 15,000.00 931.59 5,000.00 5,931.59 9,068.41
72
Production of educational material (drafting, editing, review in print and digital)
23,000.00 30.00 44.10 10,000.00 10,074.10 12,925.90
73
subtotal 470,000.00 14,188.23 122,018.14 242,500.00 378,706.37 91,293.63
74
outras despesas 6,026.59 7,292.34 13,318.93 - 13,318.93
75
Overhead 30,000.00 1,400.00 12,200.00 8,250.00 21,850.00 8,150.00
76
Total 500,000.00 21,614.82 134,218.14 258,042.34 413,875.30 86,124.70
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...
Main menu