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:
Fiscal Year Start
|
January 1, 2012
|
Fiscal Year End
|
December 31, 2012
|
Month End
|
December 31, 2012
|
Then when you do the following:
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
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
|
|