|
|
|
|
|
|
|
|
|
| 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 |