The GL function is the fundamental F9 formula, as it links any cell in your spreadsheet to any balance in your General Ledger. This is accomplished with a string of parameters that tell F9 what balance you would  like returned.

The syntax of the GL formula is: =GL (Account, Period,Organization, Year, Activity, Class).

  1. Account = General Ledger account number
  2. Period = Fiscal period
  3. Organization = Specific organization (Database)
  4. Year = Fiscal year
  5. Activity = Account type activity we wish to see (Actual or Budget)
  6. Class = Fund class (restricted, unrestricted, temporarily restricted)