Previous | Next | Contents | Index | Navigation | Glossary | Library |
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 |
= | 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.
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 |