gl_excel:balance

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision
Previous revision
gl_excel:balance [2010/06/18 15:57 UTC] – created mwolfegl_excel:balance [2023/07/24 14:33 UTC] (current) – external edit 127.0.0.1
Line 1: Line 1:
 ====== Balance ====== ====== Balance ======
 This function returns the balance of a GL account or TFR line number as of a certain date. This function returns the balance of a GL account or TFR line number as of a certain date.
-%InlineCode{AvgBal(AcctNum, BalanceDate, //PosNeg//)}% 
  
-==== Example Usage ==== +**Balance(AcctNumBalanceDate, //PosNeg//)**
-  %InlineCode{=Balance("1010-000", "7/31/2009")}%  Returns the balance for account 1010-000 as of the end of the day July 31, 2009. +
-  %InlineCode{=Balance("SC110""1/31/2009")}% Returns the balance for TFR line number SC110 as of the end of the day January 312009. +
-  * %InlineCode{=Balance("3110-000", "12/31/2009")}% Returns the balance for income account 3110-000 just prior to the 2009 year-end closeout. +
-  * %InlineCode{=Balance("3110-000", "12/31/2009 8:00PM")}% Returns 0.00 because 3110-000 is an income account and 8:00 PM is past the year-end closeout time. +
-  %InlineCode{=Balance("1010-000", "3/17/2009", "C")}%  Returns 'Debit Balance' because the balance for account 1010-000 on March 17, 2009 was a debit balance and the "C" in our formula told Excel to only display the balance if it was a credit.  See below for more information about the PosNeg parameter.+
  
- +==== Example Usage ==== 
-==== Required Paramaters ====+  * **=Balance("1010-000", "7/31/2009")**  Returns the balance for account 1010-000 as of the end of the day July 31, 2009. 
 +  * **=Balance("SC110", "1/31/2009")** Returns the balance for TFR line number SC110 as of the end of the day January 31, 2009. 
 +  * **=Balance("3110-000", "12/31/2009")** Returns the balance for income account 3110-000 just prior to the 2009 year-end closeout. 
 +  * **=Balance("3110-000", "12/31/2009 8:00PM")** Returns 0.00 because 3110-000 is an income account and 8:00 PM is past the year-end closeout time. 
 +  * **=Balance("1010-000", "3/17/2009", "C")**  Returns 'Debit Balance' because the balance for account 1010-000 on March 17, 2009 was a debit balance and the "C" in our formula told Excel to only display the balance if it was a credit.  See below for more information about the PosNeg parameter. 
 +==== Required Parameters ====
 {{section>parameters#acctnum}} {{section>parameters#acctnum}}
 {{section>parameters#balancedate}} {{section>parameters#balancedate}}
 +
 ==== Optional Parameters ==== ==== Optional Parameters ====
 {{section>parameters#posneg}} {{section>parameters#posneg}}
  • gl_excel/balance.1276876650.txt.gz
  • Last modified: 2010/06/18 15:57 UTC
  • by mwolfe