Previous  Next          Contents  Index  Navigation  Glossary  Library

Example: Period Average-to-Date Balance

The following example illustrates how period average-to-date balances are calculated by General Ledger.

This example assumes that we are looking at the activity and balances for one account in a set of books. The ending balance for May 31st was $100,000.

Example: Period Average-to-Date Calculation
Day Activity Ending
Balance
PTD Aggregate Balance PTD
Range
June 1 $5,000 $105,000 $105,000 1
June 2 $8,000 $113,000 $218,000 2
June 3 $4,000 $117,000 $335,000 3

The period average-to-date balance for June 3rd:

    = PTD Aggregate Balance (as of June 3)
divided by PTD Range (number of days: period-to-date)
    = $335,000 / 3 days
    = $111,666.67

Note: The PTD aggregate balance is reset to zero at the beginning of each period.

See Also

General Example

Relationship Between Aggregate and Average Balances

Example: Quarter Average-to-Date Balance

Example: Year Average-to-Date Balance


         Previous  Next          Contents  Index  Navigation  Glossary  Library