Setting up columns

Follow these instructions as part of designing a financial statement.

If you have rows of account information that you want to filter in the same way, you may want to set up a row as a Column Setup row and define the column contents.

You do this by:

Ajera enters the data you define in the column of the current row and continues down the column until you define another Column Setup row.

Note: You can define columns without using a Column Setup row, but you will have to define each cell in the column individually.

Step 1: Defining a row as a Column Setup row

  1. Select a row in the first column of the worksheet. The first column is a work area only and does not print on the statement.

  1. Click the Column Setup button. The Column Setup and Column Headings rows appear in the worksheet.

Step 2: Defining column contents

  1. Click a cell in the Column Setup row. The Content List buttons, options, and fields appear.

  1. You can define the contents of the column by either selecting a Content List option or using a formula. For a full list of the options, see Content List options.

To select an option, do the following. Otherwise, proceed to the next step to enter a formula.

To display this

Click this button

The information comes from

Information from the chart of accounts

Account

And double-click an option such as Account Description, Account ID, and so on.

> Setup > Company > Financials > Chart of Accounts

Account activity for a specific time frame, excluding closing entries

Activity

And double-click an option such as This Month This Year, Last Quarter Last Year, and so on.

Month-End Date field on the Workbook Properties sheet

Account balances at a specific point in time, including all previous closing entries

Balance

And double-click an option such as Current Balance This Year, Retained Earnings Balance Two Years Ago, and so on.

Month-End Date field on the Workbook Properties sheet

Accrual budget amounts for a specific time frame

Budget

And double-click an option such as Budget This Month This Year, January Budget Three Years Ago, and so on.

Month-End Date field on the Workbook Properties sheet

Note:

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.

Credit or debit account activity for a specific time frame

Cash Flow

And double-click an option such as This Month Debit This Year, Year End Credit Four Years Ago, and so on.

Month-End Date field on the Workbook Properties sheet

Activity, balance, or cash-flow information for a time frame or point in time that you specify

Note: Custom account balances do not include all previous closing entries.

Custom

And double-click a custom date property.

Custom Date Properties window and the Month-End Date field on the Workbook Properties sheet

The worksheet displays a label for the Content List option you selected.

Repeat these instructions for the other columns, as needed.

  1. To define the cell with a formula:
  1. Enter it into the cell. The formula appears in the worksheet.

Ajera supports common spreadsheet formulas. You can use formulas to define percentages, variances, key ratios, and so forth. In the following example, a formula for variance between Activity This Month (B5) and Budget This Month (C5) is =B5-C5.

  1. In the Format group of the toolbar, select Currency, Percent, or Number to define the values in the column as currency, percentages, or numbers, as needed.
  2. Repeat these instructions to define other columns, as needed.

Step 3: Using column filters (optional)

unavailable in ajeraCore unless you have the Departments add-on

  1. To filter the information in a column for a department or reporting entity, select the column. If you use multi-company, you can also filter by company.
  2. Click in the Department or Reporting Entity field, and select a department or reporting entity. If you use multi-company, you can also select a company.
Note:

By default, the Department List window and Reporting Entity List window display both active and inactive items but do not indicate the status. To view the status, click (Customize) and select the Status check box.

  1. Make sure that the column heading (see next step) indicates the company (multi-company only), department, or reporting entity chosen.

Step 4: Changing column headings and formatting

  1. Click a cell in the Column Headings row, and change the heading or enter a descriptive new heading.

  1. Use the toolbar to format and align the heading and apply borders. Repeat for the other column headings in that row.
  2. Resize rows or columns by dragging the row or column edges.
  3. If you want to add or delete a row or column to the design, right-click a row or column and click Insert or Delete.
  4. To create a space between columns, insert a blank column.