Previous  Next          Contents  Index  Navigation  Glossary  Library

Example: Quarter Average-to-Date Balance

Expanding on the period average-to-date example, the following example illustrates how quarter average-to-date balances are calculated by General Ledger.

In this example, the ending balance for March 31st was $70,000.

Example: Quarter Average-to-Date Calculation
Day Daily Activity Ending
Balance
PTD
Aggregate Balance
QTD
Aggregate Balance
QTD
Range
April 1 $2,000 $72,000 $72,000 $72,000 1
April 2 $3,000 $75,000 $147,000 $147,000 2
April 3 ($1,000) $74,000 $221,000 $221,000 3
: : : : : :
: : : : : :
June 1 $5,000 $105,000 $105,000 $5,145,000 62
June 2 $8,000 $113,000 $218,000 $5,258,000 63
June 3 $4,000 $117,000 $335,000 $5,375,000 64

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

    = QTD Aggregate Balance (as of June 3)
divided by QTD Range (number of days: quarter-to-date)
    = $5,375,000 / 64 days
    = $83,984.38

Note: The QTD aggregate balance is reset to zero at the beginning of each quarter. Accordingly, throughout the first period of a quarter, the PTD and QTD aggregate balances for any day are the same.

Additional Information: Some financial institutions calculate quarter average-to-date balances by summing the three period ending averages-to-date for the quarter and dividing by three. You can use General Ledger's Financial Statement Generator to create a custom report using this calculation method for quarter average-to-date.

See Also

General Example

Relationship Between Aggregate and Average Balances

Example: Period Average-to-Date Balance

Example: Year Average-to-Date Balance


         Previous  Next          Contents  Index  Navigation  Glossary  Library