gl_excel:linebudget

LineBudget

This function returns the budget of a user report line for a given month and year. The day portion of the date is ignored.

When budget numbers are entered in the GL they are entered for the current month only. However, for income and expense accounts, the LineBudget function returns the cumulative year-to-date budget number. For example, if a user report line consisted of a single income account that had a constant monthly budget of $10,000 per month, the LineBudget function would return $40,000 for the April budget.

LineBudget(UserRpt, LineCode, BudgetDate, Company)

  • =LineBudget("BALCON", "A01", "7/31/2009") Returns the budget for line A01 of the BALCON user report for the month of July 2009.
  • =LineBudget("BALCON", "A01", "3/17/2009", "Cit") Returns the budget for the Citizens Savings Bank accounts in line A01 of the BALCON user report for the month of March 2009 (ie, it excludes all of the service company accounts). See below for more information about the Company parameter.

UserRpt

The name of the user report (not its description)

"BALCON"
"INCST2"

%fineprint{Used in: LineAverage, LineAverageRound, LineBalance, LineBudget, LineBudgetRound, LineColumn, LineDescription, LineRound}%

LineCode

The 3-digit user report line item code.

"A01"
"C15"

%fineprint{Used in: LineAverage, LineAverageRound, LineBalance, LineBudget, LineBudgetRound, LineColumn, LineDescription, LineRound}%

BudgetDate

The date that represents 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, FedRptBudget, LineBudget, LineBudgetRound}%

Company

The company suffix code used to restrict user report numbers to a single company. To include all companies, either 1) do not enter anything for this parameter or 2) use the abbreviation "Con" (for Consolidated). To include only the default Citizens company, use either 1) double quotes with nothing inside: "" or 2) the abbreviation "Cit" (for Citizens).

           Consolidated
"Con"      Consolidated
""         Citizens Savings Bank
"Cit"      Citizens Savings Bank
"CSA"      CSA Services, LLC
"CSB"      CSB Services, Inc.

%fineprint{Used in: FedRptAvgBal, FedRptBalance, FedRptBudget, LineAverage, LineBalance, LineBudget}%

  • gl_excel/linebudget.txt
  • Last modified: 2023/07/24 14:33 UTC
  • by 127.0.0.1