Opinions

Letter from the editor | Introducing Ledger

Across its many different bank accounts, Pitt brings in and spends a lot of money.

Like, a lot a lot.

For the first time, any expense from the $2-billion University for goods or services worth $1,000 or more is now easily searchable by community members. This is thanks to Ledger, a new tool from The Pitt News which I created.

Using Ledger, you can search University transactions by year, purchaser, vendor and purchase type. For example, we have written extensively about the University’s millions in payments to Philadelphia-based “union avoidance” firm Ballard Spahr. We were the first to report on these transactions — which ultimately earned us an award from a national journalism competition — and have used Ledger to track these transactions.

The data behind Ledger is available due to Article XX-D, Section 2004-D of Pennsylvania’s Public School Code of 1949 — I know, it just rolls right off the tongue. My favorite section of Pennsylvania law says state-related universities like Pitt “shall submit in electronic format a report of the information” requested, including the goods and services contracts, by the end of the calendar year. The data is then provided to the state government in Harrisburg, from which every year we obtain one coveted Excel file in particular — Contracts.xlsx — before it is loaded into Ledger. You can access the raw transaction data in CSV format here.

We hope that you enjoy using Ledger.

All my best,

Jon Moss

Editor-in-Chief

editor@pittnews.com

412-648-7895

TPN Editor-in-Chief

Share
Published by
TPN Editor-in-Chief

Recent Posts

Opinion | How did this happen?

Thomas and I spent most of the election night texting back and forth. We both…

48 mins ago

Opinion | Intimacy is not reserved for romantic relationships

Chances are, during college, you’re going to crash out over nothing and live in a…

54 mins ago

Sam Clancy: A guarantee on Pittsburgh’s Mount Rushmore

Pittsburgh is home to some of the most important figures in sports history –– so…

2 hours ago

‘I’ll get through these next four years’: Pitt students divided over Trump’s victory, with mixed emotions on campus

As the news echoes across campus, Pitt students are grappling with mixed emotions about the…

2 hours ago

Faculty Assembly discusses antisemitic violence on campus, announces antisemitic ad-hoc committee 

On Wednesday, Nov. 6., Faculty Assembly reflected on the 2024 presidential election, addressed recent acts…

2 hours ago

DePasquale, Democrat watch party brings feelings of optimism in the community

A watch party held at the Pittsburgh Federation of Teachers for Pennsylvania attorney general candidate…

2 hours ago