FedRptBudget

FedRptBudget

This function returns the total budget of a Federal Report line as of a certain date.

FedRptBalance(RptName, LineNum, BudgetDate, Company)

Example Usage

=FedRptBudget("TFR", "SC11", "7/31/2009") Returns the balance for line SC11 of the TFR Federal Report as of July 2009.
=FedRptBudget("TFR", "SC26", "3/17/2009", "Cit") Returns the budget for March 2009 of the Citizens Savings Bank accounts in line SC26 of the TFR Federal Report (ie, it excludes all of the service company accounts). See below for more information about the Company parameter.

Required Parameters

RptName

The name of the federal report (not its description)

"Call"
"TFR"

%fineprint{Used in: FedRptAvgBal, FedRptBalance, FedRptBudget, FedRptDescription}%

LineNum

The abbreviated federal report line number.

"SC11"
"SO141"
"RI-4435"

%fineprint{Used in: FedRptAvgBal, FedRptBalance, FedRptBudget, FedRptDescription}%

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}%

Optional Parameters

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}%

Table of Contents