Journal entry data

Data from the journal entries endpoint is returned in CSV format. Below is a list of columns in the file, along with examples.

Column Example Notes
accounting_date 2024-12-01 00:00:00
company UWMSN
created_on 2025-03-28 00:00:00
journal_number JRN0000001745
journal_source General Ledger Conversion
journal_status Posted
ledger Actuals
ledger_period 2025-12-01 00:00:00
operational_transaction Award Revenue Recognition: UWMSN University of Wisconsin Madison on 12/31/2024
originated_by Bucky Badger
journal_line a1b2c3d4e5f678901234567890abcdef
last_updated_ts
award AWD-000001: Ice Drilling Program
cost_center CC000001 UWEAU | CHAN | Chancellor
credit_amount 123.45
debit_amount 123.45
function FN0000 Student Services
fund FD0001 Balancing Fund
gift GF000000001 UWRVF | SASE | Admissions Foundation Gifts
grant GR000000001 UWRVF | Peer Mentor Program – Fund for Wisconsin Scholars (FFWS)
interworktag_affiliate FD0001 Balancing Fund
ledger_account 6000:Travel
program PG000000001 UWRVF | FINC | Accounting Services
project PJ000000001 UWLAC | SOE | FY20 Startup
revenue_category RC00037 – Federal Grants & Contracts (Sponsored Research)
spend_category SC00130 – Equipment – Computer
supplier_as_worktag STAPLES INC
transaction_date 2025-01-01 08:00:00