Chart of Accounts

Chart of Accounts is a basic table for financial accounting. Also often Chart of Accounts is adapted for management accounting, via adding of non-financial accounts to the Chart of Accounts, such as Number of Seasonally Close Rooms. It helps account and used unified approach to calculate management indicators such as RevPAR, ADR etc.

Chart of Accounts is related structure of List of Accounts and additional dictionaries called as Accounting Dimensions or Analytical Dimensions.

In the terms of financial accounting, value from List of Accounts is called as Synthetic Account, and values from other Analytical Dimension dictionaries are called as Analytical Accounts.

mUSALI proposes the following Accounting Dimensions:

  • Cost Centre, the same as Department/Business Function
  • Product

All accounts in financial transaction show as a single line of accounts: Account + Cost Centre + Product, if analytical accounts are applicable to the account.

Example of the transaction:

Account Cost Centre Product Amount
Dr 081211 Cost of Food Sales 1322 Main Kitchen 171 Fish 1000
Cr 024112 Inventory: Food 1322 Main Kitchen 171 Fish 1000

The table has the following columns:

ID and ParentID fields allows identifying row, and making tree from this table.

AccountNum field: Every account has own number. This is structured number. For example, all expenses start from 08, revenues start from 07. The structure of Chart of Accounts allows use of masks of accounts when we link report lines to accounts of Chart of accounts.

BusnFuncID is a reference to Department or Business Function in case if this account is departmental expense or departmental revenue, or departmental asset etc.

Product is indicator that the account is related to Products.

IsGroup means that this line is group of accounts.

AccGroup1..7 and AccountNum2 – code of groups that are parts of account code.

Prop1, Prop3 .. Prop7 – name of account groups

Prop2 – property if it is Debit or Credit Account