Amount Types for Average Balance Processing
If you have enabled average balance processing for your ledger, every time you post a transaction, the application updates the standard period-end balances and all the average balances.
This includes the aggregate balances, End-of-Day balance, Daily Activity balance, Period Average-to-Date balance, Quarter Average-to-Date balance, and Year Average-to-Date balance.
The following amount types are available in the General Ledger average balances cube for inquiry or reporting using the Inquire and Analyze Average Balances page, Smart View, or reports created in Financial Reporting Web Studio:
-
End-of-Day (EOD)
-
Daily Activity
-
Period Average-to-Date (PATD)
-
Quarter Average-to-Date (QATD)
-
Year Average-to-Date (YATD)
Daily activity balances in the General Ledger average balances cube are derived by subtracting the prior day's EOD balance from today's EOD balance. PATD, QATD, and YATD balances are derived by summing the EOD balances for each day into an aggregate balance that's divided by the correct number of days in a period, quarter, and year.
Types of Average Balances
To satisfy different reporting and analysis requirements, the application tracks these types of average balances:
-
Period average-to-date
-
Quarter average-to-date
-
Year average-to-date