Both sides previous revision Previous revision Next revision | Previous revision |
gl_excel:balance [2010/06/18 15:58 UTC] – mwolfe | gl_excel:balance [2023/07/24 14:33 UTC] (current) – external edit 127.0.0.1 |
---|
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{Balance(AcctNum, BalanceDate, //PosNeg//)}% | **Balance(AcctNum, BalanceDate, //PosNeg//)** |
| |
==== Example Usage ==== | ==== Example Usage ==== |
* %InlineCode{=Balance("1010-000", "7/31/2009")}% Returns the balance for account 1010-000 as of the end of the day July 31, 2009. | * **=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 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. |
* %InlineCode{=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")** 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. | * **=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. | * **=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 ==== |
| |
==== Required Paramaters ==== | |
{{section>parameters#acctnum}} | {{section>parameters#acctnum}} |
{{section>parameters#balancedate}} | {{section>parameters#balancedate}} |
| |
==== Optional Parameters ==== | ==== Optional Parameters ==== |
{{section>parameters#posneg}} | {{section>parameters#posneg}} |