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 > Setup > Company > Preferences
  • Multi-company only. Fiscal Year fields in > Setup > 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

Is

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.

If the custom date property is from 12/15/2010 to 1/12/2011 and the month-end date is 12/31/2010, financial information from 12/15/2010 to 12/31/2010 appears.

Next: Designing a financial statement