gl_excel:budget

Differences

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

Link to this comparison view

gl_excel:budget [2010/06/18 16:08 UTC] – created mwolfegl_excel:budget [2023/07/24 14:33 UTC] (current) – external edit 127.0.0.1
Line 4: Line 4:
 When budget numbers are entered in the GL they are entered for the current month only.  However, for income and expense accounts, the Budget function returns the cumulative year-to-date budget number.  For example, if an income account had a constant monthly budget of $10,000 per month, the Budget function would return $40,000 for the April budget. When budget numbers are entered in the GL they are entered for the current month only.  However, for income and expense accounts, the Budget function returns the cumulative year-to-date budget number.  For example, if an income account had a constant monthly budget of $10,000 per month, the Budget function would return $40,000 for the April budget.
  
-%InlineCode{Budget(AcctNum, BudgetDate)}%+**Budget(AcctNum, BudgetDate)**
  
 ==== Example Usage ==== ==== Example Usage ====
-  * %InlineCode{=Budget("1010-000", "7/31/2009")}%  Returns the budget for account 1010-000 for the month of July 2009. +  * **=Budget("1010-000", "7/31/2009")**  Returns the budget for account 1010-000 for the month of July 2009. 
-  * %InlineCode{=Budget("SC110", "1/11/2009")}% Returns the total budget for all accounts that comprise TFR line number SC110 for the month of January 2009. +  * **=Budget("SC110", "1/11/2009")** Returns the total budget for all accounts that comprise TFR line number SC110 for the month of January 2009. 
-  * %InlineCode{=Budget("3110-000", "12/31/2009")}% Returns the total 2009 budget for income account 3110-000.+  * **=Budget("3110-000", "12/31/2009")** Returns the total 2009 budget for income account 3110-000.
  
 ==== Required Parameters ==== ==== Required Parameters ====
  • gl_excel/budget.1276877294.txt.gz
  • Last modified: 2010/06/18 16:08 UTC
  • by mwolfe