Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Filtering and Sorting Data in Excel File Downloads for Automated Reports - step-by-step instructions


Table of Contents
absoluteUrltrue


Link to Excel download of yesterday's dataShort TitleDescription

Link to Source Query

MCR113 





MCR113 FY2025

Excel download of yesterday's data

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

source query

MCR114 





MCR114 

Excel download of yesterday's data

short title

description

MCR114 FY2025

source query

MCR116





MCR116 

Excel download of yesterday's data

short title

description

MCR116 


source query

MCR120





MCR120

Excel download of yesterday's data

short title

description

MCR120


source query

MCR132





MCR132Y FY2025 

Excel download of yesterday's data

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. 

MCR139

source query

MCR139





MCR139

Excel download of yesterday's data

short title

description

MCR139

source query

MCRXXX




MCRXXX

Excel download of yesterday's data

query_name


query description

MCRXXX

source query





...