What is Magic Auditor and How Can You Use It?


Magic Auditor is a real-time auditing tool, developed to compare accounting records in certain date ranges by comparison.


Route: ERP > Finance - Accounting > Audit > Magic Auditor


What is the Benchmark Block and how does it work?
The benchmark block consists of two opposing blocks. These blocks cumulate the debts or credits of multiple accounts between two dates. It finds the total value of the block by taking the percentage value entered in each block row. The same operation is applied in the second block and its total value is found in the second block. A rule is inserted to compare two blocks.

The benchmarking rules are as follows.

  • The defined % value of the total value of the first block must be equal to the sum of the second block.
  • The defined % value of the total value of the first block must be greater than the sum of the second block.
  • The defined % value of the total value of the first block must be less than the sum of the second block.
  • The defined % value of the total value of the first block must be greater-equal to the sum of the second block.
  • The defined % value of the total value of the first block must be less than-equal to the sum of the second block.

Definitions

  1. Chart of Accounts: The balance in the selected chart of accounts is taken.
  2. Transaction Type: The type of transaction recorded in the accounting is selected. For example, Wire Transfer filters record posted with the bank transfer transaction type in this chart of accounts.
  3. % - Percent: It is determined what percentage of the balance in the chart of accounts will be taken.
  4. Explanation: It is the description given to the line.
  5. Debt/Credit: Filters the debt or credit balance value.
  6. Cross-Block Benchmarking Criteria: >, <, =, >=, <= values and % percentage value are entered. Thus, the comparison measure of the first block with the second block is determined.
  7. 2. Block Chart of Accounts: The balance in the selected chart of accounts is taken.
  8. 2. Block Transaction Type: The transaction type for which the accounting entry is made is selected. For example, Wire Transfer filters record posted with the bank transfer transaction type in this chart of accounts.
  9. 2. Block % - Percentage: It is determined what percentage of the balance in the chart of accounts will be taken.
  10. 2. Block Description: It is the description given to the line.
  11. 2. Block Debt/Credit: Filters the debt or credit balance value.
  12. Transaction Day: It is determined which period and day it works.
  13. Workbook: It is determined which of the workbooks created by copying Uniform, IFRS, or Accounting spreadsheets will be used.

When the audit templates designed with Magic Auditor are run, benchmark results are produced as follows.


Multiple account blocks can be added to Magic Auditor. E.g; Wizards can be developed for different purposes such as monthly capital adequacy, ratio of short-term debts to receivables. A design recorded with Magic Auditor can be run by filtering between two dates, if desired. A report is generated when Magic Auditor runs. The user can archive the report.


Feedback

Did you find this content helpful?