Accounts dimension
From the Manage ACCT page, you can manage the Accounts dimension, which contains records for each account in the GL of your organization. This includes accounts that can be found on the balance sheet, income statement, and statistics.
TIP: You can manage your dimension tables by downloading them in spreadsheet form so that you can make larger changes more easily. You can then upload the spreadsheet with the changes back into the system database. For more information, see Editing a dimension using a spreadsheet.
To access the ACCT dimension:
-
From the Command Center home page, select System Administration.
Click image to view full size
-
On the System Administration page, click Manage Data.
Click image to view full size
-
On the Accounts sub-tab, click Open.
Click image to view full size
NOTE: The page can only display up to a maximum of 10,000 records.
Filtering records
To filter records:
-
Click the funnel
icon in the upper left corner of the page.
- In the Filter box, you can narrow down the records to display by selecting or creating a filter using the Filter Wizard. To access the Filter Wizard, click
Edit. If you are familiar with writing filter statements, you can type the statement syntax directly in the Filter box.
- Click Apply.
Adding or editing an account
Due to the large number of records that this table may contain, you need to use the Filter panel to identify the records to display.
To add or edit an account:
- In the table, do any of the following:
To add an account, click Add Row. The new row displays at the bottom of the table. Enter information in each column. After you save, the table will display the new row in order by the ACCT column.
NOTE: You can optionally add multiple rows to an account by clicking Add Rows. This displays the Add Rows dialog box, where you enter the number of rows that you want to add.
IMPORTANT: If you add a new record that already exists in the table, the system will overwrite the original column values with your new entries when you save your changes. We recommend that you review your entries before saving any changes.
To edit an account, click in the cell(s) to make your changes.
NOTE: Columns that are grayed out cannot be edited.
- To undo your changes, click the left arrow icon
.
- To redo your changes, click the right arrow icon
.
- When you finish making changes, click Save.
Deleting an account
Due to the large number of records that this table may contain, you need to use the Filter panel to identify the records to display.
To delete an account:
-
In the table, select the row to highlight it, and then click Delete Row.
- At the Continue? prompt, click OK.
- When you finish making changes, click Save.
This section provides descriptions for each column in the Accounts dimension table:
Column Name | Description |
---|---|
ACCT | The GL account number. The data type always has to integer. Integer columns can store a maximum of 19 digits. |
Description | The GL account number description. |
NewAcct |
Do the following:
|
AcctType | The GL account type classifications for balance sheet and income statement accounts. This column references column AcctType.AX_AcctType. Axiom comes with a number of standard account types. |
AccrualBasis | References the AccrualBasis.AX_Accrual_Basis column. The accrual basis codes of either ACT_ACT or Thirty_360 are assigned to balance sheet accounts. The AX_Accrual_Basis column is used in the creation of annualized interest records for yield reporting and by Axiom calculated columns within the GL and Management GL tables. |
YieldDTYPE | The yield data type column that must be assigned to all interest income/expense accounts for yield reporting records. This column references the DTYPE.DTYPE column. For more information about yield reporting data types, see DTYPE dimension. |
BalanceSheetAcct | The balance sheet account number to which interest income and interest expense accounts are associated. This column is used by Axiom to map interest income/expense amounts to balance sheet account numbers as the associated YieldDtype to create yield reporting records. The AX_BSACCT column references ACCT.ACCT column. The default value of AX_BSACCT is 0. |
TaxEquivalent | Specifies whether the account is taxable or not. |
DebitCreditCode | Specifies whether an account's positive balance is a debit or credit. |
ReportSign | The report sign applied to GL trial balance reports. |
BudgetActRollup | The Axiom budget account. |
BudgetDescription | The description of the Axiom planning - budget account. |
ForecastAcctRollup | The Axiom forecast account. |
ForecastDescription | The description of the Axiom forecast account. |
IsInterestAcct |
Do one of the following:
|
BudgetInUtility | Specifies that the account's budget projections are calculated by a budget utility. The system will exclude the account from the budget plan files. |
ForecastInUtility | Specifies that the account's budget projections are calculated by a budget utility. The system will exclude the account from the budget plan files. |
BudgetBalancing | The assignment of the account to a balancing utility category. |
ForecastBalancing | The assignment of the account to a balancing utility category. |
LoanLossReserveType | Identifies the predefined account types, such as Loan Balance, Reserve, etc. used by the planning Loan Loss Reserve utility. |
LoanLossReserveCategory | Identifies the loan category to which a loan account belongs. |
BudgetPlanCode | Specifies the budget plan code for a budget account that is to be centrally planned. |
ForecastPlanCode | Specifies the forecast plan code for a forecast account that is to be centrally planned. |
BudgetSheetSection | Specifies the section of a budget plan file where an account displays. |
ForecastSheetSection | Specifies the section of a forecast plan where an account displays. |
BudgetCalcMethod | The calculation method associated with the budget account. |
ForecastCalcMethod | The calculation method associated with the forecast account. |
BudgetNonTaxable | This field informs the Bank Balancer utility as to whether a budget income or expense account is non-taxable. |
ForecastNonTaxable | This field informs the Bank Balancer utility as to whether a forecast income or expense account is non-taxable. |
BudgetStatAcct | Specifies the statistical budget account associated with the budget account to be used by the NonInterest Driver Based Growth calculation method. |
ForecastStatAcct | Specifies the statistical budget account associated with the forecast account to be used by the NonInterest Driver Based Growth calculation method. |
PoolType | The profitability pool type. |
RAROCBalanceSheet | The risk-adjusted return on capital balance sheet grouping. |
RAROCBalanceSheetOrder | The risk-adjusted return on capital balance sheet order number. |
Custom1-30 |
Optional custom columns that can be used by your institution, including assigning a preferred column name. NOTE: For details on editing custom columns, which is only available in the Axiom Windows Client at this time, see Column properties. |
NOTE: The table may display some columns that are related to other Kaufman Hall products or have been created specifically for your organization. Contact your Kaufman Hall Implementation Consultant or Kaufman Hall Support if you need help with these columns.