University of Arkansas for Medical Sciences

Grant Award Budget Tracking

Saved on this browser only — clearing history or cookies will delete your reports
Report tools
Instructions & docs
Display settings
Projection tool only — confirm with Grants Accounting

Grant Wizard is a projection tool only. It does not replace your official account balance or institutional financial records. Please review and confirm all numbers with your grants accountant before sending anything to the sponsor.

Setup checklist — 5 item(s) left

The report cannot calculate correctly until each item below is filled in. Click any item to jump straight to it.

Details & guidance
  • Months Elapsed and Months Remaining calculate automatically.
  • Name the report however you like (for example the PI name and award number) — you can keep several reports and switch between them at the top of the page.
  • Enter the current budget period start and end dates from the Notice of Award, then the start and end dates of the month you are reporting on.
  • Enter the F&A rate as a percentage (for example 47.5, not 0.475).
  • Months Elapsed and Months Remaining fill in on their own and drive the projected expense math, so double-check the dates if projections look wrong.
  • Everything you type is saved in this browser automatically — no login and no Save button.

Months Elapsed In Period

0

Months Remaining In Period

0

Calculated as of today from the Current Budget Period Start and End dates (award dates are used only if no budget period dates are entered). A period that has already ended shows the full calendar months since it ended and always has 0 months remaining for projections.

U.S. Government Award Resources

If this award is from a U.S. Government agency, you can find public award details, spending history, and related information at these federal reporting systems:

  • NIH RePORTER — Search NIH-funded research projects, publications, and patents.
  • USAspending.gov — Browse federal awards, spending, and recipient information across all agencies.
  • NSF Award Search — Look up National Science Foundation awards and award abstracts.
  • SAM.gov — Find federal award opportunities, entity registrations, and assistance listings.

UAMS Internal Research Suite

UAMS personnel with permission can view their Notice of Award and related grant documents in the internal grants portal:

UAMS Grants Portal (MUSE)
Details & guidance
  • Paste the exported table or upload the exported file for each report.
  • Run each of the three Workday reports listed on the cards, then either copy the whole table (including the header row) and paste it into the card, or drop the exported .xlsx, .xlsb, or .csv file on the card.
  • Columns are matched by their header name, so extra columns or a different column order are fine — just do not delete the header row.
  • Budget vs Actuals supplies budget, actuals, commitments, obligations, and available balance. Actual Expenses supplies month-by-month detail and all subrecipient expenses. Effort Allocations supplies salary, fringe, and effort.
  • A card turns green with a row count when the import works. If it says a column is missing, re-export from Workday without hiding or renaming columns.
  • Re-import any card at any time to refresh that data; the rest of the report stays as it is.

Budget vs Actuals

RPT – Grant Budget vs Actual – Object Class (UAMS)

Drag and drop a file here, click Upload, or paste the table.

Actual Expenses

Actuals Restricted – Details View

Drag and drop a file here, click Upload, or paste the table.

Effort Allocations

RPT – Grant/Award Base Pay Allocations

Drag and drop a file here, click Upload, or paste the table.

Loading saved work…