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:35 UTC] – update LineCode 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. | The 3-digit user report line item code. | ||
Line 46: | Line 75: | ||
" | " | ||
%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, | ||
+ | |||
+ | 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 in your other Excel formulas only in specific circumstances. | ||
" | " | ||
" | " | ||
Line 54: | Line 92: | ||
" | " | ||
- | %fineprint{Used in: [[AvgBal]], [[Balance]], | + | %fineprint{Used in: [[AvgBal]], [[Balance]], [[FedRptAvgBal]], |
+ | ==== 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) |