*** This version of Confluence is for testing only and contains a copy of content from June 29th 2026. No changes will be preserved. ***
...
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 the source code for each report query is also provided so you can run the query manually in your reporting application (e.g., CloudBeaver, DBeaver) to get the data for a different date range of your choosing, which you must set in the date parameters of the query. 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
| Table of Contents |
|---|
Report
to Automated Report of Yesterday's Data
YTD
The fiscal year can be selected in the WHERE clause. The current fiscal year is preselected by default.
FY2025
query_name
query description
| Click Link Below to Download Excel Report | Short Title | Description | Click Link |
|---|
Link to Query to run for Current Version of Data
MCR132Y Excel Download
MCR132Y Excel Download
Below to go to Source Query | |||
| daily_appr_inv_exported_yesterday | This query provides the total amount of voucher lines per account number and per approval date for transactions exported to accounting. |
|
| daily_appr_inv_vendor_yesterday | This query provides a list of invoices paid by vendor along with the voucher line details. |
|
| payables_inv_not_fed_notes_yesterday | This query provides the total amount of voucher lines not sent to accounting (manuals) per account number with notes. |
|
| daily_appr_inv_control_yesterday | This query provides the total amount of voucher_lines per external account number along with the approval dates. It includes manuals and transactions sent to accounting. |
|
| ytd |
_acct_bal_by_ledger_univ_acct_yesterday | This report provides the year-to-date external account cash balance along with total_expenditures, initial allocation, and net allocation. |
MCRXXX Excel Download
query_name
Next Reports:
MCR113
MCR114
MCR116
MCR120
| |||
| inv_appr_paid_diff_date_yesterday | This query provides a list of approved invoices that have been paid at a different date. |
|
...