| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 2020 | |||||||||||||||||||||||||
2 | GASTOS | JAN | FEV | MAR | ABR | MAI | JUN | JUL | AGO | SET | OUT | NOV | DEZ | |||||||||||||
3 | Projeção | Real | Projeção | Real | Projeção | Real | Projeção | Real | Projeção | Real | Projeção | Real | Projeção | Real | Projeção | Real | Projeção | Real | Projeção | Real | Projeção | Real | Projeção | Real | ||
4 | Staff | |||||||||||||||||||||||||
5 | Salários | €10,448.21 | €9,698.12 | €10,448.21 | €10,133.19 | €10,448.21 | €10,344.51 | €11,732.03 | €11,214.63 | €11,732.03 | €10,437.97 | €11,732.03 | €11,429.77 | €11,732.03 | €12,467.81 | €11,732.03 | €12,147.27 | €11,732.03 | €11,809.32 | €11,732.03 | €11,642.13 | €11,732.03 | €11,099.44 | €11,732.03 | €11,571.02 | |
6 | Freelancing | €750.00 | €0.00 | €750.00 | €490.00 | €2,000.00 | €1,899.90 | €750.00 | €0.00 | €750.00 | €1,345.80 | €750.00 | €787.90 | €750.00 | €197.90 | €750.00 | €0.00 | €750.00 | €0.00 | €750.00 | €0.00 | €750.00 | €0.00 | €750.00 | €0.00 | |
7 | Voluntariado | €150.00 | €0.00 | €150.00 | €0.00 | €150.00 | €0.00 | €150.00 | €0.00 | €150.00 | €0.00 | €150.00 | €0.00 | €150.00 | €0.00 | €150.00 | €0.00 | €150.00 | €400.00 | €150.00 | €0.00 | €150.00 | €0.00 | €150.00 | €0.00 | |
8 | Total Staff | €11,348.21 | €9,698.12 | €11,348.21 | €10,623.19 | €12,598.21 | €12,244.41 | €12,632.03 | €11,214.63 | €12,632.03 | €11,783.77 | €12,632.03 | €12,217.67 | €12,632.03 | €12,665.71 | €12,632.03 | €12,147.27 | €12,632.03 | €12,209.32 | €12,632.03 | €11,642.13 | €12,632.03 | €11,099.44 | €12,632.03 | €11,571.02 | |
9 | Staff Diferença | €1,650.09 | €725.02 | €353.80 | €1,417.40 | €848.26 | €414.36 | -€33.68 | €484.76 | €422.71 | €989.90 | €1,532.59 | €1,061.01 | |||||||||||||
10 | Outros | |||||||||||||||||||||||||
11 | Marketing | €700.00 | €0.00 | €700.00 | €130.05 | €700.00 | €1.50 | €700.00 | €235.84 | €700.00 | €20.00 | €700.00 | €0.00 | €700.00 | €77.51 | €700.00 | €81.23 | €700.00 | €17.70 | €700.00 | €0.00 | €700.00 | €0.00 | €700.00 | €0.00 | |
12 | Outros (e-mail, servidores, contabilidade, softwares, etc) | €400.00 | €406.87 | €400.00 | €411.77 | €400.00 | €489.10 | €400.00 | €458.88 | €400.00 | €580.53 | €400.00 | €456.02 | €400.00 | €541.76 | €400.00 | €474.01 | €400.00 | €322.42 | €400.00 | €414.24 | €400.00 | €304.38 | €400.00 | €435.34 | |
13 | Escritório | €500.00 | €1,218.63 | €500.00 | €531.60 | €500.00 | €493.84 | €500.00 | €360.48 | €500.00 | €450.00 | €500.00 | €400.00 | €500.00 | €537.86 | €500.00 | €412.00 | €500.00 | €202.50 | €500.00 | €410.10 | €500.00 | €1,606.79 | €500.00 | €1,340.44 | |
14 | Estúdio | €2,600.00 | €121.97 | €50.00 | €1,977.89 | €50.00 | €0.00 | €50.00 | €0.00 | €50.00 | €313.41 | €50.00 | €0.00 | €50.00 | €19.98 | €50.00 | €0.00 | €50.00 | €0.00 | €50.00 | €0.00 | €50.00 | €0.00 | €50.00 | €3,818.65 | |
15 | Viagens | €600.00 | €1,035.42 | €600.00 | €642.34 | €600.00 | €614.92 | €600.00 | €44.83 | €600.00 | €531.13 | €600.00 | €335.99 | €600.00 | €450.97 | €600.00 | €96.39 | €600.00 | €774.78 | €600.00 | €134.14 | €600.00 | €172.95 | €600.00 | €115.52 | |
16 | Total Outros | €4,800.00 | €2,782.89 | €2,250.00 | €3,693.65 | €2,250.00 | €1,599.36 | €2,250.00 | €1,100.03 | €2,250.00 | €1,895.07 | €2,250.00 | €1,192.01 | €2,250.00 | €1,628.08 | €2,250.00 | €1,063.63 | €2,250.00 | €1,317.40 | €2,250.00 | €958.48 | €2,250.00 | €2,084.12 | €2,250.00 | €5,709.95 | |
17 | Outros Diferença | €2,017.11 | -€1,443.65 | €650.64 | €1,149.97 | €354.93 | €1,057.99 | €621.92 | €1,186.37 | €932.60 | €1,291.52 | €165.88 | -€3,459.95 | |||||||||||||
18 | Total Custos Mensais | €16,148.21 | €12,481.01 | €13,598.21 | €14,316.84 | €14,848.21 | €13,843.77 | €14,882.03 | €12,314.66 | €14,882.03 | €13,678.84 | €14,882.03 | €13,409.68 | €14,882.03 | €14,293.79 | €14,882.03 | €13,210.90 | €14,882.03 | €13,526.72 | €14,882.03 | €12,600.61 | €14,882.03 | €13,183.56 | €14,882.03 | €17,280.97 | |
19 | Total Custos Acumulados | €16,148.21 | €12,481.01 | €29,746.42 | €26,797.85 | €44,594.63 | €40,641.62 | €59,476.66 | €52,956.28 | €74,358.69 | €66,635.12 | €89,240.72 | €80,044.80 | €104,122.75 | €94,338.59 | €119,004.78 | €107,549.49 | €133,886.81 | €121,076.21 | €148,768.84 | €133,676.82 | €163,650.87 | €146,860.38 | €178,532.90 | €164,141.35 | |
20 | Total Diferença Custos Mensais | €3,667.20 | -€718.63 | €1,004.44 | €2,567.37 | €1,203.19 | €1,472.35 | €588.24 | €1,671.13 | €1,355.31 | €2,281.42 | €1,698.47 | -€2,398.94 | |||||||||||||
21 | ||||||||||||||||||||||||||
22 | ||||||||||||||||||||||||||
23 | ||||||||||||||||||||||||||
24 | RECEITAS | 2020 | ||||||||||||||||||||||||
25 | JAN | FEV | MAR | APR | MAI | JUN | JUL | AGO | SET | OUT | NOV | DEZ | ||||||||||||||
26 | Subscrições Paypal | €21.00 | €26.00 | €23.00 | €23.00 | €23.00 | €23.00 | €23.00 | €23.00 | €23.00 | €20.00 | €20.00 | €23.00 | |||||||||||||
27 | Subscrições Patreon | €1,003.78 | €1,069.79 | €1,019.50 | €1,090.80 | €1,218.15 | €1,208.21 | €1,224.37 | €1,089.51 | €1,410.59 | €1,219.49 | €1,206.77 | €1,315.12 | |||||||||||||
28 | Stripe (Pagamentos únicos + Subscrições) | €2,033.00 | €1,951.37 | €1,605.22 | €2,865.27 | €2,983.27 | €3,379.28 | €2,704.71 | €4,794.30 | €3,454.75 | €2,867.91 | €13.00 | €5,054.33 | |||||||||||||
29 | Donativos através de conta bancária | €30.00 | €10.00 | €10.00 | €330.00 | €46.00 | €110.00 | €10.00 | €40.00 | €784.00 | €21.00 | €13.00 | €326.48 | |||||||||||||
30 | Receitas de eventos | €0.00 | €0.00 | €0.00 | €0.00 | €0.00 | €0.00 | €0.00 | €250.00 | €250.00 | €0.00 | €150.00 | €0.00 | |||||||||||||
31 | Crowdfunding (suspenso) | €0.00 | €0.00 | €0.00 | €0.00 | €0.00 | €0.00 | €0.00 | €19,759.53 | €0.00 | €0.00 | €0.00 | €0.00 | |||||||||||||
32 | Prémios de jornalismo | €0.00 | €0.00 | €0.00 | €0.00 | €0.00 | €0.00 | €0.00 | €0.00 | €0.00 | €0.00 | €0.00 | €0.00 | |||||||||||||
33 | Bolsas | €0.00 | €0.00 | €0.00 | €1,000.00 | €39,352.09 | €0.00 | €2,000.00 | €0.00 | €0.00 | €2,500.00 | €42,033.76 | €3,000.00 | |||||||||||||
34 | Total por mês | €3,087.78 | €3,057.16 | €2,657.72 | €5,309.07 | €43,622.51 | €4,720.49 | €5,962.08 | €25,956.34 | €5,922.34 | €6,628.40 | €43,436.53 | €9,718.93 | |||||||||||||
35 | Total acumulado | €3,087.78 | €6,144.94 | €8,802.66 | €14,111.73 | €57,734.24 | €62,454.73 | €68,416.81 | €94,373.15 | €100,295.49 | €106,923.89 | €150,360.42 | €160,079.35 | |||||||||||||
36 | ||||||||||||||||||||||||||
37 | ||||||||||||||||||||||||||
38 | FUNDOS USADOS (por fonte) | Real | % | Projeção | % | |||||||||||||||||||||
39 | Prémios | €0.00 | 0.0% | Prémios | 4% | |||||||||||||||||||||
40 | Donativos | €49,783.97 | 30.3% | Donativos | 17% | |||||||||||||||||||||
41 | Eventos | €650.00 | 0.4% | Eventos | 12% | |||||||||||||||||||||
42 | Bolsas de jornalismo | €93,947.85 | 57.2% | Fundos | 45% | |||||||||||||||||||||
43 | Crowdfunding | €19,759.53 | 12.0% | Crowdfunding | 22% | |||||||||||||||||||||
44 | Total Usado | €164,141.35 | 100.00% | 100.00% | ||||||||||||||||||||||
45 | ||||||||||||||||||||||||||
46 | ||||||||||||||||||||||||||