*** This version of Confluence is for testing only and contains a copy of content from June 29th 2026. No changes will be preserved. ***
...
Filtering and Sorting Data in Excel File Downloads for Automated Reports - step-by-step instructions
| Table of Contents |
|---|
| 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
MCR132Y 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. | Excel download of yesterday's data | source query |
MCRXXX 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 | |||
MCR132Y Excel Download
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 | |||
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 | |||
MCR132Y Excel Download
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 | |||
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 | |||
query_name | query description | ||
Next Reports:
MCR113Y - yesterday's data automated
...