gl_excel:fedrptavgbal

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Last revisionBoth sides next revision
gl_excel:fedrptavgbal [2014/03/13 21:20 UTC] – [Example Usage] mwolfegl_excel:fedrptavgbal [2014/03/13 21:26 UTC] – [FedRptAvgBal] mwolfe
Line 1: Line 1:
 ====== FedRptAvgBal ====== ====== FedRptAvgBal ======
-This is the Federal Report Average Balance function.  It returns the daily average balance of a Federal Report line for a given month (or span of months).+This is the Federal Report Average Balance function.  It returns the daily average balance of a Federal Report line for a given month (or span of months).   
 + 
 +The daily average balance is calculated by adding the balance at the end of each day in the time span and then dividing by the total number of days in that span.  A daily average is calculated for each individual account.  This final average is used to determine where an account's balance is reported for accounts whose balances are reported on different lines depending on whether the account has a positive or negative balance.
  
 The Federal Reports are accessible from the GL's Main Menu via the button [Fed Rpt Lines]. The Federal Reports are accessible from the GL's Main Menu via the button [Fed Rpt Lines].
  • gl_excel/fedrptavgbal.txt
  • Last modified: 2023/07/24 14:33 UTC
  • by 127.0.0.1