CLASS Function
The CLASS function links a ratio class balance from the accounting database to a cell in CaseView. Ratio class balances can be added together or one account subtracted from another. CaseView's linkage worksheet is the quickest way to link ratio class balances using the CLASS function. The exact syntax will be added automatically using the linkage worksheet.
Syntax
CLASS("Value","ratio class")
Where
The Value is the type of balance.
The ratio class represents the abbreviation for the ratio class referenced to accounts in the Working Trial Balance. The following table describes the available ratio classes and their descriptions:
Class |
Description |
TR |
Assets - Current - trade receivable |
QA |
Assets - Current - other quick |
IN |
Assets - Current - inventory |
CA |
Assets - Current – other |
FD |
Assets - Capital - amortized cost |
FN |
Assets - Capital non-amortized cost |
FA |
Assets - Capital - accumulated amortization |
IA |
Assets - Capital asset |
OA |
Assets - Other asset |
TP |
Liabilities - Current - trade payable |
CL |
Liabilities - Current - other |
LL |
Liabilities - Long term |
DI |
Equity – Dividend |
RE |
Equity - Retained earnings |
EQ |
Equity – Other |
SA |
Revenue - Credit sales |
SO |
Revenue - Other sales |
RO |
Revenue – Other |
CD |
Expense - cost of sales - amortization |
CN |
Expense - cost of sales - non-cash |
CI |
Expense - cost of sales - interest |
PU |
Expense - cost of sales - purchase |
CR |
Expense - cost of sales - repair and maintenance |
CS |
Expense - cost of sales - other cost of sales |
OD |
Expenses - other - amortization |
ON |
Expenses - other - non-cash |
IT |
Expenses - other - income tax expense |
OI |
Expenses - other - interest |
OR |
Expenses - other - repairs and maintenance |
OE |
Expenses - other - other expenses |
Example
CLASS("BA","CL")
Returns the current year to date balance plus normal adjustments of all accounts referenced to the Current Liabilities ratio.
Note
- In the Report tab, the print column is used to restrict the conditions under which the balance of an account can print or display. For example, selecting credit allows the account to print only if it is in a credit balance. When displaying balances, the CLASS function uses these options set in the report tab to determine whether to include or exclude a balance in the total calculation.