[openspending-dev] Balance Sheets - advice please!

Thu Jan 26 14:51:15 UTC 2012

On Thu, Jan 26, 2012 at 1:32 PM, Mark Brough
<mark.brough at publishwhatyoufund.org> wrote:
> Looks to me like it's two tables of data side by side?

That was my impression as well, but my french is disastrous.

> The Revenue (left) side has titles for each of the sections (anything where
> "Imputation" is blank). Imputation means budget line.
>
> The "Spending" (right) side looks like it is separated into capital and
> recurrent spending on each row. You'd want to include the stuff lower down
> on pensions, local government (presuming commune=local government) spending
> and debt.

This is nice for us, since we can aggregate both ways: sum up capital
and recurrent or by other breakdowns.

> BF = Budget de fonctionnement. BIP = Budget d'Investissement Public
>
> BF = current
> BIP = capital
>
> Would combining the two tables work in OpenSpending by turning the data into
> something like:
>
> From | From_id | To | source | type | type_code | type_2 | type_2_code
>
> IMPOTS SUR LES REVENUS DES PERSONNES PHYSIQUES | 721 | Government of
> Cameroon | Revenue | RECETTES PROPRES | A | RECETTES FISCALES | i | 155900
> Government of Cameroon | 1 | Society (Cameroon) | Spending | PRESIDENCE DE
> LA REPUBPLIQUE | 1 | Current spending | BF | 40927
>
> Would that work? Then the views would allow you to show Revenue and Spending
> on separate tabs, broken down by `type` in each case.

That sounds good, I've been using this with German budgets (Federal,
Berlin, Bremen) and the Budget of the European Union.

We'll just have to remember to reverse `to` and `from` if they are to be set :)

- Friedrich

> On 26 January 2012 09:34, Lucy Chambers <lucy.chambers at okfn.org> wrote:
>>
>> Hi Pudo,
>>
>> Thanks for looking at this.
>>
>>> Looking at the tree though, I'm not entirely sure this is normal
>>> balance sheet data - is there perhaps an English version or some data
>>> to look at available?
>>
>>
>>  Sorry, I meant to send you the link to the DataHub package, there's some
>> sample data in there:
>>
>> http://thedatahub.org/dataset/cameroon-budget-2012
>>
>> If there is any way to meaningfully restructure the data, I'd be happy to
>> write up a guide to put on the wiki.
>>
>> Lucy
>>
>>
>>>
>>> Best regards,
>>>
>>>  - Friedrich
>>>
>>> [1] https://github.com/okfn/openspending/issues/157
>>>
>>> On Thu, Jan 26, 2012 at 12:14 AM, Lucy Chambers <lucy.chambers at okfn.org>
>>> wrote:
>>> > Hi All,
>>> >
>>> > I've been attempting to guide JeanBrice, dealing with the Cameroon
>>> > budget
>>> > through the Data Format process, but want to make sure I am advising
>>> > him to
>>> > do the right thing.
>>> >
>>> > His data is more like a balance sheet than what we usually have. Do we
>>> > have
>>> > any nice way to display receipts / income (distinguishing them from
>>> > outgoings) or should he work just on the outgoings for now?
>>> >
>>> > His data (including a diagram to show the structure of the budget) is
>>> >
>>> > here: https://commondatastorage.googleapis.com/ckannet-storage/2012-01-25T132804/Tree-of-the-Budget-of-the-State-of-Cameroon.pdf).
>>> >
>>> > Help appreciated!
>>> >
>>> > Lucy
>>> >
>>> > --
>>> > Lucy Chambers
>>> > Community Coordinator
>>> > Open Knowledge Foundation
>>> > http://okfn.org/
>>> > Skype: lucyfediachambers
>>> >
>>> > _______________________________________________
>>> > openspending-dev mailing list
>>> > openspending-dev at lists.okfn.org
>>> > http://lists.okfn.org/mailman/listinfo/openspending-dev
>>> >
>>
>>
>>
>>
>> --
>> Lucy Chambers
>> Community Coordinator
>> Open Knowledge Foundation
>> http://okfn.org/
>> Skype: lucyfediachambers
>>
>> _______________________________________________
>> openspending-dev mailing list
>> openspending-dev at lists.okfn.org
>> http://lists.okfn.org/mailman/listinfo/openspending-dev
>>
>