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


MCR113 MCR114 MCR116MCR132MCRXXX
Link to Excel download of yesterday's dataClick Link Below to Download Excel ReportShort TitleDescription

Link to Source Query

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 

Excel download of yesterday's data

short title

description

MCR114 FY2025

source query

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

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

Excel download of yesterday's data

query_name


query description

MCRXXX

source query

...