You are viewing this article in the AnnArbor.com archives. For the latest breaking news and updates in Ann Arbor and the surrounding area, see MLive.com/ann-arbor
Posted on Thu, Sep 22, 2011 : 2:55 p.m.

No secrets: Ann Arbor posts real-time 'checkbook' on new website

By Ryan J. Stanton

The city of Ann Arbor's checkbook is now open for the public to see — essentially in real-time — on a new interactive website called A2OpenBook.

Ann Arbor officials said the new tool is an effort to increase the city's financial transparency by disclosing all city expenses and revenue in a format the average citizen can understand.

"It will give you some insights into our financial status — virtually live," said Tom Crawford, the city's chief financial officer.

A2OpenBook.jpg
The online resource at www.a2gov.org/a2openbook allows citizens easy access to information ranging from departmental budgets to individual payments to specific vendors.

Karen Lancaster, the city's accounting manager, and Josh Baron, a senior application specialist in the city's IT department, led the effort to launch A2OpenBook.

Baron said city financial data is downloaded directly from the city’s financial database every 24 hours and uploaded to A2OpenBook.

"The way that this works is the data gets refreshed nightly, so it's actually a one-day lag," he said. "So for all intents and purposes, it is actually real-time."

Citizens can browse expenditure and revenue information in a variety of ways, including by searching alphabetical lists of vendors and by expense amounts and expense types. Citizens also can drill down into specific funds such as the city's general fund, water and sewer funds, major streets fund, or parks maintenance and capital improvements millage fund.

"Once inside these service areas, you can actually drill down and it will take you down into the service unit, so now you have a deeper picture into how that money is being spent," Baron said during a run-through of the new site earlier this week.

Information is available for expenses beginning July 1, 2010, through the present. Not included on A2OpenBook are expenditures for the Downtown Development Authority and Housing Commission, which maintain their own financial systems.

Baron said A2OpenBook will continue to accumulate data on a daily basis. For user convenience, he noted, data sets are downloadable via Microsoft Excel.

Crawford said while the city has always believed that local government should be accountable for every dollar spent and has shared financial data and records online with citizens, the A2OpenBook website takes financial transparency to the next level.

Accountability and transparency is one of three categories where Gov. Rick Snyder is calling on Michigan municipalities to show improvements in order to receive state revenue sharing payments in the next fiscal year. Ann Arbor and other cities have until Oct. 1 to submit information to the state showing they're making progress in that area.

Crawford said A2OpenBook is over and above what the state is requiring. He said the city is working on other accountability and transparency efforts.

"That includes a performance dashboard, which are some metrics for the community to look at," he said. "For example, how much recycling we have, the quality of life, how we utilize fund balance — that kind of thing. And then the second thing we're publishing is a citizens guide to finance and budget, and both of those will be complete by the end of the month and put on our website. The citizens guide to finance and budget builds on what we already have out there and incorporates some of the graphs and information that the state has suggested."

Ryan J. Stanton covers government and politics for AnnArbor.com. Reach him at ryanstanton@annarbor.com or 734-623-2529. You also can follow him on Twitter or subscribe to AnnArbor.com's e-mail newsletters.

Comments

pgagreg

Sat, Sep 24, 2011 : 9:39 a.m.

I'm only looking at one small area of waste, the golf courses. Leslie is budgeted to lose about $240,000 this year. Huron Hills is budgeted to lose $260,000 this year. Wouldn't that money be better spent on Police, Firefighters or even fixing the roads. Or if you really don't have the money how about not spending it at all. The most interesting line item to me is the retiree health care cost. This year budgeted at nearly $28,000 an increase of 15% over last year. The longer you keep people employed in a money losing operation the more you add to your future retirement obligations. This is the downward spiral that politicians have to get a grip on. You just can't keep spending our tax dollars like there's no tomorrow. Tomorrow is here and bank is busted.

Bob Bethune

Fri, Sep 23, 2011 : 1:11 p.m.

How much information can one find out about ordinary citizens by digging into these accounts? How comfortable are you about that?

Gordon

Fri, Sep 23, 2011 : 12:53 p.m.

Good issues brought up by the comments. I suspect we have a number of people trained municipal accounting who can raise issues about what they see. Municipal accounting is a bit different then the average household accounting & business; so those with the knowledge could be helpful to the rest of us.

FreedomOfSpeech

Fri, Sep 23, 2011 : 6:23 a.m.

Let's see the Comprehensive Annual Financial Reports or CAFRs !!!! Budgets can be in the red while a trillion dollars in Stocks, Bonds &amp; Assets hides in plain sight in the CAFRs. Hello! Not saying that A2 has a Trillion like NYC did when Mayor Koch declared them all but bankrupt but I am pretty sure they won't be publishing their CAFRs online or promoting them, even though you... Joe/Jane Citizen has every right to march in and demand them as a public record... Learn! <a href="http://cafr1.com/WarDeclaration.html" rel='nofollow'>http://cafr1.com/WarDeclaration.html</a>

wolverineqt

Fri, Sep 23, 2011 : 1:10 p.m.

Please note the City of Ann Arbor has been displaying their CAFRS online for several years. <a href="http://www.a2gov.org/government/financeadminservices/Pages/Home.aspx" rel='nofollow'>http://www.a2gov.org/government/financeadminservices/Pages/Home.aspx</a> under Audit Financials.

Dale Vanderford

Fri, Sep 23, 2011 : 11:16 a.m.

2002 to 2010 is available on the accounting department's home page. <a href="http://www.a2gov.org/government/financeadminservices/accounting/Pages/Home.aspx" rel='nofollow'>http://www.a2gov.org/government/financeadminservices/accounting/Pages/Home.aspx</a> Happy reading!

Kai Petainen

Fri, Sep 23, 2011 : 5:44 a.m.

I have a concern... &quot;Ann Arbor and other cities have until Oct. 1 to submit information to the state showing they're making progress in that area&quot; I hope this site isn't up, just so they can submit the information..... only to take it down the minute they get approved by Snyder.

Kai Petainen

Fri, Sep 23, 2011 : 3:48 a.m.

This isn't a complaint, nor a compliment to city hall, but more of a question... Since they 'opened' the books for everyone to see.... and we constantly hear complaints about budgets and city hall... ... doesn't that mean, us... as the public... might be able to look at the books and figure out how the budget should go? I mean... instead of complaining, can we now come up with possible alternative solutions to whatever problem we face? i dunno the answer... just thought i'd ask the question.

Kai Petainen

Fri, Sep 23, 2011 : 12:01 a.m.

wow. nice. transparency. cool. this is really nice...

Mick52

Thu, Sep 22, 2011 : 9:16 p.m.

I have always been interested in how much the city spends on housing, the Delonis shelter and the other facilities. I did review this but it sure did not jump out. Can anyone point out where the figures are for A2's housing systems?

wolverineqt

Fri, Sep 23, 2011 : 1:08 p.m.

Please email klancaster@a2gov.org and she can help you with this.

Grumpy

Thu, Sep 22, 2011 : 8:13 p.m.

This is great. Is it too much to ask for AAPS to utilize a system like this?

LuvAA

Fri, Sep 23, 2011 : 2:39 p.m.

I second that! I just went to AAPS site just to make sure. I would love the same transparency with their financials. With all the reported budget issues, maybe some of us in the community can help come up with ideas. I'm interested to see details on where the money is spent and what kind of approval process requests go through. I'd also like to see how much is in reserves, so that long term planning is taken in to consideration.

Linda Peck

Thu, Sep 22, 2011 : 7:50 p.m.

Okay, this is good. Thank you. It sure beats a lot of the city news that I have read lately. I will be checking it out.