Monthly Review & Reconciliation

The following documents and tools will provide additional assistance during the review and reconciliation process.

• Expenditure Type Look Up Tool (link updated 4/1/2008)
• Reference Code Table - most commonly used source codes and contact information (updated 08/06/2008)
• Earning Codes (for reconciliation)
• Vacation Resource Page - includes links to forms, policies, tools and examples
  • Salary and Vacation Accrual Example
• Chart of Account resources - includes links to chart of account information, forms and tools
• Issues and Resolutions - a cumulative spreadsheet containing all known issues with Expenditure Detail Reports, resolutions, parties responsible for resolution, and dates issues were (or will be) resolved. (opens in Excel)
  Note: As of May, 2006, this spreadsheet will only be updated if an issue related to expenditure or revenue reports occurs.

Frequently Asked Questions

• Expenditure & Revenue Detail FAQ (updated 03/12/2008)

Additional Web Resources

• Treatment of Capital Expenditures in Oracle - Scroll down to "Reclassifying or Transferring Capital Equipment Expenditures"
• Capital Expenditures on Expenditure and Fund Reports
• Expenditure Type - this excel spreadsheet contains 5 tabs with the following:
  • Explanation
  • Descriptions and Rules
  • Old to New with Titles
  • Discussion
  • Sal, Vac and Fringe
• Objects List of Values (LOV)
• Project Types Job Aid
• Service Types (on Tasks)
• Award Types
• Award Purpose
• Fund/Award Number ranges
• Expenditure Item Date Job Aid
• Managing your Money

Topical Research Administration Resources

• Cost Sharing
• Effort Allocation
• NIH Salary Caps
• Stewardship and Compliance for Stanford PIs
• Tracking Committed Effort