Worksheet Name of Master File

Ledger

Compulsory Master;
Define Database Identification is a Minimum Requirement to Create a Ledger

Chart of Account

Optional Master;
Define it When You Implement Override Calculation Rules of Account or Register Name of Account

Analysis Category

Optional Master;
Define it When You Implement Multi-dimension Analysis

Currency

Optional Master;
Define it When You Implementation Foreign Currency Translation Functions

Column Name of Ledger Master

Ledger

Database Identification
e.g. A01

Name

Description of the Database Identification
e.g. ABC Company

Ledger Set

Register a Label to Implement Common Chart of Account, Analysis Category and Currency
e.g. White

Currency

Base Currency of the Ledger “A01”
e.g. HKD

P&L Account Range Start

Start Account for Transferring Yearly Closing Balance to a Retained Account
e.g. 60000000

P&L Account Range End

End Account for Transferring Yearly Closing Balance to a Retained Account
e.g. 99999999

Retained Earnings Account

Default Account to Book Balance Transferring by P&L Accounts
e.g. 51000000

Exchange Variation Account

Default Account to Book Exchange Difference by Certain Foreign Currency Functions
e.g. Analysis Project: 78000000

Period Offset

Declare First Period of a Year
e.g. 0 (Jan is the First Period), -3 (Apr is the First Period)

Ledger

Database Identification
e.g. A01

Account

Primary Classification of Transactions within Each Transaction Group
e.g. 28001560

Description

Description for Each Account
e.g. Account Receivable

Account Type

There are 4 Types of Account
e.g. B – Balance Sheet. P – Profit & Loss, D – Debtor, C – Creditor

Currency Revaluation

Define Whether to Book Adjustment by Foriegn Currency Revaluation Functions
e.g. Y or N

Retained Earnings Account

Default Account to Book Balance Transferring by P&L Accounts
e.g. 51000000

Control Account

Primary Classification of Transactions within Each Transaction Group
e.g. 28001560

Currency Rate Type

Define Override Exchange Rate Type
e.g. A – Average Rate, C – Closing Rate

Column Name of Analysis Category Master

Ledger

Database Identification
e.g. A01

Analysis Category

Define Analysis Category as New Column Name
e.g. Project

Analysis Code

Define Code List for Each Analysis Category
e.g. FDK1675 – An Analysis Code of the Analysis Project

Description

Define Description of an Analysis Code
e.g. Golden

Is Default

Define Whether to Enable Default Analysis Code Function
e.g. True or False

Column Name of Currency Master

Ledger

Database Identification
e.g. A01

Currency

Currency of Original Amount
e.g. USD

Description

Description for Each Currency
e.g. US Dollar

Period

Accounting Period
e.g. 01/2016

Rate

Define Exchange Rate for Each Combination of Currency, Period and Ledger
e.g. 7.8000