Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
gl_excel:parameters [2010/06/18 13:32 UTC] – added TFR lines to AcctNum section mwolfe | gl_excel:parameters [2023/07/24 14:33 UTC] (current) – external edit 127.0.0.1 | ||
---|---|---|---|
Line 1: | Line 1: | ||
===== Parameters ===== | ===== Parameters ===== | ||
This page provides a description of all of the parameters that are used throughout the GL functions in Excel. | This page provides a description of all of the parameters that are used throughout the GL functions in Excel. | ||
+ | |||
+ | ===== To Quote or not to Quote ===== | ||
+ | * Use quotes if you are using the **actual** data in the formula: **=Balance(" | ||
+ | * Don’t use quotes if you are **referring** to the cell that holds the data: | ||
+ | * Cell A1 would then contain **SC11** **not** **" | ||
+ | * Cell B1 would then contain **12/ | ||
+ | Please note that all examples given on this page show quoted data, as would be used if the values were directly entered into the formula. | ||
+ | |||
==== AcctNum ==== | ==== AcctNum ==== | ||
The GL account number or TFR line number. | The GL account number or TFR line number. | ||
Line 8: | Line 16: | ||
" | " | ||
%fineprint{Used in: [[AvgBal]], [[Balance]], | %fineprint{Used in: [[AvgBal]], [[Balance]], | ||
- | |||
==== AvgBalDate ==== | ==== AvgBalDate ==== | ||
- | The **month and year** for which to compute the daily average balance (when used **without** the optional StartDate parameter). | + | The date that represents the **month and year** for which to compute the daily average balance (when used **without** the optional StartDate parameter). |
- | 3/ | + | |
- | | + | "3/1/2009" |
- | 3/ | + | |
| | ||
- | The month and year **through** which to compute the daily average balance (when used **with** the optional StartDate parameter). | + | The date that represents 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/ | + | |
- | | + | "3/1/2009", with StartDate of 1/ |
- | 3/17/2009, with StartDate of 1/ | + | |
- | %fineprint{Used in: [[AvgBal]], [[LineAverage]], | + | %fineprint{Used in: [[AvgBal]], [[FedRptAvgBal]], [[LineAverage]], |
==== BalanceDate ==== | ==== BalanceDate ==== | ||
The date used to retrieve account balances from the General Ledger. | The date used to retrieve account balances from the General Ledger. | ||
- | | + | "1/31/2009" |
- | 12/ | + | |
- | 12/31/2009 8:00 PM Account balances after posting the year-end close out batch (ie, income + expense = 0) | + | |
- | %fineprint{Used in: [[Balance]], | + | %fineprint{Used in: [[Balance]], [[FedRptBalance]], [[LineBalance]], |
==== BudgetDate ==== | ==== BudgetDate ==== | ||
- | The **month and year** used to retrieve the budget numbers | + | The date that represents the **month and year** used to retrieve the budget numbers |
- | 3/ | + | |
- | | + | "3/1/2009" |
- | 3/ | + | |
- | %fineprint{Used in: [[Budget]], [[LineBudget]], | + | %fineprint{Used in: [[Budget]], [[FedRptBudget]], [[LineBudget]], |
==== ColDate ==== | ==== ColDate ==== | ||
+ | The date of the user report column created by going to Edit Columns from the Edit User Report form in the General Ledger. | ||
+ | " | ||
+ | " | ||
%fineprint{Used in: [[LineColumn]]}% | %fineprint{Used in: [[LineColumn]]}% | ||
==== ColName ==== | ==== ColName ==== | ||
+ | Name of the user report column created by going to Edit Columns from the Edit User Report form in the General Ledger. | ||
+ | "AVG BAL" | ||
+ | "QTD Average Balance" | ||
+ | "YTD Avg Bal (Month End Adjusted)" | ||
%fineprint{Used in: [[LineColumn]]}% | %fineprint{Used in: [[LineColumn]]}% | ||
==== Company ==== | ==== Company ==== | ||
- | %fineprint{Used in: [[LineAverage]], | + | The company suffix code used to restrict user report numbers to a single company. |
+ | | ||
+ | " | ||
+ | "" | ||
+ | " | ||
+ | " | ||
+ | " | ||
+ | |||
+ | %fineprint{Used in: [[FedRptAvgBal]], | ||
+ | |||
+ | ==== Concept ==== | ||
+ | The 8-character alphanumeric Call Report concept code. | ||
+ | " | ||
+ | " | ||
+ | %fineprint{Used in: [[CallRptDescription]], | ||
==== LineCode ==== | ==== LineCode ==== | ||
+ | The 3-digit user report line item code. | ||
+ | " | ||
+ | " | ||
%fineprint{Used in: [[LineAverage]], | %fineprint{Used in: [[LineAverage]], | ||
+ | |||
+ | ==== LineNum ==== | ||
+ | The abbreviated federal report line number. | ||
+ | " | ||
+ | " | ||
+ | " | ||
+ | %fineprint{Used in: [[FedRptAvgBal]], | ||
+ | |||
==== PosNeg ==== | ==== PosNeg ==== | ||
Limit results to **P**ositive, | Limit results to **P**ositive, | ||
- | P Show balance only if positive, otherwise display: | ||
- | N Show balance only if negative, otherwise display: | ||
- | D Show positive number if debit balance, otherwise display: | ||
- | C Show positive number if credit balance, otherwise display: | ||
- | %fineprint{Used | + | When evaluating numeric formulas such as SUM, Excel treats text as 0. This makes it possible to use this PosNeg parameter to include results of GL formulas |
+ | " | ||
+ | " | ||
+ | " | ||
+ | " | ||
+ | %fineprint{Used in: [[AvgBal]], [[Balance]], | ||
+ | |||
+ | ==== RptDate ==== | ||
+ | The month-end date that corresponds to the respective Call Report reporting period. | ||
+ | " | ||
+ | " | ||
+ | %fineprint{Used in: [[CallRptValue]]}% | ||
+ | |||
+ | ==== RptName ==== | ||
+ | The name of the federal report (not its description) | ||
+ | " | ||
+ | " | ||
+ | %fineprint{Used in: [[FedRptAvgBal]], | ||
+ | | ||
==== StartDate ==== | ==== StartDate ==== | ||
- | The month and year **from** which to compute the daily average balance (used only with the required AvgBalDate parameter). | + | The date that represents 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/ |
- | 1/31/2009, with AvgBalDate of 3/ | + | |
- | 1/17/2009, with AvgBalDate of 3/ | + | |
- | %fineprint{Used in: [[AvgBal]], [[LineAverageRound]]}% | + | %fineprint{Used in: [[AvgBal]], [[FedRptAvgBal]], [[LineAverageRound]]}% |
==== UserRpt ==== | ==== UserRpt ==== | ||
The name of the user report (not its description) | The name of the user report (not its description) | ||
- | BALCON | + | |
- | INCST2 | + | |
%fineprint{Used in: [[LineAverage]], | %fineprint{Used in: [[LineAverage]], |