Changing the Balance Sheet (account groups) template design

The Balance Sheet - Account Groups template creates a balance sheet based on the default account groups in Ajera.

If you have already customized the account groups list for your firm, you will need to change the template design to fit your firm's needs.

To do this:

Step 1: Verify the rows

Each account group you have set up to print on your current balance sheet will need to appear in the statement design in the Financial Statement Designer.

  1. From the > Reports menu, click Manage Financial Statements > Designs. A blank worksheet appears.
  2. Click Open, and double-click Template - Balance Sheet - Account Group Summary. The Balance Sheet - Account Group Summary template design appears.
  • The design contains the following sections: Assets, Liabilities, and Equity.
  • The Amounts row in each section is based on an account group, except the Net Income row in the Equity section. This row is based on your profit and loss account types.
  1. In the template design, start with the first Amounts row in the design. Verify that each Amounts row is correct:
  1. Click the first Amounts row in the worksheet. The account group for that row appears in the properties area, below the worksheet.
  2. If this account group does not exist or is incorrect, click in the Account Group list and select the correct account group. (For more information, see Setting up Amounts rows.)
  1. To delete an Amounts row, right-click the row and click Delete.
  2. To add an Amounts row:
  1. Right-click the totals row and click Insert. A blank row appears above the current row.
  2. Click the blank row, and click the Amounts button.
  3. Click the Account Groups button.
  4. Click in the Account Group list and select the correct account group.
  5. Click the Summarized button.
  6. Based on the account group, select or clear the Reverse sign check box.

For example, this check box is cleared for the account groups in the Assets section in the design, and selected for the account groups in the Liabilities and Equity sections.

  1. If you have accounts without account groups, you will need to set up new Amounts rows for these accounts so that they appear on the statement. You can set up an Amounts row by account range, ID range, or account type. (For more information, see Setting up Amounts rows.)

Step 2: Verify the columns

Each column you have set up to print on your current balance sheet will need to appear in the statement design.

The design contains a defined column for Current Balance. Each Amounts row will print the current balance, except for the Equity section. This section will print the retained earnings balance for the Capital account group and this year's activity amount for the Net Income account types.

To add a column:

  1. If needed, right-click a column letter at the top of the worksheet and click Insert.
  2. Click a blank cell in the Column Setup row, and select the correct option in the properties area or enter a formula.