This is an old revision of the document!
Parameters
This page provides a description of all of the parameters that are used throughout the GL functions in Excel.
AcctNum
The GL account number or TFR line number. This must include any applicable company abbreviations.
"1010-000" "1010-000CSB" "SC110" "SO11"
%fineprint{Used in: AvgBal, Balance, Budget, Description}%
AvgBalDate
The month and year for which to compute the daily average balance (when used without the optional StartDate parameter).
"3/31/2009" Returns the daily average balance for 3/1/2009 through 3/31/2009, inclusive "3/1/2009" Returns the daily average balance for 3/1/2009 through 3/31/2009, inclusive "3/17/2009" Returns the daily average balance for 3/1/2009 through 3/31/2009, inclusive
The month and year through which to compute the daily average balance (when used with the optional StartDate parameter).
"3/31/2009", with StartDate of 1/1/2009 Returns the daily average balance for 1/1/2009 through 3/31/2009, inclusive "3/1/2009", with StartDate of 1/31/2009 Returns the daily average balance for 1/1/2009 through 3/31/2009, inclusive "3/17/2009", with StartDate of 1/12/2009 Returns the daily average balance for 1/1/2009 through 3/31/2009, inclusive
%fineprint{Used in: AvgBal, LineAverage, LineAverageRound}%
BalanceDate
The date used to retrieve account balances from the General Ledger. End of year closeout transactions are posted as of 6:00 PM on December 31. A balance date of 12/31 will return balances for income and expense accounts, while a balance date of 12/31 8:00PM will return zero for all income and expense accounts and reflect an accurate year-end close out equity fund balance.
1/31/2009 Account balances as of the end of the day on January 31, 2009 12/31/2009 Account balances prior to posting the year-end close out batch (ie, income + expense > 0) 12/31/2009 8:00 PM Account balances after posting the year-end close out batch (ie, income + expense = 0)
%fineprint{Used in: Balance, LineBalance, LineRound}%
BudgetDate
The month and year used to retrieve the budget numbers
3/31/2009 Returns the budget for March 2009 3/1/2009 Returns the budget for March 2009 3/17/2009 Returns the budget for March 2009
%fineprint{Used in: Budget, LineBudget, LineBudgetRound}%
ColDate
%fineprint{Used in: LineColumn}%
ColName
%fineprint{Used in: LineColumn}%
Company
%fineprint{Used in: LineAverage, LineBalance, LineBudget}%
LineCode
The 3-digit user report line item code.
"A01" "C15"
%fineprint{Used in: LineAverage, LineAverageRound, LineBalance, LineBudget, LineBudgetRound, LineColumn, LineDescription, LineRound}%
PosNeg
Limit results to Positive, Negative, Debit, or Credit only. You may spell out or abbreviate Positive, Negative, Debit, and Credit if you would like to make your formula more readable; the function performs a match on the first character only.
"P" Show balance only if positive, otherwise display: Neg Balance "N" Show balance only if negative, otherwise display: Pos Balance "D" Show positive number if debit balance, otherwise display: Credit Balance "C" Show positive number if credit balance, otherwise display: Debit Balance
%fineprint{Used in: AvgBal, Balance, LineAverage, LineAverageRound, LineBalance, LineRound}%
StartDate
The month and year from which to compute the daily average balance (used only with the required AvgBalDate parameter).
1/1/2009, with AvgBalDate of 3/31/2009 Returns the daily average balance for 1/1/2009 through 3/31/2009, inclusive 1/31/2009, with AvgBalDate of 3/1/2009 Returns the daily average balance for 1/1/2009 through 3/31/2009, inclusive 1/17/2009, with AvgBalDate of 3/12/2009 Returns the daily average balance for 1/1/2009 through 3/31/2009, inclusive
%fineprint{Used in: AvgBal, LineAverageRound}%
UserRpt
The name of the user report (not its description)
"BALCON" "INCST2"
%fineprint{Used in: LineAverage, LineAverageRound, LineBalance, LineBudget, LineBudgetRound, LineColumn, LineDescription, LineRound}%