Previous Next Contents Index Navigation Glossary Library

## Example: Year Average-to-Date Balance

Expanding on the previous two examples, the following example illustrates how year average-to-date balances are calculated by General Ledger.

In this example, the ending balance for December 31st of the previous year was \$50,000.

 Example: Year Average-to-Date Calculation Day Daily Activity Ending Balance PTD Agg. Bal. QTD Agg. Bal. YTD Agg. Bal. YTD Rng Jan. 1 \$4,000 \$54,000 \$54,000 \$54,000 \$54,000 1 Jan. 2 \$2,000 \$56,000 \$110,000 \$110,000 \$110,000 2 Jan. 3 \$0 \$56,000 \$166,000 \$166,000 \$166,000 3 : : : : : : : : : : : : : : Apr. 1 \$2,000 \$72,000 \$72,000 \$72,000 \$5,711,000 91 Apr. 2 \$3,000 \$75,000 \$147,000 \$147,000 \$5,786,000 92 Apr. 3 (\$1,000) \$74,000 \$221,000 \$221,000 \$5,860,000 93 : : : : : : : : : : : : : : June 1 \$5,000 \$105,000 \$105,000 \$5,145,000 \$10,784,000 152 June 2 \$8,000 \$113,000 \$218,000 \$5,258,000 \$10,897,000 153 June 3 \$4,000 \$117,000 \$335,000 \$5,375,000 \$11,014,000 154

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

 = YTD Aggregate Balance (as of June 3) divided by YTD Range (number of days: year-to-date) = \$11,014,000 / 154 days = \$71,519.48

Note: The YTD aggregate balance is reset to zero at the beginning of each year. Accordingly, for every day in the first period of a year, the PTD, QTD, and YTD aggregate balances are the same. Also note that all three aggregate balances, for all asset, liability, and equity accounts, are reset to zero at the beginning of a new year.

Additional Information: Some financial institutions calculate year average-to-date by summing all the period ending averages-to-date within the year and dividing by the number of periods, excluding any adjusting periods. Another alternative is to sum the four quarter averages-to-date and divide by four. You can use General Ledger's Financial Statement Generator to create a custom report using either of these calculation methods for year average-to-date.

General Example

Overview

Major Features

Effective Date Handling

Set Up and Maintenance

Multi-Currency Processing

Consolidation

On-line Inquiry

Reporting

Previous  Next          Contents  Index  Navigation  Glossary  Library