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.

Related Topics