This is an old revision of the document!
FedRptBudget
This function returns the total budget of a Federal Report line as of a certain date.
%InlineCode{FedRptBalance(RptName, LineNum, BudgetDate, Company)}%
Example Usage
- %InlineCode{=FedRptBudget("TFR", "SC11", "7/31/2009")}% Returns the balance for line SC11 of the TFR Federal Report as of July 31, 2009.
- %InlineCode{=FedRptBudget("TFR", "SC26", "3/17/2009", "Cit")}% Returns the budget for 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}%
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, FedRptBalance, LineBalance, LineRound}%
Optional Parameters
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}%