WISDM and Other Budget Resources

WISDM

Account Tracking Spreadsheets - Why use them?

  • To make notes(i.e. “transfer expense to John’s grant account when posted”)
  • To input revenue and expenses when they occur/are promised, know actual balance at any point in time
  • To input estimates, know how much is left to spend (especially close to year end)

Sample Account Tracking Spreadsheet (Use tabs to see different samples and templates)

  • Simple vertical, use for grants or other low volume accounts
  • Cross tab, use for department accounts (detailed and summarized versions)
  • Small cross tab, use for undergrad research accounts

Sample Account Tracking Spreadsheet - Art Faculty

Reconciliation Instructions

Business Processes