Versions Compared

Key

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


The following Excel reports are automatically updated and posted to Box every morning by 97:00am. The reports include data that was current in the FOLIO system at the end of the previous business day. Access to these datasets is restricted to Cornell Library Selectors and Selector Support staff members. Also see related Selector Data Dashboards. These datasets are restricted to selectors and other authorized staff members.


To inquire about access to these datasets, please submit a request through the by clicking the Requesting Reporting Help form and  and specify that you would like access to selector datasets.


INSTRUCTIONS: To download daily report results in Excel format, click the link below the links in the left column to choose the desired dataset in the "Link to Daily Report Results in Box - Set 1 or Set 2."

Results sets are provided for all selector teams and individual selector teams.

from the table below.


Want to see how to sort and filter the data by fiscal year, fund group, or other fields once you download it? See the filtering and sorting instructions here:


Click Link Below to Download Excel Report from BoxShort TitleDescription of Selector Excel Report

MCR122 Excel Download

fund_detail 



This report provides the list of all active funds along with their ledger, fund group and fund type. It also provides allocations, transfers, encumbrances, expenditures, fund balance and percentage spent for each fund. Please note: Titles are not included. See appr_invoices_bib_data for Titles with Funds.

MCR134 FY2026 Excel Download

MCR134 FY2025 Excel Download

MCR134 FY2024 Excel Download

MCR134 FY2023 Excel Download

MCR134 FY2022 Excel Download

Report Short TitleDescriptionTimeframeLink to Daily Report Results in Box - Set 1Link to Daily Report Results in Box - Set 2

CR101 Excel Download

CR101 Excel Download

fund_expenditures_ by_po_line_invoice_payments

This report shows fund expenditures by purchase order line within a given invoice payment date range. For each purchase order line number, the fund data attributes are shown alongside the purchase order line transaction amount. Multiple fund groups appear by team due to split fund payments.7/1/21 - 6/30/22

CR101 for All Teams

CR101 for 2CUL

CR101 for Area Studies

CR101 for Central

CR101 for Cornell Medical

CR101 for Course Reserves

CR101 for Humanities

CR101 for Interdisciplinary

CR101 for Law

CR101  for Preservation & Digitization

CR101 for Rare & Distinctive

CR101 for Sciences

CR101 for Social Sciences

CR123 Excel Download

CR123 Excel download

open_orders

This report provides a list of open purchase orders and their encumbrance and/or amount paid, broken down by purchase order lines.FY2022

CR123 for All Teams

CR123 for 2CUL

CR123  for Area Studies

CR123 for Central

CR123 for Cornell Medical

CR123  for Course Reserves

CR123 for Humanities

CR123 for Interdisciplinary

CR123 for Law

CR123 for Preservation & Digitization

CR123 for Rare & Distinctive

CR123 for Sciences

CR123 for Social Sciences

CR134 Excel Download

CR134 Excel download


appr_invoices_bib_data

This report provides the list of approved invoices within a date range along with vendor name, invoice number, fund details and purchase order data.
7/1/21 - 6/30/22

CR134 for All Teams

CR134 for 2CUL

CR134 for Area Studies

CR134 for Central

CR134 for Cornell Medical

CR134 for Course Reserves

CR134 for Humanities

Titles are included.

MCR157_FY2026

CR134 for Interdisciplinary

CR134 for Law

CR134 for Preservation & Digitization

CR134 for Rare & Distinctive

CR134 for Sciences

CR134 for Social Sciences

CR138 Excel Download

CR138 Excel download

orders_split_funds

This query provides the list of split funds purchases for a purchase order line that has multiple funds used along with the transaction amount for each fund and the percentage spent.

FY2022

CR138 for All Teams

CR138 for 2CUL

CR138 for Area Studies

CR138 for Central

CR138 for Cornell Medical

CR138 for Course Reserves

CR138 for Humanities

CR138 for Interdisciplinary

CR138 for Law

CR138 for Preservation & Digitization

CR138 for Rare & Distinctive

CR138 for Sciences

CR138 for Social Sciences

CR157 Excel Download

CR157

Excel Download

funds_and_teams_with_expense_class

Provides a detailed current date report of funds and teams with amounts spent, encumbered, and remaining. It also shows the expense class.
FY2022

CR157 for All Teams

CR157 for 2CUL

CR157 for Area Studies

CR157 for Central

CR157 for Cornell Medical

CR157 for Course Reserves

CR157 for Humanities

CR157 for Interdisciplinary

CR157 for Law

CR157 for Preservation & Digitization

CR157 for Rare & Distinctive

CR157 for Sciences

CR157 for Social Sciences

CR165 Excel Download

CR165

funds_and_teams

Provides
a current date report
the current fiscal year and past fiscal year reports of funds and teams with amounts spent, encumbered, and remaining. This report does not include expense class (see
CR157
MCR157).
FY2022

CR165 for All Teams

CR165 for 2CUL

CR165 for Area Studies

team_related_split_funds

Shows split funds by PO line that enables selectors to filter by the funds for their team while also seeing what other team funds split a purchase order payment with them.

missing_lost_claimed_returned 

This report creates a list of missing, lost, and claimed returned items (including equipment) at a given library, and includes item status date, last date and location of check in, and size/pagination.

current_encumbrances

This report finds current encumbrances by fund and fiscal year. It also shows titles and locations. Please note: As of 6/21/23, Fully Paid orders may still have a current encumbrance; this is a system issue to be fixed.

CR165 for Central

CR165 for Cornell Medical

CR165 for Course Reserves

CR165 for Humanities

CR165 for Interdisciplinary

CR165 for Law

CR165 for Preservation & Digitization

CR165 for Rare & Distinctive

CR165 for Sciences

CR165 for Social Sciences