About the Month-End Date field

To determine the time period for the financial information in your statement, Ajera uses the Month-End Date field on the Workbook Properties sheet in conjunction with the following:

Fiscal Year fields in Company > Preferences

Multi-company only. Fiscal Year fields in Company > Companies

Content List options (if selected) that are based on the Month-End Date field

For descriptions of all the Content List options, see Content List options.

Following are examples of how some of the Content List options work in conjunction with the Month-End Date field and the Fiscal Year fields. The examples are not meant to be comprehensive.

If you have the following fiscal year and month-end dates:

This date

Fiscal Year Start

January 1, 2012

Fiscal Year End

December 31, 2012

Month End

December 31, 2012

Then when you do the following:

Select this

Amounts for this time period appear

Company button:

Month Start Date

December 1, 2012

Month End Date

December 31, 2012

For N Months Ended MonthEndDate

For 12 Months Ended December 2012

For the N Quarter Ended QuarterEndDate

For the 4th Quarter Ended December 31, 2012

Fiscal Year Start Date

January 1, 2012

Fiscal Year End Date

December 31, 2012

Activity button:

This Month This Year, This Month Last Year, This Month Two Years Ago, and so on

December 2012, December 2011, December 2010, and so on

January This Year, January Last Year, January Two Years Ago, and so on

January 2012, January 2011, January 2010, and so on

This Quarter This Year, This Quarter Last Year, This Quarter Two Years Ago, and so on

4th Quarter 2012, 4th Quarter 2011, 4th Quarter 2010, and so on

Balance button:

Current Balance This Year, Current Balance Last Year, Current Balance Two Years Ago, and so on

Current date 2012, current date 2011, current date 2010, and so on

Balance Last Quarter This Year, Balance Last Quarter Last Year, Balance Two Quarters Ago Last Year, and so on

3rd Quarter 2012, 3rd Quarter 2011, 3rd Quarter 2010, and so on

Year End Balance This Year, Year End Balance Last Year, Year End Balance Two Years Ago, Year End Balance Three Years Ago, and so on

Current date 2012; December 31, 2011; December 31, 2010; and so on

Budget button:

Note:

When reporting budget amounts, the QTD and YTD options are based on and restricted by the month-end date. The other budget options are based on that date but not restricted by it.

Budget This Month This Year, Budget This Month Last Year, Budget This Month Two Years Ago, and so on

December 2012, December 2011, December 2010, and so on

January Budget This Year, January Budget Last Year, January Budget Two Years Ago, and so on

January 2012, January 2011, January 2010, and so on

Budget This Quarter This Year, Budget This Quarter Last Year, Budget This Quarter Two Years Ago, and so on

4th Quarter 2012, 4th Quarter 2011, 4th Quarter 2010, and so on

Cash Flow button:

This Month This Year, This Month Last Year, This Month Two Years Ago, and so on

December 2012, December 2011, December 2010, and so on

January This Year, January Last Year, January Two Years Ago, and so on

January 2012, January 2011, January 2010, and so on

This Quarter This Year, This Quarter Last Year, This Quarter Two Years Ago, and so on

4th Quarter 2012, 4th Quarter 2011, 4th Quarter 2010, and so on

Custom button:

Custom date properties that you define.

If the entire date property occurs before the month-end date, financial information for the entire date property appears.
If the entire date property occurs after the month-end date, no financial information appears.

If the date property begins before the month-end date but ends after it, financial information from the beginning of the date property through the month-end date appears. Example