Composite Processing

Amend_Transaction

Amend_Transaction

This command can be used to amend ledger transactions of current workspace based on your matching criteria which determine ledger transaction(s) are subjected to effect relevant amendment(s).

Prerequisite Knowledge

Before learning how to use this command, users shall understand how to create a ledger with transactions by using commands “Import_Master” and “Import_Transaction“.

Command with Parameters

e.g. Amend_Transaction “C:\LB\Data2.xlsx” “d” “Analysis 1”

 

Note: Assuming first worksheet “Data2.xlsx” contains an amended transaction list where matched transactions for amendment are base on the following matching criteria:

  1. same ledger(s)
  2. same date(s) (same year, same month and same day)
  3. same analysis code(s) of Analysis 1

Source File Path

Specify full file path of an Excel Workbook which contains an amended transaction list in the first worksheet
e.g. C:\LB\Data2.xlsx

Matching Criteria

Specify any one of below matching criteria
e.g. d

y – matching year of transaction date
m – matching year and month of transaction date
d – matching year, month and day of transaction date

Matching Criteria

Specify a column header of the transaction list
e.g. Analysis 1

Matching Criteria (Optional)

Specify another column header of the transaction list
e.g. Currency

Consol_YTD_TB

Consol_YTD_TB

This command can be used to calculate monthly movement and relevant foreign currency translation based on your monthly year-to-date trial balance. Account balance and analysis account balance tables can be built for ledger(s) of current workspace automatically to support your preparation of consolidated financial statements with compliance of the standard  "IAS 21 - The Effects of Changes in Foreign Exchange Rates".

Prerequisite Knowledge

Before learning how to use this command, users shall understand how to use the commands "Import_Master" and "Import_Transaction". In addition, an understanding of the standard "IAS 21 - The Effects of Changes in Foreign Exchange Rates" can empower user to verify the processing results.

Command with Parameters

e.g. Consol_YTD_TB "C:\LB\Trial Balance.xlsx" "Data"  "C:\LB\Setting.xlsx"

 

Note: Prior to use this command, users shall use the command "Import_Master" to configure Ledger, Chart of Account, Analysis Category and Currency.

Source File Path

Specify full file path of an Excel Workbook which contains a month-end trial balance
e.g. C:\LB\Trial Balance.xlsx

Source Worksheet Name

Specify worksheet name of the source file which contains the trial balance
e.g. Data

Setting Worksheet Name

Specify full file path of an Excel Workbook which contains a worksheet "Parameter"

e.g. C:\LBSetting.xlsx

Note: Based on the above setting, the imported trial balance shall be included the column of "Analysis 1" "Analysis 2" to support relevant data amendment. In addition, users shall also learn how to implement analysis path for better performance when the number of analysis category is more than one type. Other default settings per row 1,2,4 are to support some of the exceptional requirements.

Relevant Case Study

Download the file IAS21.zip

Run_Spreadsheet_Formula

Run_Spreadsheet_Formula

This command can be used to run your business formulas with referring to a process table which contains a list of your combinations of business assumptions and values. A group of calculated transactions (or in term of double entry vouchers) can be generated and posting to single or multiple ledgers within your current workspace automatically.

Prerequisite Knowledge

Before learning how to use this command, users shall understand how to use the commands “Import_Master” and “Import_Transaction“.

Command with Parameters

e.g. Run_Spreadsheet_Formula “C:\LB\Model.xlsx” “N”

Source File Path

Specify full file path of an Excel Workbook which contains worksheet “LB_Voucher” and “LB_Process_Table”
e.g. C:\LB\Model.xlsx

Process Table Type

Specify type of process table
e.g. N – LB_Process_Table and its data shall be configured along with the same source file which contains a worksheet “LB_Voucher”

e.g. F “C:\LB\ProcessTable.xlsx” – LB_Process_Table and its data can be configured by a separate Excel Workbook from the original file given that the “LB_Process_Table” worksheet shall have at least one dummy record for each refer cell of “LB_Voucher” worksheet (i.e. 0)

Is Save Calculation Audit Trail (Optional)

e.g. Y

The audit trial of the calculation can be found on [Home Folder of Current Workspace]\data\attachment

 

Target File Path (Optional)

Specify full file path of an Excel Workbook to output transaction list without to import transactions
e.g. C:\LB\Validation.xlsx

Run_Spreadsheet_Formula_Background

Run_Spreadsheet_Formula_Background

This command can be used to run your business formulas with referring to a process table which contains a list of your combinations of business assumptions and values. A group of calculated transactions (or in term of double entry vouchers) can be generated and posting to single or multiple ledgers within your current workspace automatically.

Note: The system can proceed to run next command without waiting the process completion of this command.

Prerequisite Knowledge

Before learning how to use this command, users shall understand how to use the commands “Import_Master” and “Import_Transaction“.

Command with Parameters

e.g. Run_Spreadsheet_Formula “C:\LB\Model.xlsx” “N”

Source File Path

Specify full file path of an Excel Workbook which contains worksheet “LB_Voucher” and “LB_Process_Table”
e.g. C:\LB\Model.xlsx

Process Table Type

Specify type of process table
e.g. N – LB_Process_Table and its data shall be configured along with the same source file which contains a worksheet “LB_Voucher”

e.g. F “C:\LB\ProcessTable.xlsx” – LB_Process_Table and its data can be configured by a separate Excel Workbook from the original file given that the “LB_Process_Table” worksheet shall have at least one dummy record for each refer cell of “LB_Voucher” worksheet (i.e. 0)

Is Save Calculation Audit Trail (Optional)

e.g. Y

The audit trial of the calculation can be found on [Home Folder of Current Workspace]\data\attachment

 

Target File Path (Optional)

Specify full file path of an Excel Workbook to output transaction list without to import transactions
e.g. C:\LB\Validation.xlsx