Include Monthly Treasury Statements?

[abelsonlive]

@martinburch pointed out the treasury's monthly statements to me, which seem to have a wealth of information not included in the daily statements: http://fms.treas.gov/mts/mts1013.txt

What say ye?

[cezary4]

I've already started looking at them . . . basically they summarize the
data on a monthly basis from a budgetary standpoint vs. cash in, cash out.
I'm getting started on a scraper for these because I think they could be a
useful complement to the dailies. But I don't think we'd want every little
data item out of them.

Brian if you want to team up, I'd love to help you tackle the monthlies.
It's obviously outside the scope of our CodeSprint Grant, as we've already
delivered what we'd promised. But if you're game, I'd love to go the extra
mile to get this data on there as well.

Let me know what you think.

Cezary

On Sun, Jan 19, 2014 at 11:02 PM, Brian Abelson [email protected]:

@martinburch https://github.com/martinburch pointed out the treasury's
monthly statements to me, which seem to have a wealth of information not
included in the daily statements: http://fms.treas.gov/mts/mts1013.txt

What say ye?

—
Reply to this email directly or view it on GitHubhttps://github.com//issues/200
.

Cezary Podkul | @cezary
Mobile: (708) 228 1319
Web: cezarypodkul.com

[abelsonlive]

Here's what I just wrote to @martinburch:

On second pass it seems like these are just aggregates of the daily statements, but with the aggregations performed at the level of super-classes like 'Department of Agriculture.' Maybe the best approach would be to join line-items in the daily statements to the classes that show up in the monthly statements?

[cezary4]

Yeah but they won't match up exactly because you have line items like
Federal salaries, which reflect salaries for the entire Federal government.
So mapping out, adding and netting all the various line items that go into
one department, like Dept. of Agriculture, won't reflect the salaries of
their workforce, for instance. Plus Treasury has told us it makes some
month end adjustments when it crunches those numbers that don't show up in
the daily data. So some programs like Medicare line up pretty closely with
the monthlies, but other ones will be off.

Cezary

On Sun, Jan 19, 2014 at 11:28 PM, Brian Abelson [email protected]:

Here's what I just wrote to @martinburch https://github.com/martinburch:

On second pass it seems like these are just aggregates of the daily
statements, but with the aggregations performed at the level of
super-classes like 'Department of Agriculture.' Maybe the best approach
would be to join line-items in the daily statements to the classes that
show up in the monthly statements?

—
Reply to this email directly or view it on GitHubhttps://github.com//issues/200#issuecomment-32733563
.

Cezary Podkul | @cezary
Mobile: (708) 228 1319
Web: cezarypodkul.com

[mhkeller]

@cezary4 this would require a new grant