Skip to Main Content

ACRL, IPEDS, and National Surveys

Support, guides and tutorials for PALNI libraries completing the ACRL, IPEDS, and other national surveys.

WMS Reports for Expenditures

Recommended Methods:

  • PALNI Libraries: Folder 2.1/Annual Survey Toolkit, "PALNI Acquisitions Expenditures Template for ACRL/IPEDS"
  • WMS libraries without Report Designer: use the Standard Payment Activity by Material Format report; see the PALNI ACRL/IPEDS Help Guide document

screenshot of acquisitions and expenditures report excel output

screenshot of excel pivot table of expenditures and acquisitions report

Payment Activity by Material Format

Go to WMS Analytics > Reports > Reports > Acquisitions Reports.  Open the Payment Activity by Material Format report.

WMS payment by material type report screenshot

In the Prompts box, enter the beginning and ending dates of your fiscal year in the “from” and “to” payment date. ADD Budget status=CLOSED so that you can include last year’s data (CLICK REFRESH VALUES to see and add/remove available options). Click OK to generate report.

WMS payment by material type report screenshot

On the left hand side in the Input Controls, choose Acquisitions Type=FIRM_ORDER for one-time purchases, or SUBSCRIPTION for subscriptions, and press OK. You can toggle between types or run this report separately for each type.

screenshot of WMS payment activity by material format report

On each report, find the Grand Total in the Amount Expended column. If the Acquisitions module data has been entered correctly, this is the amount you need to report.

screenshot of WMS payment activity by material format report