Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Reconcile payments from companies with receipts to government agencies #18

Closed
anderspeders opened this issue Apr 21, 2017 · 2 comments
Closed

Comments

@anderspeders
Copy link

Why

For EITI country datasets which have high data accuracy there is an opportunity to "merge" payments and receipts datasets without reducing the amount of infromation.

The guidance below shows how - thanks to Fernando from Development Gateway for this tip!

I suggest that we develop a tool that will check if a flat file can be produced that include both payments from and payments to and in that case this should supplement the double file for a given country.

What

There's a chance to eliminate the double counting in the flattened files under the following conditions:
1 - The Excel sheet should have disaggregated company information.
2 - The Government reported revenue and the Company reported revenue should match.
3 - Then you group by GFS Code + Name of revenue stream
4 - The rows of type "company" in column G aggregated by value_reported should be equal to the row of type "government" same column.
If all those conditions are met, then you can copy the value in column name_of_recieving_agency from the "government"type row, to the "company" type rows that have it empty, and delete the former, effectively eliminating the double counting.

Notes

@mattfullerton
Copy link
Contributor

This is the same as #28 right?

@mattfullerton
Copy link
Contributor

Closing in favour of #28

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants