Changing a custom date property

To change a custom date property

  1. Click an Amounts or Column Setup cell in the worksheet. The Content List buttons, options, and fields appear.
  2. Click the Custom button. All available custom date properties appear.
  3. Click the custom date property you want to change, and click (Change).
  4. In the Custom Date Property window, change the following information:

Field

Description

Description

The name of the custom date property. The maximum length is 78 characters.

As you type, the Property field displays how the description will appear in the worksheet and in the Ajera database. Ajera removes any spaces or special characters such as \ / : * ? " < > | , -.

Retained Earnings

If using a non-month-end date, check to reflect the correct balance in the Retained Earnings and Net Income rows on the Balance sheet.

Example: To report the balances as of a point in time and display the correct amount for Retained Earnings and Net Income, set up all custom Balance Sheet date properties as follows:

February 2014 : Beginning date: 1/1/1901. Ending date: 2/22/14. Mark the Retained Earnings check box.

Date Range

The dates for the custom date property, which work in conjunction with the month-end date on the Workbook Properties sheet and the reporting period for a statement group.

Field

Description

Beginning Date

The first date in the date property.

If you leave this blank, the field defaults to 1/1/1900.

Ending Date

The last date in the date property.

Cash Flow Options

Any cash-flow options that may apply.

  • Not Used: Select for any financial statement that is not a statement of cash flow.
  • Show debits only: Select if you want only debit information to appear in the date property.
  • Show credits only: Select if you want only credit information to appear in the date property.
  1. Click Save or Save As if you want to save it as a new custom date property.