*** This version of Confluence is for testing only and contains a copy of content from June 29th 2026. No changes will be preserved. ***
-
Created by
Sharon Helen Markus, last updated on Jan 20, 2025
2 minute read
The following reports are automatically updated and published to Box in Excel format every morning by 7:00am. Links are provided to each report on Box so you can download them to your desktop. A link to each report query is also provided so you can run the query manually in your reporting application (e.g., CloudBeaver, DBeaver) to get the most current version of the results. Access to these datasets is restricted to Cornell Library FBO staff members.
Filtering and Sorting Data in Excel File Downloads for Automated Reports - step-by-step instructions
| Report | Short Title | Description | Link to Excel download of Yesterday's Data | Link to Query to run for Current Version of Data |
|---|---|---|---|---|
MCR113 Excel Download | ||||
| ||||
MCR113 | daily_appr_inv_exported | This query provides the total amount of voucher lines per account number and per approval date for transactions exported to accounting. | MCR113 FY2025 | |
MCRXXX Excel Download | ||||
| ||||
MCR132Y Excel Download | yesterday_YTD_acct_bal_by_ledger_univ_acct | This report provides the year-to-date external account cash balance along with total_expenditures, initial allocation, and net allocation. The fiscal year can be selected in the WHERE clause. The current fiscal year is preselected by default. | ||
MCRXXX Excel Download | ||||
| ||||
MCR132Y Excel Download | yesterday_YTD_acct_bal_by_ledger_univ_acct | This report provides the year-to-date external account cash balance along with total_expenditures, initial allocation, and net allocation. The fiscal year can be selected in the WHERE clause. The current fiscal year is preselected by default. | ||
MCRXXX Excel Download | ||||
| ||||
MCR132Y Excel Download | yesterday_YTD_acct_bal_by_ledger_univ_acct | This report provides the year-to-date external account cash balance along with total_expenditures, initial allocation, and net allocation. The fiscal year can be selected in the WHERE clause. The current fiscal year is preselected by default. | ||
MCRXXX Excel Download | ||||
| ||||
MCR132Y Excel Download | yesterday_YTD_acct_bal_by_ledger_univ_acct | This report provides the year-to-date external account cash balance along with total_expenditures, initial allocation, and net allocation. The fiscal year can be selected in the WHERE clause. The current fiscal year is preselected by default. | ||
MCRXXX Excel Download | ||||
| ||||
MCR132Y Excel Download | yesterday_YTD_acct_bal_by_ledger_univ_acct | This report provides the year-to-date external account cash balance along with total_expenditures, initial allocation, and net allocation. The fiscal year can be selected in the WHERE clause. The current fiscal year is preselected by default. | ||
MCRXXX Excel Download | ||||
| ||||
MCR132Y Excel Download | yesterday_YTD_acct_bal_by_ledger_univ_acct | This report provides the year-to-date external account cash balance along with total_expenditures, initial allocation, and net allocation. The fiscal year can be selected in the WHERE clause. The current fiscal year is preselected by default. | ||
MCR132Y Excel Download | ||||
| ||||
MCR132Y Excel Download | yesterday_YTD_acct_bal_by_ledger_univ_acct | This report provides the year-to-date external account cash balance along with total_expenditures, initial allocation, and net allocation. The fiscal year can be selected in the WHERE clause. The current fiscal year is preselected by default. | ||
MCRXXX Excel Download | ||||
MCRXXX Excel Download | query_name | query description | ||
Next Reports:
MCR113Y - yesterday's data automated
MCR114Y - yesterday's data automated
MCR116 - yesterday's data automated
MCR120 - yesterday's data automated
MCR139 - yesterday's data automated for this fiscal year