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 | |
| function_id | FN0000 | |
| function_name | Student Services | |
| fund | FD0001 Balancing Fund | |
| fund_id | FD0001 | |
| fund_name | Balancing Fund | |
| gift | GF000000001 UWRVF | SASE | Admissions Foundation Gifts | |
| gift_id | GF000000001 | |
| gift_name | UWRVF | SASE | Admissions Foundation Gifts | |
| grant | GR000000001 UWRVF | Peer Mentor Program – Fund for Wisconsin Scholars (FFWS) | |
| grant_id | GR000000001 | |
| grant_name | UWRVF | Peer Mentor Program – Fund for Wisconsin Scholars (FFWS) | |
| interworktag_affiliate | FD0001 Balancing Fund | |
| interworktag_affiliate_id | FD0001 | |
| interworktag_affiliate_name | Balancing Fund | |
| ledger_account | 6000:Travel | |
| ledger_account_id | 6000 | |
| ledger_account_name | Travel | |
| program | PG000000001 UWRVF | FINC | Accounting Services | |
| program_id | PG000000001 | |
| program_name | UWRVF | FINC | Accounting Services | |
| project | PJ000000001 UWLAC | SOE | FY20 Startup | |
| project_id | PJ000000001 | |
| project_name | UWLAC | SOE | FY20 Startup | |
| revenue_category | RC00037 – Federal Grants & Contracts (Sponsored Research) | |
| revenue_category_id | RC00037 | |
| revenue_category_name | Federal Grants & Contracts (Sponsored Research) | |
| spend_category | SC00130 – Equipment – Computer | |
| spend_category_id | SC00130 | |
| spend_category_name | Equipment – Computer | |
| supplier_as_worktag | STAPLES INC | |
| transaction_date | 2025-01-01 08:00:00 |